Welcome to MSDN Blogs Sign in | Join | Help

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...
Published Sunday, July 18, 2004 8:39 AM by ericgu

Comments

Sunday, July 18, 2004 9:45 AM by Larry Osterman

# re: Killing comment spam

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.
Sunday, July 18, 2004 10:43 AM by David Brabant

# re: Killing comment spam

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>%'
Sunday, July 18, 2004 12:28 PM by Morten Isaksen

# re: Killing comment spam

It is not exatly what you are looking for. But i have created a RBL system where you can blacklist comment spammers. Check http://www.aub.dk/~misak/index.php?p=17

Sunday, July 18, 2004 3:43 PM by Michael Carr

# re: Killing comment spam

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...
Tuesday, July 20, 2004 8:40 AM by Luke Hutteman

# re: Killing comment spam

Bayesian filtering won't work for comment-spam because, unlike email-spammers, comment-spammers are not interested in people clicking on links, but want their google ranking to be increased. This means they can copy any existing comment and repost it using their own url, which would pass right through a bayesian filter.

You need to filter based on the payload, i.e. the URLs in the comment. For Movable Type, MT-BlackList does a great job at this. Don't know if .Text has anything similar. If it does, the master MT-BlackList blacklist is public, so that can be used as a great starting point of URLs to block.
Wednesday, July 21, 2004 7:12 PM by Shaun F

# re: Killing comment spam

Another idea could be...
If comment spam is there mainly for spammers to increase their google rank, would a url redirector work in eliminating their url appearing.

Along with that you could capture all urls in a comment and store them in a db with an index. that way you could then remove all offending links in one location.
An upshot of that could also be an easy way to black list urls based on whatever method..

Tuesday, July 27, 2004 4:45 PM by Mark Brown

# Comment Spam and Blacklisting

Saturday, December 18, 2004 10:57 AM by MBA

# MBA

Helpful For MBA Fans.
New Comments to this post are disabled
 
Page view tracker