Save rank history and also do not generate ranks if < 32 games played for the game...

[xonotic/xonstatdb.git] / scripts / update_ranks.sql

diff --git a/scripts/update_ranks.sql b/scripts/update_ranks.sql
index 66e8b12fc1dce5d2688216ace66bb50a58adda41..0b50125730f2997aa38d4eb17261390331576704 100644 (file)
--- 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)