From feba756702085906b659c892ab18b0aadc9ef447 Mon Sep 17 00:00:00 2001 From: schneefux Date: Tue, 25 Jul 2017 08:51:37 +0200 Subject: calculate trueskill on the fly --- crunch_player.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'crunch_player.sql') 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, -- cgit v1.3.1