sql querys to delete a member in vbulletin

[mlee]

Just in case someone else needs this in the future:

PHP Code:

$user = $DB_site->query_first("
            SELECT userid, username, avatarrevision
            FROM " . TABLE_PREFIX . "user
            WHERE userid = $userid
");

$DB_site->query("
            UPDATE " . TABLE_PREFIX . "post
            SET username = '" . addslashes($user['username']) . "',
            userid = 0
            WHERE userid = $userid
        ");

$DB_site->query("
            UPDATE " . TABLE_PREFIX . "usernote
            SET username = '" . addslashes($user['username']) . "',
            posterid = 0
            WHERE posterid = $userid
        ");

$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "usernote
            WHERE userid = $userid
        ");

$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "user
            WHERE userid = $userid
        ");

$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "userfield
            WHERE userid = $userid
        ");

$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "usertextfield
            WHERE userid = $userid
        ");

$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "access
            WHERE userid = $userid
        ");

$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "event
            WHERE userid = $userid
        ");

$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "customavatar
            WHERE userid = $userid
        ");
        

$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "customprofilepic
            WHERE userid = $userid
        ");
        
$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "moderator
            WHERE userid = $userid
        ");
        
$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "subscribeforum
            WHERE userid = $userid
        ");
        
$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "subscribethread
            WHERE userid = $userid
        ");
        
$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "subscriptionlog
            WHERE userid = $userid
        ");
        
$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "session
            WHERE userid = $userid
        ");
        
$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "userban
            WHERE userid = $userid
        ");
        
$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "administrator
            WHERE userid = $userid
        ");
        
$DB_site->query("
            DELETE FROM " . TABLE_PREFIX . "usergrouprequest
            WHERE userid = $userid
        ");

$DB_site->query("DELETE FROM " . TABLE_PREFIX . "pmreceipt WHERE userid = $userid");

$DB_site->query("DELETE FROM " . TABLE_PREFIX . "pm WHERE userid = $userid"); 


[merk]

You can use the datamanager to do all of that. (the queries you posted is still not a complete list )

init a datamanager then use set_existing() then use delete().

[mlee]

Originally Posted by merk

You can use the datamanager to do all of that. (the queries you posted is still not a complete list )

init a datamanager then use set_existing() then use delete().

And again:
"Im writing an import script to use vbulletin usersdatabase together with an other cms thats why i can not use any vbulletin functions.

OR in other words:
I need to write my own script to safty delete vbulletins user.

Thats the complete liste except the deletion of the pms and the update of the forums data.

[merk]

Did you delete the users avatar or profile picture from the filesystem if it existed?

Even if you cant use the function, there is a complete list of operations that needs to be completed in the function i referenced.

[mlee]

Originally Posted by merk

Did you delete the users avatar or profile picture from the filesystem if it existed?

Even if you cant use the function, there is a complete list of operations that needs to be completed in the function i referenced.

Yes, I saw where they where unlinked but since they use the userid as a part of the file name i thought it is not necessary to delete them.