<?php
require_once('includes/includes.inc.php');
define("TPL_NAME", "portfolio2");

$db->sql_query("SELECT * FROM cats ORDER BY position");
$cats=$db->fetched_array();

if (isset($_GET['cid'])) 
{
	foreach ($cats  as $val) 
		if ($val['id'] == $_GET['cid']) 
		  $ccat=$val;	
	$db->sql_query("SELECT * FROM	subcats WHERE cat_id=".$_GET['cid']);
	$csubcats=$db->fetched_array();
	$db->sql_query("SELECT * FROM subcats  WHERE cat_id=".$_GET['cid']." ORDER BY position");
	$csubcats=$db->fetched_array();
	if (!empty($csubcats)) 
	{
		$csubcat=$csubcats[0];
	}	
}

if (isset($_GET['sid'])) 
{
	$db->sql_query("SELECT * FROM subcats WHERE id=".$_GET['sid']);
	$csubcat=$db->fetch();
	if ($csubcat) 
	{
	  foreach ($cats  as $val) 
	    if ($val['id'] == $csubcat['cat_id']) 
		  $ccat=$val;	
	//  $db->sql_query("SELECT * FROM subcats WHERE cat_id=".$csubcat['cat_id']);
	 // $csubcats=$db->fetched_array();		  
		  
	}
	if (isset($ccat))
	{ $db->sql_query("SELECT * FROM subcats WHERE cat_id=".$ccat['id']." ORDER BY position");
	  $csubcats=$db->fetched_array();		  
	}
	
}

if (!isset($ccat)) 
{
	
$db->sql_query("
	SELECT cats.* FROM cats 
	LEFT JOIN subcats
	ON cats.id = subcats.cat_id 
	WHERE cats.id IS NOT NULL ORDER BY cats.position LIMIT 1;
	");
	$ccat=$db->fetch();
	if (!empty($ccat)) 
	$db->sql_query("SELECT * FROM subcats WHERE cat_id=".$ccat['id']);
	$csubcats=$db->fetched_array();
	if (!empty($csubcats)) 
	{
		$csubcat=$csubcats[0];
	}
}
$smarty->assign('csubcats',$csubcats);
$smarty->assign('cats',$cats);
//$smarty->assign('subcats',$subcats);

$smarty->assign('ccat',$ccat);

$smarty->assign('csubcat',$csubcat);
$smarty->display(TPL_NAME.'.html');
?>