View file Loads_by_Ozomen/loads/stats.php

<?
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';

$set['title']='Статистика файлов'; // заголовок страницы
include_once '../sys/inc/thead.php';
title();
aut();

$all_size = mysql_fetch_row(mysql_query('SELECT SUM(`size`) FROM `loads_list` WHERE `size` > 0' ));

if($all_size[0] < 1048576){
$all_size[0] = round($all_size[0]/1024, 2).'Kb';
}
else{
$all_size[0] = round($all_size[0]/1024/1024, 2).'Mb';
}

$all_size_dop = mysql_fetch_row(mysql_query('SELECT SUM(`size`) FROM `loads_dop` WHERE `size` > 0' ));

if($all_size_dop[0] < 1048576){
$all_size_dop[0] = round($all_size_dop[0]/1024, 2).'Kb';
}
else{
$all_size_dop[0] = round($all_size_dop[0]/1024/1024, 2).'Mb';
}

$all_files = mysql_fetch_row(mysql_query('SELECT COUNT(*) FROM `loads_list` WHERE `size` > 0'));
$all_files_dop = mysql_fetch_row(mysql_query('SELECT COUNT(*) FROM `loads_dop` WHERE `size` > 0'));
$all_loads = mysql_fetch_row(mysql_query('SELECT SUM(`loads`) FROM `loads_list` WHERE `size` > 0'));


echo'Всего файлов: '.(int)$all_files[0].'<br/>';
echo'Всего дополнительных файлов файлов: '.(int)$all_files_dop[0].'<br/>';
echo'Общий размер: '.$all_size[0].'<br/>';
echo'Общий размер дополнительных файлов: '.$all_size_dop[0].'<br/>';

echo'<div class="foot">
&laquo;<a href="/loads/">Загрузки</a><br />
</div>';




include_once '../sys/inc/tfoot.php';

?>