diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-10-09 21:20:45 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-10-09 21:20:45 +0200 |
| commit | 749869b2abbb77ebaab82f12cec7c01a69ac1d02 (patch) | |
| tree | 22d8b106d4286b5871678bdb7d78fac0c645d1fa /crunch_player.sql | |
| parent | 7693ad926eae8baa937d180d0fa4b7e9cb0ee7aa (diff) | |
| download | cruncher-749869b2abbb77ebaab82f12cec7c01a69ac1d02.tar.gz cruncher-749869b2abbb77ebaab82f12cec7c01a69ac1d02.zip | |
player_point: add trueskill_ranked_max
Diffstat (limited to 'crunch_player.sql')
| -rw-r--r-- | crunch_player.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/crunch_player.sql b/crunch_player.sql index ea10d95..4ad2dd4 100644 --- a/crunch_player.sql +++ b/crunch_player.sql @@ -17,6 +17,7 @@ select -- special player_point facts max(p.trueskill_mu-p.trueskill_sigma) as trueskill_max, + max(p.trueskill_ranked_mu-p.trueskill_ranked_sigma) as trueskill_ranked_max, sum(p.trueskill_delta) as trueskill_delta, sum(p.trueskill_mu) as trueskill_mu, sum(p.trueskill_sigma) as trueskill_sigma, @@ -54,6 +55,7 @@ updated_at = case when values(updated_at) > updated_at then values(updated_at) e played = played + values(played), wins = wins + values(wins), trueskill_max = case when values(trueskill_max) > trueskill_max then values(trueskill_max) else trueskill_max end, +trueskill_ranked_max = case when values(trueskill_ranked_max) > trueskill_ranked_max then values(trueskill_ranked_max) else trueskill_ranked_max end, trueskill_delta = trueskill_delta + values(trueskill_delta), trueskill_mu = trueskill_mu + values(trueskill_mu), trueskill_sigma = trueskill_sigma + values(trueskill_sigma), |