Stat Repairs, Requests and Bugs

[Eagletree]

Somewhere in here, I mentioned to someone that the squad stat reports were down due to the Wiretap server being dead. The squad reports are now reworked to eliminate dependency on Wiretap. They instead use a direct feed from a backup game db which is just as efficient, less hacky, and contains no spurious squads.

Elsewhere, in several posts, people noted that the CSR 2.0 lacked a direct link to killers and "killees", plus either should show the weapon they were using. All Persona, Player, and Weapon reports that show sortie information, now have clickable killers and killnames, that also show the weapon in use. The click-through loads a detail sortie information page for either who you've killed and who killed you.

Performance is relatively good for all reports now. It will be ten-fold better when we have the new DB, but elimination of the 94/95 campaign conflict, some in-fighting with update scripts, and several DB corruptions, now makes even accessing the old DB acceptable. The only remaining report that seems too slow is the Squad Vs Squad.

Totals shown in the 24 hour report of your personalized CSR 2.0 home page, are now correct.

Weapons Summary now displays the correct weapon rather than the generic version (e.g., German Rifleman vs Rifleman). This was causing a failure to load all the sorties for that weapon.

Near-term plans are:

1. Get off the old DB. This is a joint project with TGUNR which we hope to accomplish within the next week. It keeps sliding due to other more pressing infrastructure issues. Most improvements such as features and performance enhancments, are predicated on this.

2. Pull additional game db data to allow FB, FRU and other damage oriented reporting currently not possible.

3. Player Top List query replacement/correction. The current ones are stand-ins until we have enough performance headroom to do them correctly.

4. Squad Achievements

5. Historical tracking of all Achievements

6. Finalization of metrics that constitute Achievements. The present Achievement log is a rough first attempt.

7. Date ranges for all (or all applicable) reports.

8. CSV Data Extracts for use by those who want to crunch stat data, but have no interest in programming. We have a sortie prototype in place. If anyone is interested, PM me.

Feel free to use this thread to report other issues and desires as related to stats. I already have a list that contains all ideas presented in earlier stat discussions, but if you have new ideas, please drop them here.