<?
echo '<div class="lines"> <img src="design/img/icon2.png"> Меню </div><div class="block">';
$news=mysql_result(mysql_query("SELECT COUNT(*) FROM `news`"),0);
$chat=mysql_result(mysql_query("SELECT COUNT(*) FROM `mchat`"),0);
$k_p = mysql_result(mysql_query("SELECT COUNT(*) FROM `files_file`"), 0);
$k_n = mysql_result(mysql_query("SELECT COUNT(*) FROM `files_file` WHERE `time` > '" . (time() - 60 * 60 * 24 * 1) . "'"), 0);
if ($k_n == 0)$k_n = NULL;
else $k_n = '+' . $k_n;
echo '<div class="row"><a href="/news"><img src="design/img/icon1.png"> Новости <span class="kol">'.$news.'</span></a></div>';
echo '<div class="row"><a href="/mchat"><img src="design/img/icon1.png"> Sex - Чат <span class="kol">'.$chat.'</span></a></div>';
echo '<div class="row"><a href="/files/"><img src="design/img/icon1.png"> Категория <span class="kol">' . $k_p . ' <font color="red">' . $k_n . '</font></span></a></div>';
echo '<div class="row"><a href="/pages/users.php"><img src="design/img/icon1.png"> Пользователи <span class="kol">'.mysql_result(mysql_query("SELECT COUNT(*) FROM `users`"), 0).'</span></a></div>';
$all_size = mysql_fetch_row(mysql_query('SELECT SUM(`size`) FROM `files_file` 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';
}
echo '<div class="row"><a href="/pages/stats.php"><img src="design/img/icon1.png"> Статистика<span class="kol">'.$all_size[0].'</span></a></div>';
echo '<div class="row"><a href="/wk/index.php"><img src="design/img/icon1.png"> Купить Рекламу <span class="kol">1р в день</span></a></div>';
echo '</div>';
?>