<?php
$news_count = mysql_result(mysql_query("SELECT COUNT(*) FROM `news`"),0);
$user_count = mysql_result(mysql_query("SELECT COUNT(*) FROM `user`"),0);
$user_countn = mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `time_reg` > ". (time()-43200) .""),0);
$user_on = mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `time_last` > ". (time()-600) .""), 0);
$guest_count = mysql_result(mysql_query("SELECT COUNT(*) FROM `guest`"),0);
$guest_new_count = mysql_result(mysql_query("SELECT COUNT(*) FROM `guest` WHERE `time` > ". (time()-86400) .""),0);
?>
<? $query = mysql_query("SELECT * FROM `news` WHERE `time` > '". (time()-60 * 60 * 24 * 30) ."' ORDER BY `time` DESC LIMIT 1");
while ($newsone = mysql_fetch_assoc($query)){
$k_komm = mysql_result(mysql_query("SELECT COUNT(*) FROM `news_comments` WHERE `news_id` = '$newsone[id]'"),0);
$knew_komm = mysql_result(mysql_query("SELECT COUNT(*) FROM `news_comments` WHERE `news_id` = '$newsone[id]' AND `time` > ". (time()-86400) .""),0);
if (string($newsone['txt']) <= 500) $news_msg = output($newsone['txt']);
else $news_msg = output(cut($newsone['txt'], 500)) .'... <a href="/scripts/news.php?komm='.$newsone['id'].'" title="Читать дальше"><b>»</b></a>';
echo '<div id="menu">';
echo ' '.htmlspecialchars($newsone['name']).' </div> <div class="post0"> '.$news_msg.'<br>';
echo '</div>';
echo '
<div id="menu">Общее</div>
<div id="link">
<a href="/news/"><span class="arrow"><img src="/img/paper.png" alt="icon" /> Новости ('.$news_count.')</span></a>
<a href="/gb/"><span class="arrow"><img src="/img/guestbook.png" alt="icon" /> Гостевая <span class="color">('.$guest_count.' '.($guest_new_count > 0? '/ <font color="red">+'.$guest_new_count.'</font>' : '').')</span></a>
<a href="/sites/"><span class="arrow"><img src="/img/guestbook.png" alt="icon" /> Список сайтов<span class="color">('.$user_count.' '.($user_countn > 0? '/ <font color="red">+'.$user_countn.'</font>' : '').')</span></span></a>
</div>';
} ?>