3.0.0MPAKÿüÌINFOÌüÿ#
# This file contains Installation Informations.
# This file does not include Installation Instructions for the normal User.
# Please do not edit this file if you are not the Module Author.
#
# Please read the provided install.txt for Informations on how to install this Module.
#

# Module Name
[name]
Administrative Statistics
[/name]

# Module Directory Name
[short_name]
admin_statistics
[/short_name]

# your name
[author]
Acyd Burn
[/author]

# your email
[email]
acyd.burn@gmx.de
[/email]

# your webpage url
[url]
http://www.opentools.de
[/url]

# module version
[version]
3.0.1beta3s
[/version]

# required minimum Statistics Mod Version
[stats_mod_version]
3.0.1beta3s
[/stats_mod_version]

# default update time
[update_time]
360
[/update_time]

[check_update_site]
http://www.opentools.de/board/show_modules.php
[/check_update_site]

# extra info for the user
[extra_info]
This Module displays some Admin Statistics about your Board.
It is nearly the same you are able to see within the first Administration Panel visit.
[/extra_info]
ÌÌÿINFOÿÌÌÿüÌLANGÌüÿ<?php

// [lang_english]

// Administrative Statistics
$lang['module_name'] = 'Administrative Statistics';

$lang['Board_Up_Days'] = 'Board Up Days';
$lang['Latest_Reg_User'] = 'Latest User Registered';
$lang['Latest_Reg_User_Date'] = 'Latest User Registered Date';
$lang['Most_Ever_Online'] = 'Most Users Ever Online';
$lang['Most_Ever_Online_Date'] = 'Most Users Ever Online Date';
$lang['Disk_usage'] = 'Disk Usage';

// [/lang_english]

// [lang_danish]

// Administrative Statistics
$lang['module_name'] = 'Administrative statistikker';

$lang['Board_Up_Days'] = 'Forum oppetid i dage';
$lang['Latest_Reg_User'] = 'Senest tilmeldte bruger';
$lang['Latest_Reg_User_Date'] = 'Dato for senest tilmeldte bruger';
$lang['Most_Ever_Online'] = 'Flest brugere online nogensinde';
$lang['Most_Ever_Online_Date'] = 'Dato for flest brugere online nogensinde';
$lang['Disk_usage'] = 'Diskforbrug';

// [/lang_danish]

// [lang_dutch]

// Administrative Statistics
$lang['module_name'] = 'Administratieve Statistieken';

$lang['Board_Up_Days'] = 'Board Up Dagen';
$lang['Latest_Reg_User'] = 'Laatst Geregistreerde Gebruiker';
$lang['Latest_Reg_User_Date'] = 'Datum Laatst Geregistreerde Gebruiker';
$lang['Most_Ever_Online'] = 'Meeste gebruikers ooit Online';
$lang['Most_Ever_Online_Date'] = 'Datum Meeste gebruikers ooit Online';
$lang['Disk_usage'] = 'Schijf Gebruik';

// [/lang_dutch]

// [lang_german]

// Administrative Statistiken
$lang['module_name'] = 'Administrative Statistiken';

$lang['Board_Up_Days'] = 'Tage seit der ersten Inbetriebnahme';
$lang['Latest_Reg_User'] = 'Letzter registrierter Benutzer';
$lang['Latest_Reg_User_Date'] = 'Letzter registrierter Benutzer am';
$lang['Most_Ever_Online'] = 'Meisten User auf einem Mal Online';
$lang['Most_Ever_Online_Date'] = 'Meisten User auf einem Mal Online am';
$lang['Disk_usage'] = 'Speicherplatzverbrauch der Attachments';

// [/lang_german]

// [lang_italian]

// Administrative Statistics
$lang['module_name'] = 'Statistiche amministrative';

$lang['Board_Up_Days'] = 'Giorni di attivit&agrave; del forum';
$lang['Latest_Reg_User'] = 'Ultimo utente registrato';
$lang['Latest_Reg_User_Date'] = 'Data registrazione ultimo utente';
$lang['Most_Ever_Online'] = 'Record utenti online';
$lang['Most_Ever_Online_Date'] = 'Data del record utenti online';
$lang['Disk_usage'] = 'Utilizzo disco';

// [/lang_italian]

// [lang_spanish]

// Administrative Statistics
$lang['module_name'] = 'Estadísticas administrativas';

$lang['Board_Up_Days'] = 'Días del foro en línea';
$lang['Latest_Reg_User'] = 'Último usuario registrado';
$lang['Latest_Reg_User_Date'] = 'Fecha de registro del último usuario';
$lang['Most_Ever_Online'] = 'Mayor catidad de usuarios conectados';
$lang['Most_Ever_Online_Date'] = 'Fecha de mayor catidad de usuarios conectados';
$lang['Disk_usage'] = 'Uso del disco';

// [/lang_spanish]

?>ÌÌÿLANGÿÌÌÿüÌMODÌüÿ<?php
/***************************************************************************
*                            admin_statistics.pak
*                            --------------------
*     begin                :
*     copyright            : (C)      Meik Sievertsen
*     email                : acyd.burn@gmx.de
*
*     $Id: stats_overview.pak, 2006/08/12 16:02:00 acydburn Exp $
*          for Statistics MOD version 3.0.1beta3s
****************************************************************************/
/***************************************************************************
*
*   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_PHPBB') )
{
	die("Hacking attempt");
}

//
// Administrative Statistics
//

$core->start_module(true);

$core->set_content('values');

$attachment_mod_installed = ( defined('ATTACH_VERSION') ) ? TRUE : FALSE;
$attachment_version = ($attachment_mod_installed) ? ATTACH_VERSION : '';

if ( $attachment_mod_installed )
{
	@include_once($phpbb_root_path . 'attach_mod/includes/functions_admin.'.$phpEx);
}

$sql = "SELECT COUNT(user_id) AS total
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS;

$result = $core->sql_query($sql, 'Unable to get user count');
$row = $core->sql_fetchrow($result);

$total_users = $row['total'];

$sql = "SELECT SUM(forum_topics) AS topic_total, SUM(forum_posts) AS post_total
FROM " . FORUMS_TABLE;

$result = $core->sql_query($sql, 'Unable to get topic and post count');
$row = $core->sql_fetchrow($result);

$total_posts = $row['post_total'];
$total_topics = $row['topic_total'];

$sql = "SELECT user_id, username
FROM " . USERS_TABLE . "
WHERE user_id <> " . ANONYMOUS . "
ORDER BY user_id DESC
LIMIT 1";

$result = $core->sql_query($sql, 'Unable to get newest user data');
$newest_userdata = $core->sql_fetchrow($result);

$start_date = create_date($board_config['default_dateformat'], $board_config['board_startdate'], $board_config['board_timezone']);

$boarddays = max(1, round( ( 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 (!$attachment_mod_installed)
	{
		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
	{
		if($avatar_dir_size >= 1048576)
		{
			$avatar_dir_size = round($avatar_dir_size / 1048576 * 100) / 100 . ' ' . $lang['MB'];
		}
		else if($avatar_dir_size >= 1024)
		{
			$avatar_dir_size = round($avatar_dir_size / 1024 * 100) / 100 . ' ' . $lang['KB'];
		}
		else
		{
			$avatar_dir_size = $avatar_dir_size . ' ' . $lang['Bytes'];
		}
	}

}
else
{
	$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
//
$dbsize = 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'];
						}
					}	
				}
			}
		}
	}
}

$dbsize = intval($dbsize);

if ($dbsize != 0)
{
	if ($attachment_mod_installed)
	{
		if( $dbsize >= 1048576 )
		{
			$dbsize = sprintf('%.2f ' . $lang['MB'], ( $dbsize / 1048576 ));
		}
		else if( $dbsize >= 1024 )
		{
			$dbsize = sprintf('%.2f ' . $lang['KB'], ( $dbsize / 1024 ));
		}
		else
		{
			$dbsize = sprintf('%.2f ' . $lang['Bytes'], $dbsize);
		}
	}
	else
	{
		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
{
	$dbsize = $lang['Not_available'];
}

//
// Newest user data
//
$newest_user = $newest_userdata['username'];
$newest_uid = $newest_userdata['user_id'];

$sql = 'SELECT user_regdate 
FROM ' . USERS_TABLE . ' 
WHERE user_id = ' . $newest_uid . '
LIMIT 1';

$result = $core->sql_query($sql, 'Couldn\'t retrieve users data');
$row = $core->sql_fetchrow($result);
$newest_user_date = $row['user_regdate'];

//
// Most Online data
//
$sql = "SELECT *
FROM " . CONFIG_TABLE . "
WHERE config_name = 'record_online_users' OR config_name = 'record_online_date'";

$result = $core->sql_query($sql, 'Couldn\'t retrieve configuration data');

$row = $core->sql_fetchrowset($result);
$most_users_date = $lang['Not_available'];
$most_users = $lang['Not_available'];

for ($i = 0; $i < count($row); $i++)
{
	if ( (intval($row[$i]['config_value']) > 0) && ($row[$i]['config_name'] == 'record_online_date') )
	{
		$most_users_date = create_date($board_config['default_dateformat'], intval($row[$i]['config_value']), $board_config['board_timezone']);
	}
	else if ( (intval($row[$i]['config_value']) > 0) && ($row[$i]['config_name'] == 'record_online_users') )
	{
		$most_users = intval($row[$i]['config_value']);
	}
}

$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_root_path . '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 ( $attachment_mod_installed )
{
	$disk_usage = get_formatted_dirsize();

	$statistic_array[] = $lang['Disk_usage'];
	$value_array[] = $disk_usage;
}

$core->set_view('columns', 2);
$core->set_view('num_blocks', 2);
$core->set_view('value_order', 'left_right');
//$core->set_view('value_order', 'up_down');

$core->define_view('set_columns', array(
	'stats' => $lang['Statistic'],
	'value' => $lang['Value'])
);

$core->set_header($lang['module_name']);

$data = $core->assign_defined_view('value_array', array($statistic_array, $value_array));

$core->set_data($data);

$core->define_view('iterate_values', array());

$core->run_module();

?>ÌÌÿMODÿÌÌ