<?php $inIndex = true; require_once "../lib/setup/databaseInfo.php"; require_once "../lib/database.php"; date_default_timezone_set('UTC'); $objDatabase = new Database(); print "Database update will update the observerobjectlist: remove 'Public' in front of all the public lists and add a new column 'public'<br />\n"; $sql = "ALTER TABLE observerobjectlist ADD COLUMN public SMALLINT NOT NULL DEFAULT 0;"; $objDatabase->execSQL($sql); // Iterate over all the list entries, set the new public column and remove 'Public' from the name. $sql = "SELECT * from observerobjectlist;"; $listEntries = $objDatabase->selectRecordsetArray($sql); $publicList = array(); foreach ($listEntries as $listEntry) { if (strpos($listEntry['listname'], "Public: ") !== false) { // The list is a public list. // We add the name of the list to the publicList array. if (!in_array($listEntry['listname'], $publicList)) { array_push($publicList, $listEntry['listname']); } } } foreach ($publicList as $listName) { // Set the public column to true. $sql = "UPDATE observerobjectlist SET public = \"1\" WHERE listname = \"" . $listName . "\";"; $objDatabase->execSQL($sql); // Change the name of the list. $sql = "UPDATE observerobjectlist SET listname = \"" . substr($listName, 8) . "\" WHERE listname = \"" . $listName . "\";"; $objDatabase->execSQL($sql); }
<?php $inIndex = true; require_once "../lib/setup/databaseInfo.php"; require_once "../lib/database.php"; $objDatabase = new Database(); print "Database update will add the highest altitudes possibilities to the report layouts of the users.\n\n"; $sql = "SELECT DISTINCT observerid, reportname, reportlayout FROM reportlayouts"; $results = $objDatabase->selectRecordsetArray($sql); while (list($key, $value) = each($results)) { echo "Writing data for " . $value['observerid'] . ' ' . $value['reportname'] . ' ' . $value['reportlayout'] . "...\n\n"; $sql = "INSERT INTO reportlayouts(observerid,reportname,reportlayout,fieldname,fieldline,fieldposition,fieldwidth,fieldheight,fieldstyle,fieldbefore,fieldafter,fieldlegend)\r\n VALUES('" . $value['observerid'] . "','" . $value['reportname'] . "','" . $value['reportlayout'] . "','objectmaxaltstarttext',3,20,50,'','','','','');"; $objDatabase->execSQL($sql); $sql = "INSERT INTO reportlayouts(observerid,reportname,reportlayout,fieldname,fieldline,fieldposition,fieldwidth,fieldheight,fieldstyle,fieldbefore,fieldafter,fieldlegend)\r\n VALUES('" . $value['observerid'] . "','" . $value['reportname'] . "','" . $value['reportlayout'] . "','objectmaxaltmidtext',3,70,50,'','','','','');"; $objDatabase->execSQL($sql); $sql = "INSERT INTO reportlayouts(observerid,reportname,reportlayout,fieldname,fieldline,fieldposition,fieldwidth,fieldheight,fieldstyle,fieldbefore,fieldafter,fieldlegend)\r\n VALUES('" . $value['observerid'] . "','" . $value['reportname'] . "','" . $value['reportlayout'] . "','objectmaxaltendtext',3,120,50,'','','','','');"; $objDatabase->execSQL($sql); $sql = "INSERT INTO reportlayouts(observerid,reportname,reportlayout,fieldname,fieldline,fieldposition,fieldwidth,fieldheight,fieldstyle,fieldbefore,fieldafter,fieldlegend)\r\n VALUES('" . $value['observerid'] . "','" . $value['reportname'] . "','" . $value['reportlayout'] . "','objectmaxalt',3,170,50,'','','','','');"; $objDatabase->execSQL($sql); } print "Database update successful.\n";
<?php $inIndex = true; require_once "../lib/setup/databaseInfo.php"; require_once "../lib/database.php"; require_once "../lib/atlasses.php"; require_once "../lib/objects.php"; require_once "../lib/setup/language/nl/lang_main.php"; $objDatabase = new Database(); $objAtlas = new Atlasses(); print "Database update will add the interstellarum atlas as one of the standard atlasses.\n"; $sql = "INSERT INTO atlasses VALUES ('Interstellarum');"; $run = mysql_query($sql) or die(mysql_error()); $sql = "ALTER TABLE objects ADD COLUMN Interstellarum VARCHAR(4) NOT NULL DEFAULT 0 ;"; $run = mysql_query($sql) or die(mysql_error()); $result = $objDatabase->selectRecordsetArray("SELECT name, ra, decl FROM objects"); while (list($key, $value) = each($result)) { $objDatabase->execSQL("UPDATE objects SET Interstellarum = \"" . $objAtlas->calculateAtlasPage('Interstellarum', $value['ra'], $value['decl']) . "\" WHERE name = \"" . $value['name'] . "\""); } print "Database update successful.\n"; ?>
<?php $inIndex = true; require_once "../lib/setup/databaseInfo.php"; require_once "../lib/database.php"; require_once "../lib/locations.php"; date_default_timezone_set('UTC'); $objDatabase = new Database(); $objLocation = new Locations(); print "Database update will correct all the bad locations.<br />\n"; $locationsToCheck = $objDatabase->selectRecordsetArray("SELECT id FROM locations where checked=\"1\"", 'id'); print sizeof($locationsToCheck); print "<br />"; if (sizeof($locationsToCheck) > 0) { foreach ($locationsToCheck as $location) { print $location['id'] . "<br />"; // We adapt the timezone, elevation and country $latitude = $objLocation->getLocationPropertyFromId($location['id'], "latitude"); $longitude = $objLocation->getLocationPropertyFromId($location['id'], "longitude"); $url = "https://maps.googleapis.com/maps/api/timezone/json?location=" . $latitude . "," . $longitude . "×tamp=0"; $json = file_get_contents($url); $obj = json_decode($json); if ($obj->status == "OK") { $objLocation->setLocationProperty($location['id'], "timezone", $obj->timeZoneId); // Get the elevation $url = "https://maps.googleapis.com/maps/api/elevation/json?locations=" . $latitude . "," . $longitude; $json = file_get_contents($url); $obj = json_decode($json); if ($obj->status == "OK") { $results = $obj->results[0]; $objLocation->setLocationProperty($location['id'], "elevation", (int) $results->elevation);