{

var $cookie_data = array();

var $page = array();

var $data = array();

var $browser = '';

var $forwarded_for = '';

var $host = '';

var $session_id = '';

var $ip = '';

var $load = 0;

var $time_now = 0;

var $update_session_page = true;

/**

static function extract_current_page($root_path)

{

global $request, $symfony_request;

$page_array = array();

// First of all, get the request uri...

$script_name = $request->escape($symfony_request->getScriptName(), true);

$args = $request->escape(explode('&', $symfony_request->getQueryString()), true);

// If we are unable to get the script name we use REQUEST_URI as a failover and note it within the page array for easier support...

if (!$script_name)

{

$script_name = htmlspecialchars_decode($request->server('REQUEST_URI'));

$script_name = (($pos = strpos($script_name, '?')) !== false) ? substr($script_name, 0, $pos) : $script_name;

$page_array['failover'] = 1;

}

// Replace backslashes and doubled slashes (could happen on some proxy setups)

$script_name = str_replace(array('\\', '//'), '/', $script_name);

// Now, remove the sid and let us get a clean query string...

$use_args = array();

// Since some browser do not encode correctly we need to do this with some "special" characters...

// " -> %22, ' => %27, < -> %3C, > -> %3E

$find = array('"', "'", '<', '>', '&quot;', '&lt;', '&gt;');

$replace = array('%22', '%27', '%3C', '%3E', '%22', '%3C', '%3E');

foreach ($args as $key => $argument)

{

if (strpos($argument, 'sid=') === 0)

{

continue;

}

$use_args[] = str_replace($find, $replace, $argument);

}

unset($args);

// The following examples given are for an request uri of {path to the phpbb directory}/adm/index.php?i=10&b=2

// The current query string

$query_string = trim(implode('&', $use_args));

// basenamed page name (for example: index.php)

$page_name = (substr($script_name, -1, 1) == '/') ? '' : basename($script_name);

$page_name = urlencode(htmlspecialchars($page_name));

$symfony_request_path = filesystem_helper::clean_path($symfony_request->getPathInfo());

if ($symfony_request_path !== '/')

{

$page_name .= str_replace('%2F', '/', urlencode($symfony_request_path));

}

if (substr($root_path, 0, 2) === './' && strpos($root_path, '..') === false)

{

$root_dirs = explode('/', str_replace('\\', '/', rtrim($root_path, '/')));

$page_dirs = explode('/', str_replace('\\', '/', '.'));

}

else

{

// current directory within the phpBB root (for example: adm)

$root_dirs = explode('/', str_replace('\\', '/', filesystem_helper::realpath($root_path)));

$page_dirs = explode('/', str_replace('\\', '/', filesystem_helper::realpath('./')));

}

$intersection = array_intersect_assoc($root_dirs, $page_dirs);

$root_dirs = array_diff_assoc($root_dirs, $intersection);

$page_dirs = array_diff_assoc($page_dirs, $intersection);

$page_dir = str_repeat('../', count($root_dirs)) . implode('/', $page_dirs);

if ($page_dir && substr($page_dir, -1, 1) == '/')

{

$page_dir = substr($page_dir, 0, -1);

}

// Current page from phpBB root (for example: adm/index.php?i=10&b=2)

$page = (($page_dir) ? $page_dir . '/' : '') . $page_name;

if ($query_string)

{

$page .= '?' . $query_string;

}

// The script path from the webroot to the current directory (for example: /phpBB3/adm/) : always prefixed with / and ends in /

$script_path = $symfony_request->getBasePath();

// The script path from the webroot to the phpBB root (for example: /phpBB3/)

$script_dirs = explode('/', $script_path);

array_splice($script_dirs, -count($page_dirs));

$root_script_path = implode('/', $script_dirs) . (count($root_dirs) ? '/' . implode('/', $root_dirs) : '');

// We are on the base level (phpBB root == webroot), lets adjust the variables a bit...

if (!$root_script_path)

{

$root_script_path = ($page_dir) ? str_replace($page_dir, '', $script_path) : $script_path;

}

$script_path .= (substr($script_path, -1, 1) == '/') ? '' : '/';

$root_script_path .= (substr($root_script_path, -1, 1) == '/') ? '' : '/';

$forum_id = $request->variable('f', 0);

// maximum forum id value is maximum value of mediumint unsigned column

$forum_id = ($forum_id > 0 && $forum_id < 16777215) ? $forum_id : 0;

$page_array += array(

'page_name' => $page_name,

'page_dir' => $page_dir,

'query_string' => $query_string,

'script_path' => str_replace(' ', '%20', htmlspecialchars($script_path)),

'root_script_path' => str_replace(' ', '%20', htmlspecialchars($root_script_path)),

'page' => $page,

'forum' => $forum_id,

);

return $page_array;

}

/**

function extract_current_hostname()

{

global $config, $request;

// Get hostname

$host = htmlspecialchars_decode($request->header('Host', $request->server('SERVER_NAME')));

// Should be a string and lowered

$host = (string) strtolower($host);

// If host is equal the cookie domain or the server name (if config is set), then we assume it is valid

if ((isset($config['cookie_domain']) && $host === $config['cookie_domain']) || (isset($config['server_name']) && $host === $config['server_name']))

{

return $host;

}

// Is the host actually a IP? If so, we use the IP... (IPv4)

if (long2ip(ip2long($host)) === $host)

{

return $host;

}

// Now return the hostname (this also removes any port definition). The http:// is prepended to construct a valid URL, hosts never have a scheme assigned

$host = @parse_url('http://' . $host);

$host = (!empty($host['host'])) ? $host['host'] : '';

// Remove any portions not removed by parse_url (#)

$host = str_replace('#', '', $host);

// If, by any means, the host is now empty, we will use a "best approach" way to guess one

if (empty($host))

{

if (!empty($config['server_name']))

{

$host = $config['server_name'];

}

else if (!empty($config['cookie_domain']))

{

$host = (strpos($config['cookie_domain'], '.') === 0) ? substr($config['cookie_domain'], 1) : $config['cookie_domain'];

}

else

{

// Set to OS hostname or localhost

$host = (function_exists('php_uname')) ? php_uname('n') : 'localhost';

}

}

// It may be still no valid host, but for sure only a hostname (we may further expand on the cookie domain... if set)

return $host;

}

/**

function session_begin($update_session_page = true)

{

global $phpEx, $SID, $_SID, $_EXTRA_URL, $db, $config, $phpbb_root_path;

global $request, $phpbb_container, $user, $phpbb_log, $phpbb_dispatcher;

// Give us some basic information

$this->time_now = time();

$this->cookie_data = array('u' => 0, 'k' => '');

$this->update_session_page = $update_session_page;

$this->browser = $request->header('User-Agent');

$this->referer = $request->header('Referer');

$this->forwarded_for = $request->header('X-Forwarded-For');

$this->host = $this->extract_current_hostname();

$this->page = $this->extract_current_page($phpbb_root_path);

// if the forwarded for header shall be checked we have to validate its contents

if ($config['forwarded_for_check'])

{

$this->forwarded_for = preg_replace('# {2,}#', ' ', str_replace(',', ' ', $this->forwarded_for));

// split the list of IPs

$ips = explode(' ', $this->forwarded_for);

foreach ($ips as $ip)

{

if (!filter_var($ip, FILTER_VALIDATE_IP))

{

// contains invalid data, don't use the forwarded for header

$this->forwarded_for = '';

break;

}

}

}

else

{

$this->forwarded_for = '';

}

if ($request->is_set($config['cookie_name'] . '_sid', \phpbb\request\request_interface::COOKIE) || $request->is_set($config['cookie_name'] . '_u', \phpbb\request\request_interface::COOKIE))

{

$this->cookie_data['u'] = $request->variable($config['cookie_name'] . '_u', 0, false, \phpbb\request\request_interface::COOKIE);

$this->cookie_data['k'] = $request->variable($config['cookie_name'] . '_k', '', false, \phpbb\request\request_interface::COOKIE);

$this->session_id = $request->variable($config['cookie_name'] . '_sid', '', false, \phpbb\request\request_interface::COOKIE);

$SID = (defined('NEED_SID')) ? '?sid=' . $this->session_id : '?sid=';

$_SID = (defined('NEED_SID')) ? $this->session_id : '';

if (empty($this->session_id))

{

$this->session_id = $_SID = $request->variable('sid', '');

$SID = '?sid=' . $this->session_id;

$this->cookie_data = array('u' => 0, 'k' => '');

}

}

else

{

$this->session_id = $_SID = $request->variable('sid', '');

$SID = '?sid=' . $this->session_id;

}

$_EXTRA_URL = array();

// Why no forwarded_for et al? Well, too easily spoofed. With the results of my recent requests

// it's pretty clear that in the majority of cases you'll at least be left with a proxy/cache ip.

$ip = htmlspecialchars_decode($request->server('REMOTE_ADDR'));

$ip = preg_replace('# {2,}#', ' ', str_replace(',', ' ', $ip));

/**

$vars = array('ip');

extract($phpbb_dispatcher->trigger_event('core.session_ip_after', compact($vars)));

// split the list of IPs

$ips = explode(' ', trim($ip));

// Default IP if REMOTE_ADDR is invalid

$this->ip = '127.0.0.1';

foreach ($ips as $ip)

{

// Normalise IP address

$ip = phpbb_ip_normalise($ip);

if ($ip === false)

{

// IP address is invalid.

break;

}

// IP address is valid.

$this->ip = $ip;

}

$this->load = false;

// Load limit check (if applicable)

if ($config['limit_load'] || $config['limit_search_load'])

{

if ((function_exists('sys_getloadavg') && $load = sys_getloadavg()) || ($load = explode(' ', @file_get_contents('/proc/loadavg'))))

{

$this->load = array_slice($load, 0, 1);

$this->load = floatval($this->load[0]);

}

else

{

$config->set('limit_load', '0');

$config->set('limit_search_load', '0');

}

}

// if no session id is set, redirect to index.php

$session_id = $request->variable('sid', '');

if (defined('NEED_SID') && (empty($session_id) || $this->session_id !== $session_id))

{

send_status_line(401, 'Unauthorized');

redirect(append_sid("{$phpbb_root_path}index.$phpEx"));

}

// if session id is set

if (!empty($this->session_id))

{

$sql = 'SELECT u.*, s.*

FROM ' . SESSIONS_TABLE . ' s, ' . USERS_TABLE . " u

WHERE s.session_id = '" . $db->sql_escape($this->session_id) . "'

AND u.user_id = s.session_user_id";

$result = $db->sql_query($sql);

$this->data = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

// Did the session exist in the DB?

if (isset($this->data['user_id']))

{

// Validate IP length according to admin ... enforces an IP

// check on bots if admin requires this

if (strpos($this->ip, ':') !== false && strpos($this->data['session_ip'], ':') !== false)

{

$s_ip = short_ipv6($this->data['session_ip'], $config['ip_check']);

$u_ip = short_ipv6($this->ip, $config['ip_check']);

}

else

{

$s_ip = implode('.', array_slice(explode('.', $this->data['session_ip']), 0, $config['ip_check']));

$u_ip = implode('.', array_slice(explode('.', $this->ip), 0, $config['ip_check']));

}

$s_browser = ($config['browser_check']) ? trim(strtolower(substr($this->data['session_browser'], 0, 149))) : '';

$u_browser = ($config['browser_check']) ? trim(strtolower(substr($this->browser, 0, 149))) : '';

$s_forwarded_for = ($config['forwarded_for_check']) ? substr($this->data['session_forwarded_for'], 0, 254) : '';

$u_forwarded_for = ($config['forwarded_for_check']) ? substr($this->forwarded_for, 0, 254) : '';

// referer checks

// The @ before $config['referer_validation'] suppresses notices present while running the updater

$check_referer_path = (@$config['referer_validation'] == REFERER_VALIDATE_PATH);

$referer_valid = true;

// we assume HEAD and TRACE to be foul play and thus only whitelist GET

if (@$config['referer_validation'] && strtolower($request->server('REQUEST_METHOD')) !== 'get')

{

$referer_valid = $this->validate_referer($check_referer_path);

}

if ($u_ip === $s_ip && $s_browser === $u_browser && $s_forwarded_for === $u_forwarded_for && $referer_valid)

{

$session_expired = false;

// Check whether the session is still valid if we have one

/* @var $provider_collection \phpbb\auth\provider_collection */

$provider_collection = $phpbb_container->get('auth.provider_collection');

$provider = $provider_collection->get_provider();

if (!($provider instanceof \phpbb\auth\provider\provider_interface))

{

throw new \RuntimeException($provider . ' must implement \phpbb\auth\provider\provider_interface');

}

$ret = $provider->validate_session($this->data);

if ($ret !== null && !$ret)

{

$session_expired = true;

}

if (!$session_expired)

{

// Check the session length timeframe if autologin is not enabled.

// Else check the autologin length... and also removing those having autologin enabled but no longer allowed board-wide.

if (!$this->data['session_autologin'])

{

if ($this->data['session_time'] < $this->time_now - ($config['session_length'] + 60))

{

$session_expired = true;

}

}

else if (!$config['allow_autologin'] || ($config['max_autologin_time'] && $this->data['session_time'] < $this->time_now - (86400 * (int) $config['max_autologin_time']) + 60))

{

$session_expired = true;

}

}

if (!$session_expired)

{

$this->data['is_registered'] = ($this->data['user_id'] != ANONYMOUS && ($this->data['user_type'] == USER_NORMAL || $this->data['user_type'] == USER_FOUNDER)) ? true : false;

$this->data['is_bot'] = (!$this->data['is_registered'] && $this->data['user_id'] != ANONYMOUS) ? true : false;

$this->data['user_lang'] = basename($this->data['user_lang']);

// Is user banned? Are they excluded? Won't return on ban, exists within method

$this->check_ban_for_current_session($config);

return true;

}

}

else

{

// Added logging temporarily to help debug bugs...

if ($phpbb_container->getParameter('session.log_errors') && $this->data['user_id'] != ANONYMOUS)

{

if ($referer_valid)

{

$phpbb_log->add('critical', $user->data['user_id'], $user->ip, 'LOG_IP_BROWSER_FORWARDED_CHECK', false, array(

$u_ip,

$s_ip,

$u_browser,

$s_browser,

htmlspecialchars($u_forwarded_for),

htmlspecialchars($s_forwarded_for)

));

}

else

{

$phpbb_log->add('critical', $user->data['user_id'], $user->ip, 'LOG_REFERER_INVALID', false, array($this->referer));

}

}

}

}

}

// If we reach here then no (valid) session exists. So we'll create a new one

return $this->session_create();

}

/**

function session_create($user_id = false, $set_admin = false, $persist_login = false, $viewonline = true)

{

global $SID, $_SID, $db, $config, $cache, $phpbb_container, $phpbb_dispatcher;

$this->data = array();

/* Garbage collection ... remove old sessions updating user information

// Do we allow autologin on this board? No? Then override anything

// that may be requested here

if (!$config['allow_autologin'])

{

$this->cookie_data['k'] = $persist_login = false;

}

/**

$bot = false;

$active_bots = $cache->obtain_bots();

foreach ($active_bots as $row)

{

if ($row['bot_agent'] && preg_match('#' . str_replace('\*', '.*?', preg_quote($row['bot_agent'], '#')) . '#i', $this->browser))

{

$bot = $row['user_id'];

}

// If ip is supplied, we will make sure the ip is matching too...

if ($row['bot_ip'] && ($bot || !$row['bot_agent']))

{

// Set bot to false, then we only have to set it to true if it is matching

$bot = false;

foreach (explode(',', $row['bot_ip']) as $bot_ip)

{

$bot_ip = trim($bot_ip);

if (!$bot_ip)

{

continue;

}

if (strpos($this->ip, $bot_ip) === 0)

{

$bot = (int) $row['user_id'];

break;

}

}

}

if ($bot)

{

break;

}

}

/* @var $provider_collection \phpbb\auth\provider_collection */

$provider_collection = $phpbb_container->get('auth.provider_collection');

$provider = $provider_collection->get_provider();

$this->data = $provider->autologin();

if ($user_id !== false && isset($this->data['user_id']) && $this->data['user_id'] != $user_id)

{

$this->data = array();

}

if (isset($this->data['user_id']))

{

$this->cookie_data['k'] = '';

$this->cookie_data['u'] = $this->data['user_id'];

}

// If we're presented with an autologin key we'll join against it.

// Else if we've been passed a user_id we'll grab data based on that

if (isset($this->cookie_data['k']) && $this->cookie_data['k'] && $this->cookie_data['u'] && empty($this->data))

{

$sql = 'SELECT u.*

FROM ' . USERS_TABLE . ' u, ' . SESSIONS_KEYS_TABLE . ' k

WHERE u.user_id = ' . (int) $this->cookie_data['u'] . '

AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ")

AND k.key_id = '" . $db->sql_escape(md5($this->cookie_data['k'])) . "'";

$result = $db->sql_query($sql);

$user_data = $db->sql_fetchrow($result);

if ($user_id === false || (isset($user_data['user_id']) && $user_id == $user_data['user_id']))

{

$this->data = $user_data;

$bot = false;

}

$db->sql_freeresult($result);

}

if ($user_id !== false && empty($this->data))

{

$this->cookie_data['k'] = '';

$this->cookie_data['u'] = $user_id;

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

WHERE user_id = ' . (int) $this->cookie_data['u'] . '

AND user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')';

$result = $db->sql_query($sql);

$this->data = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$bot = false;

}

// Bot user, if they have a SID in the Request URI we need to get rid of it

// otherwise they'll index this page with the SID, duplicate content oh my!

if ($bot && isset($_GET['sid']))

{

send_status_line(301, 'Moved Permanently');

redirect(build_url(array('sid')));

}

// If no data was returned one or more of the following occurred:

// Key didn't match one in the DB

// User does not exist

// User is inactive

// User is bot

if (!is_array($this->data) || !count($this->data))

{

$this->cookie_data['k'] = '';

$this->cookie_data['u'] = ($bot) ? $bot : ANONYMOUS;

if (!$bot)

{

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

WHERE user_id = ' . (int) $this->cookie_data['u'];

}

else

{

// We give bots always the same session if it is not yet expired.

$sql = 'SELECT u.*, s.*

FROM ' . USERS_TABLE . ' u

LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = u.user_id)

WHERE u.user_id = ' . (int) $bot;

}

$result = $db->sql_query($sql);

$this->data = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

}

if ($this->data['user_id'] != ANONYMOUS && !$bot)

{

$this->data['session_last_visit'] = (isset($this->data['session_time']) && $this->data['session_time']) ? $this->data['session_time'] : (($this->data['user_lastvisit']) ? $this->data['user_lastvisit'] : time());

}

else

{

$this->data['session_last_visit'] = $this->time_now;

}

// Force user id to be integer...

$this->data['user_id'] = (int) $this->data['user_id'];

// At this stage we should have a filled data array, defined cookie u and k data.

// data array should contain recent session info if we're a real user and a recent

// session exists in which case session_id will also be set

// Is user banned? Are they excluded? Won't return on ban, exists within method

$this->check_ban_for_current_session($config);

$this->data['is_registered'] = (!$bot && $this->data['user_id'] != ANONYMOUS && ($this->data['user_type'] == USER_NORMAL || $this->data['user_type'] == USER_FOUNDER)) ? true : false;

$this->data['is_bot'] = ($bot) ? true : false;

// If our friend is a bot, we re-assign a previously assigned session

if ($this->data['is_bot'] && $bot == $this->data['user_id'] && $this->data['session_id'])

{

// Only assign the current session if the ip, browser and forwarded_for match...

if (strpos($this->ip, ':') !== false && strpos($this->data['session_ip'], ':') !== false)

{

$s_ip = short_ipv6($this->data['session_ip'], $config['ip_check']);

$u_ip = short_ipv6($this->ip, $config['ip_check']);

}

else

{

$s_ip = implode('.', array_slice(explode('.', $this->data['session_ip']), 0, $config['ip_check']));

$u_ip = implode('.', array_slice(explode('.', $this->ip), 0, $config['ip_check']));

}

$s_browser = ($config['browser_check']) ? trim(strtolower(substr($this->data['session_browser'], 0, 149))) : '';

$u_browser = ($config['browser_check']) ? trim(strtolower(substr($this->browser, 0, 149))) : '';

$s_forwarded_for = ($config['forwarded_for_check']) ? substr($this->data['session_forwarded_for'], 0, 254) : '';

$u_forwarded_for = ($config['forwarded_for_check']) ? substr($this->forwarded_for, 0, 254) : '';

if ($u_ip === $s_ip && $s_browser === $u_browser && $s_forwarded_for === $u_forwarded_for)

{

$this->session_id = $this->data['session_id'];

// Only update session DB a minute or so after last update or if page changes

if ($this->time_now - $this->data['session_time'] > 60 || ($this->update_session_page && $this->data['session_page'] != $this->page['page']))

{

// Update the last visit time

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_lastvisit = ' . (int) $this->data['session_time'] . '

WHERE user_id = ' . (int) $this->data['user_id'];

$db->sql_query($sql);

}

$SID = '?sid=';

$_SID = '';

return true;

}

else

{

// If the ip and browser does not match make sure we only have one bot assigned to one session

$db->sql_query('DELETE FROM ' . SESSIONS_TABLE . ' WHERE session_user_id = ' . $this->data['user_id']);

}

}

$session_autologin = (($this->cookie_data['k'] || $persist_login) && $this->data['is_registered']) ? true : false;

$set_admin = ($set_admin && $this->data['is_registered']) ? true : false;

// Create or update the session

$sql_ary = array(

'session_user_id' => (int) $this->data['user_id'],

'session_start' => (int) $this->time_now,

'session_last_visit' => (int) $this->data['session_last_visit'],

'session_time' => (int) $this->time_now,

'session_browser' => (string) trim(substr($this->browser, 0, 149)),

'session_forwarded_for' => (string) $this->forwarded_for,

'session_ip' => (string) $this->ip,

'session_autologin' => ($session_autologin) ? 1 : 0,

'session_admin' => ($set_admin) ? 1 : 0,

'session_viewonline' => ($viewonline) ? 1 : 0,

);

if ($this->update_session_page)

{

$sql_ary['session_page'] = (string) substr($this->page['page'], 0, 199);

$sql_ary['session_forum_id'] = $this->page['forum'];

}

$db->sql_return_on_error(true);

$sql = 'DELETE

FROM ' . SESSIONS_TABLE . '

WHERE session_id = \'' . $db->sql_escape($this->session_id) . '\'

AND session_user_id = ' . ANONYMOUS;

if (!defined('IN_ERROR_HANDLER') && (!$this->session_id || !$db->sql_query($sql) || !$db->sql_affectedrows()))

{

// Limit new sessions in 1 minute period (if required)

if (empty($this->data['session_time']) && $config['active_sessions'])

{

$sql = 'SELECT COUNT(session_id) AS sessions

FROM ' . SESSIONS_TABLE . '

WHERE session_time >= ' . ($this->time_now - 60);

$result = $db->sql_query($sql);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

if ((int) $row['sessions'] > (int) $config['active_sessions'])

{

send_status_line(503, 'Service Unavailable');

trigger_error('BOARD_UNAVAILABLE');

}

}

}

// Since we re-create the session id here, the inserted row must be unique. Therefore, we display potential errors.

// Commented out because it will not allow forums to update correctly

// Something quite important: session_page always holds the *last* page visited, except for the *first* visit.

// We are not able to simply have an empty session_page btw, therefore we need to tell phpBB how to detect this special case.

// If the session id is empty, we have a completely new one and will set an "identifier" here. This identifier is able to be checked later.

if (empty($this->data['session_id']))

{

// This is a temporary variable, only set for the very first visit

$this->data['session_created'] = true;

}

$this->session_id = $this->data['session_id'] = md5(unique_id());

$sql_ary['session_id'] = (string) $this->session_id;

$sql_ary['session_page'] = (string) substr($this->page['page'], 0, 199);

$sql_ary['session_forum_id'] = $this->page['forum'];

$sql = 'INSERT INTO ' . SESSIONS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

$db->sql_query($sql);

$db->sql_return_on_error(false);

// Regenerate autologin/persistent login key

if ($session_autologin)

{

$this->set_login_key();

}

// refresh data

$SID = '?sid=' . $this->session_id;

$_SID = $this->session_id;

$this->data = array_merge($this->data, $sql_ary);

if (!$bot)

{

$cookie_expire = $this->time_now + (($config['max_autologin_time']) ? 86400 * (int) $config['max_autologin_time'] : 31536000);

$this->set_cookie('u', $this->cookie_data['u'], $cookie_expire);

$this->set_cookie('k', $this->cookie_data['k'], $cookie_expire);

$this->set_cookie('sid', $this->session_id, $cookie_expire);

unset($cookie_expire);

$sql = 'SELECT COUNT(session_id) AS sessions

FROM ' . SESSIONS_TABLE . '

WHERE session_user_id = ' . (int) $this->data['user_id'] . '

AND session_time >= ' . (int) ($this->time_now - (max((int) $config['session_length'], (int) $config['form_token_lifetime'])));

$result = $db->sql_query($sql);

$row = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

if ((int) $row['sessions'] <= 1 || empty($this->data['user_form_salt']))

{

$this->data['user_form_salt'] = unique_id();

// Update the form key

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_form_salt = \'' . $db->sql_escape($this->data['user_form_salt']) . '\'

WHERE user_id = ' . (int) $this->data['user_id'];

$db->sql_query($sql);

}

}

else

{

$this->data['session_time'] = $this->data['session_last_visit'] = $this->time_now;

// Update the last visit time

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_lastvisit = ' . (int) $this->data['session_time'] . '

WHERE user_id = ' . (int) $this->data['user_id'];

$db->sql_query($sql);

$SID = '?sid=';

$_SID = '';

}

$session_data = $sql_ary;

/**

$vars = array('session_data');

extract($phpbb_dispatcher->trigger_event('core.session_create_after', compact($vars)));

unset($session_data);

return true;

}

/**

function session_kill($new_session = true)

{

global $SID, $_SID, $db, $phpbb_container, $phpbb_dispatcher;

$sql = 'DELETE FROM ' . SESSIONS_TABLE . "

WHERE session_id = '" . $db->sql_escape($this->session_id) . "'

AND session_user_id = " . (int) $this->data['user_id'];

$db->sql_query($sql);

$user_id = (int) $this->data['user_id'];

$session_id = $this->session_id;

/**

$vars = array('user_id', 'session_id', 'new_session');

extract($phpbb_dispatcher->trigger_event('core.session_kill_after', compact($vars)));

unset($user_id);

unset($session_id);

// Allow connecting logout with external auth method logout

/* @var $provider_collection \phpbb\auth\provider_collection */

$provider_collection = $phpbb_container->get('auth.provider_collection');

$provider = $provider_collection->get_provider();

$provider->logout($this->data, $new_session);

if ($this->data['user_id'] != ANONYMOUS)

{

// Delete existing session, update last visit info first!

if (!isset($this->data['session_time']))

{

$this->data['session_time'] = time();

}

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_lastvisit = ' . (int) $this->data['session_time'] . '

WHERE user_id = ' . (int) $this->data['user_id'];

$db->sql_query($sql);

if ($this->cookie_data['k'])

{

$sql = 'DELETE FROM ' . SESSIONS_KEYS_TABLE . '

WHERE user_id = ' . (int) $this->data['user_id'] . "

AND key_id = '" . $db->sql_escape(md5($this->cookie_data['k'])) . "'";

$db->sql_query($sql);

}

// Reset the data array

$this->data = array();

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

WHERE user_id = ' . ANONYMOUS;

$result = $db->sql_query($sql);

$this->data = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

}

$cookie_expire = $this->time_now - 31536000;

$this->set_cookie('u', '', $cookie_expire);

$this->set_cookie('k', '', $cookie_expire);

$this->set_cookie('sid', '', $cookie_expire);

unset($cookie_expire);

$SID = '?sid=';

$this->session_id = $_SID = '';

// To make sure a valid session is created we create one for the anonymous user

if ($new_session)

{

$this->session_create(ANONYMOUS);

}

return true;

}

/**

function session_gc()

{

global $db, $config, $phpbb_container, $phpbb_dispatcher;

if (!$this->time_now)

{

$this->time_now = time();

}

/**

$sql_select = 'SELECT s1.session_page, s1.session_user_id, s1.session_time AS recent_time

FROM ' . SESSIONS_TABLE . ' AS s1

FROM ' . SESSIONS_TABLE . '

WHERE session_time < ' . ($this->time_now - (int) $config['session_length']) . '

AND session_user_id <> ' . ANONYMOUS . '

AND s1.session_time = s2.recent_time';

switch ($db->get_sql_layer())

{

case 'sqlite3':

if (phpbb_version_compare($db->sql_server_info(true), '3.8.3', '>='))

{

// For SQLite versions 3.8.3+ which support Common Table Expressions (CTE)

$sql = "WITH s3 (session_page, session_user_id, session_time) AS ($sql_select)

UPDATE " . USERS_TABLE . '