1. 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

Discussion in 'Troubleshooting and Problems' started by jamalfree, May 24, 2014.

  1. jamalfree

    jamalfree Active Member

    how can i run this querys

    UPDATE xf_post SET message replacemessage'[COLOR=darkslategray]''' ) ;
    UPDATE xf_post SET message replacemessage'[COLOR=deepskyblue]''' ) ;
    UPDATE xf_post SET message replacemessage'[COLOR=darkorange]''' ) ;
    UPDATE xf_post SET message replacemessage'[COLOR=red]''' ) ;
    UPDATE xf_post SET message replacemessage'[COLOR=Red]''' ) ;
    UPDATE xf_post SET message replacemessage'[COLOR=Navy]''' ) ;
    UPDATE xf_post SET message replacemessage'[COLOR=blue]''' ) ;
    UPDATE xf_post SET message replacemessage'[COLOR=#0000ff]''' ) ;
    UPDATE xf_post SET message replacemessage'[COLOR=orange]''' ) ;

    i runt it in my db but no changes

    i install this add on

    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
  2. Chris D

    Chris D XenForo Developer Staff Member

    The queries you posted above should work.

    I assume you may have this option enabled:
    (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:

    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']
    jamalfree likes this.

Share This Page