View Full Version : Delete mass users
khalled
12-10-2016, 03:37 AM
i have got spammed and i want delete mass of user with the same mails in one time , when i search user by mail i got result by all users i want to deleted , but it required to delete user one by one , is it any way to delete all user in one time
regards
MarkFL
12-10-2016, 04:35 AM
Perhaps you can isolate those users in the "Prune / Move Users" search?
khalled
12-10-2016, 07:09 AM
"Prune / Move Users" i can't filter users by mail , so i can't use this to isolate them
MarkFL
12-10-2016, 07:19 AM
You can order the results by email...and it might not be a simple 1 or 2 step process, but it shouldn't be too bad.
Or, what you can do is run a manual SQL query to mass move all users having a particular email into a special usergroup you create for this purpose:
UPDATE user
SET usergroupid = X
WHERE email LIKE '%@spam.com%'
Replace X with the usergroupid of the usergroup you are going to move all the users, and replace @spam.com with the text common to all the emails in question.
After the query, all the spammers will be in the same usergroup, and you can prune them by that group.
khalled
12-22-2016, 05:59 PM
very thanks , that is work good
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.