flightid-overview.php

   1 <?php
   2 $id = filter_input(INPUT_GET,'id',FILTER_SANITIZE_STRING);
   3 if ($id == "")
   4 {
   5         header('Location: /');
   6 }
   7
   8 require_once('require/class.Connection.php');
   9 require_once('require/class.Spotter.php');
  10 require_once('require/class.ACARS.php');
  11 require_once('require/class.Language.php');
  12 require_once('require/class.SpotterArchive.php');
  13 $ACARS = new ACARS();
  14 $Spotter = new Spotter();
  15 $SpotterArchive = new SpotterArchive();
  16 $spotter_array = $Spotter->getSpotterDataByID($id);
  17
  18
  19 if (!empty($spotter_array))
  20 {
  21         if(isset($spotter_array[0]['flightaware_id'])) {
  22                 $flightaware_id = $spotter_array[0]['flightaware_id'];
  23         }
  24         if(isset($spotter_array[0]['last_latitude']) && $spotter_array[0]['last_latitude'] != '') {
  25                 $latitude = $spotter_array[0]['last_latitude'];
  26         } elseif(isset($spotter_array[0]['latitude'])) {
  27                 $latitude = $spotter_array[0]['latitude'];
  28         }
  29         if(isset($spotter_array[0]['last_longitude']) && $spotter_array[0]['last_longitude'] != '') {
  30                 $longitude = $spotter_array[0]['last_longitude'];
  31         } elseif(isset($spotter_array[0]['longitude'])) {
  32                 $longitude = $spotter_array[0]['longitude'];
  33         }
  34
  35         if (isset($flightaware_id) && ((!isset($latitude) && !isset($longitude)) || ($latitude == 0 && $longitude == 0))) {
  36                 require_once('require/class.SpotterLive.php');
  37                 $SpotterLive = new SpotterLive();
  38                 $live_data = $SpotterLive->getLastLiveSpotterDataById($flightaware_id);
  39                 $latitude = $live_data[0]['latitude'];
  40                 $longitude = $live_data[0]['longitude'];
  41         }
  42
  43         $title = '';
  44         if(isset($spotter_array[0]['ident'])) {
  45                 $title .= $spotter_array[0]['ident'];
  46         }
  47         if(isset($spotter_array[0]['airline_name'])) {
  48                 $title .= ' - '.$spotter_array[0]['airline_name'];
  49         }
  50         if(isset($spotter_array[0]['aircraft_name']) && $spotter_array[0]['aircraft_name'] != 'Not Available') {
  51                 $title .= ' - '.$spotter_array[0]['aircraft_name'].' ('.$spotter_array[0]['aircraft_type'].')';
  52         }
  53         if(isset($spotter_array[0]['registration']) && $spotter_array[0]['registration'] != 'NA' && $spotter_array[0]['registration'] != 'N/A') {
  54                 $title .= ' - '.$spotter_array[0]['registration'];
  55         }
  56         //$facebook_meta_image = $spotter_array[0]['image'];
  57         require_once('header.php');
  58         if (isset($globalArchive) && $globalArchive) {
  59                 $all_data = $SpotterArchive->getAltitudeSpeedArchiveSpotterDataById($spotter_array[0]['flightaware_id']);
  60                 if (isset($globalTimezone)) {
  61                         date_default_timezone_set($globalTimezone);
  62                 } else date_default_timezone_set('UTC');
  63
  64                 if (is_array($all_data) && count($all_data) > 1) {
  65                         print '<br/>';
  66                         print '<link href="'.$globalURL.'/css/c3.min.css" rel="stylesheet" type="text/css">';
  67                         print '<script type="text/javascript" src="'.$globalURL.'/js/d3.min.js"></script>';
  68                         print '<script type="text/javascript" src="'.$globalURL.'/js/c3.min.js"></script>';
  69                         print '<div id="chart" class="chart" width="100%"></div><script>';
  70                         $altitude_data = '';
  71                         $hour_data = '';
  72                         $speed_data = '';
  73                         foreach($all_data as $data)
  74                         {
  75                                 $hour_data .= '"'.$data['date'].'",';
  76                                 if (isset($data['real_altitude']) && $data['real_altitude'] != '') {
  77                                         $altitude = $data['real_altitude'];
  78                                 } else {
  79                                         $altitude = $data['altitude'].'00';
  80                                 }
  81                                 if ((!isset($_COOKIE['unitaltitude']) && isset($globalUnitAltitude) && $globalUnitAltitude == 'feet') || (isset($_COOKIE['unitaltitude']) && $_COOKIE['unitaltitude'] == 'feet')) {
  82                                         $unit = 'feet';
  83                                 } else {
  84                                         $unit = 'm';
  85                                         $altitude = round($altitude*0.3048);
  86                                 }
  87                                 $altitude_data .= $altitude.',';
  88                                 $speed = $data['ground_speed'];
  89                                 if ((!isset($_COOKIE['unitspeed']) && isset($globalUnitSpeed) && $globalUnitSpeed == 'mph') || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'mph')) {
  90                                         $speed = round($speed*1.15078);
  91                                         $units = 'mph';
  92                                 } elseif ((!isset($_COOKIE['unitspeed']) && isset($globalUnitSpeed) && $globalUnitSpeed == 'knots') || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'knots')) {
  93                                         $units = 'knots';
  94                                 } else {
  95                                         $speed = round($speed*1.852);
  96                                         $units = 'km/h';
  97                                 }
  98                                 $speed_data .= $speed.',';
  99                         }
 100                         $hour_data = "['x',".substr($hour_data, 0, -1)."]";
 101                         $altitude_data = "['altitude',".substr($altitude_data,0,-1)."]";
 102                         $speed_data = "['speed',".substr($speed_data,0,-1)."]";
 103                         print 'c3.generate({
 104                             bindto: "#chart",
 105                             data: {
 106                                 x: "x",
 107                                 axes: {
 108                                     altitude: "y",
 109                                     speed: "y2"
 110                                 },
 111                                 xFormat: "%Y-%m-%d %H:%M:%S",
 112                                 columns: ['.$hour_data.','.$altitude_data.','.$speed_data.'],
 113                                 colors: {
 114                                     altitude: "#1a3151",
 115                                     speed: "#aa0000"
 116                                 }
 117                             },
 118                             axis: {
 119                                 x: {
 120                                     type: "timeseries", tick: { format: "%H:%M:%S"}
 121                                 },
 122                                 y: {
 123                                     label: "Altitude ('.$unit.')"
 124                                 },
 125                                 y2: {
 126                                     label: "Speed ('.$units.')",
 127                                     show: true
 128                                 }
 129                             },
 130                             legend: { show: false }});';
 131                         print '</script>';
 132                 }
 133         }
 134
 135
 136         print '<div class="info column">';
 137         print '<br/><br/><br/>';
 138         print '<h1>';
 139         if ($globalIVAO && @getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif')) {
 140                 print '<a href="'.$globalURL.'/airline/'.$spotter_array[0]['airline_icao'].'"><img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.gif" class="airline-logo" /></a> ';
 141         } elseif (@getimagesize($globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png')) {
 142                 print '<a href="'.$globalURL.'/airline/'.$spotter_array[0]['airline_icao'].'"><img src="'.$globalURL.'/images/airlines/'.$spotter_array[0]['airline_icao'].'.png" class="airline-logo" /></a> ';
 143         } else {
 144                 if (isset($spotter_array[0]['airline_name']) && $spotter_array[0]['airline_name'] != "") {
 145                         print '<a href="'.$globalURL.'/airline/'.$spotter_array[0]['airline_icao'].'">'.$spotter_array[0]['airline_name'].'</a> ';
 146                 }
 147         }
 148         if(isset($spotter_array[0]['ident'])) {
 149                 print $spotter_array[0]['ident'];
 150         }
 151         if(isset($spotter_array[0]['airline_name'])) {
 152                 print ' - '.$spotter_array[0]['airline_name'];
 153         }
 154         if(isset($spotter_array[0]['aircraft_name']) && $spotter_array[0]['aircraft_name'] != 'Not Available') {
 155                 print ' - '.$spotter_array[0]['aircraft_name'].' ('.$spotter_array[0]['aircraft_type'].')';
 156         }
 157         if(isset($spotter_array[0]['registration']) && $spotter_array[0]['registration'] != 'NA') {
 158                 print ' - '.$spotter_array[0]['registration'];
 159         }
 160         print '</h1>';
 161         print '</div>';
 162
 163         if ($spotter_array[0]['registration'] != "") {
 164                 //$highlight = $Spotter->getHighlightByRegistration($spotter_array[0]['registration']);
 165                 $highlight = $spotter_array[0]['highlight'];
 166                 if ($highlight != "") {
 167                         print '<div class="alert alert-warning">'.$highlight.'</div>';
 168                 }
 169         }
 170
 171         include('flightid-sub-menu.php');
 172         print '<div class="clear column">';
 173         print '<div class="image">';
 174         if ($spotter_array[0]['image'] != "")
 175         {
 176                 if ($spotter_array[0]['image_source'] == 'planespotters') {
 177                         $planespotter_url_array = explode("_", $spotter_array[0]['image']);
 178                         $planespotter_id = str_replace(".jpg", "", $planespotter_url_array[1]);
 179                         print '<a href="http://www.planespotters.net/Aviation_Photos/photo.show?id='.$planespotter_id.'" target="_blank"><img src="'.$spotter_array[0]['image_thumbnail'].'" alt="Click image to view on Planespotters.net" title="Click image to view on Planespotters.net" width="100%" /></a>';
 180                         print '<div class="note">Disclaimer: The images are courtesy of Planespotters.net and their respective uploaders. This system may not always 100% accuratly show the actual aircraft.</div>';
 181                         print '<div class="note">Planespotters.net didn\'t allow us to show full size pics here. This pic is copyright '.$spotter_array[0]['image_copyright'].'</div>';
 182                 } else {
 183                         if (isset($spotter_array[0]['image_source_website']) && $spotter_array[0]['image_source_website'] != '') {
 184                                 print '<a href="'.$spotter_array[0]['image_source_website'].'"><img src="'.$spotter_array[0]['image'].'" width="100%" /></a>';
 185                         } else {
 186                                 print '<img src="'.$spotter_array[0]['image'].'" width="100%" />';
 187                         }
 188                         print '<div class="note">Disclaimer: The source of the above image is '.$spotter_array[0]['image_source'].' and is copyright '.$spotter_array[0]['image_copyright'].'. This system may not show the actual aircraft with 100% accuracy.</div>';
 189                 }
 190         } else {
 191                 //print '<img src="'.$globalURL.'/images/placeholder.png" alt="No image found!" title="No image found!" />';
 192         }
 193         print '</div>';
 194
 195 /*                      print '<div class="col-sm-4 details">';
 196
 197                         foreach($spotter_array as $spotter_item)
 198                   {
 199                         print '<div class="detail">';
 200                         if (@getimagesize($globalURL.'/images/airlines/'.$spotter_item['airline_icao'].'.png'))
 201                         {
 202                                 print '<a href="'.$globalURL.'/airline/'.$spotter_item['airline_icao'].'"><img src="'.$globalURL.'/images/airlines/'.$spotter_item['airline_icao'].'.png" /></a>';
 203                         } else {
 204                                         if (isset($spotter_item['airline_name']) && $spotter_item['airline_name'] != "")
 205                                         {
 206                                                 print '<a href="'.$globalURL.'/airline/'.$spotter_item['airline_icao'].'">'.$spotter_item['airline_name'].'</a>';
 207                                         } else {
 208                                         print 'N/A';
 209                                         }
 210                         }
 211                         print '</div>';
 212
 213                         print '<div class="detail">';
 214                                 print '<div class="title">Ident/Callsign</div>';
 215                                 print '<div>';
 216                                 if ($spotter_item['ident'] != "")
 217                                 {
 218                                         print '<a href="'.$globalURL.'/ident/'.$spotter_item['ident'].'">'.$spotter_item['ident'].'</a>';
 219                                 } else {
 220                                 print 'N/A';
 221                                 }
 222                                 print '</div>';
 223                         print '</div>';
 224
 225                         print '<div class="detail">';
 226                                 print '<div class="title">Aircraft</div>';
 227                                 print '<div>';
 228                                         if (isset($spotter_item['aircraft_name']))
 229                                         {
 230                                         print '<a href="'.$globalURL.'/aircraft/'.$spotter_item['aircraft_type'].'">'.$spotter_item['aircraft_name'].' ('.$spotter_item['aircraft_type'].')</a>';
 231                                         } else {
 232                                                 if ($spotter_item['aircraft_type'] != "")
 233                                                 {
 234                                                 print $spotter_item['aircraft_type'];
 235                                                 } else {
 236                                                 print 'N/A';
 237                                                 }
 238                                         }
 239                                 print '</div>';
 240                         print '</div>';
 241
 242                         print '<div class="detail">';
 243                                 print '<div class="title">Registration</div>';
 244                                 print '<div>';
 245                                         if ($spotter_item['registration'] != "")
 246                                         {
 247                                         print '<a href="'.$globalURL.'/registration/'.$spotter_item['registration'].'">'.$spotter_item['registration'].'</a>';
 248                                         } else {
 249                                                 print 'N/A';
 250                                         }
 251                                 print '</div>';
 252                         print '</div>';
 253
 254                         print '<div class="detail">';
 255                                 print '<div class="title">Coming from</div>';
 256                                 print '<div>';
 257                                         if ($spotter_item['departure_airport_name'] != "")
 258                                 {
 259                                         print '<a href="'.$globalURL.'/airport/'.$spotter_item['departure_airport'].'">'.$spotter_item['departure_airport_city'].', '.$spotter_item['departure_airport_name'].', '.$spotter_item['departure_airport_country'].' ('.$spotter_item['departure_airport'].')</a>';
 260                                 } else {
 261                                         print $spotter_item['departure_airport'];
 262                                 }
 263                                 print '</div>';
 264                         print '</div>';
 265
 266                         print '<div class="detail">';
 267                                 print '<div class="title">Flying to</div>';
 268                                 print '<div>';
 269                                         if ($spotter_item['arrival_airport_name'] != "")
 270                                 {
 271                                         print '<a href="'.$globalURL.'/airport/'.$spotter_item['arrival_airport'].'">'.$spotter_item['arrival_airport_city'].', '.$spotter_item['arrival_airport_name'].', '.$spotter_item['arrival_airport_country'].' ('.$spotter_item['arrival_airport'].')</a>';
 272                                                 } else {
 273                                                         print $spotter_item['arrival_airport'];
 274                                                 }
 275                                 print '</div>';
 276                         print '</div>';
 277
 278                         print '<div class="detail">';
 279                                 print '<div class="title">Date</div>';
 280                                 print '<div>';
 281
 282                                         print '<a href="'.$globalURL.'/date/'.date("Y-m-d", strtotime($spotter_item['date_iso_8601'])).'">'.date("M j, Y, g:i a", strtotime($spotter_item['date_iso_8601'])).'</a>';
 283                                 print '</div>';
 284                         print '</div>';
 285                   }
 286
 287                  print '</div>';
 288
 289
 290                         print '<div class="col-sm-7 col-sm-offset-1 image">';
 291
 292                         print '<div class="image">';
 293
 294
 295                                 if ($spotter_array[0]['image'] != "")
 296                                 {
 297                     $planespotter_url_array = explode("_", $spotter_array[0]['image']);
 298                     $planespotter_id = str_replace(".jpg", "", $planespotter_url_array[1]);
 299                     print '<a href="http://www.planespotters.net/Aviation_Photos/photo.show?id='.$planespotter_id.'" target="_blank"><img src="'.$spotter_array[0]['image'].'" alt="Click image to view on Planespotters.net" title="Click image to view on Planespotters.net" /></a>';
 300
 301                                 } else {
 302                                         print '<img src="'.$globalURL.'/images/placeholder.png" alt="No image found!" title="No image found!" />';
 303                                 }
 304
 305                          print '</div>';
 306                          print '<div class="note">Disclaimer: The images are courtesy of Planespotters.net and may not always be 100% accurate of the actual aircraft that has flown over.</div>';
 307                  print '</div>';
 308          print '</div>';
 309 */
 310
 311         foreach($spotter_array as $spotter_item)
 312         {
 313                 print '<div class="details">';
 314                 print '<h3>'._("Flight Information").'</h3>';
 315                 print '<div class="detail callsign">';
 316                 print '<div class="title">'._("Ident/Callsign").'</div>';
 317                 print '<div>';
 318                 if ($spotter_item['ident'] != "")
 319                 {
 320                         print '<a href="'.$globalURL.'/ident/'.$spotter_item['ident'].'">'.$spotter_item['ident'].'</a>';
 321                 } else {
 322                         print 'N/A';
 323                 }
 324                 print '</div>';
 325                 print '</div>';
 326
 327                 if (isset($spotter_item['aircraft_owner']) && $spotter_item['aircraft_owner'] != '')
 328                 {
 329                         print '<div class="detail fa-user">';
 330                         print '<div class="title">'._("Owner").'</div>';
 331                         print '<div>';
 332                         print $spotter_item['aircraft_owner'];
 333                         print '</div>';
 334                         print '</div>';
 335                 } elseif ((isset($globalVA) && $globalVA) || (isset($globalIVAO) && $globalIVAO) || (isset($globalVATSIM) && $globalVATSIM) || (isset($globalphpVMS) && $globalphpVMS)) {
 336                         print '<div class="detail fa-user">';
 337                         print '<div class="title">'._("Pilot Name").'</div>';
 338                         print '<div>';
 339                         if (isset($spotter_item['pilot_id']) && $spotter_item['pilot_id'] != "")
 340                         {
 341                                 if ($spotter_item['format_source'] == 'whazzup') print '<a href="https://www.ivao.aero/Member.aspx?ID='.$spotter_item['pilot_id'].'">'.$spotter_item['pilot_name'].' ('.$spotter_item['pilot_id'].')</a>';
 342                                 elseif ($spotter_item['format_source'] == 'vatsimtxt') print '<a href="http://www.vataware.com/pilot/'.$spotter_item['pilot_id'].'">'.$spotter_item['pilot_name'].' ('.$spotter_item['pilot_id'].')</a>';
 343                                 else print $spotter_item['pilot_name'].' ('.$spotter_item['pilot_id'].')';
 344                         } else {
 345                                 if (isset($spotter_item['pilot_name']) && $spotter_item['pilot_name'] != "")
 346                                 {
 347                                         print $spotter_item['pilot_name'];
 348                                 } else {
 349                                         print _("N/A");
 350                                 }
 351                         }
 352                         print '</div>';
 353                         print '</div>';
 354                 }
 355
 356                 print '<div class="detail airline">';
 357                 print '<div class="title">'._("Airline").'</div>';
 358                 print '<div>';
 359                 if ($spotter_item['airline_name'] != "")
 360                 {
 361                         print '<a href="'.$globalURL.'/airline/'.$spotter_item['airline_icao'].'">'.$spotter_item['airline_name'].'</a>';
 362                 } else {
 363                         print _("N/A");
 364                 }
 365                 print '</div>';
 366                 print '</div>';
 367
 368                 print '<div class="detail aircraft">';
 369                 print '<div class="title">'._("Aircraft").'</div>';
 370                 print '<div>';
 371                 if ($spotter_item['aircraft_name'] != "")
 372                 {
 373                         print '<a href="'.$globalURL.'/aircraft/'.$spotter_item['aircraft_type'].'">'.$spotter_item['aircraft_name'].' ('.$spotter_item['aircraft_type'].')</a>';
 374                 } else {
 375                         if ($spotter_item['aircraft_type'] != "")
 376                         {
 377                                 print $spotter_item['aircraft_type'];
 378                         } else {
 379                                 print _("N/A");
 380                         }
 381                 }
 382                 print '</div>';
 383                 print '</div>';
 384
 385                 print '<div class="detail registration">';
 386                 print '<div class="title">'._("Registration").'</div>';
 387                 print '<div>';
 388                 if ($spotter_item['registration'] != "")
 389                 {
 390                         print '<a href="'.$globalURL.'/registration/'.$spotter_item['registration'].'">'.$spotter_item['registration'].'</a>';
 391                 } else {
 392                         print 'N/A';
 393                 }
 394                 print '</div>';
 395                 print '</div>';
 396
 397                 if ($spotter_item['departure_airport'] != 'NA') {
 398                         print '<div class="detail departure">';
 399                         print '<div class="title">'._("Departure Airport").'</div>';
 400                         print '<div>';
 401                         if ($spotter_item['departure_airport_name'] != "")
 402                         {
 403                                 print '<a href="'.$globalURL.'/airport/'.$spotter_item['departure_airport'].'">'.$spotter_item['departure_airport_city'].', '.$spotter_item['departure_airport_name'].', '.$spotter_item['departure_airport_country'].' ('.$spotter_item['departure_airport'].')</a>';
 404                         } else {
 405                                 print $spotter_item['departure_airport'];
 406                         }
 407                         print '</div>';
 408                         if (isset($spotter_item['departure_airport_time']) && $spotter_item['departure_airport_time'] != '') {
 409                                 if ($spotter_item['departure_airport_time'] > 2460) {
 410                                         print '<div class="time">';
 411                                         print 'at '.date('H:m',$spotter_item['departure_airport_time']);
 412                                         print '</div>';
 413                                 } else {
 414                                         print '<div class="time">';
 415                                         print 'at '.$spotter_item['departure_airport_time'];
 416                                         print '</div>';
 417                                 }
 418                         }
 419                         print '</div>';
 420                 }
 421
 422                 if ($spotter_item['arrival_airport'] != 'NA') {
 423                         print '<div class="detail arrival">';
 424                         print '<div class="title">'._("Arrival Airport").'</div>';
 425                         print '<div>';
 426                         if ($spotter_item['arrival_airport_name'] != "")
 427                         {
 428                                 print '<a href="'.$globalURL.'/airport/'.$spotter_item['arrival_airport'].'">'.$spotter_item['arrival_airport_city'].', '.$spotter_item['arrival_airport_name'].', '.$spotter_item['arrival_airport_country'].' ('.$spotter_item['arrival_airport'].')</a>';
 429                         } else {
 430                                 print $spotter_item['arrival_airport'];
 431                         }
 432                         print '</div>';
 433                         if (isset($spotter_item['arrival_airport_time']) && $spotter_item['arrival_airport_time'] != '') {
 434                                 print '<div class="time">';
 435                                 print 'at '.$spotter_item['arrival_airport_time'];
 436                                 print '</div>';
 437                         } elseif (isset($spotter_item['real_arrival_airport_time']) && $spotter_item['real_arrival_airport_time'] != '') {
 438                                 print '<div class="time">';
 439                                 print 'at '.$spotter_item['real_arrival_airport_time'];
 440                                 print '</div>';
 441                         }
 442                         print '</div>';
 443                 }
 444
 445                 if ($spotter_item['waypoints'] != "" || (isset($spotter_item['route_stop']) && $spotter_item['route_stop'] != ""))
 446                 {
 447                         print '<div class="detail coordinates">';
 448                         print '<div class="title">'._("Route").'</div>';
 449                         print '<div>';
 450                         if ($spotter_item['waypoints'] != "")
 451                         {
 452                                 print $spotter_item['waypoints'];
 453                         } elseif ($spotter_item['route_stop'] != "")
 454                         {
 455                                 print $spotter_item['route_stop'];
 456                         }
 457                         print '</div>';
 458                         print '</div>';
 459                 }
 460                 print '</div>';
 461
 462                 print '<div class="details">';
 463                 print '<h3>Additional information as it flew nearby</h3>';
 464                 if ($spotter_item['latitude'] != 0 && $spotter_item['longitude'] != 0) {
 465                         print '<div class="detail speed">';
 466                         print '<div class="title">'._("Ground Speed").'</div>';
 467                         print '<div>';
 468                         if (isset($spotter_item['last_ground_speed']) && $spotter_item['last_ground_speed'] != '') {
 469                                 if ((!isset($_COOKIE['unitspeed']) && isset($globalUnitSpeed) && $globalUnitSpeed == 'mph') || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'mph')) {
 470                                         print round($spotter_item['last_ground_speed']*1.15078).' mph';
 471                                 } elseif ((!isset($_COOKIE['unitspeed']) && isset($globalUnitSpeed) && $globalUnitSpeed == 'knots') || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'knots')) {
 472                                         print $spotter_item['last_ground_speed'].' knots';
 473                                 } else {
 474                                         print round($spotter_item['last_ground_speed']*1.852).' km/h';
 475                                 }
 476                         } else {
 477                                 if ((!isset($_COOKIE['unitspeed']) && isset($globalUnitSpeed) && $globalUnitSpeed == 'mph') || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'mph')) {
 478                                         print round($spotter_item['ground_speed']*1.15078).' mph';
 479                                 } elseif ((!isset($_COOKIE['unitspeed']) && isset($globalUnitSpeed) && $globalUnitSpeed == 'knots') || (isset($_COOKIE['unitspeed']) && $_COOKIE['unitspeed'] == 'knots')) {
 480                                         print $spotter_item['ground_speed'].' knots';
 481                                 } else {
 482                                         print round($spotter_item['ground_speed']*1.852).' km/h';
 483                                 }
 484                 }
 485                 print '</div>';
 486                 print '</div>';
 487
 488                 print '<div class="detail heading">';
 489                 print '<div class="title">'._("Heading (degrees)").'</div>';
 490                 print '<div>';
 491                 print $spotter_item['heading'].' ('.$spotter_item['heading_name'].')';
 492                 print '</div>';
 493                 print '</div>';
 494
 495                 print '<div class="detail altitude">';
 496                 print '<div class="title">'._("Altitude").'</div>';
 497                 print '<div>';
 498                 if (isset($spotter_item['last_altitude']) && $spotter_item['last_altitude'] != '') {
 499                         if ((!isset($_COOKIE['unitaltitude']) && isset($globalUnitAltitude) && $globalUnitAltitude == 'feet') || (isset($_COOKIE['unitaltitude']) && $_COOKIE['unitaltitude'] == 'feet')) {
 500                                 print number_format($spotter_item['last_altitude'].'00').' feet';
 501                         } else {
 502                                 print round($spotter_item['last_altitude']*30.48).' m';
 503                         }
 504                 } else {
 505                         if ((!isset($_COOKIE['unitaltitude']) && isset($globalUnitAltitude) && $globalUnitAltitude == 'feet') || (isset($_COOKIE['unitaltitude']) && $_COOKIE['unitaltitude'] == 'feet')) {
 506                                 print number_format($spotter_item['altitude'].'00').' feet';
 507                         } else {
 508                                 print round($spotter_item['altitude']*30.48).' m';
 509                         }
 510                 }
 511                 print '</div>';
 512                 print '</div>';
 513
 514                 print '<div class="detail coordinates">';
 515                 print '<div class="title">'._("Coordinates").'</div>';
 516                 print '<div>';
 517                 //print '<a href="https://www.google.com/maps/place/'.$spotter_item['latitude'].','.$spotter_item['longitude'].'/@'.$spotter_item['latitude'].','.$spotter_item['longitude'].',10z" target="_blank">Lat: '.$spotter_item['latitude'].' Lng: '.$spotter_item['longitude'].'</a>';
 518                 if (isset($spotter_item['last_latitude']) && $spotter_item['last_latitude'] != '') {
 519                         print 'Lat: '.$spotter_item['last_latitude'].' Lng: '.$spotter_item['last_longitude'];
 520                 } else {
 521                         print 'Lat: '.$spotter_item['latitude'].' Lng: '.$spotter_item['longitude'];
 522                 }
 523                 print '</div>';
 524                 print '</div>';
 525                 }
 526                 print '<div class="detail date">';
 527                 print '<div class="title">'._("Date").' ('.$globalTimezone.')</div>';
 528                 print '<div>';
 529                 date_default_timezone_set($globalTimezone);
 530                 print '<a href="'.$globalURL.'/date/'.date("Y-m-d", strtotime($spotter_item['date_iso_8601'])).'">'.date("M j, Y g:i a", strtotime($spotter_item['date_iso_8601'])).'</a>';
 531                 print '</div>';
 532                 print '</div>';
 533
 534                 print '<div class="detail date">';
 535                 print '<div class="title">'._("Date").' (UTC)</div>';
 536                 print '<div>';
 537                 date_default_timezone_set('UTC');
 538                 print date("M j, Y G:i", strtotime($spotter_item['date_iso_8601']));
 539                 print '</div>';
 540                 print '</div>';
 541
 542                 if (isset($spotter_item['duration'])) {
 543                         print '<div class="detail duration">';
 544                         print '<div class="title">'._("Flight spotted duration").'</div>';
 545                         print '<div>';
 546                         date_default_timezone_set('UTC');
 547                         print date("H:m:s", strtotime($spotter_item['duration']));
 548                         print '</div>';
 549                         print '</div>';
 550                 }
 551
 552                 if (isset($spotter_item['departure_airport']) && $spotter_item['departure_airport'] != '' && $spotter_item['departure_airport'] != 'NA' && $spotter_item['latitude'] != 0 && $spotter_item['longitude'] != 0) {
 553                         print '<div class="detail distance-departure">';
 554                         print '<div class="title">'._("Distance from Departure Airport").'</div>';
 555                         print '<div>';
 556                         $Common = new Common();
 557                         $departure_airport_info = $Spotter->getAllAirportInfo($spotter_item['departure_airport']);
 558                         if (count($departure_airport_info) > 0) {
 559                                 if (isset($spotter_item['last_latitude']) && $spotter_item['last_latitude'] != '') {
 560                                         if ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'nm') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'nm')) {
 561                                                 print $Common->distance($spotter_item['last_latitude'],$spotter_item['last_longitude'],$departure_airport_info[0]['latitude'],$departure_airport_info[0]['longitude'],'nm').' nm';
 562                                         } elseif ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'mi') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'mi')) {
 563                                                 print $Common->distance($spotter_item['last_latitude'],$spotter_item['last_longitude'],$departure_airport_info[0]['latitude'],$departure_airport_info[0]['longitude'],'mi').' mi';
 564                                         } else {
 565                                                 print $Common->distance($spotter_item['last_latitude'],$spotter_item['last_longitude'],$departure_airport_info[0]['latitude'],$departure_airport_info[0]['longitude'],'km').' km';
 566                                         }
 567                                 } else {
 568                                         if ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'nm') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'nm')) {
 569                                                 print $Common->distance($spotter_item['latitude'],$spotter_item['longitude'],$departure_airport_info[0]['latitude'],$departure_airport_info[0]['longitude'],'nm').' nm';
 570                                         } elseif ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'mi') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'mi')) {
 571                                                 print $Common->distance($spotter_item['latitude'],$spotter_item['longitude'],$departure_airport_info[0]['latitude'],$departure_airport_info[0]['longitude'],'mi').' mi';
 572                                         } else {
 573                                                 print $Common->distance($spotter_item['latitude'],$spotter_item['longitude'],$departure_airport_info[0]['latitude'],$departure_airport_info[0]['longitude'],'km').' km';
 574                                         }
 575                                 }
 576                         }
 577                         print '</div>';
 578                         print '</div>';
 579                 }
 580                 if (isset($spotter_item['arrival_airport']) && $spotter_item['arrival_airport'] != '' && $spotter_item['arrival_airport'] != 'NA' && $spotter_item['latitude'] != 0 && $spotter_item['longitude'] != 0) {
 581                         print '<div class="detail distance-arrival">';
 582                         print '<div class="title">'._("Distance to Arrival Airport").'</div>';
 583                         print '<div>';
 584                         $Common = new Common();
 585                         $arrival_airport_info = $Spotter->getAllAirportInfo($spotter_item['arrival_airport']);
 586                         if (count($arrival_airport_info) > 0) {
 587                                 if (isset($spotter_item['last_latitude']) && $spotter_item['last_latitude'] != '') {
 588                                         if ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'nm') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'nm')) {
 589                                                 print $Common->distance($spotter_item['last_latitude'],$spotter_item['last_longitude'],$arrival_airport_info[0]['latitude'],$arrival_airport_info[0]['longitude'],'nm').' nm';
 590                                         } elseif ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'mi') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'mi')) {
 591                                                 print $Common->distance($spotter_item['last_latitude'],$spotter_item['last_longitude'],$arrival_airport_info[0]['latitude'],$arrival_airport_info[0]['longitude'],'mi').' mi';
 592                                         } else {
 593                                                 print $Common->distance($spotter_item['last_latitude'],$spotter_item['last_longitude'],$arrival_airport_info[0]['latitude'],$arrival_airport_info[0]['longitude'],'km').' km';
 594                                         }
 595                                 } else {
 596                                         if ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'nm') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'nm')) {
 597                                                 print $Common->distance($spotter_item['latitude'],$spotter_item['longitude'],$arrival_airport_info[0]['latitude'],$arrival_airport_info[0]['longitude'],'nm').' nm';
 598                                         } elseif ((!isset($_COOKIE['unitdistance']) && isset($globalUnitDistance) && $globalUnitDistance == 'mi') || (isset($_COOKIE['unitdistance']) && $_COOKIE['unitdistance'] == 'mi')) {
 599                                                 print $Common->distance($spotter_item['latitude'],$spotter_item['longitude'],$arrival_airport_info[0]['latitude'],$arrival_airport_info[0]['longitude'],'mi').' mi';
 600                                         } else {
 601                                                 print $Common->distance($spotter_item['latitude'],$spotter_item['longitude'],$arrival_airport_info[0]['latitude'],$arrival_airport_info[0]['longitude'],'km').' km';
 602                                         }
 603                                 }
 604                         }
 605                         print '</div>';
 606                         print '</div>';
 607                 }
 608                 $LatestACARS = $ACARS->getLiveAcarsData($spotter_item['ident']);
 609                 if ($LatestACARS != '') {
 610                         print '<div class="detail acars">';
 611                         print '<div class="title">'._("Latest ACARS message").'</div>';
 612                         print '<div>';
 613                         print $LatestACARS;
 614                         print '</div>';
 615                         print '</div>';
 616                 }
 617                 print '</div>';
 618         }
 619         print '</div>';
 620
 621         print '<div id="archive-map"></div>';
 622         //print '<div id="live-map"></div>';
 623
 624         if ($spotter_array[0]['registration'] != "" && $spotter_array[0]['registration'] != "NA" && $spotter_array[0]['registration'] != "N/A")
 625         {
 626                 $registration = $spotter_array[0]['registration'];
 627                 print '<div class="last-flights">';
 628                 print '<h3>'._("Last 5 Flights of this Aircraft").' ('.$registration.')</h3>';
 629                 $hide_th_links = true;
 630                 $spotter_array = $Spotter->getSpotterDataByRegistration($registration,"0,5", "");
 631                 include('table-output.php');
 632                 print '<div class="more">';
 633                 print '<a href="'.$globalURL.'/registration/'.$registration.'" class="btn btn-default btn" role="button">See all Flights&raquo;</a>';
 634                 print '</div>';
 635                 print '</div>';
 636         }
 637 /*              ?>
 638              <div class="column">
 639
 640         <div class="share">
 641                 <span class='st_facebook' displayText='Facebook'></span>
 642                         <span class='st_twitter' displayText='Tweet'></span>
 643                         <span class='st_googleplus' displayText='Google +'></span>
 644                         <span class='st_pinterest' displayText='Pinterest'></span>
 645                         <span class='st_email' displayText='Email'></span>
 646         </div>
 647                 <script type="text/javascript">var switchTo5x=true;</script>
 648                 <script type="text/javascript" src="http://w.sharethis.com/button/buttons.js"></script>
 649                 <script type="text/javascript">stLight.options({publisher: "ur-5a9fbd4d-de8a-6441-d567-29163a2526c7", doNotHash: false, doNotCopy: false, hashAddressBar: false});</script>
 650
 651         <?php
 652     print '</div>';
 653 */
 654 } else {
 655         $title = "ID";
 656         require_once('header.php');
 657         print '<h1>'._("Error").'</h1>';
 658         print '<p>'._("Sorry, this flight is not anymore in the database. :(").'</p>';
 659 }
 660 require_once('footer.php');
 661 ?>