forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 bridging => Topic started by: comrade on January 09, 2009, 07:18:36 pm

Title: [Solved]: user name shows as question marks
Post by: comrade on January 09, 2009, 07:18:36 pm

Hi
i just integrated the latest cpg with phpBB3. when i was running them separately, i could register users with russian letters in user id's and they displayed properly. after integration, i assume cpg ignores it's user database and rely on phpBB one. integration itself works fine, but after logging into the forum with userid in russian characters, it displayed as question marks in cpg, as well as question marks are in the galelry name i create, using this user id. Other then that everything works, i can upload files with russian names in them, etc. anyone had similar problems? I converted mySQL to utf8_unicode_ci collation, so both DB's are the same (i dont have to restart mySQL after that, do i?).

thanks

www.russianclubnyc.com/frm
www.russianclubnyc.com/gallery

Title: Re: user name shows as question marks
Post by: phill104 on January 09, 2009, 07:37:13 pm

Have you run charsetmgr.php?

Title: Re: user name shows as question marks
Post by: comrade on January 09, 2009, 08:21:39 pm

it converts cpg database, but after integration, user names are coming from phpBB database. thats what is not working.

Title: Re: user name shows as question marks
Post by: comrade on January 09, 2009, 11:44:52 pm

this worked, modified functions.inc.php

function cpg_db_connect()
{
        global $CONFIG;
        $result = @mysql_connect($CONFIG['dbserver'], $CONFIG['dbuser'], $CONFIG['dbpass']);
        if (!$result) {
                return false;
        }
        if (!mysql_select_db($CONFIG['dbname']))
                return false;
      mysql_query("SET NAMES 'utf8'",$result);
        return $result;
}