PDA

View Full Version : Mass Delete Users


Liquid1ce
11-08-2006, 08:43 AM
Looking for a way to mass delete users with date of birth XXXX-XX-XX

Having problems with my forum with spam bots registering with a date of birth all the same but i would like to be able to mass delete all accounts with the date of birth i enter, does anyone have a way to do this.

Inferno Dragon
11-09-2006, 01:15 PM
I want the same option..I want to delete bots who register with a specific email "xxx@cashette.com" there are more then 60 users :( and deleting them one by one sux <_<

Liquid1ce
11-09-2006, 07:57 PM
i have the spam its a bot date of birth 03-28-1985

ive fixed it so they get blocked but theres accounts still there so need to delete them

CodeRed
11-28-2006, 01:43 AM
im also up for a mod like this... i have 200+ bot accounts id like to zap! hehee...

jluerken
11-28-2006, 06:57 AM
Create a new group and call it TRASH.
Remember the groupID.

Move the bots to this group and run a db query to delete them.
This should work but I've not tested it.

Before doing such things ALWAYS BACKUP YOUR DB.

netwind
12-07-2006, 01:41 PM
simple deleting from user not good. many tables has wasted associated records.
better way : create new group, update users primary group id (usergroupid),
by complex condition, then prune members of group from admincp.

SubstanceP
01-05-2007, 06:11 PM
simple deleting from user not good. many tables has wasted associated records.
better way : create new group, update users primary group id (usergroupid),
by complex condition, then prune members of group from admincp.

From the sidebar in the Admin CP, if you scroll down to Users (beneath attachments but above usergroups), there is a option called Prune / Move Users.

If you click on that, the screen allows you to select all users with filtering by:
Usergroup
Has not logged on for x days
Join Date is Before
Posts is less than #

It then gives you a list of all the users and each name has a checkbox that is already checked off. You can uncheck names or leave them all checked and at the bottom of the list, it allows you to either move the checked users to a usergroup or delete them. Would this accompish what some of you need without messing the database up? It is what I did so I hope it wasn't a bad idea.

Another thing I did to make life easier is I installed Access Permissions Based on User's Post Count (https://vborg.vbsupport.ru/showthread.php?t=96523)

Then you do not let members post in any forum except for intros or whatever forum you want to designate as a starting point. Now the member called FreeOnlineMags can only spam that one folder as a first post and that makes policing and cleaning up easier. You pay attention to intros since they definitely have to post there first. If you see something there, you just need to use the post count to determine if it's more than one. if it is more than one, you can pull up that person's threads and delete them as well. I find it easier than paying attention to the whole forum. I implemented that last spring and now most of our spam members register and don't bother with actually posting the spam since it's too easy for us to zap it fast.