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

Jahrgang
"; $query = "SELECT Beschreibung, dateiname, target FROM skik_admin_rechte, skik_admin_rechte_zuord, skik_admin WHERE skik_admin.faid = skik_admin_rechte_zuord.faid AND skik_admin_rechte.skik_admin_rolle = skik_admin_rechte_zuord.skik_admin_rolle AND bereich = 'o' AND skik_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 skik_admin_rechte, skik_admin_rechte_zuord, skik_admin WHERE skik_admin.faid = skik_admin_rechte_zuord.faid AND skik_admin_rechte.skik_admin_rolle = skik_admin_rechte_zuord.skik_admin_rolle AND bereich = 'j' AND skik_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 skik_admin_rechte, skik_admin_rechte_zuord, skik_admin WHERE skik_admin.faid = skik_admin_rechte_zuord.faid AND skik_admin_rechte.skik_admin_rolle = skik_admin_rechte_zuord.skik_admin_rolle AND bereich = 'a' AND skik_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 skik_admin_rechte, skik_admin_rechte_zuord, skik_admin WHERE skik_admin.faid = skik_admin_rechte_zuord.faid AND skik_admin_rechte.skik_admin_rolle = skik_admin_rechte_zuord.skik_admin_rolle AND bereich = 's' AND skik_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
"; ?>