def game(sel):
ret = ""
gs = dbselectors.GameSelector()
gs.copyfrom(sel)
game = gs.single(sel.pathid)
if game is None:
ret = "<div class='center'><h2>No such game.</h2></div>"
else:
game["map"] = cgi.escape(game["map"])
ss = dbselectors.ServerSelector()
ss.copyfrom(sel)
server = ss.single(game["server"])
server["desc"] = cgi.escape(server["desc"])
teamsstr = ""
for team in game["teams"]:
team = game["teams"][team]
teamsstr += "<tr>"
teamsstr += "<td>%s</td>" % cgi.escape(team["name"])
teamsstr += "<td>%s</td>" % (dbselectors.scorestr(game, team["score"]))
teamsstr += "</tr>"
playersstr = ""
for player in game["players"]:
playersstr += "<tr>"
playersstr += tdlinkp("player", player["handle"], player["name"])
playersstr += "<td>%s</td>" % (dbselectors.scorestr(game, player["score"]))
playersstr += tdlinkp("player", player["handle"], player["handle"])
playersstr += "<td>%s</td>" % (timeutils.durstr(player["timealive"]))
playersstr += "<td>%d</td>" % player["frags"]
playersstr += "<td>%d</td>" % player["deaths"]
playersstr += "</tr>"
ret += """
<div class="center">
<h2>Game #{game[id]}: {modestr} on {mapstr}</h2>
Duration: {duration}<br>
Played: {agohtml}<br>
Server: <a
href="/display/server/{server[handle]}">{server[desc]}</a><br>
<div class='display-table'>
<h3>Teams</h3>
<table>
<tr>
<th>Name</th>
<th>Score</th>
</tr>
{teams}
</table>
</div>
<div class='display-table'>
<h3>Players</h3>
<table>
<tr>
<th>Name</th>
<th>Score</th>
<th>Handle</th>
<th>Alive</th>
<th>Frags</th>
<th>Deaths</th>
</tr>
{players}
</table>
</div>
</div>
""".format(
modestr=alink("mode", game["mode"], dbselectors.modestr[game["mode"]]),
mapstr=alink("map", game["map"], game["map"]),
agohtml=timeutils.agohtml(game["time"]),
duration=timeutils.durstr(game["timeplayed"]),
game=game,
server=server,
teams=teamsstr,
players=playersstr,
)
return base.page(sel, ret, title="Game %s" % sel.pathid)
def player(sel):
ret = ""
gs = dbselectors.PlayerSelector()
gs.copyfrom(sel)
player = gs.single(sel.pathid)
if player is None:
ret = "<div class='center'><h2>No such player.</h2></div>"
else:
player["name"] = cgi.escape(player["name"])
recentgames = ""
for gid, game in list(reversed(list(player["recentgames"].items())))[:10]:
entry = [p for p in game["players"] if p["handle"] == player["handle"]][0]
recentgames += "<tr>"
recentgames += tdlink("game", gid, "#%d (%s on %s)" % (gid, dbselectors.modestr[game["mode"]], game["map"]))
recentgames += "<td>%s</td>" % timeutils.agohtml(game["time"])
recentgames += "<td>%s</td>" % cgi.escape(entry["name"])
recentgames += "<td>%s</td>" % dbselectors.scorestr(game, entry["score"])
recentgames += "<td>%d</td>" % entry["frags"]
recentgames += "<td>%d</td>" % entry["deaths"]
recentgames += "</tr>"
recentweapons = ""
try:
fratio = "%.2f" % (player["recent"]["frags"] / max(1, player["recent"]["deaths"]))
except TypeError:
fratio = "-"
try:
totalwielded = sum([w["timewielded"] for w in list(player["recent"]["weapons"].values())])
for weap in sorted(dbselectors.weaponlist):
weapon = player["recent"]["weapons"][weap]
recentweapons += "<tr>"
recentweapons += "<td>%s</td>" % cgi.escape(weap)
recentweapons += "<td>%d%%</td>" % (weapon["timeloadout"] / max(1, totalwielded) * 100)
recentweapons += "<td>%d%%</td>" % (weapon["timewielded"] / max(1, totalwielded) * 100)
recentweapons += "<td>%d%%</td>" % (weapon["hits1"] / max(1, weapon["shots1"]) * 100)
recentweapons += "<td>%d%%</td>" % (weapon["hits2"] / max(1, weapon["shots2"]) * 100)
recentweapons += "<td>%d</td>" % weapon["frags1"]
recentweapons += "<td>%d</td>" % weapon["frags2"]
recentweapons += "</tr>"
except TypeError:
pass
gs = dbselectors.GameSelector()
gs.copyfrom(sel)
firstago = timeutils.agohtml(gs.single(min(player["games"]))["time"])
ret += """
<div class="center">
<h2>{player[name]}</h2>
<h3>{player[handle]}</h3>
First recorded game: {firstago}<br>
Frag Ratio: {fratio}<br>
<div class='display-table'>
<h3>Recent Games</h3>
<table>
<tr>
<th>Game</th>
<th>Time</th>
<th>Played As</th>
<th>Score</th>
<th>Frags</th>
<th>Deaths</th>
</tr>
{recentgames}
</table>
</div>
<div class='display-table'>
<h3>Weapon Statistics</h3>
<table>
<tr>
<th>Name</th>
<th>Loadout</th>
<th>Wielded</th>
<th>Hit Ratio 1</th>
<th>Hit Ratio 2</th>
<th>Frags 1</th>
<th>Frags 2</th>
</tr>
{recentweapons}
</table>
</div>
</div>
""".format(
recentgames=recentgames, player=player, firstago=firstago, fratio=fratio, recentweapons=recentweapons
)
return base.page(sel, ret, title="Game %s" % sel.pathid)