• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Censor words database location

#1
Can you please tell me in which DB table the censor words are stored. I have a list and I'd like to put the whole lot in with an SQL statement rather than entering each one, one at a time.

Thanks
 

Jake Bunce

XenForo moderator
Staff member
#5
Specifically, it's the xf_data_registry table with data_key = options. That caches all of the options including the censored words. The source data is in the xf_option table with option_id = censorWords.
 
#6
Unfortunately I don't know enough SQL to cast the blob into text so I can add my profanity list and insert it back in in blob format. I guess it would be quicker to add the words one at a time. It might make me a bit more discriminating in my choice of swear and slur words.

Must remember to add lamo!

I'm a Mac boy too!