From 876f4901fa03efe43dc808004af04ec729c46756 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Fri, 6 May 2011 13:16:00 -0400
Subject: [PATCH] Add recent games to the player_info view (still buggy).

---
 xonstat/templates/player_info.mako |  9 +++++++++
 xonstat/views.py                   | 17 +++++++++++++++--
 2 files changed, 24 insertions(+), 2 deletions(-)
 mode change 100644 => 100755 xonstat/templates/player_info.mako

diff --git a/xonstat/templates/player_info.mako b/xonstat/templates/player_info.mako
old mode 100644
new mode 100755
index e177e42..cfa47c3
--- a/xonstat/templates/player_info.mako
+++ b/xonstat/templates/player_info.mako
@@ -21,3 +21,12 @@ ${parent.title()}
    <li>Joined: ${player.create_dt}</li>
 </ul>
 % endif
+
+% if recent_games:
+<h2>Recent Games</h2>
+<ul>
+% for (game_id, server_name, map_name) in recent_games:
+   <li>Game #${game_id} on ${server_name}: ${map_name}</li>
+% endfor
+</ul>
+% endif
diff --git a/xonstat/views.py b/xonstat/views.py
index f9574ab..532f2e6 100755
--- a/xonstat/views.py
+++ b/xonstat/views.py
@@ -33,9 +33,22 @@ def player_info(request):
     player_id = request.matchdict['id']
     try:
         player = DBSession.query(Player).filter_by(player_id=player_id).one()
-    except:
+        recent_games = DBSession.query("game_id", "server_name", "map_name").\
+                from_statement("select g.game_id, s.name as server_name, m.name as map_name "
+                        "from player_game_stats gs, games g, servers s, maps m "
+                        "where gs.player_id=:player_id "
+                        "and gs.game_id = g.game_id "
+                        "and g.server_id = s.server_id "
+                        "and g.map_id = m.map_id "
+                        "order by g.start_dt desc "
+                        "limit 10 offset 1").\
+                        params(player_id=player_id).all()
+
+        log.debug(recent_games)
+    except Exception as e:
+        raise e
         player = None
-    return {'player':player}
+    return {'player':player, 'recent_games':recent_games}
 
 
 ##########################################################################
-- 
2.39.2