View file adm_panel/statistic.php

<?php
require( '../sys/inc/core.php' );

user_access( 'adm_statistic', null, 'index.php?' . SID );

$set['title'] = 'Статистика сайта';
get_header_admin(); 
for ( $i = 0; $i < 24; $i++ ) {
    $hit        = db::count("SELECT COUNT(*) FROM `visit_today` WHERE `time` >= '" . mktime( $i, 0, 0 ) . "' AND `time` < '" . mktime( $i + 1, 0, 0 ) . "'");
    $host       = db::count("SELECT COUNT(DISTINCT `ip`) FROM `visit_today` WHERE `time` >= '" . mktime( $i, 0, 0 ) . "' AND `time` < '" . mktime( $i + 1, 0, 0 ) . "'");
    $user_reg   = db::count("SELECT COUNT(*) FROM `user` WHERE `date_reg` >= '" . mktime( $i, 0, 0 ) . "' AND `date_reg` < '" . mktime( $i + 1, 0, 0 ) . "'");
    $forum_them = db::count("SELECT COUNT(*) FROM `forum_t` WHERE `time_create` >= '" . mktime( $i, 0, 0 ) . "' AND `time_create` < '" . mktime( $i + 1, 0, 0 ) . "'");
    $forum_post = db::count("SELECT COUNT(*) FROM `forum_p` WHERE `time` >= '" . mktime( $i, 0, 0 ) . "' AND `time` < '" . mktime( $i + 1, 0, 0 ) . "'");
    $stat[]     = array(
         'hit' => $hit,
        'host' => $host,
        'time' => mktime( $i, 0, 0 ),
        'for_th' => $forum_them,
        'for_p' => $forum_post,
        'user' => $user_reg 
    );
}
echo "Текущие сутки:<br />\n";
echo "<table border='1'>";
echo "<tr>\n";
echo "<td><b>Час</b></td>\n";
echo "<td><b>Хиты</b></td>\n";
echo "<td><b>Хосты</b></td>\n";
echo "<td><b>Рег.</b></td>\n";
echo "<td><b>Форум-темы</b></td>\n";
echo "<td><b>Форум-посты</b></td>\n";
echo "</tr>\n";
for ( $i = 0; $i < sizeof( $stat ); $i++ ) {
    if ( $time < $stat[$i]['time'] )
        continue;
    echo "<tr>\n";
    echo "<td>" . date( 'H', $stat[$i]['time'] + $user['set_timesdvig'] * 60 * 60 ) . "</td>\n";
    echo "<td>" . $stat[$i]['hit'] . "</td>\n";
    echo "<td>" . $stat[$i]['host'] . "</td>\n";
    echo "<td>" . $stat[$i]['user'] . "</td>\n";
    echo "<td>" . $stat[$i]['for_th'] . "</td>\n";
    echo "<td>" . $stat[$i]['for_p'] . "</td>\n";
    echo "</tr>\n";
}
echo "</table><br />\n";
unset( $stat );
echo "Последний месяц:<br />\n";
$k_day = db::count("SELECT COUNT(*) FROM `visit_everyday`");
$q     = db::query("SELECT * FROM `visit_everyday` ORDER BY `time` ASC LIMIT " . max( $k_day - 30, 0 ) . ", 30");
$stat = array(); 
while ( $result =  $q->fetch_assoc() ) {
    $day_st     = mktime( 0, 0, 0, date( 'n', $result['time'] ), date( 'j', $result['time'] ) );
    $day_fn     = mktime( 0, 0, 0, date( 'n', $result['time'] ), date( 'j', $result['time'] ) + 1 );
    $user_reg   = db::count("SELECT COUNT(*) FROM `user` WHERE `date_reg` >= '$day_st' AND `date_reg` < '$day_fn'");
    $forum_them = db::count("SELECT COUNT(*) FROM `forum_t` WHERE `time_create` >= '$day_st' AND `time_create` < '$day_fn'");
    $forum_post = db::count("SELECT COUNT(*) FROM `forum_p` WHERE `time` >= '$day_st' AND `time` < '$day_fn'");
    $stat[]     = array(
         'host' => ( $result['host_ip_ua'] < $result['host'] * 2 ? $result['host_ip_ua'] : $result['host'] ),
        'hit' => $result['hit'],
        'time' => $result['time'],
        'for_th' => $forum_them,
        'for_p' => $forum_post,
        'user' => $user_reg 
    );
}
echo "<table border='1'>";
echo "<tr>\n";
echo "<td><b>Дата</b></td>\n";
echo "<td><b>Хиты</b></td>\n";
echo "<td><b>Хосты</b></td>\n";
echo "<td><b>Рег.</b></td>\n";
echo "<td><b>Форум-темы</b></td>\n";
echo "<td><b>Форум-посты</b></td>\n";
echo "</tr>\n";
for ( $i = 0; $i < sizeof( $stat ); $i++ ) {
    echo "<tr>\n";
    echo "<td>" . date( 'd.m.Y', $stat[$i]['time'] ) . "</td>\n";
    echo "<td>" . $stat[$i]['hit'] . "</td>\n";
    echo "<td>" . $stat[$i]['host'] . "</td>\n";
    echo "<td>" . $stat[$i]['user'] . "</td>\n";
    echo "<td>" . $stat[$i]['for_th'] . "</td>\n";
    echo "<td>" . $stat[$i]['for_p'] . "</td>\n";
    echo "</tr>\n";
}
echo "</table><br />\n";
if ( user_access( 'adm_panel_show' ) ) {
    echo "<div class='foot'>\n";
    echo "<a href='/adm_panel/'>Админка</a><br />\n";
    echo "</div>\n";
}
get_footer_admin();