Web developers notes,programming tutorials.

The current DrupalVB Module 5.x-1.1. It has the following bug. The dual login for login in the user in vbulletin when they login in the drupal is not working.

Before the line 

 return;

in the function “_drupalvb_set_login_cookies” in the script drupal/modules/drupalvb/drupalvb.inc.php

 Add the following code

$idhash = md5($_SERVER[’HTTP_USER_AGENT’] . fetch_substr_ip($_SERVER[’REMOTE_ADDR’]));

  $result = db_query(_drupalvb_prefix(”REPLACE INTO {session} (sessionhash, userid, host, idhash, ”
                    .”lastactivity, location, useragent, styleid, languageid, loggedin, ”
                    .”inforum, inthread, incalendar, badlocation, bypass, profileupdate) VALUES ”
                    .”(’”.md5(’drupalvb’ . $userid).”‘, ‘”.$userid.”‘, ‘”.$_SERVER[’REMOTE_ADDR’].”‘, ‘”.$idhash.”‘, ”
                    .”‘”.time().”‘, ‘index.php’, ‘”.$_SERVER[HTTP_USER_AGENT].”‘, 0, 0, 1, 0, 0, 0, 0, 0, 0  )”));
 

Then add this function at the end of the script drupalvb.inc.php of the drupalvb module of drupal

function fetch_substr_ip($ip, $length = null)
{
 if ($length === null OR $length > 3)
 {
  $length = 1;
 }
 return implode(’.', array_slice(explode(’.', $ip), 0, 4 - $length));
}

Then remove the following line in the function drupalvb_user_login() in the script drupal/modules/drupalvb/drupalvb.module

$userinfo = db_fetch_array($result);

This entry was posted on Thursday, March 13th, 2008 at 6:09 pm and is filed under drupal custom changes, Beginners Php / Php Novices. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.