<?


	/*	miCMS 4 SEO-Modul


	Dieses Script analysiert die SEO-Links und ermittelt die aufgerufene Seite

    Die Variablen stehen dann wie gewohnt in $navid und $lang

        
	*/

    
    require("admin/config.php");


    function return_404() {

    
    	// Gibt HTTP-Code 404 aus und zeigt die Fehlerseite an

        
        //header("HTTP/1.0 404 Not Found");

        //exit; 

    
    }

	
	$seo_replacements=array(

						"ä"		=>	"ae",

						"ö"		=>	"oe",

						"ü"		=>	"ue",

						"ß"		=>	"ss",

						"Ä"		=>	"Ae",

						"Ö"		=>	"Oe",

						"Ü"		=>	"Ue",

						"\""	=>	"'"

						
	);

	
	function seo_replace($x, $lang) {

		global $seo_replacements;

		
		$seo_replacements2=$seo_replacements;

		
		$y=Array();

		
		array_push($y,$x);

		
		foreach ($seo_replacements As $x2=>$y2) {
			
			if(intval($lang) === 1) {
				$t=str_replace($y2,$x2,$x);
				$t=str_replace('-und-',' & ',$x);
			} else if(intval($lang) === 2) {
				$t=str_replace('-and-',' & ',$x);
			} else if(intval($lang) === 3) {
				$t=str_replace('-et-',' & ',$x);
			} else if(intval($lang) === 4) {
				$t=str_replace('-y-',' & ',$x);
			} else if(intval($lang) === 5) {
				$t=str_replace('-e-',' & ',$x);
			}

			$t=str_replace("_"," ",$x);
			$t=str_replace("'","\'",$x);


			if (!in_array($t,$y)) {

				array_push($y,$t);

			}

			
			foreach ($seo_replacements2 As $x3=>$y3) {
				if ($x2!=$x3) {	
					if(intval($lang) === 1) {
						$t=str_replace($y3,$x3,$t);
						$t=str_replace('-und-',' & ',$t);
					} else if(intval($lang) === 2) {
						$t=str_replace('-and-',' & ',$t);
					} else if(intval($lang) === 3) {
						$t=str_replace('-et-',' & ',$t);
					} else if(intval($lang) === 4) {
						$t=str_replace('-y-',' & ',$t);
					} else if(intval($lang) === 5) {
						$t=str_replace('-e-',' & ',$t);
					}

					$t=str_replace("_"," ",$t);
					$t=str_replace("'","\'",$t);
		

					if (!in_array($t,$y)) {

						array_push($y,$t);	

					}

				
				}

			
			}

		
		}


		return $y;


	}

	
    $cms_seo_url=urldecode($_SERVER['REQUEST_URI']);

    
    $cms_seo_directories=explode("/",$cms_seo_url);

    
    if (count($cms_seo_directories)<2) {

    
    	return_404();

        exit;

    
    }

    
	$cms_seo_lang=$cms_seo_directories[1];

	// $cms_seo_lang="de";

    
    // Sprache vorhanden?

    
    $e=mysql_query("SELECT id FROM cms_sprachen WHERE kuerzel=\"".mysql_real_escape_string($cms_seo_lang)."\" AND status=1");

   
    if (mysql_num_rows($e)==0) {
               
	    return_404();

        exit;

    }


    $s=mysql_fetch_array($e);

    $lang=$s["id"];

	$_GET["lg"]=$lang;

	
	// require("cms_lang".$lang.".php");

  
    // Die Verzeichnisebenen durchgehen und die Variable $navid entsprechend erweitern

    $navid="";

	$misgroup="";

	$lastshopid=0;

    $lastid=0;

	$lastid2=9999999;

	$misgroup="";

	$check_haendler=0;

	$mis_inshop=0;

	
	$seo_startcheck=1;

	
	if ($seo_startcheck==1) {


		for ($i=2;$i<count($cms_seo_directories);$i++) {

		
			$t=$cms_seo_directories[$i];

	
			$t=str_replace("-und-"," & ",$t);

		$t=str_replace("_"," ",$t);

			$t=urldecode($t);

	
			$t2=$t;

			if($cms_seo_lang === "de") {
				$t2=str_replace("ae","ä",$t2);

				$t2=str_replace("oe","ö",$t2);

				$t2=str_replace("ue","ü",$t2);

				$t2=str_replace("ss","ß",$t2);

				$t2=str_replace("Ae","Ä",$t2);

				$t2=str_replace("Ue","Ü",$t2);

				$t2=str_replace("Oe","Ö",$t2);
			}

	
			if (strpos($t,"galerie-")!==false) {

			
				// Bildergalerie

				
				$t=str_replace("galerie-","",$t);

				
				$sql="SELECT a.* FROM cms_eintraege a INNER JOIN cms_zuordnung b ON (a.id=b.eintrag_id) WHERE b.navigation_id=".$lastid." AND a.status=1 AND a.archiv=0 AND a.sprache=".$lang." AND (a.titel=\"".$t."\" OR a.titel=\"".$t2."\") ORDER BY b.rang LIMIT 0,1";

				$et=mysql_query($sql);

				if (mysql_num_rows($et)!=0) {

					$st=mysql_fetch_array($et);

					$bgalerie=$st["id"];

				
				}

		
			} else {

			
				if (substr($t,0,1)=="?") {

					
					// Variablenzuweisung

					
					$te=substr($t,1);

					$te=str_replace(" ","_",$te);

					$te=str_replace("&amp;","&",$te);

					$te2=explode("&",$te);

					foreach ($te2 As $x=>$y) {

						$te3=explode("=",$y);

						$_GET[$te3[0]]=$te3[1];

						$_REQUEST[$te3[0]]=$te3[1];

						$$te3[0]=$te3[1];

						
					}

					
				} elseif (substr($t,0,1)==";") {

				
					// Eintragauswahl

					
					$tempeintrag=explode("-",substr($t,1));

					$entry=(int) $tempeintrag[0];

					
					if ($lastshopid!=0) {


						// Artikel, da wir uns im Shop befinden

						
						$misart=$entry;

						$entry=0;

						
						$mis_shop_ersatzteile=0;

						$mis_shop_smallview=0;

						
						if (strpos($t,"-ersatzteile-")!==false) {

							$mis_shop_ersatzteile=1;

							$etemp=explode("-",$t);

							$mis_shop_ersatzteil_id=(int) $etemp[count($etemp)-1];

													
						} elseif (strpos($t,"-smallview-")!==false) {

							$mis_shop_smallview=1;

						}


					} else {

					
						if ($entry==0) {

							$tet=substr($t,1);

							$tet=seo_replace($tet,$lang);

							$sqladd="";

							foreach ($tet As $xt=>$yt) {

								if ($sqladd!="") {

									$sqladd.=" OR ";

								}

								$sqladd.="titel=\"".mysql_real_escape_string($yt)."\"";

							}

		
							$sql="SELECT id FROM cms_eintraege WHERE (".$sqladd.") AND sprache=".$lang." AND status=1 AND archiv=0";

							$e=mysql_query($sql);

		
							if (mysql_num_rows($e)!=0) {

								$s=mysql_fetch_array($e);

								$entry=$s["id"];

							}

							
						}

					}

				
				} elseif ($t=="shop") {

					
					$mis_inshop=1;

					
				} else {

			
					// Navigationspunkt

			   
					if ($t!="") {

					
						$t=seo_replace($t, $lang);

						
						if ($check_haendler==1) {

							
						} else {

						
							$sqladd="";

							foreach ($t As $xt=>$yt) {

								if ($sqladd!="") {

									$sqladd.=" OR ";

								}

								if ($yt=="Karrosserie aussen") {

									$sqladd.="name=\"".mysql_real_escape_string($yt)."\" OR name=\"Karrosserie außen\"";

								} else {

									$sqladd.="name=\"".mysql_real_escape_string($yt)."\"";

								}


							}

							// echo("<script>console.log('".$sqladd."');</script>");

					
							$sql="SELECT * FROM cms_navigation WHERE (".$sqladd.")  AND (topid=".(int) $lastid." OR topid=".(int) $lastid2.") AND sprache=".$lang." AND status=1";

							$e=mysql_query($sql);

					
							if (mysql_num_rows($e)==0) {

	
								if ($mis_inshop==1) {

									
									// Shop

									// Warengruppe??

									$sql="SELECT * FROM shop_warengruppen WHERE (".$sqladd.")  AND topid=".$lastshopid." AND sprache=".$lang." AND status=1";


									$e=mysql_query($sql);

									if (mysql_num_rows($e)==0) {

									
										return_404();

										
									}

									
									$s=mysql_fetch_array($e);

							
									$lastshopid=$s["id"];

								  
									if ($misgroup!="") {

										$misgroup.=",";

									}

								  
									$misgroup.=$s["id"];


								} else {

									
									return_404();

									exit;

									
								}

								
							} else {

							
								$s=mysql_fetch_array($e);

								
								$lastid=$s["id"];

							  	if ($lastid==6) {

									$mis_inshop=1;

									$lastshopid=1;	

								}

								if ($navid!="") {

									$navid.=",";

								} else {

									$firstid=$s["id"];	

								}

							  
								$navid.=$s["id"];

								
							}

							
						}

				   }

				   
			  }

			   
		  }

		
		}

		
	}


    include("index.php");

    
?>