Файл: www/loads/index.php
Строк: 64
<?php
include '../config.php';
$timm=time()-60*60*24;
$ntime = time() - (3600*24*1);
div('Загрузки');
$total_mp3=mysql_num_rows(mysql_query('SELECT `id` FROM `music`'));
echo '<img src="http://rugame.mobi/ic_m25.gif"> <a href="/mp3/">Музыка</a> ['.$total_mp3.']<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="http://rugame.mobi/ic_m6.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="http://rugame.mobi/ic_m7.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/ic_m9.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="http://rugame.mobi/ic_m8.gif"> <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="http://rugame.mobi/ic_m11.gif"> <a href="/vid">Видео</a> ['.$total_vi.']<br/>';
//echo '<img src="/image/16_t.gif"> <a href="/theme/">Темы</a> [0]<br/>';
$pic=mysql_num_rows(mysql_query('SELECT `id` FROM `pic_files`'));
echo '<img src="/image/1_p.gif"> <a href="/pic/">Картинки</a> ['.$pic.']<br/>';
echo '</div>';
include '../foot.php';
echo '</div>';
?>