Censor words database location

Hackfall

Member
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
 

Hackfall

Member
Apologies for my speeeeelling in the title of this thread. Once I spotted it it was too late to change!
 

Lawrence

Well-known member
Fixed the typo. The censor word list is stored under options in the xf_data_registry. The data is stored as a blob.
 

Jake Bunce

XenForo moderator
Staff member
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.
 

Hackfall

Member
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!
 

DFI

Active member
Is there any simpler way to upload list of Bad words for censoring them ??

Experts , pls guide o_O
 

NetDoc

Member
Is there a list available in the admin console? It was easy on vBulletin, but I just can't seem to find it here.
 
Top