Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: [Double posting]: login with cpg 1.5 and vb 4.0.3  (Read 8136 times)

0 Members and 1 Guest are viewing this topic.

davidjmorin

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
[Double posting]: login with cpg 1.5 and vb 4.0.3
« 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: [Select]
<?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) ? 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;
}
?>

« Last Edit: May 30, 2010, 06:47:00 pm by Joachim Müller »
Logged

davidjmorin

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: login with cpg 1.5 and vb 4.0.3
« Reply #1 on: May 28, 2010, 08:18:07 pm »

does not login to the gallery when logged into the forum

what do i need to change?

here is my bridge file
Code: [Select]
<?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) ? 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;
}
?>




I edited the file as instructed on another thread with the _session
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: login with cpg 1.5 and vb 4.0.3
« Reply #2 on: May 30, 2010, 06:43:30 pm »

I edited the file as instructed on another thread with the _session
Post reference (i.e. a link) to the thread you're refering to.

Additionally, read up
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: login with cpg 1.5 and vb 4.0.3
« Reply #3 on: May 30, 2010, 06:45:52 pm »

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.
Logged
Pages: [1]   Go Up
 

Page created in 0.038 seconds with 19 queries.