<?
$bInitialLoad = true;
$timePageStart = microtime(true);
include_once("inc/connect.php");
$bInitialLoad = false;
$filename = mysql_real_escape_string($_GET['filename']);
$origFilename = $filename;
$pcount = isset($_GET['count'])?intval($_GET['pcount']):1;
//echo "SELECT * FROM filenames WHERE filename='$filename' ORDER BY fnid ASC";
$fnres = mysql_query("SELECT *, COALESCE(productmenu.live,0) as prod_live, IF(type=6,1,0) as is_redirect FROM filenames
 LEFT JOIN productmenu on (filenames.id=productmenu.productid and filenames.mid=productmenu.pmid)
WHERE filename='$filename' ORDER BY is_redirect DESC, prod_live DESC, fnid ASC") or die(mysql_error());
if (mysql_num_rows($fnres) == 0) {
header("HTTP/1.1 404 Not Found");
include("error.php");
exit; 
}
$cnt = 0;

$frow = mysql_fetch_assoc($fnres);

$type = $frow['type'];
$origType = $type;
$id = $frow['id'];
$mid = $frow['mid'];
//if ($cnt == $pcount) { break; }


if ($type == 1) { //PAGE
	$_GET['pg'] = $id;
	$_GET['mn'] = $mid;
	
	$nav_pg=$mid.'_0_0';
	$canonicalUrl = $frow['filename'];
	include("page.php");
} elseif ($type == 3) { //CATEGORY
	$_GET['cid'] = $id;
	$_POST['cid'] = $id;
	
	$nav_pg='0_'.$id.'_0';

	$page = isset($_GET['pg'])?$_GET['pg']:1;
	$crow = $app->getDb()->fetchRow($app->getDb()->select()->from('cat')->where('cid=?', $id));
	if ($crow['new_design'] === '1') {
	    $cid = $id;
	    include 'productlistnew.php';
    } else {
        include("productlist.php");
    }
} elseif ($type == 2) { //PRODUCT

	$_GET['pid'] = $id;
	$_POST['pid'] = $id;
	$_GET['mn'] = $mid;
	$_POST['mn'] = $mid;
	
	$sql = "
		
		SELECT * FROM
			productmenu
		WHERE
			productid=$id
		
	";
	
	$res = mysql_query($sql) or die(mysql_error());
	$rec = mysql_fetch_assoc($res);
	
	$nav_pg='0_'.$rec['categoryid'].'_0';
	
	include("productdetail.php");

}elseif ($type == 4) { //NEWS

	$_GET['nid'] = $id;
	$_POST['nid'] = $id;
	$_GET['mn'] = $mid;
	$_POST['mn'] = $mid;
	include("news.php");

}elseif ($type == 5) { //FORM

	$_GET['id'] = $id;
	$_POST['id'] = $id;
	$_GET['mn'] = $mid;
	$_POST['mn'] = $mid;
	
	
	$nav_pg='0_0_'.$id;
	
	include("form.php");

} elseif ($type == 6) { //re-direct
	$redir = $frow['redirect'];
        $code = $frow['redirect_code'];
        if ($code == 404) {
            header('HTTP/1.1 404 Not Found');
			$errorHeaderSent = true;
            include_once('error.php');
            exit;
        } elseif ($code == 410) {
            header('HTTP/1.1 410 Gone');
			$errorHeaderSent = true;
            include_once('error.php');
            exit;
        } elseif ($code == 302) {
            header('HTTP/1.1 302 Moved Temporarily');
            header('Location: '.$redir);
        } else {
            header('HTTP/1.1 301 Moved Permanently');
            header('Location: '.$redir);
        }
	exit;
}