query("SELECT DISTINCT 1 FROM pros_admin_rechte_zuord, pros_admin, pros_admin_rechte WHERE pros_admin_rechte_zuord.faid = pros_admin.faid AND pros_admin_rechte.pros_admin_rolle = pros_admin_rechte_zuord.pros_admin_rolle AND pros_admin.user='$user_admin' AND bereich='j' "); $row0 = $result0->fetch_array(); $result1 = $db->query("SELECT DISTINCT 1 FROM pros_admin_rechte_zuord, pros_admin, pros_admin_rechte WHERE pros_admin_rechte_zuord.faid = pros_admin.faid AND pros_admin_rechte.pros_admin_rolle = pros_admin_rechte_zuord.pros_admin_rolle AND pros_admin.user='$user_admin' AND bereich='a' "); $row1 = $result1->fetch_array(); $result2 = $db->query("SELECT DISTINCT 1 FROM pros_admin_rechte_zuord, pros_admin, pros_admin_rechte WHERE pros_admin_rechte_zuord.faid = pros_admin.faid AND pros_admin_rechte.pros_admin_rolle = pros_admin_rechte_zuord.pros_admin_rolle AND pros_admin.user='$user_admin' AND bereich='s' "); $row2 = $result2->fetch_array(); echo" Menu
  Menu
 

Jahrgang
"; $query = "SELECT Beschreibung, dateiname, target FROM pros_admin_rechte, pros_admin_rechte_zuord, pros_admin WHERE pros_admin.faid = pros_admin_rechte_zuord.faid AND pros_admin_rechte.pros_admin_rolle = pros_admin_rechte_zuord.pros_admin_rolle AND bereich = 'o' AND pros_admin.user = '$user_admin' ORDER BY sort_order ASC "; $result = $db->query($query) or die ("Cannot execute query"); while ($row = $result->fetch_array()){ echo" · $row[Beschreibung]
"; } $query = "SELECT Beschreibung, dateiname, target FROM pros_admin_rechte, pros_admin_rechte_zuord, pros_admin WHERE pros_admin.faid = pros_admin_rechte_zuord.faid AND pros_admin_rechte.pros_admin_rolle = pros_admin_rechte_zuord.pros_admin_rolle AND bereich = 'j' AND pros_admin.user = '$user_admin' ORDER BY sort_order ASC "; $result = $db->query($query) or die ("Cannot execute query"); while ($row = $result->fetch_array()){ if ($ln_zaehler1 < 1){ echo"Jahrgangsabhängig »
"; $ln_zaehler1 = 1; } echo" · $row[Beschreibung]
"; } echo"
"; $query = "SELECT Beschreibung, dateiname, target FROM pros_admin_rechte, pros_admin_rechte_zuord, pros_admin WHERE pros_admin.faid = pros_admin_rechte_zuord.faid AND pros_admin_rechte.pros_admin_rolle = pros_admin_rechte_zuord.pros_admin_rolle AND bereich = 'a' AND pros_admin.user = '$user_admin' ORDER BY sort_order ASC "; $result = $db->query($query) or die ("Cannot execute query"); while ($row = $result->fetch_array()){ if ($ln_zaehler2 < 1){ echo"Administration »
"; $ln_zaehler2 = 1; } echo" · $row[Beschreibung]
"; } echo"
"; $query = "SELECT Beschreibung, dateiname, target FROM pros_admin_rechte, pros_admin_rechte_zuord, pros_admin WHERE pros_admin.faid = pros_admin_rechte_zuord.faid AND pros_admin_rechte.pros_admin_rolle = pros_admin_rechte_zuord.pros_admin_rolle AND bereich = 's' AND pros_admin.user = '$user_admin' ORDER BY sort_order ASC "; $result = $db->query($query) or die ("Cannot execute query"); while ($row = $result->fetch_array()){ if ($ln_zaehler3 < 1){ echo"Statistik »
"; $ln_zaehler2 = 1; $ln_zaehler3 = 1; } echo" · $row[Beschreibung]
"; } echo"
"; echo" Logout
"; ?>