$modul2show = $_REQUEST['modul'];
$query_subnav = "select name,id,navName,fremdurl,isSubNavHeadline,content,content_einleitung,isSubnavVon,nameReihenfolge,anwendung, SUBSTRING(nameReihenfolge,11,4) AS nameReihenfolge1, SUBSTRING(nameReihenfolge,21,4) AS nameReihenfolge4 from content where aktiv = '1' AND hauptmodul = '$modul_array3[$modul2show]' AND insubnav='1' AND SUBSTRING(nameReihenfolge,11,4) = '0000' AND lang = '$_REQUEST[lang]' order by nameReihenfolge4";
$result_subnav = @mysqli_query($con,$query_subnav);
$num_subnav = @mysqli_num_rows($result_subnav);
$i_subnav = 0;
while ( $i_subnav < $num_subnav)
{
$navName = @mysqli_result($result_subnav,$i_subnav,"navName");
$navName = changeAmpersand($navName);
$nameReihenfolge = @mysqli_result($result_subnav,$i_subnav,"nameReihenfolge");
$nameReihenfolge1 = @mysqli_result($result_subnav,$i_subnav,"nameReihenfolge1");
$nameReihenfolge2 = substr($nameReihenfolge,5,4);
$id = @mysqli_result($result_subnav,$i_subnav,"id");
$isSubNavHeadline = @mysqli_result($result_subnav,$i_subnav,"isSubNavHeadline");
$name = @mysqli_result($result_subnav,$i_subnav,"name");
$navNameID = @mysqli_result($result_subnav,$i_subnav,"id");
$fremdurl = @mysqli_result($result_subnav,$i_subnav,"fremdurl");
$content_sub = @mysqli_result($result_subnav,$i_subnav,"content");
$content_sub_einleitung = @mysqli_result($result_subnav,$i_subnav,"content_einleitung");
$anwendung = @mysqli_result($result_subnav,$i_subnav,"anwendung");
if($fremdurl>0) {
$query_topnav0 = "select hauptmodul,name from content where id='$fremdurl'";
$result_topnav_nav0 = @mysqli_query($con,$query_topnav0);
$num_topnav_nav0 = @mysqli_num_rows($result_topnav_nav0);
$name = @mysqli_result($result_topnav_nav0,0,"name");
$hauptmodul = @mysqli_result($result_topnav_nav0,0,"hauptmodul");
$modulfremd = @$modul_array4[$hauptmodul];
}
$query_subnav1 = "select name,id,navName,fremdurl,isSubNavHeadline,content,content_einleitung,isSubnavVon,nameReihenfolge,anwendung, SUBSTRING(nameReihenfolge,6,4) AS nameReihenfolge2, SUBSTRING(nameReihenfolge,21,4) AS nameReihenfolge3 from content where aktiv = '1' AND hauptmodul = '$modul_array3[$modul2show]' AND insubnav='1' AND SUBSTRING(nameReihenfolge,11,4) = '$nameReihenfolge2' AND lang = '$_REQUEST[lang]' order by nameReihenfolge3";
$result_subnav1 = @mysqli_query($con,$query_subnav1);
$num_subnav1 = @mysqli_num_rows($result_subnav1);
$name_sub1 = @mysqli_result($result_subnav1,0,"name");
// weiter auf Unterpunkt wenn Hauptpunkt leer
if($anwendung=="-") {$anwendung="";}
if($content_sub=="" && $content_sub_einleitung=="" && $anwendung=="") {$name = $name_sub1;}
if($isSubNavHeadline=="1") {$add_headline = "subnavheadline";} else {$add_headline = "";}
// Ende weiter
if($_REQUEST['site']==$name) {
$add_aktiv = "aktiv";
//$add_aktiv1 = "
>";
}
else {
$add_aktiv = "";
$add_aktiv1 = "";
}
if($fremdurl>0) {
echo '
';
echo "\r";
}
else {
echo '
';
echo "\r";
}
$i_subnav1 = 0;
while ( $i_subnav1 < $num_subnav1)
{
$navName_sub = @mysqli_result($result_subnav1,$i_subnav1,"navName");
$navName_sub = changeAmpersand($navName_sub);
$name_sub = @mysqli_result($result_subnav1,$i_subnav1,"name");
$nameReihenfolge_sub = @mysqli_result($result_subnav1,$i_subnav1,"nameReihenfolge");
$nameReihenfolge2_sub = @mysqli_result($result_subnav1,$i_subnav1,"nameReihenfolge2");
$id_sub = @mysqli_result($result_subnav1,$i_subnav1,"id");
$content_sub2 = @mysqli_result($result_subnav1,$i_subnav1,"content");
$content_sub2_einleitung = @mysqli_result($result_subnav1,$i_subnav1,"content_einleitung");
$anwendung2 = @mysqli_result($result_subnav1,$i_subnav1,"anwendung");
$query_subnav2 = "select name,id,navName,fremdurl,isSubNavHeadline,content,content_einleitung,isSubnavVon,nameReihenfolge,anwendung, SUBSTRING(nameReihenfolge,11,4) AS nameReihenfolge2, SUBSTRING(nameReihenfolge,21,4) AS nameReihenfolge5 from content where aktiv = '1' AND hauptmodul = '$modul_array3[$modul2show]' AND insubnav='1' AND SUBSTRING(nameReihenfolge,11,4) = '$nameReihenfolge2_sub' AND lang = '$_REQUEST[lang]' order by nameReihenfolge5";
$result_subnav2 = @mysqli_query($con,$query_subnav2);
$num_subnav2 = @mysqli_num_rows($result_subnav2);
$name_sub2 = @mysqli_result($result_subnav2,0,"name");
$isSubnavVon2 = @mysqli_result($result_subnav2,0,"isSubnavVon");
?>
// weiter auf Unterpunkt wenn Hauptpunkt leer
if($anwendung2=="-") {$anwendung2="";}
if($content_sub2=="" && $content_sub_einleitung2=="" OR $anwendung2="") {$name_sub = $name_sub2;}
if($_REQUEST['site']==$name_sub) {
$add_aktiv = "aktiv";
//$add_aktiv1 = "
>";
}
else {
$add_aktiv = "";
$add_aktiv1 = "";
}
//$subnavVon_array[$id_aktiv] --> in setup.php - vom aktiven Punkt wird die SubnavVonID abgefragt
if($subnavVon_array[$id_aktiv]==$isSubnavVon2) {$add_aktiv = "aktiv";}
echo '
'.$navName_sub.'';
echo "\r";
$add_headline = "";
$add_aktiv = "";
$add_aktiv1 = "";
$i_subnav2 = 0;
while ( $i_subnav2 < $num_subnav2)
{
$navName_sub2 = @mysqli_result($result_subnav2,$i_subnav2,"navName");
$navName_sub2 = changeAmpersand($navName_sub2);
$name_sub2 = @mysqli_result($result_subnav2,$i_subnav2,"name");
$nameReihenfolge_sub2 = @mysqli_result($result_subnav2,$i_subnav2,"nameReihenfolge");
$nameReihenfolge1_sub2 = @mysqli_result($result_subnav2,$i_subnav2,"nameReihenfolge1");
$id_sub2 = @mysqli_result($result_subnav2,$i_subnav2,"id");
if($_REQUEST['site']==$name_sub2) {
$add_aktiv = "aktiv";
//$add_aktiv1 = "
>";
}
else {
$add_aktiv = "";
$add_aktiv1 = "";
}
echo '
';
echo "\r";
$add_headline = "";
$add_aktiv = "";
$add_aktiv1 = "";
$i_subnav2++;
}
echo '
';
$i_subnav1++;
}
echo "
";
$i_subnav++;
}
?>