INNER JOIN devices_types
USING (device_type_id)';
if (!empty($observation_id)) {
$query .= ' WHERE observation_id=' . $observation_id;
} else {
if (!empty($start_time) && !empty($end_time)) {
$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);
$table_id = mysqli_query($dbc, $query);
if(mysqli_num_rows($table_id) == 1){
$row = mysqli_fetch_array($table_id);
$subtitle = $row['constellation_name'];
}
break;
case 'astronomical object':
$object_id = mysqli_real_escape_string($dbc, trim($_GET['object_id']));
$query = 'SELECT astronomical_objects.object_name FROM astronomical_objects WHERE astronomical_objects.object_id=' . $object_id;
$table_id = mysqli_query($dbc, $query);
$row = mysqli_fetch_array($table_id);
$subtitle = return_astronomical_object_name($dbc, $object_id, $row['object_name']);
break;
}
$query = 'SELECT page_id, title, page, meta_description, meta_keywords FROM pages WHERE title="' . $page . '"';
$table_id = mysqli_query($dbc, $query);
if(mysqli_num_rows($table_id) == 1){
$row = mysqli_fetch_array($table_id);
$page_id = $row['page_id'];
if(strtolower($row['title']) != 'home'){
$page_title = $row['title'];
if(!empty($subtitle)){
