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

Change mass smilie path

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

Brogan

XenForo moderator
Staff member
#2
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.
 
#4
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)