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

Smiley paths need updating after import

CyclingTribe

Well-known member
#1
I've noticed that some posts contain references to the old URL for smilies so need a query to update them in the POST table please ...

Old path:
Code:
http://img.cyclechat.co.uk/public/style_emoticons/default/biggrin.gif
New path:
Code:
http://img.cyclechat.co.uk/styles/default/xenforo/smilies/biggrin.gif
I'd rather someone with the proper know-how volunteered a query than hazard a guess and fudge it all up ... :eek:
 

Brogan

XenForo moderator
Staff member
#2
Code:
UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
So for that it would be:
Code:
UPDATE xf_post SET message = REPLACE(message,'http://img.cyclechat.co.uk/public/style_emoticons/default/','http://img.cyclechat.co.uk/styles/default/xenforo/smilies/');
Take a backup first though.