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">&times;</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);
}