markusr

Hello, will it show the route thet the pilot entered in XACARS, or the route that is stored in the DB to the flight? In our chase we don't have routes stored, the pilot can book an aircraft and enter Depature and Destination airport in XACARS as well as the route. Thanks for an answer, Mark

Hello, I got notified from a pilot today, that he is getting the same message as Mark described. I looked in the en.lang.php and saw, that the line 31 is exactly the same as you have posted here. I am running 2.1.944 release. /* Email stuff */ 'email.inuse' => 'This email address is already in use', 'email.register.accepted.subject' => 'Your registration was accepted!', 'email.register.rejected.subject' => 'Your registration was denied!', 'email.pilot.retired.subject' => SITE_NAME.': You\'ve been marked as retired', it must be another issue....

The version in the admin interface says: Version 2.1.944

Yes, here is the link to the image: http://austrian-jet-service.at.tf/lib/images/ranks/GOLD2.jpg

permissions are on 755. I can see the badge, but not the rank image in it.

Hi Nabeel, I have also tried the jpg file extension, but I will get the same error then saving the the pilot profile.

Hi, yes around 80 Pireps are logged. The fleet module is working when I don't try to filter only the enabled aircraft. If I add the filter for the enabled aircraft, the script stops working.

Yes, they are enabled. Schedules are existant, but without dep/arr airport. They were delted in the database directly, so that you can book an aircraft, but not a specific route. and the fleet:

Hi, I have just tried replacing the sql script, but I get the same error: Warning: Invalid argument supplied for foreach() in /var/www/web97/html/phpvms/core/templates/fleet_table.tpl on line 4 I have only 5 aircraft for our business VA fleet.

no one able to fix the request? :-(

Hello, I have just updated to this 944 release. But the rank image is not showing up in the signature. I always get the error when updating the profile: Warning: imagecreatefromstring(): Empty string or invalid image in /var/www/web97/html/markus/phpvms/core/common/PilotData.class.php on line 1104 The line says:$rankimg = imagecreatefromstring($rankimg); The images are showing up in the roster as well in the the pilot profile. The ranks are in gif format, but I have also tried it with JPG. thanks, Markus EDIT: I have only uploaded the changed files to the server. Do I need to upload all files from the compressed file? Edit again: I have now uploaded all files from the package and executed the update.php, but same error.

Hi, here is the whole fleet.php <?php class Fleet extends CodonModule { public function index() { $fleet = self::FleetInfo(); Template::Set('fleet', $fleet); Template::Show('fleet_table.tpl'); } /** * Return all possible information about the fleet * Code by Mitchell W * Enhanced by Stu (stuartpb) * Fleet Table 2.0 */ public static function FleetInfo() { $sql = 'SELECT a.*, a.name AS aircraft, COUNT(p.pirepid) AS routesflown, SUM(p.distance) AS distance, SEC_TO_TIME(SUM(p.flighttime*60*60)) AS totaltime, AVG(p.distance) AS averagedistance, AVG(p.flighttime) as averagetime FROM '.TABLE_PREFIX.'aircraft a WHERE a.enabled = 1 LEFT OUTER JOIN '.TABLE_PREFIX.'pireps p ON (p.aircraft = a.id) GROUP BY a.registration'; return DB::get_results($sql); DB::debug(); return $ret; } } ?> and the tpl: <h1><?php echo SITE_NAME?> Fleet</h1> <table align="center"><tr><td> <?php foreach ($fleet as $aircraft) { ?> <div style="float: left;" align="right"> ICAO :<br> Type :<br> Full Name:<br> Registration :<br> Range :<br> Empty Weight :<br> Cruise Alt :<br> Max Pax :<br> Max Cargo :<br> Total hours :<br> Total Routes flown :<br> current Airport :<br> current Country :<br> <br> Download : </div> <div style="float: left;"> <?php echo $aircraft->icao; ?><br> <?php echo $aircraft->name; ?><br> <?php echo $aircraft->fullname; ?><br> <?php echo $aircraft->registration; ?><br> <?php echo $aircraft->range; ?><br> <?php echo $aircraft->weight; ?><br> <?php echo $aircraft->cruise; ?><br> <?php echo $aircraft->maxpax; ?><br> <?php echo $aircraft->maxcargo; ?><br> <?php echo $aircraft->totaltime; ?><br> <?php echo $aircraft->routesflown; ?><br> <?php $params = (array('a.registration'=>$aircraft->registration, 'p.accepted'=>PIREP_ACCEPTED)); $pirep = PIREPData::findPIREPS($params); $current_location = $pirep[0]->arricao; $current_location2 = $pirep[0]->arrname; echo $current_location.'-'.$current_location2; ?> <?php $airport = OperationsData::getAirportInfo($pirep[0]->arricao); ?><br> <?php echo $airport->country; ?><br> <br> <a href="<?php echo $aircraft->downloadlink; ?>">Download!</a> </div> <div style="float: right;"> <img src="<?php echo $aircraft->imagelink; ?>" height="97" width="160"></div> <br style="clear:both;"> <br> <hr> <br> <? } ?> </td></tr></table> the error says: Warning: Invalid argument supplied for foreach() in /var/www/web97/html/phpvms/core/templates/fleet_table.tpl on line 4 Thanks for help! best regards, Markus

Hi, with this one, I get an error on line 4 from the tpl file: $sql = 'SELECT a.*, a.name AS aircraft, COUNT(p.pirepid) AS routesflown, SUM(p.distance) AS distance, SEC_TO_TIME(SUM(p.flighttime*60*60)) AS totaltime, AVG(p.distance) AS averagedistance, AVG(p.flighttime) as averagetime FROM '.TABLE_PREFIX.'aircraft a WHERE a.enabled = 1 LEFT OUTER JOIN '.TABLE_PREFIX.'pireps p ON (p.aircraft = a.id) GROUP BY a.registration'; return DB::get_results($sql); DB::debug(); return $ret; Line 4 of the tpl is: foreach ($fleet as $aircraft) any idea?

I think only the SQL query need to be adopted public static function FleetInfo() { $sql = 'SELECT a.*, a.name AS aircraft, COUNT(p.pirepid) AS routesflown, SUM(p.distance) AS distance, SEC_TO_TIME(SUM(p.flighttime*60*60)) AS totaltime, AVG(p.distance) AS averagedistance, AVG(p.flighttime) as averagetime FROM '.TABLE_PREFIX.'aircraft a LEFT OUTER JOIN '.TABLE_PREFIX.'pireps p ON (p.aircraft = a.id) GROUP BY a.registration'; return DB::get_results($sql); DB::debug(); return $ret; } to include only enabled aircraft, but I didn't managed to get it working. Maybe some sql expert could help. thanks, Markus

got it! i missed this one: <?php /*Any custom Javascript should be placed below this line, after the above call */ ?> <?php echo $page_htmlhead; ?> <script type="text/javascript" src="<?php echo SITE_URL?>/lib/skins/crystal-II/assets/js/jquery.pikachoose.js"></script> </head>