Esempi in PHP per Atlasses::calculateAtlasPage

Esempio n. 1

File: updatev4.2-v4.3d.php Progetto: rolfvandervleuten/DeepskyLog

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

Esempio n. 2

File: updatev3.2-v3.3.php Progetto: rolfvandervleuten/DeepskyLog

$run = mysql_query($sql) or die(mysql_error());
// Only for open clusters : partlyUnresolved
$sql = "ALTER TABLE observations ADD COLUMN partlyUnresolved int(1) NOT NULL default '-1'";
$run = mysql_query($sql) or die(mysql_error());
// Only for open clusters : colorContrasts
$sql = "ALTER TABLE observations ADD COLUMN colorContrasts int(1) NOT NULL default '-1'";
$run = mysql_query($sql) or die(mysql_error());
// SQM for the observations
$sql = "ALTER TABLE observations ADD COLUMN SQM float NOT NULL default '-1.0'";
$run = mysql_query($sql) or die(mysql_error());
$sql = "SELECT * FROM objects";
$run = mysql_query($sql) or die(mysql_error());
while ($get = mysql_fetch_object($run)) {
    $ra = $get->ra;
    $dec = $get->decl;
    $psa = trim($atlas->calculateAtlasPage('psa', $ra, $dec));
    $torresB = trim($atlas->calculateAtlasPage('torresB', $ra, $dec));
    $torresBC = trim($atlas->calculateAtlasPage('torresBC', $ra, $dec));
    $torresC = trim($atlas->calculateAtlasPage('torresC', $ra, $dec));
    $name = $get->name;
    $sql2 = "UPDATE objects SET psa = \"{$psa}\" WHERE name = \"{$name}\"";
    $run2 = mysql_query($sql2) or die(mysql_error());
    $sql2 = "UPDATE objects SET torresB = \"{$torresB}\" WHERE name = \"{$name}\"";
    $run2 = mysql_query($sql2) or die(mysql_error());
    $sql2 = "UPDATE objects SET torresBC = \"{$torresBC}\" WHERE name = \"{$name}\"";
    $run2 = mysql_query($sql2) or die(mysql_error());
    $sql2 = "UPDATE objects SET torresC = \"{$torresC}\" WHERE name = \"{$name}\"";
    $run2 = mysql_query($sql2) or die(mysql_error());
}
$sql = "ALTER TABLE objects ADD COLUMN milleniumbase VARCHAR(4) NOT NULL AFTER torresC";
$run = mysql_query($sql) or die(mysql_error());

Esempio n. 3

File: updatev4.2-v4.3c.php Progetto: rolfvandervleuten/DeepskyLog

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