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"); ?> >"; } 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 ''; $i_subnav1++; } echo "
"; $i_subnav++; } ?>