FAP CUSTOMIZATION - Update pic_username when a user changes username

The time now is Thu 04 Sep, 2025 17:55 • All times are UTC + 1 Hour [DST enabled]

FAP CUSTOMIZATION - Update pic_username when a user changes username

Page 1 of 1

lefty74

Joined: January 2007
Posts: 137

FAP CUSTOMIZATION - Update pic_username when a user changes username

I don't know whether it was intended to be like this but whenever a user changes his/her username, the pic_username of all their picture prior to the name change stays the same, i.e. when you do a search in the album on the username, it may not find all the pictures of that user... (Anyone know where else pic_username is used other then search?)

I did the following to update the pic_username whenever the user changes their username or an admin does...

It seems to be working but grateful if the more advanced coders could cast an eye over this

Cheers

Code: [Download] [Hide] [Select]

#

#-----[ OPEN ]------------------------------------------

#

includes/usercp_register.php

#

#-----[ FIND ]------------------------------------------

#

// We remove all stored login keys since the password has been updated

            // and change the current one (if applicable)

            if ( !empty($passwd_sql) )

#

#-----[ BEFORE, ADD ]------------------------------------------

#

$sql = "UPDATE " . ALBUM_TABLE . "

                SET pic_username = '" . str_replace("'", "''", $username) . "'

                WHERE " . ALBUM_TABLE . ".pic_user_id = $user_id";

            if ( !($result = $db->sql_query($sql)) )

            {

                message_die(GENERAL_ERROR, 'Could not update album table', '', __LINE__, __FILE__, $sql);

            }

#

#-----[ OPEN ]------------------------------------------

#

admin/admin_users.php

#

#-----[ FIND ]------------------------------------------

#

        //

        // Update entry in DB

        //

        if( !$error )

        {

#

#-----[ AFTER, ADD ]------------------------------------------

#

                $sql = "UPDATE " . ALBUM_TABLE . "

                SET pic_username = '" . str_replace("'", "''", $username) . "'

                WHERE " . ALBUM_TABLE . ".pic_user_id = $user_id";

            if ( !($result = $db->sql_query($sql)) )

            {

                message_die(GENERAL_ERROR, 'Could not update album table', '', __LINE__, __FILE__, $sql);

            }

#

#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------

____________
lefty74
www.zoocrew.eu - help us save our wildlife

#1 Mon 02 Apr, 2007 19:33

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Artie Joined: January 2007 Posts: 833 Location: Lone Star State	Re: Update pic_username when a user changes username Actually, I would have thought that pic_username would only be used for guests ... same as post_username is used. Evidently that is not the case, but perhaps it needs to be
#2 Wed 04 Apr, 2007 03:43

Page 1 of 1

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Thu 04 Sep, 2025 17:55 • All times are UTC + 1 Hour [DST enabled]

Permissions List

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

Icy Phoenix

FAP CUSTOMIZATION - Update pic_username when a user changes username

Was this topic useful?

Was this topic useful?