"; exit; } require_once "../language/german.inc.php"; if (isset($_GET['action'])) { $action = $_GET['action']; } else { $action = ''; } if ($action == '') { if (isset($_GET['edit'])) { $rid = $_GET['edit']; $smarty->assign('rollen_edit', $rid); } $result_head = $db->query("SELECT bezeichnung FROM jumi_admin_rolle WHERE rid=$rid"); $row_head = $result_head->fetch_array(); $smarty->assign('rollenzuordnung_bezeichnung', $row_head['bezeichnung']); # Nicht zugewiesene Rechte $query = "SELECT meid, headline FROM jumi_menu_entries WHERE meid NOT IN (SELECT meid FROM jumi_admin_rollen_rechte_zuord WHERE rid=$rid) ORDER BY meid ASC"; $result = $db->query($query) or die("Cannot execute query"); while ($row = $result->fetch_array()) { $table_data[] = $row; } $smarty->assign('table_data', $table_data); # Zugewiesene Rechte $query1 = "SELECT meid, headline FROM jumi_menu_entries WHERE meid IN (SELECT meid FROM jumi_admin_rollen_rechte_zuord WHERE rid=$rid) ORDER BY meid ASC"; $result1 = $db->query($query1) or die("Cannot execute query1"); while ($row1 = $result1->fetch_array()) { $table_data1[] = $row1; } $smarty->assign('table_data1', $table_data1); } $smarty->assign('action', "$action"); $smarty->display("$template/dashboard/$templatename"); ?>