Leaderboard

phpvms_navdata 1902: UPDATED 20 February 2019 | 23:59 Hrs US Central Time | 05:59 Zulu See Original Post Thx everyone for the +Rep. Spreading the love

I'm very apprehensive about eventually moving from 5.5.2 to v7. Although after playing with the demo version I'm really enjoying the new features. I did have a concern however. At least in the current state, I don't see many cargo/freight specific options as most everything looks to more for a passenger airline. How would we set the fares for freighters? Would we have a single fare class for general freight to the max payload of the aircraft? I don't know if this would have any advantages, but I guess we could set multiple fare categories for main deck cargo and belly cargo for dedicated freighter aircraft. Any thoughts or guidance about cargo only VA's running phpvms v7?

I know that the version 7 is still being worked on, and have no idea when it will be ready for wide release but I have been learning the basic's of Blade Templating and converting an existing Bootstrap & HTML template to phpVMS v7. I am also trying to learn the basic's of Laravel for v7. I am not a coder by any mean's just enjoy making template's for the old version's of phpVMS and also learning how to make them or customize them for v7. I am making video's and was wondering if anyone is interested, while I work on them. My way is just the simple old school way similar to the older version's. Still have to learn SASS, Laravel, etc... but the basic's of the look of the templates do work, so that you can have something look different than the stock one, and hopefully we can learn and help each other. Please let me know if you are interested in these very basic video's. I have the first one done that show's you how to get the converted template to show up, and now have to work on the navigation, drop down menu, content, etc... video's! I have not made very many, if any, (wait I did make one Adobe Muse one for menu's that is super simple about 3-4 years ago and for some strange reason has like 80,000 views), and they are not very professional, still learning, but get the job done! phpVMS 7 is still in development, not recommended to use as a production virtual airline! Alright, here is the first video in I hope to be a series. I worked on the navigation and Snag It crashed, a lot of work down the drain. Have to redo it at some point! I do all my editing on a Mac, but it's the same for WIndow's! Just use the editor of choice and FileZilla type program, etc... This is how I do although there are a ton of different ways! phpVMS v7 template links and basics - Part 1 Thanks!

Hi Chris, You need to download the tar file then extract the tar file to a folder it will say this folder phpvms, if you're ok with the php you need to change the version change it to PHP 7.0 or 7.2 on your server panel like I did, the folder will be called phpvms I sent the files to the public _html folder on the ftp upload to web server located the public_html that worked for me, right to get it working I found this get your website domain www.website.com/install it will pop up then you're good to go on the setting up your VA. Hope this helps Thanks Fivestar001

I know that Nabeel is busy and does most of the work for phpvms7 on github, so I leave this as a suggestion from my VA. If someone else wants to put their suggestions it can be a good post. How are suggestions can be included or not, and may be soon or not. 1. fleet->new aircraft-> (complete all data)-> save (there is no button to go back and add other aircraft) P.S: Doing clicking twice in save return to aircraft menu. 2. Add a option to edit pilot ID ex: 3. Option (checkbox) to make a return/reverse flight when you create a flight. So you can create a flight and their reverse route without complete all fields again.

AirMail 3.1 phpVMS module to create a messaging system your phpVMS based virtual airline. Released under the following license: Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License Developed by: simpilot www.simpilotgroup.com Developed on: phpVMS v2.1.934-158 php 5.3.4 mysql 5.0.7 apache 2.2.17 This system is not compatible with any earlier versions of AirMail New Features: -Delete All function in inbox and all message folders -Individual pilot setting to have email sent to pilot when new message is received -Threaded messages -Cleaner templates to help with site integration Install: -Download the attached package. -unzip the package and place the files as structured in your root phpVMS install. -use the airmail.sql file to create the tables needed in your sql database using phpmyadmin or similar. To Use the "You Have Mail" function place the following code where you would like the notice to appear, it will only appear if the pilot is logged in. <?php MainController::Run('Mail', 'checkmail'); ?> -Create a link on your site for your pilots to access their AIRMail <a href="<?php echo url('/Mail'); ?>">AIRMail</a> File Updated 9/2/2011 files changed: core/templates/sentitems.tpl core/common/MailDataClass.php File Updates 9/26/11 core/common/MailDataClass.php - NOTAM bug fix Code hosted on Github - Link In Signature.

Hi guys - the default installation of iCrew LITE sometimes does not automatically go to the login page if you visit the site while not logged in, or when your login session expires. I'm posting the fix below. Hope this helps some of you: In index.php in the root of phpvms: define('CODON_DEFAULT_MODULE', 'Frontpage'); change to: define('CODON_DEFAULT_MODULE', 'Profile'); And in modules/Profile/Profile.php: public function index() { if(!Auth::LoggedIn()) { $this->set('message', 'You must be logged in to access this feature!'); $this->render('core_error.php'); return; change to: public function index() { if(!Auth::LoggedIn()) { $this->render('login_form.php'); return;

Found this: https://github.com/tutsplus/how-to-integrate-google-no-captcha-recaptcha-on-your-website/blob/master/recaptchalib.php Does your recaptchalib.php look alike? If yes, try to replace this: function ReCaptcha with this: function __contruct

See if this works Find this on line 37 <?php foreach($pireps as $pirep) { Replace it with this (deprecated function, but it works) <?php foreach($pireps as $pirep) { $schedule = SchedulesData::getScheduleByFlight($pirep->code, $pirep->flightnum); Find this <strong>Flight Time: </strong><?php echo $pirep->flighttime; ?> <br /> Now the $schedule variable should be activated, so you should be able to read it like this <strong>Actual Flight Time: </strong><?php echo $pirep->flighttime; ?> <br /> <strong>Scheduled Flight Time: </strong><?php echo $schedule->flighttime; ?> <br /> <strong>Scheduled Aircraft: </strong><?php echo $schedule->aircraft; ?> <br /> <strong>Scheduled Flight Level: </strong><?php echo $schedule->flightlevel; ?> <br />

Hello guys, I made a new skin with some unique modules few weeks ago. My skin contains responsive designs with unique modules, listed below: 1. Unique VistaID of a Pilot 2. Group Flight Module ( Pilot can create a Group Flight ) 3. VIstaChallenges ( Assign Challenges to Pilots ) 4. VistaCharter System (Create and Bid Flights on your own with detailed information ) 5. VistaGallery ( Upload/View screenshots by Pilots ) 6. Real World FlightBoard 7. Responsive Booking System with Automatic Emails System I'm selling this theme with all the above features for $50 If you want to buy it you can send me a message on this forum or contact on +91 9619271512 or email me on yash.govekar55@gmail.com

I do not know if this is what you are looking for in core/modules/pireps/pireps.php find this $this->render('route_map.tpl');

Found a possible solution. Exported the schedules Changed all of the values in the Week 1, Week 2, Week 3, Week 4 columns to 1 in the csv file. Saved the file. Import the newly saved schedules with Delete Previous checked. Deleted all the 1s in the Week 1, Week 2, Week 3, Week 4 columns. Saved the csv file. Import the newly saved schedules with Delete Previous checked again. All the schedules appear on the first Schedule page without clicking Find Flights. Not sure why this worked. Just know that it did. If your schedules are actively using the Week 1 through Week 4 columns, doing the same in the "days of week" column should work. Just sort your spreadsheet accordingly and only change values in the empty cells.

This message is great if you can share the code we need flight map, please share this code to us also k922365@gmail.com

I think its because on your schedule search form it says <form id="form" action="https://va.atlasgaming.group/index.php/schedules/view" method="post"> While it should be <form id="form" action="https://va.atlasgaming.group/action.php/schedules/view" method="post"> When using index it will render the whole template and action will ony render the results part In your php file it will probably look like action="<?php echo url('/schedules/view')" OR action="<?php echo SITE_URL."/schedules/view" ?>" If so it should be. action="<?php echo actionurl('/schedules/view')" But again I think Im saying this from memory since im at work

Take your most recent pirep from the DB. What is in the raw_data column? If there is data there, you can get it working. Take a look at the exaple Chart.js charts and you'll see the format it requires. It should be a simple JS array format data = [1,2,3,4] etc. And then each element of the array should have an associated element in the labels array. But check the docs for this. A quick solution would be to just generate a script that creates a properly formatted string, and call it inside the .tpl/.php file. I guess the better way would be to perform some sort of AJAX call to get the data then do a $.each() on the array. Did this for a VA. Take a look at the part of the code

Im really losing grasp of where we stand with this? I am on 2.x and it's not 2.9. Then I see webpage for 3.0, and THEN still talk of 5.5. It's VERY fragmented with almost NO support that I can speak of. If I am at an older 2.x HOW do I update to the newer versions?

Quick question, Do you know where the script pulls the Airline and Flight Number? Every time I click "Click to Generate" it puts a random flight number, that 1. Isn't in my aircraft database, or listed anyone on my site. So I'm not sure how to fix that. Example: Airline = LXA Flight Number = LXA57 on Brief Page. After clicking Generate, Flight Number = N320SB. Edit: So I figured out it's pulling the registration number of the aircraft from the SimBrief database. Is there any way to transmit our airline and flight number, in order for it to show up like that on generated pilot brief under flight number? Solution: Fixed by adding this code before the submit button. <input type="hidden" name="airline" value="<?php echo $schedule->code?>"> <input type="hidden" name="fltnum" value="<?php echo $schedule->flightnum?>"> <input type="hidden" name="reg" value="<?php echo $schedule->registration?>">

CLICK HERE TO DOWNLOAD PACKAGED & READY TO GO VERSION

Help me with the code. I'm trying to do so on the page of the Airport (HUB module), displays a list of planes that are currently at this airport. I'm trying to take some code from the module (RealScheduleLite), but the page out only the aircraft which have not yet done a single flight. Below the code of the page (hub master) hubview.tpl <div class="container">[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<br>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<div class="row">[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<div class="col-md-3"> <div class="panel panel-default"> <div class="panel-heading">AIRPORT DETALIS </div> <table class="table table-hover"> <tbody> <tr> <td><img src="<?php echo SITE_URL;?>/lib/skins/red/images/airports/<?php echo $hubs->icao;?>.jpg" alt="<?php echo $hubs->icao;?>" width="100%" height="100"/></td></tr> <tr><td><div><strong>ICAO</strong></div> <?php echo $hubs->icao;?></td></tr> <tr><td><div><strong>Airport name</strong></div> <?php echo $hubs->name;?> </td></tr> <tr><td><div><strong>Number of Pilots:</strong></div> <span><?php echo HubStats::CountPilots($hubs->icao);?></font></span><br></td></tr> <tr><td><div><strong>Total Flight </strong></div> <?php echo vFleetTrackData::countFlights($aircraft->id);?><br></td></tr> <tr><td><div><strong>Location (Lat) </strong></div> <?php echo $hubs->lat;?><br></td></tr><tr><td><div><strong>Location (Lon) </strong></div> <?php echo round(vFleetTrackData::countHours($aircraft->id));?><br></td></tr> <tr><td><div><strong>Annual passenger traffic</strong></div> 30 500 000 people<br></td></tr> <tr><td><div><strong>Number of Flights Flown:</strong></div><?php echo HubStats::CountFlights($hubs->icao);?> <br></td></tr> <tr><td><div><strong>Number of Routes Flown From <?php echo $hubs->icao;?>:</strong></div><?php echo HubStats::CountRoutes($hubs->icao);?><br></td></tr> <tr><td><div><strong>Total Miles Flown:</strong></div><?php echo HubStats::TotalMiles($hubs->icao);?>nm <br></td></tr> <tr><td><div><strong>Total Hours Flown:</strong></div><?php echo round(HubStats::TotalHours($hubs->icao));?><br></td></tr> <tr><td><div><strong>Total Fuel Used:</strong></div><?php echo round(HubStats::TotalFuelUsed($hubs->icao));?>lbs <br></td></tr> <tr><td><div><strong>Hub for airlines (ICAO) </strong></div>SVR, RWZ, SBI, MOV, RLU <br></td></tr> <tr><td><div><strong>Maximum takeoff weight (MTOW)</strong></div><br></td></tr> <tr><td><div><strong>Type</strong></div> International civil<br></td></tr><tr><td><div class="small"><strong>IATA</strong></div> DME<br></td></tr> <tr><td><div><strong>Country</strong></div>Russian Federation<br></td></tr> </tbody></table>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] </div> </div>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<div>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<div class="col-md-3"> <div class="panel panel-default"> <div class="panel-heading">AIRPORT Ranweys </div> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <th>Runway</th> <th>Runway length</th> <th>Runway width</th> </tr> <tr> <td>14C</td> <td>8531 ft</td> <td>148 ft</td> </tr> <tr> <td>32C</td> <td>8531 ft</td> <td>148 ft</td> </tr> <tr> <td>14L</td> <td>12448 ft</td> <td>174 ft</td> </tr> <tr> <td>32R</td> <td>12448 ft</td> <td>174 ft</td> </tr> <tr> <td>14R</td> <td>11483 ft</td> <td>230 ft</td> </tr> <tr> <td>32L</td> <td>11483 ft</td> <td>230 ft</td> </tr> </table>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] </div> </div> <div class="col-md-3"> <div class="panel panel-default"> <div class="panel-heading">AIRPORT FREQUENCIES </div> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <th>Type</th> <th>Name</th> <th>Frequency</th> </tr> <tr> <td>APP</td> <td>APP</td> <td>120.6 MHZ</td> </tr> <tr> <td>ATIS</td> <td>ATIS</td> <td>128.3 MHZ</td> </tr> <tr> <td>GND</td> <td>TAXIING</td> <td>119 MHZ</td> </tr> <tr> <td>MISC</td> <td>TRANSIT</td> <td>129.15 MHZ</td> </tr> <tr> <td>PMSV</td> <td>VOLMET</td> <td>127.875 MHZ</td> </tr> <tr> <td>RDR</td> <td>KRUG</td> <td>127.7 MHZ</td> </tr> <tr> <td>RMP</td> <td>APRON</td> <td>130.6 MHZ</td> </tr> <tr> <td>TWR</td> <td>TWR</td> <td>118.6 MHZ</td> </tr> </table>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] </div> </div> <div class="col-md-3"> <div class="panel panel-default"> <div class="panel-heading">AIRPORT NAVIGATION AIDS </div> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <th>Type</th> <th>Name</th> <th>Frequency</th> </tr> <tr> <td>NDB</td> <td>Domodedovo</td> <td>437 KHZ</td> </tr> <tr> <td>NDB</td> <td>Domodedovo</td> <td>659 KHZ</td> </tr> <tr> <td>NDB</td> <td>Domodedovo</td> <td>659 KHZ</td> </tr> <tr> <td>NDB</td> <td>Domodedovo</td> <td>437 KHZ</td> </tr> <tr> <td>NDB</td> <td>Domodedovo</td> <td>887 KHZ</td> </tr> <tr> <td>NDB</td> <td>Domodedovo</td> <td>320 KHZ</td> </tr> <tr> <td>NDB</td> <td>Domodedovo</td> <td>320 KHZ</td> </tr> <tr> <td>NDB</td> <td>Domodedovo</td> <td>887 KHZ</td> </tr> </table>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] </div> </div> [/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<div class="col-md-9"> <div class="panel panel-default"> <!-- Default panel contents --> <div class="panel-heading"><?php echo $hubs->icao;?> map</div> <!--<img src="http://www.gcmap.com/map?P=<?php echo $hubs->icao;?>,+&MS=bm&MR=30&MX=700x360&PM=b:disc4:blue%2b%22%25i%25+%28N%2210:yellow&PC=%23ffffff&MP=rect" width="100%" />--> <script type="text/javascript">[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] function initialize() { var mapDiv = document.getElementById('airport'); var map = new google.maps.Map(mapDiv, { center: new google.maps.LatLng(<?php echo $hubs->lat;?> , <?php echo $hubs->lng;?> ), zoom: 14, mapTypeId: google.maps.MapTypeId.SATELLITE }); } [/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] google.maps.event.addDomListener(window, 'load', initialize); </script> <div id="airport" style="width: 100%; height: 250px"></div></div> </br> <div class="panel panel-default"> <!-- Default panel contents --> <div class="panel-heading"> <?php echo '<td>'.$airport->name.'</td>'; echo '<td>'.$airport->country.'</td><td>'; $aircrafts = OperationsData::getAllAircraft('true'); $count = 0; if(!$aircrafts) { echo 'The Airline Has No Aircraft'; } else { foreach ($aircrafts as $aircraft) { $location = RealScheduleLiteData::get_aircraft_location($aircraft->id); $airfield = $location->arricao; if(!$location) { $location = RealScheduleLiteData::get_aircraft_start($aircraft->id); $airfield = $location->depicao; } else { $airfield = $location->arricao; } if ($airfield == $airport->icao) { if ($count == 0) { echo '| '; } echo ''.$aircraft->registration.' | '; $count++; } } if ($count == 0) { echo '<font color="#6D7B8D"><i>No Aircraft Available</i></font>'; } echo '</td>'; } ?> </div></div> </br> <div class="panel panel-default"> <!-- Default panel contents --> <div class="panel-heading">FLIGHTS FOR AIRCRAFT WITH TAIL NUMBER</div> <div> <div> <?php $hubs_details = HubStats::Pilots($hubs->icao); if($hubs_details == ''){ echo 'Sorry, no Pilots allocated to this hub yet. <br />';} else { [/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]?> <script type="text/javascript"> $(document).ready(function() { $('#plist').dataTable( { "sPaginationType": "bootstrap" } ); } ); </script> <table width="100%" id="plist" class="table table-striped"> <thead> <tr id="tablehead"> <th>Country</th> <th>Pilot ID</th>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<th>Name</th>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<th>Rank</th>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<th>Flights</th>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<th>Hours</th> <th>Group</th>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] <th>Vatsim ID/IVAO ID</th> <th>Active</th>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] [/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]</tr> </thead> <tbody> <?php foreach($hubs_details as $pilot) { if($pilot->retired =='1') { continue; } if($pilot->totalhours =='0'){ continue; } if(!$pilot){echo "Sorry, no pilot allocated to this hub yet.";} ?>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<tr> <td> <img src="<?php echo Countries::getCountryImage($pilot->location);?>" alt="<?php echo Countries::getCountryName($pilot->location);?>" /> </td> <td width="1%" nowrap><a href="<?php echo SITE_URL?>/index.php/profile/view/<?php echo $pilot->pilotid;?>"><?php echo PilotData::GetPilotCode($pilot->code, $pilot->pilotid);?></a>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]</td>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<td> [/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] <?php echo $pilot->firstname.' '.$pilot->lastname;?>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]</td>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<td><img src="<?php echo $pilot->rankimage;?>" alt="<?php echo $pilot->rank;?>" /></td> [/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<td><?php echo $pilot->totalflights; ?></td>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]<td><?php echo Util::AddTime($pilot->totalhours, $pilot->transferhours); ?></td> <td><?php echo $pilot->group;?></td>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] <td><?php[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]$fieldvalue = PilotData::GetFieldValue($pilot->pilotid, 'VATSIM ID');[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]if($fieldvalue != '')[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]{[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] echo '<a href="http://www.vataware.com/pilot.cfm?cid='.$fieldvalue.'" target="_blank"><img src="'.SITE_URL.'/lib/skins/mva/images/vatsim.gif" alt="Vatsim ID" border="0" /></a>';[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]}[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]?> <?php $feildvalue = PilotData::GetFieldValue($pilot->pilotid, 'IVAO ID');[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]if($feildvalue != '') { echo '<img src="http://status.ivao.aero/R/'.$feildvalue.'.png">'; } ?> </td>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4] <td> <?php if($pilot->retired == 0) echo '<span class="label label-success">Active</span>'; elseif($pilot->retired == 1) echo '<span class="label label-warning">Inactive</span>'; elseif($pilot->retired == 2) echo '<span class="label label-error">Banned</span>'; elseif($pilot->retired == 3) echo '<span class="label label-warning">On Leave</span>'; ?> <!--<?php if($pilot->retired == '1') {echo '<img src="'.SITE_URL.'/lib/skins/mva/images/no.png" alt="Retired" /> - Retired';} else {echo '<img src="'.SITE_URL.'/lib/skins/mva/images/yes.png" alt="Active" /> - Active';} ?>--> <?php[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]}[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]?></td>[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]</tr> </tbody> </table> <?php[/size][/font][/color] [color=#333333][font=Arial, Helvetica, sans-serif][size=4]}?> </div> </div> </div> </div> </div> </div>

What is the progress on this nice admin design

Dear All, During the past days, I have seen some double posts in this category and I decided to add this topic for your convenience. This board of the forum is a post-only board. This means that no one can answer to the topic you are posting. It is just used for your virtual airline's announcements. Posting topics which require others feedback is not that useful for the rest of the forum members cause they are not able to answer you. Also, each topic must be validated by a forum moderator prior shown to the public. So, if you can't see your topic, there is no need to worry about it or reposting it again. Just wait and a moderator of the forum will validate your topic. Thank you very much for reading this. Have Fun.

I've never done it using Charts.js, but I've used Morris Charts before. - You could probably tweak it for charts.js What I did was put the following in core/modules/Pilots/Pilots.php public function morrisstatsbymonthdata() { $data = PIREPData::getIntervalDataByMonth(array('p.pilotid'=>Auth::$userinfo->pilotid), 3); header("Content-type: application/json"); echo json_encode($data); } public function morrisstatsaircraftdata($pilotid) { $data = StatsData::PilotAircraftFlownCountsMorris($pilotid); header("Content-type: application/json"); echo json_encode($data); } core/common/StatsData.class.php public static function PilotAircraftFlownCountsMorris($pilotid) { $key = 'ac_flown_counts_1_'.$pilotid; $counts = CodonCache::delete($key); if($counts === true) { //Select aircraft types $sql = 'SELECT a.name AS label, COUNT(p.aircraft) AS value, SUM(p.flighttime) AS hours FROM '.TABLE_PREFIX.'pireps p, '.TABLE_PREFIX.'aircraft a WHERE p.aircraft = a.id AND p.pilotid='.intval($pilotid).' GROUP BY a.name'; $counts = DB::get_results($sql); CodonCache::write($key, $counts, 'medium'); } return $counts; } If your using phpvms 5.5.x core/common/StatsData.class.php public static function PilotAircraftFlownCountsMorris($pilotid) { $key = 'ac_flown_counts_1_'.$pilotid; $counts = CodonCache::delete($key); if($counts === false) { //Select aircraft types $sql = 'SELECT a.name AS label, COUNT(p.aircraft) AS value, SUM(p.flighttime) AS hours FROM '.TABLE_PREFIX.'pireps p, '.TABLE_PREFIX.'aircraft a WHERE p.aircraft = a.id AND p.pilotid='.intval($pilotid).' GROUP BY a.name'; $counts = DB::get_results($sql); CodonCache::write($key, $counts, 'medium'); } return $counts; } And here's my core/templates/profile_stats.tpl/php (should really be in lib/skins/XXX/profile_stats.tpl/php) <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.css"> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"></script> <script src="//cdnjs.cloudflare.com/ajax/libs/raphael/2.1.0/raphael-min.js"></script> <script src="//cdnjs.cloudflare.com/ajax/libs/morris.js/0.5.1/morris.min.js"></script> <h3>Your Stats</h3> <?php /* Added in 2.0! */ $chart_width = '800'; $chart_height = '250'; /* Don Not need to change anything below this here */ ?> <div align="center" style="width: 100%;"> <div id="monthdata" style="height: 250px;"></div> </div> <br /> <div align="center" style="width: 100%;"> <div id="aircraftdata" style="height: 250px;"></div> </div> <script type="text/javascript"> var json = (function () { var json = null; $.ajax({ 'async': false, 'global': false, 'url': "<?php echo actionurl('/pilots/morrisstatsbymonthdata');?>", 'dataType': "json", 'success': function (data) { json = data; } }); return json; }) (); new Morris.Line({ // ID of the element in which to draw the chart. element: 'monthdata', // Chart data records -- each entry in this array corresponds to a point on // the chart. data: json, // The name of the data record attribute that contains x-values. xkey: 'ym', // A list of names of data record attributes that contain y-values. ykeys: ['total'], // Labels for the ykeys -- will be displayed when you hover over the // chart. labels: ['Flights'] }); </script> <script type="text/javascript"> var json = (function () { var json = null; $.ajax({ 'async': false, 'global': false, 'url': "<?php echo actionurl('/pilots/morrisstatsaircraftdata/'.Auth::$userinfo->pilotid.'');?>", 'dataType': "json", 'success': function (data) { json = data; } }); return json; }) (); Morris.Donut({ element: 'aircraftdata', data: json }); </script> The end result http://imgur.com/wyb2lUz Thanks to Vangelis for providing most of the base code.

After receiving several requests by PM, I am releasing the addon I use to show the airports in the phpVMS database, with a separate page for each airport with various bits of data. First though I would like to attribute the work which I did not complete and is part of this addon. The Airport Table Page - This was originally created by Adamm, and I just removed some of the columns and added the link to the seperate webpage for the detailed airport info. The Last Arrival and Last Departure Fields - I asked for help on this forum, and Jeff (Lorathon) gave me the code to enable this feature. The Flight Counts - Simpilot posted some code to show the flight count. I expanded on this to show the arrival and departure flight counts. The Google Map - I reused and slightly modified (stripped out the ACARS functionality) the acars map from the default acarsmap.tpl here. The js for the map display - Problem resolved my Mark1Million I take absolutely no credit for the above mentioned aspects of the addon, and I would like to thank those mentioned for helping me create the addon released here. If you are going to thank anyone for this addon, thank those guys. I just put stuff together and added some more stuff. If you use this addon, I have placed attribution in the HTML commenting, please do leave it there. If it doesn't work on your site, I'm sorry but I can only provide limited support, as I'm still a learner when it comes to php. Please don't PM me asking for support. You would be much better posting here and there is every chance that someone more knowledgeable may be able to help. The addon can be seen working here: http://execair.org/index.php/airports The attached file has the same functionality but requires CSS styling to be applied. There are many tutorials available online, which discuss CSS styling at length, here are a few: http://w3schools.com/Css/default.asp http://www.csstutorial.net/ http://www.echoecho.com/css.htm To install the addon, unzip the folder, then copy the contents of the core folder over to the core folder on your website. Then to access the addon, you need to create a link to the new page in your navigation: <a href="<?php echo url('/airports'); ?>">Text for link here</a> EDIT: Attached File Amended to correct all Map Errors mentioned below. RE-EDIT: The attachment has been amended again to correct the errors. It should work 100% now. airportinfo_v3.zip

1) In core/modules create a folder called Gatwick 2) In core/modules/Gatwick create a file called Gatwick.php 3) In core/modules/Gatwick/Gatwick.php add this code <?php class Gatwick extends CodonModule { function index() { $this->show('gatwick'); } } 4) In lib/skins/bluelight create a file called gatwick.tpl 5) In lib/skins/bluelight/gatwick.tpl add this code <p> </p> <p style="text-align: center"> <strong><span style="font-size: 18px"><span style="color: #0000cd"><span style="font-family: georgia,serif">Gatwick airport, EGKK.</span></span></span></strong></p> <p style="text-align: center"> <span style="font-size: 18px"><span style="color: #0000cd"><span style="font-family: georgia,serif">WHQ & European fleet hub.</span></span></span></p> <p style="text-align: center"> <span style="font-size: 14px"><span style="color: #0000cd"><span style="font-family: georgia,serif">Gatwick is our world Headquarters, from here the CEO overseas all 5 Star operations and assist all the Division/hub managers in the running of their hubs and fleet. Gatwick is an international hub for flights to and from North America and throughout Europe. The European fleet consist of an Airbus A320, B737-800 and a B767-300 also the Comjet fleet aircraft use Gatwick as their international arrivals and departures.</span></span></span></p> <p style="text-align: center"> <span style="font-size: 14px"><span style="color: #0000cd"><span style="font-family: georgia,serif">Gatwick Airport is located 5km (3.1mi) north of the centre of Crawley, West Sussex, and 45.7 km (28.4 mi) south of Central London, previously known as London Gatwick, it is London's second largest international airport and second busiest by total passenger traffic in the United Kingdom after Heathrow. Gatwick furthermore is Europe's leading airport for point-to-point flights and has the world's busiest single-use runway averaging 52 aircraft movements an hour.</span></span></span></p> <p style="text-align: center"> <span style="font-size: 14px"><span style="color: #0000cd"><span style="font-family: georgia,serif">In 2010, over 31.3 million passengers passed through Gatwick, making it the 9th largest in Europe by passenger traffic and the 12th busiest in terms of international passengers.</span></span></span></p> <p style="text-align: center"> <span style="font-size: 14px"><span style="color: #0000cd"><span style="font-family: georgia,serif">Gatwick's main runway is 08R/26L, 3316 m/ 10879 ft in length and handled around 240,500 flights last year.</span></span></span></p> <p style="text-align: center"> <img alt="" height="176" src="http://5starvirtualaviation.com/phpvms/lib/skins/bluelight/images/gatwick.jpg" width="286" /></p> <div> <p style="text-align: center; "> <span style="color:#0000cd;"><span style="font-size:14px;"><span style="font-family:georgia,serif;">Pilots based at London Gatwick</span></span></span></p> <!--?php $pilots = PilotData::getAllPilotsByHub('EGKK'); ?--><!--?php if(!$pilots) { echo 'There are no pilots in that hub, so there must be at least one pilot so the hub can run.'; return; } ?--> <table cellpadding="1" cellspacing="0" class="tablesorter" id="tabledlist" width="100%"> <thead> <tr> <th style="background-color: #00008B; color: #FFF"> Pilot ID</th> <th style="background-color: #00008B; color: #FFF" width="200px"> <div align="left"> Name</div> </th> <th style="background-color: #00008B; color: #FFF"> <div align="left"> Rank</div> </th> <th style="background-color: #00008B; color: #FFF"> <div align="left"> Flights</div> </th> <th style="background-color: #00008B; color: #FFF"> <div align="left"> Hours</div> </th> <th style="background-color: #00008B; color: #FFF"> <div align="left"> Last Flight</div> </th> <th style="background-color: #00008B; color: #FFF"> <div align="left"> Joined</div> </th> </tr> </thead> <tbody> <!--?php foreach($pilots as $pilot) { ?--> <tr> <td nowrap="nowrap" width="1%"> <a href="<?php echo url('/profile/view/'.$pilot->pilotid);?>"><!--?php echo PilotData::GetPilotCode($pilot--->code, $pilot->pilotid)?></a></td> <td> <img alt="<?php echo Countries::getCountryName($pilot->location);?>" src="<?php echo Countries::getCountryImage($pilot->location);?>" /><!--?php echo $pilot--->firstname.' '.$pilot->lastname?></td> <td> <img alt="<?php echo $pilot->rank;?>" src="<?php echo $pilot->rankimage?>" /></td> <td> <!--?php echo $pilot---> totalflights?></td> <td> <!--?php echo Util::AddTime($pilot---> totalhours, $pilot->transferhours); ?></td> <td> <!--?php echo date(DATE_FORMAT, strtotime($pilot---> lastpirep));?></td> <td> <!--?php echo date(DATE_FORMAT, strtotime($pilot---> joindate));?></td> <!--?php } ?--> </tr> </tbody> </table> </div> 6) in your navigation menu, link to the page by adding this http://5starvirtuala...dex.php/gatwick

I came across this page from air malta virtual http://airmaltavirtual.com/en/index.php/bookings, Is this custom or is the code available, i done a quick search here but didn't find anything. Daniel, hope you don't mind me listing your site.

I proudly display "Powered by PHPVMS" and the "Simpilot Group" on my front page! I give both of these guys a lot of respect for helping the community like they have. Thanks to both of you!!!