Page 1 of 1

Just deleted some spam registrations

Posted: 07 Jul 2020, 20:42
by TorbenGB
Hi all,
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)