comment spam, comment spam, rolly polly comment spam

so here’s how i handle moderation of comment spam. i go into phpmyadmin. export my comments table. then i cut out the top block of sql code.


DROP TABLE IF EXISTS `wp_comments`;
CREATE TABLE `wp_comments` (
`comment_ID` bigint(20) unsigned NOT NULL auto_increment,
`comment_post_ID` int(11) NOT NULL default '0',
`comment_author` tinytext NOT NULL,
`comment_author_email` varchar(100) NOT NULL default '',
`comment_author_url` varchar(200) NOT NULL default '',
`comment_author_IP` varchar(100) NOT NULL default '',
`comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
`comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
`comment_content` text NOT NULL,
`comment_karma` int(11) NOT NULL default '0',
`comment_approved` enum('0','1','spam') NOT NULL default '1',
`user_id` int(11) NOT NULL default '0',
`comment_agent` varchar(255) NOT NULL default '',
`comment_type` varchar(20) NOT NULL default '',
`comment_parent` int(11) NOT NULL default '0',
PRIMARY KEY (`comment_ID`),
KEY `comment_approved` (`comment_approved`),
KEY `comment_post_ID` (`comment_post_ID`)
) TYPE=MyISAM AUTO_INCREMENT=1382 ;

#

  1. Dumping data for table `wp_comments`

#

then i copy out the first block or so that are older already approved comments. then i do a kind of visual scrolling scan for non-spam. it may not be perfect. but until i get more comments or the wordpress admin dashboard makes it easier for me to delete hundreds of spam comments at a time, that’s what i’m gonna do. so the chance of your hypothetical comment getting deleted is there, although its relatively small. if you do comment me for real and you’re a real person, you could also email me letting me know that your comment hasn’t gotten thru.

Advertisements