"; exit; } require_once "../language/german.inc.php"; if (isset($_GET['action'])) { $action = $_GET['action']; } else { $action = ''; } if ($action == '') { if (isset($_GET['edit'])) { $zsid = $_GET['edit']; $smarty->assign('zusammenstellung_edit', $zsid); } $result_head = $db->query("SELECT bezeichnung FROM jumi_noten_zusammenstellung WHERE zsid=$zsid"); $row_head = $result_head->fetch_array(); $smarty->assign('notenzuordnung_bezeichnung', $row_head['bezeichnung']); # Nicht zugewiesene User $query = "SELECT csid, vorname, nachname FROM jumi_chor_saenger WHERE csid NOT IN (SELECT csid FROM jumi_noten_zus_saenger_zuord WHERE zsid=$zsid) ORDER BY nachname 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 csid, vorname, nachname FROM jumi_chor_saenger WHERE csid IN (SELECT csid FROM jumi_noten_zus_saenger_zuord WHERE zsid=$zsid) ORDER BY nachname 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"); ?>