{$herinfo['period_deadline']} JOIN $kldv.grp2subj ON grp2subj.grp_id = ppl2grp.grp_id JOIN $kldv.ppl2grp2subj ON ppl2grp2subj.grp2subj_id = grp2subj.grp2subj_id AND ppl2grp2subj.ppl_enter <= {$herinfo['period_deadline']} AND ppl2grp2subj.ppl_exit > {$herinfo['period_deadline']} JOIN $kldv.ppl2altlogin ON ppl2altlogin.ppl_id = ppl2grp2subj.ppl_id JOIN $kldv.subj ON subj.subj_id = grp2subj.subj_id WHERE ppl.ppl_id = %i AND altlogin = '%q' AND subj_abbrev = 'mt' EOQ , $ppl_id, $_SESSION['username']); if (!$true) error_user('Onmogelijk', 'Je geeft een herkansing op voor een leerling die niet jouw mentorleerling is'); $subj_id = $_POST['vak'][$count]; $rex_id = $_POST['rex_id'][$count]; $info = $_POST['info'][$count]; //echo("vak={$_POST['vak'][$count]} info = {$_POST['info'][$count]} rex_id = {$_POST['rex_id'][$count]}\n"); if ($rex_id) { // wijzig bestaande herkansing? if (!$subj_id) mdb2_exec($db, "DELETE FROM rex WHERE rex_id = %i AND ppl_id = %i AND period_id = {$herinfo['period_id']}", $rex_id, $ppl_id); else { mdb2_exec($db, "UPDATE rex SET info = '%q', subj_id = %i WHERE ppl_id = %i AND period_id = {$herinfo['period_id']} AND rex_id = %i", htmlenc($info), $subj_id, $ppl_id, $rex_id); // error_user("NIET", "geimplementeerd"); } } else { if ($subj_id) { // er is een vak geselecteerd mdb2_exec($db, "INSERT INTO rex ( ppl_id, subj_id, period_id, info ) VALUES ( %i, %i, {$herinfo['period_id']}, '%q' )", $ppl_id, $subj_id, htmlenc($info)); $rex_id = mdb2_single_val($db, $last_insert_id); $num = mdb2_single_val($db, "SELECT COUNT(*) FROM rex WHERE ppl_id = %i AND period_id = {$herinfo['period_id']}", $ppl_id); if ($num > 1) { mdb2_exec($db, "DELETE FROM rex WHERE rex_id = $rex_id"); error_user("te veel herkansingen", "ll probeert meer dan 1 her op te geven :("); } } } $count++; } header("Location: $location".'mentor.php'); ?>