How to filter curse words from discussion board?

[zhao790]

There is one discussion board on our web site to let users submit their question freely but we want set up a language fileter to detect/avoid some unnecessary words such as curse words. How to do it? Are there any language filter software on the market?

[mndrx]

if the board is in asp:

make an extra table in your db: tblCurseWords with 2 fields:
CurseWord and ReplacingWord

Then, take a look at the scripts of your board, and find the place where the form-inputfield is passed to your database.

In most cases there is already some manipulation there (htmlencode, or replacing eol's with <br>, etc.)

At this place, lets say your formfield is called TextField, and it is put into strTextField (example: strTextField=request.form("TextField") ), if you found this place, after this you do your own manipulation:

dim ObjConn,rsCurseWords,strSQL

set Objconn = Server.CreateObject("ADODB.Connection") 'if connection not already open
Objconn.open "...." 'idem
set rsCursedWords = Server.CreateObject("ADODB.Recordset")
strSQL="select * from TblCurseWords;"
rsCurseWords.open strSQL,Objconn

while not rsCurseWords.EOF
replace(StrTextField,rsCurseWords("CurseWord"),rsC urseWords("ReplacingWord"))
rsCurseWords.MoveNext
wend

rsCurseWords.close
set rsCursWords = nothing
ObjConn.close
set ObjConn = nothing



Something like this
bye,
mndrx