{$_SERVER['REQUEST_TIME']} JOIN $kldv.grp2subj ON grp2subj.grp2subj_id = ppl2grp2subj.grp2subj_id JOIN $kldv.grp ON grp.grp_id = grp2subj.grp_id JOIN $kldv.subj ON subj.subj_id = grp2subj.subj_id JOIN $kldv.ppl2grp ON ppl2grp.grp_id = grp.grp_id AND ppl2grp.ppl_enter <= {$_SERVER['REQUEST_TIME']} AND ppl2grp.ppl_exit >{$_SERVER['REQUEST_TIME']} JOIN $kldv.ppl AS lln ON lln.ppl_id = ppl2grp.ppl_id WHERE ppl.ppl_id = {$_SESSION['ppl_id']} AND lln.ppl_id = %i ORDER BY lln.ppl_surname, lln.ppl_forename, lln.ppl_prefix EOQ , $_POST['ppl_id']); if (!$ppl_id && !$_SESSION['admin']) error_user("Geen toegang", "Je geeft geen les aan deze leerling, de gegevens zijn niet toegankelijk"); $count = count($_POST['signal_id']); for ($i = 0; $i < $count; $i++) { $signal_id = $_POST['signal_id'][$i]; $signal2ppl_id = $_POST['signal2ppl_id'][$i]; $severity = $_POST['severity'][$i]; if ($severity != '' && $severity != '0' && $severity != '1' && $severity != '2' && $severity !== '3') error_system('onmogelijke severity'); //echo('

signal_id='.$_POST['signal_id'][$i].', signal2ppl_id='.$_POST['signal2ppl_id'][$i].', severity='.$_POST['severity'][$i]); if (!$signal2ppl_id) { if ($severity != '') mdb2_exec($db, "INSERT INTO signal2ppl ( signal_id, signaler_ppl_id, signalee_ppl_id, signal_severity, timestamp, year_id ) VALUES ( %i, {$_SESSION['ppl_id']}, %i, %i, {$_SERVER['REQUEST_TIME']}, $year_id )", $signal_id, $_POST['ppl_id'], $severity); } else { if ($severity != '') mdb2_exec($db, "UPDATE signal2ppl SET signal_severity = %i WHERE signal2ppl_id = %i AND signaler_ppl_id = {$_SESSION['ppl_id']} AND signalee_ppl_id = %i AND year_id = $year_id", $severity, $signal2ppl_id, $_POST['ppl_id']); else mdb2_exec($db, "DELETE FROM signal2ppl WHERE signal2ppl_id = %i AND signaler_ppl_id = {$_SESSION['ppl_id']} AND signalee_ppl_id = %i AND year_id = $year_id", $signal2ppl_id, $_POST['ppl_id']); } } header('Location: signal_ll.php?ppl_id='.$_POST['ppl_id']); ?>