delete some spam from phpbb forum

------------------------------
SOURCE ARTICLE: How to clean forum/site from SPAM: <<<<<<<<<<<<<
http://tophostingforum.com/how-to-clean-forum-from-spam-ar-any-website-t1055.html
------------------------------


This mysql query may delete users, posts, topics containing phrasses (even partial):

'%zithrom%'
'%forex%'
'%treatment%'
'%diet%'
'%nutrition%'
'%chlamydia%'
'%cialis%'
'%prescription%'
'%Jelly%'
'%pharma%'
'%genuine%'
'%purchase%'
'%handbags%'
'%jerseys%'
'%Obama%'

I used this on my PHPBB forum which was overspammed. This is a dirty way to clean spammed forum and i dont recommend anyone to do it. I dont recommend anyone to execute this query because it may delete even important data. Always backup your mysql database first. Dont try it if you dont know what are following mysql commands doing. You are doing everything on your own risk.

DELETE FROM  `phpbb_posts` WHERE (`post_text` LIKE  '%zithrom%' OR `post_text` LIKE '%forex%' OR `post_text` LIKE '%treatment%' OR `post_text` LIKE '%diet%' OR `post_text` LIKE '%nutrition%' OR `post_text` LIKE '%chlamydia%' OR `post_text` LIKE '%cialis%' OR `post_text` LIKE '%prescription%' OR `post_text` LIKE '%Jelly%' OR `post_text` LIKE '%pharma%' OR `post_text` LIKE '%genuine%' OR `post_text` LIKE '%purchase%' OR `post_text` LIKE '%handbags%' OR `post_text` LIKE '%jerseys%' OR `post_text` LIKE '%Obama%') LIMIT 20000;
SELECT SLEEP(5);
DELETE FROM  `phpbb_topics` WHERE (`topic_title` LIKE  '%zithrom%' OR `topic_title` LIKE '%forex%' OR `topic_title` LIKE '%treatment%' OR `topic_title` LIKE '%diet%' OR `topic_title` LIKE '%nutrition%' OR `topic_title` LIKE '%chlamydia%' OR `topic_title` LIKE '%cialis%' OR `topic_title` LIKE '%prescription%' OR `topic_title` LIKE '%Jelly%' OR `topic_title` LIKE '%pharma%' OR `topic_title` LIKE '%genuine%' OR `topic_title` LIKE '%purchase%' OR `topic_title` LIKE '%handbags%' OR `topic_title` LIKE '%jerseys%' OR `topic_title` LIKE '%Obama%') LIMIT 20000;
SELECT SLEEP(5);
DELETE FROM  `phpbb_users` WHERE (`user_sig` LIKE  '%zithrom%' OR `user_sig` LIKE '%forex%' OR `user_sig` LIKE '%treatment%' OR `user_sig` LIKE '%diet%' OR `user_sig` LIKE '%nutrition%' OR `user_sig` LIKE '%chlamydia%' OR `user_sig` LIKE '%cialis%' OR `user_sig` LIKE '%prescription%' OR `user_sig` LIKE '%Jelly%' OR `user_sig` LIKE '%pharma%' OR `user_sig` LIKE '%genuine%' OR `user_sig` LIKE '%purchase%' OR `user_sig` LIKE '%handbags%' OR `user_sig` LIKE '%jerseys%' OR `user_sig` LIKE '%Obama%') LIMIT 20000;