/cpgdbal/bridge/vbulletin30.inc.php

<?php

/*************************

  Coppermine Photo Gallery

  ************************

  Copyright (c) 2003-2008 Dev Team

  v1.1 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.0

  $HeadURL: https://coppermine.svn.sourceforge.net/svnroot/coppermine/trunk/cpg1.5.x/bridge/vbulletin30.inc.php $

  $Revision: 5129 $

  $LastChangedBy: gaugau $

  $Date: 2008-10-18 16:03:12 +0530 (Sat, 18 Oct 2008) $

**********************************************/



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;

            ###################       DB       #################

            global $CONFIG;

            $cpgdb =& cpgDB::getInstance();

            $cpgdb->connect_to_existing($CONFIG['LINK_ID']);

            ##########################################

    		

    		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']; */

            ##########################################            DB          #######################################

            $this->usertable = $cpgdb->getFullTableNames($this->db['name'], $this->db['prefix'], $this->table['users']);

            $this->groupstable = $cpgdb->getFullTableNames($this->db['name'], $this->db['prefix'], $this->table['groups']);

            $this->sessionstable = $cpgdb->getFullTableNames($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 = $this->use_post_based_groups ? 101 : 3;

    		

    		// 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()

    	{

            global $cpg_db_vbulletin30_inc;    ######    cpgdb_AL

    		$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;

    			} */

                #######################################          DB         #######################################

                $this->cpgudb->query($cpg_db_vbulletin30_inc['session_extraction'], $this->field['user_id'], $this->field['password'], 

                                    $this->field['grouptbl_group_id'], $this->usertable, $this->sessionstable, $session_id);



                $rowset = $this->cpgudb->fetchRowSet();

                if (count($rowset)) {

                    $row = $rowset[0];

                    return $row;

                } else {

                    return false;

                }

                #######################################################################################

    		}

    	}

    	

    	// Get groups of which user is member

    	function get_groups($row)

    	{

            global $cpg_db_vbulletin30_inc;    ######    cpgdb_AL

    		$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); */

                ########################################           DB         ########################################

                $this->cpgudb->query($cpg_db_vbulletin30_inc['get_groups'], $this->field['usertbl_group_id'], $this->usertable, 

                                    $this->groupstable, $thisfield['grouptbl_group_id'], $this->field['user_id'], $row['id']);



                $row = $this->cpgudb->fetchRow();

                ##########################################################################################

    			

    			$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;

}

?>