forked from science-ation/science-ation
b3ce18ca0c
Allow logging in if the user isnt in the conference (just go to the user_account page for now, i guess eventually it'll need to go to a "register for the conference" page Some fixes and updates to the menu/navigation, still not perfect, btu getting there
47 lines
1.1 KiB
PHP
Executable File
47 lines
1.1 KiB
PHP
Executable File
<?php
|
|
function db_update_204_pre()
|
|
{
|
|
}
|
|
|
|
function db_update_204_post()
|
|
{
|
|
$tables = array(
|
|
'judges_schedulerconfig',
|
|
'judges_teams',
|
|
'judges_teams_awards_link',
|
|
'judges_teams_link',
|
|
'judges_teams_timeslots_link',
|
|
'judges_teams_timeslots_projects_link',
|
|
'judges_timeslots'
|
|
);
|
|
|
|
// get the year => conference_id links
|
|
$q1 = mysql_query("SELECT year, id FROM conferences WHERE year>0");
|
|
while($r = mysql_fetch_assoc($q1)){
|
|
|
|
foreach($tables as $tableName){
|
|
$query = "UPDATE `$tableName` SET `conferences_id` = {$r['id']} WHERE `year` = {$r['year']}";
|
|
mysql_query($query);
|
|
echo $query . ";\n";
|
|
}
|
|
}
|
|
|
|
// a couple more
|
|
foreach($tables as $tableName){
|
|
$query = "UPDATE `$tableName` SET `conferences_id` = -1 WHERE `year` = -1";
|
|
mysql_query($query);
|
|
echo $query . ";\n";
|
|
|
|
$query = mysql_query("SELECT DISTINCT(year) FROM `$tableName` WHERE `conferences_id` = 0");
|
|
$badYears = array();
|
|
while($data = mysql_fetch_assoc($query)){
|
|
$badYears[] = $data['year'];
|
|
}
|
|
if(count($badYears) > 0){
|
|
echo "ERROR: could not update conference_id in the table '$tableName' for the years ";
|
|
echo implode(', ', $badYears) . "\n";
|
|
}
|
|
}
|
|
}
|
|
?>
|