This should remove the
Ff prefix for all avatars:
PHP Code:
<?php
error_reporting(E_ALL & ~E_NOTICE);
define('NO_REGISTER_GLOBALS', 1);
require_once('./global.php');
$avs = $DB_site->query("
SELECT *
FROM ".TABLE_PREFIX."avatar
WHERE title like 'Ff%'
");
while($av = $DB_site->fetch_array($avs))
{
$newavname = substr($av['title'], 2);
$DB_site->query("
UPDATE ".TABLE_PREFIX."avatar
SET title = '".addslashes($newavname)."'
WHERE avatarid = $av[avatarid]
");
}
echo 'DONE';
?>