} } } $filter = getFilterString($_POST); // List top 10 routes $sql = "SELECT DISTINCT s.iata AS siata,s.icao AS sicao,s.apid AS sapid,d.iata AS diata,d.icao AS dicao,d.apid AS dapid,{$mode} AS times FROM flights AS f, airports AS s, airports AS d WHERE f.src_apid=s.apid AND f.dst_apid=d.apid AND f.uid={$uid} {$filter} GROUP BY s.apid,d.apid ORDER BY times DESC LIMIT {$limit}"; $result = mysql_query($sql, $db); $first = true; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { if ($first) { $first = false; } else { printf(":"); } $src = format_apcode2($row["siata"], $row["sicao"]); $dst = format_apcode2($row["diata"], $row["dicao"]); printf("%s,%s,%s,%s,%s", $src, $row["sapid"], $dst, $row["dapid"], $row["times"]); } printf("\n"); // List top 10 airports //$sql = "select a.name, a.iata, a.icao, $mode as count, a.apid from airports as a, " . // "(select src_apid as apid, distance, count(*) as fid from flights where uid = $uid group by src_apid" . // " UNION ALL " . // "select dst_apid as apid, distance, count(*) as fid from flights where uid = $uid group by dst_apid ) as f " . // "where f.apid=a.apid $filter " . // "group by a.apid order by count desc limit $limit"; //print $sql; // // ^^^ this is even faster, but $mode has to be SUM(fid), not COUNT(fid), to count flights correctly... $sql = "select a.name, a.iata, a.icao, {$mode} as count, a.apid from airports as a, " . "(select src_apid as apid, distance, fid from flights as f where uid = {$uid} {$filter} " . " UNION ALL " . "select dst_apid as apid, distance, fid from flights as f where uid = {$uid} {$filter} ) as f " . "where f.apid=a.apid " . "group by a.apid order by count desc limit {$limit}"; $result = mysql_query($sql, $db);
function format_apcode($row) { return format_apcode2($row["iata"], $row["icao"]); }
if ($first) { $first = false; } else { if ($export == "export" || $export == "backup") { printf("\r\n"); } else { if ($export == "gcmap") { } else { printf("\n"); } } } $src_apid = $row["src_apid"]; $src_code = format_apcode2($row["src_iata"], $row["src_icao"]); $dst_apid = $row["dst_apid"]; $dst_code = format_apcode2($row["dst_iata"], $row["dst_icao"]); $al_code = format_alcode($row["al_iata"], $row["al_icao"], $row["mode"]); if ($row["opp"] == 'Y') { $tmp = $src_apid; $src_apid = $dst_apid; $dst_apid = $tmp; $tmp = $src_code; $src_code = $dst_code; $dst_code = $tmp; } if ($export == "export" || $export == "backup") { $note = "\"" . $note . "\""; $src_time = $row["src_time"]; // Pad time with space if it's known if ($src_time) { $src_time = " " . $src_time;