$db->Execute("ALTER TABLE install_users ADD " . $userProfile[$i]['name'] . " varchar(255) " . $mandatory . " DEFAULT '" . $default . "'");
} else {
$db->Execute("ALTER TABLE users ADD " . $userProfile[$i]['name'] . " varchar(255) " . $mandatory . " DEFAULT '" . $default . "'");
}
} catch (Exception $e) {
$failed_updates[] = $e->msg;
}
}
unset($tables['userpage']);
//deprecated table
$upgradedTables = array();
foreach ($tables as $table) {
if ($values['old_db_name'] == $values['db_name']) {
if (!in_array($table, $existingTables)) {
//Installation :: updateDBTable($table, "install_".$table);
if (Installation::quickUpgrade($table)) {
$upgradedTables[] = $table;
}
}
} else {
$oldDB = array('db_host' => $values['db_host'], 'db_user' => $values['db_user'], 'db_password' => $values['db_password'], 'db_name' => $values['old_db_name']);
$newDB = array('db_host' => $values['db_host'], 'db_user' => $values['db_user'], 'db_password' => $values['db_password'], 'db_name' => $values['db_name']);
Installation::updateDBTable($table, $table, $oldDB, $newDB);
}
}
//In any case, Restore connection to the normal database
$GLOBALS['db']->NConnect($values['db_host'], $values['db_user'], $values['db_password'], $values['db_name']);
$GLOBALS['db']->Execute("SET NAMES 'UTF8'");
//The upgrade completed successfully, so delete old tables and rename temporary install_ tables to its original names
if ($values['old_db_name'] == $values['db_name']) {
foreach ($upgradedTables as $table) {
