pikitanga

I was trying to suggest a solution in my original post that was fair to everyone. The answer to your question is "the small VA would receive the better ranking" ? You already calculate "Total active pilots in the airline over last 7 days". So why not calculate "Total pilots on roster" = "Total active pilots in the airline over last 90 days". Then plug that into your existing formula. (Which I think is fine by the way.) That way vaCentral is using a more accurate value for "Total pilots on roster". A brand new airline with 1 pilot would still get 1000 points using the formula, which is fine. We currently have 77 pilots who have flown in the last 90 days, 36 of which have flown in the last 7 days. 36/77 x 1000 = 467 pts. A semi new airline with say 10 pilots 9 of which are still flying would get 900 pts. So a small VA can do just as well if not better than a old VA with a large roster of pilots not flown anytime recently. Seems reasonable and fair to me. Duncan

I have solved the landing rate problem by writing a X-Plane plugin which copies the latest entry in the landing log created by the existing Landing Speed plugin, sending it off to phpvms.

I would like to give some feedback on the ranking system from the perspective of ZonExecutive. We have moved from rank #24 (old) to rank #132 (new). Our policy on deleting pilots is as follows: Once you've completed your first flight, your account will never be suspended or deleted for inactivity. You are free to take a break, come back and fly again at any time. However, if you do not fly within 100 days of your registration, we'll automatically delete your account unless you've logged in within the past 30 days, or have posted at least once on our forums. As we have been around for a while we have 592 pilots. Our active pilots is 36 ie those who have flown in the last 7 days. Our flight time is 415 hours in the last 7 days. Basically because of our 592 on the pilot roster we only get 60.811 pilot points and 70 flight time points. Airlines with 1 pilot on their roster are getting 1000 points just like that. I think a more fair system would be to calculate the number of pilots on roster as being those pilots in an airline who have flown in the last 3 months. ie using the same data you calculate active pilots with This would then be consistent across all airlines since vaCentral would be applying a set formula across all airlines the same, rather than an airlines policy on retiring/deleting pilots skewing the result. My second problem is landing rate. Based on the airlines who have landing rates we are losing on average 750 points. We are an X-Plane va using xacars, which does not have a landing rate. The developer of xacars has some very good reasons for not adding it, which I won't go into here. How about giving airlines which cannot provide a landing rate the points of the worst performing airline who do have landing rate capability just to even things up a bit. (Currently 414.9 pts) That way airlines with a landing rate still have an incentive to land well without airlines like Zon being so disadvantaged. Otherwise I could just generate a random landing rate between -25 to -450 ie rand(25,450) * -1 and just send that in with each pirep. Duncan VP of Operations ZonExecutive

Hi David, With the new ranking system, do you know why some of the top airlines never seem to appear on the live map ? Regards, Duncan

Do you have the SQL in post #6 reversed ie shouldn't you be adding 'p.rawdata' not removing ?

Hi simpilot, As ZonExecutive uses 'xacars' we cannot return a landing rate. Should we return blank/empty for the landing rate ? Cheers, Duncan VP of Operations, ZonExecutive