File size: 4.37Kb
<?
echo '<div class="menu_razd">Главное меню</div>';
/*----------------------------------------------------------------------------------------------------------*/
echo '<div class="main_menu"><a href="/news/">Новости <span class="count">[';
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `news`",$db), 0);
$k_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `news` WHERE `time` > '".(time()-86400)."'",$db), 0);
if ($k_n==0)$k_n=NULL;
else $k_n='/+'.$k_n;
echo "$k_p$k_n";
echo ']</span></a>';
/*----------------------------------------------------------------------------------------------------------*/
echo '<a href="/chat/">Чат <span class="count">[';
if (isset($user))mysql_query("DELETE FROM `chat_who` WHERE `id_user` = '$user[id]'");
mysql_query("DELETE FROM `chat_who` WHERE `time` < '".($time-120)."'");
echo mysql_result(mysql_query("SELECT COUNT(*) FROM `chat_who`"),0).' человек';
echo ']</span></a>';
/*----------------------------------------------------------------------------------------------------------*/
echo '<a href="/forum/">Форум <span class="count">[';
if (!isset($set['forum_counter']) || $set['forum_counter']==0)
{
$adm_add_mass=NULL;
$adm_add=NULL;
if (!isset($user) || $user['level']==0){
$q222=mysql_query("SELECT * FROM `forum_f` WHERE `adm` = '1'");
if (mysql_num_rows($q222)!=0) {
$adm_add=' WHERE ';
while ($adm_f = mysql_fetch_assoc($q222))
{
$adm_add_mass[]=$adm_f['id'];
}
for ($zzz=0;$zzz<count($adm_add_mass);$zzz++)
{
$adm_add.="`id_forum` <> '$adm_add_mass[$zzz]'";
if (count($adm_add_mass)!=$zzz+1)$adm_add.= ' AND ';
}
}
}
//echo $adm_add;
echo mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_p`$adm_add"),0).'/'.mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_t`$adm_add"),0);
}
else
{
echo mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `date_last` > '".(time()-600)."' AND `url` like '/forum/%'"), 0).' человек';
}
echo ']</span></a>';
/*----------------------------------------------------------------------------------------------------------*/
echo '<a href="/guest/">Гостевая <span class="count">[';
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `guest`",$db), 0);
$k_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `guest` WHERE `time` > '".(time()-86400)."'",$db), 0);
if ($k_n==0)$k_n=NULL;
else $k_n='/+'.$k_n;
echo "$k_p$k_n";
echo ']</span></a>';
/*----------------------------------------------------------------------------------------------------------*/
echo '<a href="/loads/">Загрузки <span class="count">[';
echo k_files();
echo ']</span></a>';
/*----------------------------------------------------------------------------------------------------------*/
echo '<a href="/obmen/">Файлобменник <span class="count">[';
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `obmennik_files`",$db), 0);
$k_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `obmennik_files` WHERE `time` > '".(time()-60*60*$set['loads_new_file_hour'])."'",$db), 0);
if ($k_n==0)$k_n=NULL;
else $k_n='/+'.$k_n;
echo "$k_p$k_n";
echo ']</span></a>';
/*----------------------------------------------------------------------------------------------------------*/
echo '<a href="/foto/">Фотогалерея <span class="count">[';
echo mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery_foto`"),0);
echo "/";
echo mysql_result(mysql_query("SELECT COUNT(*) FROM `gallery`"),0);
echo ']</span></a>';
/*----------------------------------------------------------------------------------------------------------*/
echo '<a href="/votes/">Опросы <span class="count">[';
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `survey_s`",$db), 0);
$k_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `survey_s` WHERE `time_close` > '$time'",$db), 0);
if ($k_n==0)$k_n=NULL;
else $k_n='/+'.$k_n;
echo "$k_p$k_n";
echo ']</span></a>';
/*----------------------------------------------------------------------------------------------------------*/
echo '<a href="/lib/">Библиотека <span class="count">[';
$k_p=mysql_result(mysql_query("SELECT COUNT(*) FROM `lib_files`",$db), 0);
$k_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `lib_files` WHERE `time` > '".(time()-86400)."'",$db), 0);
if ($k_n==0)$k_n=NULL;
else $k_n='/+'.$k_n;
echo "$k_p$k_n";
echo ']</span></a>';
/*----------------------------------------------------------------------------------------------------------*/
echo '</div>';
?>