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 "
".$log->getAt("date");
if($datum_heute != $log->getAt("date")) {
#echo "
".$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('
',a.bildunterschrift,'
\n')) as layerbildunterschrift,
IF(a.bildquelle = '' OR a.bildquelle = ' ', '', CONCAT('© ',a.bildquelle,'
\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('',a.bildunterschrift,'
\n')) as layerbildunterschrift,
IF(a.bildquelle = '' OR a.bildquelle = ' ', '', CONCAT('© ',a.bildquelle,'
\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();
?>