Emojis in game chat

Members can make suggestions for improving the site and improving the forum as well as submit bug reports to be reviewed by our support team here.
Post Reply
Message
Author
alamothe
Bronze Donator
Bronze Donator
Posts: 2
Joined: Fri Jul 05, 2019 1:05 pm
Contact:

Emojis in game chat

#1 Post by alamothe » Thu Oct 03, 2019 10:16 pm

Game chat does not support emojis! How are we supposed to negotiate a difficult situation?

User avatar
dargorygel
Site Moderator
Site Moderator
Posts: 6682
Joined: Mon Dec 18, 2017 1:55 pm
Location: Over the rainbow
Contact:

Re: Emojis in game chat

#2 Post by dargorygel » Fri Oct 04, 2019 12:04 am

The old school way... : - )

bunp
Posts: 16
Joined: Mon Oct 15, 2018 4:28 pm
Contact:

Re: Emojis in game chat

#3 Post by bunp » Mon Oct 07, 2019 7:57 pm

I find :^) has an ~80% chance to instantly sour negotiations when used but I just can't help myself.

Restitution
Posts: 225
Joined: Thu Jan 31, 2019 7:00 am
Contact:

Re: Emojis in game chat

#4 Post by Restitution » Mon Oct 07, 2019 8:26 pm

))<>((

Foldemort
Posts: 1
Joined: Thu Sep 12, 2019 11:41 pm
Contact:

Re: Emojis in game chat

#5 Post by Foldemort » Wed Oct 09, 2019 9:25 am

8=======D (an army tank with a long cannon)

tobieee911
Silver Donator
Silver Donator
Posts: 293
Joined: Sun Jun 10, 2018 8:43 pm
Location: The netherlands
Contact:

Re: Emojis in game chat

#6 Post by tobieee911 » Wed Oct 09, 2019 9:32 am

lol

e.m.c^42
Posts: 6320
Joined: Thu Jan 11, 2018 7:00 pm
Location: Rated 0/5 Stars; ☆☆☆☆☆
Contact:

Re: Emojis in game chat

#7 Post by e.m.c^42 » Wed Oct 09, 2019 12:23 pm

You don't need those pesky round emojis.

look at all this passion and sheer emotion conveyed between these two countries:

?!!
(ノ°Д°)ノ︵ ┻━┻

___________

:/
___________

(;⌣̀_⌣́)
___________

:P
___________

-_-
___________

;)
___________

(凸ಠ益ಠ)︻デ═== ✴

A_Tin_Can
Lifetime Site Contributor
Posts: 283
Joined: Fri Sep 29, 2017 9:18 pm
Contact:

Re: Emojis in game chat

#8 Post by A_Tin_Can » Sun Aug 23, 2020 7:38 am

I think this is just because of the character set on the database and DB table used to store the messages. Something like this would probably work to fix it: https://stackoverflow.com/questions/394 ... l-database

A_Tin_Can
Lifetime Site Contributor
Posts: 283
Joined: Fri Sep 29, 2017 9:18 pm
Contact:

Re: Emojis in game chat

#9 Post by A_Tin_Can » Sun Aug 23, 2020 7:39 am

As a workaround, you can just write out "eggplant" as necessary.

Peregrine Falcon
Site Contributor
Site Contributor
Posts: 245
Joined: Tue Mar 14, 2017 8:44 pm
Contact:

Re: Emojis in game chat

#10 Post by Peregrine Falcon » Sun Aug 23, 2020 2:34 pm

It's actually worse than just not having emojis display properly. They actually completely break off the message being posted—only the text before the emoji makes it into the db.

Most webDip tables, particularly the wd_gamemessages table, are set to utf8. They should really be converted to the standard collation utf8mb4_0900_ai_ci. (Due to a weird and annoying quirk of MySQL naming, the utf8 character set is not actually utf-8-compliant. The newer utf8mb4 set is what's actually needed... /facepalm_emoji)

That said, when I made the change on my test server, emojis were no longer cutting off the message, which is good, but still were only showing as ???? and I'm not sure why.

A_Tin_Can
Lifetime Site Contributor
Posts: 283
Joined: Fri Sep 29, 2017 9:18 pm
Contact:

Re: Emojis in game chat

#11 Post by A_Tin_Can » Sun Aug 23, 2020 3:21 pm

There are a few places you might need to put it - take a look at eg: https://www.toptal.com/php/a-utf-8-prim ... -and-mysql

Peregrine Falcon
Site Contributor
Site Contributor
Posts: 245
Joined: Tue Mar 14, 2017 8:44 pm
Contact:

Re: Emojis in game chat

#12 Post by Peregrine Falcon » Sun Aug 23, 2020 6:21 pm

Oh lol I just hadn't looked closely enough at the db connection before and missed where it specified the encoding.

The table encoding just needs to be converted to utf8mb4 in mySQL, then database.php has to change set names from utf8 to utf8mb4 on line 118.

That made the full unicode display properly on my test server.

Claesar
Posts: 1965
Joined: Tue Oct 03, 2017 10:34 am
Contact:

Re: Emojis in game chat

#13 Post by Claesar » Sun Aug 23, 2020 7:10 pm

Viaduct

Post Reply

Who is online

Users browsing this forum: No registered users