$board_config['limit_load'] ) { message_die(GENERAL_MESSAGE, 'Board_unavailable', 'Information'); } } } if ( !empty($session_id) ) { // // session_id exists so go ahead and attempt to grab all data in preparation // $sql = "SELECT u.*, s.* FROM " . SESSIONS_TABLE . " s, " . USERS_TABLE . " u WHERE s.session_id = '$session_id' AND u.user_id = s.session_user_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(CRITICAL_ERROR, 'Error doing DB query userdata row fetch', '', __LINE__, __FILE__, $sql); } $this->userdata = $db->sql_fetchrow($result); // // Did the session exist in the DB? // if ( isset($this->userdata['user_id']) ) { // // Do not check IP assuming equivalence, if IPv4 we'll check only first 24 // bits ... I've been told (by vHiker) this should alleviate problems with // load balanced et al proxies while retaining some reliance on IP security. // $ip_check_s = explode('.', $this->userdata['session_ip']); $ip_check_u = explode('.', $user_ip); if ( $ip_check_s[0].'.'.$ip_check_s[1].'.'.$ip_check_s[2] == $ip_check_u[0].'.'.$ip_check_u[1].'.'.$ip_check_u[2] ) { $SID = '?sid=' . ( ( $sessionmethod == SESSION_METHOD_GET ) ? $session_id : '' ); // // Only update session DB a minute or so after last update or if page changes // if ( ( $current_time - $this->userdata['session_time'] > 60 || $this->userdata['session_page'] != $this_page ) && $update ) { $sql = "UPDATE " . SESSIONS_TABLE . " SET session_time = $current_time, session_page = '$this_page' WHERE session_id = '" . $this->userdata['session_id'] . "'"; if ( !$db->sql_query($sql) ) { message_die(CRITICAL_ERROR, 'Error updating sessions table', '', __LINE__, __FILE__, $sql); } // // Garbage collection ... remove old sessions updating user information // if necessary // if ( $current_time - $board_config['session_gc'] > $board_config['session_last_gc'] ) { $this->gc($current_time); } setcookie($board_config['cookie_name'] . '_data', serialize($sessiondata), $current_time + 31536000, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); setcookie($board_config['cookie_name'] . '_sid', $session_id, 0, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); } $this->config(); return $this->userdata; } } } // // If we reach here then no (valid) session exists. So we'll create a new one, // using the cookie user_id if available to pull basic user prefs. // $autologin = ( isset($sessiondata['autologinid']) ) ? $sessiondata['autologinid'] : ''; $user_id = ( isset($sessiondata['userid']) ) ? $sessiondata['userid'] : ANONYMOUS; // // Limit 5 minute sessions // $sql = "SELECT COUNT(*) AS sessions FROM " . SESSIONS_TABLE . " WHERE session_time >= " . ( $current_time - 3600 ); if ( !($result = $db->sql_query($sql)) ) { message_die(CRITICAL_ERROR, 'Could not obtain ban information', '', __LINE__, __FILE__, $sql); } $row = $db->sql_fetchrow[$result]; if ( intval($board_config['active_sessions']) && $row['sessions'] >= $board_config['active_sessions'] ) { message_die(GENERAL_MESSAGE, 'Board_unavailable', 'Information'); } $sql = "SELECT * FROM " . USERS_TABLE . " WHERE user_id = $user_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(CRITICAL_ERROR, 'Could not obtain lastvisit data from user table', '', __LINE__, __FILE__, $sql); } $this->userdata = $db->sql_fetchrow($result); // // Check autologin request, is it valid? // if ( $this->userdata['user_password'] != $autologin || !$this->userdata['user_active'] || $user_id == ANONYMOUS ) { $autologin = ''; $this->userdata['user_id'] = $user_id = ANONYMOUS; } $user_ip_parts = explode('.', $user_ip); $sql = "SELECT ban_ip, ban_userid, ban_email FROM " . BANLIST_TABLE . " WHERE ban_ip IN ( '" . $user_ip_parts[1] . ".', '" . $user_ip_parts[1] . "." . $user_ip_parts[2] . ".', '" . $user_ip_parts[1] . "." . $user_ip_parts[2] . "." . $user_ip_parts[3] . ".', '" . $user_ip_parts[1] . "." . $user_ip_parts[2] . "." . $user_ip_parts[3] . "." . $user_ip_parts[4] . "') OR ban_userid = $user_id"; if ( $user_id != ANONYMOUS ) { $sql .= " OR ban_email LIKE '" . str_replace('\\\'', '\\\'\\\'', $this->userdata['user_email']) . "' OR ban_email LIKE '" . substr(str_replace('\\\'', '\\\'\\\'', $this->userdata['user_email']), strpos(str_replace('\\\'', '\\\'\\\'', $this->userdata['user_email']), '@')) . "'"; } if ( !($result = $db->sql_query($sql)) ) { message_die(CRITICAL_ERROR, 'Could not obtain ban information', '', __LINE__, __FILE__, $sql); } if ( $ban_info = $db->sql_fetchrow($result) ) { if ( $ban_info['ban_ip'] || $ban_info['ban_userid'] || $ban_info['ban_email'] ) { message_die(CRITICAL_MESSAGE, 'You_been_banned'); } } // // Create or update the session // $sql = "UPDATE " . SESSIONS_TABLE . " SET session_user_id = $user_id, session_start = $current_time, session_time = $current_time, session_browser = '$session_browser', session_page = '$this_page' WHERE session_id = '$session_id'"; if ( !$db->sql_query($sql) || !$db->sql_affectedrows() ) { $session_id = md5(uniqid($user_ip)); $sql = "INSERT INTO " . SESSIONS_TABLE . " (session_id, session_user_id, session_start, session_time, session_ip, session_browser, session_page) VALUES ('$session_id', $user_id, $current_time, $current_time, '$user_ip', '$session_browser', '$this_page')"; if ( !$db->sql_query($sql) ) { message_die(CRITICAL_ERROR, 'Error creating new session', '', __LINE__, __FILE__, $sql); } } $SID = '?sid=' . ( ( $sessionmethod == SESSION_METHOD_GET ) ? $session_id : '' ); $sessiondata['autologinid'] = ( $autologin && $user_id != ANONYMOUS ) ? $autologin : ''; $sessiondata['userid'] = $user_id; setcookie($board_config['cookie_name'] . '_data', serialize($sessiondata), $current_time + 31536000, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); setcookie($board_config['cookie_name'] . '_sid', $session_id, 0, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); $this->userdata['session_id'] = $session_id; $this->config(); return $this->userdata; } function destroy($userdata) { global $SID, $db, $board_config, $user_ip; global $HTTP_SERVER_VARS, $HTTP_ENV_VARS, $HTTP_COOKIE_VARS, $HTTP_GET_VARS; if ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_sid']) ) { $session_id = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_sid']) ) ? $HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_sid'] : ''; } else { $session_id = ( isset($HTTP_GET_VARS['sid']) ) ? $HTTP_GET_VARS['sid'] : ''; } // // Delete existing session, update last visit info first! // $sql = "UPDATE " . USERS_TABLE . " SET user_lastvisit = " . $userdata['session_time'] . ", user_session_page = '" . $userdata['session_page'] . "' WHERE user_id = " . $userdata['user_id']; if ( !$db->sql_query($sql) ) { message_die(CRITICAL_ERROR, 'Could not update user session info', '', __LINE__, __FILE__, $sql); } $sql = "DELETE FROM " . SESSIONS_TABLE . " WHERE session_id = '" . $userdata['session_id'] . "' AND session_user_id = " . $userdata['user_id']; if ( !$db->sql_query($sql) ) { message_die(CRITICAL_ERROR, 'Error removing user session', '', __LINE__, __FILE__, $sql); } $SID = '?sid='; setcookie($board_config['cookie_name'] . '_data', '', $current_time - 31536000, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); setcookie($board_config['cookie_name'] . '_sid', '', $current_time - 31536000, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); return true; } function gc($current_time) { global $db, $board_config, $user_ip; $sql = "SELECT * FROM " . SESSIONS_TABLE . " WHERE session_time < " . ( $current_time - $board_config['session_length'] ); if ( !($result = $db->sql_query($sql)) ) { message_die(CRITICAL_ERROR, 'Could not obtain expired session list', '', __LINE__, __FILE__, $sql); } $del_session_id = ''; while ( $row = $db->sql_fetchrow($result) ) { if ( $row['session_logged_in'] ) { $sql = "UPDATE " . USERS_TABLE . " SET user_lastvisit = " . $row['session_time'] . ", user_session_page = '" . $row['session_page'] . "' WHERE user_id = " . $row['session_user_id']; if ( !$db->sql_query($sql) ) { message_die(CRITICAL_ERROR, 'Could not update user session info', '', __LINE__, __FILE__, $sql); } } $del_session_id .= ( ( $del_session_id != '' ) ? ', ' : '' ) . '\'' . $row['session_id'] . '\''; } if ( $del_session_id != '' ) { // // Delete expired sessions // $sql = "DELETE FROM " . SESSIONS_TABLE . " WHERE session_id IN ($del_session_id)"; if ( !$db->sql_query($sql) ) { message_die(CRITICAL_ERROR, 'Error clearing sessions table', '', __LINE__, __FILE__, $sql); } } $sql = "UPDATE " . CONFIG_TABLE . " SET config_value = '$current_time' WHERE config_name = 'session_last_gc'"; if ( !$db->sql_query($sql) ) { message_die(CRITICAL_ERROR, 'Could not update session gc time', '', __LINE__, __FILE__, $sql); } return; } function config() { global $db, $template, $lang, $board_config, $theme, $images; global $phpEx, $phpbb_root_path; if ( $this->userdata['user_id'] != ANONYMOUS ) { if ( !empty($this->userdata['user_lang'])) { $board_config['default_lang'] = $this->userdata['user_lang']; } if ( !empty($this->userdata['user_dateformat']) ) { $board_config['default_dateformat'] = $this->userdata['user_dateformat']; } if ( isset($this->userdata['user_timezone']) ) { $board_config['board_timezone'] = $this->userdata['user_timezone']; } } if ( !file_exists($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.'.$phpEx) ) { $board_config['default_lang'] = 'english'; } include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.' . $phpEx); if ( defined('IN_ADMIN') ) { if( !file_exists($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin.'.$phpEx) ) { $board_config['default_lang'] = 'english'; } include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin.' . $phpEx); } // // Set up style // $style = ( !$board_config['override_user_style'] && $this->userdata['user_id'] != ANONYMOUS && $this->userdata['user_style'] > 0 )? $this->userdata['user_style'] : $board_config['default_style']; $sql = "SELECT * FROM " . THEMES_TABLE . " WHERE themes_id = $style"; if ( !($result = $db->sql_query($sql)) ) { message_die(CRITICAL_ERROR, 'Could not query database for theme info'); } if ( !($theme = $db->sql_fetchrow($result)) ) { message_die(CRITICAL_ERROR, "Could not get theme data for themes_id [$style]"); } $template_path = 'templates/' ; $template_name = $theme['template_name'] ; $template = new Template($phpbb_root_path . $template_path . $template_name); if ( $template ) { $current_template_path = $template_path . $template_name; @include($phpbb_root_path . $template_path . $template_name . '/' . $template_name . '.cfg'); if ( !defined('TEMPLATE_CONFIG') ) { message_die(CRITICAL_ERROR, "Could not open $template_name template config file", '', __LINE__, __FILE__); } $img_lang = ( file_exists($current_template_path . '/images/lang_' . $board_config['default_lang']) ) ? $board_config['default_lang'] : 'english'; while( list($key, $value) = @each($images) ) { if ( !is_array($value) ) { $images[$key] = str_replace('{LANG}', 'lang_' . $img_lang, $value); } } } return; } } // // Note this doesn't use the prefetch at present and is very // incomplete ... purely for testing ... will be keeping my // eye of 'other products' to ensure these things don't // mysteriously appear elsewhere, think up your own solutions! // class auth { var $acl; function auth($userdata) { global $db; $sql = "SELECT ag.forum_id, ag.auth_allow_deny, ao.auth_option FROM phpbb_user_group ug, phpbb_auth_groups ag, phpbb_auth_options ao WHERE ug.user_id = " . $userdata['user_id'] . " AND ag.group_id = ug.group_id AND ao.auth_option_id = ag.auth_option_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Failed obtaining forum access control lists', '', __LINE__, __FILE__, $sql); } if ( $row = $db->sql_fetchrow($result) ) { do { list($option_main, $option_type) = explode('_', $row['auth_option']); $this->acl[$row['forum_id']][$option_main][$option_type] = $row['auth_allow_deny']; } while ( $row = $db->sql_fetchrow($result) ); } $db->sql_freeresult($result); $sql = "SELECT au.forum_id, au.auth_allow_deny, ao.auth_option FROM phpbb_auth_users au, phpbb_auth_options ao WHERE au.user_id = " . $userdata['user_id'] . " AND ao.auth_option_id = au.auth_option_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Failed obtaining forum access control lists', '', __LINE__, __FILE__, $sql); } if ( $row = $db->sql_fetchrow($result) ) { do { list($option_main, $option_type) = explode('_', $row['auth_option']); $this->acl[$row['forum_id']][$option_main][$option_type] = ( isset($this->acl[$row['forum_id']][$option_main][$option_type]) ) ? $this->acl[$row['forum_id']][$option_main][$option_type] && $row['auth_allow_deny'] : $row['auth_allow_deny']; } while ( $row = $db->sql_fetchrow($result) ); } $db->sql_freeresult($result); return; } function get_acl($forum_id = false, $auth_main = false, $auth_type = false) { if ( !$forum_id ) { if ( !$auth_type && is_array($this->acl) ) { @reset($this->acl); while ( list(, $value1) = @each($this->acl) ) { while ( list(, $value2) = @each($value1) ) { while ( list(, $value3) = @each($value2) ) { if ( $value3 ) { return true; } } } } return false; } else if ( !$auth_main && is_array($this->acl) ) { @reset($this->acl); while ( list(, $value1) = each($this->acl) ) { while ( list(, $value2) = each($value1) ) { if ( $value2[$auth_type] ) { return true; } } } return false; } else { return $this->acl; } } else if ( $auth_main && $auth_type ) { return $this->acl[$forum_id][$auth_main][$auth_type]; } else if ( !$auth_type && is_array($this->acl[$forum_id][$auth_main]) ) { @reset($this->acl); while ( list(, $value) = @each($this->acl[$forum_id][$auth_main]) ) { if ( $value ) { return true; } } return false; } else if ( !$auth_main && is_array($this->acl[$forum_id]) ) { @reset($this->acl); while ( list(, $value) = each($this->acl[$forum_id]) ) { if ( $value[$auth_type] ) { return true; } } return false; } else { return $this->acl[$forum_id]; } } function set_acl($ug_data, $forum_id = false, $auth_list = false, $dependencies = false) { global $db; $dependencies = array_merge($dependencies, array( 'admin' => 'mod', 'mod' => 'forum') ); } } // // Centralised login? May stay, may not ... depends if needed // function login($username, $password) { global $SID, $db, $board_config, $lang, $user_ip, $phpEx; $result = false; $sql = "SELECT user_id, username, user_password, user_email, user_active, user_level FROM " . USERS_TABLE . " WHERE username = '" . str_replace("\'", "''", $username) . "'"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error in obtaining userdata', '', __LINE__, __FILE__, $sql); } if ( $row = $db->sql_fetchrow($result) ) { if ( $row['user_level'] != ADMIN && $board_config['board_disable'] ) { header($header_location . "index.$phpEx$SID"); exit; } if ( $board_config['ldap_enable'] && extension_loaded('ldap') ) { if ( !($ldap_id = @ldap_connect($board_config['ldap_hostname'])) ) { // // FINISH // @ldap_unbind($ldap_id); } } else { if ( md5($password) == $row['user_password'] && $row['user_active'] ) { $autologin = ( isset($HTTP_POST_VARS['autologin']) ) ? md5($password) : ''; $user_ip_parts = explode('.', $user_ip); $sql = "SELECT ban_ip, ban_userid, ban_email FROM " . BANLIST_TABLE . " WHERE ban_ip IN ( '" . $user_ip_parts[0] . ".', '" . $user_ip_parts[0] . "." . $user_ip_parts[1] . ".', '" . $user_ip_parts[0] . "." . $user_ip_parts[1] . "." . $user_ip_parts[2] . ".', '" . $user_ip_parts[0] . "." . $user_ip_parts[1] . "." . $user_ip_parts[2] . "." . $user_ip_parts[3] . "') OR ban_userid = " . $row['user_id']; if ( $user_id != ANONYMOUS ) { $sql .= " OR ban_email LIKE '" . str_replace('\\\'', '\\\'\\\'', $row['user_email']) . "' OR ban_email LIKE '" . substr(str_replace('\\\'', '\\\'\\\'', $row['user_email']), strpos(str_replace('\\\'', '\\\'\\\'', $row['user_email']), '@')) . "'"; } if ( !($result = $db->sql_query($sql)) ) { message_die(CRITICAL_ERROR, 'Could not obtain ban information', '', __LINE__, __FILE__, $sql); } if ( $ban_info = $db->sql_fetchrow($result) ) { if ( $ban_info['ban_ip'] || $ban_info['ban_userid'] || $ban_info['ban_email'] ) { message_die(CRITICAL_MESSAGE, 'You_been_banned'); } } $session_browser = ( !empty($HTTP_SERVER_VARS['HTTP_USER_AGENT']) ) ? $HTTP_SERVER_VARS['HTTP_USER_AGENT'] : $HTTP_ENV_VARS['HTTP_USER_AGENT']; $current_time = time(); // // Update the session // $sql = "UPDATE " . SESSIONS_TABLE . " SET session_user_id = " . $row['user_id'] . ", session_start = $current_time, session_time = $current_time, session_browser = '$session_browser', session_page = '' WHERE session_id = '" . $userdata['session_id'] . "'"; if ( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not update session post-login', '', __LINE__, __FILE__, $sql); } $sessiondata['autologinid'] = ( $autologin && $user_id != ANONYMOUS ) ? $autologin : ''; $sessiondata['userid'] = $row['user_id']; setcookie($board_config['cookie_name'] . '_data', serialize($sessiondata), $current_time + 31536000, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); setcookie($board_config['cookie_name'] . '_sid', $userdata['session_id'], 0, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); $result = true; } } } return $result; } // // // This routine is dead instead we just set a URL$SID for // appropriate URLs rather than this append stuff // function append_sid($url, $non_html_amp = false) { return $url; } ?>