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

Jahrgang
"; $query = "SELECT Beschreibung, dateiname, target FROM sozkom_admin_rechte, sozkom_admin_rechte_zuord, sozkom_admin WHERE sozkom_admin.faid = sozkom_admin_rechte_zuord.faid AND sozkom_admin_rechte.sozkom_admin_rolle = sozkom_admin_rechte_zuord.sozkom_admin_rolle AND bereich = 'o' AND sozkom_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 sozkom_admin_rechte, sozkom_admin_rechte_zuord, sozkom_admin WHERE sozkom_admin.faid = sozkom_admin_rechte_zuord.faid AND sozkom_admin_rechte.sozkom_admin_rolle = sozkom_admin_rechte_zuord.sozkom_admin_rolle AND bereich = 'j' AND sozkom_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 sozkom_admin_rechte, sozkom_admin_rechte_zuord, sozkom_admin WHERE sozkom_admin.faid = sozkom_admin_rechte_zuord.faid AND sozkom_admin_rechte.sozkom_admin_rolle = sozkom_admin_rechte_zuord.sozkom_admin_rolle AND bereich = 'a' AND sozkom_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 sozkom_admin_rechte, sozkom_admin_rechte_zuord, sozkom_admin WHERE sozkom_admin.faid = sozkom_admin_rechte_zuord.faid AND sozkom_admin_rechte.sozkom_admin_rolle = sozkom_admin_rechte_zuord.sozkom_admin_rolle AND bereich = 's' AND sozkom_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
"; ?>