Support > cpg1.5 bridging
[Double posting]: login with cpg 1.5 and vb 4.0.3
(1/1)
davidjmorin:
does not login to the gallery when logged into the forum
what do i need to change?
here is my bridge file
--- Code: ---<?php
/*************************
Coppermine Photo Gallery
************************
Copyright (c) 2003-2010 Coppermine Dev Team
v1.0 originally written by Gregory Demar
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License version 3
as published by the Free Software Foundation.
********************************************
Coppermine version: 1.5.3
$HeadURL: https://coppermine.svn.sourceforge.net/svnroot/coppermine/trunk/cpg1.5.x/bridge/vbulletin30.inc.php $
$Revision: 6985 $
$LastChangedBy: gaugau $
$Date: 2010-01-02 11:38:29 +0100 (Sa, 02. Jan 2010) $
**********************************************/
if (!defined('IN_COPPERMINE')) die('Not in Coppermine...');
if (isset($bridge_lookup)) {
$default_bridge_data[$bridge_lookup] = array(
'full_name' => 'vBulletin 3.0',
'short_name' => 'vbulletin30',
'support_url' => 'http://www.vbulletin.com/',
'full_forum_url_default' => 'http://www.yoursite.com/board',
'full_forum_url_used' => 'mandatory,not_empty,no_trailing_slash',
'relative_path_to_config_file_default' => '../board/',
'relative_path_to_config_file_used' => 'lookfor,includes/config.php',
'use_post_based_groups_default' => '0',
'use_post_based_groups_used' => 'radio,1,0',
);
} else {
// Switch that allows overriding the bridge manager with hard-coded values
define('USE_BRIDGEMGR', 1);
require_once 'bridge/udb_base.inc.php';
class cpg_udb extends core_udb {
function cpg_udb()
{
global $BRIDGE;
if (!USE_BRIDGEMGR) {
$this->boardurl = 'http://www.yousite.com/vb3';
require_once('../vb3/includes/config.php');
} else {
$this->boardurl = $BRIDGE['full_forum_url'];
require_once($BRIDGE['relative_path_to_config_file'] . 'includes/config.php');
$this->use_post_based_groups = $BRIDGE['use_post_based_groups'];
}
$this->multigroups = 1;
// Database connection settings
if (isset($config['Database']['dbname']))
{
// Running on vBulletin 3.5.x
$this->db = array(
'name' => $config['Database']['dbname'],
'host' => $config['MasterServer']['servername'] ? $config['MasterServer']['servername'] : 'localhost',
'user' => $config['MasterServer']['username'],
'password' => $config['MasterServer']['password'],
'prefix' => $config['Database']['tableprefix']
);
} else {
// Running on vBulletin 3.0.x
$this->db = array(
'name' => $dbname,
'host' => $servername ? $servername : 'localhost',
'user' => $dbusername,
'password' => $dbpassword,
'prefix' =>$tableprefix
);
}
// Board table names
$this->table = array(
'users' => 'user',
'groups' => 'usergroup',
'sessions' => 'session'
);
// Derived full table names
$this->usertable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['users'];
$this->groupstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups'];
$this->sessionstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['sessions'];
// Table field names
$this->field = array(
'username' => 'username', // name of 'username' field in users table
'user_id' => 'userid', // name of 'id' field in users table
'password' => 'password', // name of 'password' field in users table
'email' => 'email', // name of 'email' field in users table
'regdate' => 'joindate', // name of 'registered' field in users table
'location' => "''", // name of 'location' field in users table
'website' => 'homepage', // name of 'website' field in users table
'usertbl_group_id' => 'usergroupid', // name of 'group id' field in users table
'grouptbl_group_id' => 'usergroupid', // name of 'group id' field in groups table
'grouptbl_group_name' => 'title' // name of 'group name' field in groups table
);
// Pages to redirect to
$this->page = array(
'register' => '/register.php',
'editusers' => '/memberlist.php',
'edituserprofile' => "/member.php?u=",
);
// Group ids - admin and guest only.
$this->admingroups = array(6);
$this->guestgroup = 1;
// Use a special function to collect groups for cpg groups table
$this->group_overrride = 0;
// Cookie settings - used in following functions only
if (isset($config['Misc']['cookieprefix']))
{
// get cookieprefix from vb3.5.x
$this->cookie_name = $config['Misc']['cookieprefix'];
} else {
// get cookieprefix from vb3.0.x
$this->cookie_name = $cookieprefix;
}
// Connect to db
$this->connect();
}
// definition of how to extract id, name, group from a session cookie
function session_extraction()
{
$superCage = Inspekt::makeSuperCage();
//if (isset($_COOKIE[$this->cookie_name . '_sessionhash'])) {
// $session_id = addslashes($_COOKIE[$this->cookie_name . '_sessionhash']);
if ($superCage->cookie->keyExists($this->cookie_name . 'sessionhash')) {
$session_id = $superCage->cookie->getEscaped($this->cookie_name . 'sessionhash');
$sql = "SELECT u.{$this->field['user_id']}, u.{$this->field['password']}, u.{$this->field['grouptbl_group_id']}+100 AS usergroupid FROM {$this->usertable} AS u, {$this->sessionstable} AS s WHERE s.{$this->field['user_id']}=u.{$this->field['user_id']} AND s.sessionhash='$session_id'";
$result = cpg_db_query($sql, $this->link_id);
if (mysql_num_rows($result)){
$row = mysql_fetch_array($result);
return $row;
} else {
return false;
}
}
}
// Get groups of which user is member
function get_groups($row)
{
$data[0] = in_array($row['group_id'] - 100, $this->admingroups) ? 1 : 2;
if ($this->use_post_based_groups){
$sql = "SELECT g.{$this->field['usertbl_group_id']}+100 AS group_id, u.* FROM {$this->usertable} AS u, {$this->groupstable} as g WHERE g.{$this->field['grouptbl_group_id']} = u.{$this->field['usertbl_group_id']} AND u.{$this->field['user_id']} = '{$row['id']}'";
$result = cpg_db_query($sql, $this->link_id);
$row = mysql_fetch_array($result);
$data[0] = $row['group_id'];
if ($row['membergroupids']){
$groups = explode(',', $row['membergroupids']);
foreach ($groups as $id => $group){
$data[] = $group+100;
}
}
}
return $data;
}
// definition of how to extract an id and password hash from a cookie
function cookie_extraction()
{
return false;
}
// definition of actions required to convert a password from user database form to cookie form
function udb_hash_db($password)
{
return $password; // unused
}
function login_page()
{
$this->redirect("/index.php");
}
function logout_page()
{
$this->redirect("/login.php?do=logout&u=".USER_ID);
}
}
// and go !
$cpg_udb = new cpg_udb;
}
?>
--- End code ---
davidjmorin:
--- Quote from: davidjmorin on May 28, 2010, 08:17:21 pm ---does not login to the gallery when logged into the forum
what do i need to change?
here is my bridge file
--- Code: ---<?php
/*************************
Coppermine Photo Gallery
************************
Copyright (c) 2003-2010 Coppermine Dev Team
v1.0 originally written by Gregory Demar
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License version 3
as published by the Free Software Foundation.
********************************************
Coppermine version: 1.5.3
$HeadURL: https://coppermine.svn.sourceforge.net/svnroot/coppermine/trunk/cpg1.5.x/bridge/vbulletin30.inc.php $
$Revision: 6985 $
$LastChangedBy: gaugau $
$Date: 2010-01-02 11:38:29 +0100 (Sa, 02. Jan 2010) $
**********************************************/
if (!defined('IN_COPPERMINE')) die('Not in Coppermine...');
if (isset($bridge_lookup)) {
$default_bridge_data[$bridge_lookup] = array(
'full_name' => 'vBulletin 3.0',
'short_name' => 'vbulletin30',
'support_url' => 'http://www.vbulletin.com/',
'full_forum_url_default' => 'http://www.yoursite.com/board',
'full_forum_url_used' => 'mandatory,not_empty,no_trailing_slash',
'relative_path_to_config_file_default' => '../board/',
'relative_path_to_config_file_used' => 'lookfor,includes/config.php',
'use_post_based_groups_default' => '0',
'use_post_based_groups_used' => 'radio,1,0',
);
} else {
// Switch that allows overriding the bridge manager with hard-coded values
define('USE_BRIDGEMGR', 1);
require_once 'bridge/udb_base.inc.php';
class cpg_udb extends core_udb {
function cpg_udb()
{
global $BRIDGE;
if (!USE_BRIDGEMGR) {
$this->boardurl = 'http://www.yousite.com/vb3';
require_once('../vb3/includes/config.php');
} else {
$this->boardurl = $BRIDGE['full_forum_url'];
require_once($BRIDGE['relative_path_to_config_file'] . 'includes/config.php');
$this->use_post_based_groups = $BRIDGE['use_post_based_groups'];
}
$this->multigroups = 1;
// Database connection settings
if (isset($config['Database']['dbname']))
{
// Running on vBulletin 3.5.x
$this->db = array(
'name' => $config['Database']['dbname'],
'host' => $config['MasterServer']['servername'] ? $config['MasterServer']['servername'] : 'localhost',
'user' => $config['MasterServer']['username'],
'password' => $config['MasterServer']['password'],
'prefix' => $config['Database']['tableprefix']
);
} else {
// Running on vBulletin 3.0.x
$this->db = array(
'name' => $dbname,
'host' => $servername ? $servername : 'localhost',
'user' => $dbusername,
'password' => $dbpassword,
'prefix' =>$tableprefix
);
}
// Board table names
$this->table = array(
'users' => 'user',
'groups' => 'usergroup',
'sessions' => 'session'
);
// Derived full table names
$this->usertable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['users'];
$this->groupstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['groups'];
$this->sessionstable = '`' . $this->db['name'] . '`.' . $this->db['prefix'] . $this->table['sessions'];
// Table field names
$this->field = array(
'username' => 'username', // name of 'username' field in users table
'user_id' => 'userid', // name of 'id' field in users table
'password' => 'password', // name of 'password' field in users table
'email' => 'email', // name of 'email' field in users table
'regdate' => 'joindate', // name of 'registered' field in users table
'location' => "''", // name of 'location' field in users table
'website' => 'homepage', // name of 'website' field in users table
'usertbl_group_id' => 'usergroupid', // name of 'group id' field in users table
'grouptbl_group_id' => 'usergroupid', // name of 'group id' field in groups table
'grouptbl_group_name' => 'title' // name of 'group name' field in groups table
);
// Pages to redirect to
$this->page = array(
'register' => '/register.php',
'editusers' => '/memberlist.php',
'edituserprofile' => "/member.php?u=",
);
// Group ids - admin and guest only.
$this->admingroups = array(6);
$this->guestgroup = 1;
// Use a special function to collect groups for cpg groups table
$this->group_overrride = 0;
// Cookie settings - used in following functions only
if (isset($config['Misc']['cookieprefix']))
{
// get cookieprefix from vb3.5.x
$this->cookie_name = $config['Misc']['cookieprefix'];
} else {
// get cookieprefix from vb3.0.x
$this->cookie_name = $cookieprefix;
}
// Connect to db
$this->connect();
}
// definition of how to extract id, name, group from a session cookie
function session_extraction()
{
$superCage = Inspekt::makeSuperCage();
//if (isset($_COOKIE[$this->cookie_name . '_sessionhash'])) {
// $session_id = addslashes($_COOKIE[$this->cookie_name . '_sessionhash']);
if ($superCage->cookie->keyExists($this->cookie_name . 'sessionhash')) {
$session_id = $superCage->cookie->getEscaped($this->cookie_name . 'sessionhash');
$sql = "SELECT u.{$this->field['user_id']}, u.{$this->field['password']}, u.{$this->field['grouptbl_group_id']}+100 AS usergroupid FROM {$this->usertable} AS u, {$this->sessionstable} AS s WHERE s.{$this->field['user_id']}=u.{$this->field['user_id']} AND s.sessionhash='$session_id'";
$result = cpg_db_query($sql, $this->link_id);
if (mysql_num_rows($result)){
$row = mysql_fetch_array($result);
return $row;
} else {
return false;
}
}
}
// Get groups of which user is member
function get_groups($row)
{
$data[0] = in_array($row['group_id'] - 100, $this->admingroups) ? 1 : 2;
if ($this->use_post_based_groups){
$sql = "SELECT g.{$this->field['usertbl_group_id']}+100 AS group_id, u.* FROM {$this->usertable} AS u, {$this->groupstable} as g WHERE g.{$this->field['grouptbl_group_id']} = u.{$this->field['usertbl_group_id']} AND u.{$this->field['user_id']} = '{$row['id']}'";
$result = cpg_db_query($sql, $this->link_id);
$row = mysql_fetch_array($result);
$data[0] = $row['group_id'];
if ($row['membergroupids']){
$groups = explode(',', $row['membergroupids']);
foreach ($groups as $id => $group){
$data[] = $group+100;
}
}
}
return $data;
}
// definition of how to extract an id and password hash from a cookie
function cookie_extraction()
{
return false;
}
// definition of actions required to convert a password from user database form to cookie form
function udb_hash_db($password)
{
return $password; // unused
}
function login_page()
{
$this->redirect("/index.php");
}
function logout_page()
{
$this->redirect("/login.php?do=logout&u=".USER_ID);
}
}
// and go !
$cpg_udb = new cpg_udb;
}
?>
--- End code ---
--- End quote ---
I edited the file as instructed on another thread with the _session
Joachim Müller:
--- Quote from: davidjmorin on May 28, 2010, 08:18:07 pm ---I edited the file as instructed on another thread with the _session
--- End quote ---
Post reference (i.e. a link) to the thread you're refering to.
Additionally, read up
* Board rules / Forum policies: Post Links
* Documentation: Bridging support
* Sticky thread: When requesting bridge support - must read!
Joachim Müller:
You have another open thread about the same issue - I didn't notice that when I posted above. Thanks for not causing double moderation effort in the future. Locking and marking thread accordingly.
Navigation
[0] Message Index
Go to full version