<?php/**************************************************************************** (admin) index.php* -------------------* begin : Saturday, Feb 13, 2001* copyright : (C) 2001 The phpBB Group* email : support@phpbb.com** $Id: index.php,v 1.40.2.10 2005/12/04 12:55:28 grahamje Exp $*****************************************************************************//***************************************************************************** This program is free software; you can redistribute it and/or modify* it under the terms of the GNU General Public License as published by* the Free Software Foundation; either version 2 of the License, or* (at your option) any later version.****************************************************************************/define('IN_PHPBB', 1);//// Load default header//$no_page_header = TRUE;$phpbb_root_path = "./../";require($phpbb_root_path . 'extension.inc');require('./pagestart.' . $phpEx);// ---------------// Begin functions//function inarray($needle, $haystack){for($i = 0; $i < sizeof($haystack); $i++ ){if( $haystack[$i] == $needle ){return true;}}return false;}//// End functions// -------------//// Generate relevant output//if( isset($HTTP_GET_VARS['pane']) && $HTTP_GET_VARS['pane'] == 'left' ){$dir = @opendir(".");$setmodules = 1;while( $file = @readdir($dir) ){if( preg_match("/^admin_.*?\." . $phpEx . "$/", $file) ){include('./' . $file);}}@closedir($dir);unset($setmodules);include('./page_header_admin.'.$phpEx);$template->set_filenames(array("body" => "admin/index_navigate.tpl"));$template->assign_vars(array("U_FORUM_INDEX" => append_sid("../index.$phpEx"),"U_ADMIN_INDEX" => append_sid("index.$phpEx?pane=right"),"L_FORUM_INDEX" => $lang['Main_index'],"L_ADMIN_INDEX" => $lang['Admin_Index'],"L_PREVIEW_FORUM" => $lang['Preview_forum']));ksort($module);while( list($cat, $action_array) = each($module) ){$cat = ( !empty($lang[$cat]) ) ? $lang[$cat] : preg_replace("/_/", " ", $cat);$template->assign_block_vars("catrow", array("ADMIN_CATEGORY" => $cat));ksort($action_array);$row_count = 0;while( list($action, $file) = each($action_array) ){$row_color = ( !($row_count%2) ) ? $theme['td_color1'] : $theme['td_color2'];$row_class = ( !($row_count%2) ) ? $theme['td_class1'] : $theme['td_class2'];$action = ( !empty($lang[$action]) ) ? $lang[$action] : preg_replace("/_/", " ", $action);$template->assign_block_vars("catrow.modulerow", array("ROW_COLOR" => "#" . $row_color,"ROW_CLASS" => $row_class,"ADMIN_MODULE" => $action,"U_ADMIN_MODULE" => append_sid($file)));$row_count++;}}$template->pparse("body");include('./page_footer_admin.'.$phpEx);}elseif( isset($HTTP_GET_VARS['pane']) && $HTTP_GET_VARS['pane'] == 'right' ){include('./page_header_admin.'.$phpEx);$template->set_filenames(array("body" => "admin/index_body.tpl"));$template->assign_vars(array("L_WELCOME" => $lang['Welcome_phpBB'],"L_ADMIN_INTRO" => $lang['Admin_intro'],"L_FORUM_STATS" => $lang['Forum_stats'],"L_WHO_IS_ONLINE" => $lang['Who_is_Online'],"L_USERNAME" => $lang['Username'],"L_LOCATION" => $lang['Location'],"L_LAST_UPDATE" => $lang['Last_updated'],"L_IP_ADDRESS" => $lang['IP_Address'],"L_STATISTIC" => $lang['Statistic'],"L_VALUE" => $lang['Value'],"L_NUMBER_POSTS" => $lang['Number_posts'],"L_POSTS_PER_DAY" => $lang['Posts_per_day'],"L_NUMBER_TOPICS" => $lang['Number_topics'],"L_TOPICS_PER_DAY" => $lang['Topics_per_day'],"L_NUMBER_USERS" => $lang['Number_users'],"L_USERS_PER_DAY" => $lang['Users_per_day'],"L_BOARD_STARTED" => $lang['Board_started'],"L_AVATAR_DIR_SIZE" => $lang['Avatar_dir_size'],"L_DB_SIZE" => $lang['Database_size'],"L_FORUM_LOCATION" => $lang['Forum_Location'],"L_STARTED" => $lang['Login'],"L_GZIP_COMPRESSION" => $lang['Gzip_compression']));//// Get forum statistics//$total_posts = get_db_stat('postcount');$total_users = get_db_stat('usercount');$total_topics = get_db_stat('topiccount');$start_date = create_date($board_config['default_dateformat'], $board_config['board_startdate'], $board_config['board_timezone']);$boarddays = ( time() - $board_config['board_startdate'] ) / 86400;$posts_per_day = sprintf("%.2f", $total_posts / $boarddays);$topics_per_day = sprintf("%.2f", $total_topics / $boarddays);$users_per_day = sprintf("%.2f", $total_users / $boarddays);$avatar_dir_size = 0;if ($avatar_dir = @opendir($phpbb_root_path . $board_config['avatar_path'])){while( $file = @readdir($avatar_dir) ){if( $file != "." && $file != ".." ){$avatar_dir_size += @filesize($phpbb_root_path . $board_config['avatar_path'] . "/" . $file);}}@closedir($avatar_dir);//// This bit of code translates the avatar directory size into human readable format// Borrowed the code from the PHP.net annoted manual, origanally written by:// Jesse (jesse@jess.on.ca)//if($avatar_dir_size >= 1048576){$avatar_dir_size = round($avatar_dir_size / 1048576 * 100) / 100 . " MB";}else if($avatar_dir_size >= 1024){$avatar_dir_size = round($avatar_dir_size / 1024 * 100) / 100 . " KB";}else{$avatar_dir_size = $avatar_dir_size . " Bytes";}}else{// Couldn't open Avatar dir.$avatar_dir_size = $lang['Not_available'];}if($posts_per_day > $total_posts){$posts_per_day = $total_posts;}if($topics_per_day > $total_topics){$topics_per_day = $total_topics;}if($users_per_day > $total_users){$users_per_day = $total_users;}//// DB size ... MySQL only//// This code is heavily influenced by a similar routine// in phpMyAdmin 2.2.0//if( preg_match("/^mysql/", SQL_LAYER) ){$sql = "SELECT VERSION() AS mysql_version";if($result = $db->sql_query($sql)){$row = $db->sql_fetchrow($result);$version = $row['mysql_version'];if( preg_match("/^(3\.23|4\.|5\.)/", $version) ){$db_name = ( preg_match("/^(3\.23\.[6-9])|(3\.23\.[1-9][1-9])|(4\.)|(5\.)/", $version) ) ? "`$dbname`" : $dbname;$sql = "SHOW TABLE STATUSFROM " . $db_name;if($result = $db->sql_query($sql)){$tabledata_ary = $db->sql_fetchrowset($result);$dbsize = 0;for($i = 0; $i < count($tabledata_ary); $i++){if( $tabledata_ary[$i]['Type'] != "MRG_MyISAM" ){if( $table_prefix != "" ){if( strstr($tabledata_ary[$i]['Name'], $table_prefix) ){$dbsize += $tabledata_ary[$i]['Data_length'] + $tabledata_ary[$i]['Index_length'];}}else{$dbsize += $tabledata_ary[$i]['Data_length'] + $tabledata_ary[$i]['Index_length'];}}}} // Else we couldn't get the table status.}else{$dbsize = $lang['Not_available'];}}else{$dbsize = $lang['Not_available'];}}else if( preg_match("/^mssql/", SQL_LAYER) ){$sql = "SELECT ((SUM(size) * 8.0) * 1024.0) as dbsizeFROM sysfiles";if( $result = $db->sql_query($sql) ){$dbsize = ( $row = $db->sql_fetchrow($result) ) ? intval($row['dbsize']) : $lang['Not_available'];}else{$dbsize = $lang['Not_available'];}}else{$dbsize = $lang['Not_available'];}if ( is_integer($dbsize) ){if( $dbsize >= 1048576 ){$dbsize = sprintf("%.2f MB", ( $dbsize / 1048576 ));}else if( $dbsize >= 1024 ){$dbsize = sprintf("%.2f KB", ( $dbsize / 1024 ));}else{$dbsize = sprintf("%.2f Bytes", $dbsize);}}$template->assign_vars(array("NUMBER_OF_POSTS" => $total_posts,"NUMBER_OF_TOPICS" => $total_topics,"NUMBER_OF_USERS" => $total_users,"START_DATE" => $start_date,"POSTS_PER_DAY" => $posts_per_day,"TOPICS_PER_DAY" => $topics_per_day,"USERS_PER_DAY" => $users_per_day,"AVATAR_DIR_SIZE" => $avatar_dir_size,"DB_SIZE" => $dbsize,"GZIP_COMPRESSION" => ( $board_config['gzip_compress'] ) ? $lang['ON'] : $lang['OFF']));//// End forum statistics////// Get users online information.//$sql = "SELECT u.user_id, u.username, u.user_session_time, u.user_session_page, s.session_logged_in, s.session_ip, s.session_startFROM " . USERS_TABLE . " u, " . SESSIONS_TABLE . " sWHERE s.session_logged_in = " . TRUE . "AND u.user_id = s.session_user_idAND u.user_id <> " . ANONYMOUS . "AND s.session_time >= " . ( time() - 300 ) . "ORDER BY u.user_session_time DESC";if(!$result = $db->sql_query($sql)){message_die(GENERAL_ERROR, "Couldn't obtain regd user/online information.", "", __LINE__, __FILE__, $sql);}$onlinerow_reg = $db->sql_fetchrowset($result);$sql = "SELECT session_page, session_logged_in, session_time, session_ip, session_startFROM " . SESSIONS_TABLE . "WHERE session_logged_in = 0AND session_time >= " . ( time() - 300 ) . "ORDER BY session_time DESC";if(!$result = $db->sql_query($sql)){message_die(GENERAL_ERROR, "Couldn't obtain guest user/online information.", "", __LINE__, __FILE__, $sql);}$onlinerow_guest = $db->sql_fetchrowset($result);$sql = "SELECT forum_name, forum_idFROM " . FORUMS_TABLE;if($forums_result = $db->sql_query($sql)){while($forumsrow = $db->sql_fetchrow($forums_result)){$forum_data[$forumsrow['forum_id']] = $forumsrow['forum_name'];}}else{message_die(GENERAL_ERROR, "Couldn't obtain user/online forums information.", "", __LINE__, __FILE__, $sql);}$reg_userid_ary = array();if( count($onlinerow_reg) ){$registered_users = 0;for($i = 0; $i < count($onlinerow_reg); $i++){if( !inarray($onlinerow_reg[$i]['user_id'], $reg_userid_ary) ){$reg_userid_ary[] = $onlinerow_reg[$i]['user_id'];$username = $onlinerow_reg[$i]['username'];if( $onlinerow_reg[$i]['user_allow_viewonline'] || $userdata['user_level'] == ADMIN ){$registered_users++;$hidden = FALSE;}else{$hidden_users++;$hidden = TRUE;}if( $onlinerow_reg[$i]['user_session_page'] < 1 ){switch($onlinerow_reg[$i]['user_session_page']){case PAGE_INDEX:$location = $lang['Forum_index'];$location_url = "index.$phpEx?pane=right";break;case PAGE_POSTING:$location = $lang['Posting_message'];$location_url = "index.$phpEx?pane=right";break;case PAGE_LOGIN:$location = $lang['Logging_on'];$location_url = "index.$phpEx?pane=right";break;case PAGE_SEARCH:$location = $lang['Searching_forums'];$location_url = "index.$phpEx?pane=right";break;case PAGE_PROFILE:$location = $lang['Viewing_profile'];$location_url = "index.$phpEx?pane=right";break;case PAGE_VIEWONLINE:$location = $lang['Viewing_online'];$location_url = "index.$phpEx?pane=right";break;case PAGE_VIEWMEMBERS:$location = $lang['Viewing_member_list'];$location_url = "index.$phpEx?pane=right";break;case PAGE_PRIVMSGS:$location = $lang['Viewing_priv_msgs'];$location_url = "index.$phpEx?pane=right";break;case PAGE_FAQ:$location = $lang['Viewing_FAQ'];$location_url = "index.$phpEx?pane=right";break;default:$location = $lang['Forum_index'];$location_url = "index.$phpEx?pane=right";}}else{$location_url = append_sid("admin_forums.$phpEx?mode=editforum&" . POST_FORUM_URL . "=" . $onlinerow_reg[$i]['user_session_page']);$location = $forum_data[$onlinerow_reg[$i]['user_session_page']];}$row_color = ( $registered_users % 2 ) ? $theme['td_color1'] : $theme['td_color2'];$row_class = ( $registered_users % 2 ) ? $theme['td_class1'] : $theme['td_class2'];$reg_ip = decode_ip($onlinerow_reg[$i]['session_ip']);$template->assign_block_vars("reg_user_row", array("ROW_COLOR" => "#" . $row_color,"ROW_CLASS" => $row_class,"USERNAME" => $username,"STARTED" => create_date($board_config['default_dateformat'], $onlinerow_reg[$i]['session_start'], $board_config['board_timezone']),"LASTUPDATE" => create_date($board_config['default_dateformat'], $onlinerow_reg[$i]['user_session_time'], $board_config['board_timezone']),"FORUM_LOCATION" => $location,"IP_ADDRESS" => $reg_ip,"U_WHOIS_IP" => "http://network-tools.com/default.asp?host=$reg_ip","U_USER_PROFILE" => append_sid("admin_users.$phpEx?mode=edit&" . POST_USERS_URL . "=" . $onlinerow_reg[$i]['user_id']),"U_FORUM_LOCATION" => append_sid($location_url)));}}}else{$template->assign_vars(array("L_NO_REGISTERED_USERS_BROWSING" => $lang['No_users_browsing']));}//// Guest users//if( count($onlinerow_guest) ){$guest_users = 0;for($i = 0; $i < count($onlinerow_guest); $i++){$guest_userip_ary[] = $onlinerow_guest[$i]['session_ip'];$guest_users++;if( $onlinerow_guest[$i]['session_page'] < 1 ){switch( $onlinerow_guest[$i]['session_page'] ){case PAGE_INDEX:$location = $lang['Forum_index'];$location_url = "index.$phpEx?pane=right";break;case PAGE_POSTING:$location = $lang['Posting_message'];$location_url = "index.$phpEx?pane=right";break;case PAGE_LOGIN:$location = $lang['Logging_on'];$location_url = "index.$phpEx?pane=right";break;case PAGE_SEARCH:$location = $lang['Searching_forums'];$location_url = "index.$phpEx?pane=right";break;case PAGE_PROFILE:$location = $lang['Viewing_profile'];$location_url = "index.$phpEx?pane=right";break;case PAGE_VIEWONLINE:$location = $lang['Viewing_online'];$location_url = "index.$phpEx?pane=right";break;case PAGE_VIEWMEMBERS:$location = $lang['Viewing_member_list'];$location_url = "index.$phpEx?pane=right";break;case PAGE_PRIVMSGS:$location = $lang['Viewing_priv_msgs'];$location_url = "index.$phpEx?pane=right";break;case PAGE_FAQ:$location = $lang['Viewing_FAQ'];$location_url = "index.$phpEx?pane=right";break;default:$location = $lang['Forum_index'];$location_url = "index.$phpEx?pane=right";}}else{$location_url = append_sid("admin_forums.$phpEx?mode=editforum&" . POST_FORUM_URL . "=" . $onlinerow_guest[$i]['session_page']);$location = $forum_data[$onlinerow_guest[$i]['session_page']];}$row_color = ( $guest_users % 2 ) ? $theme['td_color1'] : $theme['td_color2'];$row_class = ( $guest_users % 2 ) ? $theme['td_class1'] : $theme['td_class2'];$guest_ip = decode_ip($onlinerow_guest[$i]['session_ip']);$template->assign_block_vars("guest_user_row", array("ROW_COLOR" => "#" . $row_color,"ROW_CLASS" => $row_class,"USERNAME" => $lang['Guest'],"STARTED" => create_date($board_config['default_dateformat'], $onlinerow_guest[$i]['session_start'], $board_config['board_timezone']),"LASTUPDATE" => create_date($board_config['default_dateformat'], $onlinerow_guest[$i]['session_time'], $board_config['board_timezone']),"FORUM_LOCATION" => $location,"IP_ADDRESS" => $guest_ip,"U_WHOIS_IP" => "http://network-tools.com/default.asp?host=$guest_ip","U_FORUM_LOCATION" => append_sid($location_url)));}}else{$template->assign_vars(array("L_NO_GUESTS_BROWSING" => $lang['No_users_browsing']));}// Check for new version$current_version = explode('.', '2' . $board_config['version']);$minor_revision = (int) $current_version[2];$errno = 0;$errstr = $version_info = '';if ($fsock = @fsockopen('www.phpbb.com', 80, $errno, $errstr, 10)){@fputs($fsock, "GET /updatecheck/20x.txt HTTP/1.1\r\n");@fputs($fsock, "HOST: www.phpbb.com\r\n");@fputs($fsock, "Connection: close\r\n\r\n");$get_info = false;while (!@feof($fsock)){if ($get_info){$version_info .= @fread($fsock, 1024);}else{if (@fgets($fsock, 1024) == "\r\n"){$get_info = true;}}}@fclose($fsock);$version_info = explode("\n", $version_info);$latest_head_revision = (int) $version_info[0];$latest_minor_revision = (int) $version_info[2];$latest_version = (int) $version_info[0] . '.' . (int) $version_info[1] . '.' . (int) $version_info[2];if ($latest_head_revision == 2 && $minor_revision == $latest_minor_revision){$version_info = '<p style="color:green">' . $lang['Version_up_to_date'] . '</p>';}else{$version_info = '<p style="color:red">' . $lang['Version_not_up_to_date'];$version_info .= '<br />' . sprintf($lang['Latest_version_info'], $latest_version) . ' ' . sprintf($lang['Current_version_info'], '2' . $board_config['version']) . '</p>';}}else{if ($errstr){$version_info = '<p style="color:red">' . sprintf($lang['Connect_socket_error'], $errstr) . '</p>';}else{$version_info = '<p>' . $lang['Socket_functions_disabled'] . '</p>';}}$version_info .= '<p>' . $lang['Mailing_list_subscribe_reminder'] . '</p>';$template->assign_vars(array('VERSION_INFO' => $version_info,'L_VERSION_INFORMATION' => $lang['Version_information']));$template->pparse("body");include('./page_footer_admin.'.$phpEx);}else{//// Generate frameset//$template->set_filenames(array("body" => "admin/index_frameset.tpl"));$template->assign_vars(array("S_FRAME_NAV" => append_sid("index.$phpEx?pane=left"),"S_FRAME_MAIN" => append_sid("index.$phpEx?pane=right")));header ("Expires: " . gmdate("D, d M Y H:i:s", time()) . " GMT");header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");$template->pparse("body");$db->sql_close();exit;}?>