<?php $inIndex = true; require_once "../lib/setup/databaseInfo.php"; require_once "../lib/database.php"; require_once "../lib/observers.php"; date_default_timezone_set('UTC'); $objDatabase = new Database(); $objObserver = new Observers(); print "Database update add a sendMail field to observers.\n"; $sql = "ALTER TABLE observers ADD sendMail BOOL default '0'"; $run = $objDatabase->execSQL($sql); print "Database update successful.\n";
<?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"; 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"; date_default_timezone_set('UTC'); $objDatabase = new Database(); print "Database update will update the locations table: remove region and add elevation and checked.\n"; $sql = "ALTER TABLE locations DROP COLUMN region;"; $objDatabase->execSQL($sql); $sql = "ALTER TABLE locations ADD COLUMN elevation SMALLINT NOT NULL DEFAULT 0;"; $objDatabase->execSQL($sql); $sql = "ALTER TABLE locations ADD COLUMN checked BOOL NOT NULL DEFAULT '0';"; $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 deepskylog atlasses page numbers for the DSL objects.\n"; $result = $objDatabase->selectRecordsetArray("SELECT name, ra, decl FROM objects"); while (list($key, $value) = each($result)) { $objDatabase->execSQL("UPDATE objects SET DSLDL = \"" . $objAtlas->calculateAtlasPage('DSLDL', $value['ra'], $value['decl']) . "\" WHERE name = \"" . $value['name'] . "\""); $objDatabase->execSQL("UPDATE objects SET DSLDP = \"" . $objAtlas->calculateAtlasPage('DSLDP', $value['ra'], $value['decl']) . "\" WHERE name = \"" . $value['name'] . "\""); $objDatabase->execSQL("UPDATE objects SET DSLLL = \"" . $objAtlas->calculateAtlasPage('DSLLL', $value['ra'], $value['decl']) . "\" WHERE name = \"" . $value['name'] . "\""); $objDatabase->execSQL("UPDATE objects SET DSLLP = \"" . $objAtlas->calculateAtlasPage('DSLLP', $value['ra'], $value['decl']) . "\" WHERE name = \"" . $value['name'] . "\""); $objDatabase->execSQL("UPDATE objects SET DSLOL = \"" . $objAtlas->calculateAtlasPage('DSLOL', $value['ra'], $value['decl']) . "\" WHERE name = \"" . $value['name'] . "\""); $objDatabase->execSQL("UPDATE objects SET DSLOP = \"" . $objAtlas->calculateAtlasPage('DSLOP', $value['ra'], $value['decl']) . "\" WHERE name = \"" . $value['name'] . "\""); $objDatabase->execSQL("UPDATE objects SET DeepskyHunter = \"" . $objAtlas->calculateAtlasPage('DeepskyHunter', $value['ra'], $value['decl']) . "\" WHERE name = \"" . $value['name'] . "\""); } print "Database update successful.\n";