Post: #1

Hello, i have this script but it doesnt fire when the bad word is sad alone for example if i say, " f*ck " - it doesnt trigger, but if i say- " f*ck that " it triggers as it should. Heres scp.


[SPEECH spk_player]
ON=*

if (!<isgm>)
local.ex=<explode \',<args>>
//local.ex=<explode \",<local.ex>>
db.query "SELECT `word` FROM `bad_words` WHERE ('<local.ex>' REGEXP `word`) = 1 LIMIT 0,1;"
if (<db.row.numrows>)
if !(<src.has_fun_events>)
src.sayua 00b00,0,0,0 I love you!
endif
if (<tag0.mat_count> < 5)
tag0.mat_count += 1
sysmessage @00b00 Abuse: <dtag.mat_count>
else
tag0.mat_count =
sysmessage @00b00 Punished, muted for 5 min
say @00b00 Punished: Abusive language
tag.mute=<serv.time>+300*10
tag.mute_t=1
endif
return 1
endif
endif

Post: #2

I recommend use LIST for this. Imagine many people talking. It will flood your mysql connection then will slow sphere...

Post: #3

sphere already have an internal engine for badword list, which is much more lightweight/fast than SQL
just add all badwords on [OBSCENE] section on spheretables.scp
and then you can check if someone said any badword using <eval IsObscene(<ARGS>)>

Post: #4

Ok Thanks Guys.

Corujas solution works like charm