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)){