if ($_COOKIE[cookie_name]) { $IVAO_Info = json_decode(file_get_contents(api_url . '?type=json&token=' . $_COOKIE[cookie_name])); } // GLOBAL VARIABLES global $navdatabase, $rfedatabase, $IVAO_Info, $sqlconn; // Get Information of the Flight from the Database $querymodal = "SELECT f.id, f.flightnumber, f.radiocallsign, f.origin, f.destination, IFNULL(DATE_FORMAT(f.deptime, '%H%i'),'----') AS deptime,\n IFNULL(DATE_FORMAT(f.arrtime, '%H%i'),'----') AS arrtime, IFNULL(f.gate,'TBD') AS gate, f.acft, IFNULL(f.route,'TBD') AS route, f.vid, f.bookingstatus, m.name, m.ratingpilot, m.division, m.privacy\n FROM rfe_flights AS f\n\t\t\t\t\tLEFT JOIN rfe_members AS m ON m.vid = f.vid\n\t\t\t\t\tWHERE f.id='" . $flightID . "'"; $querymodal = mysqlexec($sqlconn, $querymodal); // Get Information of the Departure and Arrival airports from the Database change_db($sqlconn, $navdatabase); $queryorig = "SELECT Name,Latitude,Longtitude FROM airports WHERE ICAO='" . mysql_result($querymodal, 0, "origin") . "'"; $queryorig = mysqlexec($sqlconn, $queryorig); $querydest = "SELECT Name,Latitude,Longtitude FROM airports WHERE ICAO='" . mysql_result($querymodal, 0, "destination") . "'"; $querydest = mysqlexec($sqlconn, $querydest); change_db($sqlconn, $rfedatabase); $gcddistance = round(decimal_distance(mysql_result($queryorig, 0, 'Latitude'), mysql_result($queryorig, 0, 'Longtitude'), mysql_result($querydest, 0, 'Latitude'), mysql_result($querydest, 0, 'Longtitude'))); // Get radio callsign configuration $querycall = "SELECT useradiocallsign FROM rfe_config"; $querycall = mysqlexec($sqlconn, $querycall); $radiocall = mysql_result($querycall, 0, 'useradiocallsign'); // Check if the airline has a logo and gets it. if (file_exists("../logos/" . substr(mysql_result($querymodal, 0, 'flightnumber'), 0, 3) . ".gif")) { $logo = '<img src="logos/' . substr(mysql_result($querymodal, 0, 'flightnumber'), 0, 3) . '.gif"/> '; } else { $logo = ''; } ?> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h3><?php
break; case 11: $simVersion = '<span class="label label-warning pull-right">X-Plane</span>'; break; default: $simVersion = '<span class="label label-muted pull-right">Unknown</span>'; break; } // Current aircraft type $aircraftInUse = explode("-", $onlineData[9]); $aircraftInUse = explode("/", $aircraftInUse[0]); $aircraftInUse = $aircraftInUse[1]; //print_r($onlineData); // Planned arrival $distFwn = decimal_distance($onlineData[5], $onlineData[6], mysql_result($queryorig, 0, 'Latitude'), mysql_result($queryorig, 0, 'Longtitude')); $distRem = decimal_distance($onlineData[5], $onlineData[6], mysql_result($querydest, 0, 'Latitude'), mysql_result($querydest, 0, 'Longtitude')); if ($distFwn < 2) { if ($onlineData[8] > 0) { $remTime = "Taxi Out"; } else { $remTime = "Boarding"; } } else { if ($distRem < 2) { if ($onlineData[8] > 0) { $remTime = "Taxi In"; } else { $remTime = "On Blocks"; } } else { $timeRem = $distRem / $onlineData[8];
function flighttime($orgn, $dest, $acft) { // SQL Pointer is a global variable global $navdatabase, $rfedatabase, $sqlconn; // Pick up LatLon of each airfield change_db($sqlconn, $navdatabase); $queryorig = "SELECT Latitude,Longtitude FROM airports WHERE ICAO='" . $orgn . "'"; $queryorig = mysqlexec($sqlconn, $queryorig); $querydest = "SELECT Latitude,Longtitude FROM airports WHERE ICAO='" . $dest . "'"; $querydest = mysqlexec($sqlconn, $querydest); change_db($sqlconn, $rfedatabase); // Pick up average speed of the aircraft $queryacft = "SELECT speed FROM nav_aircrafts WHERE iata='" . $acft . "'"; $queryacft = mysqlexec($sqlconn, $queryacft); $speed = mysql_result($queryacft, 0, 'speed'); if (empty($speed)) { $query = "SELECT speed FROM nav_aircrafts WHERE icao='" . $acft . "'"; $query = mysqlexec($sqlconn, $query); if (empty($speed)) { $spd = 250; } else { $spd = mysql_result($query, 0, 'speed'); } } else { $spd = mysql_result($queryacft, 0, 'speed'); } $flightdistance = decimal_distance(mysql_result($queryorig, 0, 'Latitude'), mysql_result($queryorig, 0, 'Longtitude'), mysql_result($querydest, 0, 'Latitude'), mysql_result($querydest, 0, 'Longtitude')); //$flighttime = ($flightdistance/mysql_result($queryacft,0,'speed')); $flighttime = $flightdistance / $spd + 0.3; // 20 min added as climb/descent. $timeHours = floor($flighttime); $timeMinutes = $flighttime - $timeHours; $timeMinutes = round($timeMinutes * 60); return sprintf("%02.0f", $timeHours) . sprintf("%02.0f", $timeMinutes); }