Example #1
0
</td>
	</tr>
	<?php 
}
?>
	<tr>
		<td>Date & time</td>
		<td><?php 
echo return_date($row['observation_datetime'], null, 'line');
?>
</td>
	</tr>
	<tr>
		<td>Magnification</td>
		<td><?php 
echo return_magnification($dbc, $observation_id, 'observation', strtolower($row['device_type_name']));
?>
</td>
	</tr>
	<tr>
		<td>Level</td>
		<td><?php 
echo return_level_data($row['level_id'], $row['level_description'], null);
?>
</td>
	</tr>
	<tr>
		<td>Type</td>
		<td><?php 
echo return_object_type_data($row['object_type_name'], $row['object_type_url_wikipedia'], $row['object_type_thumb_url'], '');
?>
Example #2
0
        $query .= ' WHERE observation_datetime >= "' . $start_time . '" AND observation_datetime <= "' . $end_time . '"';
    }
}
$query .= ' ORDER BY observation_datetime ASC';
$table_id = mysqli_query($dbc, $query);
$xml = "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>" . "\n";
$xml .= "<locations>" . "\n";
while ($row = mysqli_fetch_array($table_id)) {
    $xml .= '<location latitude="' . $row['latitude'] . '" longitude="' . $row['longitude'] . '" accuracy="' . $row['accuracy'] . '" datetime="' . $row['observation_datetime'] . '">' . "\n";
    $astronomical_object_name = return_astronomical_object_name($dbc, $row['object_id'], $row['object_name']);
    $xml .= '<object object_id="' . $row['object_id'] . '" object_name="' . $astronomical_object_name . '"';
    if (!empty($row['object_thumb_url'])) {
        $xml .= ' object_thumb_url="' . SITE_IMAGES_DIR_FRONT . SITE_THUMB_DIR . $row['object_thumb_url'] . '"';
    }
    $xml .= ' object_type_name="' . ucfirst($row['object_type_name']) . '" object_type_thumb_url="' . $row['object_type_thumb_url'] . '" object_type_thumb_maps_url="' . $row['object_type_thumb_maps_url'] . '"></object>' . "\n";
    $xml .= '<user first_name="' . $row['user_first_name'] . '" last_name="' . $row['user_surname'] . '" avatar_url="' . $row['user_avatar_maps_url'] . '" magnification="' . return_magnification($dbc, $row['observation_id'], 'observation', strtolower($row['device_type_name'])) . '"></user>' . "\n";
    $xml .= '<device device_name="' . $row['device_name'] . '" thumb_url="' . $row['device_thumb_url'] . '"  thumb_maps_url="' . $row['device_thumb_maps_url'] . '" thumb_type_maps_url="' . $row['device_type_thumb_maps_url'] . '"></device>' . "\n";
    $xml .= '<notes>';
    if (!empty($row['notes'])) {
        $text = preg_replace("/\r\n/", "\n", $row['notes']);
        $text_array = explode("\n\n", $text);
        foreach ($text_array as $paragraph) {
            $xml .= '<p>';
            $paragraph = str_replace("\n", '<br />', $paragraph);
            $xml .= trim($paragraph);
            $xml .= '</p>' . "\n";
        }
    }
    $xml .= '</notes>' . "\n";
    $xml .= '</location>' . "\n";
}
    }
    $query_o = 'SELECT object_id FROM observations WHERE MONTH(observation_datetime) = MONTH(NOW()) AND object_id = ' . $object_id;
    $table_id_o = mysqli_query($dbc, $query_o);
    echo '<tr>' . "\n" . '<td>Marked</td>' . "\n" . '<td';
    if (mysqli_num_rows($table_id_o) > 0) {
        echo ' class="now_visible"';
    }
    echo '>';
    echo return_user_marked_data($object_id, $marked_objects);
    echo '</td>' . "\n" . '</tr>' . "\n";
}
?>
	<tr>
		<td>Magnification</td>
		<td><?php 
echo return_magnification($dbc, $object_id, 'average', 'telescope') . ' <sup>(average, telescope)</sup>';
?>
</td>
	</tr>
</table>

<h2>Observations</h2>

<?php 
require_once 'php_scripts/function_observation_list.php';
require_once 'php_scripts/tabular_data_functions.php';
$observations_objects = return_observation_list($dbc, '', $object_id, 'astronomical_object');
if ($observations_objects != false) {
    echo $observations_objects;
} else {
    echo '<p>No observations for this astronomical object</p>';