session_id = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_sid']) ) ? $HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_sid'] : ''; $SID = '?sid='; } else { $sessiondata = ''; $this->session_id = ( isset($HTTP_GET_VARS['sid']) ) ? $HTTP_GET_VARS['sid'] : ''; $SID = '?sid=' . $this->session_id; } // // Load limit check (if applicable) // if ( !empty($board_config['limit_load']) && file_exists('/proc/loadavg') ) { if ( $load = @file('/proc/loadavg') ) { list($this->load) = explode(' ', $load[0]); if ( $this->load > $board_config['limit_load'] ) { message_die(MESSAGE, 'Board_unavailable'); } } } // // session_id exists so go ahead and attempt to grab all data in preparation // if ( !empty($this->session_id) ) { $sql = "SELECT u.*, s.* FROM " . SESSIONS_TABLE . " s, " . USERS_TABLE . " u WHERE s.session_id = '" . $this->session_id . "' AND u.user_id = s.session_user_id"; $result = $db->sql_query($sql); $userdata = $db->sql_fetchrow($result); $db->sql_freeresult($result); // // Did the session exist in the DB? // if ( isset($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('.', $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] ) { // // Only update session DB a minute or so after last update or if page changes // if ( ( $current_time - $userdata['session_time'] > 60 || $userdata['session_page'] != $user_page ) && $update ) { $sql = "UPDATE " . SESSIONS_TABLE . " SET session_time = $current_time, session_page = '$user_page' WHERE session_id = '" . $this->session_id . "'"; $db->sql_query($sql); // // Garbage collection ... remove old sessions updating user information // if necessary. It means (potentially) lots of queries but only infrequently // if ( $current_time - $board_config['session_gc'] > $board_config['session_last_gc'] ) { $this->gc($current_time); } } return $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']) ) ? intval($sessiondata['userid']) : ANONYMOUS; return $this->create($user_id, $autologin, $user_page, $user_browser); } // // Create a new session // function create(&$user_id, &$autologin, &$user_page, &$user_browser) { global $SID, $db, $board_config, $user_ip; $sessiondata = array(); $current_time = time(); // // Limit sessions in 1 minute period // $sql = "SELECT COUNT(*) AS sessions FROM " . SESSIONS_TABLE . " WHERE session_time >= " . ( $current_time - 60 ); $result = $db->sql_query($sql); $row = $db->sql_fetchrow[$result]; $db->sql_freeresult($result); if ( intval($board_config['active_sessions']) && intval($row['sessions']) > intval($board_config['active_sessions']) ) { message_die(MESSAGE, 'Board_unavailable'); } // // Grab user data // $sql = "SELECT * FROM " . USERS_TABLE . " WHERE user_id = $user_id"; $result = $db->sql_query($sql); $userdata = $db->sql_fetchrow($result); $db->sql_freeresult($result); // // Check autologin request, is it valid? // if ( $userdata['user_password'] != $autologin || !$userdata['user_active'] || $user_id == ANONYMOUS ) { $autologin = ''; $userdata['user_id'] = $user_id = ANONYMOUS; } $sql = "SELECT ban_ip, ban_userid, ban_email FROM " . BANLIST_TABLE . " WHERE ban_end >= $current_time OR ban_end = 0"; $result = $db->sql_query($sql); if ( $row = $db->sql_fetchrow($result) ) { do { if ( ( $row['user_id'] == $userdata['user_id'] || ( $row['ban_ip'] && preg_match('#^' . str_replace('*', '.*?', $row['ban_ip']) . '$#i', $user_ip) ) || ( $row['ban_email'] && preg_match('#^' . str_replace('*', '.*?', $row['ban_email']) . '$#i', $userdata['user_email']) ) ) && !$userdata['user_founder'] ) { message_die(MESSAGE, 'You_been_banned'); } } while ( $row = $db->sql_fetchrow($result) ); } $db->sql_freeresult($result); // // Create or update the session // $db->sql_return_on_error(true); $sql = "UPDATE " . SESSIONS_TABLE . " SET session_user_id = $user_id, session_start = $current_time, session_time = $current_time, session_browser = '$user_browser', session_page = '$user_page' WHERE session_id = '" . $this->session_id . "'"; if ( !($result = $db->sql_query($sql)) || !$db->sql_affectedrows() ) { $db->sql_return_on_error(false); $this->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 ('" . $this->session_id . "', $user_id, $current_time, $current_time, '$user_ip', '$user_browser', '$user_page')"; $db->sql_query($sql); } $db->sql_return_on_error(false); $userdata['session_id'] = $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', $this->session_id, 0, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); $SID = '?sid=' . $this->session_id; return $userdata; } // // Destroy a session // function destroy(&$userdata) { global $SID, $db, $board_config; global $HTTP_COOKIE_VARS, $HTTP_GET_VARS; $current_time = time(); 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']); // // 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']; $db->sql_query($sql); $sql = "DELETE FROM " . SESSIONS_TABLE . " WHERE session_id = '" . $this->session_id . "' AND session_user_id = " . $userdata['user_id']; $db->sql_query($sql); $SID = '?sid='; $this->session_id = ''; return true; } // // Garbage collection // function gc(&$current_time) { global $db, $board_config, $user_ip; $sql = "SELECT * FROM " . SESSIONS_TABLE . " WHERE session_time < " . ( $current_time - $board_config['session_length'] ) . " LIMIT 10"; $result = $db->sql_query($sql); $del_session_id = ''; while ( $row = $db->sql_fetchrow($result) ) { if ( $row['user_id'] != ANONYMOUS ) { $sql = "UPDATE " . USERS_TABLE . " SET user_lastvisit = " . $row['session_time'] . ", user_session_page = '" . $row['session_page'] . "' WHERE user_id = " . $row['session_user_id']; $db->sql_query($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)"; $db->sql_query($sql); } $sql = "UPDATE " . CONFIG_TABLE . " SET config_value = '$current_time' WHERE config_name = 'session_last_gc'"; $db->sql_query($sql); return; } // // // function configure($userdata, $lang_set = false) { global $db, $template, $lang, $board_config, $theme, $images; global $phpEx, $phpbb_root_path; if ( $userdata['user_id'] != ANONYMOUS ) { $board_config['default_lang'] = $userdata['user_lang']; $board_config['default_dateformat'] = $userdata['user_dateformat']; $board_config['board_timezone'] = $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'] && $userdata['user_id'] != ANONYMOUS ) ? $userdata['user_style'] : $board_config['default_style']; $sql = "SELECT t.template_path, t.poll_length, t.pm_box_length, c.css_data, c.css_external, i.* FROM " . STYLES_TABLE . " s, " . STYLES_TPL_TABLE . " t, " . STYLES_CSS_TABLE . " c, " . STYLES_IMAGE_TABLE . " i WHERE s.style_id = $style AND t.template_id = s.template_id AND c.theme_id = s.style_id AND i.imageset_id = s.imageset_id"; $result = $db->sql_query($sql); if ( !($theme = $db->sql_fetchrow($result)) ) { message_die(ERROR, 'Could not get style data [ id ' . $style . ' ]'); } if ( $template = new Template($theme['template_path']) ) { $img_lang = ( file_exists('imageset/' . $theme['imageset_path'] . '/lang_' . $board_config['default_lang']) ) ? $board_config['default_lang'] : 'english'; $i10n = array('post_new', 'post_locked', 'post_pm', 'reply_new', 'reply_pm', 'reply_locked', 'icon_quote', 'icon_edit', 'icon_search', 'icon_profile', 'icon_pm', 'icon_email', 'icon_www', 'icon_icq', 'icon_aim', 'icon_yim', 'icon_msnm', 'icon_delete', 'icon_ip', 'icon_no_email', 'icon_no_www', 'icon_no_icq', 'icon_no_aim', 'icon_no_yim', 'icon_no_msnm'); for($i = 0; $i < sizeof($i10n); $i++) { $theme[$i10n[$i]] = str_replace('{LANG}', 'lang_' . $img_lang, $theme[$i10n[$i]]); } } return; } } // // Will be keeping my eye of 'other products' to ensure these things don't // mysteriously appear elsewhere, think up your own solutions! // class acl { var $founder = false; var $acl = false; function acl(&$userdata, $forum_id = false, $extra_options = false) { global $db; if ( !($this->founder = $userdata['user_founder']) ) { $and_sql = "ao.auth_option LIKE 'list'"; if ( $extra_options ) { $tmp_ary = explode(',', $extra_options); foreach ( $tmp_ary as $option ) { $and_sql .= " OR ao.auth_option LIKE '" . trim($option) . "'"; } } $and_sql = ( !$forum_id ) ? $and_sql : "( a.forum_id = $forum_id ) OR ( a.forum_id <> $forum_id AND ( ao.auth_option LIKE 'list' OR ao.auth_type LIKE 'mod' ) )"; $and_sql .= " OR ao.auth_type LIKE 'admin'"; $sql = "SELECT a.forum_id, a.auth_allow_deny, ao.auth_type, ao.auth_option FROM " . ACL_GROUPS_TABLE . " a, " . ACL_OPTIONS_TABLE . " ao, " . USER_GROUP_TABLE . " ug WHERE ug.user_id = " . $userdata['user_id'] . " AND a.group_id = ug.group_id AND ao.auth_option_id = a.auth_option_id AND ( $and_sql )"; $result = $db->sql_query($sql); if ( $row = $db->sql_fetchrow($result) ) { do { switch ( $this->acl[$row['forum_id']][$row['auth_type']][$row['auth_option']] ) { case ACL_PERMIT: case ACL_DENY: case ACL_PREVENT: break; default: $this->acl[$row['forum_id']][$row['auth_type']][$row['auth_option']] = $row['auth_allow_deny']; } } while ( $row = $db->sql_fetchrow($result) ); } $db->sql_freeresult($result); $sql = "SELECT a.forum_id, a.auth_allow_deny, ao.auth_type, ao.auth_option FROM " . ACL_USERS_TABLE . " a, " . ACL_OPTIONS_TABLE . " ao WHERE a.user_id = " . $userdata['user_id'] . " AND ao.auth_option_id = a.auth_option_id AND ( $and_sql )"; $result = $db->sql_query($sql); if ( $row = $db->sql_fetchrow($result) ) { do { switch ( $this->acl[$row['forum_id']][$row['auth_type']][$row['auth_option']] ) { case ACL_PERMIT: case ACL_PREVENT: break; default: $this->acl[$row['forum_id']][$row['auth_type']][$row['auth_option']] = $row['auth_allow_deny']; break; } } while ( $row = $db->sql_fetchrow($result) ); } $db->sql_freeresult($result); if ( is_array($this->acl) ) { foreach ( $this->acl as $forum_id => $auth_ary ) { foreach ( $auth_ary as $type => $option_ary ) { foreach ( $option_ary as $option => $value ) { switch ( $value ) { case ACL_ALLOW: case ACL_PERMIT: $this->acl[$forum_id][$type][$option] = 1; break; case ACL_DENY: case ACL_PREVENT: $this->acl[$forum_id][$type][$option] = 0; break; } } } } } } // print_r($this->acl); return; } function get_acl($forum_id, $auth_main, $auth_type = false) { if ( $this->founder ) { return true; } 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]) ) { return array_sum($this->acl[$forum_id][$auth_main]); } } function get_acl_admin($auth_type = false) { return ( $this->founder ) ? true : $this->get_acl(0, 'admin', $auth_type); } function set_acl_user(&$forum_id, &$user_id, &$auth, $dependencies = array()) { global $db; $forum_sql = ( $forum_id ) ? "AND a.forum_id IN ($forum_id, 0)" : ''; $sql = "SELECT a.user_id, o.auth_type, o.auth_option_id, o.auth_option, a.auth_allow_deny FROM " . ACL_USERS_TABLE . " a, " . ACL_OPTIONS_TABLE . " o, " . USERS_TABLE . " u WHERE a.auth_option_id = o.auth_option_id $forum_sql AND u.user_id = a.user_id AND a.user_id = $user_id"; $result = $db->sql_query($sql); $user_auth = array(); if ( $row = $db->sql_fetchrow($result) ) { do { $user_auth[$row['user_id']][$row['auth_type']][$row['auth_option_id']] = $row['auth_allow_deny']; } while ( $row = $db->sql_fetchrow($result) ); } $db->sql_freeresult($result); foreach ( $auth as $auth_type => $auth_option_ary ) { foreach ( $auth_option_ary as $auth_option => $allow ) { if ( !empty($user_auth) ) { foreach ( $user_auth as $user => $user_auth_ary ) { $sql_ary[] = ( !isset($user_auth_ary[$auth_type][$auth_option]) ) ? "INSERT INTO " . ACL_USERS_TABLE . " (user_id, forum_id, auth_option_id, auth_allow_deny) VALUES ($user_id, $forum_id, $auth_option, $allow)" : ( ( $user_auth_ary[$auth_type][$auth_option] != $allow ) ? "UPDATE " . ACL_USERS_TABLE . " SET auth_allow_deny = $allow WHERE user_id = $user_id AND forum_id = $forum_id and auth_option_id = $auth_option" : '' ); } } else { $sql_ary[] = "INSERT INTO " . ACL_USERS_TABLE . " (user_id, forum_id, auth_option_id, auth_allow_deny) VALUES ($user_id, $forum_id, $auth_option, $allow)"; } } } foreach ( $sql_ary as $sql ) { $db->sql_query($sql); } unset($user_auth); unset($sql_ary); } function set_acl_group(&$forum_id, &$group_id, &$auth, $dependencies = array()) { global $db; $forum_sql = ( $forum_id ) ? "AND a.forum_id IN ($forum_id, 0)" : ''; $sql = "SELECT a.group_id, o.auth_type, o.auth_option_id, o.auth_option, a.auth_allow_deny FROM " . ACL_GROUPS_TABLE . " a, " . ACL_OPTIONS_TABLE . " o WHERE a.auth_option_id = o.auth_option_id $forum_sql AND a.group_id = $group_id"; $result = $db->sql_query($sql); $group_auth = array(); if ( $row = $db->sql_fetchrow($result) ) { do { $group_auth[$row['group_id']][$row['auth_type']][$row['auth_option_id']] = $row['auth_allow_deny']; } while ( $row = $db->sql_fetchrow($result) ); } $db->sql_freeresult($result); foreach ( $auth as $auth_type => $auth_option_ary ) { foreach ( $auth_option_ary as $auth_option => $allow ) { if ( !empty($group_auth) ) { foreach ( $group_auth as $group => $group_auth_ary ) { $sql_ary[] = ( !isset($group_auth_ary[$auth_type][$auth_option]) ) ? "INSERT INTO " . ACL_GROUPS_TABLE . " (group_id, forum_id, auth_option_id, auth_allow_deny) VALUES ($group_id, $forum_id, $auth_option, $allow)" : ( ( $group_auth_ary[$auth_type][$auth_option] != $allow ) ? "UPDATE " . ACL_GROUPS_TABLE . " SET auth_allow_deny = $allow WHERE group_id = $group_id AND forum_id = $forum_id and auth_option_id = $auth_option" : '' ); } } else { $sql_ary[] = "INSERT INTO " . ACL_GROUPS_TABLE . " (group_id, forum_id, auth_option_id, auth_allow_deny) VALUES ($group_id, $forum_id, $auth_option, $allow)"; } } } foreach ( $sql_ary as $sql ) { $db->sql_query($sql); } unset($group_auth); unset($sql_ary); } function delete_acl_user($forum_id, $user_id, $auth_type = false) { global $db; $auth_sql = ( $auth_type != '' ) ? " AND auth_option_id IN ()" : ""; $sql = "DELETE FROM " . ACL_USERS_TABLE . " WHERE user_id = $user_id AND forum_id = $forum_id"; $db->sql_query($sql); } function delete_acl_group($forum_id, $group_id, $auth_type = false) { global $db; $auth_sql = ( $auth_type != '' ) ? " AND auth_option_id IN ()" : ""; $sql = "DELETE FROM " . ACL_GROUPS_TABLE . " WHERE group_id = $group_id AND forum_id = $forum_id"; $db->sql_query($sql); } } // // Authentication plug-ins is largely down to // Sergey Kanareykin, our thanks to him. // class login { function login($username, $password, $autologin = false) { global $SID, $db, $board_config, $lang, $user_ip, $session; global $HTTP_SERVER_VARS, $HTTP_ENV_VARS, $phpEx; $user_page = ( !empty($HTTP_SERVER_VARS['PHP_SELF']) ) ? $HTTP_SERVER_VARS['PHP_SELF'] : $HTTP_ENV_VARS['PHP_SELF']; $user_page .= '&' . ( ( !empty($HTTP_SERVER_VARS['QUERY_STRING']) ) ? $HTTP_SERVER_VARS['QUERY_STRING'] : $HTTP_ENV_VARS['QUERY_STRING'] ); $this_browser = ( !empty($HTTP_SERVER_VARS['HTTP_USER_AGENT']) ) ? $HTTP_SERVER_VARS['HTTP_USER_AGENT'] : $HTTP_ENV_VARS['HTTP_USER_AGENT']; $method = trim($board_config['auth_method']); if ( file_exists('includes/auth/auth_' . $method . '.' . $phpEx) ) { include_once('includes/auth/auth_' . $method . '.' . $phpEx); $method = 'login_' . $method; if ( function_exists($method) ) { if ( !($user = $method($username, $password)) ) { return false; } $autologin = ( isset($autologin) ) ? md5($password) : ''; return ( $user['user_active'] ) ? $session->create($user['user_id'], $autologin, $user_page, $this_browser) : false; } } message_die(ERROR, 'Authentication method not found'); } } ?>