Support Time Attack ranking
While developing the Recent Activity endpoint, we realized that players will also want to submit their Time Attack PBs. We want to be able to show a player's incremental improvement in regards to time in addition to grade-level-time.
Ideas:
- Modify ranking calculation to allow sorting by just time (when game has been cleared) and add this calculation step to the score insert trigger
- Problems:
- Information will only show up on the recent activity response
- calculate_ranking function will get even more complicated
- Determining what a "clear" is is different for each mode (#83 (closed) score validation issue should be addressed first?)
- Problems:
- Create new "time attack" modes
- Problems:
- Too many modes?
- Players potentially will need to submit scores twice or we can modify scores to belong to multiple modes (though that also has problems).
- Problems:
- Just don't rank Time Attack. It's enough to just sort the mode rankings by level then time
- Problems:
- What gets shown in recent activity for Time Attack PBs?
- Players may be less motivated.
- Doesn't always work
- Problems:
Edited by MHL