Batch deleting Users: How to?

[Adan0s]

Hey,

I recently scanned my userdatabase for mailadresses known used by spammers. I ended up with like 500 accounts.
Now I want to delete those accs, but I certainly don't want to do it for each one of them via the adminpanel.
I could of course just delete those users from the users-table but there is a huge load if information split over dozens of tables of an user (see class_dm_user.php function delete).

Unfortunately I don't really know how to build the object which is then passed to that function. So, if someone please could point me how to build the array and use that function, so I can delete those 500 datazombies?

thank you.

[Retal]

Hey there,
if you haven't solved it yet, I took this out of the admincp/user.php, section "kill", so this is the official process

PHP Code:

$info = fetch_userinfo($vbulletin->GPC['userid']);
if (!$info)
{
    print_stop_message('invalid_user_specified');
}

if ($vbulletin->GPC['transfer_groups'])
{
    // fetch groupmember info for groups that the deleted user has ownership of
    $sgmember_query = $vbulletin->db->query("
        SELECT socialgroup.groupid AS sgroupid, sgmember.*
        FROM " . TABLE_PREFIX . "socialgroup AS socialgroup
        LEFT JOIN " . TABLE_PREFIX . "socialgroupmember AS sgmember
        ON sgmember.groupid = socialgroup.groupid
        AND sgmember.userid = " . $vbulletin->userinfo['userid'] . "
        WHERE creatoruserid = " . $vbulletin->GPC['userid'] . "
    ");

    if ($vbulletin->db->num_rows($sgmember_query))
    {
        while ($sgmember = $vbulletin->db->fetch_array($sgmember_query))
        {
            // ensure the current user is a full member of the group
            if ($sgmember['type'] != 'member')
            {
                $socialgroupmemberdm = datamanager_init('SocialGroupMember', $vbulletin);

                if ($sgmember['userid'])
                {
                    $socialgroupmemberdm->set_existing($sgmember);
                }

                $socialgroupmemberdm->set('userid', $vbulletin->userinfo['userid']);
                $socialgroupmemberdm->set('groupid', $sgmember['sgroupid']);
                $socialgroupmemberdm->set('dateline', TIMENOW);
                $socialgroupmemberdm->set('type', 'member');

                $socialgroupmemberdm->save();
            }
        }
        $vbulletin->db->free_result($sgmember_query);

        // transfer all of the groups to the current user
        $vbulletin->db->query_write("
            UPDATE " . TABLE_PREFIX . "socialgroup
            SET creatoruserid = " . $vbulletin->userinfo['userid'] . ",
                transferowner = 0
            WHERE creatoruserid = " . $vbulletin->GPC['userid'] . "
        ");
    }
}

$userdm =& datamanager_init('User', $vbulletin, ERRTYPE_CP);
$userdm->set_existing($info);
$userdm->delete();
unset($userdm); 


[Adan0s]

Thanks, but I already solved it.

For the people who are interested in it:

PHP Code:

<?php
error_reporting(E_ALL & ~E_NOTICE);

require_once('./global.php');
require_once('/includes/adminfunctions_profilefield.php');
require_once('/includes/adminfunctions_user.php');

        $ids = array(1234,1235); 
foreach($ids as $id)
{
    $info = fetch_userinfo($id);
    if (!$info)
    {
        echo $id.'fail<br />';
    }
    else
    {
        $userdm =& datamanager_init('User', $vbulletin, ERRTYPE_CP);
        $userdm->set_existing($info);
        $userdm->delete();
        unset($userdm); 
        echo $id.'okay<br />';
    }
    unset($info);
}
?>

This deletes the member and all information connected to it. The posts and threads are still there, but those are simple to delete by two sql statements.