function return_observation_list($dbc, $max_observations, $id, $select_type)
{
$return_data;
$return_data .= '<table>
<tr>' . "\n" . '
<th>Date</th>' . "\n" . '
<th>Observed By</th>' . "\n" . '
<th>Level</th>' . "\n" . '
<th>Messier</th>' . "\n" . '
<th>NGC</th>' . "\n" . '
<th>Name</th>' . "\n";
if ($select_type != 'astronomical_object') {
$return_data .= '<th>Type</th>' . "\n";
}
$return_data .= '<th>Device used</th>' . "\n";
if (isset($_SESSION['user_id'])) {
$return_data .= '<th>Loc</th>' . "\n";
}
$return_data .= '<!--<th>Links</th>-->' . "\n" . '
</tr>' . "\n";
$query = 'SELECT observations.observation_id, observations.observation_datetime, observations.level_id, observations.latitude, observations.longitude, observations.notes, astronomical_objects.object_id, astronomical_objects.object_name, astronomical_objects.object_thumb_url, astronomical_objects.object_url_wikipedia, astronomical_objects_types.object_type_name, astronomical_objects_types.object_type_thumb_url, astronomical_objects_types.object_type_url_wikipedia, users.user_id, users.user_first_name, users.user_surname, users.user_avatar_url, observations_levels.level_description, devices.device_id, devices.device_name, devices.device_thumb_url
FROM observations
INNER JOIN users
USING (user_id)
INNER JOIN astronomical_objects
USING (object_id)
INNER JOIN observations_levels
USING (level_id)
INNER JOIN devices
USING (device_id)
INNER JOIN astronomical_objects_types
USING (object_type_id)';
if ($select_type == 'user' && is_int(intval($id)) && $id > 0) {
$query .= ' WHERE user_id=' . $id;
} else {
if ($select_type == 'device' && is_int(intval($id)) && $id > 0) {
$query .= ' WHERE device_id=' . $id;
} else {
if ($select_type == 'eyepiece_device' && is_int(intval($id)) && $id > 0) {
$query .= ' WHERE eyepiece_device_id=' . $id;
} else {
if ($select_type == 'filter_device' && is_int(intval($id)) && $id > 0) {
$query .= ' WHERE filter_device_id=' . $id;
} else {
if ($select_type == 'astronomical_object' && is_int(intval($id)) && $id > 0) {
$query .= ' WHERE object_id=' . $id;
}
}
}
}
}
$query .= ' ORDER BY observations.observation_datetime DESC';
if (is_int($max_observations)) {
$query .= ' LIMIT 0,' . $max_observations;
}
$table_id = mysqli_query($dbc, $query);
if (mysqli_num_rows($table_id) == 0) {
$return_data .= '<tr><td></td><td>No observations yet</td><td></td><td></td><td></td><td></td>';
if ($select_type != 'astronomical_object' && !is_int(intval($id)) && $id <= 0) {
$return_data .= '<td></td>';
}
if (isset($_SESSION['user_id'])) {
$return_data .= '<td></td>';
}
$return_data .= '<td></td><td></td></tr>';
}
while ($row = mysqli_fetch_array($table_id)) {
$return_data .= '<tr>' . "\n";
$return_data .= '<td>';
$return_data .= return_date($row['observation_datetime'], $row['observation_id'], null);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_user_observation_data($row['user_id'], $row['user_first_name'], $row['user_avatar_url'], 'default');
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_level_data($row['level_id'], $row['level_description'], $row['notes']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$query = 'SELECT list_object_number FROM astronomical_objects_lists_objects WHERE list_id=1 AND object_id=' . $row['object_id'];
$table_id_messier = mysqli_query($dbc, $query);
$row_messier = mysqli_fetch_array($table_id_messier);
$return_data .= return_messier_number($row_messier['list_object_number']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$query = 'SELECT list_object_number FROM astronomical_objects_lists_objects WHERE list_id=3 AND object_id=' . $row['object_id'];
$table_id_ngc = mysqli_query($dbc, $query);
$row_ngc = mysqli_fetch_array($table_id_ngc);
$return_data .= return_ngc_number($row_ngc['list_object_number']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_name_data($row['object_id'], $row['object_name'], $row['object_url_wikipedia'], $row['object_thumb_url']);
$return_data .= '</td>' . "\n";
if ($select_type != 'astronomical_object') {
$return_data .= '<td>';
$return_data .= return_object_type_data($row['object_type_name'], $row['object_type_url_wikipedia'], $row['object_type_thumb_url'], '');
$return_data .= '</td>' . "\n";
}
$return_data .= '<td>';
$return_data .= return_device_data($row['device_id'], $row['device_name'], $row['device_thumb_url'], false);
$return_data .= '</td>' . "\n";
if (isset($_SESSION['user_id'])) {
$return_data .= '<td>';
$return_data .= return_location_icon($row['latitude'], $row['longitude']);
$return_data .= '</td>' . "\n";
}
//echo '<td><a href="' . $row['object_url_wikipedia'] . '"><img src="images/link_wiki.png" /></a></td>' . "\n";
$return_data .= '</tr>' . "\n";
}
$return_data .= '</table>' . "\n";
return $return_data;
}
function return_astronomical_objects_list($dbc, $sort_type, $sort_type_info)
{
$return_data;
if ($_GET['mark'] && isset($_SESSION['user_id'])) {
$query = 'INSERT INTO users_objects_marked (user_id, object_id) VALUES (' . $_SESSION['user_id'] . ', ' . mysqli_real_escape_string($dbc, trim($_GET['mark'])) . ')';
$result = mysqli_query($dbc, $query);
if ($result) {
echo '<p class="notification">The object has been succesfully <strong>marked</strong></p>' . "\n";
}
}
if ($_GET['unmark'] && isset($_SESSION['user_id'])) {
$query = 'DELETE FROM users_objects_marked WHERE user_id=' . $_SESSION['user_id'] . ' && marked_id=' . mysqli_real_escape_string($dbc, trim($_GET['unmark']));
$result = mysqli_query($dbc, $query);
if ($result) {
echo '<p class="notification">The object has been succesfully <strong>unmarked</strong></p>' . "\n";
}
}
if (!empty($_GET['sorting_column'])) {
$sorting_column = mysqli_real_escape_string($dbc, trim($_GET['sorting_column']));
} else {
$sorting_column = 'object_id';
}
if (!empty($_GET['sorting_order'])) {
$sorting_order = mysqli_real_escape_string($dbc, trim($_GET['sorting_order']));
} else {
$sorting_order = 'ASC';
}
$return_data .= '<table>' . "\n";
$return_data .= '<tr>' . "\n";
$return_data .= '<th>' . "\n";
$return_data .= '<a href="?p=' . trim($_GET['p']);
if (!empty($_GET['user_id'])) {
$return_data .= '&user_id=' . trim($_GET['user_id']);
} else {
if (!empty($_GET['constellation_id'])) {
$return_data .= '&constellation_id=' . trim($_GET['constellation_id']);
}
}
$return_data .= '&sorting_column=object_messier_number&';
if ($sorting_column == 'object_messier_number' && $sorting_order == 'ASC') {
$return_data .= 'sorting_order=DESC';
} else {
$return_data .= 'sorting_order=ASC';
}
$return_data .= '">Messier</a>' . "\n";
$return_data .= '</th>' . "\n";
$return_data .= '<th>' . "\n";
$return_data .= '<a href="?p=' . trim($_GET['p']);
if (!empty($_GET['user_id'])) {
$return_data .= '&user_id=' . trim($_GET['user_id']);
} else {
if (!empty($_GET['constellation_id'])) {
$return_data .= '&constellation_id=' . trim($_GET['constellation_id']);
}
}
$return_data .= '&sorting_column=object_ngc_number&';
if ($sorting_column == 'object_ngc_number' && $sorting_order == 'ASC') {
$return_data .= 'sorting_order=DESC';
} else {
$return_data .= 'sorting_order=ASC';
}
$return_data .= '">NGC</a>' . "\n";
$return_data .= '</th>' . "\n";
$return_data .= '<th>' . "\n";
$return_data .= '<a href="?p=' . trim($_GET['p']);
if (!empty($_GET['user_id'])) {
$return_data .= '&user_id=' . trim($_GET['user_id']);
} else {
if (!empty($_GET['constellation_id'])) {
$return_data .= '&constellation_id=' . trim($_GET['constellation_id']);
}
}
$return_data .= '&sorting_column=object_name&';
if ($sorting_column == 'object_name' && $sorting_order == 'ASC') {
$return_data .= 'sorting_order=DESC';
} else {
$return_data .= 'sorting_order=ASC';
}
$return_data .= '">Name</a>' . "\n";
$return_data .= '</th>' . "\n";
$return_data .= '<th>' . "\n";
$return_data .= '<a href="?p=' . trim($_GET['p']);
if (!empty($_GET['user_id'])) {
$return_data .= '&user_id=' . trim($_GET['user_id']);
} else {
if (!empty($_GET['constellation_id'])) {
$return_data .= '&constellation_id=' . trim($_GET['constellation_id']);
}
}
$return_data .= '&sorting_column=object_type_id&';
if ($sorting_column == 'object_type_id' && $sorting_order == 'ASC') {
$return_data .= 'sorting_order=DESC';
} else {
$return_data .= 'sorting_order=ASC';
}
$return_data .= '">Type</a>' . "\n";
$return_data .= '</th>' . "\n";
$return_data .= '<th>' . "\n";
$return_data .= '<a href="?p=' . trim($_GET['p']);
if (!empty($_GET['user_id'])) {
$return_data .= '&user_id=' . trim($_GET['user_id']);
} else {
if (!empty($_GET['constellation_id'])) {
$return_data .= '&constellation_id=' . trim($_GET['constellation_id']);
}
}
$return_data .= '&sorting_column=constellation_name&';
if ($sorting_column == 'constellation_name' && $sorting_order == 'ASC') {
$return_data .= 'sorting_order=DESC';
} else {
$return_data .= 'sorting_order=ASC';
}
$return_data .= '">Constellation</a>' . "\n";
$return_data .= '</th>' . "\n";
//$return_data .= '<th>Links</th>' . "\n";
$return_data .= '<th>Observations</th>' . "\n";
if (isset($_SESSION['user_id'])) {
$return_data .= '<th>Marked</th>' . "\n";
}
$return_data .= '</tr>' . "\n";
//if(login_check()){
// $return_data .= '<th>Starred user_id' . $_SESSION['user_id'] . '</th>';
//}
require_once 'php_scripts/function_observations_user_array.php';
$observations_array = observations_user_array($dbc);
switch ($sorting_column) {
case 'constellation_name':
$sorting_table = 'constellations';
break;
default:
$sorting_table = 'astronomical_objects';
break;
}
$query = 'SELECT astronomical_objects.object_id, astronomical_objects.object_messier_number, astronomical_objects.object_ngc_number, astronomical_objects.object_name, astronomical_objects.object_thumb_url, astronomical_objects.object_url_wikipedia, astronomical_objects_types.object_type_name, astronomical_objects_types.object_type_thumb_url, astronomical_objects_types.object_type_url_wikipedia, ';
//astronomical_objects_lists.list_name,
$query .= 'constellations.constellation_id, constellations.constellation_name, constellations.constellation_thumb_url, constellations.constellation_url_wikipedia
FROM astronomical_objects
INNER JOIN astronomical_objects_types
USING (object_type_id) ';
//LEFT JOIN astronomical_objects_lists_objects
//USING (object_id)
//LEFT JOIN astronomical_objects_lists
//USING (list_id)
$query .= 'INNER JOIN constellations
USING (constellation_id)';
switch ($sort_type) {
case 'marked':
$query .= ' INNER JOIN users_objects_marked
USING (object_id)
WHERE users_objects_marked.user_id =' . $sort_type_info;
break;
case 'constellation':
$query .= ' WHERE constellations.constellation_id=' . $sort_type_info;
break;
case 'picture':
$query .= ' INNER JOIN pictures_astronomical_objects
USING (object_id)
WHERE pictures_astronomical_objects.picture_id=' . $sort_type_info;
}
$query .= ' ORDER BY ' . $sorting_table . '.' . $sorting_column . ' ' . $sorting_order;
$table_id = mysqli_query($dbc, $query);
if (isset($_SESSION['user_id'])) {
$query_m = 'SELECT marked_id, object_id FROM users_objects_marked WHERE user_id=' . $_SESSION['user_id'];
$table_id_m = mysqli_query($dbc, $query_m);
$marked_objects = array();
while ($row_m = mysqli_fetch_array($table_id_m)) {
array_push($marked_objects, array($row_m['object_id'], $row_m['marked_id']));
}
//echo '<p class="notification">' . $query_m . ' - ' . mysqli_num_rows($table_id_m) . ' : ' . count($marked_objects) . '</p>';
}
while ($row = mysqli_fetch_array($table_id)) {
$return_data .= '<tr>' . "\n";
$return_data .= '<td>';
$return_data .= return_messier_number($row['object_messier_number']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_ngc_number($row['object_ngc_number']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_name_data($row['object_id'], $row['object_name'], $row['object_url_wikipedia'], $row['object_thumb_url']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_object_type_data($row['object_type_name'], $row['object_type_url_wikipedia'], $row['object_type_thumb_url'], '');
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_constellation_data($row['constellation_id'], $row['constellation_name'], $row['constellation_thumb_url'], $row['constellation_url_wikipedia']);
$return_data .= '</td>' . "\n";
//$return_data .= '<td>';
//if(!empty($row['object_url_wikipedia'])){
// $return_data .= '<a href="' . $row['object_url_wikipedia'] . '"><img src="images/link_wiki.png" alt="wikipedia_link" /></a>';
//}
//$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_user_object_observation_data($observations_array, $row['object_id']);
/*if(isset($observations_array) && !empty($observations_array[$row['object_id']])){
for($i = 0; $i<count($observations_array[$row['object_id']]);$i++){
echo '<div class="avatar" style="background-image: url(\'' . SITE_IMAGES_DIR_FRONT . SITE_AVATAR_DIR . $observations_array[$row['object_id']][$i][2] . '\');"><div class="observations">' . $observations_array[$row['object_id']][$i][1] . '</div></div>';
//echo 'user: '******'object_id']][$i][0] . ' views: ' . $observations_array[$row['object_id']][$i][1];
}
}*/
$return_data .= '</td>' . "\n";
if (isset($_SESSION['user_id'])) {
$query_o = 'SELECT object_id FROM observations WHERE MONTH(observation_datetime) = MONTH(NOW()) AND object_id = ' . $row['object_id'];
$table_id_o = mysqli_query($dbc, $query_o);
$return_data .= '<td';
if (mysqli_num_rows($table_id_o) > 0) {
$return_data .= ' class="now_visible"';
}
$return_data .= '>';
$return_data .= return_user_marked_data($row['object_id'], $marked_objects);
$return_data .= '</td>' . "\n";
}
$return_data .= '</tr>' . "\n";
}
$return_data .= '</table>';
if (mysqli_num_rows($table_id) == 0 && $sort_type == 'marked') {
return '<p>No objects marked</p>';
}
if (mysqli_num_rows($table_id) == 0) {
return false;
} else {
return $return_data;
}
}
function return_astronomical_objects_list($dbc, $sort_type, $sort_type_info)
{
$return_data;
if (!empty($_GET['sorting_column'])) {
$sorting_column = mysqli_real_escape_string($dbc, trim($_GET['sorting_column']));
} else {
$sorting_column = 'object_id';
}
if (!empty($_GET['sorting_order'])) {
$sorting_order = mysqli_real_escape_string($dbc, trim($_GET['sorting_order']));
} else {
$sorting_order = 'ASC';
}
$return_data .= '<table>' . "\n";
$return_data .= '<tr>' . "\n";
$return_data .= '<th>' . "\n";
$return_data .= '<a href="?p=' . trim($_GET['p']);
if (!empty($_GET['user_id'])) {
$return_data .= '&user_id=' . trim($_GET['user_id']);
} else {
if (!empty($_GET['constellation_id'])) {
$return_data .= '&constellation_id=' . trim($_GET['constellation_id']);
}
}
$return_data .= '&sorting_column=object_messier_number&';
if ($sorting_column == 'object_messier_number' && $sorting_order == 'ASC') {
$return_data .= 'sorting_order=DESC';
} else {
$return_data .= 'sorting_order=ASC';
}
$return_data .= '">Messier</a>' . "\n";
$return_data .= '</th>' . "\n";
$return_data .= '<th>' . "\n";
$return_data .= '<a href="?p=' . trim($_GET['p']);
if (!empty($_GET['user_id'])) {
$return_data .= '&user_id=' . trim($_GET['user_id']);
} else {
if (!empty($_GET['constellation_id'])) {
$return_data .= '&constellation_id=' . trim($_GET['constellation_id']);
}
}
$return_data .= '&sorting_column=object_ngc_number&';
if ($sorting_column == 'object_ngc_number' && $sorting_order == 'ASC') {
$return_data .= 'sorting_order=DESC';
} else {
$return_data .= 'sorting_order=ASC';
}
$return_data .= '">NGC</a>' . "\n";
$return_data .= '</th>' . "\n";
$return_data .= '<th>' . "\n";
$return_data .= '<a href="?p=' . trim($_GET['p']);
if (!empty($_GET['user_id'])) {
$return_data .= '&user_id=' . trim($_GET['user_id']);
} else {
if (!empty($_GET['constellation_id'])) {
$return_data .= '&constellation_id=' . trim($_GET['constellation_id']);
}
}
$return_data .= '&sorting_column=object_name&';
if ($sorting_column == 'object_name' && $sorting_order == 'ASC') {
$return_data .= 'sorting_order=DESC';
} else {
$return_data .= 'sorting_order=ASC';
}
$return_data .= '">Name</a>' . "\n";
$return_data .= '</th>' . "\n";
$return_data .= '<th>' . "\n";
$return_data .= '<a href="?p=' . trim($_GET['p']);
if (!empty($_GET['user_id'])) {
$return_data .= '&user_id=' . trim($_GET['user_id']);
} else {
if (!empty($_GET['constellation_id'])) {
$return_data .= '&constellation_id=' . trim($_GET['constellation_id']);
}
}
$return_data .= '&sorting_column=object_type_id&';
if ($sorting_column == 'object_type_id' && $sorting_order == 'ASC') {
$return_data .= 'sorting_order=DESC';
} else {
$return_data .= 'sorting_order=ASC';
}
$return_data .= '">Type</a>' . "\n";
$return_data .= '</th>' . "\n";
$return_data .= '<th>' . "\n";
$return_data .= '<a href="?p=' . trim($_GET['p']);
if (!empty($_GET['user_id'])) {
$return_data .= '&user_id=' . trim($_GET['user_id']);
} else {
if (!empty($_GET['constellation_id'])) {
$return_data .= '&constellation_id=' . trim($_GET['constellation_id']);
}
}
$return_data .= '&sorting_column=constellation_name&';
if ($sorting_column == 'constellation_name' && $sorting_order == 'ASC') {
$return_data .= 'sorting_order=DESC';
} else {
$return_data .= 'sorting_order=ASC';
}
$return_data .= '">Constellation</a>' . "\n";
$return_data .= '</th>' . "\n";
$return_data .= '<th>Links</th>' . "\n";
$return_data .= '<th>Observations</th>' . "\n";
$return_data .= '</tr>' . "\n";
//if(login_check()){
// $return_data .= '<th>Starred user_id' . $_SESSION['user_id'] . '</th>';
//}
$query_observations = 'SELECT observations.object_id, observations.level_id, observations.user_id, users.user_avatar_url
FROM observations
INNER JOIN users
USING (user_id)
ORDER BY object_id, user_id ASC';
$table_id_observations = mysqli_query($dbc, $query_observations);
$current_object_id = 0;
$prev_object_id = 0;
$current_user_id = 0;
$prev_user_id = 0;
$prev_level_id = 0;
$current_max_level_id = 0;
$current_observation_count = 0;
$observations_user_array = array();
$observations_array = array();
while ($row = mysqli_fetch_array($table_id_observations)) {
$current_object_id = $row['object_id'];
$current_user_id = $row['user_id'];
$current_level_id = $row['level_id'];
if ($prev_object_id == 0) {
$prev_object_id = $current_object_id;
}
if ($prev_user_id == 0) {
$prev_user_id = $current_user_id;
}
if ($prev_level_id == 0) {
$prev_level_id = $current_level_id;
}
if ($current_user_id != $prev_user_id || $current_object_id != $prev_object_id && $current_user_id == $prev_user_id) {
//echo $pev_user_id . ' - ' . $current_observation_count . ' - ' . $prev_avatar_url . ' - ' . $current_max_level_id . '(' . $row['level_id'] . ')<br />';
array_push($observations_user_array, array($prev_user_id, $current_observation_count, $prev_avatar_url, $current_max_level_id));
$current_observation_count = 1;
$current_max_level_id = 0;
} else {
$current_observation_count += 1;
$prev_level_id = $current_level_id;
}
if ($current_object_id != $prev_object_id) {
$observations_array[$prev_object_id] = $observations_user_array;
$observations_user_array = '';
$observations_user_array = array();
}
if ($current_level_id >= $prev_level_id) {
$current_max_level_id = $current_level_id;
}
$prev_object_id = $current_object_id;
$prev_user_id = $current_user_id;
$prev_avatar_url = $row['user_avatar_url'];
}
//echo $pev_user_id . ' - ' . $current_observation_count;
array_push($observations_user_array, array($prev_user_id, $current_observation_count, $prev_avatar_url, $current_max_level_id));
//echo ' laatste ' . $prev_object_id . ' - ' . count($observations_user_array);
$observations_array[$prev_object_id] = $observations_user_array;
switch ($sorting_column) {
case 'constellation_name':
$sorting_table = 'constellations';
break;
default:
$sorting_table = 'astronomical_objects';
break;
}
$query = 'SELECT astronomical_objects.object_id, astronomical_objects.object_messier_number, astronomical_objects.object_ngc_number, astronomical_objects.object_name, astronomical_objects.object_thumb_url, astronomical_objects.object_url_wikipedia, astronomical_objects_types.object_type_name, astronomical_objects_types.object_type_thumb_url, astronomical_objects_types.object_type_url_wikipedia, ';
//astronomical_objects_lists.list_name,
$query .= 'constellations.constellation_id, constellations.constellation_name, constellations.constellation_thumb_url, constellations.constellation_url_wikipedia
FROM astronomical_objects
INNER JOIN astronomical_objects_types
USING (object_type_id) ';
//LEFT JOIN astronomical_objects_lists_objects
//USING (object_id)
//LEFT JOIN astronomical_objects_lists
//USING (list_id)
$query .= 'INNER JOIN constellations
USING (constellation_id)';
switch ($sort_type) {
case 'marked':
$query .= ' INNER JOIN users_objects_marked
USING (object_id)
WHERE users_objects_marked.user_id =' . $sort_type_info;
break;
case 'constellation':
$query .= ' WHERE constellations.constellation_id=' . $sort_type_info;
break;
case 'picture':
$query .= ' INNER JOIN pictures_astronomical_objects
USING (object_id)
WHERE pictures_astronomical_objects.picture_id=' . $sort_type_info;
}
$query .= ' ORDER BY ' . $sorting_table . '.' . $sorting_column . ' ' . $sorting_order;
$table_id = mysqli_query($dbc, $query);
while ($row = mysqli_fetch_array($table_id)) {
$return_data .= '<tr>' . "\n";
$return_data .= '<td>';
$return_data .= return_messier_number($row['object_messier_number']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_ngc_number($row['object_ngc_number']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_name_data($row['object_name'], $row['object_url_wikipedia'], $row['object_thumb_url']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_object_type_data($row['object_type_name'], $row['object_type_url_wikipedia'], $row['object_type_thumb_url'], '');
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_constellation_data($row['constellation_id'], $row['constellation_name'], $row['constellation_thumb_url'], $row['constellation_url_wikipedia']);
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
if (!empty($row['object_url_wikipedia'])) {
$return_data .= '<a href="' . $row['object_url_wikipedia'] . '"><img src="images/link_wiki.png" alt="wikipedia_link" /></a>';
}
$return_data .= '</td>' . "\n";
$return_data .= '<td>';
$return_data .= return_user_object_observation_data($observations_array, $row['object_id']);
/*if(isset($observations_array) && !empty($observations_array[$row['object_id']])){
for($i = 0; $i<count($observations_array[$row['object_id']]);$i++){
echo '<div class="avatar" style="background-image: url(\'' . SITE_IMAGES_DIR_FRONT . SITE_AVATAR_DIR . $observations_array[$row['object_id']][$i][2] . '\');"><div class="observations">' . $observations_array[$row['object_id']][$i][1] . '</div></div>';
//echo 'user: '******'object_id']][$i][0] . ' views: ' . $observations_array[$row['object_id']][$i][1];
}
}*/
$return_data .= '</td>' . "\n";
if ($starred) {
}
$return_data .= '</tr>' . "\n";
}
$return_data .= '</table>';
if (mysqli_num_rows($table_id) == 0) {
return false;
} else {
return $return_data;
}
}
