Файл: www/menu.php
Строк: 107
<?php
$timm=time()-60*60*24;
$times=time()-60*60*24*7;
$ntime = time() - (3600*24*1);
$chat=mysql_num_rows(mysql_query("SELECT `id` FROM `users` WHERE `link1`<>''"));
echo '<img src="/image/5_c.gif"> <a href="/chat/">Чат</a> ['.$chat.']<br/>';
$forum=mysql_num_rows(mysql_query("SELECT `id` FROM `users` WHERE `link2`<>''"));
echo '<img src="/image/11_f.gif"> <a href="/forum/">Форум</a> ['.$forum.']<br/>';
$gp_who=mysql_num_rows(mysql_query("SELECT `id` FROM `users` WHERE `link4`<>''"));
echo '<img src="/image/gp.gif"> <a href="/gp/">Группы</a> ['.$gp_who.']<br/>';
$total_mp3=mysql_num_rows(mysql_query('SELECT `id` FROM `music`'));
echo '<img src="/image/music.png"> <a href="/mp3/">Музыка</a> [85 млн.]<br/>';
$alb=mysql_num_rows(mysql_query("SELECT `id` FROM `alb`"));
echo '<img src="/image/12_a.gif"> <a href="/album/">Альбомы</a> ['.$alb.']<br/>';
$blog=mysql_num_rows(mysql_query("SELECT `id` FROM `users` WHERE `link3`<>''"));
echo '<img src="/image/9_b.gif"> <a href="/blog/">Дневники</a> ['.$blog.']<br/>';
$mgame=mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `link`='OnLine игра [<a href=/mf/>Мафия</a>]'"));
$mgame2=mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `link`='OnLine игра [<a href=/ferma/Ферма</a>]'"));
$mgame3=$mgame+$mgame2;
echo '<img src="/image/10_o.gif"> <a href="/mgame/">OnLine игры</a> ['.$mgame3.']<br/>';
//echo '<img src="/image/3_s.gif"> <a href="/anime/">Аниме загрузки</a> [0]<br/>';
$total_3d=mysql_result(mysql_query("SELECT COUNT(*) FROM `gamess` WHERE `3d`=1"),0);
$total_bt=mysql_result(mysql_query("SELECT COUNT(*) FROM `gamess` WHERE `bluetooth`=1"),0);
$total_game=mysql_result(mysql_query("SELECT COUNT(*) FROM `gamess`"),0);
$new_game=mysql_result(mysql_query("SELECT COUNT(*) FROM `gamess` WHERE `added`>'$timm' OR `updated`>'$timm'"),0);
if($new_game>0) $total='/<a href="/new_ld/1/"><font color="red"><b>+'.$new_game.'</b></font></a>';
echo '<img src="/image/jg.gif"> <a href="/game/">Java игры</a> ['.($total_game+$total_bt+$total_3d).''.$total.']<br/>';
$total_app=mysql_result(mysql_query("SELECT COUNT(*) FROM `app_games`"),0);
$new_app=mysql_result(mysql_query("SELECT COUNT(*) FROM `app_games` WHERE `added`>'$timm' OR `updated`>'$timm'"),0);
if($new_app>0) $total_app.='/<a href="/new_ld/2/"><font color="red"><b>+'.$new_app.'</b></font></a>';
echo '<img src="/image/js.gif"> <a href="/app/">Java софт</a> ['.$total_app.']<br/>';
$total_ip= mysql_result(mysql_query("SELECT COUNT(*) FROM `games` WHERE (`cat_id` > '250' && `cat_id` < '300');"),0);
$new_ip = mysql_result(mysql_query("SELECT COUNT(*) FROM `games` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."') and (`cat_id` > '250' && `cat_id` < '300');"),0);
if($new_ip>0) $total_ip.='/<a href="/games/new_ld/5/"><font color="red"><b>+'.$new_ip.'</b></font></a>';
//echo '<img src="/image/iphone.gif"> <a href="/games/?rid=8">iPhone</a> ['.$total_ip.']<br/>';
$total_and_app = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_and` WHERE (`cat_id` > '0' && `cat_id` < '99');"),0);
$new_and_app = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_and` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."') and (`cat_id` > '0' && `cat_id` < '99');"),0);
if($new_and_app>0) $total_and_app.='/<font color="red"><b>+'.$new_and_app.'</b></font>';
echo '<img src="/image/android.gif"> <a href="/and">Android</a> ['.$total_and_app.']<br/>';
$total_sy = mysql_result(mysql_query("SELECT COUNT(*) FROM `games` WHERE (`cat_id` > '38' && `cat_id` < '80');"),0);
$new_sy = mysql_result(mysql_query("SELECT COUNT(*) FROM `games` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."') and (`cat_id` > '38' && `cat_id` < '80');"),0);
if($new_sy>0) $total_sy.='/<font color="red"><b>+'.$new_sy.'</b></font>';
echo '<img src="/image/symb.png"> <a href="/symba">Symbian</a> ['.$total_sy.']<br/>';
$total_vi= mysql_result(mysql_query("SELECT COUNT(*) FROM `games_video` ;"),0);
$new_vi = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_video` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."');"),0);
if($new_vi>0) $total_vi.='/<font color="red"><b>+'.$new_vi.'</b></font>';
echo '<img src="/image/films.gif"> <a href="/video/">Фильмы</a> ['.$total_vi.']<br/>';
$theme=mysql_num_rows(mysql_query("SELECT * FROM `theme_file`"));
$new_theme=mysql_result(mysql_query("SELECT COUNT(*) FROM `theme_file` WHERE `time` > '$ntime'"),0);
$new_themes=mysql_result(mysql_query("SELECT COUNT(*) FROM `theme_file` WHERE `time` > '$times'"),0);
if($new_themes>0) $themes.='<font color="blue"><b>+'.$new_themes.'</b></font>';
if($new_theme>0) $theme.='/<font color="red"><b>+'.$new_theme.'</b></font>';
echo '<img src="/image/16_t.gif"> <a href="/theme/">Темы</a> ['.$theme.''.$themes.']<br/>';
$pic=mysql_num_rows(mysql_query('SELECT `id` FROM `pic_files`'));
$new_pic = mysql_result(mysql_query("SELECT COUNT(*) FROM `pic_files` WHERE (`time_d` > '".$timm."');"),0);
if($new_pic>0) $pic.='/<a href="/pic/"><font color="red"><b>+'.$new_pic.'</b></font></a>';
echo '<img src="/image/1_p.gif"> <a href="/pic/">Картинки</a> ['.$pic.']<br/>';
$obm=mysql_num_rows(mysql_query('SELECT * FROM `obm_file`'));
echo '<img src="/image/2_o.gif"> <a href="/obm/">Обменник</a> ['.$obm.']<br/>';
echo '<img src="/image/3_s.gif"> <a href="/shop/">Наш магазин</a><br/>';
echo '<img src="/image/4_s.gif"> <a href="/servis/">Наши сервисы</a><br/>';
$k=mysql_num_rows(mysql_query("SELECT * FROM `users` WHERE `sess`<>'' AND `reload`>'".($time-1200)."'"));
//$k=$k*6;
echo '<img src="/image/6_o.gif"> <a href="online.php">Кто в OnLine</a> ['.$k.']<br/>';
?>