26-04-2006, 08:50 AM
1st off, great program, great script!!
I have altered the VA script to allow pilots to add comments to thier flights if they want and to display indivdual pilot stats. I can't seem to
get one thing to work though.
I want to retrieve to Total Flight Time form the SQL database for each pilot. I can get the sum but it displays as a whole number and not in
hours, minutes and seconds.
Example:
Result after query is run: 1236894
Should be: 143:46:14
On my "Individual Pilot Stats" page it does list the total flight hours for each pilot but I cannot figure out how it was done. My programming skills are not that great.
I need this total to make a page that will allow my pilots to update thier rank, without cheating!!
Dan,
I know you are busy improving FS Passengers, but it would be really cool if an update and a script like the VA script came out that allowed
us to export the "Pilot Details" showing thier rank, total flight time, time and points needed for next rank ect..
Thanks in advanced.
Post Edited ( 04-26-06 09:56 )
I have altered the VA script to allow pilots to add comments to thier flights if they want and to display indivdual pilot stats. I can't seem to
get one thing to work though.
I want to retrieve to Total Flight Time form the SQL database for each pilot. I can get the sum but it displays as a whole number and not in
hours, minutes and seconds.
Example:
Result after query is run: 1236894
Should be: 143:46:14
On my "Individual Pilot Stats" page it does list the total flight hours for each pilot but I cannot figure out how it was done. My programming skills are not that great.

Dan,
I know you are busy improving FS Passengers, but it would be really cool if an update and a script like the VA script came out that allowed
us to export the "Pilot Details" showing thier rank, total flight time, time and points needed for next rank ect..
Thanks in advanced.
Post Edited ( 04-26-06 09:56 )
Wayne
FS Passengers Flight Log:
http://www.dcvirtual.com/flightstats.php
VATSIM Stats
http://www.dcvirtual.com/vatstats.php
![[Image: sdc16]](http://www.fspassengers.com/images/banner/sig/sdc16)
FS Passengers Flight Log:
http://www.dcvirtual.com/flightstats.php
VATSIM Stats
http://www.dcvirtual.com/vatstats.php