airberlin Live Departure/Arrival Board

<h3 style="text-align: center;">Flight Departures Board</h3>
<?php
if(!$lastbids) {
echo '<p align="center">There are currently no booked flights!</p></div>';
return;
}
mysql_connect('localhost', 'xxx', 'xxx');
mysql_select_db('flkeeper');
$result = mysql_query("SELECT * FROM liveacars");
$fsfk = mysql_num_rows($result);
?>
<center>
<table cellspacing="0" cellpadding="0" style="border:1px solid grey;">
    <thead>
        <tr style="font-size:14px; font-weight:bold;">
            <th align="center" style="background-color: #1F1F1F; width: 3.5%;">&nbsp;</th>
            <th align="center" style="background-color: #1F1F1F; width: 10%;"><font color="#ff8710"><b>Flight</b></font></th>
            <th align="center" style="background-color: #1F1F1F; width: 30%;"><font color="#ff8710"><b>Departing</b></font></th>
            <th align="center" style="background-color: #1F1F1F; width: 30%;"><font color="#ff8710"><b>Arriving</b></font></th>
            <th align="center" style="background-color: #1F1F1F; width: 5%"><font color="#ff8710"><b>Aircraft</b></font></th>
            <th align="center" style="background-color: #1F1F1F; width: 18.5%;"><font color="#ff8710"><b>Status</b></font></th>
        </tr>
    </thead>
    <tbody>
    <?php
        $flights = ACARSData::GetACARSData();
        if ($flights OR $fsfk > 0) {
            if($flights) {
            foreach($flights as $flight) {
                   $pid = $flight->pilotid + 100;?>
            <tr style="height:12px; font-size:14px; font-weight:normal;">
                <td align="center" valign="middle" style="background-color: #1F1F1F; padding: 1px;"><?php if($flight->phasedetail == "Boarding") { echo "<img style='padding-left:3px;' src='http://www.airberlinva.de/lib/skins/airberlin/images/dots_blink.gif'>"; } elseif($flight->phasedetail == "Arrived") { echo "<img style='padding-left:3px;' src='http://www.airberlinva.de/lib/skins/airberlin/images/dots.gif'>"; } elseif($flight->phasedetail == "On Approach") { echo "<img style='padding-left:3px;' src='http://www.airberlinva.de/lib/skins/airberlin/images/dots_yellow.gif'>"; } ?></td>
                <td align="center" valign="middle" style="background-color: #1F1F1F;"><font color="#ff961e"><?php echo $flight->flightnum?></td>
                <td align="center" valign="middle" style="background-color: #1F1F1F; padding-right: 5px;"><font color="#ff961e"> <?php echo $flight->depapt?></td>
                <td align="center" valign="middle" style="background-color: #1F1F1F; padding-right: 5px;"><font color="#ff961e"> <?php echo $flight->arrapt?></td>
                <td align="center" valign="middle" style="background-color: #1F1F1F; padding-right: 0px;"><font color="#ff961e"> <?php echo $flight->aircraftname?> </td>
                <td
align="center" valign="middle"
style="background-color: #1F1F1F;"><font
color="#ff961e"><?php if($flight->phasedetail
!= 'Paused') { echo $flight->phasedetail; }
else { echo "Cruise"; } ?></font></td>
            </tr>
            <?php
            }
            }
            while($row = mysql_fetch_assoc($result)) {
            mysql_select_db('berlin_vms');
            $dep = mysql_fetch_assoc(mysql_query("SELECT name FROM phpvms_airports WHERE icao = '$row[OriginAirport]'"));
            $arr = mysql_fetch_assoc(mysql_query("SELECT name FROM phpvms_airports WHERE icao = '$row[DestinationAirport]'"));
            $row['OriginAirport'];
            ?>
            <tr style="height:12px; font-size:14px; font-weight:normal;">
                <td align="center" valign="middle" style="background-color: #1F1F1F; padding: 1px;"><?php if($row['Status'] == 0) { echo "<img style='padding-left:3px;' src='http://www.airberlinva.de/lib/skins/airberlin/images/dots_blink.gif'>"; } elseif($row['Status'] == 4) { echo "<img style='padding-left:3px;' src='http://www.airberlinva.de/lib/skins/airberlin/images/dots.gif'>"; } elseif($row['Status'] == 3) { echo "<img style='padding-left:3px;' src='http://www.airberlinva.de/lib/skins/airberlin/images/dots_yellow.gif'>"; }?></td>
                <td align="center" valign="middle" style="background-color: #1F1F1F;"><font color="#ff961e"><?php echo $row['FlightNumber']; ?>*</td>
                <td align="center" valign="middle" style="background-color: #1F1F1F; padding-right: 5px;"><font color="#ff961e"> <?php echo utf8_encode($dep['name']); ?></td>
                <td align="center" valign="middle" style="background-color: #1F1F1F; padding-right: 5px;"><font color="#ff961e"> <?php echo utf8_encode($arr['name']); ?></td>
                <td align="center" valign="middle" style="background-color: #1F1F1F; padding-right: 0px;"><font color="#ff961e"> <?php echo $row['Aircraft']; ?> </td>
                <td align="center" valign="middle" style="background-color: #1F1F1F;"><font color="#ff961e"><?php  if($row['Status'] == 0) { echo "Boarding"; } elseif($row['PauseMode'] != 0) { echo "Paused"; } elseif($row['Status'] == 1) { echo "Taxiing to Runway"; } elseif($row['Status'] == 2 && $row['AltitudeStatus'] == 1) { echo "Cruise"; } elseif($row['Status'] == 2 && $row['AltitudeStatus'] == 2) { echo "Climbing"; } elseif($row['Status'] == 2 && $row['AltitudeStatus'] == 0) { echo "Descending"; } elseif($row['Status'] == 3) { echo "Taxiing to Gate"; } elseif($row['Status'] == 4) { echo "Arrived"; } ?></font></td>
            </tr>
            <?php
            }
        } else { ?>
            <tr><td width="20%" align="center" colspan="6" style="padding: 5px; font-size: 13px; font-weight: bold; color: #ff961e;">No Flights in Progress!</td></tr>
        <?php
        }
        ?>
    </tbody>
</table>
<p><i>The actual, flights and flights completed in the last <?php echo Config::Get('ACARS_LIVE_TIME') ?> minutes.<br />*Flight with FSFlightkeeper</i></p>