Cleanup SPAM users in PHPBB2

December 5th, 2008 | by RoarinPenguin |

Once you have access to DB, the SQL string is:

DELETE FROM phpbb_users WHERE user_active=0 AND user_id>0

This will cleanup all the users marked as non active, thus most likely spam.

Post a Comment