Damn Spammers

Arg… Kendra was right: I got spammed. Well, I did manage to figure out how to connect directly to the MySQL database and delete the necessary rows from the necessary tables. Interesting stuff:

mysql> delete from wp_comments where comment_author like "%poker%";
Query OK, 854 rows affected (0.08 sec)

mysql> delete from wp_comments where comment_author like "%gambling%";
Query OK, 36 rows affected (0.05 sec)

mysql> delete from wp_comments where comment_author like "%roulette%";
Query OK, 36 rows affected (0.05 sec)

mysql> delete from wp_comments where comment_author like "%casino%";
Query OK, 169 rows affected (0.06 sec)

mysql> delete from wp_comments where comment_author like "%texas%";
Query OK, 176 rows affected (0.06 sec)

mysql> delete from wp_comments where comment_author like "%online%";
Query OK, 16 rows affected (0.04 sec)

mysql> delete from wp_comments where comment_author like "%debt%";
Query OK, 7 rows affected (0.05 sec)

mysql> delete from wp_comments where comment_author like "%phentermine%";
Query OK, 6 rows affected (0.05 sec)

mysql> delete from wp_comments where comment_author like "%blackjack%";
Query OK, 24 rows affected (0.05 sec)

mysql> delete from wp_comments where comment_author like "%wsop%";
Query OK, 22 rows affected (0.05 sec)

mysql> delete from wp_comments where comment_author like "%WPT%";
Query OK, 19 rows affected (0.05 sec)

mysql> delete from wp_comments where comment_author like "%forex%";
Query OK, 2 rows affected (0.05 sec)

Post a Comment

Your E-mail will never published nor shared. Notice that the required fields are marked *...

*

*

Type your comment out: