View file category.php

<?php
require_once('includes/connect.php');
include('includes/lang.php');

if(isset($_GET['id'])) {
$cid = intval($_GET['id']);
// Fetching Category
$queryCats = mysql_query('select id,name from file_cat where id = '.$cid.'');
$queryNum = mysql_query('select id from file_cat where id = '.$cid.'');
if(mysql_num_rows($queryNum)>0){
$all = mysql_num_rows($queryNum);
while($catinfo = mysql_fetch_assoc($queryCats)){
$catname = $catinfo['name'];
$title = $lang["listing"].': '.$catname;
require_once('includes/header.php');
echo '<div class="title"><img src="'.$url.'/images/flz.png" alt="*"> '.$lang["listing"].': '.$catname.'</div>';
$queryFiles = mysql_query('select * from files where catid = '.$cid.' order by `id` desc limit '.$j.',10');
$queryNm = mysql_query('select id from files where catid = '.$cid.'');
if(mysql_num_rows($queryNm)>0){
$all = mysql_num_rows($queryNm);
while($file=mysql_fetch_assoc($queryFiles)){
$img = fileExt($file['name']);
if($img == jar) { $fimg = ''.$url.'/icon.php?id='.$file['id'].''; }
elseif(file_exists("images/$img.png")) { $fimg = ''.$url.'/images/'.$img.'.png'; }
else{ $fimg = ''.$url.'/images/file.png'; }
$Filetag = fileExt($file['name']);
$name = $file['name'];
$name = str_replace(".$Filetag","",$name);
echo '<div class="list">
<img src="'.$fimg.'" height="16" width="16"/> <a href="'.$url.'/load/file/'.$file['id'].'/'.hdm_converturl($name).'.html">'.$file['name'].'</a> ('.size($file['size']).')</div>';
}
mysql_free_result($queryFiles);
mysql_free_result($queryNm);
paging($all,$page,10,$url.'/category.php?id='.$cid.'&');
echo '<div class="list">
<form action="'.$url.'/category.php" method="GET">'.$lang["jump"].': <input type="hidden" name="id" value="'.$cid.'"/>
<input type="text" name="page" value="'.$page.'" size="3">
<input type="submit" value="'.$lang["btn-go"].'"> </form></div>'; 
} else {
echo '<div class="news">'.$lang["empty-msg"].'<br><a href="'.$url.'/user/upload.php">'.$lang["upload-here"].'</a></div>';
}
}
} else { header('location: '.$url.'/category.php'); }
} else
{ $title = $lang["filecat"];
require_once('includes/header.php');

// Listing Categories
echo '<div class="title"><img src="'.$url.'/images/cat.png" alt="*"> '.$lang["filecat"].'</div>';
$queryCats = mysql_query('select * from file_cat order by `name` asc limit 20');
$queryNum = mysql_query('select id from file_cat');
if(mysql_num_rows($queryNum)>0){
$all = mysql_num_rows($queryNum);
while($ct=mysql_fetch_assoc($queryCats)){
$cat_id = $ct['id'];
$img = $ct['img'];
if(!empty($img)) { $img= '<img src="'.$img.'" height="16" width="16"/>'; }
else { $img= '<img src="'.$url.'/images/folder.png" height="16" width="16"/>'; }
$reqCats = mysql_query("SELECT COUNT(*) FROM `files` WHERE `catid` = '$cat_id'");
$catfiles = mysql_result($reqCats, 0);
echo '<div class="list">'.$img.' <a href="'.$url.'/loads/'.$ct['id'].'/'.hdm_converturl($ct['name']).'.html">'.$ct['name'].'</a> ('.$catfiles.')</div>';
}
mysql_free_result($queryCats);
mysql_free_result($queryNum);
} else {
echo '<div class="news">'.$lang["empty-msg"].'</div>';
}
}
include ('includes/footer.php');
?>