Bots and Spam

I killed about 3000 spam comments on my stories with a single SQL statement. Beware any spammer from considering spamming me again.
delete FROM `gl_comments` WHERE 1
delete FROM `gl_storysubmission` WHERE 1
UPDATE `gl_stories` SET comments = 0 WHERE 1
DELETE FROM `gl_users` WHERE uid > 50


Also disabling comments worked wonders.

Leave a Reply