Файл: www/game/bt_games.php
Строк: 14
<?php
include '../config.php';
if(!isset($_GET['id'])){
div('BT Java');
$q=mysql_query("SELECT * FROM `categoryss` ORDER BY `id` ASC");
while($dir=mysql_fetch_array($q)){
$timm=time()-60*60*24;
$total_files=mysql_result(mysql_query("SELECT COUNT(*) FROM `gamess` WHERE `cat_id`='$dir[id]' AND `bluetooth`=1"),0);
$new_files = mysql_result(mysql_query("SELECT COUNT(*) FROM `gamess` WHERE (`added`>'$timm' OR `updated`>'$timm') AND `cat_id`='$dir[id]' AND `bluetooth`=1"),0);
if($new_files>0) $total_files.="<font color=red>+$new_files</font>";
echo "<a href=?id=$dir[id]>$dir[name]</a> [$total_files]<br/>";}}
if(isset($_GET['id']) && is_numeric($_GET['id'])){
$dir_id=intval($_GET['id']);
$q=mysql_query("SELECT * FROM `categoryss` WHERE `id`=$dir_id");
$dir=mysql_fetch_array($q);
if(!$dir){
div('Ошибка');
echo "Выбранной Вами категории не существует";
}else{
div($dir['name']);
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `gamess` WHERE `cat_id`=$dir[id] AND `bluetooth`=1"),0);
$s=mysql_query("SELECT * FROM `gamess` WHERE `cat_id`=$dir[id] AND `bluetooth`=1 ORDER BY `updated` DESC");
if($k_post!=0){
while($file=mysql_fetch_array($s)){
if($file['updated']!=NULL){
$vre=$file['updated'];
}else{
$vre=$file['added'];}
echo "<a href=file.php?id=$file[id]>$file[name]</a> [".data($vre)."]<br/>";}
}else{
echo "Нет файлов в выбраной Вами категории";}}}
echo '</div>';
include '../foot.php';
echo '</div>';
?>