Smiley paths need updating after import

[CTXMedia]

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:

http://img.cyclechat.co.uk/public/style_emoticons/default/biggrin.gif

New path:

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

 

[Paul B]

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

So for that it would be:

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.

 

[CTXMedia]

Thanks again ... maaaannnnn you're quick!!!

[Edit: I had to take this part out of the query (for the two instances where it is shown): http://img.cyclechat.net/ ]