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')) {