vb.org Archive - username can not announce well without engilsh

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)

- - username can not announce well without engilsh (https://vborg.vbsupport.ru/showthread.php?t=184530)

dinosmart

07-06-2008 05:49 PM

username can not announce well without engilsh

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

07-06-2008 06:38 PM

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

07-07-2008 07:30 AM

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?

PHP Code:


		
			
        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

07-09-2008 09:02 PM

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

07-10-2008 05:13 AM

Tank you.

I have fix this problem by add some php code.

In arcade.php
ADD

PHP Code:


		
			
$sql_driver = FUNCTIONS_PATH . "dbclass.php";

In arcade/functions/dbclass.php
ADD

PHP Code:


		
			
 mysql_query("SET NAMES 'utf8';");

All times are GMT. The time now is 05:23 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01051 seconds Memory Usage 1,723KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: