Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 23 Aug 2019, 10:17
rory2000 rory2000 is offline
Join Date: Jan 2012
Real name: Rory
Bulk Deleting of spam accounts / submit to Spam-O-Matic


Lots of spam regestrations, i want to search for them easily, which i can do via search for users, but then i have to delete one by one, clearly i want to bulk delete them all and any post, message etc so they are total removed.

Also what would be much better to help the community is to select all and submit to Spam-O-Matic so their details are shared in a database to stop them posting on other forums.

Can anyone help me with this ? Any suggestions..

Thanks in advance.
Reply With Quote
Old 28 Sep 2019, 10:48
rory2000 rory2000 is offline
Join Date: Jan 2012
Real name: Rory

Anyone any suggestions here ?
Reply With Quote
Old 08 Nov 2019, 15:29
fdifranco fdifranco is offline
Join Date: Feb 2010
How I Bulk Deleted Spam Users and Messages

Hi Rory,

This may not be the best way to do it (due to database referential integrity) but it seemed to work for me.

From CPanel, I went in to phpMyAdmin and executed the following two SQL delete commands:

delete FROM `post` WHERE userid > 2000
delete FROM `user` WHERE userid > 2000

All of the spam userid's on my site had a value higher than 2000 so that's why I used 2000. You should look at the vBulletin 'user' table to see where the spam accounts start for you.

Warning: This is a sledgehammer. It will delete indiscriminately but like I said earlier, it worked for me and took about 10 seconds to delete hundreds of spam users and ten's of thousands of spam posts.

If it messes up my forums then I don't care too much since I really only use vBulletin for the CMS.

Hope that helps, and if not then I at least hope it spurs someone else to offer a better solution.

Reply With Quote
Old 09 Nov 2019, 10:28
snakes1100 snakes1100 is offline
Join Date: Dec 2001
Real name: Anthony
Do NOT delete accounts as suggested above, this doesnt completely remove a users account.

Use the "User Moving/Pruning System" on the action selection use "delete"
Reply With Quote

Similar Threads
Thread Thread Starter Forum Replies Last Post
Anti-Spam Options [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam vBulletin 4.x Add-ons 3490 29 Jul 2019 19:11

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 20:37.

Layout Options | Width: Wide Color: