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

XF 1.3 how can i run this querys

jamalfree

Active member
#1
hello
how can i run this querys

PHP:
UPDATE xf_post SET message = replace( message, '[COLOR=darkslategray]', '' ) ;
UPDATE xf_post SET message = replace( message, '[COLOR=deepskyblue]', '' ) ;
UPDATE xf_post SET message = replace( message, '[COLOR=darkorange]', '' ) ;
UPDATE xf_post SET message = replace( message, '[COLOR=red]', '' ) ;
UPDATE xf_post SET message = replace( message, '[COLOR=Red]', '' ) ;
UPDATE xf_post SET message = replace( message, '[COLOR=Navy]', '' ) ;
UPDATE xf_post SET message = replace( message, '[COLOR=blue]', '' ) ;
UPDATE xf_post SET message = replace( message, '[COLOR=#0000ff]', '' ) ;
UPDATE xf_post SET message = replace( message, '[COLOR=orange]', '' ) ;

i runt it in my db but no changes

i install this add on

http://xenforo.com/community/resources/post-content-find-replace.1549/
but i dont know what i write in regular expression
for example first fied i write [COLOR = darkslategray ]
second i dont know
the third is empty that i wish
 

Chris D

XenForo developer
Staff member
#2
The queries you posted above should work.

I assume you may have this option enabled:
upload_2014-5-24_12-42-42.png
(In Admin CP > Options > Performance)

Turn that option off and the queries you ran should take effect.

You will want to deal with the [/COLOR] tags too, or you'll be left with something like this:
upload_2014-5-24_12-44-15.png

Also bear in mind it is case sensitive so you may also need to deal with [color] and [/color] as well as hex colours [COLOR='#0000ff']