[Raptor]

AFter a lot of pruing etc i found that my USER table had 33799 rows but my userfield table ahd 134,786 rows. Now we had deleted 3 years worth of zero posters to get these figures - but what about the bloated userfield db ?

i'm sure VB should have prined this up auto - well if it does it didnt in this case - and i doubt it could do it faster than this script.

The script checks that the userid in userfield table exists in user table. If it doesnt it deletes it.

After 30 seconds I have 33799 User and 33799 userfield

heres the code - maybe of some use to someone ?

PHP Code:

<?php

$link = mysql_connect("dbserver", "database", "password");
mysql_select_db("dforums");

set_time_limit(300000000);

$foundresult = mysql_query("select * from userfield order by userid asc");
$foundnum = mysql_num_rows($foundresult);

echo("Deleting obsolete UserID entries from userfield...<br>\r\n");

for ($i=0;$i<$foundnum;$i++)
{
    $row = mysql_fetch_array($foundresult);
    $huntId = $row["userid"];
    
    // now lookup user
    $huntresult = mysql_query("select * from user where userid='$huntId'");
    $huntnum = mysql_num_rows($huntresult);
    
    if ($huntnum == 0)
    {
        echo("Deleting: $huntId<br>\r\n");
        mysql_query("delete from userfield where userid='$huntId'");
    }
}

mysql_close();
?>