DATE_SUB( NOW() , INTERVAL 15 MINUTE ) ORDER BY IATA";
$result = mysql_query( $sql );
$cont = 1;
/* mysql error */
if (!$result) {
print "Error - Database Connection.";
$cont = 0;
}
if ($cont) {
if (mysql_numrows($result) == 0) {
print "No Pilots Actively Flying.";
} else {
print "![](\"pilot_world_map_gen.php\")
";
print "";
print "";
print "| Pilot | ";
print "Callsign | ";
print "Alt | ";
print "GS | ";
print "From | ";
print "To | ";
print "Dist. from Ori. | ";
print "Dist. to Dest. | ";
print "ETE | ";
print "STATUS | ";
print "
";
$phase_colors = array();
$phase_colors[0] = "color=#FFFFFF"; // Disconnected from ACARS - White
$phase_colors[1] = "color=#CCCCCC"; // Boarding - Gray
$phase_colors[2] = "color=#FF00FF"; // Taxi From Gate - Purple
$phase_colors[3] = "color=#0000FF"; // Departing - Blue
$phase_colors[4] = "color=#00FFFF"; // Climbing - Cyan
$phase_colors[5] = "color=#00FF00"; // Cruising - Green
$phase_colors[6] = "color=#FFFF00"; // Descending - Yellow
$phase_colors[7] = "color=#FF8800"; // Landed - Orange
$phase_colors[8] = "color=#FF0000"; // Taxi To Gate - Red
$phase_colors[9] = "color=#FFFFFF"; // Arrived at Gate - White
$phase_msgs = array();
$phase_msgs[0] = "Disconnected from ACARS";
$phase_msgs[1] = "Boarding";
$phase_msgs[2] = "Taxi From Gate";
$phase_msgs[3] = "Departing";
$phase_msgs[4] = "Climbing";
$phase_msgs[5] = "Cruising";
$phase_msgs[6] = "Descending";
$phase_msgs[7] = "Landed";
$phase_msgs[8] = "Taxi To Gate";
$phase_msgs[9] = "Arrived At Gate";
$number = mysql_numrows($result);
for ($i=0; $i < $number; $i++) {
$pnum = mysql_result($result,$i,"pilot_num");
$alt = mysql_result($result,$i,"alt");
$gs = mysql_result($result,$i,"gs");
$callsign = mysql_result($result,$i,"IATA");
$dep = mysql_result($result,$i,"depAptICAO");
$depname = mysql_result($result,$i,"depapt");
$dest = mysql_result($result,$i,"destAptICAO");
$destname = mysql_result($result,$i,"destapt");
$distOrig = mysql_result($result,$i,"disDepApt");
$distDest = mysql_result($result,$i,"disDestApt");
$ETA = mysql_result($result,$i,"timeDestApt");
$phase = mysql_result($result,$i,"phase");
print "";
print "| $pnum | ";
print "$callsign | ";
print "$alt | ";
print "$gs | ";
print "$depname | ";
print "$destname | ";
print "$distOrig | ";
print "$distDest | ";
print "$ETA | ";
print "".$phase_msgs[$phase]." | ";
print "
";
}
}
}
?>