UTStatsDB Version 3.09
Following the release of 3.08, which focussed on providing modern DB and PHP support, this release begins to introduce some general codebase cleanup. Primarily, old styles are resource files have been removed, a lot of old code has been cleaned out and cleaned up, and many improvements have been made to SQL queries and caching to reduce DB load and improve page load times.
When upgrading, after applying the updated files, please visit the Admin page and click the "Update DB" menu link to update the database, which will resolve broken style issues following application of the new files.
For new installations, UT2004 map images are available from the 3.08 release.
Changes since 3.08
- Clean out old resource files, remove some old styles.
- Clean out upgrade code for versions < 3.07.
- Add better time/duration display/format (eg. 15 minutes shows as "15m", rather than "0.25").
- Consolidate and optimise several SQL queries using JOINs, rather than multiple repeat lookups.
- In some cases, don't display stats section where no data is present (eg. "Vehicle and Turret Specific Information").
- Cache (in-memory) several query results for faster execution.
- Significantly reduce SQL query count during log parsing by optimising queries and caching. ~78% reduction in query count.
- Use standard footer in admin pages.