} // 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]);