nexissair

Brilliant, thanks chaps, I'll pass this info along to my pilots

Evening all Just a quick question, one of my pilots has asked if kACARS will work with Prepare3D, does anyone know the answer because I haven't got a clue. Many thanks Karl

Its ok folks I've solved it after reading through the API

Afternoon everyone I'm currently building a module for my site which I plan to share on here for everyone to use if they want, it allows you to add extra information to an aircraft that can then be shown on a nice shiney fleet page, I am a bit stuck though, whilst I can pull the aircraft, add extra information to them and display it all on the fleet page with no problems, I just cannot for the life of me get it to update existing added extra data, I've been staring at this for four days without success, the query works when run direct in SQL command line, I've tried absolutley everything but clearly I've missed something that I can't spot, Please please please can some one look over what I've done and let me know what I've missed because I can't find my error and its driving me nuts now, I so close to having this done but its vital that people have the ability to update what they've added. The code is below. Core Class: <?php /** * Karl Sawdy */ class FleetInfoData extends CodonData { //Public Functions - Fleet Page //Get enabled ICAO's public static function getAllicao() { $sql = 'SELECT DISTINCT icao, fullname FROM '.TABLE_PREFIX.'aircraft WHERE enabled=1 ORDER BY `icao` ASC'; return DB::get_results($sql); } // Get all of the enabledd aircraft public static function getAllAircraft() { $sql = "SELECT a.* FROM ".TABLE_PREFIX."aircraft a WHERE enabled=1 ORDER BY a.registration"; return DB::get_results($sql); } //End Public Functions - Fleet Page //Admin Functions //Get All Aircraft Added public static function getEveryAircraft() { $sql = "SELECT a.* FROM ".TABLE_PREFIX."aircraft a ORDER BY a.registration"; return DB::get_results($sql); } //Get Aircraft with Added Details for Main Page public function getAcDetails() { $query = "SELECT a.*, e.* FROM phpvms_aircraft_details as e LEFT JOIN ".TABLE_PREFIX."aircraft AS a ON a.id = e.aircraftid ORDER BY a.icao ASC"; return DB::get_results($query); } //Get a Specific Aircraft to Add Details to public static function getAircraftInfo($id) { $id = DB::escape($id); return DB::get_row('SELECT * FROM '.TABLE_PREFIX.'aircraft WHERE `id`='.$id); } //Add New Details to Existing Aircraft public function save_new_details($aircraftid, $detregistration, $wingspan, $length, $height, $cruisemach, $ceiling, $engines, $base, $department, $status, $comments) { $query = "INSERT INTO phpvms_aircraft_details (aircraftid, detregistration, wingspan, length, height, cruisemach, ceiling, engines, base, department, status, comments ) VALUES('$aircraftid', '$detregistration', '$wingspan', '$length', '$height', '$cruisemach', '$ceiling', '$engines', '$base', '$department', '$status', '$comments')"; DB::query($query); } // End Adding Details to Existing Aircraft //Get a Specific Aircraft with Existing Details to Edit public static function getAircraftEdit($id) { $id = DB::escape($id); return DB::get_row('SELECT a.*,e.* FROM phpvms_aircraft_details AS e LEFT JOIN phpvms_aircraft AS a ON a.id = e.aircraftid WHERE `aircraftid`='.$id); } //Edit Existing Details on Existing Aircraft public function update_details($wingspan, $length, $height, $cruisemach, $ceiling, $engines, $base, $department, $status, $comments, $detid) { $query = "UPDATE phpvms_aircraft_details SET wingspan='$wingspan' length='$length' height='$height' cruisemach='$cruisemach' ceiling='$ceiling' engines='$engines' base='$base' department='$department' status='$status' comments='$comments' WHERE detid='$detid'"; DB::query($query); } } Admin Module: <?php class FleetInfo extends CodonModule { public function HTMLHead() { $this->set('sidebar', 'fleetinfo/fleetinfo_sidebar.tpl'); } public function NavBar() { echo '<li><a href="'.SITE_URL.'/admin/index.php/FleetInfo">Additional Aircraft Info</a></li>'; } public function index() { $this->set('info', FleetInfoData::getAcDetails()); $this->show('fleetinfo/fleetinfo_index.tpl'); } //Edit Existing Aircraft - Pages //See All Existing Aircraft public function SeeAllAddedAircraft() { $this->set('allaircraft', FleetInfoData::getEveryAircraft()); $this->render('fleetinfo/all_aircraftlist.tpl'); } //Select The Existing Aircraft to Add Details to and show Add Details Page public function SelectAircraft() { $id = $this->get->id; $this->set('action', 'adddetails'); $this->set('allranks', RanksData::getAllRanks()); $this->set('aircraft', OperationsData::GetAircraftInfo($id)); $this->render('fleetinfo/fleetinfo_adddetails.tpl'); } //Add Details 'action' public function adddetails() { $details = array(); $details['aircraftid'] = DB::escape($this->post->aircraftid); $details['detregistration'] = DB::escape($this->post->detregistration); $details['wingspan'] = DB::escape($this->post->wingspan); $details['length'] = DB::escape($this->post->length); $details['height'] = DB::escape($this->post->height); $details['cruisemach'] = DB::escape($this->post->cruisemach); $details['ceiling'] = DB::escape($this->post->ceiling); $details['engines'] = DB::escape($this->post->engines); $details['base'] = DB::escape($this->post->base); $details['department'] = DB::escape($this->post->department); $details['status'] = DB::escape($this->post->status); $details['comments'] = DB::escape($this->post->comments); $details['fullname'] = DB::escape($this->post->fullname); FleetInfoData::save_new_details($details['aircraftid'], $details['detregistration'], $details['wingspan'], $details['length'], $details['height'], $details['cruisemach'], $details['ceiling'], $details['engines'], $details['base'], $details['department'], $details['status'], $details['comments']); //Go to Admin Index page After Saving $this->set('info', FleetInfoData::getAcDetails()); $this->show('fleetinfo/fleetinfo_index.tpl'); //Add Successful Save info to user log LogData::addLog(Auth::$userinfo->pilotid, 'Added Details To Aircraft "'.$this->post->fullname.' Registration '.$this->post->registration.'"'); } //END Adding Details to Existing Aircraft //Select The Existing Aircraft to Edit Details of and show Edit Details Page public function EditAircaftDetails($id) { $this->set('action', 'save_edit_details'); $this->set('details',FleetInfoData::GetAircraftEdit($id)); $this->set('allranks', RanksData::getAllRanks()); $this->render('fleetinfo/fleetinfo_editdetail.tpl'); } //Save Edited Details 'action' public function save_edit_details() { $ac = array(); $ac['wingspan'] = DB::escape($this->post->wingspan); $ac['length'] = DB::escape($this->post->length); $ac['height'] = DB::escape($this->post->height); $ac['cruisemach'] = DB::escape($this->post->cruisemach); $ac['ceiling'] = DB::escape($this->post->ceiling); $ac['engines'] = DB::escape($this->post->engines); $ac['base'] = DB::escape($this->post->base); $ac['department'] = DB::escape($this->post->department); $ac['status'] = DB::escape($this->post->status); $ac['comments'] = DB::escape($this->post->comments); $ac['detregistration'] = DB::escape($this->post->detregistration); $ac['detid'] = DB::escape($this->post->detid); $ac['fullname'] = DB::escape($this->post->fullname); FleetInfoData::update_details($ac['wingspan'], $ac['length'], $ac['height'], $ac['cruisemach'], $ac['ceiling'], $ac['engines'], $ac['base'], $ac['department'], $ac['status'], $ac['comments'], $ac['detregistration'], $ac['detid']); //Show Successful Update Message to User and index page $this->set('message', 'The Aircraft "'.$this->post->fullname.' '.$this->post->detregistration.'" has been successfully Updated'); $this->render('core_success.tpl'); $this->set('info', FleetInfoData::getAcDetails()); $this->show('fleetinfo/fleetinfo_index.tpl'); //Add Successful Update info to user log LogData::addLog(Auth::$userinfo->pilotid, 'Edited Aircraft "'.$this->post->fullname.' '.$this->post->detregistration.'"'); } } Edit Details TPL <h4>Existing Aircraft Details</h4> <hr> <form action="<?php echo adminurl('/FleetInfo/'.$action.'');?>" method="post"> <table width="100%" border="0" cellspacing="5" cellpadding="5"> <tr> <td width="15%">Database ID Number</td> <td><?php echo $details->id; ?></td> </tr> <tr> <td width="15%">Aircraft ICAO</td> <td><?php echo $details->icao; ?></td> </tr> <tr> <td>Aircraft Name / Type</td> <td><?php echo $details->name; ?></td> </tr> <tr> <td>Full Name</td> <td><?php echo $details->fullname; ?></td> </tr> <tr> <td>Aircraft Registration</td> <td><?php echo $details->registration; ?></td> </tr> <tr> <td>Max Pax</td> <td><?php echo $details->maxpax; ?> PAX</td> </tr> <tr> <td>Max Cargo</td> <td><?php echo $details->maxcargo; ?> lbs</td> </tr> <tr> <td>Range</td> <td><?php echo $details->range; ?> nM</td> </tr> <tr> <td>weight</td> <td><?php echo $details->weight; ?> lbs</td> </tr> <tr> <td>Cruise Speed Kts</td> <td><?php echo $details->cruise; ?> kts</td> </tr> <tr> <td>Minimum Rank to Fly This Aircraft</td> <td><?php foreach($allranks as $rank) if($details->minrank == $rank->rankid) echo $rank->rank; ?></td> </tr> <tr> <?php if($details->enabled == 1) { echo '<td colspan="2" bgcolor="#00FF00" align="center"><strong>Aircraft Active - Can Be Flown Now</strong></td>'; } else echo '<td colspan="2" bgcolor="#FF0000" align="center"><strong>Aircraft Not Active - Cannot Be Flown By Pilots</strong></td>'; ?> </tr> <tr> <td colspan="2"> <hr> <h4>Update Additional Aircraft Details</h4> <hr> </td> </tr> <tr> <td>Wingspan</td> <td><input type="text" name="wingspan" value="<?php echo $details->wingspan;?>" /> ft</td> </tr> <tr> <td>Length</td> <td><input type="text" name="length" value="<?php echo $details->length;?>" /> ft</td> </tr> <tr> <td>Height</td> <td><input type="text" name="height" value="<?php echo $details->height;?>" /> ft</td> </tr> <tr> <td>Cruise Mach</td> <td><input type="text" name="cruisemach" value="<?php echo $details->cruisemach;?>" /> mach</td> </tr> <tr> <td>Ceiling</td> <td><input type="text" name="ceiling" value="<?php echo $details->ceiling;?>" /> ft</td> </tr> <tr> <td>Engines</td> <td><input type="text" name="engines" style="width: 40%;" value="<?php echo $details->engines;?>" /></td> </tr> <tr> <td>Base</td> <td><select name="base"><option value="<?php echo $details->base;?>"></option> <option value="To Be Confirmed">To Be Confirmed</option> <option value="EGSS">EGSS</option> <option value="PANC">PANC</option> <option value="KMIA">KMIA</option> </select> Currently Set To: <strong><?php echo $details->base;?></strong></td> </tr> <tr> <td>Department</td> <td><select name="department"><option value="<?php echo $details->department;?>"></option> <option value="To Be Confirmed">To Be Confirmed</option> <option value="Schedules">Schedules</option> <option value="Charters">Charters</option> <option value="Cargo">Cargo</option> <option value="Executive Charters">Executive Charters</option> <option value="Vintage">Vintage</option> <option value="Private">Private</option> </select> Currently Set To: <strong><?php echo $details->department;?></strong></td> </tr> <tr> <td>Status</td> <td><select name="status"><option value="<?php echo $details->status;?>"></option> <option value="Active">Active</option> <option value="On Order">On Order</option> <option value="In Storage">In Storage</option> <option value="Retired">Retired</option> <option value="External Contract">External Contract</option> <option value="Leased">Leased</option> <option value="Re-Fit">Re-Fit</option> <option value="Sold">Sold</option> <option value="Scrapped">Scrapped</option> </select> Currently Set To: <strong><?php echo $details->status;?></strong></td> </tr> <tr> <td>Notes</td> <td><textarea name="comments" style="width: 50%; height: 100px"><?php echo $details->comments;?></textarea></td> </tr> <tr> <td></td> <td> <input type="hidden" name="detid" value="<?php echo $details->detid;?>" /> <input type="hidden" name="detregistration" value="<?php echo $details->registration;?>" /> <input type="hidden" name="fullname" value="<?php echo $details->fullname;?>" /> <input type="submit" name="submit" value="Edit Details" /> </td> </tr> </table> </form> <?php print_r($details);?> Thankyou all for your help Karl

Hi all don't worry I've Sovled the problem Karl

Afternoon All I currently have on my site a static fleet page gouped by aircraft type, however as part of my quest to learn MVC and php I thought I would have a go at making it dynamic so that when I add an aircraft the page auto updates saving me loads of work in the long run. So after an evening of browsing though phpvms files to see how it all ticks, and based on the public pilots list, grouped by hubs I made my class, module and tpl files. I had some success but not completely, the page gives me one group for each icao which is what I wanted, but it also gives me all the whole fleet repeated in each group! not just the aircraft specific to the group. If this was an access database I know the answer, php is not access so I'm stuffed, could some of you php wizards please look over what I've done and let me know where I've gone wrong please, All said and done this was only a learning excersise with a useful out come, so its not the end of the world, but if I don't know where or why I've gone wrong I can't learn from it, I did do a search but nothing came up specific to the way I'm trying to do this. My code is below: FleetData Class <?php /** * Karl Sawdy */ class FleetData extends CodonData { //Get ICAO's public static function getAllicao() { $sql = 'SELECT DISTINCT icao, fullname FROM '.TABLE_PREFIX.'aircraft WHERE enabled=1 ORDER BY `icao` ASC'; return DB::get_results($sql); } /** * Get all of the aircraft */ public static function getAllAircraft() { $sql = "SELECT a.* FROM ".TABLE_PREFIX."aircraft a WHERE a.enabled=1 ORDER BY a.registration"; return DB::get_results($sql); } } Fleet module <?php /** * Karl Sawdy */ class Fleet extends CodonModule { public function index() { // Get all aircraft types, and list aircraft by type $alltypes = FleetData::GetAllicao(); if(!$alltypes) $alltypes = array(); foreach($alltypes as $type) { $this->set('title', $type->fullname); $this->set('icao', $type->icao); $this->set('allaircraft', FleetData::getAllAircraft(array('a.icao'=>$type->icao))); $this->render('fleet/fleet_list.tpl'); } } } fleet list tpl <div id="newshead"> <h3head><?php echo $title?></h3head> </div> <?php if(!$allaircraft) { echo '<div id="news">There are no aircraft!</div>'; return; } ?> <div id="news"> <table id="tabledlist" class="tablesorter"> <thead> <tr> <th>Registration</th> <th>Name</th> </tr> </thead> <tbody> <?php foreach($allaircraft as $aircraft) { ?> <tr> <td><?php echo $aircraft->registration;?></td> <td><?php echo $aircraft->fullname;?></td> </tr> <?php } ?> </tbody> </table> </div> Many thanks All your help is much appreciated Karl

Ok I have worked out how to filter from the list of aircraft but I need a little help filtering from the location map please. Also is it possible to indicate wen an aircraft is in flight? Thanks karl

Evening all Is there a way to filter out 2 or 3 aircraft by registration so that they don't show on the list or map? Thanks Karl

Me too

cool many thanks

Hi all I'm currently having a go t building a module, I need a little help, is there a piece of code that I can put on the template page i'm working on during development to show me all he fields that my query is pulling from the database, obviously once I'm done the little helper code can be deleted, many thanks karl

That's unfortunate, shame it looks like just what I was looking for :-(

Evening All, Don't know if I've missed something but how / where can I get hold of this module / addon? Regards Karl

Super job thank you very much

Evening all I am pretty sure that some time ago I soor or read that one of our developers was offering phpvms packaged up with some of their addons included. For the life of me I can't remember who it was or where I soor it. Could someone please point me in the right direction, search didn't dig anything up for me, and I now can't find it. Thanks Karl