forked from science-ation/science-ation
114 lines
3.4 KiB
PHP
114 lines
3.4 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
function conv_config($mysqli, $old_prefix)
|
||
|
|
{
|
||
|
|
print("Converting Config\n");
|
||
|
|
|
||
|
|
/* Get the latest year */
|
||
|
|
$q = $mysqli->query("SELECT val FROM {$old_prefix}config WHERE `var`='FAIRYEAR'");
|
||
|
|
$r = $q->fetch_row();
|
||
|
|
$year = (int)$r[0];
|
||
|
|
print(" Latest Year = $year\n");
|
||
|
|
|
||
|
|
/* Save the current year */
|
||
|
|
$mysqli->real_query("UPDATE config SET `val`='$year' WHERE `var`='year'");
|
||
|
|
|
||
|
|
/* Convert dates */
|
||
|
|
$q = $mysqli->query("SELECT * FROM {$old_prefix}dates WHERE year='$year'");
|
||
|
|
print($mysqli->error);
|
||
|
|
$c = 0;
|
||
|
|
while($old_c = $q->fetch_assoc()) {
|
||
|
|
$old_name = $old_c['name'];
|
||
|
|
$old_val = $old_c['date'];
|
||
|
|
|
||
|
|
$val = $mysqli->real_escape_string($old_val);
|
||
|
|
$name = NULL;
|
||
|
|
switch($old_name) {
|
||
|
|
case 'fairdate':
|
||
|
|
$mysqli->real_query("UPDATE `config` SET `val`='$val' WHERE `var`='date_fair_begins'");
|
||
|
|
$mysqli->real_query("UPDATE `config` SET `val`='$val' WHERE `var`='date_fair_ends'");
|
||
|
|
break;
|
||
|
|
case 'regopen':
|
||
|
|
$mysqli->real_query("UPDATE `config` SET `val`='$val' WHERE `var`='date_student_registration_opens'");
|
||
|
|
break;
|
||
|
|
case 'regclose':
|
||
|
|
$mysqli->real_query("UPDATE `config` SET `val`='$val' WHERE `var`='date_student_registration_closes'");
|
||
|
|
break;
|
||
|
|
case 'judgeregopen':
|
||
|
|
$mysqli->real_query("UPDATE `config` SET `val`='$val' WHERE `var`='date_judge_registration_opens'");
|
||
|
|
break;
|
||
|
|
case 'judgeregclose':
|
||
|
|
$mysqli->real_query("UPDATE `config` SET `val`='$val' WHERE `var`='date_judge_registration_closes'");
|
||
|
|
break;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
/* Convert the rest of the config */
|
||
|
|
$q = $mysqli->query("SELECT * FROM {$old_prefix}config WHERE year='$year'");
|
||
|
|
print($mysqli->error);
|
||
|
|
$c = 0;
|
||
|
|
while($old_c = $q->fetch_assoc()) {
|
||
|
|
$old_var = $old_c['var'];
|
||
|
|
$old_val = $old_c['val'];
|
||
|
|
$old_category = $old_c['category'];
|
||
|
|
$old_type = $old_c['type'];
|
||
|
|
$old_typevalues = $old_c['type_values'];
|
||
|
|
$old_ord = $old_c['ord'];
|
||
|
|
$old_description = $old_c['description'];
|
||
|
|
|
||
|
|
$var = NULL;
|
||
|
|
if($old_type == 'yesno') {
|
||
|
|
$val = $old_val == 'yes' ? 1 : 0;
|
||
|
|
} else {
|
||
|
|
$val = $old_val;
|
||
|
|
}
|
||
|
|
|
||
|
|
switch($old_var) {
|
||
|
|
case 'fairmanageremail':
|
||
|
|
$var = array('email_chair', 'email_chiefjudge', 'email_ethics','email_registration');
|
||
|
|
break;
|
||
|
|
|
||
|
|
case 'fairname': $var = 'fair_name'; break;
|
||
|
|
case 'regfee': $var = 'regfee'; break;
|
||
|
|
case 'tours_enable': $var = 'tours_enable'; break;
|
||
|
|
case 'participant_student_tshirt': $var = 'tshirt_enable'; break;
|
||
|
|
case 'participant_student_tshirt_cost': $var = 'tshirt_cost'; break;
|
||
|
|
case 'volunteer_enable': $var = 'volunteers_enable'; break;
|
||
|
|
case 'participant_project_summary_wordmax': $var = 's_abstract_max_words'; break;
|
||
|
|
case 'participant_project_summary_wordmin': $var = 's_abstract_min_words'; break;
|
||
|
|
|
||
|
|
case 'min_judges_per_team': $var = 'judge_div_min_team'; break;
|
||
|
|
case 'max_judges_per_team': $var = 'judge_div_max_team'; break;
|
||
|
|
case 'max_projects_per_team': $var = 'judge_div_max_projects'; break;
|
||
|
|
|
||
|
|
case 'projects_per_special_award_judge': $var = 'judge_sa_max_projects'; break;
|
||
|
|
}
|
||
|
|
|
||
|
|
if($var !== NULL) {
|
||
|
|
if(!is_array($var)) {
|
||
|
|
$var = array($var);
|
||
|
|
}
|
||
|
|
|
||
|
|
$val = $mysqli->real_escape_string($val);
|
||
|
|
|
||
|
|
foreach($var as $v) {
|
||
|
|
$mysqli->real_query("UPDATE `config` SET `val`='$val' WHERE `var`='$v'");
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
/* These are all missing from the old config:
|
||
|
|
// fair_abbreviation
|
||
|
|
// s_tagline_max_words
|
||
|
|
// s_tagline_min_words
|
||
|
|
// judge_cusp_max_team
|
||
|
|
// judge_cusp_min_team
|
||
|
|
// judge_div_min_projects
|
||
|
|
// judge_sa_min_projects
|
||
|
|
*/
|
||
|
|
|
||
|
|
}
|
||
|
|
print(" Converted config.\n");
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|