Spruce up the player info page a bit: add weapon images for accuracy for starters.

[xonotic/xonstat.git] / xonstat / views / player.py

diff --git a/xonstat/views/player.py b/xonstat/views/player.py
index 9337b834b05cda1d88f3c229d7db7cb9577c7a1e..8db3c556b170345be289c448d1fe96f6056fd1d7 100755 (executable)
--- a/xonstat/views/player.py
+++ b/xonstat/views/player.py
@@ -28,16 +28,16 @@ def player_info(request):
     try:\r
         player = DBSession.query(Player).filter_by(player_id=player_id).one()\r
 \r
-        weapon_stats = DBSession.query("descr", "actual_total", \r
+        weapon_stats = DBSession.query("descr", "weapon_cd", "actual_total", \r
                 "max_total", "hit_total", "fired_total", "frags_total").\\r
                 from_statement(\r
-                    "select cw.descr, sum(actual) actual_total, "\r
+                    "select cw.descr, cw.weapon_cd, sum(actual) actual_total, "\r
                     "sum(max) max_total, sum(hit) hit_total, "\r
                     "sum(fired) fired_total, sum(frags) frags_total "\r
                     "from xonstat.player_weapon_stats ws, xonstat.cd_weapon cw "\r
                     "where ws.weapon_cd = cw.weapon_cd "\r
                     "and player_id = :player_id "\r
-                    "group by descr "\r
+                    "group by descr, cw.weapon_cd "\r
                     "order by descr"\r
                 ).params(player_id=player_id).all()\r
 \r