$Mdl= basename($_SERVER['PHP_SELF']); // current file name for error logging
require_once('IOCheck.php');
$db= GetDb();
//get mnuID
$result = mysql_query("SELECT mnuID FROM menu WHERE mnuAlias = \"".EncodeQ(gcMENU)."\"",$db) or die ("Abfrage i10 fehlgeschlagen: ".mysql_error());
$result = DecodeQ(mysql_fetch_array($result));
$mnuID= ChkInt( $result['mnuID'] ,1);
if ($mnuID==0) { $mnuID= 1;}
//main menu
$result = mysql_query("SELECT mnuID, mnuAlias, mnuCaption, mnuHelp, mnuPath FROM menu WHERE mnuParent = 1 Order By mnuOrder",$db) or die ("Abfrage i20 fehlgeschlagen: ".mysql_error());
while ($nav= DecodeQ(mysql_fetch_array($result))){ // . q navigation items
$mnuHtml=$mnuHtml."".htmlentities($nav['mnuCaption'])." \n";
}
//main
$result = mysql_query("SELECT mnuPageTitle, mnuTitle, mnuPageDiscription, mnuPageKeys, mnuPageIntro, mnuText, mnuTextExe, mnuParent, mnuLogo, mnuHelp FROM menu WHERE mnuID=".$mnuID,$db) or die ("Abfrage i50 fehlgeschlagen: ".mysql_error());
$result = DecodeQ(mysql_fetch_array($result));
$mnuPageTitle = htmlentities($result['mnuPageTitle']);
$mnuPageDiscription = htmlentities($result['mnuPageDiscription']);
$mnuPageKeys = htmlentities($result['mnuPageKeys']);
$mnuTitle = htmlentities($result['mnuTitle']);
$mnuText = $result['mnuText'];
$mnuTextExe = ChkInt($result['mnuTextExe'], 0);
$mnuParent= ChkInt($result['mnuParent'], 0);
$mnuLogo= $result['mnuLogo'];
$mnuHelp= $result['mnuHelp'];
$mnuPageIntro= str_replace("\r\n", "", nl2br(htmlentities($result['mnuPageIntro'])));
if ($mnuLogo) { $mnuLogo= "";};
//chapters
if (gcMENU<>'Home' ) { // show navigation?
$chpHtml="";
if (gcMENU<>'' ){ $chpHtml= $chpHtml." Auswahl:
\n"; }; // show select caption?
if (!(gcMENU=='Datenschutz' || gcMENU=='Nutzung' || gcMENU=='Impressum' ||
gcMENU=='401' || gcMENU=='403'|| gcMENU=='404'|| gcMENU=='500') ){ // show up button?
$result = mysql_query("SELECT m1.mnuAlias, m1.mnuCaption, m1.mnuHelp, m1.mnuPath FROM menu AS m1 LEFT JOIN menu As m2 ON (m1.mnuID=m2.mnuParent) WHERE m2.mnuID = ".$mnuID,$db) or die ("Abfrage i40 fehlgeschlagen: ".mysql_error());
$up= mysql_fetch_array($result);
$chpHtml=$chpHtml."
".htmlentities($up['mnuCaption'])."\n";
}
if (gcMENU<>'' ){ // show menu?
$result = mysql_query("SELECT mnuID, mnuAlias, mnuCaption, mnuHelp, mnuPath FROM menu WHERE mnuParent = ".$mnuID." Order By mnuOrder",$db) or die ("Abfrage i30 fehlgeschlagen: ".mysql_error());
if (mysql_num_rows($result)==0 && $mnuParent>1) { //if no child available and higher than 1st level, list same nodelevel
$result = mysql_query("SELECT mnuID, mnuAlias, mnuCaption, mnuHelp, mnuPath FROM menu WHERE mnuParent = ".$mnuParent." Order By mnuOrder",$db) or die ("Abfrage i35 fehlgeschlagen: ".mysql_error());
}
while ($nav= DecodeQ(mysql_fetch_array($result))){ // 3. q navigation items
if (!$nav['lnkMenu']) {$nav['lnkMenu']=gcMENU;};
$chpHtml=$chpHtml."".htmlentities($nav['mnuCaption'])."\n";
}
}
if (gcMENU<>''){ $chpHtml=$chpHtml."
zurück\n";} // show back button?
}
//counter
LogIt($db,'-20');
?>
