From e2d305b32225ec349c763c47b2b36a7662369abb Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Sun, 22 Jan 2012 12:35:41 -0500
Subject: [PATCH] Save rank history and also do not generate ranks if < 32
 games played for the game type.

---
 scripts/update_ranks.sql | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/scripts/update_ranks.sql b/scripts/update_ranks.sql
index 66e8b12..0b50125 100644
--- a/scripts/update_ranks.sql
+++ b/scripts/update_ranks.sql
@@ -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)
-- 
2.39.2