<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') != "----") {