[RSS Feed/News] proper way to update old ipb emoticons

[XenForo]

I'm fairly certain this is from IPB conversion some 15 years ago... I have many posts that look like this in the db:
Code:

text text text [IMG]style_emoticons/<#EMO_DIR#>/hmm.gif[/IMG]
text text

I was thinking I could do a simple update replace like:

Code:

UPDATE xf_post SET message = REPLACE(message,'[IMG]style_emoticons/<#EMO_DIR#>/','[IMG]styles/default/xenforo/smilies/');

but, looking at a modern post with xf emoticons, the raw bbcode like
Code:

:)
is stored...

Read more

ادامه مطلب...