How to remove spam threads and posts
 

In the past several months one of our forums was him with allot of spammers and they generated tons of posts and threads and we are trying to clean all of them out of the database. What is the best way to delete/prune spam threads

Sometimes the best to way to mass delete threads is to just pull up the relevant threads in a search window (either user by user, or with the new posts option) or go forum by forum, and check all the spam threads/posts in the moderator column. Delete or move as you see fit. Another way is to use the prune/delete threads option in the Admin CP. Really, it's just a matter of what is more convenient for you. When the number of posts gets particularly large, there's just no getting around the more tedious aspects of picking out the spam posts.

Another option I often use is in the spam poster's account in the Admin CP. There's an option there to delete all his posts. You should run this, though, before deleting his account if you intend to do so, as his posts will all revert to Guest and they're won't be a good way of finding those posts anymore. This can seem tedious, too. But it's a little more precise and a bit quicker than eyeballing the posts yourself.

The best way, IMO, is to select multiple spam threads/posts then use "Delete threads/posts as spam". After that you have options to delete all posts and threads started by those users, and even ban the users.

Hope it helps

Hi

I am not able to Delete using Moderation due to SPAM posts count is 48000

Server is going down and nothing im able to delete please advise

You can search on vBulletin.org, there is a Mod to do this and you just need a click to delete thousands of spam posts on your forum in seconds. I could not remember the name of the plugin.