Save rank history and also do not generate ranks if < 32 games played for the game...
authorAnt Zucaro <azucaro@gmail.com>
Sun, 22 Jan 2012 17:35:41 +0000 (12:35 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Sun, 22 Jan 2012 17:35:41 +0000 (12:35 -0500)
scripts/update_ranks.sql

index 66e8b12..0b50125 100644 (file)
@@ -1,4 +1,10 @@
 begin;
+    -- save the history
+    insert into player_ranks_history
+    select * from player_ranks;
+
+    -- get rid of the existing ranks and refresh them using
+    -- the latest elo information for each game type
     delete from player_ranks;
 
     insert into player_ranks(player_id, nick, game_type_cd, elo, rank)