View file sots-syet-livebook/guest/top.php

<?
include_once '../sys/inc/start.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();

echo '<div style="border-radius: 5px 5px 0 0;" class="main">За последние Сутки</div>';

$k_post=mysql_num_rows(mysql_query("SELECT `id_user` FROM `guest` WHERE `id_user` > '0' AND `time` > '".(time()-60*60*24)."' GROUP BY `id_user`"));
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];

if ($k_post =='0')
{
echo '<div class="gmenu">Список пуст</div>';
}

$q=mysql_query("SELECT `id_user` ,COUNT(*) as count FROM `guest` WHERE `id_user` > '0' AND `time` > '".(time()-60*60*24)."' GROUP BY `id_user` ORDER BY count DESC LIMIT $start, ".$set['p_str']."");

while ($guest_komm = mysql_fetch_array($q))
{
$ank=get_user($guest_komm['id_user']);
echo '<div class="mess">';
$num++;
echo '<span style="float: left; margin: 1px 5px 0px 0px;">';
echo avatar($ank['id'])."";
echo '</span>';
echo group($ank['id'])."";
echo " <a href='/info.php?id=".$ank['id']."'>".$ank['nick']."</a> ";
echo online($ank['id'])." ".medal($ank['id'])."<br />";
echo "<img src='/style/icons/st1.png'> Сообщений: <font color='green'>".$guest_komm['count']."</font></div>";
}

if ($k_page>1)str("?",$k_page,$page);

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