X-Git-Url: https://de.git.xonotic.org/?p=xonotic%2Fxonstat.git;a=blobdiff_plain;f=xonstat%2Fviews%2Fgame.py;h=1ce8a9ac74e5aeb164118a44db9da532f6427d66;hp=25ab4082333742a079b51d56bd91c4741bbe2408;hb=129a16ca216817db10b4724def90ff8d1fc75961;hpb=4192fbbe4da9efb321bbae77ee3c1723d5b51442

diff --git a/xonstat/views/game.py b/xonstat/views/game.py
index 25ab408..1ce8a9a 100755
--- a/xonstat/views/game.py
+++ b/xonstat/views/game.py
@@ -3,7 +3,7 @@ import logging
 import re
 import time
 from pyramid.response import Response
-from sqlalchemy import desc
+from sqlalchemy import desc, func, over
 from webhelpers.paginate import Page, PageURL
 from xonstat.models import *
 from xonstat.util import page_url
@@ -106,10 +106,9 @@ def rank_index(request):
 
     game_type_cd = request.matchdict['game_type_cd']
 
-    ranks_q = DBSession.query(PlayerElo, Player).\
-            filter(PlayerElo.game_type_cd==game_type_cd).\
-            filter(PlayerElo.player_id==Player.player_id).\
-            order_by(PlayerElo.elo.desc())
+    ranks_q = DBSession.query(PlayerRank).\
+            filter(PlayerRank.game_type_cd==game_type_cd).\
+            order_by(PlayerRank.rank)
 
     ranks = Page(ranks_q, current_page, url=page_url)