Fleet Table

[AFVA | Mitchell]

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

[CPC900]

Thank you.

[Nabeel]

Moved to releases. Also, can you upload it as an attachment, it seems your site is down, thanks.

[AFVA | Mitchell]

Moved to releases. Also, can you upload it as an attachment, it seems your site is down, thanks.

Done.

Thank you.

Your Welcome

[AFVA | Mitchell]

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

[faraz]

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

[faraz]

I have changed Line 10 in Fleet  modules from

codonmodule

To

CodonModule

and worked for me !

Thank you AFVA | Mitchell

[AFVA | Mitchell]

Recoded and reuploaded

[Danny]

Maybe it would be a nice idea to have the picture on there aswell?

Thanks for the script.

[TAV1702]

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.

[Danny]

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

[AFVA | Mitchell]

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

[Strider]

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

[mark1million]

Great Stuff! Thanks for that. Saves me doing a static page

[shiljo]

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

[Strider]

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

[AFVA | Mitchell]

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....

[TAV1702]

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

[AFVA | Mitchell]

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)

[TAV1702]

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. 

[faraz]

HI

How can I show Fleet by airlines ?

[stuartpb]

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

[TennShadow]

Thanks for this!

[stuartpb]

Thanks for this!

No worries

[Guest lorathon]

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?

[TennShadow]

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.

[AFVA | Mitchell]

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

[Guest lorathon]

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.

[crnjola]

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 !!

[TennShadow]

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!