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.
