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

[rory2000]

HI,

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.

[rory2000]

HI,

Anyone any suggestions here ?

[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

[snakes1100]

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"