Commits

Author Commit Message Labels Comments Date
Carey Tilden
Reworked query to split sessions based on 30 min gaps in activity rather than join/quit events
Carey Tilden
Created scripts for Restore the Wasteland
Carey Tilden
Copied summary and detail scripts for new map
Carey Tilden
Added detailed list of deaths
Carey Tilden
Added player user name to the results
Carey Tilden
Added script for new map
Carey Tilden
Made life length calculation more accurate for lives that had no idle time
Carey Tilden
Reworked life length distribution to avoid counting idle time
Carey Tilden
Added total rows
Carey Tilden
Switched to round instead of ceil, so interval groups are more of a mid point than an upper limit
Carey Tilden
Added a column to show an average minutes per life for each time group
Carey Tilden
Created sql for analyzing superhostile 8 data
Carey Tilden
Created queries for mapping spellbound caves
Carey Tilden
Merged accidental branch
Carey Tilden
Created queries used for generating maps
Carey Tilden
Created queries for spellbound caves
Carey Tilden
Added queries to group results without regard to date
Carey Tilden
Added query to show playtime per day by each unique set of players
Carey Tilden
Avoided counting idle time and greatly simplified query at the same time
Carey Tilden
Changed function calls to view names
Carey Tilden
Moved server cwd logic into main view
Carey Tilden
Removed subquery using a different method to extract cwd basename
Carey Tilden
Made code a bit more robust
Carey Tilden
Converted most functions to views
Carey Tilden
Added a function to give a brief view of each log row
Carey Tilden
Split script into two with varying levels of detail
Carey Tilden
Added a table listing how much time each person put in on each day
Carey Tilden
Created a script for Legendary
Carey Tilden
Added a query to find blocks placed on the victory monument
Carey Tilden
Fixed occurences_per_hour to use the time each player spent on that particular day
  1. Prev
  2. Next