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

Change mass smilie path

Discussion in 'XenForo Questions and Support' started by TazDevilLooney, Aug 7, 2011.

  1. TazDevilLooney

    TazDevilLooney Active Member

    Hi does any one know of a MYSQL way of changing the smilies paths i have over 100.

    In the database my current smilies path is
    images/smilies/animated/a01.gif
    I would like to change them to
    http://othersite.com/images/smilies/animated/a01.gif

    Any thoughts or is there an easer way i have missed?

    Cheres.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    To replace post content you can run this query.

    UPDATE xf_post SET message = REPLACE(message, 'old_path', 'new_path')

    Just replace old_path and new_path as necessary.

    Take a backup first though, just in case.
     
    TazDevilLooney likes this.
  3. TazDevilLooney

    TazDevilLooney Active Member

    Error : 1146 - Table 'forum.xf_post' doesn't exist

    0 row(s) affected. ( Query took 0.9003 sec )

    UPDATE xf_post SET message = REPLACE(message, 'images/smilies/animated/', 'http://othersite.com/images/smilies/animated/')

    Any idears :rolleyes:
     
  4. TazDevilLooney

    TazDevilLooney Active Member

    I got it! My dum fault i was looking at the wrong database.

    UPDATE xf_post SET message = REPLACE(message, '/styles/default/xenforo/smilies/', 'http://other.com/styles/default/xenforo/smilies/')

    Al sorted thanks Brogan. (y)
     

Share This Page