Файл: www/vid/index.php
Строк: 99
<?
include '../config.php';
div('Видео');
echo '<div class="msg1">';
$ntime = time() - (3600*24*1);
$total_f= mysql_result(mysql_query("SELECT COUNT(*) FROM `games_video` WHERE (`cat_id` > '0' && `cat_id` < '99');"),0);
$new_f = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_video` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."') and (`cat_id` > '0' && `cat_id` < '99');"),0);
if($new_f>0) $total_f.='/<a href="/video/new_ld/1/"><font color="red"><b>+'.$new_f.'</b></font></a>';
echo '<a href="/video/?rid=1">Мобильные фильмы</a> ['.$total_f.']<br/>';
$total_s= mysql_result(mysql_query("SELECT COUNT(*) FROM `games_video` WHERE (`cat_id` > '99' && `cat_id` < '199');"),0);
$new_s = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_video` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."') and (`cat_id` > '99' && `cat_id` < '199');"),0);
if($new_s>0) $total_s.='/<a href="/video/new_ld/2/"><font color="red"><b>+'.$new_s.'</b></font></a>';
//echo '<a href="/video/?rid=2">Сериалы</a> ['.$total_s.']<br/>';
$total_an= mysql_result(mysql_query("SELECT COUNT(*) FROM `games_video` WHERE (`cat_id` > '199' && `cat_id` < '299');"),0);
$new_an = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_video` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."') and (`cat_id` > '199' && `cat_id` < '299');"),0);
if($new_an>0) $total_an.='/<a href="/video/new_ld/3/"><font color="red"><b>+'.$new_an.'</b></font></a>';
//echo '<a href="/video/?rid=3">Аниме</a> ['.$total_an.']<br/>';
$total_and= mysql_result(mysql_query("SELECT COUNT(*) FROM `games_and` WHERE (`cat_id` > '299' && `cat_id` < '399');"),0);
$new_and = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_and` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."') and (`cat_id` > '299' && `cat_id` < '399');"),0);
if($new_and>0) $total_and.='/<a href="/android/new_ld/4/"><font color="red"><b>+'.$new_and.'</b></font></a>';
//echo '<a href="/video/?rid=4">Эротика</a> ['.$total_e.']<br/>';
$total_and= mysql_result(mysql_query("SELECT COUNT(*) FROM `games_and` WHERE (`cat_id` > '399' && `cat_id` < '499');"),0);
$new_and = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_and` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."') and (`cat_id` > '399' && `cat_id` < '499');"),0);
if($new_and>0) $total_and.='/<a href="/android/new_ld/5/"><font color="red"><b>+'.$new_and.'</b></font></a>';
//echo '<a href="/video/?rid=5">Муз. Клипы</a> ['.$total_mz.']<br/>';
$total_p= mysql_result(mysql_query("SELECT COUNT(*) FROM `games_video` WHERE (`cat_id` > '499' && `cat_id` < '599');"),0);
$new_p = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_video` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."') and (`cat_id` > '499' && `cat_id` < '599');"),0);
if($new_p>0) $total_p.='/<a href="/video/new_ld/6/"><font color="red"><b>+'.$new_p.'</b></font></a>';
//echo '<a href="/video/?rid=6">Приколы</a> ['.$total_p.']<br/>';
$total_and= mysql_result(mysql_query("SELECT COUNT(*) FROM `games_and` WHERE (`cat_id` > '599' && `cat_id` < '699');"),0);
$new_and = mysql_result(mysql_query("SELECT COUNT(*) FROM `games_and` WHERE (`added` > '".$ntime."' or `two_added` > '".$ntime."') and (`cat_id` > '599' && `cat_id` < '699');"),0);
if($new_and>0) $total_and.='/<a href="/android/new_ld/7/"><font color="red"><b>+'.$new_and.'</b></font></a>';
//echo '<a href="/video/?rid=7">Мульты</a> ['.$total_m.']<br/>';
echo '<br/>';
echo '<a href="/forum/?tid=33722">Закажи видео</a><br/>';
echo '<a href="/">Новинки видео</a><br/>';
echo '<a href="/video/search.php">Поиск по названию</a><br/>';
echo '<a href="/info/adm_mod.php?ad=13">Администрация раздела</a><br/>';
echo '</div>';
include '../foot.php';
echo '</div>';
?>