Icy Phoenix :: View topic - FAP CUSTOMIZATION - Update pic

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: [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 ]------------------------------------------

Icy Phoenix

Archived phpBB Topics (Styles, Mods, Support) - FAP CUSTOMIZATION - Update pic_username when a user changes username