}
// List of all flights (unique by airport pair)
$sql = "SELECT DISTINCT s.apid,s.x,s.y,d.apid,d.x,d.y,count(fid),distance AS times,IF(MIN(src_date)>NOW(), 'Y', 'N') AS future,f.mode 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";
$result = mysql_query($sql, $db) or die('Error;Database error ' . $sql . ', ' . mysql_error());
$first = true;
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
if ($first) {
$first = false;
} else {
$map .= "\t";
}
$map .= sprintf("%s;%s;%s;%s;%s;%s;%s;%s;%s;%s", $row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6], $row[7], $row[8], $row[9]);
}
$map .= "\n";
// List of all airports
$sql = "SELECT DISTINCT a.apid,x,y,name,iata,icao,city,country,timezone,dst,count(name) AS visits,IF(MIN(src_date)>NOW(), 'Y', 'N') AS future FROM flights AS f, airports AS a WHERE (f.src_apid=a.apid OR f.dst_apid=a.apid) AND f.uid=" . $uid . $filter . " GROUP BY CONCAT(name,city) ORDER BY visits ASC";
$result = mysql_query($sql, $db) or die('Error;Database error ' . $sql . ', ' . mysql_error());
$first = true;
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if ($first) {
$first = false;
} else {
$map .= "\t";
}
$map .= sprintf("%s;%s;%s;%s;%s;%s;%s", format_apdata($row), $row["name"], $row["city"], $row["country"], $row["visits"], format_airport($row), $row["future"]);
}
print $map . "\n";
// When running for the first time, load up possible filter settings for this user
if ($init == "true") {
loadFilter($db, $uid, $trid, $logged_in);
}
$sql = sprintf("%s OR name LIKE '%s%%') ORDER BY city,name LIMIT %s", $sql, $query, $limit);
} else {
$sql = sprintf("%s) ORDER BY city,name LIMIT %s", $sql, $limit);
}
break;
}
if ($limit > 1) {
print "<ul class='autocomplete'>";
}
$rs = mysql_query($sql);
if (mysql_num_rows($rs) > 0) {
while ($row = mysql_fetch_assoc($rs)) {
if ($limit > 1) {
printf("<li class='autocomplete' origin='%s' id='%s'>%s</li>\n", $ap, format_apdata($row), format_airport($row));
} else {
printf("%s;%s", format_apdata($row), format_airport($row));
exit;
// match found, do not fall thru to airlines
}
}
}
}
if (!$query || $multi) {
// Autocompletion for airlines
// 2 chars: match on IATA or name (major airlines only)
// 3 chars: match on ICAO or name (major airlines only)
// >3 chars: match on name (any airline)
$airlines = array("qs", "airline", "airline1", "airline2", "airline3", "airline4");
foreach ($airlines as $al) {
if ($_POST[$al]) {
$query = mysql_real_escape_string($_POST[$al]);
