AFVA | Mitchell Posted December 16, 2009 Report Share Posted December 16, 2009 Version 1.0 Outdated A table which contains your full fleet information. Preview: http://www.vhmrw.site90.com/index.php/fleet 1. Add the folder 'Fleet' to your core/modules folder 2. Add fleet_main.tpl to your coretemplate folder 3. Go to: www.yourvmssite.com/index.php/fleet (Replacing www.yourvmssite.com with your site URL of course) Download Link: http://downloads.vhmrw.site90.com/Fleet%20Module.zip (only download link as earlier version) ------------------------------------------------------------------------------------------ Version 1.1 Released 1.1 Features: All previous 1.0 information Total Hours Total Flights Custom SQL (FleetInfo) 1.1 Will come with a very large table. To things you don't want: 1. Go to the thead section 2. Find the name of the thing you want to delete 3. Delete this: <td><b>Whatever</b></td> 4. Go to the tbody section 5. Do the same Preview of 1.1: http://vhmrw.site90.com/index.php/fleetta Download attached. ------------------------------------------------------------------------------------------ Feedback appreciated, Mitchell Williamson FleetTable1.1FIXED.zip 3 Quote Link to comment Share on other sites More sharing options...
CPC900 Posted December 16, 2009 Report Share Posted December 16, 2009 Thank you. Quote Link to comment Share on other sites More sharing options...
Administrators Nabeel Posted December 16, 2009 Administrators Report Share Posted December 16, 2009 Moved to releases. Also, can you upload it as an attachment, it seems your site is down, thanks. Quote Link to comment Share on other sites More sharing options...
AFVA | Mitchell Posted December 16, 2009 Author Report Share Posted December 16, 2009 Moved to releases. Also, can you upload it as an attachment, it seems your site is down, thanks. Done. Thank you. Your Welcome Quote Link to comment Share on other sites More sharing options...
AFVA | Mitchell Posted January 12, 2010 Author Report Share Posted January 12, 2010 1.1 Released, info at the top ^^^ Features: ICAO, Type, Registration, Range, Empty Weight, Cruise Alt, Max Pax, Max Cargo, Total Hours, Total Routes Flown and Location Quote Link to comment Share on other sites More sharing options...
faraz Posted January 12, 2010 Report Share Posted January 12, 2010 I have problem With fleet 1.1 Fatal error: Class 'codonmodule' not found in /home/pav/public_html/data/core/modules/Fleet/Fleet.php on line 10 Quote Link to comment Share on other sites More sharing options...
faraz Posted January 12, 2010 Report Share Posted January 12, 2010 I have changed Line 10 in Fleet modules from codonmodule To CodonModule and worked for me ! Thank you AFVA | Mitchell Quote Link to comment Share on other sites More sharing options...
AFVA | Mitchell Posted January 12, 2010 Author Report Share Posted January 12, 2010 Recoded and reuploaded Quote Link to comment Share on other sites More sharing options...
Danny Posted January 20, 2010 Report Share Posted January 20, 2010 Maybe it would be a nice idea to have the picture on there aswell? Thanks for the script. Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted January 20, 2010 Report Share Posted January 20, 2010 Maybe it would be a nice idea to have the picture on there aswell? Thanks for the script. That would be cool. Thumbnails though. Some full size screen shots would basically destroy the layout pf pages. Quote Link to comment Share on other sites More sharing options...
Danny Posted January 20, 2010 Report Share Posted January 20, 2010 That would be cool. Thumbnails though. Some full size screen shots would basically destroy the layout pf pages. Yea i only thought something small like 100x100 Quote Link to comment Share on other sites More sharing options...
AFVA | Mitchell Posted January 21, 2010 Author Report Share Posted January 21, 2010 Try this, watch out, don't really have time to test it. Attached is the .tpl in a .zip with the included image feature. KEEP SIZE OF IMAGE SMALL! I recommend 80x80 but 100x100 should be ok. fleet_table.tpl V1.1.2.zip Quote Link to comment Share on other sites More sharing options...
Strider Posted January 21, 2010 Report Share Posted January 21, 2010 Thank you, i made a few changes to it, as i found you had an extra <table> tag which was obsolete. Removed that, also added a css rule so that the borders collapsed so they didn't llook weird, also changed the <b></b> to <strong></strong> just to help with validation. Also changed the link to this thread to open up in a new tab. Cheers Dan C Quote Link to comment Share on other sites More sharing options...
Moderators mark1million Posted January 24, 2010 Moderators Report Share Posted January 24, 2010 Great Stuff! Thanks for that. Saves me doing a static page Quote Link to comment Share on other sites More sharing options...
shiljo Posted January 26, 2010 Report Share Posted January 26, 2010 How to import that table in pages from Admin, its html, and this is php related, right? Any tip here, so i can learn something... Thxs Quote Link to comment Share on other sites More sharing options...
Strider Posted January 26, 2010 Report Share Posted January 26, 2010 As far as i know it doesn't import any pages from the admin, it creates a table of the fleet, from the fleet table in the database. Cheers Dan C Quote Link to comment Share on other sites More sharing options...
AFVA | Mitchell Posted January 29, 2010 Author Report Share Posted January 29, 2010 How to import that table in pages from Admin, its html, and this is php related, right? Any tip here, so i can learn something... Thxs Sadly, with this you can't. Fleet Table 1.1 uses its own SQL code in Fleet.php so making it into a html page from the admin center won't work.... Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted January 30, 2010 Report Share Posted January 30, 2010 Thanks for this hack. It works great. On my site, I have not used V2 of this yet with the thumbnail images, am still using the original. Here is a peak at how I have mine looking. I borrowed some code from Nabbel's Downloads list from the admin area and used it on the fleet table. It worked out great. http://thunderva.com/index.php/fleet Quote Link to comment Share on other sites More sharing options...
AFVA | Mitchell Posted January 30, 2010 Author Report Share Posted January 30, 2010 I have not used V2 of this yet with the thumbnail images Actually its 1.1.2 Here is a peak at how I have mine looking Looks very nice! Also while im here: Version 2.0 (Final Public Release Version) of the Fleet Table will be released soon.... FEATURES: Aircraft Image fleet_table.tpl bugs fixed. Fleet.php Fixes Some Information about fleet below the table Just a question....anyone interested in a 'Download' Link for each aircraft? Also if anyone has ANY requests for the page whether its got to do with the table or if you want something nice below it (screenshot gallery, downloads, checklists etc) Quote Link to comment Share on other sites More sharing options...
TAV1702 Posted January 30, 2010 Report Share Posted January 30, 2010 I love the idea for download from the table. I was going to do that tonight when I doctored mine up but I got antsy to do a flight. Quote Link to comment Share on other sites More sharing options...
faraz Posted February 5, 2010 Report Share Posted February 5, 2010 HI How can I show Fleet by airlines ? Quote Link to comment Share on other sites More sharing options...
stuartpb Posted February 20, 2010 Report Share Posted February 20, 2010 I really like this feature, but I wanted all of my fleet to be shown in the fleet page. As the code is set, planes will only appear once they have accrued flight time. As my VA is brand new, there are quite a lot of aircraft with no hours logged that won't show up in the fleet page. So I took the liberty of amending the SQL query in the /core/modules/fleet/fleet.php page: Original SQL: $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 INNER JOIN '.TABLE_PREFIX.'pireps p ON (p.aircraft = a.id) GROUP BY a.registration'; By changing the join function, I can now show all of the fleet, regardless of whether it has logged any flight time: Amended Code: $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'; Cheers, Stu Quote Link to comment Share on other sites More sharing options...
TennShadow Posted February 20, 2010 Report Share Posted February 20, 2010 Thanks for this! Quote Link to comment Share on other sites More sharing options...
stuartpb Posted February 20, 2010 Report Share Posted February 20, 2010 Thanks for this! No worries Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted February 20, 2010 Report Share Posted February 20, 2010 New to all this but love the fleet add on. Question - How can you add this to the main menu? I have just started customizing the standard package so not much changed. I would like to have the fleet link right next to the "live map" link. Thanks. Nevermind I figured that out but the image is not showing up. I put an image url attached to the fleet aircraft through the admin. When i open the fleet page image is not there. If i copy the image url from the missing image location it is the same url as the fleet page. what am i doing wrong? Quote Link to comment Share on other sites More sharing options...
TennShadow Posted February 21, 2010 Report Share Posted February 21, 2010 Nevermind I figured that out but the image is not showing up. I put an image url attached to the fleet aircraft through the admin. When i open the fleet page image is not there. If i copy the image url from the missing image location it is the same url as the fleet page. what am i doing wrong? I had the same problem. The code used to call the image is wrong. On the fleet_table.tpl change the following. <img src="<?php echo $aircraft->imageurl; ?>"> to <img src="<?php echo $aircraft->imagelink; ?>"> That should work for you. Quote Link to comment Share on other sites More sharing options...
AFVA | Mitchell Posted February 21, 2010 Author Report Share Posted February 21, 2010 FLEET TABLE 2.0 BETA - FINAL PUBLIC RELEASE Here is the BETA of Fleet Table 2.0 NEW FEATURES: Added download link Image fixes SQL Updated and more! It is attached. NOTE: This is only a BETA release and many things may not work yet. NOTE2: I'm gonna be away from Monday 22nd to Friday 27th (i think). FleetTable2BETA.zip 1 Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted February 21, 2010 Report Share Posted February 21, 2010 I had the same problem. The code used to call the image is wrong. On the fleet_table.tpl change the following. <img src="<?php echo $aircraft->imageurl; ?>"> to <img src="<?php echo $aircraft->imagelink; ?>"> That should work for you. Thanks worked like a charm. You know I saw this and changed it but I must have typoed or something. Could not get it to work. Does now though. Thanks again. Quote Link to comment Share on other sites More sharing options...
crnjola Posted March 13, 2010 Report Share Posted March 13, 2010 Hello !! I have a preoblem !! Where I have to put aircraft images ? I tired to ../images/aircraft, but didnit work !! I make mistake ?? Please help !! Quote Link to comment Share on other sites More sharing options...
TennShadow Posted March 13, 2010 Report Share Posted March 13, 2010 Hello !! I have a preoblem !! Where I have to put aircraft images ? I tired to ../images/aircraft, but didnit work !! I make mistake ?? Please help !! You upload the images to your server then you go to Airline Operations --> Add and Edit Fleet . From there you click on the aircraft you want to add a picture to and the add the full URL to the "Link to Aircraft Image" field. The module will then display the image. Hope this helps! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.