Jump to content
simpilot

TOPPilot beta 1.0

Recommended Posts

TOPPilot beta 1.0

phpVMS module to extract monthly flight statistics for individual pilots from your phpVMS based virtual airline.

Developed by:

simpilot

www.simpilotgroup.com

Developed on:

phpVMS 2.0.874

php 5.2.11

mysql 5.0.51

apache 2.2.11

Included files:

readme.txt

top_flight.sql

TopPilot.php

TpPilotData.class.php

tp_index.tpl

tp_previous.tpl

Install:

-Download the attached package.

-unzip the package and place the files as structured in your root phpVMS install.

-use the top_flights.sql file to create the table needed in your sql database using phpmyadmin or similar.

-after the initial install point your browser to yoursite/index.php/TopPilot/refresh_pilot_stats one time. This will populate the database table with any data available.

-to view the main TopPilot index create a link yoursite/index.php/TopPilot

-everytime a pirep is filed the module will recalculate the pilot stats and update the database

There are three main display functions within the TopPilotData class that you can configure to use in various parts of your site.

Flights flown - TopPilotData::top_pilot_flights($month, $year, 5)
Hours flown -  TopPilotData::top_pilot_hours($month, $year, 5)
Miles flown - TopPilotData::top_pilot_miles($month, $year, 5)

$month should be the two digit month id of the month you want data from – ie 06 = June

$year is the four digit year you are pulling – ie 2010

5 – can be changed to how many records you want returned.

Excluding PIREPS that are not accepted yet.

TopPilot.php line 52.

Uncomment the trailing section and the module will not include unapproved PIREPS. Doing this will cause the module not to display any newly accepted PIREPS in the TopPilot data listings until after another PIREP is filed although you can refresh the stats at anytime using – yoursite/index.php/TopPilot/refresh_pilot_stats

Although this script carries no limits of use a link back to www.simpilotgroup.com would be greatly appreciated!

Have fun!

Can someone explain to me in layman's terms on how to create a table using phpmyadmin, I don't think I understand how it actually works, I am very new to doing these kinda things.

Share this post


Link to post
Share on other sites

Can someone explain to me in layman's terms on how to create a table using phpmyadmin, I don't think I understand how it actually works, I am very new to doing these kinda things.

What you do is log into your database with phpmyadmin or something similar and then you import the top_flights.sql file. It will then automatically create the needed tables for this module. Hope this helps.

Share this post


Link to post
Share on other sites

What you do is log into your database with phpmyadmin or something similar and then you import the top_flights.sql file. It will then automatically create the needed tables for this module. Hope this helps.

Would it be placed in the

www/core/modules
folder or where?

Share this post


Link to post
Share on other sites

BUMP :)

My other question is.....can transferred hours be accounted for in the Top Pilots Hours Flown??

Share this post


Link to post
Share on other sites

I notice from today that the months are messed up again :(

I think it is something to do with the end of the month and the time difference from the server and GMT... It always seems to correct itself after the 1st of the month, on my site anyway. I have not messed with this mod for a bit, I am not sure what or if I tracked it down.

Share this post


Link to post
Share on other sites

BUMP :)

My other question is.....can transferred hours be accounted for in the Top Pilots Hours Flown??

I did not respond to it as it did not make sense to me to include transfered hours every month to a pilots stats. If you want to, you can:

Open TopPilotData.class.php

find line 54

$totaltime=0;

and change to

$totaltime=$pilot->transferhours;

That will add the transfer hours to the pilots time each month.

B)

Share this post


Link to post
Share on other sites

Would it be placed in the folder or where?

This question got skipped for reply, still need answer if you have one. (^5 posts up^)

Share this post


Link to post
Share on other sites

This question got skipped for reply, still need answer if you have one. (^5 posts up^)

The sql file is to create the needed table in your database. You need to go into phpMyAdmin and either import it into your database with the import function or copy the text of the file into the sql box and run it that way. The file does not need to be on your server, once you have loaded it into the database you should not need it again.

Share this post


Link to post
Share on other sites

I did not respond to it as it did not make sense to me to include transfered hours every month to a pilots stats. If you want to, you can:

Open TopPilotData.class.php

find line 54

$totaltime=0;

and change to

$totaltime=$pilot->transferhours;

That will add the transfer hours to the pilots time each month.

B)

Sorry, I guess I meant for the TOTAL numbers for the pilots, not the monthly ones. But I see your point. I just wanted the total hours to add the transferred hours in for that...not for the month totals. Thanks. :)

Share this post


Link to post
Share on other sites

I see you meant TopPilot.php :)

See, now I just want to add the transfer hours to the ONE total of "public function alltime_hours ($howmany) {" on Line 57 of TopPilotDataClass.php....I think?! But not having much luck. I don't want to screw up any of the monthly stuff....just that ONE total is all.

Share this post


Link to post
Share on other sites

I see you meant TopPilot.php :)

See, now I just want to add the transfer hours to the ONE total of "public function alltime_hours ($howmany) {" on Line 57 of TopPilotDataClass.php....I think?! But not having much luck. I don't want to screw up any of the monthly stuff....just that ONE total is all.

To include transfer hours in the totals ->

open TopPilotData.class.php

find line 58

$query = "SELECT pilotid, totalhours FROM phpvms_pilots ORDER BY totalhours DESC LIMIT $howmany";

and change to

$query = "SELECT pilotid, totalhours, transferhours FROM phpvms_pilots ORDER BY totalhours DESC LIMIT $howmany";

Open tp_index.tpl

find line 70

echo $row->totalhours;

and change to

echo ($row->totalhours + $row->transferhours);

Share this post


Link to post
Share on other sites

In "tp_index.tpl" I don't have a line that says "echo $row->totalhours;". Line 70 says " foreach ($topflights as $top) {" ?!?

Share this post


Link to post
Share on other sites

I re-installed the module, but now I have a problem with this:

"Warning: Invalid argument supplied for foreach() in /home/woodsdom/public_html/CPC/core/templates/tp_index.tpl on line 24"

Line 24 is:

"foreach($all_flights as $all) {"

I don't understand where this went wrong. Nothing was edited except for pointing to the correct database in the "TopPilotDataClass.php file". It was working fine the other day!

http://www.canadianclassicairlines.com/CPC/index.php/TopPilot

Share this post


Link to post
Share on other sites

*Bump*

Please let me know what is wrong here?! The monthly stuff workis fine, but I get the error for the all time totals, and I can't figure out why.

Share this post


Link to post
Share on other sites

*Bump*

Please let me know what is wrong here?! The monthly stuff workis fine, but I get the error for the all time totals, and I can't figure out why.

My guess is that you are not using the standard phpvms_ table prefix in your db. If this is the case, you will have to change the sql commands on lines 52 & 58 in TopPilotData.class.php in root/core/common/ to reflect your db prefix, or you could insert the TABLE_PREFIX command, which I should have done in the first place...

Share this post


Link to post
Share on other sites

In "tp_index.tpl" I don't have a line that says "echo $row->totalhours;". Line 70 says " foreach ($topflights as $top) {" ?!?

My bad - it is actually line 45.

I was looking at a customized version of the custom module of a ... .... errr...... you get the idea. Way too many files floating around on my box, time to start deleting some I think. B)

Share this post


Link to post
Share on other sites

I just noticed that my top pilot lists the last 6 months as:

January - 2010

March - 2010

March - 2010

April - 2010

May - 2010

June - 2010

The first march stats are actually February?! But I can't find where/why it list March twice?!

Share this post


Link to post
Share on other sites

Have a look today, i fixed it :lol:

Only messing but i bet its back to normal though, :)

It messes with up slightly on the last day of the month but after that itsOK again.

Share this post


Link to post
Share on other sites

Good day

guys I'm having trouble installing the module TopPilot.

let the following description of the error that this showing me

Ouvir

Ler foneticamente:

Warning: Invalid argument supplied for foreach() in /home/vhosts/kaflyportugal.noads.biz/core/templates/tp_index.tpl on line 24

please help me!

thanks

Share this post


Link to post
Share on other sites

Could be a number of things:

Did you load the sql tables to your database?

If so, did you run the "refresh_pilot_stats" command?

Are there any contents in the db after running that?

Also, if the va has no pireps the module will not work.

Share this post


Link to post
Share on other sites

my friend

I have already approved the flights go, and already ran the command you mentioned, but stays the same.

I put the contents in the right folders on the server!

a question:

if command is executed in the browser or phpmyadmin?

thanks

Share this post


Link to post
Share on other sites

I have already approved the flights go, and already ran the command you mentioned, but stays the same.

I put the contents in the right folders on the server!

a question:

if command is executed in the browser or phpmyadmin?

The sql files would be loaded using phpmyadmin and the refresh command would be used in your browser address bar, but you say you already did this, right?

Share this post


Link to post
Share on other sites

how do i align it so it is normal on the Obsess Blue Template? as it is way at the bottom

Thanks

Daniel

Everything needs to sit between those two divs, class="mcright" :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×