vBulletin 4 Request - Bulk Deleting of spam accounts / submit to Spam-O-Matic

[fdifranco]

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.

-fab