[nico_swd]

vB?

PHP Code:

$query = $db->query("SELECT * FROM ". TABLE_PREFIX ."avatar");

while ($avatar = $db->fetch_array($query))
{
    $db->query("
          UPDATE ". TABLE_PREFIX ."avatar
          SET avatarpath = '/forums/". $avatar['avatarpath']."'
          WHERE avatarid = ". $avatar['avatarid']
    );
} 


Untested but should work.

I don't think this is a good idea though. Don't you think that this might causes problems in the forum?