So random spam bots have joined my forum and spammed the orange out of it I have like 30k post in 1 forum and I need to get rid of it. I pruned the users but all it did was delete the users and leae their post behind. How may I get rid of the post quickly?
But how do I remove all the post? Here is my forum so you can see lostnationmc.com
(2013-09-15, 10:18 PM)Supersean Wrote: [ -> ]But how do I remove all the post? Here is my forum so you can see lostnationmc.com
You can do it by pruning the users along with their threads and posts.
All the users are deleted :/ but the post are there
Bump and one?
Akismet will block most of the spam, for the ones that occasionally leak you should have some handy staff members to obliterate the rouge posts
You made it hard for yourself now. Deleting the account doesn't delete the posts. If you had the account then you could have easily deleted all the posts. Anyways, go to PHPMyAdmin and run the following queries:
DELETE FROM `mybb_posts` WHERE `uid` = '0' AND `username` != 'Guest';
DELETE FROM `mybb_threads` WHERE `uid` = '0' AND `username` != 'Guest';
However be sure to create a backup of your board to be on the safe side.