FAForever / FAForever/db

Add new column average_rating to game_stats

Open
#282 6 comments 0 reactions 0 assignees View on GitHub
Dominant language
Shell
Stars
11
Forks
20
PR merge metrics
No merged PRs in 30d

Description

I'm working on a bot command to show top rating replays for a specific period, i.e. list replays max 1 week old with high rated players.

The current poor man version is something like this:
`
https://api.faforever.com/data/game?include=playerStats.player&sort=startTime&page[limit]=1&filter=startTime=gt=2021-08-01T11:58:02Z;playerStats.player.globalRating.rating=gt=2000
`
Then I at least get a game with at least one player having globalRating.Rating > 2000 but that could be a high rated player bashing noobs. Another problem is that it is the current rating, not the rating when the game was played.

What I really want is to be able to query and sort on the players average_rating of a game, I guess this would require a new column to game_stats which is then populated by the python server at start?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.