Foren / Cotonti / Support / How to mass delete Banned members ?

Trustmaster
#31778 2. Dezember 2011, 16:44

Here is the code from system/core/users/users.edit.inc.php:

PHP
1
2
3
4
5
6
7
8
9
10
11
12
13
$sql = sed_sql_query("SELECT * FROM $db_users WHERE user_id='$id'");
 
            if ($row = sed_sql_fetchassoc($sql))
            {
                if ($cfg['trash_user'])
                { sed_trash_put('user', $L['User']." #".$id." ".$row['user_name'], $id, $row); }
                $sql = sed_sql_query("DELETE FROM $db_users WHERE user_id='$id'");
                $sql = sed_sql_query("DELETE FROM $db_groups_users WHERE gru_userid='$id'");
                if ($ruserdelpfs) { sed_pfs_deleteall($id); }
                sed_log("Deleted user #".$id,'adm');
                header("Location: " . SED_ABSOLUTE_URL . sed_url('message', "msg=109&rc=200&id=".$id, '', true));
                exit;
            }

What you need to change in your plugin is the main select query. Something like this:

SQL
1
SELECT * FROM $db_users AS u LEFT JOIN $db_users_groups AS g ON g.gru_userid = u.user_id WHERE g.gru_groupid = 3

And of course changed if to while and remove sed_log/header/exit lines from the loop.

May the Source be with you!