My first AntiSpam Countermeasure...

I've just dedicated 30 minutes of my evening to adopt my first countermeasure against Spamming on my Blog.

The solution I've adopted for the moment is the SQL method suggested me by John Sample (check my previous post). I've create an antispam table under my .Text database and I've alter the blog_InsertEntry stored procedure. Now when someone inserts a comment on my Blog, the stored procedure checks if some words on the comment are blacklisted and, if so, the post is rejected, otherwise the post is accepted.

For the moment it seems to work good... I've inserted a good amount of spam words on my antispam table and I'll continue to insert new words when they're discovered... spam fantasy is unlimited and unpredictable!

Print | posted on Tuesday, January 11, 2005 11:27 PM

Comments on this post

# re: My first AntiSpam Countermeasure...

Requesting Gravatar...
Invece che modificare una stored di .TEXT, ti consiglio di aggiungere un trigger alla tabella. Così non dovresti avere problemi n caso di aggiornamento di versione.
Left by Andrea Boschin on Jan 11, 2005 9:33 PM

# re: My first AntiSpam Countermeasure...

Requesting Gravatar...
Si probabilmente hai ragione, ma diciamo che questa è una soluzione temporanea in attesa del tuo controllino )
Left by Stefano Demiliani on Jan 11, 2005 9:50 PM

# re: My first AntiSpam Countermeasure...

Requesting Gravatar...
I'm observing some submitting and notification problems and I've to test...
Left by Stefano Demiliani on Jan 12, 2005 7:24 AM

Your comment:

 (will show your gravatar)
 
Please add 7 and 7 and type the answer here: