<?	

session_start();

	
	require 'lib/smarty/Smarty.class.php';
	require 'inc/config.inc.php';
	require 'inc/menuereader.inc.php';

	$page 		= "SITEMAP"; 
	
	

	// Menü befüllen --------------------------
	$smarty = new Smarty;
	$smarty->assign("page", $page , true);
	$smarty->assign("language", $language, true);
	$smarty->assign("plan_list", $plan_list, true);
	$smarty->assign("model_list", $model_list, true);


	// -------------------------------------------------
	// Alle Article auslesen !!!!!!
	// -------------------------------------------------
	$qry 		= "SELECT 
							  fw_cms_text.article_id as article_id,
							  fw_cms_content.id,
							  fw_cms_content.create_date,
							  fw_cms_text.headertext as title
							FROM
							  fw_cms_text
							  INNER JOIN fw_cms_content ON (fw_cms_text.article_id = fw_cms_content.id)
							WHERE	
							  fw_cms_content.reftype = 'ARTICLE' 		
							AND  				    							  
							  fw_cms_text.`language` = '$language'	  
							ORDER BY
							  fw_cms_content.create_date DESC";	
	$articles 	= array();
	$res 		= $mysqli->query($qry);	
	

	while($row = $res->fetch_assoc()) {
		$urltext		= urlencode($row['title']);
		$urltext 		= str_replace("%", '', $urltext);
		$row['urltext'] = $urltext;	
		$articles[] 	= $row;
	}
	$smarty->assign('articles', $articles, true);


	// -------------------------------------------------
	// Alle Bausätze auslesen !!!!!!
	// -------------------------------------------------
	$qry 		= "SELECT 
							  fw_cms_text.article_id as article_id,
							  fw_cms_content.id,
							  fw_cms_content.create_date,
							  fw_cms_text.headertext as title
							FROM
							  fw_cms_text
							  INNER JOIN fw_cms_content ON (fw_cms_text.article_id = fw_cms_content.id)
							WHERE	
							  fw_cms_content.reftype = 'BAUSATZ' 		
							AND  				    							  
							  fw_cms_text.`language` = '$language'	  
							ORDER BY
							  fw_cms_content.create_date DESC";	
	$kits 	= array();
	$res 		= $mysqli->query($qry);	

	while($row = $res->fetch_assoc()) {
		$urltext		= urlencode($row['title']);
		$urltext 		= str_replace("%", '', $urltext);
		$row['urltext'] = $urltext;	
		$kits[] 	= $row;
	}
	$smarty->assign('kits', $kits, true);


	// -------------------------------------------------
	// Alle Pläne auslesen !!!!!!
	// -------------------------------------------------
	$qry 		= "SELECT 
							  fw_cms_text.article_id as article_id,
							  fw_cms_content.id,
							  fw_cms_content.create_date,
							  fw_cms_text.headertext as title
							FROM
							  fw_cms_text
							  INNER JOIN fw_cms_content ON (fw_cms_text.article_id = fw_cms_content.id)
							WHERE	
							  fw_cms_content.reftype = 'PLAN' 		
							AND  				    							  
							  fw_cms_text.`language` = '$language'	  
							ORDER BY
							  fw_cms_content.create_date DESC";	
	$plans 	= array();
	$res 		= $mysqli->query($qry);	

	while($row = $res->fetch_assoc()) {
		$urltext		= urlencode($row['title']);
		$urltext 		= str_replace("%", '', $urltext);
		$row['urltext'] = $urltext;	
		$plans[] 	= $row;
	}
	$smarty->assign('plans', $plans, true);



	// -------------------------------------------------
	// Alle GALLERY auslesen !!!!!!
	// -------------------------------------------------
	$qry 		= "SELECT 
							  fw_cms_text.article_id as article_id,
							  fw_cms_content.id,
							  fw_cms_content.create_date,
							  fw_cms_text.headertext as title
							FROM
							  fw_cms_text
							  INNER JOIN fw_cms_content ON (fw_cms_text.article_id = fw_cms_content.id)
							WHERE	
							  fw_cms_content.reftype = 'GALLERY' 		
							AND  				    							  
							  fw_cms_text.`language` = '$language'	  
							ORDER BY
							  fw_cms_content.create_date DESC";	
	$gallery 	= array();
	$res 		= $mysqli->query($qry);	

	while($row = $res->fetch_assoc()) {
		$urltext		= urlencode($row['title']);
		$urltext 		= str_replace("%", '', $urltext);
		$row['urltext'] = $urltext;	
		$gallery[] 	= $row;
	}
	$smarty->assign('gallery', $gallery, true);


	$message = isset($_REQUEST['src']) ? "Uuups! File Not Found" : "Sitemap";	

		
	$smarty->assign('headertext', $message, true);	
	$smarty->assign('rand', $rand, true);								
	$smarty->assign('language', $language, true);
	
	$smarty->display('sitemap.tpl');
	
	


?>