XF 2.2 IPB 3 issue and emoji did not convert, [emoji512]

[beerForo]

So starting in IPB 3, importing to XF 1.5, and upgrading to XF 2.2, I have thousands of emoji bbcode.
[emoji512] (birthday cake)
I have thousands of these, all different numbers. In IPB they are emoji. Not sure how they became bbcode. How can I fix these?

 

[beerForo]

Okayyyyy I figured it out. These emoji were inserted by tapatalk users. The list is here:

Emojis - for copying/pasting into posts

Emojis - for copying/pasting into posts

forums.dansdeals.com

Now how the heck would you fix the db to replace the ones used. Example:
Replace:
[emoji512]
with:

 

[beerForo]

Looks like those "emoji" are hosted images at tapatalk so it's probably a lost cause at this point. A lot of work to replace the bbcode with the img codes.

Or could a query use the actual emoji as replacement?

 

[Jeremy P]

You would have to map the numbers in the [emoji] code to their corresponding unicode characters. It doesn't seem like they follow a scheme that makes this straightforward, so you'd probably have to enumerate them all to create the map manually. With 1000s of characters, that's probably just not worth it.