<td style="vertical-align:middle"><?php if (file_exists("logos/" . substr(mysql_result($query, $i, 'flightnumber'), 0, 3) . ".gif")) { ?> <img src="logos/<?php echo substr(mysql_result($query, $i, 'flightnumber'), 0, 3); ?> .gif"/><?php } ?> </td> <td style="vertical-align:middle"><?php echo mysql_result($query, $i, 'flightnumber'); ?> </td> <td style="vertical-align:middle"><?php echo aircraftname(mysql_result($query, $i, 'acft')); ?> </td> <td style="vertical-align:middle;text-align:center;"><?php if (mysql_result($query, $i, 'deptime') == "----") { echo "FROM"; } else { echo "TO"; } ?> </td> <td style="vertical-align:middle"><?php if (mysql_result($query, $i, 'deptime') == "----") { echo getCountry(mysql_result($query, $i, 'origin'), "alt", "24") . " " . mysql_result($query, $i, 'origin') . " - " . mysql_result($queryorig, 0, 'Name'); } else { echo getCountry(mysql_result($query, $i, 'destination'), "alt", "24") . " " . mysql_result($query, $i, 'destination') . " - " . mysql_result($querydest, 0, 'Name');
<td><b>Aircraft</b> <a href="http://www.airliners.net/search/photo.search?q=<?php echo str_ireplace(" ", "+", aircraftname(mysql_result($querymodal, 0, 'acft'))); ?> +<?php echo str_ireplace(" ", "+", airlinename(mysql_result($querymodal, 0, 'flightnumber'), "name")); ?> " target="_blank" style="color: #333;" onMouseOver="this.style.color='#F00'" onMouseOut="this.style.color='#333'"><i class="icon-camera" title="Click here to see pictures of this aircraft"></i></a></td> <td><b>Departure Time</b></td> <td><b>Arrival Time</b></td> </tr> <tr height="60px"> <td style="vertical-align: middle;"><span style="font-size: 30px;"><?php echo aircraftname(mysql_result($querymodal, 0, 'acft')); ?> </span><br/><span style="font-size: 10px;"><?php echo aircraftname(mysql_result($querymodal, 0, 'acft'), "name"); ?> </span></td> <td style="vertical-align: middle;"><span style="font-size: 30px; margin-top: 10px;"><?php if (mysql_result($querymodal, 0, 'deptime') != "----") { echo mysql_result($querymodal, 0, 'deptime'); } else { ?> <span style="color: red;"><?php echo timeOperation(mysql_result($querymodal, 0, 'arrtime'), flighttime(mysql_result($querymodal, 0, 'origin'), mysql_result($querymodal, 0, 'destination'), mysql_result($querymodal, 0, 'acft')), "diff"); ?> </span><?php } ?> </span><br/><span style="font-size: 10px;"><?php if (mysql_result($querymodal, 0, 'deptime') != "----") {
<td style="border-bottom: 1px solid #444"><b>Flight</b></td> <td style="border-bottom: 1px solid #444"><b>Departure</b></td> <td style="border-bottom: 1px solid #444"><b>Arrival</b></td> </tr> <tr height="60px"> <td style="vertical-align: middle;"><span style="font-size: 30px;">' . mysql_result($querymodal, 0, 'flightnumber') . '</span></td> <td style="vertical-align: middle;"><span style="font-size: 30px;"><img style="vertical-align: middle;" src="' . getCountry(mysql_result($querymodal, 0, 'origin'), 'norm', '48', 'full') . '"> ' . mysql_result($querymodal, 0, 'origin') . '</span><br/><span style="font-size: 10px;">' . mysql_result($queryorig, 0, 'Name') . '</span> <td style="vertical-align: middle;"><span style="font-size: 30px;"><img style="vertical-align: middle;" src="' . getCountry(mysql_result($querymodal, 0, 'destination'), 'norm', '48', 'full') . '"> ' . mysql_result($querymodal, 0, 'destination') . '</span><br/><span style="font-size: 10px;">' . mysql_result($querydest, 0, 'Name') . '</span> </tr> <tr style="border-bottom: 1px solid #444"> <td style="border-bottom: 1px solid #444"><b>Aircraft</b></td> <td style="border-bottom: 1px solid #444"><b>Departure Time</b></td> <td style="border-bottom: 1px solid #444"><b>Arrival Time</b></td> </tr> <tr height="60px"> <td style="vertical-align: middle;"><span style="font-size: 30px;">' . aircraftname(mysql_result($querymodal, 0, 'acft')) . '</span><br/><span style="font-size: 10px;">' . aircraftname(mysql_result($querymodal, 0, 'acft'), "name") . '</span></td> <td style="vertical-align: middle;"><span style="font-size: 30px;">'; if ($movement == "dep") { $msg .= mysql_result($querymodal, 0, 'slottime'); } else { $msg .= '<span style="color: red;">' . timeOperation(mysql_result($querymodal, 0, 'slottime'), flighttime(mysql_result($querymodal, 0, 'origin'), mysql_result($querymodal, 0, 'destination'), mysql_result($querymodal, 0, 'acft')), "diff") . '</span>'; } $msg .= '</span><br/><span style="font-size: 10px;">'; if ($movement == "dep") { $msg .= "ZULU"; } else { $msg .= '<span style="color: red;">ZULU (AUTOMATICALLY ESTIMATED)</span>'; } $msg .= '</span></td><td style="vertical-align: middle;"><span style="font-size: 30px;">'; if ($movement == "arr") { $msg .= mysql_result($querymodal, 0, 'slottime');
imagettftext($image, 7, 0, 220, 252, $font_color, $font_file_3, "DATA"); imagettftext($image, 11, 0, 220, 270, $black, $font_file_1, strtoupper(trim("RFE" . mysql_result($query, 0, "id")))); $flag = "../images/divlogous-sm.png"; $flag = imagecreatefrompng($flag); $insert_x = imagesx($flag); $insert_y = imagesy($flag); imagecopy($image, $flag, 721, 230, 0, 0, $insert_x, $insert_y); imagettftext($image, 5, 90, 789, 292, $font_color, $font_file_3, "IVAO United States"); imagettftext($image, 22, 0, 75, 330, $white, $font_file_2, $logo_message); $flag = "../images/divlogo/divlogo@55px.png"; $flag = imagecreatefrompng($flag); $insert_x = imagesx($flag); $insert_y = imagesy($flag); imagecopy($image, $flag, 8, 294, 0, 0, $insert_x, $insert_y); $filename = mysql_result($query, 0, 'flightnumber') . ".png"; $text = $logo_message . " | " . $eventdate . " | " . mysql_result($query, 0, 'flightnumber') . " | " . mysql_result($query, 0, 'origin') . "-" . mysql_result($query, 0, 'destination') . " | " . mysql_result($query, 0, 'reftime') . "Z | " . aircraftname(mysql_result($query, 0, 'acft')) . " | " . mysql_result($query, 0, 'name'); QRcode::png($text, $filename, "L", "2", 0); $flag = imagecreatefrompng($filename); imagecopy($image, $flag, 485, 220, 0, 0, 74, 74); unlink($filename); // Check if the airline has a logo and gets it. if (file_exists("../logos/" . substr(mysql_result($query, 0, 'flightnumber'), 0, 3) . ".gif")) { $flag = "../logos/" . substr(mysql_result($query, 0, 'flightnumber'), 0, 3) . ".gif"; $flag = imagecreatefromgif($flag); $insert_x = imagesx($flag); $insert_y = imagesy($flag); imagecopy($image, $flag, 706, 331, 0, 0, $insert_x, $insert_y); } header('Content-type: ' . $mime_type); ImagePNG($image); ImageDestroy($image);
</span><br/><span style="font-size: 10px;"><?php echo mysql_result($querydest, 0, 'Name'); ?> </span> </tr> <tr style="border-bottom: 1px solid #444"> <td><b>Aircraft</b></td> <td><b>Departure Time</b></td> <td><b>Arrival Time</b></td> </tr> <tr height="60px"> <td style="vertical-align: middle;"><span style="font-size: 30px;"><?php echo aircraftname(mysql_result($queryprvdet, $j, 'acft')); ?> </span><br/><span style="font-size: 10px;"><?php echo aircraftname(mysql_result($queryprvdet, $j, 'acft'), "name"); ?> </span></td> <td style="vertical-align: middle;"><span style="font-size: 30px; margin-top: 10px;"><?php if ($movement == 'dep') { echo mysql_result($queryprvdet, $j, 'slottime'); } else { ?> <span style="color: red;"><?php echo timeOperation(mysql_result($queryprvdet, $j, 'slottime'), flighttime(mysql_result($queryprvdet, $j, 'origin'), mysql_result($queryprvdet, $j, 'destination'), mysql_result($queryprvdet, $j, 'acft')), "diff"); ?> </span><?php } ?> </span><br/><span style="font-size: 10px;"><?php if ($movement == 'dep') {
<td><b>Aeronave</b> <a href="http://www.airliners.net/search/photo.search?q=<?php echo str_ireplace(" ", "+", aircraftname(mysql_result($queryturnover, 0, 'acft'))); ?> +<?php echo str_ireplace(" ", "+", airlinename(mysql_result($queryturnover, 0, 'flightnumber'), "name")); ?> " target="_blank" style="color: #333;" onMouseOver="this.style.color='#ee5f5b'" onMouseOut="this.style.color='#333'"><i class="fa fa-camera" title="Click here to see pictures of this aircraft"></i></a></td> <td><b>Hora Salida</b></td> <td><b>Hora Llegada</b></td> </tr> <tr height="60px"> <td style="vertical-align: middle;"><span style="font-size: 30px;"><?php echo aircraftname(mysql_result($queryturnover, 0, 'acft')); ?> </span><br/><span style="font-size: 10px;"><?php echo aircraftname(mysql_result($queryturnover, 0, 'acft'), "name"); ?> </span></td> <td style="vertical-align: middle;"><span style="font-size: 30px; margin-top: 10px;"><?php if (mysql_result($queryturnover, 0, 'deptime') != "----") { echo mysql_result($queryturnover, 0, 'deptime'); } else { ?> <span style="color: red;"><?php echo timeOperation(mysql_result($queryturnover, 0, 'arrtime'), flighttime(mysql_result($queryturnover, 0, 'origin'), mysql_result($queryturnover, 0, 'destination'), mysql_result($queryturnover, 0, 'acft')), "diff"); ?> </span><?php } ?> </span><br/><span style="font-size: 10px;"><?php if (mysql_result($queryturnover, 0, 'deptime') != "----") {