0) // $queryAdd = "AND ((level=1 OR master_id='".$id."' OR master_id=$curMasterId OR id='".$id."' ) OR (master_id='$prevMasterId'))"; //OR (level=2 AND id=$curMasterId) //else // $queryAdd = "AND level=1"; $query = " SELECT id, master_id, master_id_array, name_".$lngName.", level, active, JRK FROM ".$tableGroup." WHERE active=1 ".$queryAdd." ORDER BY level, JRK"; //master_id, name $resultGroup = mysql_query($query); while ($row = mysql_fetch_assoc($resultGroup)){ if ($row['master_id']==0) { $groupArray[$row['id']] = array( 'id' => $row['id'], 'master_id' => $row['master_id'], 'master_id_array' => $row['master_id_array'], 'level' => $row['level'], 'name' => CAL6_STRIP($row['name_'.$lngName]), 'JRK' => $row['JRK'], 'active' => $row['active'], 'sub' => "0" ); }elseif ($row['level']==2 and $row['level']<=$maxLevel and mysql_result(mysql_query("SELECT active FROM ".$tableGroup." WHERE id = ".$row['master_id']),0,"active") == 1) { if (!is_array($groupArray[$row['master_id']]['sub'])) $groupArray[$row['master_id']]['sub'] = array(); $groupArray[$row['master_id']]['sub'][$row['id']] = array( 'id' => $row['id'], 'master_id' => $row['master_id'], 'master_id_array' => $row['master_id_array'], 'level' => $row['level'], 'name' => CAL6_STRIP($row['name_'.$lngName]), 'active' => $row['active'], 'JRK' => $row['JRK'] ); }elseif ($row['level']==3 and $row['level']<=$maxLevel) { $masterID = mysql_result(mysql_query("SELECT master_id FROM ".$tableGroup." WHERE id=".$row['master_id']),0,"master_id"); //if (!is_array($groupArray[$masterID]['sub'][$row['master_id']]['sub'])) $groupArray[1]['sub'][$row['master_id']]['sub'] = array(); $groupArray[$masterID]['sub'][$row['master_id']]['sub'][$row['id']] = array( 'id' =>$row['id'], 'master_id' =>$row['master_id'], 'master_id_array' => $row['master_id_array'], 'level' =>$row['level'], 'name' =>CAL6_STRIP($row['name_'.$lngName]), 'active' =>$row['active'], 'JRK' =>$row['JRK'] ); //array_push($groupArray[$row['master_id']]['sub'], array('id'=>$row['id'],'master_id'=>$row['master_id'],'name_est'=>$row['name_est'],'active'=>$row['active'],'JRK'=>$row['JRK'],)); } $lastMaster = $row['master_id']; } return $groupArray; } $groupArray = getStructureNimiMuudetudSestMenyysKaSeeFunktsioon($tableGroup, $Lang, 3); $referentsidArray = getStructureNimiMuudetudSestMenyysKaSeeFunktsioon("module_referents_structure", $Lang, 3); if ($format=="xml"){ header("Content-Type: xml"); print''; echo "\n"; $MiniNaviQ = MYSQL_QUERY("SELECT Redirect, URLTarget, REC_ID, Name, Level, JRK, Password, NotLink FROM Struktuur WHERE Lang = '$LangID' AND Passive = 0 AND Archive = 0 AND (ACL = '0' OR FIND_IN_SET(ACL, '".@JOIN(',', $GuestACL)."')) ORDER BY JRK ASC"); FOR ($i = 0; $i < MYSQL_NUMROWS($MiniNaviQ); $i++) { $MiniNaviREC_ID = CAL6_STRIP(MYSQL_RESULT($MiniNaviQ, $i, "REC_ID")); $MiniNaviName = CAL6_STRIP(MYSQL_RESULT($MiniNaviQ, $i, "Name")); $MiniNaviLevel = CAL6_STRIP(MYSQL_RESULT($MiniNaviQ, $i, "Level")); $MiniNaviPassword = CAL6_STRIP(MYSQL_RESULT($MiniNaviQ, $i, "Password")); $MiniNaviNotLink = CAL6_STRIP(MYSQL_RESULT($MiniNaviQ, $i, "NotLink")); $MiniNaviURLTarget = CAL6_STRIP(MYSQL_RESULT($MiniNaviQ, $i, "URLTarget")); $MiniNaviRedirect = CAL6_STRIP(MYSQL_RESULT($MiniNaviQ, $i, "Redirect")); echo "".$BaseUrl."?op=body&id=".$MiniNaviREC_ID."\n"; if (in_array($MiniNaviREC_ID,$tootedMenuArray)) { foreach ($groupArray as $row){ echo "".$BaseUrl."?op=body&id=".$MiniNaviREC_ID."&prod=".$row['id']."\n"; foreach ($row['sub'] as $rowSub){ echo "".$BaseUrl."?op=body&id=".$MiniNaviREC_ID."&prod=".$rowSub['id']."\n"; } } } } echo ""; } else { ?>

"; foreach ($row['sub'] as $rowSub){ print ""; } } } ?> ( )

1):?> >	"; print " "; print $row['name'].""; print "
"; print ""; print "".$rowSub['name'].""; print "