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

Jahrgang
"; $query = "SELECT Beschreibung, dateiname, target FROM spt_admin_rechte, spt_admin_rechte_zuord, spt_admin WHERE spt_admin.faid = spt_admin_rechte_zuord.faid AND spt_admin_rechte.spt_admin_rolle = spt_admin_rechte_zuord.spt_admin_rolle AND bereich = 'o' AND spt_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 spt_admin_rechte, spt_admin_rechte_zuord, spt_admin WHERE spt_admin.faid = spt_admin_rechte_zuord.faid AND spt_admin_rechte.spt_admin_rolle = spt_admin_rechte_zuord.spt_admin_rolle AND bereich = 'j' AND spt_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 spt_admin_rechte, spt_admin_rechte_zuord, spt_admin WHERE spt_admin.faid = spt_admin_rechte_zuord.faid AND spt_admin_rechte.spt_admin_rolle = spt_admin_rechte_zuord.spt_admin_rolle AND bereich = 'a' AND spt_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 spt_admin_rechte, spt_admin_rechte_zuord, spt_admin WHERE spt_admin.faid = spt_admin_rechte_zuord.faid AND spt_admin_rechte.spt_admin_rolle = spt_admin_rechte_zuord.spt_admin_rolle AND bereich = 's' AND spt_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
"; ?>