From 2ce4312649e985cbdd0e1a0e4872dce5c35f7b46 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Mon, 8 Apr 2013 22:26:44 -0400 Subject: [PATCH] Win/loss should use scoreboardpos, not rank. --- xonstat/views/player.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/xonstat/views/player.py b/xonstat/views/player.py index e3b3853..a183114 100644 --- a/xonstat/views/player.py +++ b/xonstat/views/player.py @@ -75,12 +75,12 @@ def get_games_played(player_id): "g.game_type_cd, " "CASE " "WHEN g.winner = pgs.team THEN 1 " - "WHEN pgs.rank = 1 THEN 1 " + "WHEN pgs.scoreboardpos = 1 THEN 1 " "ELSE 0 " "END win, " "CASE " "WHEN g.winner = pgs.team THEN 0 " - "WHEN pgs.rank = 1 THEN 0 " + "WHEN pgs.scoreboardpos = 1 THEN 0 " "ELSE 1 " "END loss " "FROM games g, " -- 2.39.2