Website Update - Issue 7 (team stats)
Some new changes on this temp website STILL wah...
Team Stats System Update #
I've rolled out some changes to the stat system.
Calculated Points #
In the past, I've been tracking points using the season points data. The problem doing that is, it's inaccurate during change of seasons and no points are given to players that did little races during season.
Now I use the Team Stats and calculate the points manually.
See: https://www.nitrotype.com/news/read/100/introducing-seasons- regarding how points are calculated.
There is a very small deviation in the points compared to using the season points. Nitro Type doesn't provide me individual points earned per race.
The formula for this is basically the same, only the WPM and Accuracy from X races within 15 minute gap is used instead.
Other changes #
- Temporarily removed the "stat cache" until I roll out the new cache for it; stats will load a little slower for now
- Fixing "Left At" and "Join At" dates on Team members that Team Hop between tracked teams (eg. FOLLY member left to join TIPTOP)
- Minor updates to tools used for collecting stats
- Refactored the database schema to save disk space and performance for the Calculated Points (apparently I saved around 75% of the file usage)
- Fix possible bug where getting the stat data during the "end time" is not collected because of stat collection times.
Problems? Maybe #
I had a quick test while doing this, and it appeared alright so far. There was one fail stat collection fail during the launch (I forgot to update the database fully oops hehe).
If you think there's problems, let me know...
However, I'm tired 1:52am, so I'll sleep. And I'll probably be too drained again from Work... but I'll fix the major ones. Expect more updates to be made anyway, I'm not fully done it seems.
Known Issues #
- Need to have all teams collect stats at the same time if possible
- Stats load a bit slower because I removed the cache; it's surprisingly loading ok despite the heavy task of calculating points
Trivial #
- Doing the database migration finished after my 100th race on the current session hehe.
- Never do the database migration from your home internet... it was slow and I lost connection during a race wah
Enjoy,
- Silje P. Entidy