 |
|
$Qnavi=mysql_query("SELECT id,parent,name FROM $DB_navie WHERE parent='1' && naviwahl!='2' && geloescht='0' && id!='1155192324' ORDER BY position");
$nonscript= "
";
$za=0;
$i=0;
while($zeile=mysql_fetch_array($Qnavi)){
$resultPage=mysql_query("SELECT startCheck,start,ablaufCheck,ablauf,activ FROM $DB_pages WHERE id='".$zeile['id']."'");
$startCheck=mysql_result($resultPage,0,"startCheck");
$ablaufCheck=mysql_result($resultPage,0,"ablaufCheck");
$activ=mysql_result($resultPage,0,"activ");
if($ablaufCheck==1 || $startCheck==1){
if($startCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"start"))) < intval(date("Ymd"))){
$check=1;
//print " start 1";
}else if($startCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"start"))) > intval(date("Ymd"))){
$show=0;
//print " start 2";
}else{
$check=1;
//print " start 3";
}
if($check==1){
$ablauf=mysql_result($resultPage,0,"ablauf");
if($ablaufCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"ablauf"))) > intval(date("Ymd"))){
$show=1;
//print " ablauf 1";
}else if($ablaufCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"ablauf"))) < intval(date("Ymd"))){
$show=0;
//print " ablauf 2";
}else{
$show=1;
//print " ablauf 3";
}
}
}
if($show==1 && $activ==1){
switch ($i) {
case 0:
$breite="158";
break;
case 1:
$breite="159";
break;
case 2:
$breite="159";
break;
case 3:
$breite="159";
break;
case 4:
$breite="158";
break;
default:
$breite="158";
break;
}
$i++;
$Qnavi2=mysql_query("SELECT id,parent,name FROM $DB_navie WHERE parent='".$zeile['id']."' && naviwahl!='2' && geloescht='0' ORDER BY position");
$Qnavi2Num2=mysql_num_rows($Qnavi2);
$Qnavi2Num=0;
for($zii=0;$zii<$Qnavi2Num2;$zii++){
$Qid=mysql_result($Qnavi2,$zii,"id");
$resultPage=mysql_query("SELECT startCheck,start,ablaufCheck,ablauf,activ FROM $DB_pages WHERE id='".$Qid."'");
$startCheck=mysql_result($resultPage,0,"startCheck");
$ablaufCheck=mysql_result($resultPage,0,"ablaufCheck");
$activ=mysql_result($resultPage,0,"activ");
if($ablaufCheck==1 || $startCheck==1){
if($startCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"start"))) < intval(date("Ymd"))){
$check=1;
//print " start 1";
}else if($startCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"start"))) > intval(date("Ymd"))){
$show=0;
//print " start 2";
}else{
$check=1;
//print " start 3";
}
if($check==1){
$ablauf=mysql_result($resultPage,0,"ablauf");
if($ablaufCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"ablauf"))) > intval(date("Ymd"))){
$show=1;
//print " ablauf 1";
}else if($ablaufCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"ablauf"))) < intval(date("Ymd"))){
$show=0;
//print " ablauf 2";
}else{
$show=1;
//print " ablauf 3";
}
}
}
if($show==1 && $activ==1){
$Qnavi2Num++;
}
}
if($zeile['id']==$id_seite){
$onmouse="";
$visibility="visible";
}else{
$onmouse="onMouseOver=\"unavizeigen('".$zeile['id']."','$Qnavi2Num')\" onMouseOut=\"unavinichtzeigen('".$zeile['id']."','$Qnavi2Num')\"";
$visibility="hidden";
}
$Qnavi2=mysql_query("SELECT id FROM $DB_navie WHERE parent='".$zeile['id']."' && naviwahl!='2' && geloescht='0' ORDER BY position");
if($Qnavi2Num>0){
while($zeile2=mysql_fetch_array($Qnavi2)){
if($zeile2['id']==$id_seite){
$onmouse="";
$visibility="visible";
break;
}
}
}
$nonscript.= "
|
 | ";
}
$Qnavi2=mysql_query("SELECT id,parent,name FROM $DB_navie WHERE parent='".$zeile['id']."' && naviwahl!='2' && geloescht='0' ORDER BY position");
$Qnavi2Num=mysql_num_rows($Qnavi2);
if($Qnavi2Num>0){
$top=1;
if($za==0){
$left=$left+1;
$za++;
}else{
if($i==5){
$left=$breite+$left+2;
}else{
$left=$breite+$left+1;
}
}
$zii=0;
$unavi.="";
while($zeile2=mysql_fetch_array($Qnavi2)){
$resultPage=mysql_query("SELECT startCheck,start,ablaufCheck,ablauf,activ FROM $DB_pages WHERE id='".$zeile2['id']."'");
$startCheck=mysql_result($resultPage,0,"startCheck");
$ablaufCheck=mysql_result($resultPage,0,"ablaufCheck");
$activ=mysql_result($resultPage,0,"activ");
if($ablaufCheck==1 || $startCheck==1){
if($startCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"start"))) < intval(date("Ymd"))){
$check=1;
//print " start 1";
}else if($startCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"start"))) > intval(date("Ymd"))){
$show=0;
//print " start 2";
}else{
$check=1;
//print " start 3";
}
if($check==1){
$ablauf=mysql_result($resultPage,0,"ablauf");
if($ablaufCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"ablauf"))) > intval(date("Ymd"))){
$show=1;
//print " ablauf 1";
}else if($ablaufCheck!=0 && intval(str_replace("|","",mysql_result($resultPage,0,"ablauf"))) < intval(date("Ymd"))){
$show=0;
//print " ablauf 2";
}else{
$show=1;
//print " ablauf 3";
}
}
}
if($show==1 && $activ==1){
if($zii==0){
$top=$top+0;
}else{
$top=$top+21;
}
/*$unavi.="
";*/
$zii++;
if(strlen($zeile2['name'])>23){
$top=$top+8;
}else{
$top=$top;
}
}
}
$unavi.=" ";
}
}
$nonscript.= "
$unavi";
print $nonscript;
?>
|
|