Damn Spammers
- 2004-12-03
- Trackback URL
- General
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)