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;
}
#!/usr/bin/php
<?php
require_once '../require/settings.php';
if ($globalInstalled) {
echo '$globalInstalled must be set to FALSE in require/settings.php';
exit;
}
require 'class.update_db.php';
if (isset($globalIVAO) && $globalIVAO) {
if (!file_exists('tmp/ivae_feb2013.zip')) {
echo "You have to download the file ivae_feb2013.zip from https://www.ivao.aero/softdev/mirrors.asp?software=IvAeDataUp and put it in install/tmp directory";
} else {
echo "Install IVAO airlines and logos...";
update_db::update_IVAO();
echo "Done !\n";
}
}
#!/usr/bin/php
<?php
require_once '../require/settings.php';
if ($globalInstalled) {
echo '$globalInstalled must be set to FALSE in require/settings.php';
exit;
}
require 'class.create_db.php';
echo "Create and import all tables...";
create_db::import_all_db('../db/');
echo "Done !\n";
require 'class.update_db.php';
echo "Populate all tables...\n";
update_db::update_all();
echo "\nInstall waypoints...(VERY slow!)";
update_db::update_waypoints();
echo "Done !\n";
echo "Install airspace...";
update_db::update_airspace();
echo "Done !\n";
echo 'All is now installed ! Thanks' . "\n";
if ($globalSBS1) {
echo 'You need to run cron-sbs.php as a daemon. You can use init script in the install/init directory.' . "\n";
}
if ($globalACARS) {
echo 'You need to run cron-acars.php as a daemon. You can use init script in the install/init directory.' . "\n";
}
unset($_SESSION['install']);
if (!is_writable('tmp')) {
print '<p><strong>The directory <i>install/tmp</i> must be writable.</strong></p>';
require '../footer.php';
exit;
}
print '<div class="info column"><ul>';
foreach ($_SESSION['done'] as $done) {
print '<li>' . $done . '....<strong>SUCCESS</strong></li>';
}
print '<li>Populate notam table with externals data....<img src="../images/loading.gif" /></li></ul></div>';
flush();
@ob_flush();
include_once 'class.update_db.php';
$globalDebug = FALSE;
update_db::update_notam();
$_SESSION['done'] = array_merge($_SESSION['done'], array('Populate notam table with externals data'));
$_SESSION['install'] = 'sources';
print "<script>window.location = 'index.php?" . rand() . "&next=" . $_SESSION['install'] . "';</script>";
/*
} else if (isset($_SESSION['install']) && $_SESSION['install'] == 'ivao') {
unset($_SESSION['install']);
if (!is_writable('tmp')) {
print '<p><strong>The directory <i>install/tmp</i> must be writable.</strong></p>';
require('../footer.php');
exit;
}
print '<div class="info column"><ul>';
foreach ($_SESSION['done'] as $done) {
print '<li>'.$done.'....<strong>SUCCESS</strong></li>';
#!/usr/bin/php
<?php
/**
* This script is used to update databases with external data.
* Should be run as cronjob no more than every 2 weeks if NOTAM is not activated, once a day if NOTAM is activated and every hour if METAR is activated.
*/
require_once dirname(__FILE__) . '/../require/settings.php';
require dirname(__FILE__) . '/../install/class.update_db.php';
$update_db = new update_db();
if (isset($globalNOTAM) && $globalNOTAM && $update_db->check_last_notam_update()) {
echo "updating NOTAM...";
$update_db->update_notam();
$update_db->insert_last_notam_update();
} elseif (isset($globalDebug) && $globalDebug && isset($globalNOTAM) && $globalNOTAM) {
echo "NOTAM are only updated once a day.\n";
}
if ($update_db->check_last_update() && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM)) {
$update_db->update_all();
require_once '../require/class.Spotter.php';
$Spotter = new Spotter();
$Spotter->updateFieldsFromOtherTables();
$update_db->insert_last_update();
} elseif (isset($globalDebug) && $globalDebug && (!isset($globalIVAO) || !$globalIVAO) && (!isset($globalVATSIM) || !$globalVATSIM)) {
echo "DB are populated with external data only every 15 days ! Files are not updated more often.\n";
}
if (isset($globalMETAR) && isset($globalMETARcycle) && $globalMETAR && $globalMETARcycle) {
echo "updating METAR...";
require_once '../require/class.METAR.php';
$METAR = new METAR();
$METAR->addMETARCycle();
}
public static function update_all()
{
update_db::update_routes();
update_db::update_ModeS();
update_db::update_translation();
}
if (file_exists('tmp/ivae_feb2013.zip')) {
update_db::update_IVAO();
$_SESSION['done'] = array_merge($_SESSION['done'], array('Insert IVAO data'));
} else {
update_db::update_vatsim();
$_SESSION['done'] = array_merge($_SESSION['done'], array('Insert VATSIM data'));
}
} elseif (isset($globalVATSIM) && $globalVATSIM) {
update_db::update_vatsim();
$_SESSION['done'] = array_merge($_SESSION['done'], array('Insert VATSIM data'));
} elseif (isset($globalIVAO) && $globalIVAO) {
if (file_exists('tmp/ivae_feb2013.zip')) {
update_db::update_IVAO();
$_SESSION['done'] = array_merge($_SESSION['done'], array('Insert IVAO data'));
} else {
update_db::update_vatsim();
$_SESSION['done'] = array_merge($_SESSION['done'], array('Insert VATSIM data (IVAO not found)'));
}
}
$_SESSION['install'] = 'routes';
$_SESSION['next'] = 'Populate routes table with externals data';
$result = array('error' => $error, 'done' => $_SESSION['done'], 'next' => $_SESSION['next'], 'install' => $_SESSION['install']);
print json_encode($result);
} else {
//unset($_SESSION['install']);
$_SESSION['error'] = 'Unknwon task : ' . $_SESSION['install'];
$result = array('error' => 'Unknwon task : ' . $_SESSION['install'], 'done' => $_SESSION['done'], 'next' => 'finish', 'install' => 'finish');
print json_encode($result);
}
}
}
<?php
require_once '../require/settings.php';
if ($globalInstalled) {
echo '$globalInstalled must be set to FALSE in require/settings.php';
exit;
}
require 'class.update_db.php';
echo "Populate all tables...\n";
update_db::update_all();
echo "\nInstall waypoints...(VERY slow!)";
update_db::update_waypoints();
echo "Done !\n";
echo "Install airspace...";
update_db::update_airspace();
echo "Done !\n";
echo "Install countries...";
update_db::update_countries();
echo "Done !\n";
/*
if (isset($globalIVAO) && $globalIVAO) {
echo "Install IVAO airlines and logos...";
update_db::update_IVAO();
echo "Done !\n";
}
*/
if (isset($globalNOTAM) && $globalNOTAM && isset($globalNOTAMSource) && $globalNOTAMSource != '') {
echo "Install NOTAM from notaminfo.com...";
update_db:
update_notam();
echo "Done !\n";
}
#!/usr/bin/php
<?php
/**
* This script is used to update databases with external data.
* Should be run as cronjob no more than every 2 weeks if NOTAM is not activated, else once a day.
*/
require_once dirname(__FILE__) . '/../require/settings.php';
require dirname(__FILE__) . '/../install/class.update_db.php';
if (isset($globalNOTAM) && $globalNOTAM && update_db::check_last_notam_update()) {
echo "update NOTAM";
update_db::update_notam();
update_db::insert_last_notam_update();
} elseif (isset($globalDebug) && $globalDebug && isset($globalNOTAM) && $globalNOTAM) {
echo "NOTAM are only updated once a day.\n";
}
if (update_db::check_last_update() && (!isset($globalIVAO) || !$globalIVAO)) {
update_db::update_all();
# require_once('../require/class.Spotter.php');
# Spotter::updateFieldsFromOtherTables();
update_db::insert_last_update();
} elseif (isset($globalDebug) && $globalDebug && (!isset($globalIVAO) || !$globalIVAO)) {
echo "DB are populated with external data only every 15 days ! Files are not updated more often.\n";
}
#!/usr/bin/php
<?php
/**
* This script is used to update databases with external data.
* Should be run as cronjob no more than every 2 weeks if NOTAM is not activated, else once a day.
*/
require_once dirname(__FILE__) . '/../require/settings.php';
require dirname(__FILE__) . '/../install/class.update_db.php';
$update_db = new update_db();
if (isset($globalNOTAM) && $globalNOTAM && $update_db->check_last_notam_update()) {
echo "update NOTAM";
$update_db->update_notam();
$update_db->insert_last_notam_update();
} elseif (isset($globalDebug) && $globalDebug && isset($globalNOTAM) && $globalNOTAM) {
echo "NOTAM are only updated once a day.\n";
}
if ($update_db->check_last_update() && (!isset($globalIVAO) || !$globalIVAO)) {
$update_db->update_all();
# require_once('../require/class.Spotter.php');
# $Spotter = new Spotter();
# $Spotter::updateFieldsFromOtherTables();
$update_db->insert_last_update();
} elseif (isset($globalDebug) && $globalDebug && (!isset($globalIVAO) || !$globalIVAO)) {
echo "DB are populated with external data only every 15 days ! Files are not updated more often.\n";
}
}
require 'class.update_db.php';
echo "Populate all tables...\n";
update_db::update_all();
echo "\nInstall waypoints...(VERY slow!)";
update_db::update_waypoints();
echo "Done !\n";
echo "Install airspace...";
update_db::update_airspace();
echo "Done !\n";
echo "Install countries...";
update_db::update_countries();
echo "Done !\n";
if (isset($globalOwner) && $globalOwner) {
echo "Install private owners...";
update_db::update_owner();
echo "Done !\n";
}
/*
if (isset($globalIVAO) && $globalIVAO) {
echo "Install IVAO airlines and logos...";
update_db::update_IVAO();
echo "Done !\n";
}
*/
if (isset($globalNOTAM) && $globalNOTAM && isset($globalNOTAMSource) && $globalNOTAMSource != '') {
echo "Install NOTAM from notaminfo.com...";
update_db:
update_notam();
echo "Done !\n";
}
