Pilot/ATC/Station Statistics

[John Moen 988121]

I'm working on a statistics solution for our VACC.

What i'm trying to achieve is statistics based on possitions and vacc members.(like: 'top possitions of the month', 'top controllers of the month' and 'top flyer of the month').

I really think having this kind of statistics on the webpage really would encourage members to become more active, and man more possitions or even fly more over time.

 

Have anyone done this before? Is there any code snipplets around somewhere? Anybody willing to share?

 

It would really save me alot of time if someone already have done this before, and is willing to share the sourcecode.(and i'm pretty sure it would be usefull for others aswell), there's no point in inventing the wheel over and over again...

[Christoph Neukirch]

Hi John,

 

in germany we have our Stats. They're collected worldwide so you can get at least the stats for your stations. Unfortunately not for single members, i don't know if there's a vACC with stats like this already.

 

kind regards

Christoph

[John Moen 988121]

Hi Christoph!

 

I had a look at site you referred to, and that's partly what i'm looking for.

We have our own membership db, so thats just a matter of comparison to filter out what to show.

 

How are you collecting data? do you p[Mod - Happy Thoughts] the vatsim datafeed? ...or do you use another kind of interface?

 

If i can get the hold of a base of that sourcecode, i can rewrite it to fit my needs and repubish it back to the forums if thats OK with the author of the original code.

 

Regards

 

John

[Gerry Hattendorf 935415]

Hey John,

 

I created some PHP/MySQL scripts to track and record our controllers hours at ZLA. I also have a page to show the "top 10" controllers I'm more than willing to share. Again as I use the LAMP stack, so if you are using a different protocol i.e. ASP/Firebird or something like that you will need to change the syntax.

 

Let me know if this interest you!

 

Cheers!

[John Moen 988121]

Hi Gerry!

 

That interest me alot! I primary write javascript powered php and mySQL but i'm capable of rewriting it from asp/net if thats your language..

 

Just send me a PM or reply in this thread if you can provide me the files

 

Regards

 

John

Edited May 10, 2011 at 10:54 AM by Guest

[Gerry Hattendorf 935415]

No problem John,

 

Actually as I use a LAMP (Linux, Apache, MySQL, PHP) stack, this docomeent should be very easy for you to incorporate;

 

http://www.laartcc.org/TrackingHours.doc

 

Hope that helps to get you started!

 

PS, Just a word of warning, this code was written for PHP 4.x be advised the eregi() is depreciated in PHP 5.x. Also there are some routines you could optimize a bit better using the enriched PHP code libraries rather than my somewhat archaic UNIX/C library calls! (I guess that dates me a bit! )

[Christoph Neukirch]

Hi John,

How are you collecting data? do you p[Mod - Happy Thoughts] the vatsim datafeed? ...or do you use another kind of interface?

 

If i can get the hold of a base of that sourcecode, i can rewrite it to fit my needs and repubish it back to the forums if thats OK with the author of the original code.

yes, we're parsing the datafeed. It's developed by Thomas Purbs and published in this thread. So maybe he can add the things you're missing on request and i guess on request he could send you the source. It's written in PHP and the data is collected in MySQL.

 

kind regards

Christoph

[Jaeyong Jeong 1032491]

No problem John,

 

Actually as I use a LAMP (Linux, Apache, MySQL, PHP) stack, this docomeent should be very easy for you to incorporate;

 

http://www.laartcc.org/TrackingHours.doc

 

Hope that helps to get you started!

 

PS, Just a word of warning, this code was written for PHP 4.x be advised the eregi() is depreciated in PHP 5.x. Also there are some routines you could optimize a bit better using the enriched PHP code libraries rather than my somewhat archaic UNIX/C library calls! (I guess that dates me a bit! )

 

Hi.

 

Can i get "TrackingHours.doc" ?

[Colin Schoen]

https://berkeley.box.com/trackinghours

 

A lot of the code is old and deprecated, but I suppose you can use it to get a general idea about how to get started.