<?

 
//echo $_SERVER["DOCUMENT_ROOT"];die();
//$vali="info@werbung-text-design.de";
define("aPRUEF", 1);

include "include/func.php";
include_once "back/zconfig/config.php";


//require "install.php"; //setzt Verzeichnisrechte, danach install.php löschen und diese zeile entfernen

require "back/include/class.phperror.php";
PHPError::init();

// Mediaparser falls benötigt (advanes TinyMCE Plugin )
include_once "back/include/class.mediaparser.php";

// Bild Frequenz aus Datenbank
$query="SELECT bildFrequenz,alphadauer FROM ".$db_prefix."einstellungen WHERE admin_id  ='1';";
$result=mysql_query($query,$link);
$dat=mysql_fetch_array($result);
$bildFrequenz=$dat["bildFrequenz"];
$alphadauer=$dat["alphadauer"];
if($bildFrequenz<0){$bildFrequenz=0;}
if($alphadauer<0){$alphadauer=0;}
else
{
	$alphadauer=$alphadauer/1000;
	$alphadauer=number_format( $alphadauer, 2, ".", "");
}

$lan="de";
//$alphadauer=3.0;
//$bildFrequenz=2000;

$act=$_REQUEST["act"];
$act_ursprung=$act;
$arr_act=explode("_",$act);
$act=$arr_act[0];
$act2=$arr_act[1];
$act3=$arr_act[2];
$act4=$arr_act[3];
$act5=$arr_act[4];
$act6=$arr_act[5];

/*
Überblick:
	
	act 1 - steuer
	act 2 - kategorie 1
	act 3 - kategorie 2
	act 4 - kategorie 3
	act 5 - kategorie 4
	act 6 - textfenster

*/

/*
 $brows_var=$_SERVER["HTTP_USER_AGENT"];
 $brw="";
 if (preg_match("/MSIE/", $brows_var)) {
 	 if (preg_match("/6.0/", $brows_var))  $brw="IE6";
 	 if (preg_match("/7.0/", $brows_var))  $brw="";
 }else  $brw="";
*/

if ($_REQUEST["act2"]!="") $act2=$_REQUEST["act2"];
if ($_REQUEST["act3"]!="") $act3=$_REQUEST["act3"];
if ($_REQUEST["act4"]!="") $act3=$_REQUEST["act4"];
if ($_REQUEST["act5"]!="") $act3=$_REQUEST["act5"];
if ($_REQUEST["act6"]!="") $act3=$_REQUEST["act6"];

$sav_act=$act;
$sav_act2=$act2;
$sav_act3=$act3;
$sav_act4=$act4;
$sav_act5=$act5;
$sav_act6=$act6;


session_start();

// Sprachen

// 1 = Deutsch
// 2 = Englisch
// ... = weitere sprachen

$host=$_SERVER['HTTP_HOST'];

$tmp_host = array();
foreach($url_pfad_front_ary as $key => $value)
{
	$value=str_replace("http://", "", $value);
	
	if(substr($value, strlen($value)-1, 1) == "/")
	{
		$value = substr($value, 0, strlen($value)-1);
	}
	
	$tmp_host[$key]=$value;
}


$test = array_search($host, $tmp_host);
if($test!==false)
{
	$selected_language=$test;
	$_SESSION["selected_language"]=$test;
	$url_pfad_front=$url_pfad_front_ary[$test];
	$url_pfad_admin=$url_pfad_admin_ary[$test];
	
	switch($selected_language)
	{
		case 1:
			$_SESSION["language_code"]="de";
			break;
		case 2:
			$_SESSION["language_code"]="en";
			break;
		case 3:
			$_SESSION["language_code"]="fr";
			break;
		case 4:
			$_SESSION["language_code"]="it";
			break;
	}
}
else
{
	$selected_language=2;
	$_SESSION["selected_language"]=2;
	$_SESSION["language_code"]="en";
	$url_pfad_front=$url_pfad_front_ary[2];
	$url_pfad_admin=$url_pfad_admin_ary[2];
}

/*
if(isset($_GET["lg"]))
{
	switch($_GET["lg"])
	{
		case "de":
				$_SESSION["selected_language"]=1;
				$_SESSION["language_code"]="de";
				break;
		case "en":
				$_SESSION["selected_language"]=2;
				$_SESSION["language_code"]="en";
				break;
		case "fr":
				$_SESSION["selected_language"]=3;
				$_SESSION["language_code"]="fr";
				break;
		case "it":
				$_SESSION["selected_language"]=4;
				$_SESSION["language_code"]="it";
				break;
	}
}*/

if($_SESSION["selected_language"]<1)
{
	$selected_language=1;
	$language_code="de";
}
else
{
	$selected_language=$_SESSION["selected_language"];
	$language_code=$_SESSION["language_code"];
}

// Statische Texte für verschiedene Sprachen
require "include/staticlg/class.lg.php";
LG::start($language_code);


$query="SELECT kat_id FROM ".$db_prefix."kategorien WHERE startseite=1 AND lang_id='".$selected_language."' limit 0, 1;";
$result=mysql_query($query,$link);
$dat=mysql_fetch_array($result);

$startseite_katid=$dat["kat_id"];

if ($selected_language!=2 && $act=="Transnational-Projects-Video") {
	$act="Transnational-Projects-Video-".$language_code	;
}

// Startseitenfunktion
if ($act=="index" || $act=="")
{
	$query="SELECT * FROM ".$db_prefix."url WHERE kat_id='".$startseite_katid."' limit 0, 1";
	$result=mysql_query($query,$link);
	if(mysql_num_rows($result)>0)
	{
		$datB=mysql_fetch_array($result);
		
		$act=$datB["act1"];
		$act2=$datB["act2"];
		$act3=$datB["act3"];
		$act4=$datB["act4"];
		$act5=$datB["act5"];
	}
}


//eigene urls für kategorien und textfenster

// URL hat nur ein Act
if(count($arr_act)==1){
	
	if($act=="Bilder-Galerie")
	{
		$txtart=2;
		$act="?";
		$act2="?";
		$act3="?";
		$act4="?";
		$act5="?";
		
		if(isset($_SESSION["prev_act"]))
		{
			if($act=="?") $act=$_SESSION["prev_act"];
			if($act2=="?") $act2=$_SESSION["prev_act2"];
			if($act3=="?") $act3=$_SESSION["prev_act3"];
			if($act4=="?") $act4=$_SESSION["prev_act4"];
			if($act5=="?") $act5=$_SESSION["prev_act5"];
		}
		
	}
	else{
		
		$act=trim(htmlspecialchars($act));
		$act=stripslashes($act);
		$act=mysql_real_escape_string($act, $link);
		
		$query="SELECT * FROM ".$db_prefix."url WHERE url='".$act."' LIMIT 0, 1";
		$result=mysql_query($query,$link);
		if(mysql_num_rows($result)>0)
		{
			$datURL=mysql_fetch_array($result);
			$act=$datURL["act1"];
			$act2=$datURL["act2"];
			$act3=$datURL["act3"];
			$act4=$datURL["act4"];
			$act5=$datURL["act5"];
		
			if($datURL["txtf_id"]>0)
			{
				$txtart=1;
				$act6=$datURL["txtf_id"];
				
				if(isset($_SESSION["prev_act"]))
				{
					if($act=="?") $act=$_SESSION["prev_act"];
					if($act2=="?") $act2=$_SESSION["prev_act2"];
					if($act3=="?") $act3=$_SESSION["prev_act3"];
					if($act4=="?") $act4=$_SESSION["prev_act4"];
					if($act5=="?") $act5=$_SESSION["prev_act5"];
				}
			}
			
			if($datURL["news_id"]>0)
			{
				$act6=$act2;
				
				$isnews=1;
				
				$txtart=0;
				$act="cms";
				
				switch($selected_language)
				{
					case 1: $act2=14;break;
					case 2: $act2=66;break;
					case 3: $act2=120;break;
					case 4: $act2=92;break;
				}
				
				$act3="";
				$act4="";
				$act5="";
			}
			
			if($datURL["seminar_id"]>0)
			{
				$act6=$act2;
				
				$isseminar=1;
				
				$txtart=0;
				$act="cms";
				
				switch($selected_language)
				{
					case 1: $act2=162;break;
					case 2: $act2=161;break;
					case 3: $act2=163;break;
					case 4: $act2=164;break;
				}
				
				$act3="";
				$act4="";
				$act5="";
			}
			
			
			// Prüft ob die url für die Sprache ist
			$ary_404=array(1 => 170, 2 => 169, 3 => 171, 4 => 172);
			
			if($isnews==0 && $isseminar==0 && $txtart<1)
			{
				// URL war für Kategorie
				
				$query="SELECT * FROM ".$db_prefix."kategorien WHERE kat_id='".$datURL["kat_id"]."' AND lang_id='".$selected_language."' LIMIT 0, 1";
				$result=mysql_query($query,$link);
				if(mysql_num_rows($result)==0)
				{
					header('HTTP/1.1 404 Not Found');
					$act="cms";
					$act2=$ary_404[$selected_language];
					$act3="";
					$act4="";
					$act5="";
					$act6="";
				}
				
			}
			else
			{
				// URL war für ein Textfenster / Seminar / News
				
				if($isnews==1)
				{
					
					$query="SELECT * FROM ".$db_prefix."news WHERE kat_id='".$datURL["news_id"]."' AND lang_id='".$selected_language."' LIMIT 0, 1";
					$result=mysql_query($query,$link);
					if(mysql_num_rows($result)==0)
					{
						header('HTTP/1.1 404 Not Found');
						$act="cms";
						$act2=$ary_404[$selected_language];
						$act3="";
						$act4="";
						$act5="";
						$act6="";
						$isnews=0;
						$isseminar=0;
						$txtart=0;
					}
					
				}
				elseif($isseminar==1)
				{
					
					$query="SELECT * FROM ".$db_prefix."seminare WHERE kat_id='".$datURL["seminar_id"]."' AND lang_id='".$selected_language."' LIMIT 0, 1";
					$result=mysql_query($query,$link);
					if(mysql_num_rows($result)==0)
					{
						header('HTTP/1.1 404 Not Found');
						$act="cms";
						$act2=$ary_404[$selected_language];
						$act3="";
						$act4="";
						$act5="";
						$act6="";
						$isnews=0;
						$isseminar=0;
						$txtart=0;
					}
					
				}
				else
				{
					
					$query="SELECT * FROM ".$db_prefix."textfenster WHERE kat_id='".$datURL["txtf_id"]."' AND lang_id='".$selected_language."' LIMIT 0, 1";
					$result=mysql_query($query,$link);
					if(mysql_num_rows($result)==0)
					{
						header('HTTP/1.1 404 Not Found');
						$act="cms";
						$act2=$ary_404[$selected_language];
						$act3="";
						$act4="";
						$act5="";
						$act6="";
						$isnews=0;
						$isseminar=0;
						$txtart=0;
					}
					
				}
					
					
			}
			
		}
		
	}
	
}


//eigene urls ende


$_SESSION["prev_act"]=$act;
$_SESSION["prev_act2"]=$act2;
$_SESSION["prev_act3"]=$act3;
$_SESSION["prev_act4"]=$act4;
$_SESSION["prev_act5"]=$act5;

if($_SESSION["prev_act"]!="" && $_SESSION["prev_act2"]=="" && $_SESSION["prev_act3"]=="" && $_SESSION["prev_act4"]=="" && $_SESSION["prev_act5"]=="") {$prev_katid=$act;}
if($_SESSION["prev_act"]!="" && $_SESSION["prev_act2"]!="" && $_SESSION["prev_act3"]=="" && $_SESSION["prev_act4"]=="" && $_SESSION["prev_act5"]=="") {$prev_katid=$act2;}
if($_SESSION["prev_act"]!="" && $_SESSION["prev_act2"]!="" && $_SESSION["prev_act3"]!="" && $_SESSION["prev_act4"]=="" && $_SESSION["prev_act5"]=="") {$prev_katid=$act3;}
if($_SESSION["prev_act"]!="" && $_SESSION["prev_act2"]!="" && $_SESSION["prev_act3"]!="" && $_SESSION["prev_act4"]!="" && $_SESSION["prev_act5"]=="") {$prev_katid=$act4;}
if($_SESSION["prev_act"]!="" && $_SESSION["prev_act2"]!="" && $_SESSION["prev_act3"]!="" && $_SESSION["prev_act4"]!="" && $_SESSION["prev_act5"]!="") {$prev_katid=$act5;}


if($_GET["test"]==1){$_SESSION["stephen"]=1;}
if($_GET["test"]==2){$_SESSION["stephen"]=0;}


/* Position geändert vorher in header.php*/
if($act5==""){$kat_id=$act4;}else{$kat_id=$act5;}
if($act4==""){$kat_id=$act3;}
if($act3==""){$kat_id=$act2;}
if($act2==""){$kat_id=$act;}
$kat_id=intval($kat_id);


if(in_array($kat_id,array(165,166,167,168)))
{
	require $lan."/templates/seminarsuche_1.php";
}

if(in_array($kat_id,array(14,66,120,92)))
{
	require $lan."/templates/news_1.php";
}

if(in_array($kat_id,array(261,262,263,264)))
{
	require $lan."/templates/newsletter_1.php";
}

if($isseminar==1)
{
	require $lan."/templates/seminar_1.php";
}

$print=intval($_REQUEST["print"]);
if($print==1)
{
	$act="print";
}


switch($act) {
case "ajaxInput":
			require "data/ajaxInput.php";
			break;			
/*
case "impressum":
			require "data/header.php";
			require $lan."/impressum.php";
			break;*/
		
case "cms": 
			require "data/header.php";
			require "data/nav.php";
			require $lan."/cms.php";
			require "data/footer.php";
			break;
			
case "print": 
			require "data/header.php";
			require $lan."/print.php";
			break;
/*
case "News": 

			switch($selected_language)
			{
				case 1: $act2=14;break;
				case 2: $act2=66;break;
				case 3: $act2=120;break;
				case 4: $act2=92;break;
			}
			require "data/header.php";
			require "data/nav.php";
			require $lan."/news.php";
			require "data/footer.php";
			break;

case "newsAnzeigen":

			switch($selected_language)
			{
				case 1: $act2=14;break;
				case 2: $act2=66;break;
				case 3: $act2=120;break;
				case 4: $act2=92;break;
			}
			$isnews=1;
			require "data/header.php";
			require "data/nav.php";
			require $lan."/newsAnzeigen.php";
			require "data/footer.php";
			break;

*/


/**********************/																															
																																								
DEFAULT:

			header('HTTP/1.1 404 Not Found');
			switch ($selected_language) {
				case "1":header('location:'.urllink(170));break;
				case "2":header('location:'.urllink(169));break;
				case "3":header('location:'.urllink(171));break;
				case "4":header('location:'.urllink(172));break;
			}
			die;/*
			require "data/header.php";
		//	require "data/nav.php";
			require $lan."/startseite.php";
		//	require "data/footer.php";
			break;*/		
}


$_SESSION["s_act_ursprung"]=$act_ursprung;
mysql_close($link);
?>