Code: Select all
/**
* addPHPBBSessionInfo - Inserts the given session
* details into the phpbb_sessions table.
* Returns true on success, false otherwise.
*/
function addPHPBBSessionInfo($session_id, $session_user_id, $session_start, $session_time, $session_ip, $session_logged_in)
{
$session_ip = $this->encode_ip($session_ip);
$session_time = time();
$q = "INSERT INTO phpbb_database_name.phpbb_sessions VALUES ('$session_id', $session_user_id, $session_start, $session_time, '$session_ip', 0, $session_logged_in, 0)";
return mysql_query($q, $this->connection);
}
Code: Select all
function encode_ip($dotquad_ip)
{
$ip_sep = explode('.', $dotquad_ip);
return sprintf('%02x%02x%02x%02x', $ip_sep[0], $ip_sep[1], $ip_sep[2], $ip_sep[3]);
}
Code: Select all
$database->addPHPBBSessionInfo($_SESSION['sid'], $this->phpbb_user_id, $this->time, $this->time, $_SERVER['REMOTE_ADDR'], $this->logged_in);
Code: Select all
/**
* addPHPBBSessionInfo - Inserts the given session
* details into the phpbb_sessions table.
* Returns true on success, false otherwise.
*/
function addPHPBBSessionInfo($session_id, $session_user_id, $session_ip)
{
$session_ip = $this->encode_ip($session_ip);
$session_time = time();
$session_start = time();
$q = "INSERT INTO phpbb_database_name.phpbb_sessions VALUES ('$session_id', $session_user_id, $session_start, $session_time, '$session_ip', 0, 1, 0)";
return mysql_query($q);
}
Code: Select all
$sessionid->session_id();
$database->addPHPBBSessionInfo($sessionid, $this->phpbb_user_id, $_SERVER['REMOTE_ADDR']);
Code: Select all
<?php
$phpbb_root_path = './forums/';
define('IN_PHPBB', true);
//
// phpBB related files
//
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/bbcode.' . $phpEx);
//
// start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
if($userdata['session_logged_in'])
{
$db = mysql_connect(DB_SERVER, DB_USER, DB_PASS);
mysql_select_db(DB_NAME,$db);
$session->startSession();
$session->userinfo = $database->getUserInfo($userdata['username']);
$session->logged_in = 1;
$session->username = $_SESSION['username'] = $userdata['username'];
$session->userid = $_SESSION['userid'] = $session->userinfo['userid'];
$session->userlevel = $session->userinfo['userlevel'];
$session->time = $userdata['session_start'];
$database->updateUserField($session->username, "userid", $session->userid);
$database->addActiveUser($session->username, $session->time);
$database->removeActiveGuest($_SERVER['REMOTE_ADDR']);
}
$db = mysql_connect(DB_SERVER, DB_USER, DB_PASS);
mysql_select_db(DB_NAME,$db);
?>