Share via


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.