<?
require_once 'config/init.php';

$wartung = $db->getSQL("SELECT * FROM ".PREFIX."sysparam WHERE param='WARTUNGSMODUS'");

if($wartung->getAt("value") == 1) {
	if(!isset($_COOKIE["disable_preview"])) {
		// Wenn Cookie nicht gesetzt ist, Fehlerseite anzeigen
		header("location:".SERVER_URL."/wartung.html");
	} else {
		$tmp = DB::getInstance()->getSQL("SELECT * FROM ".PREFIX."disable_preview WHERE preview_code = '".$_COOKIE["disable_preview"]."'");
		if($tmp->size != 1) {
			// Nutzer existiert nicht
			header("location:".SERVER_URL."/wartung.html");
		} else {
			$log = DB::getInstance()->getSQL("SELECT * FROM ".PREFIX."disable_preview_log WHERE preview_id = '".$tmp->getAt("preview_id")."' ORDER BY date DESC");
			$datum_heute = date("Y-m-d");
			#echo $datum_heute;
			#echo "<br>".$log->getAt("date");
			if($datum_heute != $log->getAt("date")) {
				#echo "<br>".$log->getAt("date");
				// User IP und Datum eintragen
				DB::getInstance()->insertSQL("INSERT INTO ".PREFIX."disable_preview_log (preview_id, ip, date, time) VALUES ('".$tmp->getAt("preview_id")."', '".$_SERVER['REMOTE_ADDR']."', CURDATE(), CURTIME())");
			}
		}
	}
}

/*
if(isset($_GET["set_lang"])) {
	if(!setcookie("lang", $save_lang, time()+24*3600)) {
		$onload = "onLoad=\"alert('Not able to set Cookie!');\"";
	}
	header("location:index.php?katID=".$katID);
}
*/

/*
//wenn keine Sprache, dann DE
if(!isset($lang) AND !isset($save_lang)) {
	// darf nicht länger als zwei zeichen sein
	#if(strlen($lang) != 2) {
		$lang = "de";
		include("lang/".$lang.".php");
	#}
} else {
  if(file_exists("lang/".$lang.".php")) {
		include("lang/".$lang.".php");
	} else {
		include("lang/en.php");
	}
}
*/
/*
//wenn Cookie, dann Sprache aus Cookie
if(isset($_GET["save_lang"]))
{
	if(strlen($save_lang) != 2) {
		$lang = "de";
	} else {
		$lang = $save_lang;
	}
}
*/

if(isset($_REQUEST["lang"])) {
	$lang = $_REQUEST["lang"];
} else {
	$lang = "de";
}

//Wenn keine KatID, dann Startseite
if(!isset($_REQUEST["katID"]) OR $_REQUEST["katID"]=="") {
	$tmp = DB::getInstance()->getSQL("
		SELECT
			menu_id
		FROM ".PREFIX."menu_entry
		WHERE
			startseite = 1
		AND
			lang = '".$lang."'
	");
	$_REQUEST["katID"] = $tmp->getAt("menu_id");
}

if(isset($suchbegriff) AND $suchbegriff!="") {
	//Template laden -------------------------------
	$template = new Page(DOMAIN_1_NAME."[page_title]", "../templates/suche.html");

	$liste = DB::getInstance()->getSQL("SELECT LEFT(headline_$lang, 100) as headline, infotext_$lang as infotext, LEFT(inhalt_$lang, 500) as inhalt, kat_id,
	                      ROUND(MATCH (inhalt_$lang) AGAINST ('$suchbegriff'),2) as prozent FROM ".PREFIX."artikel
	                      WHERE (MATCH (inhalt_$lang) AGAINST ('$suchbegriff')) > 0
						  ORDER BY prozent DESC");

	$template->whileReplaceSearch($liste, "suche");
} else {
	//Template für Seite laden ----------------------
	
	if(isset($customer_login) OR isset($_COOKIE["mfg_usr"])) {
		//Alle Artikel anzeigen
		$artikel = DB::getInstance()->getSQL("SELECT a.id AS artikelID, headline AS headline, infobox_headline AS infobox_headline,
					infotext AS infotext, inhalt AS inhalt, infobox_inhalt AS infobox_inhalt, a.status,
					teaserbild_big, bildunterschrift,
					a.rang, template, a.id AS artikelID, a.kat_id, datum, t.file as layout, a.type as type, 
					a.module_param1, a.module_param2, a.module_param3, a.module_param4, a.enable_print,
					IF(a.bildunterschrift = '' OR a.bildunterschrift = ' ', '', CONCAT('<div class=\"bildunterschrift\">',a.bildunterschrift,'</div>\n')) as layerbildunterschrift,
					IF(a.bildquelle = '' OR a.bildquelle = ' ', '', CONCAT('<div class=\"bildquelle\">&copy;&nbsp;',a.bildquelle,'</div>\n')) as bildquelle
					FROM (".PREFIX."artikel a)
					LEFT JOIN ".PREFIX."templates t ON a.layout = t.id 
					WHERE a.kat_id = '".$_REQUEST["katID"]."' AND a.lang='".$lang."' AND a.status='visible'
					AND ((NOW()>= a.date_on AND NOW()<= a.date_off) OR a.date_on='0000-00-00')
					AND (a.area='' OR a.area=' ')
					ORDER BY rang");
	} else {
		//Nur öffentl.Artikel
		$artikel = DB::getInstance()->getSQL("SELECT a.id AS artikelID, headline AS headline, infobox_headline AS infobox_headline,
					infotext AS infotext, inhalt AS inhalt, infobox_inhalt AS infobox_inhalt, a.status,
					teaserbild_big,teaserbild_thumb, bildunterschrift,
					a.rang, template, a.id AS artikelID, a.kat_id, datum, t.file as layout, a.type as type, 
					a.module_param1, a.module_param2, a.module_param3, a.module_param4, a.enable_print,
					IF(a.bildunterschrift = '' OR a.bildunterschrift = ' ', '', CONCAT('<div class=\"bildunterschrift\">',a.bildunterschrift,'</div>\n')) as layerbildunterschrift,
					IF(a.bildquelle = '' OR a.bildquelle = ' ', '', CONCAT('<div class=\"bildquelle\">&copy;&nbsp;',a.bildquelle,'</div>\n')) as bildquelle
					FROM (".PREFIX."artikel a, ".PREFIX."menu m)
					LEFT JOIN ".PREFIX."templates t ON a.layout = t.id 
					WHERE a.status='visible' AND ((NOW()>= a.date_on AND NOW()<= a.date_off) OR a.date_on='0000-00-00')
					AND (a.area='' OR a.area=' ') AND m.customer_area=0 AND m.id='".$_REQUEST["katID"]."' AND a.lang='".$lang."' AND a.kat_id = '".$_REQUEST["katID"]."'
					ORDER BY rang");
	}

	$main_template = DB::getInstance()->getSQL("
		SELECT
			t.file as file,
			t.layoutID
		FROM (".PREFIX."templates t, ".PREFIX."menu m, ".PREFIX."layouts l)
		LEFT JOIN ".PREFIX."menu_entry me ON me.menu_id = m.id AND me.lang='".$lang."'
		WHERE
			m.id='".$_REQUEST["katID"]."'
		AND
			me.template = t.id
	");

	//Festegelegtes Template laden
  $templ_file = $main_template->getAt("file");
	#$templ_file = $main_template->getAt("file");

	//Prüfe auf Mobile Endgeäte
	#$mobile = mobile_device_detect();

	if(MOBILE) {
		if($main_template->size==0 OR $templ_file=="") {
      //Wenn leer, dann Basic-Template laden
			$templ_file="standard_page_mobile_tmpl.html";
		} else {
      // Mobilevariante des Pagetemplate laden
      $templ_ordner = DB::getInstance()->getSQL("SELECT * FROM avalon_layouts WHERE layoutID =".$main_template->getAt("layoutID")." AND enable=1");
      $templ_file = $templ_ordner->getAt("ordner")."/".substr($templ_file,0,-5)."_mobile.html";
      if(!is_file(TEMPL_PATH.$templ_file)) {
        // Wenn Datei nicht vorhanden, dann standard laden
        $templ_file="standard_page_mobile_tmpl.html";
      }
    }
	} else {
		if($main_template->size==0 OR $templ_file=="") {
      //Wenn leer, dann Basic-Template laden
			$templ_file="standard_page_tmpl.html";
		} else {
      $templ_ordner = DB::getInstance()->getSQL("SELECT * FROM avalon_layouts WHERE layoutID =".$main_template->getAt("layoutID")." AND enable=1");
			$templ_file = $templ_ordner->getAt("ordner")."/".$main_template->getAt("file");
      if(!is_file(TEMPL_PATH.$templ_file)) {
        // Wenn Datei nicht vorhanden, dann standard laden
        $templ_file="standard_page_tmpl.html";
      }
		}
	}
	#echo $templ_file;
	//Artikel ersetzen -------------------------------
	$template = new Page("[page_title]", $templ_file);
	$template->ArtikelReplace($artikel, "artikel", 1, $_REQUEST["katID"]);
}

//Hauptpunkt als Platzhalter ersetzen
$pfad = get_Pfad($_GET["katID"], $_GET["lang"]);
$pfad->it=1;

DB::getInstance()->sql("SET @tmpkatID='".$_REQUEST["katID"]."'");

$lang_list = DB::getInstance()->getSQL("
	SELECT
		@tmpkatID,
		code,
		sprache,
		id,
		IF(icon!='', icon, 'flag_blank.gif') as icon
	FROM ".PREFIX."languages l
	WHERE
		sprache_enable=1
	AND
		frontend_enable=1
");

$template->whileReplace($lang_list, "languages");

/* Onload für Body */
$body_onload = DB::getInstance()->getSQL("SELECT * FROM ".PREFIX."sysparam WHERE param='BODY_ONLOAD'");

$template->replace("[CHOOSELANG]", LANGCHOOSELANG);
$template->replace("[main_katID]", $pfad->getAt("id"));
$template->replace("[main_kat]", $pfad->getAt("$lang"));
$template->replace("[BODY_ONLOAD]", $body_onload->getAt("value"));
$template->replace("[load_option]", $onload);
$template->replace("[suchtext]", $suchtext);
$template->replace("[menu]", get_menu($_REQUEST["katID"], $lang, 0, $costumer_login, 0));
$template->replace("[SERVER_URL]", SERVER_URL);
$template->replace("[meta_url]", "http://".$_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]);
$template->replaceOgType($OgType);
$template->replacePageTitle($PageTitle);
$template->replacePageDescription($PageDescription);
$template->replaceLinkImage($LinkImage);
$template->show();
?>