this is just to make a note that I am doing a bit of housekeeping and clearing out the cobwebs.
I have jst deleted 232 registrations of spammers. Their posting attempts fail, as do most of their registration attempts, so it's just a handful that get that far at all. Let me know if you notice anything unruly. Thanks!
Note to self: The SQL used is along these lines:
Code: Select all
edit inline >
DELETE FROM `phpbb_users` where user_posts = 0 and ( user_regdate > 1457218800 or user_type = 1)