Page 1 of 1

A Master Stats Table

Posted: Mon 11 Apr 2011 12:55 pm
by USN_Opus
Seriously Shades, you need a donations link! What a masterpiece...! At least PM my you address and I'll send you some of Canada's best maple syrup!

Any how, enough gushing for now...

Is there any (easy) way to combine stats from multiple campaigns into one master table?

We keep track of all our pilots cumulative achievements but as we are looking to become a full SE squad, this might be a problem or at the very least, time consuming.

Thanks!!!

Posted: Mon 11 Apr 2011 3:08 pm
by II/JG54_Emil
Yes where is the donation link?

Can I donate Weißbier Brezel and Weißwurst?

Posted: Mon 11 Apr 2011 9:44 pm
by IV/JG7_4Shades
Sadly, Emil, you will need to travel to Neumarkt and buy me some Lammsbraeu!

The stats pages are built by a complex set of scripts from the full campaign records in the DB. Using the StatsCache feature (enabled by default) you can convert the stats into static HTML pages which can be archived forever. Aggregation across sectors or campaigns is difficult because the campaign information is housed in separate databases with separate contexts etc.

Maybe it would be simplest to take the Pilots statistics table from each campaign front page and import them into a spreadsheet...

Cheers,
4Shades

Posted: Wed 13 Apr 2011 11:37 am
by USN_Opus
LOL Emil..

Roger that Shades...I'm no geaniuse with PHP/mySQL but maybe I can whip something up that would be passable as a general summery page. If I do one day, I'll post the code.

Again, thanks!