Word Censor and Disallow Starter SQL Files

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Anti-Spam Guide
User avatar
durangod
Registered User
Posts: 804
Joined: Tue Nov 03, 2009 1:26 pm
Location: USA East Texas
Name: Dave

Word Censor and Disallow Starter SQL Files

Post by durangod »

If you want to set up word censoring and dont want start from scratch inputing words into the ACP. Here is a sql file you can import or run a sql command to get you a starter list, here is what i have so far. Feel free to add to it if needed.

Please noone take offense to the words on that list, i dont want to offend anyone. My intention is to help forums keep people from using these horrible words in their forums. I know its not much but its a start... :)

phpbb_words_insert.txt
Starter Disallow Usernames starter sql is in a following post below.

Thanks
You do not have the required permissions to view the files attached to this post.
Last edited by durangod on Fri Mar 01, 2024 11:45 am, edited 1 time in total.
Username is short for durango dave
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53514
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}

Re: Word Censor Starter SQL File

Post by Brf »

durangod wrote: Thu Feb 29, 2024 4:58 am My intention is to help forums keep people from using these horrible words in their forums.
The words censor does not prevent users from posting words. It prevents other users from seeing the words.
User avatar
durangod
Registered User
Posts: 804
Joined: Tue Nov 03, 2009 1:26 pm
Location: USA East Texas
Name: Dave

Re: Word Censor Starter SQL File

Post by durangod »

Brf wrote: Thu Feb 29, 2024 1:23 pm The words censor does not prevent users from posting words. It prevents other users from seeing the words.
Correct, i misspoke. Yes they can post the words at first but then it will be replaced during page view, thanks for the correction :)

Here is one for the disallow table (disallow usernames) as well if anyone wants to use it.

Please be sure your admins do not use any of those names before you add this.
phpbb_disallow_insert.txt
You do not have the required permissions to view the files attached to this post.
Username is short for durango dave
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 6209
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.

Re: Word Censor Starter SQL File

Post by thecoalman »

Also note under post settings there is a configuration for word censoring allowing the user to turn it on or off.

Allow disabling of word censoring:
You can also use wildcards, poop* will match poopsandwhich. Be careful with the wildcards because you can also match common words. Petcock for example is a word used on forum occasionally so a wild card for the slang term can't be used.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
User avatar
durangod
Registered User
Posts: 804
Joined: Tue Nov 03, 2009 1:26 pm
Location: USA East Texas
Name: Dave

Re: Word Censor Starter SQL File

Post by durangod »

@thecoalman great info... thanks :)

I suppose someone could write some js to catch the words in real time as they are being typed using the onChange event but that might create alot of false positives depending on the word spelling.
Username is short for durango dave

Return to “phpBB Discussion”