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

    hello
    how can i run this querys

    PHP:
    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

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

    Chris D XenForo Developer Staff Member

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

Share This Page