<?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";
