View file Spiderwap.in File Hosting/category.php

<?php
require('sys/config.php');

$all = $sql->result('SELECT COUNT(*) FROM `cat`');
if($all==0){
$smarty->assign('title','Categories');
$smarty->assign('error','no categories');
$smarty->assign('back','index.php');
$smarty->display('header.tpl');
$smarty->display('error.tpl');
$smarty->display('footer.tpl');
}

@$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;}
$cats = $sql->query('SELECT * FROM `cat` ORDER BY `id` DESC LIMIT '.intval($page*$onp-$onp).','.$onp);
while($cat1 = $cats->fetch_assoc()) $cat[] = $cat1;

$smarty->assign('title','Categories');
$smarty->assign('cat',$cat);
$smarty->assign('all',$allp);
$smarty->assign('one',$onp);
$smarty->assign('page',$page);
$smarty->assign('vse',$all);

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


?>