[ Index ]

PHP Cross Reference of phpBB-3.1.10-deutsch

title

Body

[close]

/phpbb/ -> session.php (source)

   1  <?php
   2  /**
   3  *
   4  * This file is part of the phpBB Forum Software package.
   5  *
   6  * @copyright (c) phpBB Limited <https://www.phpbb.com>
   7  * @license GNU General Public License, version 2 (GPL-2.0)
   8  *
   9  * For full copyright and license information, please see
  10  * the docs/CREDITS.txt file.
  11  *
  12  */
  13  
  14  namespace phpbb;
  15  
  16  /**
  17  * Session class
  18  */
  19  class session
  20  {
  21      var $cookie_data = array();
  22      var $page = array();
  23      var $data = array();
  24      var $browser = '';
  25      var $forwarded_for = '';
  26      var $host = '';
  27      var $session_id = '';
  28      var $ip = '';
  29      var $load = 0;
  30      var $time_now = 0;
  31      var $update_session_page = true;
  32  
  33      /**
  34       * Extract current session page
  35       *
  36       * @param string $root_path current root path (phpbb_root_path)
  37       * @return array
  38       */
  39  	static function extract_current_page($root_path)
  40      {
  41          global $request, $symfony_request, $phpbb_filesystem;
  42  
  43          $page_array = array();
  44  
  45          // First of all, get the request uri...
  46          $script_name = $request->escape($symfony_request->getScriptName(), true);
  47          $args = $request->escape(explode('&', $symfony_request->getQueryString()), true);
  48  
  49          // 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...
  50          if (!$script_name)
  51          {
  52              $script_name = htmlspecialchars_decode($request->server('REQUEST_URI'));
  53              $script_name = (($pos = strpos($script_name, '?')) !== false) ? substr($script_name, 0, $pos) : $script_name;
  54              $page_array['failover'] = 1;
  55          }
  56  
  57          // Replace backslashes and doubled slashes (could happen on some proxy setups)
  58          $script_name = str_replace(array('\\', '//'), '/', $script_name);
  59  
  60          // Now, remove the sid and let us get a clean query string...
  61          $use_args = array();
  62  
  63          // Since some browser do not encode correctly we need to do this with some "special" characters...
  64          // " -> %22, ' => %27, < -> %3C, > -> %3E
  65          $find = array('"', "'", '<', '>', '&quot;', '&lt;', '&gt;');
  66          $replace = array('%22', '%27', '%3C', '%3E', '%22', '%3C', '%3E');
  67  
  68          foreach ($args as $key => $argument)
  69          {
  70              if (strpos($argument, 'sid=') === 0)
  71              {
  72                  continue;
  73              }
  74  
  75              $use_args[] = str_replace($find, $replace, $argument);
  76          }
  77          unset($args);
  78  
  79          // The following examples given are for an request uri of {path to the phpbb directory}/adm/index.php?i=10&b=2
  80  
  81          // The current query string
  82          $query_string = trim(implode('&', $use_args));
  83  
  84          // basenamed page name (for example: index.php)
  85          $page_name = (substr($script_name, -1, 1) == '/') ? '' : basename($script_name);
  86          $page_name = urlencode(htmlspecialchars($page_name));
  87  
  88          $symfony_request_path = $phpbb_filesystem->clean_path($symfony_request->getPathInfo());
  89          if ($symfony_request_path !== '/')
  90          {
  91              $page_name .= str_replace('%2F', '/', urlencode($symfony_request_path));
  92          }
  93  
  94          // current directory within the phpBB root (for example: adm)
  95          $root_dirs = explode('/', str_replace('\\', '/', phpbb_realpath($root_path)));
  96          $page_dirs = explode('/', str_replace('\\', '/', phpbb_realpath('./')));
  97          $intersection = array_intersect_assoc($root_dirs, $page_dirs);
  98  
  99          $root_dirs = array_diff_assoc($root_dirs, $intersection);
 100          $page_dirs = array_diff_assoc($page_dirs, $intersection);
 101  
 102          $page_dir = str_repeat('../', sizeof($root_dirs)) . implode('/', $page_dirs);
 103  
 104          if ($page_dir && substr($page_dir, -1, 1) == '/')
 105          {
 106              $page_dir = substr($page_dir, 0, -1);
 107          }
 108  
 109          // Current page from phpBB root (for example: adm/index.php?i=10&b=2)
 110          $page = (($page_dir) ? $page_dir . '/' : '') . $page_name;
 111          if ($query_string)
 112          {
 113              $page .= '?' . $query_string;
 114          }
 115  
 116          // The script path from the webroot to the current directory (for example: /phpBB3/adm/) : always prefixed with / and ends in /
 117          $script_path = $symfony_request->getBasePath();
 118  
 119          // The script path from the webroot to the phpBB root (for example: /phpBB3/)
 120          $script_dirs = explode('/', $script_path);
 121          array_splice($script_dirs, -sizeof($page_dirs));
 122          $root_script_path = implode('/', $script_dirs) . (sizeof($root_dirs) ? '/' . implode('/', $root_dirs) : '');
 123  
 124          // We are on the base level (phpBB root == webroot), lets adjust the variables a bit...
 125          if (!$root_script_path)
 126          {
 127              $root_script_path = ($page_dir) ? str_replace($page_dir, '', $script_path) : $script_path;
 128          }
 129  
 130          $script_path .= (substr($script_path, -1, 1) == '/') ? '' : '/';
 131          $root_script_path .= (substr($root_script_path, -1, 1) == '/') ? '' : '/';
 132  
 133          $forum_id = $request->variable('f', 0);
 134          // maximum forum id value is maximum value of mediumint unsigned column
 135          $forum_id = ($forum_id > 0 && $forum_id < 16777215) ? $forum_id : 0;
 136  
 137          $page_array += array(
 138              'page_name'            => $page_name,
 139              'page_dir'            => $page_dir,
 140  
 141              'query_string'        => $query_string,
 142              'script_path'        => str_replace(' ', '%20', htmlspecialchars($script_path)),
 143              'root_script_path'    => str_replace(' ', '%20', htmlspecialchars($root_script_path)),
 144  
 145              'page'                => $page,
 146              'forum'                => $forum_id,
 147          );
 148  
 149          return $page_array;
 150      }
 151  
 152      /**
 153      * Get valid hostname/port. HTTP_HOST is used, SERVER_NAME if HTTP_HOST not present.
 154      */
 155  	function extract_current_hostname()
 156      {
 157          global $config, $request;
 158  
 159          // Get hostname
 160          $host = htmlspecialchars_decode($request->header('Host', $request->server('SERVER_NAME')));
 161  
 162          // Should be a string and lowered
 163          $host = (string) strtolower($host);
 164  
 165          // If host is equal the cookie domain or the server name (if config is set), then we assume it is valid
 166          if ((isset($config['cookie_domain']) && $host === $config['cookie_domain']) || (isset($config['server_name']) && $host === $config['server_name']))
 167          {
 168              return $host;
 169          }
 170  
 171          // Is the host actually a IP? If so, we use the IP... (IPv4)
 172          if (long2ip(ip2long($host)) === $host)
 173          {
 174              return $host;
 175          }
 176  
 177          // 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
 178          $host = @parse_url('http://' . $host);
 179          $host = (!empty($host['host'])) ? $host['host'] : '';
 180  
 181          // Remove any portions not removed by parse_url (#)
 182          $host = str_replace('#', '', $host);
 183  
 184          // If, by any means, the host is now empty, we will use a "best approach" way to guess one
 185          if (empty($host))
 186          {
 187              if (!empty($config['server_name']))
 188              {
 189                  $host = $config['server_name'];
 190              }
 191              else if (!empty($config['cookie_domain']))
 192              {
 193                  $host = (strpos($config['cookie_domain'], '.') === 0) ? substr($config['cookie_domain'], 1) : $config['cookie_domain'];
 194              }
 195              else
 196              {
 197                  // Set to OS hostname or localhost
 198                  $host = (function_exists('php_uname')) ? php_uname('n') : 'localhost';
 199              }
 200          }
 201  
 202          // It may be still no valid host, but for sure only a hostname (we may further expand on the cookie domain... if set)
 203          return $host;
 204      }
 205  
 206      /**
 207      * Start session management
 208      *
 209      * This is where all session activity begins. We gather various pieces of
 210      * information from the client and server. We test to see if a session already
 211      * exists. If it does, fine and dandy. If it doesn't we'll go on to create a
 212      * new one ... pretty logical heh? We also examine the system load (if we're
 213      * running on a system which makes such information readily available) and
 214      * halt if it's above an admin definable limit.
 215      *
 216      * @param bool $update_session_page if true the session page gets updated.
 217      *            This can be set to circumvent certain scripts to update the users last visited page.
 218      */
 219  	function session_begin($update_session_page = true)
 220      {
 221          global $phpEx, $SID, $_SID, $_EXTRA_URL, $db, $config, $phpbb_root_path;
 222          global $request, $phpbb_container, $phpbb_dispatcher;
 223  
 224          // Give us some basic information
 225          $this->time_now                = time();
 226          $this->cookie_data            = array('u' => 0, 'k' => '');
 227          $this->update_session_page    = $update_session_page;
 228          $this->browser                = $request->header('User-Agent');
 229          $this->referer                = $request->header('Referer');
 230          $this->forwarded_for        = $request->header('X-Forwarded-For');
 231  
 232          $this->host                    = $this->extract_current_hostname();
 233          $this->page                    = $this->extract_current_page($phpbb_root_path);
 234  
 235          // if the forwarded for header shall be checked we have to validate its contents
 236          if ($config['forwarded_for_check'])
 237          {
 238              $this->forwarded_for = preg_replace('# {2,}#', ' ', str_replace(',', ' ', $this->forwarded_for));
 239  
 240              // split the list of IPs
 241              $ips = explode(' ', $this->forwarded_for);
 242              foreach ($ips as $ip)
 243              {
 244                  // check IPv4 first, the IPv6 is hopefully only going to be used very seldomly
 245                  if (!empty($ip) && !preg_match(get_preg_expression('ipv4'), $ip) && !preg_match(get_preg_expression('ipv6'), $ip))
 246                  {
 247                      // contains invalid data, don't use the forwarded for header
 248                      $this->forwarded_for = '';
 249                      break;
 250                  }
 251              }
 252          }
 253          else
 254          {
 255              $this->forwarded_for = '';
 256          }
 257  
 258          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))
 259          {
 260              $this->cookie_data['u'] = request_var($config['cookie_name'] . '_u', 0, false, true);
 261              $this->cookie_data['k'] = request_var($config['cookie_name'] . '_k', '', false, true);
 262              $this->session_id         = request_var($config['cookie_name'] . '_sid', '', false, true);
 263  
 264              $SID = (defined('NEED_SID')) ? '?sid=' . $this->session_id : '?sid=';
 265              $_SID = (defined('NEED_SID')) ? $this->session_id : '';
 266  
 267              if (empty($this->session_id))
 268              {
 269                  $this->session_id = $_SID = request_var('sid', '');
 270                  $SID = '?sid=' . $this->session_id;
 271                  $this->cookie_data = array('u' => 0, 'k' => '');
 272              }
 273          }
 274          else
 275          {
 276              $this->session_id = $_SID = request_var('sid', '');
 277              $SID = '?sid=' . $this->session_id;
 278          }
 279  
 280          $_EXTRA_URL = array();
 281  
 282          // Why no forwarded_for et al? Well, too easily spoofed. With the results of my recent requests
 283          // it's pretty clear that in the majority of cases you'll at least be left with a proxy/cache ip.
 284          $ip = htmlspecialchars_decode($request->server('REMOTE_ADDR'));
 285          $ip = preg_replace('# {2,}#', ' ', str_replace(',', ' ', $ip));
 286  
 287          /**
 288          * Event to alter user IP address
 289          *
 290          * @event core.session_ip_after
 291          * @var    string    ip    REMOTE_ADDR
 292          * @since 3.1.10-RC1
 293          */
 294          $vars = array('ip');
 295          extract($phpbb_dispatcher->trigger_event('core.session_ip_after', compact($vars)));
 296  
 297          // split the list of IPs
 298          $ips = explode(' ', trim($ip));
 299  
 300          // Default IP if REMOTE_ADDR is invalid
 301          $this->ip = '127.0.0.1';
 302  
 303          foreach ($ips as $ip)
 304          {
 305              if (function_exists('phpbb_ip_normalise'))
 306              {
 307                  // Normalise IP address
 308                  $ip = phpbb_ip_normalise($ip);
 309  
 310                  if (empty($ip))
 311                  {
 312                      // IP address is invalid.
 313                      break;
 314                  }
 315  
 316                  // IP address is valid.
 317                  $this->ip = $ip;
 318  
 319                  // Skip legacy code.
 320                  continue;
 321              }
 322  
 323              if (preg_match(get_preg_expression('ipv4'), $ip))
 324              {
 325                  $this->ip = $ip;
 326              }
 327              else if (preg_match(get_preg_expression('ipv6'), $ip))
 328              {
 329                  // Quick check for IPv4-mapped address in IPv6
 330                  if (stripos($ip, '::ffff:') === 0)
 331                  {
 332                      $ipv4 = substr($ip, 7);
 333  
 334                      if (preg_match(get_preg_expression('ipv4'), $ipv4))
 335                      {
 336                          $ip = $ipv4;
 337                      }
 338                  }
 339  
 340                  $this->ip = $ip;
 341              }
 342              else
 343              {
 344                  // We want to use the last valid address in the chain
 345                  // Leave foreach loop when address is invalid
 346                  break;
 347              }
 348          }
 349  
 350          $this->load = false;
 351  
 352          // Load limit check (if applicable)
 353          if ($config['limit_load'] || $config['limit_search_load'])
 354          {
 355              if ((function_exists('sys_getloadavg') && $load = sys_getloadavg()) || ($load = explode(' ', @file_get_contents('/proc/loadavg'))))
 356              {
 357                  $this->load = array_slice($load, 0, 1);
 358                  $this->load = floatval($this->load[0]);
 359              }
 360              else
 361              {
 362                  set_config('limit_load', '0');
 363                  set_config('limit_search_load', '0');
 364              }
 365          }
 366  
 367          // if no session id is set, redirect to index.php
 368          $session_id = $request->variable('sid', '');
 369          if (defined('NEED_SID') && (empty($session_id) || $this->session_id !== $session_id))
 370          {
 371              send_status_line(401, 'Unauthorized');
 372              redirect(append_sid("{$phpbb_root_path}index.$phpEx"));
 373          }
 374  
 375          // if session id is set
 376          if (!empty($this->session_id))
 377          {
 378              $sql = 'SELECT u.*, s.*
 379                  FROM ' . SESSIONS_TABLE . ' s, ' . USERS_TABLE . " u
 380                  WHERE s.session_id = '" . $db->sql_escape($this->session_id) . "'
 381                      AND u.user_id = s.session_user_id";
 382              $result = $db->sql_query($sql);
 383              $this->data = $db->sql_fetchrow($result);
 384              $db->sql_freeresult($result);
 385  
 386              // Did the session exist in the DB?
 387              if (isset($this->data['user_id']))
 388              {
 389                  // Validate IP length according to admin ... enforces an IP
 390                  // check on bots if admin requires this
 391  //                $quadcheck = ($config['ip_check_bot'] && $this->data['user_type'] & USER_BOT) ? 4 : $config['ip_check'];
 392  
 393                  if (strpos($this->ip, ':') !== false && strpos($this->data['session_ip'], ':') !== false)
 394                  {
 395                      $s_ip = short_ipv6($this->data['session_ip'], $config['ip_check']);
 396                      $u_ip = short_ipv6($this->ip, $config['ip_check']);
 397                  }
 398                  else
 399                  {
 400                      $s_ip = implode('.', array_slice(explode('.', $this->data['session_ip']), 0, $config['ip_check']));
 401                      $u_ip = implode('.', array_slice(explode('.', $this->ip), 0, $config['ip_check']));
 402                  }
 403  
 404                  $s_browser = ($config['browser_check']) ? trim(strtolower(substr($this->data['session_browser'], 0, 149))) : '';
 405                  $u_browser = ($config['browser_check']) ? trim(strtolower(substr($this->browser, 0, 149))) : '';
 406  
 407                  $s_forwarded_for = ($config['forwarded_for_check']) ? substr($this->data['session_forwarded_for'], 0, 254) : '';
 408                  $u_forwarded_for = ($config['forwarded_for_check']) ? substr($this->forwarded_for, 0, 254) : '';
 409  
 410                  // referer checks
 411                  // The @ before $config['referer_validation'] suppresses notices present while running the updater
 412                  $check_referer_path = (@$config['referer_validation'] == REFERER_VALIDATE_PATH);
 413                  $referer_valid = true;
 414  
 415                  // we assume HEAD and TRACE to be foul play and thus only whitelist GET
 416                  if (@$config['referer_validation'] && strtolower($request->server('REQUEST_METHOD')) !== 'get')
 417                  {
 418                      $referer_valid = $this->validate_referer($check_referer_path);
 419                  }
 420  
 421                  if ($u_ip === $s_ip && $s_browser === $u_browser && $s_forwarded_for === $u_forwarded_for && $referer_valid)
 422                  {
 423                      $session_expired = false;
 424  
 425                      // Check whether the session is still valid if we have one
 426                      $provider_collection = $phpbb_container->get('auth.provider_collection');
 427                      $provider = $provider_collection->get_provider();
 428  
 429                      if (!($provider instanceof \phpbb\auth\provider\provider_interface))
 430                      {
 431                          throw new \RuntimeException($provider . ' must implement \phpbb\auth\provider\provider_interface');
 432                      }
 433  
 434                      $ret = $provider->validate_session($this->data);
 435                      if ($ret !== null && !$ret)
 436                      {
 437                          $session_expired = true;
 438                      }
 439  
 440                      if (!$session_expired)
 441                      {
 442                          // Check the session length timeframe if autologin is not enabled.
 443                          // Else check the autologin length... and also removing those having autologin enabled but no longer allowed board-wide.
 444                          if (!$this->data['session_autologin'])
 445                          {
 446                              if ($this->data['session_time'] < $this->time_now - ($config['session_length'] + 60))
 447                              {
 448                                  $session_expired = true;
 449                              }
 450                          }
 451                          else if (!$config['allow_autologin'] || ($config['max_autologin_time'] && $this->data['session_time'] < $this->time_now - (86400 * (int) $config['max_autologin_time']) + 60))
 452                          {
 453                              $session_expired = true;
 454                          }
 455                      }
 456  
 457                      if (!$session_expired)
 458                      {
 459                          $this->data['is_registered'] = ($this->data['user_id'] != ANONYMOUS && ($this->data['user_type'] == USER_NORMAL || $this->data['user_type'] == USER_FOUNDER)) ? true : false;
 460                          $this->data['is_bot'] = (!$this->data['is_registered'] && $this->data['user_id'] != ANONYMOUS) ? true : false;
 461                          $this->data['user_lang'] = basename($this->data['user_lang']);
 462  
 463                          return true;
 464                      }
 465                  }
 466                  else
 467                  {
 468                      // Added logging temporarly to help debug bugs...
 469                      if (defined('DEBUG') && $this->data['user_id'] != ANONYMOUS)
 470                      {
 471                          if ($referer_valid)
 472                          {
 473                              add_log('critical', 'LOG_IP_BROWSER_FORWARDED_CHECK', $u_ip, $s_ip, $u_browser, $s_browser, htmlspecialchars($u_forwarded_for), htmlspecialchars($s_forwarded_for));
 474                          }
 475                          else
 476                          {
 477                              add_log('critical', 'LOG_REFERER_INVALID', $this->referer);
 478                          }
 479                      }
 480                  }
 481              }
 482          }
 483  
 484          // If we reach here then no (valid) session exists. So we'll create a new one
 485          return $this->session_create();
 486      }
 487  
 488      /**
 489      * Create a new session
 490      *
 491      * If upon trying to start a session we discover there is nothing existing we
 492      * jump here. Additionally this method is called directly during login to regenerate
 493      * the session for the specific user. In this method we carry out a number of tasks;
 494      * garbage collection, (search)bot checking, banned user comparison. Basically
 495      * though this method will result in a new session for a specific user.
 496      */
 497  	function session_create($user_id = false, $set_admin = false, $persist_login = false, $viewonline = true)
 498      {
 499          global $SID, $_SID, $db, $config, $cache, $phpbb_root_path, $phpEx, $phpbb_container, $phpbb_dispatcher;
 500  
 501          $this->data = array();
 502  
 503          /* Garbage collection ... remove old sessions updating user information
 504          // if necessary. It means (potentially) 11 queries but only infrequently
 505          if ($this->time_now > $config['session_last_gc'] + $config['session_gc'])
 506          {
 507              $this->session_gc();
 508          }*/
 509  
 510          // Do we allow autologin on this board? No? Then override anything
 511          // that may be requested here
 512          if (!$config['allow_autologin'])
 513          {
 514              $this->cookie_data['k'] = $persist_login = false;
 515          }
 516  
 517          /**
 518          * Here we do a bot check, oh er saucy! No, not that kind of bot
 519          * check. We loop through the list of bots defined by the admin and
 520          * see if we have any useragent and/or IP matches. If we do, this is a
 521          * bot, act accordingly
 522          */
 523          $bot = false;
 524          $active_bots = $cache->obtain_bots();
 525  
 526          foreach ($active_bots as $row)
 527          {
 528              if ($row['bot_agent'] && preg_match('#' . str_replace('\*', '.*?', preg_quote($row['bot_agent'], '#')) . '#i', $this->browser))
 529              {
 530                  $bot = $row['user_id'];
 531              }
 532  
 533              // If ip is supplied, we will make sure the ip is matching too...
 534              if ($row['bot_ip'] && ($bot || !$row['bot_agent']))
 535              {
 536                  // Set bot to false, then we only have to set it to true if it is matching
 537                  $bot = false;
 538  
 539                  foreach (explode(',', $row['bot_ip']) as $bot_ip)
 540                  {
 541                      $bot_ip = trim($bot_ip);
 542  
 543                      if (!$bot_ip)
 544                      {
 545                          continue;
 546                      }
 547  
 548                      if (strpos($this->ip, $bot_ip) === 0)
 549                      {
 550                          $bot = (int) $row['user_id'];
 551                          break;
 552                      }
 553                  }
 554              }
 555  
 556              if ($bot)
 557              {
 558                  break;
 559              }
 560          }
 561  
 562          $provider_collection = $phpbb_container->get('auth.provider_collection');
 563          $provider = $provider_collection->get_provider();
 564          $this->data = $provider->autologin();
 565  
 566          if ($user_id !== false && sizeof($this->data) && $this->data['user_id'] != $user_id)
 567          {
 568              $this->data = array();
 569          }
 570  
 571          if (sizeof($this->data))
 572          {
 573              $this->cookie_data['k'] = '';
 574              $this->cookie_data['u'] = $this->data['user_id'];
 575          }
 576  
 577          // If we're presented with an autologin key we'll join against it.
 578          // Else if we've been passed a user_id we'll grab data based on that
 579          if (isset($this->cookie_data['k']) && $this->cookie_data['k'] && $this->cookie_data['u'] && !sizeof($this->data))
 580          {
 581              $sql = 'SELECT u.*
 582                  FROM ' . USERS_TABLE . ' u, ' . SESSIONS_KEYS_TABLE . ' k
 583                  WHERE u.user_id = ' . (int) $this->cookie_data['u'] . '
 584                      AND u.user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ")
 585                      AND k.user_id = u.user_id
 586                      AND k.key_id = '" . $db->sql_escape(md5($this->cookie_data['k'])) . "'";
 587              $result = $db->sql_query($sql);
 588              $user_data = $db->sql_fetchrow($result);
 589  
 590              if ($user_id === false || (isset($user_data['user_id']) && $user_id == $user_data['user_id']))
 591              {
 592                  $this->data = $user_data;
 593                  $bot = false;
 594              }
 595  
 596              $db->sql_freeresult($result);
 597          }
 598  
 599          if ($user_id !== false && !sizeof($this->data))
 600          {
 601              $this->cookie_data['k'] = '';
 602              $this->cookie_data['u'] = $user_id;
 603  
 604              $sql = 'SELECT *
 605                  FROM ' . USERS_TABLE . '
 606                  WHERE user_id = ' . (int) $this->cookie_data['u'] . '
 607                      AND user_type IN (' . USER_NORMAL . ', ' . USER_FOUNDER . ')';
 608              $result = $db->sql_query($sql);
 609              $this->data = $db->sql_fetchrow($result);
 610              $db->sql_freeresult($result);
 611              $bot = false;
 612          }
 613  
 614          // Bot user, if they have a SID in the Request URI we need to get rid of it
 615          // otherwise they'll index this page with the SID, duplicate content oh my!
 616          if ($bot && isset($_GET['sid']))
 617          {
 618              send_status_line(301, 'Moved Permanently');
 619              redirect(build_url(array('sid')));
 620          }
 621  
 622          // If no data was returned one or more of the following occurred:
 623          // Key didn't match one in the DB
 624          // User does not exist
 625          // User is inactive
 626          // User is bot
 627          if (!sizeof($this->data) || !is_array($this->data))
 628          {
 629              $this->cookie_data['k'] = '';
 630              $this->cookie_data['u'] = ($bot) ? $bot : ANONYMOUS;
 631  
 632              if (!$bot)
 633              {
 634                  $sql = 'SELECT *
 635                      FROM ' . USERS_TABLE . '
 636                      WHERE user_id = ' . (int) $this->cookie_data['u'];
 637              }
 638              else
 639              {
 640                  // We give bots always the same session if it is not yet expired.
 641                  $sql = 'SELECT u.*, s.*
 642                      FROM ' . USERS_TABLE . ' u
 643                      LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = u.user_id)
 644                      WHERE u.user_id = ' . (int) $bot;
 645              }
 646  
 647              $result = $db->sql_query($sql);
 648              $this->data = $db->sql_fetchrow($result);
 649              $db->sql_freeresult($result);
 650          }
 651  
 652          if ($this->data['user_id'] != ANONYMOUS && !$bot)
 653          {
 654              $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());
 655          }
 656          else
 657          {
 658              $this->data['session_last_visit'] = $this->time_now;
 659          }
 660  
 661          // Force user id to be integer...
 662          $this->data['user_id'] = (int) $this->data['user_id'];
 663  
 664          // At this stage we should have a filled data array, defined cookie u and k data.
 665          // data array should contain recent session info if we're a real user and a recent
 666          // session exists in which case session_id will also be set
 667  
 668          // Is user banned? Are they excluded? Won't return on ban, exists within method
 669          if ($this->data['user_type'] != USER_FOUNDER)
 670          {
 671              if (!$config['forwarded_for_check'])
 672              {
 673                  $this->check_ban($this->data['user_id'], $this->ip);
 674              }
 675              else
 676              {
 677                  $ips = explode(' ', $this->forwarded_for);
 678                  $ips[] = $this->ip;
 679                  $this->check_ban($this->data['user_id'], $ips);
 680              }
 681          }
 682  
 683          $this->data['is_registered'] = (!$bot && $this->data['user_id'] != ANONYMOUS && ($this->data['user_type'] == USER_NORMAL || $this->data['user_type'] == USER_FOUNDER)) ? true : false;
 684          $this->data['is_bot'] = ($bot) ? true : false;
 685  
 686          // If our friend is a bot, we re-assign a previously assigned session
 687          if ($this->data['is_bot'] && $bot == $this->data['user_id'] && $this->data['session_id'])
 688          {
 689              // Only assign the current session if the ip, browser and forwarded_for match...
 690              if (strpos($this->ip, ':') !== false && strpos($this->data['session_ip'], ':') !== false)
 691              {
 692                  $s_ip = short_ipv6($this->data['session_ip'], $config['ip_check']);
 693                  $u_ip = short_ipv6($this->ip, $config['ip_check']);
 694              }
 695              else
 696              {
 697                  $s_ip = implode('.', array_slice(explode('.', $this->data['session_ip']), 0, $config['ip_check']));
 698                  $u_ip = implode('.', array_slice(explode('.', $this->ip), 0, $config['ip_check']));
 699              }
 700  
 701              $s_browser = ($config['browser_check']) ? trim(strtolower(substr($this->data['session_browser'], 0, 149))) : '';
 702              $u_browser = ($config['browser_check']) ? trim(strtolower(substr($this->browser, 0, 149))) : '';
 703  
 704              $s_forwarded_for = ($config['forwarded_for_check']) ? substr($this->data['session_forwarded_for'], 0, 254) : '';
 705              $u_forwarded_for = ($config['forwarded_for_check']) ? substr($this->forwarded_for, 0, 254) : '';
 706  
 707              if ($u_ip === $s_ip && $s_browser === $u_browser && $s_forwarded_for === $u_forwarded_for)
 708              {
 709                  $this->session_id = $this->data['session_id'];
 710  
 711                  // Only update session DB a minute or so after last update or if page changes
 712                  if ($this->time_now - $this->data['session_time'] > 60 || ($this->update_session_page && $this->data['session_page'] != $this->page['page']))
 713                  {
 714                      // Update the last visit time
 715                      $sql = 'UPDATE ' . USERS_TABLE . '
 716                          SET user_lastvisit = ' . (int) $this->data['session_time'] . '
 717                          WHERE user_id = ' . (int) $this->data['user_id'];
 718                      $db->sql_query($sql);
 719                  }
 720  
 721                  $SID = '?sid=';
 722                  $_SID = '';
 723                  return true;
 724              }
 725              else
 726              {
 727                  // If the ip and browser does not match make sure we only have one bot assigned to one session
 728                  $db->sql_query('DELETE FROM ' . SESSIONS_TABLE . ' WHERE session_user_id = ' . $this->data['user_id']);
 729              }
 730          }
 731  
 732          $session_autologin = (($this->cookie_data['k'] || $persist_login) && $this->data['is_registered']) ? true : false;
 733          $set_admin = ($set_admin && $this->data['is_registered']) ? true : false;
 734  
 735          // Create or update the session
 736          $sql_ary = array(
 737              'session_user_id'        => (int) $this->data['user_id'],
 738              'session_start'            => (int) $this->time_now,
 739              'session_last_visit'    => (int) $this->data['session_last_visit'],
 740              'session_time'            => (int) $this->time_now,
 741              'session_browser'        => (string) trim(substr($this->browser, 0, 149)),
 742              'session_forwarded_for'    => (string) $this->forwarded_for,
 743              'session_ip'            => (string) $this->ip,
 744              'session_autologin'        => ($session_autologin) ? 1 : 0,
 745              'session_admin'            => ($set_admin) ? 1 : 0,
 746              'session_viewonline'    => ($viewonline) ? 1 : 0,
 747          );
 748  
 749          if ($this->update_session_page)
 750          {
 751              $sql_ary['session_page'] = (string) substr($this->page['page'], 0, 199);
 752              $sql_ary['session_forum_id'] = $this->page['forum'];
 753          }
 754  
 755          $db->sql_return_on_error(true);
 756  
 757          $sql = 'DELETE
 758              FROM ' . SESSIONS_TABLE . '
 759              WHERE session_id = \'' . $db->sql_escape($this->session_id) . '\'
 760                  AND session_user_id = ' . ANONYMOUS;
 761  
 762          if (!defined('IN_ERROR_HANDLER') && (!$this->session_id || !$db->sql_query($sql) || !$db->sql_affectedrows()))
 763          {
 764              // Limit new sessions in 1 minute period (if required)
 765              if (empty($this->data['session_time']) && $config['active_sessions'])
 766              {
 767  //                $db->sql_return_on_error(false);
 768  
 769                  $sql = 'SELECT COUNT(session_id) AS sessions
 770                      FROM ' . SESSIONS_TABLE . '
 771                      WHERE session_time >= ' . ($this->time_now - 60);
 772                  $result = $db->sql_query($sql);
 773                  $row = $db->sql_fetchrow($result);
 774                  $db->sql_freeresult($result);
 775  
 776                  if ((int) $row['sessions'] > (int) $config['active_sessions'])
 777                  {
 778                      send_status_line(503, 'Service Unavailable');
 779                      trigger_error('BOARD_UNAVAILABLE');
 780                  }
 781              }
 782          }
 783  
 784          // Since we re-create the session id here, the inserted row must be unique. Therefore, we display potential errors.
 785          // Commented out because it will not allow forums to update correctly
 786  //        $db->sql_return_on_error(false);
 787  
 788          // Something quite important: session_page always holds the *last* page visited, except for the *first* visit.
 789          // We are not able to simply have an empty session_page btw, therefore we need to tell phpBB how to detect this special case.
 790          // 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.
 791          if (empty($this->data['session_id']))
 792          {
 793              // This is a temporary variable, only set for the very first visit
 794              $this->data['session_created'] = true;
 795          }
 796  
 797          $this->session_id = $this->data['session_id'] = md5(unique_id());
 798  
 799          $sql_ary['session_id'] = (string) $this->session_id;
 800          $sql_ary['session_page'] = (string) substr($this->page['page'], 0, 199);
 801          $sql_ary['session_forum_id'] = $this->page['forum'];
 802  
 803          $sql = 'INSERT INTO ' . SESSIONS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
 804          $db->sql_query($sql);
 805  
 806          $db->sql_return_on_error(false);
 807  
 808          // Regenerate autologin/persistent login key
 809          if ($session_autologin)
 810          {
 811              $this->set_login_key();
 812          }
 813  
 814          // refresh data
 815          $SID = '?sid=' . $this->session_id;
 816          $_SID = $this->session_id;
 817          $this->data = array_merge($this->data, $sql_ary);
 818  
 819          if (!$bot)
 820          {
 821              $cookie_expire = $this->time_now + (($config['max_autologin_time']) ? 86400 * (int) $config['max_autologin_time'] : 31536000);
 822  
 823              $this->set_cookie('u', $this->cookie_data['u'], $cookie_expire);
 824              $this->set_cookie('k', $this->cookie_data['k'], $cookie_expire);
 825              $this->set_cookie('sid', $this->session_id, $cookie_expire);
 826  
 827              unset($cookie_expire);
 828  
 829              $sql = 'SELECT COUNT(session_id) AS sessions
 830                      FROM ' . SESSIONS_TABLE . '
 831                      WHERE session_user_id = ' . (int) $this->data['user_id'] . '
 832                      AND session_time >= ' . (int) ($this->time_now - (max($config['session_length'], $config['form_token_lifetime'])));
 833              $result = $db->sql_query($sql);
 834              $row = $db->sql_fetchrow($result);
 835              $db->sql_freeresult($result);
 836  
 837              if ((int) $row['sessions'] <= 1 || empty($this->data['user_form_salt']))
 838              {
 839                  $this->data['user_form_salt'] = unique_id();
 840                  // Update the form key
 841                  $sql = 'UPDATE ' . USERS_TABLE . '
 842                      SET user_form_salt = \'' . $db->sql_escape($this->data['user_form_salt']) . '\'
 843                      WHERE user_id = ' . (int) $this->data['user_id'];
 844                  $db->sql_query($sql);
 845              }
 846          }
 847          else
 848          {
 849              $this->data['session_time'] = $this->data['session_last_visit'] = $this->time_now;
 850  
 851              // Update the last visit time
 852              $sql = 'UPDATE ' . USERS_TABLE . '
 853                  SET user_lastvisit = ' . (int) $this->data['session_time'] . '
 854                  WHERE user_id = ' . (int) $this->data['user_id'];
 855              $db->sql_query($sql);
 856  
 857              $SID = '?sid=';
 858              $_SID = '';
 859          }
 860  
 861          $session_data = $sql_ary;
 862          /**
 863          * Event to send new session data to extension
 864          * Read-only event
 865          *
 866          * @event core.session_create_after
 867          * @var    array        session_data                Associative array of session keys to be updated
 868          * @since 3.1.6-RC1
 869          */
 870          $vars = array('session_data');
 871          extract($phpbb_dispatcher->trigger_event('core.session_create_after', compact($vars)));
 872          unset($session_data);
 873  
 874          return true;
 875      }
 876  
 877      /**
 878      * Kills a session
 879      *
 880      * This method does what it says on the tin. It will delete a pre-existing session.
 881      * It resets cookie information (destroying any autologin key within that cookie data)
 882      * and update the users information from the relevant session data. It will then
 883      * grab guest user information.
 884      */
 885  	function session_kill($new_session = true)
 886      {
 887          global $SID, $_SID, $db, $config, $phpbb_root_path, $phpEx, $phpbb_container, $phpbb_dispatcher;
 888  
 889          $sql = 'DELETE FROM ' . SESSIONS_TABLE . "
 890              WHERE session_id = '" . $db->sql_escape($this->session_id) . "'
 891                  AND session_user_id = " . (int) $this->data['user_id'];
 892          $db->sql_query($sql);
 893  
 894          $user_id = (int) $this->data['user_id'];
 895          $session_id = $this->session_id;
 896          /**
 897          * Event to send session kill information to extension
 898          * Read-only event
 899          *
 900          * @event core.session_kill_after
 901          * @var    int        user_id                user_id of the session user.
 902          * @var    string        session_id                current user's session_id
 903          * @var    bool    new_session     should we create new session for user
 904          * @since 3.1.6-RC1
 905          */
 906          $vars = array('user_id', 'session_id', 'new_session');
 907          extract($phpbb_dispatcher->trigger_event('core.session_kill_after', compact($vars)));
 908          unset($user_id);
 909          unset($session_id);
 910  
 911          // Allow connecting logout with external auth method logout
 912          $provider_collection = $phpbb_container->get('auth.provider_collection');
 913          $provider = $provider_collection->get_provider();
 914          $provider->logout($this->data, $new_session);
 915  
 916          if ($this->data['user_id'] != ANONYMOUS)
 917          {
 918              // Delete existing session, update last visit info first!
 919              if (!isset($this->data['session_time']))
 920              {
 921                  $this->data['session_time'] = time();
 922              }
 923  
 924              $sql = 'UPDATE ' . USERS_TABLE . '
 925                  SET user_lastvisit = ' . (int) $this->data['session_time'] . '
 926                  WHERE user_id = ' . (int) $this->data['user_id'];
 927              $db->sql_query($sql);
 928  
 929              if ($this->cookie_data['k'])
 930              {
 931                  $sql = 'DELETE FROM ' . SESSIONS_KEYS_TABLE . '
 932                      WHERE user_id = ' . (int) $this->data['user_id'] . "
 933                          AND key_id = '" . $db->sql_escape(md5($this->cookie_data['k'])) . "'";
 934                  $db->sql_query($sql);
 935              }
 936  
 937              // Reset the data array
 938              $this->data = array();
 939  
 940              $sql = 'SELECT *
 941                  FROM ' . USERS_TABLE . '
 942                  WHERE user_id = ' . ANONYMOUS;
 943              $result = $db->sql_query($sql);
 944              $this->data = $db->sql_fetchrow($result);
 945              $db->sql_freeresult($result);
 946          }
 947  
 948          $cookie_expire = $this->time_now - 31536000;
 949          $this->set_cookie('u', '', $cookie_expire);
 950          $this->set_cookie('k', '', $cookie_expire);
 951          $this->set_cookie('sid', '', $cookie_expire);
 952          unset($cookie_expire);
 953  
 954          $SID = '?sid=';
 955          $this->session_id = $_SID = '';
 956  
 957          // To make sure a valid session is created we create one for the anonymous user
 958          if ($new_session)
 959          {
 960              $this->session_create(ANONYMOUS);
 961          }
 962  
 963          return true;
 964      }
 965  
 966      /**
 967      * Session garbage collection
 968      *
 969      * This looks a lot more complex than it really is. Effectively we are
 970      * deleting any sessions older than an admin definable limit. Due to the
 971      * way in which we maintain session data we have to ensure we update user
 972      * data before those sessions are destroyed. In addition this method
 973      * removes autologin key information that is older than an admin defined
 974      * limit.
 975      */
 976  	function session_gc()
 977      {
 978          global $db, $config, $phpbb_root_path, $phpEx, $phpbb_container, $phpbb_dispatcher;
 979  
 980          $batch_size = 10;
 981  
 982          if (!$this->time_now)
 983          {
 984              $this->time_now = time();
 985          }
 986  
 987          // Firstly, delete guest sessions
 988          $sql = 'DELETE FROM ' . SESSIONS_TABLE . '
 989              WHERE session_user_id = ' . ANONYMOUS . '
 990                  AND session_time < ' . (int) ($this->time_now - $config['session_length']);
 991          $db->sql_query($sql);
 992  
 993          // Get expired sessions, only most recent for each user
 994          $sql = 'SELECT session_user_id, session_page, MAX(session_time) AS recent_time
 995              FROM ' . SESSIONS_TABLE . '
 996              WHERE session_time < ' . ($this->time_now - $config['session_length']) . '
 997              GROUP BY session_user_id, session_page';
 998          $result = $db->sql_query_limit($sql, $batch_size);
 999  
1000          $del_user_id = array();
1001          $del_sessions = 0;
1002  
1003          while ($row = $db->sql_fetchrow($result))
1004          {
1005              $sql = 'UPDATE ' . USERS_TABLE . '
1006                  SET user_lastvisit = ' . (int) $row['recent_time'] . ", user_lastpage = '" . $db->sql_escape($row['session_page']) . "'
1007                  WHERE user_id = " . (int) $row['session_user_id'];
1008              $db->sql_query($sql);
1009  
1010              $del_user_id[] = (int) $row['session_user_id'];
1011              $del_sessions++;
1012          }
1013          $db->sql_freeresult($result);
1014  
1015          if (sizeof($del_user_id))
1016          {
1017              // Delete expired sessions
1018              $sql = 'DELETE FROM ' . SESSIONS_TABLE . '
1019                  WHERE ' . $db->sql_in_set('session_user_id', $del_user_id) . '
1020                      AND session_time < ' . ($this->time_now - $config['session_length']);
1021              $db->sql_query($sql);
1022          }
1023  
1024          if ($del_sessions < $batch_size)
1025          {
1026              // Less than 10 users, update gc timer ... else we want gc
1027              // called again to delete other sessions
1028              set_config('session_last_gc', $this->time_now, true);
1029  
1030              if ($config['max_autologin_time'])
1031              {
1032                  $sql = 'DELETE FROM ' . SESSIONS_KEYS_TABLE . '
1033                      WHERE last_login < ' . (time() - (86400 * (int) $config['max_autologin_time']));
1034                  $db->sql_query($sql);
1035              }
1036  
1037              // only called from CRON; should be a safe workaround until the infrastructure gets going
1038              $captcha_factory = $phpbb_container->get('captcha.factory');
1039              $captcha_factory->garbage_collect($config['captcha_plugin']);
1040  
1041              $sql = 'DELETE FROM ' . LOGIN_ATTEMPT_TABLE . '
1042                  WHERE attempt_time < ' . (time() - (int) $config['ip_login_limit_time']);
1043              $db->sql_query($sql);
1044          }
1045  
1046          /**
1047          * Event to trigger extension on session_gc
1048          *
1049          * @event core.session_gc_after
1050          * @since 3.1.6-RC1
1051          */
1052          $phpbb_dispatcher->dispatch('core.session_gc_after');
1053  
1054          return;
1055      }
1056  
1057      /**
1058      * Sets a cookie
1059      *
1060      * Sets a cookie of the given name with the specified data for the given length of time. If no time is specified, a session cookie will be set.
1061      *
1062      * @param string $name        Name of the cookie, will be automatically prefixed with the phpBB cookie name. track becomes [cookie_name]_track then.
1063      * @param string $cookiedata    The data to hold within the cookie
1064      * @param int $cookietime    The expiration time as UNIX timestamp. If 0 is provided, a session cookie is set.
1065      * @param bool $httponly        Use HttpOnly. Defaults to true. Use false to make cookie accessible by client-side scripts.
1066      */
1067  	function set_cookie($name, $cookiedata, $cookietime, $httponly = true)
1068      {
1069          global $config;
1070  
1071          $name_data = rawurlencode($config['cookie_name'] . '_' . $name) . '=' . rawurlencode($cookiedata);
1072          $expire = gmdate('D, d-M-Y H:i:s \\G\\M\\T', $cookietime);
1073          $domain = (!$config['cookie_domain'] || $config['cookie_domain'] == '127.0.0.1' || strpos($config['cookie_domain'], '.') === false) ? '' : '; domain=' . $config['cookie_domain'];
1074  
1075          header('Set-Cookie: ' . $name_data . (($cookietime) ? '; expires=' . $expire : '') . '; path=' . $config['cookie_path'] . $domain . ((!$config['cookie_secure']) ? '' : '; secure') . ';' . (($httponly) ? ' HttpOnly' : ''), false);
1076      }
1077  
1078      /**
1079      * Check for banned user
1080      *
1081      * Checks whether the supplied user is banned by id, ip or email. If no parameters
1082      * are passed to the method pre-existing session data is used.
1083      *
1084      * @param int|false        $user_id        The user id
1085      * @param mixed            $user_ips        Can contain a string with one IP or an array of multiple IPs
1086      * @param string|false    $user_email        The user email
1087      * @param bool            $return            If $return is false this routine does not return on finding a banned user,
1088      *    it outputs a relevant message and stops execution.
1089      */
1090  	function check_ban($user_id = false, $user_ips = false, $user_email = false, $return = false)
1091      {
1092          global $config, $db, $phpbb_dispatcher;
1093  
1094          if (defined('IN_CHECK_BAN') || defined('SKIP_CHECK_BAN'))
1095          {
1096              return;
1097          }
1098  
1099          $banned = false;
1100          $cache_ttl = 3600;
1101          $where_sql = array();
1102  
1103          $sql = 'SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end
1104              FROM ' . BANLIST_TABLE . '
1105              WHERE ';
1106  
1107          // Determine which entries to check, only return those
1108          if ($user_email === false)
1109          {
1110              $where_sql[] = "ban_email = ''";
1111          }
1112  
1113          if ($user_ips === false)
1114          {
1115              $where_sql[] = "(ban_ip = '' OR ban_exclude = 1)";
1116          }
1117  
1118          if ($user_id === false)
1119          {
1120              $where_sql[] = '(ban_userid = 0 OR ban_exclude = 1)';
1121          }
1122          else
1123          {
1124              $cache_ttl = ($user_id == ANONYMOUS) ? 3600 : 0;
1125              $_sql = '(ban_userid = ' . $user_id;
1126  
1127              if ($user_email !== false)
1128              {
1129                  $_sql .= " OR ban_email <> ''";
1130              }
1131  
1132              if ($user_ips !== false)
1133              {
1134                  $_sql .= " OR ban_ip <> ''";
1135              }
1136  
1137              $_sql .= ')';
1138  
1139              $where_sql[] = $_sql;
1140          }
1141  
1142          $sql .= (sizeof($where_sql)) ? implode(' AND ', $where_sql) : '';
1143          $result = $db->sql_query($sql, $cache_ttl);
1144  
1145          $ban_triggered_by = 'user';
1146          while ($row = $db->sql_fetchrow($result))
1147          {
1148              if ($row['ban_end'] && $row['ban_end'] < time())
1149              {
1150                  continue;
1151              }
1152  
1153              $ip_banned = false;
1154              if (!empty($row['ban_ip']))
1155              {
1156                  if (!is_array($user_ips))
1157                  {
1158                      $ip_banned = preg_match('#^' . str_replace('\*', '.*?', preg_quote($row['ban_ip'], '#')) . '$#i', $user_ips);
1159                  }
1160                  else
1161                  {
1162                      foreach ($user_ips as $user_ip)
1163                      {
1164                          if (preg_match('#^' . str_replace('\*', '.*?', preg_quote($row['ban_ip'], '#')) . '$#i', $user_ip))
1165                          {
1166                              $ip_banned = true;
1167                              break;
1168                          }
1169                      }
1170                  }
1171              }
1172  
1173              if ((!empty($row['ban_userid']) && intval($row['ban_userid']) == $user_id) ||
1174                  $ip_banned ||
1175                  (!empty($row['ban_email']) && preg_match('#^' . str_replace('\*', '.*?', preg_quote($row['ban_email'], '#')) . '$#i', $user_email)))
1176              {
1177                  if (!empty($row['ban_exclude']))
1178                  {
1179                      $banned = false;
1180                      break;
1181                  }
1182                  else
1183                  {
1184                      $banned = true;
1185                      $ban_row = $row;
1186  
1187                      if (!empty($row['ban_userid']) && intval($row['ban_userid']) == $user_id)
1188                      {
1189                          $ban_triggered_by = 'user';
1190                      }
1191                      else if ($ip_banned)
1192                      {
1193                          $ban_triggered_by = 'ip';
1194                      }
1195                      else
1196                      {
1197                          $ban_triggered_by = 'email';
1198                      }
1199  
1200                      // Don't break. Check if there is an exclude rule for this user
1201                  }
1202              }
1203          }
1204          $db->sql_freeresult($result);
1205  
1206          /**
1207          * Event to set custom ban type
1208          *
1209          * @event core.session_set_custom_ban
1210          * @var    bool        return                If $return is false this routine does not return on finding a banned user, it outputs a relevant message and stops execution
1211          * @var    bool        banned                Check if user already banned
1212          * @var    array|false    ban_row                Ban data
1213          * @var    string        ban_triggered_by    Method that caused ban, can be your custom method
1214          * @since 3.1.3-RC1
1215          */
1216          $ban_row = isset($ban_row) ? $ban_row : false;
1217          $vars = array('return', 'banned', 'ban_row', 'ban_triggered_by');
1218          extract($phpbb_dispatcher->trigger_event('core.session_set_custom_ban', compact($vars)));
1219  
1220          if ($banned && !$return)
1221          {
1222              global $template, $phpbb_root_path, $phpEx;
1223  
1224              // If the session is empty we need to create a valid one...
1225              if (empty($this->session_id))
1226              {
1227                  // This seems to be no longer needed? - #14971
1228  //                $this->session_create(ANONYMOUS);
1229              }
1230  
1231              // Initiate environment ... since it won't be set at this stage
1232              $this->setup();
1233  
1234              // Logout the user, banned users are unable to use the normal 'logout' link
1235              if ($this->data['user_id'] != ANONYMOUS)
1236              {
1237                  $this->session_kill();
1238              }
1239  
1240              // We show a login box here to allow founders accessing the board if banned by IP
1241              if (defined('IN_LOGIN') && $this->data['user_id'] == ANONYMOUS)
1242              {
1243                  $this->setup('ucp');
1244                  $this->data['is_registered'] = $this->data['is_bot'] = false;
1245  
1246                  // Set as a precaution to allow login_box() handling this case correctly as well as this function not being executed again.
1247                  define('IN_CHECK_BAN', 1);
1248  
1249                  login_box("index.$phpEx");
1250  
1251                  // The false here is needed, else the user is able to circumvent the ban.
1252                  $this->session_kill(false);
1253              }
1254  
1255              // Ok, we catch the case of an empty session id for the anonymous user...
1256              // This can happen if the user is logging in, banned by username and the login_box() being called "again".
1257              if (empty($this->session_id) && defined('IN_CHECK_BAN'))
1258              {
1259                  $this->session_create(ANONYMOUS);
1260              }
1261  
1262              // Determine which message to output
1263              $till_date = ($ban_row['ban_end']) ? $this->format_date($ban_row['ban_end']) : '';
1264              $message = ($ban_row['ban_end']) ? 'BOARD_BAN_TIME' : 'BOARD_BAN_PERM';
1265  
1266              $contact_link = phpbb_get_board_contact_link($config, $phpbb_root_path, $phpEx);
1267              $message = sprintf($this->lang[$message], $till_date, '<a href="' . $contact_link . '">', '</a>');
1268              $message .= ($ban_row['ban_give_reason']) ? '<br /><br />' . sprintf($this->lang['BOARD_BAN_REASON'], $ban_row['ban_give_reason']) : '';
1269              $message .= '<br /><br /><em>' . $this->lang['BAN_TRIGGERED_BY_' . strtoupper($ban_triggered_by)] . '</em>';
1270  
1271              // To circumvent session_begin returning a valid value and the check_ban() not called on second page view, we kill the session again
1272              $this->session_kill(false);
1273  
1274              // A very special case... we are within the cron script which is not supposed to print out the ban message... show blank page
1275              if (defined('IN_CRON'))
1276              {
1277                  garbage_collection();
1278                  exit_handler();
1279                  exit;
1280              }
1281  
1282              trigger_error($message);
1283          }
1284  
1285          return ($banned && $ban_row['ban_give_reason']) ? $ban_row['ban_give_reason'] : $banned;
1286      }
1287  
1288      /**
1289      * Check if ip is blacklisted
1290      * This should be called only where absolutely necessary
1291      *
1292      * Only IPv4 (rbldns does not support AAAA records/IPv6 lookups)
1293      *
1294      * @author satmd (from the php manual)
1295      * @param string         $mode    register/post - spamcop for example is ommitted for posting
1296      * @param string|false    $ip        the IPv4 address to check
1297      *
1298      * @return false if ip is not blacklisted, else an array([checked server], [lookup])
1299      */
1300  	function check_dnsbl($mode, $ip = false)
1301      {
1302          if ($ip === false)
1303          {
1304              $ip = $this->ip;
1305          }
1306  
1307          // Neither Spamhaus nor Spamcop supports IPv6 addresses.
1308          if (strpos($ip, ':') !== false)
1309          {
1310              return false;
1311          }
1312  
1313          $dnsbl_check = array(
1314              'sbl.spamhaus.org'    => 'http://www.spamhaus.org/query/bl?ip=',
1315          );
1316  
1317          if ($mode == 'register')
1318          {
1319              $dnsbl_check['bl.spamcop.net'] = 'http://spamcop.net/bl.shtml?';
1320          }
1321  
1322          if ($ip)
1323          {
1324              $quads = explode('.', $ip);
1325              $reverse_ip = $quads[3] . '.' . $quads[2] . '.' . $quads[1] . '.' . $quads[0];
1326  
1327              // Need to be listed on all servers...
1328              $listed = true;
1329              $info = array();
1330  
1331              foreach ($dnsbl_check as $dnsbl => $lookup)
1332              {
1333                  if (phpbb_checkdnsrr($reverse_ip . '.' . $dnsbl . '.', 'A') === true)
1334                  {
1335                      $info = array($dnsbl, $lookup . $ip);
1336                  }
1337                  else
1338                  {
1339                      $listed = false;
1340                  }
1341              }
1342  
1343              if ($listed)
1344              {
1345                  return $info;
1346              }
1347          }
1348  
1349          return false;
1350      }
1351  
1352      /**
1353      * Check if URI is blacklisted
1354      * This should be called only where absolutly necessary, for example on the submitted website field
1355      * This function is not in use at the moment and is only included for testing purposes, it may not work at all!
1356      * This means it is untested at the moment and therefore commented out
1357      *
1358      * @param string $uri URI to check
1359      * @return true if uri is on blacklist, else false. Only blacklist is checked (~zero FP), no grey lists
1360      function check_uribl($uri)
1361      {
1362          // Normally parse_url() is not intended to parse uris
1363          // We need to get the top-level domain name anyway... change.
1364          $uri = parse_url($uri);
1365  
1366          if ($uri === false || empty($uri['host']))
1367          {
1368              return false;
1369          }
1370  
1371          $uri = trim($uri['host']);
1372  
1373          if ($uri)
1374          {
1375              // One problem here... the return parameter for the "windows" method is different from what
1376              // we expect... this may render this check useless...
1377              if (phpbb_checkdnsrr($uri . '.multi.uribl.com.', 'A') === true)
1378              {
1379                  return true;
1380              }
1381          }
1382  
1383          return false;
1384      }
1385      */
1386  
1387      /**
1388      * Set/Update a persistent login key
1389      *
1390      * This method creates or updates a persistent session key. When a user makes
1391      * use of persistent (formerly auto-) logins a key is generated and stored in the
1392      * DB. When they revisit with the same key it's automatically updated in both the
1393      * DB and cookie. Multiple keys may exist for each user representing different
1394      * browsers or locations. As with _any_ non-secure-socket no passphrase login this
1395      * remains vulnerable to exploit.
1396      */
1397  	function set_login_key($user_id = false, $key = false, $user_ip = false)
1398      {
1399          global $config, $db;
1400  
1401          $user_id = ($user_id === false) ? $this->data['user_id'] : $user_id;
1402          $user_ip = ($user_ip === false) ? $this->ip : $user_ip;
1403          $key = ($key === false) ? (($this->cookie_data['k']) ? $this->cookie_data['k'] : false) : $key;
1404  
1405          $key_id = unique_id(hexdec(substr($this->session_id, 0, 8)));
1406  
1407          $sql_ary = array(
1408              'key_id'        => (string) md5($key_id),
1409              'last_ip'        => (string) $this->ip,
1410              'last_login'    => (int) time()
1411          );
1412  
1413          if (!$key)
1414          {
1415              $sql_ary += array(
1416                  'user_id'    => (int) $user_id
1417              );
1418          }
1419  
1420          if ($key)
1421          {
1422              $sql = 'UPDATE ' . SESSIONS_KEYS_TABLE . '
1423                  SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
1424                  WHERE user_id = ' . (int) $user_id . "
1425                      AND key_id = '" . $db->sql_escape(md5($key)) . "'";
1426          }
1427          else
1428          {
1429              $sql = 'INSERT INTO ' . SESSIONS_KEYS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
1430          }
1431          $db->sql_query($sql);
1432  
1433          $this->cookie_data['k'] = $key_id;
1434  
1435          return false;
1436      }
1437  
1438      /**
1439      * Reset all login keys for the specified user
1440      *
1441      * This method removes all current login keys for a specified (or the current)
1442      * user. It will be called on password change to render old keys unusable
1443      */
1444  	function reset_login_keys($user_id = false)
1445      {
1446          global $config, $db;
1447  
1448          $user_id = ($user_id === false) ? (int) $this->data['user_id'] : (int) $user_id;
1449  
1450          $sql = 'DELETE FROM ' . SESSIONS_KEYS_TABLE . '
1451              WHERE user_id = ' . (int) $user_id;
1452          $db->sql_query($sql);
1453  
1454          // If the user is logged in, update last visit info first before deleting sessions
1455          $sql = 'SELECT session_time, session_page
1456              FROM ' . SESSIONS_TABLE . '
1457              WHERE session_user_id = ' . (int) $user_id . '
1458              ORDER BY session_time DESC';
1459          $result = $db->sql_query_limit($sql, 1);
1460          $row = $db->sql_fetchrow($result);
1461          $db->sql_freeresult($result);
1462  
1463          if ($row)
1464          {
1465              $sql = 'UPDATE ' . USERS_TABLE . '
1466                  SET user_lastvisit = ' . (int) $row['session_time'] . ", user_lastpage = '" . $db->sql_escape($row['session_page']) . "'
1467                  WHERE user_id = " . (int) $user_id;
1468              $db->sql_query($sql);
1469          }
1470  
1471          // Let's also clear any current sessions for the specified user_id
1472          // If it's the current user then we'll leave this session intact
1473          $sql_where = 'session_user_id = ' . (int) $user_id;
1474          $sql_where .= ($user_id === (int) $this->data['user_id']) ? " AND session_id <> '" . $db->sql_escape($this->session_id) . "'" : '';
1475  
1476          $sql = 'DELETE FROM ' . SESSIONS_TABLE . "
1477              WHERE $sql_where";
1478          $db->sql_query($sql);
1479  
1480          // We're changing the password of the current user and they have a key
1481          // Lets regenerate it to be safe
1482          if ($user_id === (int) $this->data['user_id'] && $this->cookie_data['k'])
1483          {
1484              $this->set_login_key($user_id);
1485          }
1486      }
1487  
1488  
1489      /**
1490      * Check if the request originated from the same page.
1491      * @param bool $check_script_path If true, the path will be checked as well
1492      */
1493  	function validate_referer($check_script_path = false)
1494      {
1495          global $config, $request;
1496  
1497          // no referer - nothing to validate, user's fault for turning it off (we only check on POST; so meta can't be the reason)
1498          if (empty($this->referer) || empty($this->host))
1499          {
1500              return true;
1501          }
1502  
1503          $host = htmlspecialchars($this->host);
1504          $ref = substr($this->referer, strpos($this->referer, '://') + 3);
1505  
1506          if (!(stripos($ref, $host) === 0) && (!$config['force_server_vars'] || !(stripos($ref, $config['server_name']) === 0)))
1507          {
1508              return false;
1509          }
1510          else if ($check_script_path && rtrim($this->page['root_script_path'], '/') !== '')
1511          {
1512              $ref = substr($ref, strlen($host));
1513              $server_port = $request->server('SERVER_PORT', 0);
1514  
1515              if ($server_port !== 80 && $server_port !== 443 && stripos($ref, ":$server_port") === 0)
1516              {
1517                  $ref = substr($ref, strlen(":$server_port"));
1518              }
1519  
1520              if (!(stripos(rtrim($ref, '/'), rtrim($this->page['root_script_path'], '/')) === 0))
1521              {
1522                  return false;
1523              }
1524          }
1525  
1526          return true;
1527      }
1528  
1529  
1530  	function unset_admin()
1531      {
1532          global $db;
1533          $sql = 'UPDATE ' . SESSIONS_TABLE . '
1534              SET session_admin = 0
1535              WHERE session_id = \'' . $db->sql_escape($this->session_id) . '\'';
1536          $db->sql_query($sql);
1537      }
1538  
1539      /**
1540      * Update the session data
1541      *
1542      * @param array $session_data associative array of session keys to be updated
1543      * @param string $session_id optional session_id, defaults to current user's session_id
1544      */
1545  	public function update_session($session_data, $session_id = null)
1546      {
1547          global $db, $phpbb_dispatcher;
1548  
1549          $session_id = ($session_id) ? $session_id : $this->session_id;
1550  
1551          $sql = 'UPDATE ' . SESSIONS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $session_data) . "
1552              WHERE session_id = '" . $db->sql_escape($session_id) . "'";
1553          $db->sql_query($sql);
1554  
1555          /**
1556          * Event to send update session information to extension
1557          * Read-only event
1558          *
1559          * @event core.update_session_after
1560          * @var    array        session_data                Associative array of session keys to be updated
1561          * @var    string        session_id                current user's session_id
1562          * @since 3.1.6-RC1
1563          */
1564          $vars = array('session_data', 'session_id');
1565          extract($phpbb_dispatcher->trigger_event('core.update_session_after', compact($vars)));
1566      }
1567  
1568  	public function update_session_infos()
1569      {
1570          global $config, $db, $request;
1571  
1572          // No need to update if it's a new session. Informations are already inserted by session_create()
1573          if (isset($this->data['session_created']) && $this->data['session_created'])
1574          {
1575              return;
1576          }
1577  
1578          // Only update session DB a minute or so after last update or if page changes
1579          if ($this->time_now - $this->data['session_time'] > 60 || ($this->update_session_page && $this->data['session_page'] != $this->page['page']))
1580          {
1581              $sql_ary = array('session_time' => $this->time_now);
1582  
1583              // Do not update the session page for ajax requests, so the view online still works as intended
1584              if ($this->update_session_page && !$request->is_ajax())
1585              {
1586                  $sql_ary['session_page'] = substr($this->page['page'], 0, 199);
1587                  $sql_ary['session_forum_id'] = $this->page['forum'];
1588              }
1589  
1590              $db->sql_return_on_error(true);
1591  
1592              $this->update_session($sql_ary);
1593  
1594              $db->sql_return_on_error(false);
1595  
1596              $this->data = array_merge($this->data, $sql_ary);
1597  
1598              if ($this->data['user_id'] != ANONYMOUS && isset($config['new_member_post_limit']) && $this->data['user_new'] && $config['new_member_post_limit'] <= $this->data['user_posts'])
1599              {
1600                  $this->leave_newly_registered();
1601              }
1602          }
1603      }
1604  }


Generated: Sun Feb 19 19:52:41 2017 Cross-referenced by PHPXref 0.7.1