Saturday, January 15, 2005 2:13 PM bart

Fighting spam on my blog

Recently, I've received a bunch of spam on my blog. Luckily I'm maintaining the database of my blog myself, so I can make any changes I want in order to get rid of all this nonsense information. I found a really nice way to do this is by using triggers as explained on http://netnerds.net/articles/285.aspx. Using a separate table called "bannedwords" you can ban certain words in feedback posts (determined by @PostType = 3), like poker, mortgage and other well-known spam words.Del.icio.us | Digg It | Technorati | Blinklist | Furl | reddit | DotNetKicks

Filed under: ,

Comments

No Comments