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.