} 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>"; } } } } }
$minTakeoffDistance = 10000000; $i = 0; foreach ($waypoints as $waypoint) { $takeoff_distance = $firstPoint->calcDistance($waypoint); if ($takeoff_distance < $minTakeoffDistance) { $minTakeoffDistance = $takeoff_distance; $takeoffIDTmp = $waypoint->waypointID; } $i++; } $nearestWaypoint = new waypoint($takeoffIDTmp); $nearestWaypoint->getFromDB(); $XML_str = "<result>\n"; $XML_str .= "\n\t\t\t<title>Leonardo at " . $_SERVER['SERVER_NAME'] . " :: Flight list</title>\n\t\t\t<link>http://" . $_SERVER['SERVER_NAME'] . getLeonardoLink(array('op' => 'list_flights')) . "</link>\t\t\n\t\t\t<date>" . gmdate('D, d M Y H:i:s', time()) . " GMT</date>\n\t\t"; $XML_str .= "<waypoints>\n"; $XML_str .= $nearestWaypoint->exportXML('XML'); $XML_str .= "\n<distance>" . sprintf("%.0f", $minTakeoffDistance) . "</distance>\n"; $XML_str .= "</waypoints>\n\n"; $where_clause = "AND takeoffID={$nearestWaypoint->waypointID} AND filename<>'' "; $query = "SELECT * FROM {$flightsTable} WHERE private=0 {$where_clause} ORDER BY FLIGHT_POINTS DESC {$lim} "; //echo $query; //exit; $res = $db->sql_query($query); if ($res <= 0) { echo "<H3> Error in query! {$query} </H3>\n"; exit; } $XML_str .= "\n\t\t<flights>"; while ($row = mysql_fetch_assoc($res)) { // $nearestWaypoint=new waypoint($takeoffIDTmp); // $nearestWaypoint->getFromDB();