From feba756702085906b659c892ab18b0aadc9ef447 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
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

