From 9841965b47d4b54f28d3f3c0c0f44943976994aa Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Tue, 25 Jul 2017 13:15:50 +0200
Subject: add trueskill delta, rename trueskill max

---
 crunch_global.sql |  2 ++
 crunch_player.sql | 10 ++++++----
 2 files changed, 8 insertions(+), 4 deletions(-)

diff --git a/crunch_global.sql b/crunch_global.sql
index 0a2ab4b..176b296 100644
--- a/crunch_global.sql
+++ b/crunch_global.sql
@@ -16,6 +16,7 @@ select
     -- everything added here needs to be in on DUPLICATE too!!!
     count(p.id) as played,
     sum(cast(p.winner as INT)) as wins,
+    sum(p.trueskill_delta) as trueskill_delta,
     sum(p_s.duration) as time_spent,
     sum(p_s.kills) as kills,
     sum(p_s.deaths) as deaths,
@@ -63,6 +64,7 @@ order by p.id
 on duplicate key update
 played = played + values(played),
 wins = wins + values(wins),
+trueskill_delta = trueskill_delta + values(trueskill_delta),
 time_spent = time_spent + values(time_spent),
 kills = kills + values(kills),
 deaths = deaths + values(deaths),
diff --git a/crunch_player.sql b/crunch_player.sql
index b3ca8c6..c102f44 100644
--- a/crunch_player.sql
+++ b/crunch_player.sql
@@ -16,7 +16,8 @@ select
     sum(p_s.duration) as time_spent,
 
     -- special player_point facts
-    max(p.trueskill_mu-p.trueskill_sigma) as trueskill,
+    max(p.trueskill_mu-p.trueskill_sigma) as trueskill_max,
+    sum(p.trueskill_delta) as trueskill_delta,
     sum(p.trueskill_mu) as trueskill_mu,
     sum(p.trueskill_sigma) as trueskill_sigma,
     0 as elo,
@@ -51,10 +52,11 @@ order by p.id
 on duplicate key update
 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_delta = trueskill_delta + values(trueskill_delta),
+trueskill_mu = trueskill_mu + values(trueskill_mu),
+trueskill_sigma = trueskill_sigma + values(trueskill_sigma),
 time_spent = time_spent + values(time_spent),
-trueskill = case when values(trueskill) > trueskill then values(trueskill) else trueskill end,
-trueskill_mu =  case when values(trueskill_mu) > trueskill_mu then values(trueskill_mu) else trueskill_mu end,
-trueskill_sigma = case when values(trueskill_sigma) > trueskill_sigma then values(trueskill_sigma) else trueskill_sigma end,
 elo = elo + values(elo),
 kills = kills + values(kills),
 deaths = deaths + values(deaths),
-- 
cgit v1.3.1