PHP Help Please (VA Script)

[Vegas_09]

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 )

[DBE]

Hey Wayne,

If you are trying to display a list of each pilot with his/her total flying time, then use this function in the query: "SEC_TO_TIME(SUM
(TIME_TO_SEC(t1.TotalBlockTime))) As SumBlockTime".

Then display the "SumBlockTime" variable instead of the "t1.TotalBlockTime" one.

[Vegas_09]

Got it figured out now. I used Dans, or whoever made the VA script, add time function. Everything is good to go now!!
http://www.stjohnsoffice.net/fspass/PilotStats.php

Now if my pilots update thier rank they cannot select a rank that has a larger flight hour requirement than thier recorded flight time. No
way of knowing thier score, so I can't keep them from cheating the script that way..boo! Agian, would love to see somebody build a script
that exports the pilot stats, like the VA script.

I have added your suggestion to my "scripts folder" , thank you!!



Post Edited ( 04-26-06 21:21 )

[2RIP]

Well I don't even have any php skills at all, but i still use a php host just for FSP :D can someone tell me the full php code for the pilot's flown
time and is it possible to extract the hours to a different page using another code?