find and replace in database

[kodode]

forse non è bellissimo però potresti fare un file con:

$sql=" SELECT * FROM `vespa_phpbb_users` ";

$result = mysql_query( $sql) or die( mysql_error() . "
" . $sql) ;

while( $valori= mysql_fetch_array( $rsINT ) ) {

         $user_avatar = $valori['user_avatar'];

         if(isset($user_avatar){
               if(substr($user_avatar, strlen($user_avatar)-3, strlen($user_avatar)) == "gif" || substr($user_avatar, strlen($user_avatar)-3, strlen($user_avatar)) == "jpg" ){
                      $user_avatar = "images/avatar/".$user_avatar ;
               }
               if(substr($user_avatar, 0, 8 ) == "personal" ){
                      $user_avatar = "images/avatar/".$user_avatar ;
               }
         }
         
         $sqlUpdate = "UPDATE `vespa_phpbb_users`SET user_avatar = ".$user_avatar." WHERE user_id = ".$valori['user_id'];

mysql_query( $sqlUpdate );

} 

provala