private static function update_from_6()
{
$Connection = new Connection();
if (!Connection::indexExists('spotter_output', 'flightaware_id')) {
$query = "ALTER TABLE spotter_output ADD INDEX(flightaware_id);\n\t\t\tALTER TABLE spotter_output ADD INDEX(date);\n\t\t\tALTER TABLE spotter_output ADD INDEX(ident);\n\t\t\tALTER TABLE spotter_live ADD INDEX(flightaware_id);\n\t\t\tALTER TABLE spotter_live ADD INDEX(ident);\n\t\t\tALTER TABLE spotter_live ADD INDEX(date);\n\t\t\tALTER TABLE spotter_live ADD INDEX(longitude);\n\t\t\tALTER TABLE spotter_live ADD INDEX(latitude);\n\t\t\tALTER TABLE routes ADD INDEX(CallSign);\n\t\t\tALTER TABLE aircraft_modes ADD INDEX(ModeS);\n\t\t\tALTER TABLE aircraft ADD INDEX(icao);\n\t\t\tALTER TABLE airport ADD INDEX(icao);\n\t\t\tALTER TABLE translation ADD INDEX(Operator);";
try {
$sth = Connection::$db->prepare($query);
$sth->execute();
} catch (PDOException $e) {
return "error (add some indexes) : " . $e->getMessage() . "\n";
}
}
$error = '';
// Update table countries
if (Connection::tableExists('airspace')) {
$error .= update_db::update_countries();
if ($error != '') {
return $error;
}
}
// Update schema_version to 7
$query = "UPDATE `config` SET `value` = '7' WHERE `name` = 'schema_version'";
try {
$sth = Connection::$db->prepare($query);
$sth->execute();
} catch (PDOException $e) {
return "error (update schema_version) : " . $e->getMessage() . "\n";
}
return $error;
}
// ob_end_clean();
// header("Location: index.php?".rand());
print "<script>window.location = 'index.php?" . rand() . "&next=" . $_SESSION['install'] . "';</script>";
// require('../footer.php');
} else {
if (isset($_SESSION['install']) && $_SESSION['install'] == 'countries') {
unset($_SESSION['install']);
print '<div class="info column"><ul>';
foreach ($_SESSION['done'] as $done) {
print '<li>' . $done . '....<strong>SUCCESS</strong></li>';
}
print '<li>Populate countries database....<img src="../images/loading.gif" /></li></ul></div>';
flush();
@ob_flush();
include_once 'class.update_db.php';
update_db::update_countries();
$_SESSION['done'] = array_merge($_SESSION['done'], array('Populate countries database'));
if (isset($globalNOTAM) && $globalNOTAM && isset($globalNOTAMSource) && $globalNOTAMSource != '') {
$_SESSION['install'] = 'notam';
} else {
$_SESSION['install'] = 'sources';
}
// require('../footer.php');
// ob_end_clean();
// header("Location: index.php?".rand());
print "<script>window.location = 'index.php?" . rand() . "&next=" . $_SESSION['install'] . "';</script>";
// require('../footer.php');
} else {
if (isset($_SESSION['install']) && $_SESSION['install'] == 'populate') {
unset($_SESSION['install']);
if (!is_writable('tmp')) {
