posted on Tuesday, November 02, 2004 10:20 AM
by
demiliani
Preventing .Text blog spam using SQL triggers
Last week on my Blog (and I've seen also on others) a bid discussion about blog spamming was started... I like a lot the CAPTCHA images solution to approve a comment, but it requires modifications to the .Text Blog Engine core.
Today I've see an interesting idea by Chrissy ... why not prevent the blog spamming using a SQL Trigger that search for special spam keywords and remove the post with them? Obviously, it's not the best solution but it could be a quick way to reduce spamming comments.
You can see the details of Chrissy ideas and the Trigger code HERE. If you're the admin of your .Text installation, this action requires only few minutes to be implemented and could be taken in considerations. 