X-Git-Url: https://git.xonotic.org/?a=blobdiff_plain;f=scripts%2Fupdate_ranks.sql;h=2f34040e417a912664ae173dff997b7067d71068;hb=e07ec5cdc863a91ee3c61b80e04eacab0e741a6b;hp=2fcd64ceda1bea871d184bcf3aa0a419f41c002a;hpb=e2dd394b03be02a768f3b9ded6203671d760bfac;p=xonotic%2Fxonstatdb.git

diff --git a/scripts/update_ranks.sql b/scripts/update_ranks.sql
index 2fcd64c..2f34040 100644
--- a/scripts/update_ranks.sql
+++ b/scripts/update_ranks.sql
@@ -8,10 +8,13 @@ begin;
     delete from player_ranks;
 
     insert into player_ranks(player_id, nick, game_type_cd, elo, rank)
-    select p.player_id, p.nick, pe.game_type_cd, pe.elo, rank() 
-    over (partition by pe.game_type_cd order by pe.elo desc)
+    select p.player_id, p.nick, pe.game_type_cd, pe.elo, row_number() 
+    over (partition by pe.game_type_cd order by pe.elo desc, pe.create_dt)
     from players p, player_elos pe
     where p.player_id = pe.player_id
-    and pe.games > 32;
+    and p.active_ind = True
+    and pe.active_ind = True
+    --and pe.games >= 32
+    and pe.elo > 100;
 
 end;