';
echo '
';
echo '';
echo '';
echo '';
echo '';
echo '';
$cachekey=md5('lnaviƒ'.$_sprache->langid.'ƒ'.$_rubrik->wert.'ƒ'.$_land->wert.'ƒ'.$_bundesland->wert.'ƒ'.$_ort->wert.'ƒ'.$_ortsteil->wert.'ƒ'.$_data->autobahn.'ƒ'.$_data->autobahnabfahrt);
if ($isdebug) {
$result=null;
} else {
$result=$_memcache->get($cachekey);
}
if ($result==null) {
$prevblocknr=-129;
$rubrikenQ=mysqli_query($thisDB, "SELECT *, (SELECT wert FROM sel_rubriken_sprachen WHERE sel_rubriken_sprachen.rubrikid=sel_rubriken.wert AND langid='$_sprache->langid' LIMIT 1) as titel FROM sel_rubriken WHERE noshow=0 ORDER BY blocknr asc, reihenfolge asc, titel asc");
while ($rubrik=mysqli_fetch_object($rubrikenQ)) {
if (($prevblocknr>-129)&&($prevblocknr<$rubrik->blocknr)) {
$result.= '';
}
if (strlen($rubrik->titel)>0) {
$rubriktitel=$rubrik->titel;
} else {
$rub=mysqli_fetch_object(mysqli_query($thisDB, "SELECT * FROM sel_rubriken_sprachen WHERE rubrikid='$rubrik->wert' ORDER BY (SELECT reihenfolge FROM sel_rubriken WHERE sel_rubriken.wert=sel_rubriken_sprachen.rubrikid LIMIT 1) asc LIMIT 1"));
$rubriktitel=$rub->wert;
}
if(!isset($$engelqueryadd)) $engelqueryadd="";
if ((strlen($_land->wert)==6)&&($rubrik->regionlock>=1)) {
$engelqueryadd.=" AND besuchsland='$_land->wert'";
if ((strlen($_bundesland->wert)==6)&&($rubrik->regionlock>=2)) {
$engelqueryadd.=" AND besuchsbundesland='$_bundesland->wert'";
if ((strlen($_ort->wert)==6)&&($rubrik->regionlock>=3)) {
$engelqueryadd.=" AND besuchsort='$_ort->wert'";
if ((strlen($_ortsteil->wert)==6)&&($rubrik->regionlock>=4)) {
$engelqueryadd.=" AND besuchsortsteil='$_ortsteil->wert'";
}
}
}
}
if ($rubrik->wert=='9sfbxq') {
$modelleC=mysqli_num_rows(mysqli_query($thisDB, "SELECT engelid, (SELECT autobahnabfahrt FROM haeuser WHERE haeuser.wert=engel.besuchshausnummer LIMIT 1) as autobahnabfahrt FROM engel WHERE status>0 AND anzeige>0 HAVING autobahnabfahrt IS NOT NULL AND autobahnabfahrt!=''"));
} else {
$modelleC=mysqli_num_rows(mysqli_query($thisDB, "SELECT engelid FROM engel WHERE engelid IN (SELECT engelid FROM engel_rubriken WHERE wert='$rubrik->wert') AND status>0 AND anzeige>0 $engelqueryadd"));
}
$result.= '';
if (($_data->page=='suche' || $_data->page=='setcard' || $_data->page=='setcard2')&&($_rubrik->wert==$rubrik->wert)&&($rubrik->wert=='9sfbxq')) {
$autobahnenQ=mysqli_query($thisDB, "SELECT * FROM autobahnen WHERE cat='2' AND status>0 ORDER BY titel asc, id asc");
while ($autobahn=mysqli_fetch_object($autobahnenQ)) {
$modelleC=mysqli_num_rows(mysqli_query($thisDB, "SELECT engelid, (SELECT autobahnabfahrt FROM haeuser WHERE haeuser.wert=engel.besuchshausnummer LIMIT 1) as autobahnabfahrt FROM engel WHERE status>0 AND anzeige>0 HAVING autobahnabfahrt IN (SELECT id FROM autobahnabfahrten WHERE parentid='$autobahn->id')"));
if ($modelleC>0) {
$result.='';
if (($_data->page=='suche' || $_data->page=='setcard' || $_data->page=='setcard2')&&($_rubrik->wert==$rubrik->wert)&&($_data->autobahn==$autobahn->id)) {
$autobahnabfahrtenQ=mysqli_query($thisDB, "SELECT * FROM autobahnabfahrten WHERE parentid='$autobahn->id' AND status>0 ORDER BY nummer asc, id asc");
while ($autobahnabfahrt=mysqli_fetch_object($autobahnabfahrtenQ)) {
$modelleC=mysqli_num_rows(mysqli_query($thisDB, "SELECT engelid, (SELECT autobahnabfahrt FROM haeuser WHERE haeuser.wert=engel.besuchshausnummer LIMIT 1) as autobahnabfahrt FROM engel WHERE status>0 AND anzeige>0 HAVING autobahnabfahrt='$autobahnabfahrt->id'"));
if ($modelleC>0) {
$result.='';
}
}
}
}
}
}
$prevblocknr=$rubrik->blocknr;
}
$_memcache->set($cachekey, $result, 0, 600);
echo $result;
} else {
echo $result;
}
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
// echo '';
// echo '';
echo '';
echo '';
echo '';
echo '';
// echo '';
// echo '';
// echo '';
// echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
// echo '';
// echo '';
echo '';
// echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
if ((strlen($_bundesland->wert)==6)&&(strlen($_rubrik->wert)==6)) {
$leftbannerQ=mysqli_query($thisDB, "SELECT * FROM banner_left WHERE land='$_land->wert' AND bannerid IN (SELECT bannerid FROM banner_left_bundeslaender WHERE (bundesland='$_bundesland->wert' OR bundesland='clear')) AND bannerid IN (SELECT bannerid FROM banner_left_rubriken WHERE (rubrikid='$_rubrik->wert' OR rubrikid='clear')) AND status>0 ORDER by reihenfolge asc, id asc");
} elseif (strlen($_bundesland->wert)==6) {
$leftbannerQ=mysqli_query($thisDB, "SELECT * FROM banner_left WHERE land='$_land->wert' AND bannerid IN (SELECT bannerid FROM banner_left_bundeslaender WHERE (bundesland='$_bundesland->wert' OR bundesland='clear')) AND status>0 ORDER by reihenfolge asc, id asc");
} elseif (strlen($_rubrik->wert)==6) {
$leftbannerQ=mysqli_query($thisDB, "SELECT * FROM banner_left WHERE land='$_land->wert' AND bannerid IN (SELECT bannerid FROM banner_left_rubriken WHERE (rubrikid='$_rubrik->wert' OR rubrikid='clear')) AND status>0 ORDER by reihenfolge asc, id asc");
} else {
$leftbannerQ=mysqli_query($thisDB, "SELECT * FROM banner_left WHERE land='$_land->wert' AND bannerid IN (SELECT bannerid FROM banner_left_bundeslaender WHERE bundesland='clear') AND status>0 ORDER by reihenfolge asc, id asc");
}
if (mysqli_num_rows($leftbannerQ)) {
echo '';
while ($leftbanner=mysqli_fetch_object($leftbannerQ)) {
echo '
';
}
}
echo '
';
if ($page=='seitenspruenge') {
echo '
';
include ('pages/'.$page.'.page.php');
echo '
';
} elseif ($page=='webcam') {
echo '
';
include ('pages/'.$page.'.page.php');
echo '
';
} else {
echo '
';
if ($isdebug) {
echo "\n";
include ('pages/'.$page.'.page.php');
echo "\n";
} else {
if(!@include ('pages/'.$page.'.page.php')) {echo 'Diese Seite existiert leider noch nicht.';}
}
echo '
';
echo '
';
$sprachenQ=mysqli_query($thisDB, "SELECT * FROM www_sprachen WHERE status=1 ORDER BY reihenfolge asc");
if (mysqli_num_rows($sprachenQ)>1) {
echo '';
echo '
';
while ($sprache=mysqli_fetch_object($sprachenQ)) {
echo '
';
}
echo '
';
}
echo '';
echo '
';
echo '
&&(strlen($_bundesland->wert)==6)) {
echo $_land->wert.'/'.$_bundesland->wert;
} elseif ($_land->wert=='sgd7cg') {
echo 'sgd7cg_sgd7cg';
} elseif (($_land->wert=='oo0twc')&&(strlen($_bundesland->wert)==6)) {
echo $_land->wert.'/'.$_bundesland->wert;
} elseif ($_land->wert=='oo0twc') {
echo 'oo0twc_oo0twc';
} elseif ($_land->wert=='sdlo1d') {
echo 'oo0twc_sdlo1d';
} elseif ($_land->wert=='wahh5i') {
echo 'oo0twc_wahh5i';
} else {
echo 'sgd7cg_'.$_land->wert;
}
echo '.jpg)
';
echo '
';
echo '
';
if (strlen($_css->partner)>0) {
echo '';
echo '
';
echo '

';
echo '
';
}
if ((strlen($_bundesland->wert)==6)&&(strlen($_rubrik->wert)==6)) {
$sidebannerQ=mysqli_query($thisDB, "SELECT * FROM banner_right WHERE land='$_land->wert' AND bannerid IN (SELECT bannerid FROM banner_right_bundeslaender WHERE (bundesland='$_bundesland->wert' OR bundesland='clear')) AND bannerid IN (SELECT bannerid FROM banner_right_rubriken WHERE (rubrikid='$_rubrik->wert' OR rubrikid='clear')) AND status>0 ORDER by reihenfolge asc, id asc");
} elseif (strlen($_bundesland->wert)==6) {
$sidebannerQ=mysqli_query($thisDB, "SELECT * FROM banner_right WHERE land='$_land->wert' AND bannerid IN (SELECT bannerid FROM banner_right_bundeslaender WHERE (bundesland='$_bundesland->wert' OR bundesland='clear')) AND status>0 ORDER by reihenfolge asc, id asc");
} elseif (strlen($_rubrik->wert)==6) {
$sidebannerQ=mysqli_query($thisDB, "SELECT * FROM banner_right WHERE land='$_land->wert' AND bannerid IN (SELECT bannerid FROM banner_right_rubriken WHERE (rubrikid='$_rubrik->wert' OR rubrikid='clear')) AND status>0 ORDER by reihenfolge asc, id asc");
} else {
$sidebannerQ=mysqli_query($thisDB, "SELECT * FROM banner_right WHERE land='$_land->wert' AND bannerid IN (SELECT bannerid FROM banner_right_bundeslaender WHERE bundesland='clear') AND status>0 ORDER by reihenfolge asc, id asc");
}
if (mysqli_num_rows($sidebannerQ)) {
echo '';
while ($sidebanner=mysqli_fetch_object($sidebannerQ)) {
echo '
';
}
}
echo '
';
echo '
';
}
echo '