</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'], ''); ?>
$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>';