XF 2.1 Batch replace old emojis with EmojiOne

[Recep Baltaş]

Hi, I would like to retire my old emojis and replace them with the new EmojiOne ones.

e.g the one on the right has the old code in the background:

:aşk:

The one on the left:

:heart_eyes:



What should be my database querry to do that? Anything I should be careful about?

Thanks.

 

[Chris D]

We wouldn’t recommend doing this.

Firstly, the new emojis are not actually stored using that code. That are actually stored as the native emoji character e.g. 😍 so the replacement string would be that rather than :heart_eyes:.

Secondly, there’s little point in making potentially risky replacements. We’d just recommend unchecking the “Display in editor” option for the smilie.

It will continue to display as it is now, but users won’t be able to see it in the editor anymore.

 

[Recep Baltaş]

Even trying to disable some icons one after another tops the load on server and causes a MySQL crash with 2.1...