function sp_remove_membership($usergroup_id, $user_id) { spdb_query('DELETE FROM ' . SFMEMBERSHIPS . " WHERE user_id={$user_id} AND usergroup_id={$usergroup_id}"); # reset auths and memberships for added user sp_reset_memberships($user_id); sp_reset_auths($user_id); sp_update_member_moderator_flag($user_id); return true; }
} } } } if ($action == 'del') { check_admin_referer('forum-adminform_memberdel', 'forum-adminform_memberdel'); $usergroup_id = sp_esc_int($_GET['usergroupid']); $new_usergroup_id = $_GET['usergroup_id']; if (isset($_GET['dmid'])) { $user_id_list = array_unique($_GET['dmid']); } # make sure not moving to same user group if (!isset($user_id_list) || $usergroup_id == $new_usergroup_id) { die; } for ($x = $startNum; $x < $startNum + $batchNum; $x++) { if (isset($user_id_list[$x])) { $user_id = sp_esc_int($user_id_list[$x]); $success = spdb_query('DELETE FROM ' . SFMEMBERSHIPS . " WHERE user_id={$user_id} AND usergroup_id={$usergroup_id}"); if ($new_usergroup_id != -1) { $success = sp_add_membership($new_usergroup_id, $user_id); } # reset auths and memberships for added user sp_reset_memberships($user_id); sp_reset_auths($user_id); # update mod flag sp_update_member_moderator_flag($user_id); } } } die;