From dca161c547842b9b3ac698865f7bce58b499aba4 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sat, 21 Apr 2012 16:25:40 -0400 Subject: [PATCH] Default total games to 1 and also print who we are merging. --- functions/merge_players.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/functions/merge_players.sql b/functions/merge_players.sql index aabf164..491f545 100644 --- a/functions/merge_players.sql +++ b/functions/merge_players.sql @@ -4,6 +4,8 @@ declare rowcount integer; weighted_elo record; begin + raise notice 'Merging % and %', p_winner_player_id, p_loser_player_id; + -- start with weapon stats update player_weapon_stats set player_id = p_winner_player_id @@ -29,7 +31,7 @@ begin -- take the weighted average of the elos and sum the games to get the new total FOR weighted_elo IN (select game_type_cd, elo_sum/game_count aggregate_elo, game_count from ( - select game_type_cd, sum(games*elo) elo_sum, sum(games) game_count + select game_type_cd, greatest(sum(games*elo),1) elo_sum, sum(games) game_count from player_elos where player_id in (p_winner_player_id, p_loser_player_id) group by game_type_cd -- 2.39.2