username can not announce well without engilsh

[dinosmart]

I had installed the ibProArcade for vBulletin 2.6.7.
And my vBulletin version is 3.6.8. (Traditional Chinese)
The code is UTF-8.

Everythings seems fine.
No problem in playing game or saving the score.

but the username can not announce well without engilsh.
The chinese ID or other particular words will be transformed like this => " ???? "

May someone help me to solve this problem?
thanks very much.
:)

[Talaturen]

I believe that is happening because this plugin is ignoring the MySQL charset you have specified in config, have a look at this thread: https://vborg.vbsupport.ru/showthread.php?t=182891.

[dinosmart]

excuse me sir.

thanks for your reply. But I don't understand very well.

By your thread https://vborg.vbsupport.ru/showthread.php?t=182891

Are you mean that I should use this code to fix this problem?

if (!empty($charset))
{
if (function_exists('mysql_set_charset'))
mysql_set_charset($charset);
else
$this->query("SET NAMES $charset");
}

But I don't know that where should I put this code.

I am very sorry. I am a green hand about that.

Could you explain more clearly?

thank you:)

[Talaturen]

If you add that you would have to read the charset variable from the config file too. A simple and temporary method to solve this would be to add this in connection part:
mysql_set_charset("latin1");

In my forums latin1 is working fine, but if you're using another charset then just change latin1 to whatever charset you use.

[dinosmart]

Tank you.

I have fix this problem by add some php code.

In arcade.php
ADD
$sql_driver = FUNCTIONS_PATH . "dbclass.php";

In arcade/functions/dbclass.php
ADD
mysql_query("SET NAMES 'utf8';");

:)