Pilots in individual hubs [SOLVED]

[NAdams]

This may have been answered somewhere but I couldn't find it

Is there a way to divide the pilots list into hubs and put just the pilot list for that hub into a page created for that hub

In other words, I made a hub page "KCLT". Is there a way of taking just the pilots that are in KCLT and displaying them in a table on that page?

[TAV1702]

I put my search skills to use by clicking the search button and this result came up. You will need to skin it to your liking. Hope this helps.

http://forum.phpvms.net/topic/3970-pilot-hub-list/

[NAdams]

I put my search skills to use by clicking the search button and this result came up. You will need to skin it to your liking. Hope this helps.

http://forum.phpvms.net/topic/3970-pilot-hub-list/

true, i saw that, i was a bit confused on where to put that code, beacuse it doesn't work on the "page" source area.

also, i went to his va and saw the pilots still displayed on on page, so i am wondering if he got it to work

http://www.greeceairwaysva.com/fss/index.php/pilots

[dimitris]

yes www.greeceairwaysva.com is my va i got it working. On pilot list i have listed all the pilots to my va but i have make some pages like:

http://www.greeceairwaysva.com/fss/index.php/lgtshub

http://www.greeceairwaysva.com/fss/index.php/lgavhub

http://www.greeceairwaysva.com/fss/index.php/eddfhub

listing only the pilots per hub and some general info for the hubs

if you need any help reply here

[NAdams]

cool, thats' exactly what i want to do

i am not sure where to put the code....did you post it in the a page you created in the admin panel of phpvms, or did you create another php page and post there

i you could give me your code so i can copy and paste, that would be awesome

thanks

[dimitris]

i have create a folder in core->modules and i name it eddfhub inside this folder i make a .php file names eddfhub.php inside the file i have this code:

<?php
class eddfhub extends CodonModule
{

       public function index()
       {    
       Template::Show('eddf_hub.tpl');
       }
}

?>

and i have one .tpl file in my skin folder named eddfhub.tpl and inside this file i have the following code:

<h3>Rhein-Main-Flughafen Frankfurt am Main  (EDDF)</h3>
<link href="table.css" rel="stylesheet" type="text/css" />
<?php $pilots = PilotData::getAllPilotsByHub('EDDF'); ?>
<table width="800" border="0">
 <tr>
   <td style="vertical-align:top" width="350"><table width="350" border="0">
   <tr>
       <th class="tableOdd">Pilot</th>
       <th class="tableOdd">Country</th>
       <th class="tableOdd">Rank</th>
   </tr>
   <?php
   foreach ($pilots as $pilot) {
   ?>
       <tr>
           <th align="left"><?php echo PilotData::GetPilotCode($pilot->code, $pilot->pilotid); ?> | <?php echo $pilot->firstname.' '.$pilot->lastname?></th>
           <th><img src="<?php echo Countries::getCountryImage($pilot->location); ?>"
                    alt="<?php echo Countries::getCountryName($pilot->location); ?>" /></th>
           <th><img src="<?php echo $pilot->rankimage ?>" alt="<?php echo $pilot->rank; ?>" /></th>
       </tr>
   <?php
   }
   ?>
</table>
</td>
   <td width="41"> </td>
   <td style="vertical-align:top" width="395">Frankfurt am Main Airport (IATA: FRA, ICAO: EDDF), known in German as Flughafen Frankfurt am Main or Rhein-Main-Flughafen is a major international airport located in Frankfurt am Main, Germany, 12 km (7.5 mi) southwest of the city centre.Run by Fraport, it is by far the busiest airport by passenger traffic in Germany, the third busiest in Europe and the ninth busiest worldwide in 2009. It serves the most international destinations in the world and is the busiest airport in Europe by cargo traffic. The southern side of the airport, Rhein-Main Air Base, was a major airlift base for the United States from 1947 until late 2005, when it was acquired by Fraport.The airport is directly located in the Frankfurt/Rhine-Main region, Germany's second largest metropolitan region, which itself has a central location in the densely populated region of the west-central European megalopolis. Thereby, along with a strong rail and motorway connection, the airport serves as a major transportation hub to the greater region, less than two hours by ground to Cologne, the Ruhr Area, and Stuttgart.There are plans to expand Frankfurt Airport with a fourth runway and a new Terminal 3. First modifications to the airport to make it Airbus A380 compatible are completed, including the first building of a large A380 maintenance facility near the former U.S. Air Base. The work on the fourth runway has been delayed several times due to environmental concerns, but received zoning approval in December 2007. The runway should go into operation in 2011.
       <table width= "590" border="0">
 <tr>
   <td><h3>Hub Manager:</h3></td>
   </tr>
 <tr>
   <td><p>GRW013 | Dimitris Spritos <img src="http://www.greeceairwaysva.com/fss/lib/images/countries/gr.png" width="16" height="11" /></p></td>
   </tr>
   </table>
</td>
 </tr>
 <tr>
   <td> </td>
   <td> </td>
   <td><table width= "590" border="0">
 <tr>
   <td colspan="2"><h3>Hub Gates:</h3></td>
   </tr>
 <tr>
   <td><p><strong>V126,V128,V130</strong></p></td>
   <td><a href="http://greeceairwaysva.com/downloads/eddfhub.jpeg">Map</a></td>
   </tr>
   </table></td>
 </tr>
 <tr>
   <td> </td>
   <td> </td>
   <td> </td>
 </tr>
 <tr>
   <td> </td>
   <td> </td>
   <td> </td>
 </tr>
 <tr>
   <td> </td>
   <td> </td>
   <td> </td>
 </tr>
 <tr>
   <td> </td>
   <td> </td>
   <td> </td>
 </tr>
</table>

All the above for the EDDF Frankfurt Am Main airport. You can edit and play with the code until you find the best for you

[TAV1702]

yes www.greeceairwaysva.com is my va i got it working. On pilot list i have listed all the pilots to my va but i have make some pages like:

http://www.greeceairwaysva.com/fss/index.php/lgtshub

http://www.greeceairwaysva.com/fss/index.php/lgavhub

http://www.greeceairwaysva.com/fss/index.php/eddfhub

listing only the pilots per hub and some general info for the hubs

if you need any help reply here

That's actually pretty slick. I have been wanting to do something up like this or like Simpilot has his. I just never got around to it yet. Good job guys. Its looking pretty sweet so far.

[NAdams]

is there another line of code i need....when i put all the info in, create the folder and the php file inside, then i create the .tpl file and our info in

i get this box at the top of the main site that has the php code

[dimitris]

is there another line of code i need....when i put all the info in, create the folder and the php file inside, then i create the .tpl file and our info in

i get this box at the top of the main site that has the php code

hi ! Can you attach your files to check please ?

[NAdams]

yep, here it is

i made a php file called "kclthub" and put it in the folder core--->modules---->kclthub

<?php
class kclthub extends CodonModule
{

        public function index()
        {    
        Template::Show('kclt_hub.tpl');
        }
}

?>

then i made a .tpl file called "kclt_hub.tpl" and put it in the skin folder

<h3>Charlotte Douglas International Airport  (KCLT)</h3>
<link href="table.css" rel="stylesheet" type="text/css" />
<?php $pilots = PilotData::getAllPilotsByHub('KCLT'); ?>
<table width="800" border="0">
  <tr>
    <td style="vertical-align:top" width="350"><table width="350" border="0">
    <tr>
        <th class="tableOdd">Pilot</th>
        <th class="tableOdd">Country</th>
        <th class="tableOdd">Rank</th>
    </tr>
    <?php
    foreach ($pilots as $pilot) {
    ?>
        <tr>
            <th align="left"><?php echo PilotData::GetPilotCode($pilot->code, $pilot->pilotid); ?> | <?php echo $pilot->firstname.' '.$pilot->lastname?></th>
            <th><img src="<?php echo Countries::getCountryImage($pilot->location); ?>"
                     alt="<?php echo Countries::getCountryName($pilot->location); ?>" /></th>
            <th><img src="<?php echo $pilot->rankimage ?>" alt="<?php echo $pilot->rank; ?>" /></th>
        </tr>
    <?php
    }
    ?>
</table>
</td>
    <td width="41"> </td>
    <td style="vertical-align:top" width="395"> Our Info Here        <table width= "590" border="0">
  <tr>
    <td><h3>Hub Manager:</h3></td>
    </tr>
  <tr>
    <td><p>AWE0001 | Our Hub Manager </p></td>
    </tr>
    </table>
</td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td><table width= "590" border="0">
  <tr>
    <td colspan="2"><h3>Hub Gates:</h3></td>
    </tr>
  <tr>
    <td><p><strong>Our Hub Gates</strong></p></td>
    <td><a href="#">Map</a></td>
    </tr>
    </table></td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
</table>

[dimitris]

try to move the kclt_hub.tpl file to the core->templates and also try to remove the line:

<link href="table.css" rel="stylesheet" type="text/css" />

from the .tpl

[NAdams]

i have got it to work! not sure how, i used netbeans to create the php files instead of text edit, but they are working and the initial code that you

gave me is the one i used, thanks so much for the help!

here are the pages, i haven't styled anything yet, but the info is there now

http://x-usairways.com/index.php/kclthub

http://x-usairways.com/index.php/kphlhub

http://x-usairways.com/index.php/kphxhub