A Master Stats Table

For bug reports and fixes, installation issues, and new ideas for technical features.

Moderator: SEOW Developers

Post Reply
USN_Opus
Posts: 41
Joined: Mon 14 Mar 2011 11:54 am

A Master Stats Table

Post 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!!!
II/JG54_Emil
Posts: 272
Joined: Thu 07 May 2009 10:45 am

Post by II/JG54_Emil »

Yes where is the donation link?

Can I donate Weißbier Brezel and Weißwurst?
IV/JG7_4Shades
Posts: 2203
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post 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
IV/JG7_4Shades
SEOW Developer

Image
USN_Opus
Posts: 41
Joined: Mon 14 Mar 2011 11:54 am

Post 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!
Post Reply