function quoth($string) {
return "'".$string."'";
}
$db = mdb2_open($dsn);
$year_id = mdb2_single_val($db, "SELECT config_value FROM config WHERE config_key = 'YEAR_ID'");
if (!$year_id) error_system("schooljaar niet ingesteld, zie config.config_key = 'YEAR_ID' in DB");
$year_long = mdb2_single_val($db, "SELECT year_long FROM $kldv.years WHERE year_id = $year_id");
if (!$year_long) error_system("schooljaar met year_id = $year_id is onbekend in kldv database");
$bevroren = mdb2_single_val($db, "SELECT config_value FROM config WHERE config_key = 'BEVROREN'");
if ($bevroren === NULL) error_system("key 'BEVROREN' niet in config");
$subjs = mdb2_all_assoc_rekey($db, "SELECT subj_id, subj_abbrev FROM $kldv.subj WHERE subj_abbrev IN ( ".implode(', ', array_map('quoth', $vakken)).") ORDER BY subj_abbrev");
if (count($vakken) != count($subjs)) error_system("niet alle vakken uit config_common.php gevonden in kldv.subj");
$subj_ids = implode(', ', array_keys($subjs));
function bbtohtml($t) {
$pattern['url'] = '/\[url\=(.+?)\](.+?)\[\/url\]/is';
$replacement['url'] = '$2';
$pattern['lf'] = '/\r\n/is';
$replacement['lf'] = '
';
$pattern['b'] = '/\[b\](.+?)\[\/b\]/is';
$replacement['b'] = '$1';
$pattern['i'] = '/\[i\](.+?)\[\/i\]/is';
$replacement['i'] = '$1';
return preg_replace($pattern, $replacement, $t);
}
function htmltobb($t) {
$pattern['lf'] = '/
/is';
$replacement['lf'] = "\r\n";
$pattern['url'] = '/(.+?)<\/a>/is';
$replacement['url'] = '[url=$1]$2[/url]';
$pattern['b'] = '/(.+?)<\/b>/is';
$replacement['b'] = '[b]$1[/b]';
$pattern['i'] = '/(.+?)<\/i>/is';
$replacement['i'] = '[i]$1[/i]';
return preg_replace($pattern, $replacement, $t);
}
function bewerkbaar() {
global $db, $bevroren;
if (!$_SESSION['admin'] && $bevroren) return 0;
return 1;
}
function build_query_string_combine($kv) {
return urlencode($kv['key']).'='.urlencode($kv['value']);
}
function build_query_string($array, $body = true) {
$elements = array();
if (count($array) == 0) return '';
foreach ($array as $key => $value) {
if (is_array($value)) {
foreach ($value as $val) {
$elements[] = array('key' => $key.'[]', 'value' => $val);
}
} else {
$elements[] = array('key' => $key, 'value' => $value);
}
}
return '?'.implode($body?'&':'&', array_map('build_query_string_combine', $elements));
}
$toets_target_options = array (
'4H' => '4H',
'5H' => '5H',
'4V' => '4V',
'5V' => '5V',
'6V' => '6V'
);
$toets_tp_options = array (
'TP1' => 'TP1',
'TP2' => 'TP2',
'TP3' => 'TP3'
);
$toets_nummer_options = array(
'' => '',
'1' => '1',
'2' => '2',
'3' => '3',
'4' => '4',
'5' => '5',
'6' => '6',
'7' => '7',
'8' => '8'
);
$toets_letter_options = array(
'' => '',
'a' => 'a',
'b' => 'b',
'c' => 'c',
'd' => 'd',
'e' => 'e',
'f' => 'f',
'g' => 'g',
'h' => 'h'
);
$toets_omschrijving_options = array(
'' => '-',
'literatuur' => 'literatuur',
'schrijfv.' => 'schrijfv.',
'brief' => 'brief',
'klt' => 'klt',
'luisterv.' => 'luisterv.',
'leesv.' => 'leesv.',
'discussie' => 'discussie',
'grammatica' => 'grammatica',
'vertalen' => 'vertalen',
'idioom' => 'idioom',
'spreekv.' => 'spreekv.'
);
$toets_lokaal_options = array (
'THEORIELOKAAL' => 'theorielokaal (toets kan samen met andere toetsen)',
'COMPUTERLOKAAL' => 'computerlokaal (toets kan samen met andere toetsen)',
'LABENCOM' => 'praktijk- en computerlokaal',
'KIJKLUISTERLOKAAL' => 'lokaal voor klassikale kijk-/luistertoets'
);
$toets_soort_options = array (
'GEWOONST' => 'ST (in toetsweek en herkansbaar)',
'VT' => 'VT (in toetsweek, niet herkansbaar)',
'PO' => 'PO (in toetsweek, niet herkansbaar)',
'HD' => 'handelingsdeel (in toetsweek, niet herkansbaar)',
'STGEENHER' => 'deel-ST (in toetsweek, niet herkansbaar)',
'STALLEENHER' => 'ST buiten toetsweek, wel bij herkansingen',
'VTHER' => 'VT (in toetsweek, wel herkansbaar)'
);
function render_radio($name, $options, $default = NULL) {
foreach ($options as $value => $text) { ?>
name="=$name?>" value="=$value?>"> =$text?>
}
}
function render_select($name, $options, $default = NULL) { ?>
}
function clean_check_return($array, $key, $values) {
if (array_key_exists($key, $array)) {
$value = $array[$key];
if (array_key_exists($value, $values)) return $value;
}
return NULL;
}
?>