<?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('./../extension.inc');
require('./pagestart.' . $phpEx);
if (!defined('ADMIN_ALLOW') && !defined('USER_ALLOW')) {
	die ("Access Denied");
}

// ---------------
// 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_FORUM_PREINDEX" => append_sid("modules.$phpEx?name=Forums&file=index"),
                "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 STATUS
                                        FROM " . $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 dbsize
                        FROM 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_start
                FROM " . USERS_TABLE . " u, " . SESSIONS_TABLE . " s
                WHERE s.session_logged_in = " . TRUE . "
                        AND u.user_id = s.session_user_id
                        AND 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_start
                FROM " . SESSIONS_TABLE . "
                WHERE session_logged_in = 0
                        AND 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_id
                FROM " . 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&amp;" . 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&amp;" . 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&amp;" . 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 = '';

#     // Version cache mod start  
#    // Change following two variables if you need to:  
    $cache_update = 86400; // 24 hours cache timeout. change it to whatever you want  
    $cache_file = '../../../cache/Modules/phpbb_update_' . $board_config['default_lang'] . $board_config['version'] . '.php'; // file where to store cache  
  
    $do_update = true;  
    if(@file_exists($cache_file))  
   {  
        $last_update = 0;  
        $version_info = '';  
        @include($cache_file);  
        if($last_update && !empty($version_info) && $last_update > (time() - $cache_update))  
        {  
            $do_update = false;  
        }  
        else  
        {  
            $version_info = '';  
        }  
    }  
  
   if($do_update)  
    {  
#        // Version cache mod end  

	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>';
	#       // Version cache mod start  
       if(@$f = fopen($cache_file, 'w'))  
        {  
            $search = array('\\', '\'');  
            $replace = array('\\\\', '\\\'');  
            fwrite($f, '<' . '?php $last_update = ' . time() . '; $version_info = \'' . str_replace($search, $replace, $version_info) . '\';');  
           fclose($f);  
            @chmod($cache_file, 0777);  
        }  
    }  
    // Version cache mod end  

	$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;

}