[mxbb-commits] core27x/modules/mx_statistics mx_statistics.php,1.1,1.2

[Jon O. <jon...@us...>]

Update of /cvsroot/mxbb/core27x/modules/mx_statistics
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv23896/core27x/modules/mx_statistics

Modified Files:
	mx_statistics.php 
Log Message:
updated

Index: mx_statistics.php
===================================================================
RCS file: /cvsroot/mxbb/core27x/modules/mx_statistics/mx_statistics.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mx_statistics.php	6 May 2005 06:48:07 -0000	1.1
--- mx_statistics.php	5 Dec 2005 19:25:26 -0000	1.2
***************
*** 1,99 ****
  <?php
! /***************************************************************************
!  *                            statistics.php
!  *                            -------------------
!  *   begin                : Tue February 26 2002
!  *  copyright            : (C) 2002 Nivisec.com
!  *   email                : ad...@ni...
!  *
!  *   $Id$
!  *
!  *
!  ***************************************************************************/
  
! /***************************************************************************
!  *                                         				                                
!  *   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.
!  *
!  ***************************************************************************/
  
! if ( !defined('IN_PORTAL') )
  {
!   define('IN_PORTAL', true);
!   $mx_root_path = "../../";
! 
! 
!   include($mx_root_path . 'extension.inc');
!   include($mx_root_path . 'common.'.$phpEx);
! 
!   //
!   //
!   // Start session management
!   //
!   $userdata = session_pagestart($user_ip, PAGE_INDEX);
!   mx_init_userprefs($userdata);
!   //
!   // End session management
!   //
  
!   $block = FALSE;  
  }
  else
  {
!   //
!   // Read block Configuration
!   //
!   $block_config = read_block_config( $block_id );
!   
!   $title    = $block_config[$block_id]['block_title'];
  
!   $block = TRUE;  
  }
  
  //
! //Start user modifiable variables
  //
  $return_limit = 10;
  //
! //End user modifiable variables
  //
  
! $template->assign_block_vars("switch_view", array());
  
  //
! // End session management
  //
! 
! //Vote Images based on the theme path, (i.e. templates/CURRNT_THEME/ is already inserted)
! $vote_left  = PHPBB_URL . TEMPLATE_ROOT_PATH . "/images/vote_lcap.gif";
  $vote_right = PHPBB_URL . TEMPLATE_ROOT_PATH . "/images/vote_rcap.gif";
! $vote_bar   = PHPBB_URL . TEMPLATE_ROOT_PATH . "/images/voting_bar.gif";
! 
! 
  
! if ( file_exists($module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.'.$phpEx) )
  {
!   include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin.' . $phpEx);
!   include($module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.' . $phpEx);
  }
  else
  {
!   include($phpbb_root_path . 'language/lang_english/lang_admin.' . $phpEx);
!   include($module_root_path . 'language/lang_english/lang_main.' . $phpEx);
  }
  
! 
  // Do the math :) (i think this is the same method as in philip mayer's statistic's file)
  // Taken from Acyd Burn.
  function do_math($firstval, $value, $total, &$percentage, &$bar_percent)
  {
! 	$cst = ($firstval > 0) ? 90 / $firstval : 90;
  
! 	if ( $value != 0  )
  	{
! 		$percentage = ( $total ) ? round( min(100, ($value / $total) * 100)) : 0;
  	}
  	else
--- 1,90 ----
  <?php
! /** ------------------------------------------------------------------------
!  *		subject				: mx-portal module
!  *		begin            	: june, 2002
!  *		copyright          	: (C) 2002-2005 MX-System
!  *		email             	: jon...@ho...
!  *		project site		: www.mx-system.com
!  * 
!  *		description			:
!  * -------------------------------------------------------------------------
!  *    $Id$
!  */
  
! /**
!  * 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.
!  */
  
! if( !defined('IN_PORTAL') )
  {
! 	define('IN_PORTAL', true);
! 	$mx_root_path = '../../';
  
! 	include($mx_root_path . 'extension.inc');
! 	include($mx_root_path . 'common.' . $phpEx);
! 	//
! 	// Start session management
! 	//
! 	$userdata = session_pagestart($user_ip, PAGE_INDEX);
! 	mx_init_userprefs($userdata);
! 	//
! 	// End session management
! 	//
! 	$is_block = false;
  }
  else
  {
! 	//
! 	// Read block Configuration
! 	//
! 	$block_config = read_block_config($block_id);
  
! 	$title = $block_config[$block_id]['block_title'];
! 
! 	$is_block = true;
  }
  
  //
! // Start user modifiable variables
  //
  $return_limit = 10;
  //
! // End user modifiable variables
  //
  
! $template->assign_block_vars('switch_view', array());
  
  //
! // Vote Images based on the theme path, (i.e. templates/CURRNT_THEME/ is already inserted)
  //
! $vote_left = PHPBB_URL . TEMPLATE_ROOT_PATH . "/images/vote_lcap.gif";
  $vote_right = PHPBB_URL . TEMPLATE_ROOT_PATH . "/images/vote_rcap.gif";
! $vote_bar = PHPBB_URL . TEMPLATE_ROOT_PATH . "/images/voting_bar.gif";
  
! if( file_exists($module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.' . $phpEx) )
  {
! 	include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin.' . $phpEx);
! 	include($module_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main.' . $phpEx);
  }
  else
  {
! 	include($phpbb_root_path . 'language/lang_english/lang_admin.' . $phpEx);
! 	include($module_root_path . 'language/lang_english/lang_main.' . $phpEx);
  }
  
! //
  // Do the math :) (i think this is the same method as in philip mayer's statistic's file)
  // Taken from Acyd Burn.
+ //
  function do_math($firstval, $value, $total, &$percentage, &$bar_percent)
  {
! 	$cst = ( $firstval > 0 ) ? 90 / $firstval : 90;
  
! 	if( $value != 0 )
  	{
! 		$percentage = ( $total ) ? round(min(100, ( $value / $total ) * 100)) : 0;
  	}
  	else
***************
*** 106,135 ****
  
  $template->set_filenames(array(
! "body" => "mx_statistics.tpl")
  );
  
  $template->assign_vars(array(
! "GRAPH_IMAGE" => $graph_image,
  
! "L_ADMIN_STATISTICS" => $lang['Admin_Stats'],
! "L_TOP_SMILIES" => $lang['Top_Smilies'],
! "L_MOST_ACTIVE" => $lang['Most_Active_Topics'],
! "L_MOST_VIEWED" => $lang['Most_Viewed_Topics'],
! "L_TOP_POSTERS" => $lang['Top_Posting_Users'],
  
! "L_USES" => $lang['Uses'],
! "L_RANK" => $lang['Rank'],
! "L_PERCENTAGE" => $lang['Percent'],
! "L_GRAPH" => $lang['Graph'],
! "L_REPLIES" => $lang['Replies'],
! "L_TOPIC" => $lang['Topic'],
! "L_VIEWS" => $lang['Views'],
! "L_USERNAME" => $lang['Username'],
! "L_POSTS" => $lang['Posts'],
! "L_STATISTIC" => $lang['Statistic'],
! "L_VALUE" => $lang['Value'],
! "L_IMAGE" => $lang['smiley_url'],
! "L_CODE" => $lang['smiley_code'],
! "PAGE_NAME" => $lang['Statistics'])
  );
  
--- 97,126 ----
  
  $template->set_filenames(array(
! 	'body' => 'mx_statistics.tpl')
  );
  
  $template->assign_vars(array(
! 	"GRAPH_IMAGE" => $graph_image,
  
! 	"L_ADMIN_STATISTICS" => $lang['Admin_Stats'],
! 	"L_TOP_SMILIES" => $lang['Top_Smilies'],
! 	"L_MOST_ACTIVE" => $lang['Most_Active_Topics'],
! 	"L_MOST_VIEWED" => $lang['Most_Viewed_Topics'],
! 	"L_TOP_POSTERS" => $lang['Top_Posting_Users'],
  
! 	"L_USES" => $lang['Uses'],
! 	"L_RANK" => $lang['Rank'],
! 	"L_PERCENTAGE" => $lang['Percent'],
! 	"L_GRAPH" => $lang['Graph'],
! 	"L_REPLIES" => $lang['Replies'],
! 	"L_TOPIC" => $lang['Topic'],
! 	"L_VIEWS" => $lang['Views'],
! 	"L_USERNAME" => $lang['Username'],
! 	"L_POSTS" => $lang['Posts'],
! 	"L_STATISTIC" => $lang['Statistic'],
! 	"L_VALUE" => $lang['Value'],
! 	"L_IMAGE" => $lang['smiley_url'],
! 	"L_CODE" => $lang['smiley_code'],
! 	"PAGE_NAME" => $lang['Statistics'])
  );
  
***************
*** 139,143 ****
  $auth_data_sql_stats = get_auth_forum();
  
- 
  //
  // Getting voting bar info from template
--- 130,133 ----
***************
*** 149,175 ****
  		$style = $userdata['user_style'];
  		if( !$theme )
! 		$style =  $board_config['default_style'];
  	}
  	else
! 	$style =  $board_config['default_style'];
  }
  else
! $style =  $board_config['default_style'];
  
- $sql = "SELECT * FROM " . THEMES_TABLE . " WHERE themes_id = $style";
  
! if(!$result = $db->sql_query($sql))
  {
! 	message_die(CRITICAL_ERROR, "Couldn't query database for theme info.");
  }
! if( !$row = $db->sql_fetchrow($result) )
  {
! 	message_die(CRITICAL_ERROR, "Couldn't get theme data for themes_id=$style.");
  }
  
  $template->assign_vars(array(
!   "LEFT_GRAPH_IMAGE" => $vote_left,
!   "RIGHT_GRAPH_IMAGE" => $vote_right,
!   "GRAPH_IMAGE" => $vote_bar)
  );
  
--- 139,171 ----
  		$style = $userdata['user_style'];
  		if( !$theme )
! 		{
! 			$style = $board_config['default_style'];
! 		}
  	}
  	else
! 	{
! 		$style = $board_config['default_style'];
! 	}
  }
  else
! {
! 	$style = $board_config['default_style'];
! }
  
  
! $sql = "SELECT * FROM " . THEMES_TABLE . " WHERE themes_id = $style";
! if( !($result = $db->sql_query($sql)) )
  {
! 	mx_message_die(CRITICAL_ERROR, "Couldn't query database for theme info.");
  }
! if( !($row = $db->sql_fetchrow($result)) )
  {
! 	mx_message_die(CRITICAL_ERROR, "Couldn't get theme data for themes_id=$style.");
  }
  
  $template->assign_vars(array(
! 	"LEFT_GRAPH_IMAGE" => $vote_left,
! 	"RIGHT_GRAPH_IMAGE" => $vote_right,
! 	"GRAPH_IMAGE" => $vote_bar)
  );
  
***************
*** 177,187 ****
  // Top posters SQL
  //
! $sql = "SELECT user_id, username, user_posts FROM " . USERS_TABLE . " WHERE user_id <> " . ANONYMOUS . " AND user_posts > 0
!          ORDER BY user_posts DESC
!          LIMIT " . $return_limit;
  
! if (!$result = $db->sql_query($sql))
  {
! 	message_die(GENERAL_ERROR, "Couldn't retrieve users data", "", __LINE__, __FILE__, $sql);
  }
  
--- 173,185 ----
  // Top posters SQL
  //
! $sql = "SELECT user_id, username, user_posts
! 	FROM " . USERS_TABLE . "
! 	WHERE user_id <> " . ANONYMOUS . " AND user_posts > 0
! 	ORDER BY user_posts DESC
! 	LIMIT " . $return_limit;
  
! if( !($result = $db->sql_query($sql)) )
  {
! 	mx_message_die(GENERAL_ERROR, "Couldn't retrieve users data", "", __LINE__, __FILE__, $sql);
  }
  
***************
*** 193,208 ****
  $firstcount = $user_data[0]['user_posts'];
  
! for ($i = 0; $i < $user_count; $i++)
  {
! 	do_math($firstcount, $user_data[$i]['user_posts'], get_db_stat('postcount'), $percentage, $bar_percent);
  
! 	$template->assign_block_vars("users", array(
! 	"RANK" => $i+1,
! 	"CLASS" => ( !($i+1 % 2) ) ? $theme['td_class2'] : $theme['td_class1'],
! 	"USERNAME" => $user_data[$i]['username'],
! 	"PERCENTAGE" => $percentage,
! 	"BAR" => $bar_percent,
! 	"URL" => append_sid( PHPBB_URL . "profile.php?mode=viewprofile&u=" . $user_data[$i]['user_id'] ),
! 	"POSTS" => $user_data[$i]['user_posts'])
  	);
  }
--- 191,206 ----
  $firstcount = $user_data[0]['user_posts'];
  
! for( $i = 0; $i < $user_count; $i++ )
  {
! 	do_math($firstcount, $user_data[$i]['user_posts'], get_db_stat( 'postcount' ), $percentage, $bar_percent);
  
! 	$template->assign_block_vars('users', array(
! 		"RANK" => $i + 1,
! 		"CLASS" => ( !( $i + 1 % 2 ) ) ? $theme['td_class2'] : $theme['td_class1'],
! 		"USERNAME" => $user_data[$i]['username'],
! 		"PERCENTAGE" => $percentage,
! 		"BAR" => $bar_percent,
! 		"URL" => append_sid(PHPBB_URL . "profile.php?mode=viewprofile&amp;u=" . $user_data[$i]['user_id']),
! 		"POSTS" => $user_data[$i]['user_posts'])
  	);
  }
***************
*** 212,238 ****
  //
  $sql = "SELECT topic_id, topic_title, topic_replies
! FROM " . TOPICS_TABLE ."
! WHERE forum_id IN ( $auth_data_sql_stats )
! AND topic_status <> 2
! AND topic_replies > 0
! ORDER BY topic_replies DESC
! LIMIT " . $return_limit;
  
! if (!$result = $db->sql_query($sql))
  {
! 	message_die(GENERAL_ERROR, "Couldn't retrieve topic data", "", __LINE__, __FILE__, $sql);
  }
  
  $topic_data = $db->sql_fetchrowset($result);
  
! for ($i = 0; $i < count($topic_data); $i++)
  {
! 
! 	$template->assign_block_vars("topicreplies", array(
! 	"RANK" => $i+1,
! 	"CLASS" => ( !($i+1 % 2) ) ? $theme['td_class2'] : $theme['td_class1'],
! 	"TITLE" => $topic_data[$i]['topic_title'],
! 	"REPLIES" => $topic_data[$i]['topic_replies'],
! 	"URL" => append_sid( PHPBB_URL . "viewtopic.php?t=" . $topic_data[$i]['topic_id']))
  	);
  }
--- 210,235 ----
  //
  $sql = "SELECT topic_id, topic_title, topic_replies
! 	FROM " . TOPICS_TABLE . "
! 	WHERE forum_id IN ( $auth_data_sql_stats )
! 		AND topic_status <> 2
! 		AND topic_replies > 0
! 	ORDER BY topic_replies DESC
! 	LIMIT " . $return_limit;
  
! if( !($result = $db->sql_query($sql)) )
  {
! 	mx_message_die(GENERAL_ERROR, "Couldn't retrieve topic data", "", __LINE__, __FILE__, $sql);
  }
  
  $topic_data = $db->sql_fetchrowset($result);
  
! for( $i = 0; $i < count($topic_data); $i++ )
  {
! 	$template->assign_block_vars('topicreplies', array(
! 		"RANK" => $i + 1,
! 		"CLASS" => ( !( $i + 1 % 2 ) ) ? $theme['td_class2'] : $theme['td_class1'],
! 		"TITLE" => $topic_data[$i]['topic_title'],
! 		"REPLIES" => $topic_data[$i]['topic_replies'],
! 		"URL" => append_sid(PHPBB_URL . "viewtopic.php?t=" . $topic_data[$i]['topic_id']))
  	);
  }
***************
*** 243,396 ****
  $rank = 0;
  $sql = "SELECT topic_id, topic_title, topic_views
! FROM " . TOPICS_TABLE ."
! WHERE forum_id IN ( $auth_data_sql_stats )
! AND topic_status <> 2
! AND topic_views > 0
! ORDER BY topic_views DESC
! LIMIT " . $return_limit;
  
! if (!$result = $db->sql_query($sql))
  {
! 	message_die(GENERAL_ERROR, "Couldn't retrieve topic data", "", __LINE__, __FILE__, $sql);
  }
  
  $topic_data = $db->sql_fetchrowset($result);
  
! for ($i = 0; $i < count($topic_data); $i++)
  {
! 	$template->assign_block_vars("topicviews", array(
! 	"RANK" => $i+1,
! 	"CLASS" => ( !($i+1 % 2) ) ? $theme['td_class2'] : $theme['td_class1'],
! 	"TITLE" => $topic_data[$i]['topic_title'],
! 	"VIEWS" => $topic_data[$i]['topic_views'],
! 	"URL" => append_sid( PHPBB_URL .  "viewtopic.php?t=" . $topic_data[$i]['topic_id']))
  	);
  }
  
  //
! // Get forum statistics (taken from admin panel)
  //
! $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 (je...@je...)
- 	//
- 	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\.)/", $version) )
  		{
! 			$db_name = ( preg_match("/^(3\.23\.[6-9])|(3\.23\.[1-9][1-9])|(4\.)/", $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'];
- 						}
  					}
! 				}
! 
! 				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);
! 				}
! 			} // Else we couldn't get the table status.
  		}
  		else
--- 240,401 ----
  $rank = 0;
  $sql = "SELECT topic_id, topic_title, topic_views
! 	FROM " . TOPICS_TABLE . "
! 	WHERE forum_id IN ( $auth_data_sql_stats )
! 		AND topic_status <> 2
! 		AND topic_views > 0
! 	ORDER BY topic_views DESC
! 	LIMIT " . $return_limit;
  
! if( !($result = $db->sql_query($sql)) )
  {
! 	mx_message_die(GENERAL_ERROR, "Couldn't retrieve topic data", "", __LINE__, __FILE__, $sql);
  }
  
  $topic_data = $db->sql_fetchrowset($result);
  
! for( $i = 0; $i < count($topic_data); $i++ )
  {
! 	$template->assign_block_vars('topicviews', array(
! 		"RANK" => $i + 1,
! 		"CLASS" => ( !( $i + 1 % 2 ) ) ? $theme['td_class2'] : $theme['td_class1'],
! 		"TITLE" => $topic_data[$i]['topic_title'],
! 		"VIEWS" => $topic_data[$i]['topic_views'],
! 		"URL" => append_sid(PHPBB_URL . "viewtopic.php?t=" . $topic_data[$i]['topic_id']))
  	);
  }
  
  //
! // Begin Of Administrative Statistics (based on admin/index.php)
! // Also, takes into mxBB tables (DB Size) and Attachment MOD
  //
! 	//
! 	// 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 (je...@je...)
! 		//
! 		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\.)/", $version) )
  			{
! 				$db_name = ( preg_match("/^(3\.23\.[6-9])|(3\.23\.[1-9][1-9])|(4\.)/", $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 != "" && $mx_table_prefix != "" )
! 							{
! 								if( strstr($tabledata_ary[$i]['Name'], $table_prefix) || strstr($tabledata_ary[$i]['Name'], $mx_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
***************
*** 403,414 ****
  		$dbsize = $lang['Not_available'];
  	}
! }
! else
! {
! 	$dbsize = $lang['Not_available'];
! }
  
  //
! //Newest user data
  //
  $newest_userdata = get_db_stat('newestuser');
--- 408,433 ----
  		$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);
! 		}
! 	}
! //
! // End Of Administrative Statistics
! //
  
  //
! // Newest user data
  //
  $newest_userdata = get_db_stat('newestuser');
***************
*** 416,425 ****
  $newest_uid = $newest_userdata['user_id'];
  $sql = "SELECT user_regdate
! FROM " . USERS_TABLE . "
! WHERE user_id = " . $newest_userdata['user_id'] . "
! LIMIT 1";
! if (!$result = $db->sql_query($sql))
  {
! 	message_die(GENERAL_ERROR, "Couldn't retrieve users data", "", __LINE__, __FILE__, $sql);
  }
  $row = $db->sql_fetchrow($result);
--- 435,444 ----
  $newest_uid = $newest_userdata['user_id'];
  $sql = "SELECT user_regdate
! 	FROM " . USERS_TABLE . "
! 	WHERE user_id = " . $newest_userdata['user_id'] . "
! 	LIMIT 1";
! if( !($result = $db->sql_query($sql)) )
  {
! 	mx_message_die(GENERAL_ERROR, "Couldn't retrieve users data", "", __LINE__, __FILE__, $sql);
  }
  $row = $db->sql_fetchrow($result);
***************
*** 427,478 ****
  
  //
! //Most Online data
  //
  $sql = "SELECT *
! FROM " . CONFIG_TABLE . "
! WHERE config_name = 'record_online_users'
! OR config_name = 'record_online_date'";
! 
! if (!$result = $db->sql_query($sql))
  {
! 	message_die(GENERAL_ERROR, "Couldn't retrieve configuration data", "", __LINE__, __FILE__, $sql);
  }
- 
  $row = $db->sql_fetchrow($result);
! $most_users_date = ($row['config_value'] > 0) ? create_date($board_config['default_dateformat'], $row['config_value'], $board_config['board_timezone']) : $most_users_date = $lang['Not_available'];
! 
  $row = $db->sql_fetchrow($result);
! $most_users = ($row['config_value'] > 0) ? $row['config_value'] : $lang['Not_available'];
  
! $statistic_array = array($lang['Number_posts'],$lang['Posts_per_day'],$lang['Number_topics'],$lang['Topics_per_day'],$lang['Number_users'],$lang['Users_per_day'],$lang['Board_started'],$lang['Board_Up_Days'],$lang['Database_size'],$lang['Avatar_dir_size'],$lang['Latest_Reg_User_Date'],$lang['Latest_Reg_User'],$lang['Most_Ever_Online_Date'],$lang['Most_Ever_Online'],$lang['Gzip_compression']);
! $value_array = array($total_posts, $posts_per_day, $total_topics, $topics_per_day, $total_users, $users_per_day, $start_date, sprintf('%.2f', $boarddays), $dbsize, $avatar_dir_size, create_date($board_config['default_dateformat'], $newest_user_date, $board_config['board_timezone']), sprintf('<a href="' . append_sid( PHPBB_URL . "profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=$newest_uid") . '">' . $newest_user . '</a>'), $most_users_date, $most_users, ( $board_config['gzip_compress'] ) ? $lang['Enabled'] : $lang['Disabled']);
  
! for ($i = 0; $i < count($statistic_array); $i += 2)
  {
! 	$template->assign_block_vars("adminrow", array(
! 	"STATISTIC" => $statistic_array[$i],
! 	"VALUE" => $value_array[$i],
! 	"STATISTIC2" => (isset($statistic_array[$i+1])) ? $statistic_array[$i + 1] : "",
! 	"VALUE2" => (isset($value_array[$i+1])) ? $value_array[$i + 1] : "")
! 	);
  }
  //
! // End forum statistics
  //
  
  //
! //Output the page
  //
  $page_title = $lang['Statistics'];
! if ( !$block )
  {
!   include($mx_root_path . 'includes/page_header.'.$phpEx);
  }
  
! $template->pparse("body");
  
! if ( !$block )
  {
!   include($mx_root_path . 'includes/page_tail.'.$phpEx);
  }
  
--- 446,505 ----
  
  //
! // Most Online data
  //
  $sql = "SELECT *
! 	FROM " . CONFIG_TABLE . "
! 	WHERE config_name = 'record_online_users'
! 		OR config_name = 'record_online_date'";
! if( !($result = $db->sql_query($sql)) )
  {
! 	mx_message_die(GENERAL_ERROR, "Couldn't retrieve configuration data", "", __LINE__, __FILE__, $sql);
  }
  $row = $db->sql_fetchrow($result);
! $most_users_date = ( $row['config_value'] > 0 ) ? create_date($board_config['default_dateformat'], $row['config_value'], $board_config['board_timezone']) : $lang['Not_available'];
  $row = $db->sql_fetchrow($result);
! $most_users = ( $row['config_value'] > 0 ) ? $row['config_value'] : $lang['Not_available'];
  
! $statistic_array = array($lang['Number_posts'], $lang['Posts_per_day'], $lang['Number_topics'], $lang['Topics_per_day'], $lang['Number_users'], $lang['Users_per_day'], $lang['Board_started'], $lang['Board_Up_Days'], $lang['Database_size'], $lang['Avatar_dir_size'], $lang['Latest_Reg_User_Date'], $lang['Latest_Reg_User'], $lang['Most_Ever_Online_Date'], $lang['Most_Ever_Online'], $lang['Gzip_compression']);
! $value_array = array($total_posts, $posts_per_day, $total_topics, $topics_per_day, $total_users, $users_per_day, $start_date, sprintf('%.2f', $boarddays), $dbsize, $avatar_dir_size, create_date($board_config['default_dateformat'], $newest_user_date, $board_config['board_timezone']), sprintf('<a href="' . append_sid(PHPBB_URL . "profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=$newest_uid") . '">' . $newest_user . '</a>'), $most_users_date, $most_users, ( $board_config['gzip_compress'] ) ? $lang['Enabled'] : $lang['Disabled']);
  
! //
! // Disk Usage, if Attachment Mod is installed
! //
! if( defined('ATTACH_VERSION') )
  {
! 	include($phpbb_root_path . 'attach_mod/includes/functions_admin.'.$phpEx);
! 	$disk_usage = get_formatted_dirsize();
! 	$statistic_array[] = $lang['Disk_usage'];
! 	$value_array[] = $disk_usage;
  }
+ 
  //
! // Output Administrative Statistics
  //
+ for( $i = 0; $i < count($statistic_array); $i += 2 )
+ {
+ 	$template->assign_block_vars('adminrow', array(
+ 		"STATISTIC" => $statistic_array[$i],
+ 		"VALUE" => $value_array[$i],
+ 		"STATISTIC2" => ( isset($statistic_array[$i + 1]) ) ? $statistic_array[$i + 1] : '',
+ 		"VALUE2" => ( isset($value_array[$i + 1]) ) ? $value_array[$i + 1] : '')
+ 	);
+ }
  
  //
! // Output the page
  //
  $page_title = $lang['Statistics'];
! if( !$is_block )
  {
! 	include($mx_root_path . 'includes/page_header.' . $phpEx);
  }
  
! $template->pparse('body');
  
! if( !$is_block )
  {
! 	include($mx_root_path . 'includes/page_tail.' . $phpEx);
  }