} else {
if ($op == "get_latest") {
$tm = $_GET['tm'] + 0;
// timestamp
if (!$tm) {
$tm = time() - 60 * 60 * 24 * 7;
}
// 1 week back
$query = "SELECT * from {$waypointsTable} WHERE modifyDate>=FROM_UNIXTIME({$tm}) AND type=1000 ";
$res = $db->sql_query($query);
header('Content-Type: text/xml');
echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\" ?>";
echo "<search>";
if ($res <= 0) {
echo "</search>";
return;
}
$i = 0;
while ($row = mysql_fetch_assoc($res)) {
$resWaypoint = new waypoint($row["ID"]);
$resWaypoint->getFromDB();
echo $resWaypoint->exportXML('XML');
$i++;
}
mysql_freeResult($res);
echo "</search>";
}
}
}
}
}
function listFlights($res, $legend, $query_str = "", $sortOrder = "DATE")
{
global $Theme;
global $module_name;
global $takeoffRadious;
global $userID;
global $moduleRelPath;
global $admin_users;
global $PREFS;
global $page_num, $pagesNum, $startNum, $itemsNum;
global $currentlang, $nativeLanguage, $opMode;
$legendRight = "";
if ($pagesNum > 1) {
if ($page_num > 1) {
$legendRight .= "<a href='?name={$module_name}&op=list_flights&sortOrder={$sortOrder}{$query_str}&page_num=" . ($page_num - 1) . "'><<</a> ";
} else {
$legendRight .= "<< ";
}
for ($k = 1; $k <= $pagesNum; $k++) {
if ($k != $page_num) {
$legendRight .= "<a href='?name={$module_name}&op=list_flights&sortOrder={$sortOrder}{$query_str}&page_num={$k}'>{$k}</a> ";
} else {
$legendRight .= "{$k} ";
}
}
if ($page_num < $pagesNum) {
$legendRight .= "<a href='?name={$module_name}&op=list_flights&sortOrder={$sortOrder}{$query_str}&page_num=" . ($page_num + 1) . "'>>></a> ";
} else {
$legendRight .= ">> ";
}
}
$endNum = $startNum + $PREFS->itemsPerPage;
if ($endNum > $itemsNum) {
$endNum = $itemsNum;
}
$legendRight .= " [ " . ($startNum + 1) . "-" . $endNum . " " . _From . " " . $itemsNum . " ]";
if ($itemsNum == 0) {
$legendRight = "[ 0 ]";
}
$headerSelectedBgColor = "#F2BC66";
open_inner_table("<table class=main_text width=100%><tr><td>{$legend}</td><td valign=top width=400 align=right bgcolor=#eeeeee>{$legendRight}</td></tr></table>", 750, -1);
?>
<td width="25" bgcolor="<?php
echo $Theme->color1;
?>
"><div align=left><?php
echo _NUM;
?>
</div></td>
<?php
printHeader(80, $headerSelectedBgColor, $Theme->color0, $sortOrder, "DATE", _DATE_SORT, $query_str);
printHeader(160, $headerSelectedBgColor, $Theme->color0, $sortOrder, "pilotName", _PILOT, $query_str);
printHeader(0, $headerSelectedBgColor, $Theme->color1, $sortOrder, "takeoffID", _TAKEOFF, $query_str);
printHeader(40, $headerSelectedBgColor, $Theme->color2, $sortOrder, "DURATION", _DURATION_HOURS_MIN, $query_str);
printHeader(65, $headerSelectedBgColor, $Theme->color3, $sortOrder, "LINEAR_DISTANCE", _LINEAR_DISTANCE, $query_str);
printHeader(65, $headerSelectedBgColor, $Theme->color3, $sortOrder, "FLIGHT_KM", _OLC_KM, $query_str);
printHeader(40, $headerSelectedBgColor, $Theme->color3, $sortOrder, "FLIGHT_POINTS", _OLC_SCORE, $query_str);
?>
<td width="18" bgcolor="<?php
echo $Theme->color4;
?>
"> </td>
<td width="72" bgcolor="<?php
echo $Theme->color4;
?>
"><div align=left><?php
echo _SHOW;
?>
</div></td></tr>
<?php
$i = 1;
while ($row = mysql_fetch_assoc($res)) {
$is_private = $row["private"];
$name = getPilotRealName($row["userID"], $row["serverID"]);
$takeoffName = getWaypointName($row["takeoffID"]);
$takeoffVinicity = $row["takeoffVinicity"];
$takeoffNameFrm = formatLocation($takeoffName, $takeoffVinicity, $takeoffRadious);
$sortRowBgColor = $i % 2 ? "#CCCACA" : "#E7E9ED";
$i++;
open_tr();
$days_from_submission = floor((mktime() - datetime2UnixTimestamp($row["dateAdded"])) / 86400);
// 60*60*24 sec per day
if ($is_private) {
$first_col_back_color = " bgcolor=#33dd33 ";
} else {
$first_col_back_color = "";
}
echo "<TD {$first_col_back_color} ><div align=left>" . ($i - 1 + $startNum) . "</div></TD> \n\t <TD " . ($sortOrder == "DATE" ? "bgcolor=" . $sortRowBgColor : "") . ">\n\t\t\t<div align=right>";
if ($days_from_submission <= 3) {
echo "<img src='" . $moduleRelPath . "/img/icon_new.png' >";
}
echo formatDate($row["DATE"]) . "</div></TD>" . "<TD width=300 colspan=2 valign=top " . ($sortOrder == "pilotName" || $sortOrder == "takeoffID" ? "bgcolor=" . $sortRowBgColor : "") . ">" . "<div align=left>" . "<a href='?name={$module_name}&op=pilot_profile&pilotIDview=" . $row["userID"] . "'><img src='" . $moduleRelPath . "/img/icon_magnify_small.gif' border=0></a>" . "<a href='?name={$module_name}&op=pilot_profile_stats&pilotIDview=" . $row["userID"] . "'><img src='" . $moduleRelPath . "/img/icon_stats.gif' border=0></a> " . "<a href='?name={$module_name}&op=list_flights&pilotID=" . $row["userID"] . "'>{$name}</a>" . "</div><div align=right>" . "<a href='?name={$module_name}&op=list_flights&takeoffID=" . $row["takeoffID"] . "'>{$takeoffNameFrm}</a> " . "<a href='?name={$module_name}&op=show_waypoint&waypointIDview=" . $row["takeoffID"] . "'><img src='" . $moduleRelPath . "/img/icon_magnify_small.gif' border=0></a>" . "<a href='" . $moduleRelPath . "/download.php?type=kml_wpt&wptID=" . $row["takeoffID"] . "'><img src='" . $moduleRelPath . "/img/gearth_icon.png' border=0></a>" . "</div></TD>" . "<TD " . ($sortOrder == "DURATION" ? "bgcolor=" . $sortRowBgColor : "") . "><div align=right>" . sec2Time($row['DURATION'], 1) . "</div></TD>\n\t <TD " . ($sortOrder == "LINEAR_DISTANCE" ? "bgcolor=" . $sortRowBgColor : "") . "><div align=right>" . formatDistanceOpen($row["LINEAR_DISTANCE"]) . "</div></TD>\t\n\t <TD " . ($sortOrder == "FLIGHT_KM" ? "bgcolor=" . $sortRowBgColor : "") . "><div align=right>" . formatDistanceOpen($row["FLIGHT_KM"]) . "</div></TD>\t\n\t <TD " . ($sortOrder == "FLIGHT_POINTS" ? "bgcolor=" . $sortRowBgColor : "") . "><div align=right>" . formatOLCScore($row["FLIGHT_POINTS"]) . "</div></TD>" . "<td><img src='" . $moduleRelPath . "/img/icon_cat_" . $row["cat"] . ".png' border=0></td>" . "<TD align=left><a href='?name={$module_name}&op=show_flight&flightID=" . $row["ID"] . "'><img src='" . $moduleRelPath . "/img/icon_magnify_small.gif' border=0></a>";
echo "<a href='" . $moduleRelPath . "/download.php?type=kml_trk&flightID=" . $row["ID"] . "'><img src='" . $moduleRelPath . "/img/gearth_icon.png' border=0></a>";
if ($row["photo1Filename"]) {
echo "<img src='" . $moduleRelPath . "/img/photo_icon.jpg' width=16 height=16>";
} else {
echo "<img src='" . $moduleRelPath . "/img/photo_icon_blank.gif' width=16 height=16>";
}
if ($row["userID"] == $userID || in_array($userID, $admin_users)) {
// admin IDS in $admin_users
echo "<a href='?name={$module_name}&op=delete_flight&flightID=" . $row["ID"] . "'><img src='" . $moduleRelPath . "/img/x_icon.gif' width=16 height=16 border=0 align=bottom></a>";
echo "<a href='?name={$module_name}&op=edit_flight&flightID=" . $row["ID"] . "'><img src='" . $moduleRelPath . "/img/change_icon.png' width=16 height=16 border=0 align=bottom></a>";
}
echo "</TD>";
close_tr();
}
close_inner_table();
mysql_freeResult($res);
}