diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-07-25 08:51:37 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-07-25 08:51:37 +0200 |
| commit | feba756702085906b659c892ab18b0aadc9ef447 (patch) | |
| tree | 43f8c353b1b9266931397e4705bd6782765cbd06 | |
| parent | 0b37ae96e446df3af3f37694672daaca2fbc2c96 (diff) | |
| download | cruncher-feba756702085906b659c892ab18b0aadc9ef447.tar.gz cruncher-feba756702085906b659c892ab18b0aadc9ef447.zip | |
calculate trueskill on the fly
| -rw-r--r-- | crunch_player.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/crunch_player.sql b/crunch_player.sql index 75432e8..4a36bb7 100644 --- a/crunch_player.sql +++ b/crunch_player.sql @@ -15,7 +15,7 @@ select sum(p_s.duration) as time_spent, -- special player_point facts - max(p.trueskill) as trueskill, + max(p.trueskill_mu-p.trueskill_sigma) as trueskill, sum(p.trueskill_mu) as trueskill_mu, sum(p.trueskill_sigma) as trueskill_sigma, 0 as elo, |