Killing comment spam
Is there a .TEXT utility to let me kill all comments that have a specific URL in them? I've been getting hit with comment spam recently...
Comments
- Anonymous
July 18, 2004
We all have :( I sent mail to Betsy with the offending comment IP address. Fortunately I didn't have that many posts to clean out. - Anonymous
July 18, 2004
If you ask that question, I presume that you don't have access to the SQL Server hosting your blog, do you? Because if you do have access, I think it's just a matter of doing something like:
delete from blog_content where PostType = 3 and Text like '%<your specific URL>%' - Anonymous
July 18, 2004
The comment has been removed - Anonymous
July 18, 2004
Here's an idea ... how about some sort of .Text plug-in that automatically runs SpamBayes (http://spambayes.sourceforge.net) on blog entries? THAT would be pretty cool... - Anonymous
July 20, 2004
The comment has been removed - Anonymous
July 21, 2004
The comment has been removed - Anonymous
December 18, 2004
Helpful For MBA Fans.