Posted by Shane Becker on
<p>so here's how i handle moderation of comment spam. i go into <a href="http://www.phpmyadmin.net/">phpmyadmin</a>. export my comments table. then i cut out the top block of sql code.</p>
<blockquote>
<code>
DROP TABLE IF EXISTS `wp_comments`;<br>
CREATE TABLE `wp_comments` (<br>
`comment_ID` bigint(20) unsigned NOT NULL auto_increment,<br>
`comment_post_ID` int(11) NOT NULL default '0',<br>
`comment_` tinytext NOT NULL,<br>
`comment__email` varchar(100) NOT NULL default '',<br>
`comment__url` varchar(200) NOT NULL default '',<br>
`comment__IP` varchar(100) NOT NULL default '',<br>
`comment_date` datetime NOT NULL default '0000-00-00 00:00:00',<br>
`comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',<br>
`comment_content` text NOT NULL,<br>
`comment_karma` int(11) NOT NULL default '0',<br>
`comment_approved` enum('0','1','spam') NOT NULL default '1',<br>
`user_id` int(11) NOT NULL default '0',<br>
`comment_agent` varchar(255) NOT NULL default '',<br>
`comment_type` varchar(20) NOT NULL default '',<br>
`comment_parent` int(11) NOT NULL default '0',<br>
PRIMARY KEY (`comment_ID`),<br>
KEY `comment_approved` (`comment_approved`),<br>
KEY `comment_post_ID` (`comment_post_ID`)<br>
) TYPE=MyISAM AUTO_INCREMENT=1382 ;<br>
<br>
#<br>
# Dumping data for table `wp_comments`<br>
#<br>
</code>
</blockquote>
<p>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 <a href="mailto:veganstraightedge@gmail.com">email me</a> letting me know that your comment hasn't gotten thru.</p>