SQL TO CLEAN UP PHPBB SPAM

This will get you most of the way through deletion of spam entries in your PHPBB TABLE... (replace ez_ with the prefix you use for your PHPBB.)

Delete from ez_posts_text where post_text like '%Proxy%' OR post_text like '%radiospace%' OR post_text like '%ringtonesring%' OR post_text like '%credit-card%' OR post_text like '%sourcerecipes%' OR post_text like '%diamonds-source%' or post_text like '%valtrex%' OR post_text like '%poker%' OR post_text like '%real estate%' OR post_text like '%ultram%' OR post_text like '%cialis%' OR post_text like '%cheap%' OR post_text like '%dating%' OR post_text like '%furniture%' OR POST_TEXT LIKE '%unishop.info%'; -- Select * from ez_posts_text ;