include("include/init.php"); check_login(); //if ($_SESSION['type'] != 'personeel') regular_error($http_path.'/', (array) NULL, // 'de gevraagde pagina is alleen toegankelijk voor personeel'); $result = mysql_query_safe("SELECT teletop_username FROM ppl2teletop WHERE ppl_id = {$_SESSION['ppl_id']}"); if (mysql_numrows($result)) $teletop_username = mysql_result($result, 0, 0); mysql_free_result($result); $vaksite_selector = '0'; if ($_SESSION['type'] == 'personeel' && $_SESSION['teletop_session']) { $ch = curl_teletop_init(); $xpath = curl_teletop_req($ch, '/tt/abvo/lms.nsf/f-MyCourses?OpenForm'); //echo($xpath->document->saveHTML()); $lijst = $xpath->query('//table[@id="viewMyCourses"]/tbody/tr[contains(@id, "~teachers")]/td[2]/a[1]'); $escaped_prefix = addcslashes($teletop_vaksite_prefix, '\/'); $out = new DOMDocument(); $select = $out->createElement('select'); $select->setAttribute('name', 'vaksite_id[]'); $out->appendChild($select); $default_option = $out->createElement('option'); $default_option->setAttribute('value', ''); $select->appendChild($default_option); foreach ($lijst as $link) { // database bijwerken (meestal zinloos) $href = $link->getAttribute('href'); $vaksite = preg_replace('/'.$escaped_prefix.'(.*)\.nsf/', '$1', $href); if ($href == $vaksite) regular_error($http_path.'/', (array) NULL, 'TeleTOP® geeft ons misvormde vaksites, notificeer de beheerder'); mysql_query_safe("INSERT INTO vaksites ( vaksite, vaksite_naam ) VALUES ( '%s', '%s' ) ON DUPLICATE KEY UPDATE vaksite_naam='%s'", mysql_escape_safe($vaksite), mysql_escape_safe(htmlspecialchars($link->nodeValue, ENT_QUOTES, 'UTF-8')), mysql_escape_safe(htmlspecialchars($link->nodeValue, ENT_QUOTES, 'UTF-8'))); $vaksite_id = sprint_singular("SELECT vaksite_id FROM vaksites WHERE vaksite = '%s'", mysql_escape_safe($vaksite)); //$vaksites .= '
'.$vaksite.' '.$link->nodeValue."\n";
$option = $out->createElement('option');
$option->setAttribute("value", $vaksite_id);
$text = $out->createTextNode($link->nodeValue);
$option->appendChild($text);
$select->appendChild($option);
$vaksite_selector .= ' OR vaksites.vaksite_id = '.$vaksite_id;
}
$result = mysql_query_safe(<<'.$row['grp2vak'].' '.$out->saveHTML();
$option->removeAttribute('selected');
}
$vaksites .= '';
//echo($out->saveHTML());
$result = mysql_query_safe(<< '."\n";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$vaksites_range .= 'vaksite eerstvolgende maximum '."\n";
}
$vaksites_range .= ''."\n";
} else if ($_SESSION['type'] == 'personeel' && not_teletop_credentials()) {
$vaksites = <<'.$row['vaksite_naam'].'