Just deleted some spam registrations

Discuss, suggest and complain about the forum itself here.

Moderator: The00Dustin

Post Reply
User avatar
Site Admin
Posts: 537
Joined: 26 Apr 2005, 00:07
Location: Vienna, Austria

Just deleted some spam registrations

Post 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)
TorbenGB - webmaster & forum admin
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest