View file Spiderwap.in File Hosting/cats.php

<?php

require 'sys/config.php';
$id = isset($_GET['id'])?fil($_GET['id'],'int'):'';
if($sql->result('SELECT COUNT(*) FROM `cat` WHERE `id`="'.$id.'"')==0)
{
$smarty->assign('title','Error');
$smarty->assign('back','/index.php');
$smarty->assign('error','This category does not exist');
$smarty->display('header.tpl');
$smarty->display('error.tpl');
$smarty->display('footer.tpl');
}

$all = $sql->result('SELECT COUNT(*) FROM `files` WHERE `cat_id`="'.$id.'"');
if($all==0){
$smarty->assign('title','List of files');
$smarty->assign('error','Files in this category do not have');
$smarty->assign('back','category.php');
$smarty->display('header.tpl');
$smarty->display('error.tpl');
$smarty->display('footer.tpl');
}

$name = $sql->query('SELECT `name` FROM `cat` WHERE `id`="'.$id.'"')->fetch_assoc();
$name = fil($name['name'],'echo');
@$page = abs(intval($_GET['page']));
if(empty($page)){$page = 1;}

$onp = $sql->query('SELECT `onp` FROM `config` LIMIT 1')->fetch_assoc();
$onp = $onp['onp'];


$allp = ceil($all/$onp);
if($page>$allp){$page=$allp;}


$order = !empty($_GET['sort'])?$_GET['sort']:'id_desc';
$order = explode('_',$order);

$smarty->assign('sorts',array('id_desc'=>'ID desc',
                              'id_asc'=>'ID desc',
                              'time_asc'=>'By Time',
                              'time_desc'=>'time increase',
                              'kol_asc'=>'Downloads (high to low)',
                              'kol_desc'=>'Downloads (low to high)',
                              'rait_asc'=>'Rate decrease',
                              'rait_desc'=>'Rating increase'));

if(!in_array($order[0],array('id','time','kol','rait'))){$order[0] = 'id';}
if(!in_array($order[1],array('asc','desc'))){$order[1] = 'desc';}
$cats = $sql->query('SELECT `name`,`id` FROM `files` WHERE `cat_id`="'.$id.'" ORDER BY `'.$order[0].'` '.$order[1].' LIMIT '.intval($page*$onp-$onp).','.$onp);

while($cat1 = $cats->fetch_assoc()) $cats1[] = $cat1;

$smarty->assign('title','Categories| '.$name);
$smarty->assign('files',$cats1);
$smarty->assign('name',$name);
$smarty->assign('cat',$id);
$smarty->assign('all',$allp);
$smarty->assign('one',$onp);
$smarty->assign('page',$page);
$smarty->assign('vse',$all);

$smarty->display('header.tpl');
$smarty->display('cat.tpl');
$smarty->display('footer.tpl');


?>