Live Flight's Board

kokosik7 · December 5, 2010

Hello

We are looking for a Live Flight's Board like that on frontpage http://www.airberlinva.de/ .. We were searching on forum but nothing there...

Maby someone have that script or know how to do that...

kokosik7 · December 5, 2010

OK delete we made it

http://entis.ionic.pl/eurolot/

ACVA_CEO · December 9, 2010

would you mind sharing how you did that?

airberlin virtual · December 14, 2010

would you mind sharing how you did that?

Hey,

Nice to see someone wants this.

you can find the code here Pastebin Code.

We have also included the FS Flight Keeper Functions although we have installed the SDK and use its own Databases because it will not send the Aircraft Type to the PHPVMS Database.

So now it shows two seperate Systems in one display FSFK Flights have a * added to the Flight Number and PHPVMS Flights are reported without a *.

If you need any other help let me know.

BastiDE · December 14, 2010

dont know how to use this with my site and with kACARS. Can one help me?

    <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%;"> </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>

ACVA_CEO · December 14, 2010

hey thanks for sharing....however I couldn't get it to work...it kept taking over the page.

airberlin virtual · December 14, 2010

Forgot to put instructions on where to put this.

This should replace everything in /lib/skins/yourskin/frontpage_recentbids.tpl

then you will have to activate this for the homepage by adding

MainController::Run('FrontBids', 'RecentFrontPage', 50);

and position it where you want it to show up in frontpage_main.tpl and it will work like a charm.

I will say it again if you do not have the FS Flight Keeper SDK installed you will have to comment the Flight Keeper Parts out of the script other than that it will work just as good as it works on our site.

ACVA_CEO · December 15, 2010

thanks for the how to....lol....I'll give it a shot now.

BastiDE · December 15, 2010

i dont know what i have to do with kACARS. Can one help me?

December 15, 2010

mysql_connect('localhost', 'xxx', 'xxx');

what I do in there???? DB-user? Passwort? or database?

ACVA_CEO · December 15, 2010

i dont know what i have to do with kACARS. Can one help me?

you don't need to do anything with Kacars.....the tpl connects to kacars and displays current flights.

ACVA_CEO · December 15, 2010

mysql_connect('localhost', 'xxx', 'xxx');

what I do in there???? DB-user? Passwort? or database?

You only need to put information in if you are using FSFK, otherwise just comment it out

mark1million · December 15, 2010

The easiest way to get this is look at your existing acars file and copy all the code except the map display Whalla all your flights are displayed

BastiDE · December 16, 2010

You only need to put information in if you are using FSFK, otherwise just comment it out

how do you mean it? Can you give an example?

The easiest way to get this is look at your existing acars file and copy all the code except the map display Whalla all your flights are displayed

But i find the other board better. ^^

airberlin virtual · December 22, 2010

how do you mean it? Can you give an example?

But i find the other board better. ^^

If you do not use Flight Keeper from Aerosoft for your Pilots then you do not have to use this at all and can uncomment the lines that have to do with flight keeper

Andy · January 1, 2011

If you do not use Flight Keeper from Aerosoft for your Pilots then you do not have to use this at all and can uncomment the lines that have to do with flight keeper

Happy new year @ all!

Hi Chris, congrats to AB VA! Looks nice!

I start now with FSFK integration to my va. What parts youÂ´ve used from the FSFK Integration pack? only SQL-Tables? you integrate the fsfk sql-tables into your main phpvms database or to an extra db?

Thx for help.

Regards

Andreas Romahn

RogerB · January 2, 2011

Yeah, I would not recommend using the code he posted with your database info there, not smart. Just do what Mark said, much safer.

Andy · January 3, 2011

Yeah, I would not recommend using the code he posted with your database info there, not smart. Just do what Mark said, much safer.

I tried but doesnÂ´t work on frontpage_main.tpl. I paste the code without the part of the acars map, but nothing show up. maybe i forgot something.

davehardy · January 8, 2011

Ive got it working except these 2 errors, any ideas?

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/easternv/public_html/eva/lib/skins/eva/frontpage_recentbids.tpl on line 10

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/easternv/public_html/eva/lib/skins/eva/frontpage_recentbids.tpl on line 47

dimitris · January 8, 2011

Hello all !

I have figure out a way to get the traffic (NO need to have FSpax,FSFK,kACARS etc) from IVAO (still working to find a way for VATSIM) you can see demo here: http://www.greeceairwaysva.com/fss/index.php/online

i m waiting the approval from IVAO LD to release this for every one ! Say tunned !

Txmmy83 · January 8, 2011

I get this error warning but dont know whats wrong with my modified code of the Air Berlin Live Board I get only that error it works but it would be nice if someone could help me to get rid of that error!

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/simaerobatic/htdocs/AMI/lib/skins/brilliancev111/frontpage_recentbids.tpl on line 43

I deleted all Flight Keeper related maybe deleted too much?

<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;
   }
   ?>
   <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%;"> </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 > 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('amiva_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 /></i></p>

if I discovered right the status did not self refresh till you click site refresh right!?

hollinst · January 10, 2011

Does this work with FSPassengers flights also? Or just the FSACARS flights like the live map?

Chaz · January 29, 2011

Really great utility this - congrats all round!

Just a quick Q though... it only seems to display the aircraft for FSFK flights, the readout is blank for kACARS, FSACARS etc.

I presume it's because there's no 'aircraftname' field in the _acarsdata table.

Is there a work around for this? Cheers!

(edit to add) Actually, I don't think I've got the whole thing working at all (I'm still getting '0' lines when using FSFK now - I don't think it's pulling the data from the flkeeper database. I've double checked all my paths etc. are correct. I was sure the first time I did it it worked (hence my original question).

TBH I've been trying to find a solution all day & quite frankly I'm completely stumped & more than a little frustrated!

Still have to say the flight board looks great tho!

Andy · February 10, 2011

Really great utility this - congrats all round!

Just a quick Q though... it only seems to display the aircraft for FSFK flights, the readout is blank for kACARS, FSACARS etc.

I presume it's because there's no 'aircraftname' field in the _acarsdata table.

Is there a work around for this? Cheers!

(edit to add) Actually, I don't think I've got the whole thing working at all (I'm still getting '0' lines when using FSFK now - I don't think it's pulling the data from the flkeeper database. I've double checked all my paths etc. are correct. I was sure the first time I did it it worked (hence my original question).

TBH I've been trying to find a solution all day & quite frankly I'm completely stumped & more than a little frustrated!

Still have to say the flight board looks great tho!

i got the same issue with the "0" when using FSFK. I tried out a lot, but nothing work. IÂ´ve genarated a stand alone db for fsfk and use the fsfk integration stuff, maybee i used on the wrong places.

Andreas

RogerB · March 3, 2011

Last code doesn't work, and it jacks up my front page. Not sure why

Sascha (DCS299) · March 3, 2011

Hello all !

I have figure out a way to get the traffic (NO need to have FSpax,FSFK,kACARS etc) from IVAO (still working to find a way for VATSIM) you can see demo here: http://www.greeceairwaysva.com/fss/index.php/online

i m waiting the approval from IVAO LD to release this for every one ! Say tunned !

Any news on this? Would be great because we use a similar system at the moment!

RogerB · March 3, 2011

For vatsim you need vatsimphp on your site...It appears he closed his site for now. I can give you the files if you like...

Txmmy83 · March 4, 2011

you can try my version where I have eliminated fsfk parts of code

if I know how we can made it self refreshing when on frontpage without reloading whole site it would be perfect!

if anyone has an idea please let me know

layout is styled to that which was used at airberlinva

http://school.simaerobatic.com/liveboard.zip

you can see it in action here (works 100% but at the moment it is not automatic refreshing!)

http://flyeurope-va.org

Best Regards

Thomas

TAV1702 · March 4, 2011

you can try my version where I have eliminated fsfk parts of code

if I know how we can made it self refreshing when on frontpage without reloading whole site it would be perfect!

if anyone has an idea please let me know

layout is styled to that which was used at airberlinva

http://school.simaerobatic.com/liveboard.zip

you can see it in action here (works 100% but at the moment it is not automatic refreshing!)

http://flyeurope-va.org

Best Regards

Thomas

Hi Thomas. The link to your file is dead. That is exactly what I was looking for a week or two ago.

Sascha (DCS299) · March 4, 2011

For vatsim you need vatsimphp on your site...It appears he closed his site for now. I can give you the files if you like...

IVAO would be fine

Sign In

Live Flight's Board

Recommended Posts

kokosik7

kokosik7

ACVA_CEO

airberlin virtual

BastiDE

ACVA_CEO

airberlin virtual

ACVA_CEO

BastiDE

Guest FWX001

ACVA_CEO

ACVA_CEO

mark1million

BastiDE

airberlin virtual

Andy

RogerB

Andy

davehardy

dimitris

Txmmy83

hollinst

Chaz

Andy

RogerB

Sascha (DCS299)

RogerB

Txmmy83

TAV1702

Sascha (DCS299)

Join the conversation