forked from science-ation/science-ation
96 lines
2.5 KiB
PHP
96 lines
2.5 KiB
PHP
|
<?php
|
||
|
|
|
||
|
|
|
||
|
|
$judges_map = array();
|
||
|
|
|
||
|
|
|
||
|
|
function conv_judges($mysqli, $old_prefix, $year)
|
||
|
|
{
|
||
|
|
global $awards_map, $awards_prizes_map;
|
||
|
|
|
||
|
|
print("Converting Judges for $year...\n");
|
||
|
|
|
||
|
|
$mysqli->real_query("DELETE FROM users WHERE FIND_IN_SET('judge',`roles`)>0 AND year='$year'");
|
||
|
|
|
||
|
|
/* */
|
||
|
|
|
||
|
|
$q = $mysqli->query("SELECT * FROM {$old_prefix}users WHERE FIND_IN_SET('judge',`types`)>0 AND deleted='no' AND year='$year'");
|
||
|
|
print($mysqli->error);
|
||
|
|
$c = 0;
|
||
|
|
while($old_u = $q->fetch_assoc()) {
|
||
|
|
|
||
|
|
$q1 = $mysqli->query("SELECT * FROM {$old_prefix}users_judge WHERE users_id='{$old_u['id']}'");
|
||
|
|
$r = $q1->fetch_assoc();
|
||
|
|
$old_u = array_merge($old_u, $r);
|
||
|
|
|
||
|
|
/* Skip incomplete users */
|
||
|
|
if($old_u['judge_active'] == 'no') continue;
|
||
|
|
if($old_u['judge_complete'] == 'no') continue;
|
||
|
|
|
||
|
|
/* Create a new user */
|
||
|
|
$password = NULL;
|
||
|
|
$u = user_create($mysqli, NULL, $old_u['email'], 'judge', $year, $password);
|
||
|
|
|
||
|
|
$u['phone1'] = $old_u['phonehome'];
|
||
|
|
$u['phone2'] = $old_u['phonecell'];
|
||
|
|
filter_phone($u['phone1']);
|
||
|
|
filter_phone($u['phone2']);
|
||
|
|
|
||
|
|
$u['username'] = NULL;
|
||
|
|
$u['firstname'] = $old_u['firstname'];
|
||
|
|
$u['lastname'] = $old_u['lastname'];
|
||
|
|
$u['salutation'] = $old_u['salutation'];
|
||
|
|
$u['organization'] = $old_u['organization'];
|
||
|
|
$u['sex'] = $old_u['sex'];
|
||
|
|
$u['city'] = $old_u['city'];
|
||
|
|
$u['province'] = $old_u['province'];
|
||
|
|
$u['language'] = ($old_u['lang'] == '') ? 'en' : $old_u['lang'];
|
||
|
|
if($old_u['highest_psd'] == '') {
|
||
|
|
$in['j_psd'] = NULL;
|
||
|
|
} else {
|
||
|
|
switch($old_u['highest_psd'][0]) {
|
||
|
|
case 'P': case 'p':
|
||
|
|
$u['j_psd'] = 'doctorate';
|
||
|
|
break;
|
||
|
|
case 'M': case 'm':
|
||
|
|
$u['j_psd'] = 'master';
|
||
|
|
break;
|
||
|
|
default:
|
||
|
|
$u['j_psd'] = 'bachelor';
|
||
|
|
break;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
$u['j_willing_lead'] = ($old_u['willing_chair'] == 'yes') ? 1 : 0;
|
||
|
|
if($old_u['languages'] != '') {
|
||
|
|
$u['j_languages'] = array_values(unserialize($old_u['languages']));
|
||
|
|
}
|
||
|
|
$u['j_sa_only'] = ($old_u['special_award_only'] == 'yes') ? 1 : 0;
|
||
|
|
$u['j_dinner'] = 0;
|
||
|
|
$u['j_years_school'] = $old_u['years_school'];
|
||
|
|
$u['j_years_regional'] = $old_u['years_regional'];
|
||
|
|
$u['j_years_national'] = $old_u['years_national'];
|
||
|
|
$u['enabled'] = 1;
|
||
|
|
$u['new'] = 0;
|
||
|
|
$u['j_rounds'] = array();
|
||
|
|
$u['j_complete'] = 1;
|
||
|
|
$u['j_cat_pref'] = 0;
|
||
|
|
$u['j_mentored'] = 0;
|
||
|
|
$highest = 0;
|
||
|
|
if($old_u['cat_prefs'] != '') {
|
||
|
|
$old_u_cat_prefs = unserialize($old_u['cat_prefs']);
|
||
|
|
foreach($old_u_cat_prefs as $cat_pref=>$rank) {
|
||
|
|
if($rank >= $highest) {
|
||
|
|
$highest = $rank;
|
||
|
|
$u['j_cat_pref'] = $cat_pref;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
user_save($mysqli, $u);
|
||
|
|
$c++;
|
||
|
|
}
|
||
|
|
print(" Converted $c judges.\n");
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|