Article: How To Clean Up A Spammed Forum

I just finished writing this. Most of it is specific to vBulletin software, though the idea is the same for all forums. Just need to change queries and adjust similar settings for whatever software that you use.

Link: http://www.securefreak.com/how-to-clean-up-a-spammed-vbulletin-forum/

 

Updated it with a query to find all posts with a link in them, sorted by latest post.

PHP:

SELECT * FROM post WHERE pagetext LIKE '[URL=%' ORDER BY dateline DESC

 

Can't edit my post. The above query should be:

PHP:

SELECT * FROM post WHERE pagetext LIKE '[/url]' ORDER BY dateline DESC

 

Updated the blog with a script you can run to collect all links on your forum. It will print the domains so that you can paste them into vBSEO's nofollow blacklist.

 

What other social media icons do I need?