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

XF 1.4 Find/Replace in Phrases

#1
I need to replace the word "Resource" with "Story" throughout all the Resource Manager phrases.

Ideally, I'd like to do this with a find/replace type MySQL query (to avoid editing the phrases individually through the admin panel).

I looked at the database and saw two two tables that look relevant. They're named xf_phrase_compiled and xf_phrase.

Which table is the correct one on which to run the query? Or does the fact the phrases are compiled mean I can't update this correctly by running a query on the database?

Or is there an easier way built in that I've completely overlooked?

Any help is greatly appreciated!