= $week_id EOQ ); if (!$request_id) error_system("geen request voor deze melding"); if (!isset($_POST['in_vip'])) error_system("input field 'in vip' is not set"); switch ($_POST['in_vip']) { case 0: $in_vip = 0; break; case 1: $in_vip = 1; break; default: error_system("onmogelijke waarde voor in_vip"); } if (!isset($_POST['duration'])) error_system("input field 'duration' is not set"); switch ($_POST['duration']) { case 'SHORT': $duration = 'SHORT'; break; case 'HALF': $duration = 'HALF'; break; case 'LONG': $duration = 'LONG'; break; case 'AFWEZIG': $duration = 'AFWEZIG'; break; default: error_system("onmogelijke waarde voor duration"); } $ok = 0; mdb2_exec($db, "INSERT INTO accept ( requestee_ppl_id, week_id, in_vip, duration, acceptor_ppl_id, subj_id, text ) VALUES ( $requestee_ppl_id, $week_id, $in_vip, '$duration', {$_SESSION['ppl_id']}, $subj_id, '%q' )", $_POST['text']); $accept_id = mdb2_single_val($db, $last_insert_id); foreach ($_POST['request_id'] as $potential_request_id) { $request_id = mdb2_single_val($db, <<= $week_id AND request_id = %i EOQ , $potential_request_id); if (!$request_id) continue; $ok = 1; mdb2_exec($db, "INSERT INTO accept2request ( accept_id, request_id ) VALUES ( $accept_id, $request_id )"); } if (!$ok) error_user('Geen hulpvraag aangevinkt', 'Bij het melden van de aanwezigheid van een leerling moet minstens 1 hulpvraag aangevinkt blijven', 'meld.php?week_id='.$week_id.'&ppl_id='.$requestee_ppl_id.'&subj_id='.$subj_id); header('Location: '.$location.'?rol=vipdocent&week_id='.$_POST['week_id']); ?>