}
}
}
$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;
