require_once("includes/mysql.inc.php");
$url_array=explode("/",$_SERVER['REQUEST_URI']);
$id = $url_array[2];
$ime = $url_array[3];
$alpha_id = $url_array[4];
mysql_query("UPDATE categories SET views=views+1 WHERE id='".$id."'") or die("LINE ".__LINE__.": ".mysql_error());
$query2 = "SELECT * FROM categories WHERE id='".$id."'";
$resr = mysql_query($query2) or die("LINE ".__LINE__.": ".mysql_error());
$arr = mysql_fetch_array($resr);
$page_title = $arr[name];
require("header.php");
$query2 = "SELECT * FROM categories WHERE id=".$arr[rootid];
if(!empty($alpha_id))
$query2 .= " AND name LIKE '".$alpha_id."%'";
$res2 = mysql_query($query2) or die("LINE ".__LINE__.": ".mysql_error());
$ar2 = mysql_fetch_array($res2);
echo '
'.$page_title.' Wallpapers
';
// Show Subcategories
$m=0;
$query2 = "SELECT * FROM categories WHERE (rootid='".$arr[id]."' OR rootid2='".$arr[id]."' OR rootid3='".$arr[id]."')";
$query2 .= " ORDER BY name";
$res = mysql_query($query2) or die("LINE ".__LINE__.": ".mysql_error());
$m=0;
if(mysql_num_rows($res)>0)
{
echo '';
}
// Show Description
if(!empty($arr[description]))
{
echo '';
}
//Show Gallery
$resg = mysql_query("SELECT * FROM wallpapers WHERE category = ".$arr[id]) or die("ERROR ".__LINE__.": ".mysql_error());
$num = mysql_num_rows($resg);
if(empty($_REQUEST['page']))
$_REQUEST['page'] = 1;
$hits = 12;
$start = ($_REQUEST['page']-1)*$hits;
$sortOption = "datum DESC";
$query2 = "SELECT * FROM wallpapers WHERE category=".$id." ORDER BY ".$sortOption." LIMIT ".$start.",".$hits;
$resg = mysql_query($query2) or die("LINE ".__LINE__.": ".mysql_error());
if($num>0)
{
echo ''.$arr[name].' Wallpapers Gallery
';
echo '';
ShowPages($num,$_REQUEST['page'],$hits);
echo '
';
echo '
';
while($arg = mysql_fetch_array($resg))
echo '
'."\n";
echo '
';
echo '';
ShowPages($num,$_REQUEST['page'],$hits);
echo '
';
}
include("footer.php");
?>