Drupaltin with vBulletin on UTF8

[hjmaier]

Hello,

I just converted my forum to UTF8 and having lots of trouble with drupaltin.

With "normal" characters, there is no problem. But if you use special characters like ßüöä in username or password (esp. Password) drupaltin mixes it up. It is not possible to log into Drupal any more with that username or passworo.

Also if you change a password in the control center of the user. Passwords with those special characters are simply not copied correctly. I guess it is because of this routine:

PHP Code:

require_once(DIR . '/includes/drupaltin_config.php');


//*** Figure out the timezone settings and convert them to work in the Drupal vB
//    Divided by 3600 b/c the Drupal system.module timezone form is in seconds   
$vbulletin->GPC['timezoneoffset'] = intval($vbulletin->GPC['timezoneoffset']) * 3600;

## Connect to Drupal database and dump the values
$connector = new DbConnector();

$insertQuery = sprintf("INSERT INTO {$drup_prefix}users (
    uid, name, pass, mail, mode, sort, threshold, theme, signature, created, access, login,
     status, timezone, language, picture, init, data)
    VALUES ('%s', '%s', '%s', '%s', '0', '0', '0', '', '', '0', '0', '0', '1', '%s', '', '', '%s', 'a:0:{}')",
        mysql_real_escape_string($vbulletin->userinfo['userid']),
        mysql_real_escape_string($vbulletin->GPC['username']),
        mysql_real_escape_string($vbulletin->GPC['password_md5']),
        mysql_real_escape_string($vbulletin->GPC['email']),    
        mysql_real_escape_string($vbulletin->GPC['timezoneoffset']),
        mysql_real_escape_string($vbulletin->GPC['email']));

    ## Save the form data into the database
    if ($result = $connector->query($insertQuery)){

        ## It worked
        return;

    }else{

        ## It hasn't worked so stop. Better error handling code would be good here!
        exit;

    } 


I am not sure how to fix it but trying to solve it.

The problem should be: mysql_real_escape_string($vbulletin->GPC['password_md5'])
and mysql_real_escape_string($vbulletin->userinfo['userid']),

Does anybody has a clue?

Best regards
Hans-Joachim