def single(request, db, specific): ws = dbselectors.get('weapon', db, {'recentsums': [pastgames]}) weapons = ws.multi() weapon = ws.single(specific) if utils.sok(weapon): totalwielded = sum(w['timewielded'] for w in list(weapons.values())) ret = web.displays.weapontable( weapon, totalwielded, pastgames).html(True) else: ret = "<div class='center'><h2>No such mutator.</h2></div>" return web.page(ret, title=specific.capitalize())
def single(request, db, specific): ret = "" serverselector = dbselectors.get('server', db) serverselector.flags_none() serverselector.weakflags(["games"], True) server = serverselector.single(specific) if utils.sok(server): # Game List pager = web.Pager(request, onpagecount, reversed(server["games"])) recentgames = web.Table( ["ID", "Mode", "Mutators", "Map", "Duration", "Played"]) gs = dbselectors.get('game', db) gs.flags_none() firstgame = gs.single(server["games"][0]) for gid in pager.list(): game = gs.single(gid) with recentgames.tr as tr: tr(web.link("/game/", gid, "Game #%d" % gid)) tr(web.link("/mode/", game["mode"], redeclipse(game).modeimg(game["mode"]))) tr(redeclipse(game).mutslist(game, True) or '-') tr(web.link("/map/", game["map"], game["map"], True)) tr(timeutils.durstr(round(game["timeplayed"]))) tr(timeutils.agohtml(game["time"])) ret += """ <div class="center"> <h2>{server[desc]}</h2> <h3>{server[handle]} <i>[{server[authflags]}]</i>: Version {server[version]}</h3> <a href="redeclipse://{server[host]}:{server[port]}"> {server[host]}:{server[port]}</a><br> {servergames} games recorded.<br> First Recorded: {fgtime} with <a href="/game/{fgid}">Game #{fgid}</a>.<br> <div class='display-table'> <h3>Recent Games</h3> {recentgames} {pages} </div> </div> """.format(server=server, recentgames=recentgames.html(), servergames=len(server["games"]), fgtime=timeutils.agohtml(firstgame["time"]), fgid=firstgame["id"], pages=pager.html()) else: ret = "<div class='center'><h2>No such server.</h2></div>" return web.page(ret, title="Server %s" % specific)
def single(request, db, specific): ps = dbselectors.get('player', db) ps.flags_none() ps.weakflags(['games'], True) gs = dbselectors.get('game', db) gs.flags_none() gs.weakflags(['players'], True) player = ps.single(specific) if utils.sok(player): table = web.Table(["Game", "Mode", "Mutators", "Map", "Time", "Played As", "Score", "Frags", "Deaths"]) pager = web.Pager(request, onpagecount, reversed(player["games"])) for gid in pager.list(): game = gs.single(gid) entry = [p for p in list(game["players"].values()) if p["handle"] == player["handle"]][0] with table.tr as tr: tr(web.link('/game/', gid, "Game #%d" % gid)) tr(web.link('/mode/', game["mode"], redeclipse(game).modeimg(game["mode"]))) tr(redeclipse(game).mutslist(game, True) or '-') tr(web.link("/map/", game["map"], game["map"], True)) tr(timeutils.agohtml(game["time"])) tr(cgi.escape(entry["name"])) tr(redeclipse(game).scorestr(game, entry["score"])) tr(entry["frags"]) tr(entry["deaths"]) ret = """ <div class="center"> <h2><a href="/player/{player[handle]}"> {player[handle]}</a>: Games</h2> <div class='display-table'> {table} {pages} </div> </div> """.format(player=player, table=table.html(), pages=pager.html()) else: ret = "<div class='center'><h2>No such player.</h2></div>" return web.page(ret, title="%s: Games" % specific)
def single(request, db, specific): ret = "" mutselector = dbselectors.get('mut', db) mutselector.flags_none() mut = mutselector.single(specific) if utils.sok(mut): # Game List pager = web.Pager(request, onpagecount, reversed(mut["games"])) recentgames = web.Table( ["ID", "Mode", "Mutators", "Map", "Duration", "Played"]) gs = dbselectors.get('game', db) gs.flags_none() for gid in pager.list(): game = gs.single(gid) with recentgames.tr as tr: tr(web.link("/game/", gid, "Game #%d" % gid)) tr(web.link("/mode/", game["mode"], redeclipse(game).modeimg(game["mode"]))) tr(redeclipse(game).mutslist(game, True) or '-') tr(web.link("/map/", game["map"], game["map"], True)) tr(timeutils.durstr(round(game["timeplayed"]))) tr(timeutils.agohtml(game["time"])) ret += """ <div class="center"> <h2>{mut[id]}</h2> <div class='display-table'> <h3>Recent Games</h3> {recentgames} {pages} </div> </div> """.format(mut=mut, recentgames=recentgames.html(), pages=pager.html()) else: ret = "<div class='center'><h2>No such mutator.</h2></div>" return web.page(ret, title="Mutator %s" % specific)
def single(request, db, specific): playerselector = dbselectors.get('player', db, {'recentsums': [-1]}) playerselector.flags_none() playerselector.weakflags( ['games', 'damage', 'recentgames', 'recentsums', 'weapons'], True) recentplayerselector = dbselectors.get('player', db, {'recentsums': [recentlimit]}) recentplayerselector.flags_none() recentplayerselector.weakflags( ['games', 'damage', 'recentsums', 'weapons'], True) gameselector = dbselectors.get('game', db) gameselector.flags_none() player = playerselector.single(specific) recentplayer = recentplayerselector.single(specific) if utils.sok(player) and utils.sok(recentplayer): #Top map topmap = "-" maps = {} for row in db.execute('''SELECT map FROM games WHERE id IN (SELECT game FROM game_players WHERE handle = ? ORDER by ROWID DESC LIMIT %d)''' % recentlimit, (player["handle"],)): if row[0] not in maps: maps[row[0]] = 0 maps[row[0]] += 1 if maps: t = sorted(maps, key=lambda x: -maps[x])[0] topmap = web.link('/map/', t, t) # Play time timeplayed = timeutils.durstr(player["recent"]["timeactive"], skip="s", skiplow=False, full=True) #DPM try: dpm = "%d" % (round(player["recent"]["damage"] / (player["recent"]["timealive"] / 60))) except TypeError: dpm = "-" #Frag ratio try: fratio = "%.2f [%d / %d]" % ((player["recent"]["frags"] / max(1, player["recent"]["deaths"])), player["recent"]["frags"], player["recent"]["deaths"]) except TypeError: fratio = "-" #Recent Games gamestable = web.Table(["Game", "Mode", "Mutators", "Map", "Time", "Played As", "Score", "Frags", "Deaths"]) for gid in sorted( list(player["recentgames"].keys()), reverse=True)[:5]: game = player["recentgames"][gid] entry = game["player"] with gamestable.tr as tr: tr(web.link('/game/', gid, "Game #%d" % gid)) tr(web.link('/mode/', game["mode"], redeclipse(game).modeimg(game["mode"]))) tr(redeclipse(game).mutslist(game, True) or '-') tr(web.link("/map/", game["map"], game["map"], True)) tr(timeutils.agohtml(game["time"])) tr(cgi.escape(entry["name"])) tr(redeclipse(game).scorestr(game, entry["score"])) tr(entry["frags"]) tr(entry["deaths"]) #Weapons totalwielded = sum([w['timewielded'] for w in list(recentplayer['recent']['weapons'].values()) if w['timewielded'] is not None]) weaponstable = web.displays.weaponstable( recentplayer['recent']['weapons'], totalwielded, redeclipse().weaponlist) ret = """ <div class="center"> <h2>{player[name]}</h2> <h3>{player[handle]}</h3> <div class="colcontainer"> <div class="leftcol"> First appeared: {firstago}<br> Last appeared: {lastago}<br> </div> <div class="rightcol"> Most played map: {topmap}<br> Playing time: {timeplayed}<br> </div> </div> <div style="clear: both;"></div> <h3>Last {recentnum} Games</h3> Frag Ratio: {fratio}<br> DPM: {dpm}<br> <div class='display-table'> {games} <h5 style="text-align: left;"> <a href="/playergames/{player[handle]}"> All Games...</a></h5> </div> <div class='display-table small-table'> <h3>Weapon Statistics</h3> {weapons} </div> </div> """.format( player=player, firstago=web.link("/game/", player["games"][0], timeutils.agohtml( gameselector.single(player["games"][0])["time"])), lastago=web.link("/game/", player["games"][-1], timeutils.agohtml( gameselector.single(player["games"][-1])["time"])), topmap=topmap, timeplayed=timeplayed, dpm=dpm, fratio=fratio, games=gamestable.html(), weapons=weaponstable.html(), recentnum=recentlimit, ) else: ret = "<div class='center'><h2>No such player.</h2></div>" return web.page(ret, title="Player %s" % specific)
def single(request, db, specific): ret = "" mapselector = dbselectors.get('map', db) mapselector.flags_none() mapselector.weakflags(["race"], True) gmap = mapselector.single(specific) if utils.sok(gmap): # Game List pager = web.Pager(request, onpagecount, reversed(gmap["games"])) recentgames = web.Table( ["ID", "Mode", "Mutators", "Duration", "Played"]) gs = dbselectors.get('game', db) gs.flags_none() for gid in pager.list(): game = gs.single(gid) with recentgames.tr as tr: tr(web.link("/game/", gid, "Game #%d" % gid)) tr(web.link("/mode/", game["mode"], redeclipse(game).modeimg(game["mode"]))) tr(redeclipse(game).mutslist(game, True) or '-') tr(timeutils.durstr(round(game["timeplayed"]))) tr(timeutils.agohtml(game["time"])) # Race Times racetable = web.Table(["Time", "Player", "Handle", "Game", "When"]) for race in gmap["topraces"][:3]: with racetable.tr as tr: tr(timeutils.durstr(race["time"] / 1000, dec=True, full=True)) tr(web.linkif('/player/', race["gameplayer"]["handle"], race["gameplayer"]["name"])) tr(web.linkif('/player/', race["gameplayer"]["handle"], race["gameplayer"]["handle"] or '-')) tr(web.link('/game/', race["game"]["id"], "Game #%d" % race["game"]["id"])) tr(timeutils.agohtml(race["game"]["time"])) racetimes = """ <div class='display-table small-table'> <h3>Top Race Times</h3> %s </div> """ % racetable.html() eracetable = web.Table(["Time", "Player", "Handle", "Game", "When"]) for race in gmap["toperaces"][:3]: with eracetable.tr as tr: tr(timeutils.durstr(race["time"] / 1000, dec=True, full=True)) tr(web.linkif('/player/', race["gameplayer"]["handle"], race["gameplayer"]["name"])) tr(web.linkif('/player/', race["gameplayer"]["handle"], race["gameplayer"]["handle"] or '-')) tr(web.link('/game/', race["game"]["id"], "Game #%d" % race["game"]["id"])) tr(timeutils.agohtml(race["game"]["time"])) eracetimes = """ <div class='display-table small-table'> <h3>Top Endurance Race Times</h3> %s </div> """ % eracetable.html() ret += """ <div class="center"> <h2>{map[name]}</h2> {racetimes} {eracetimes} <div class='display-table'> <h3>Recent Games</h3> {recentgames} {pages} </div> </div> """.format(map=gmap, recentgames=recentgames.html(), racetimes=racetimes if gmap["toprace"]["time"] else '', eracetimes=eracetimes if gmap["toperace"]["time"] else '', pages=pager.html()) else: ret = "<div class='center'><h2>No such map.</h2></div>" return web.page(ret, title="Map %s" % specific)
def single(request, db, specific): gs = dbselectors.get('game', db) gs.flags_none() gs.weakflags(["server", "teams", "affinities", "rounds", "players", "playerdamage", "weapons"], True) ss = dbselectors.get('server', db) ss.flags_none() game = gs.single(specific) ret = "" if utils.sok(game): server = ss.single(game["server"]) # Display the server's desc & version from this game. serverrow = db.execute( """SELECT version,desc,host,port FROM game_servers WHERE game = %d""" % game["id"] ).fetchone() server["version"] = serverrow[0] server["desc"] = cgi.escape(serverrow[1]) or cgi.escape( "%s:%d" % (serverrow[2], serverrow[3])) playerstable = web.Table( ["Name", "Score", "Handle", "Alive", "Frags", "Deaths"], "Players", "display-table") for player in sorted( list(game["players"].values()), key=lambda x: ( redeclipse(game).scorenum(game, x["score"]))): with playerstable.tr as tr: tr(web.linkif('/player/', player["handle"], player["name"])) tr(redeclipse(game).scorestr(game, player["score"])) tr(web.linkif('/player/', player["handle"], player["handle"])) tr(timeutils.durstr(player["timealive"])) tr(player["frags"]) tr(player["deaths"]) teamstable = None teamlist = {} if len(game["teams"]) > 1: teamstable = web.Table( ["Name", "Score"], "Teams", "display-table small-table") # Sort depending on score, counting race times for team in sorted(sorted(game["teams"], key=lambda x: game["teams"][x]["score"] * ( 1 if game["mode"] == redeclipse(game).modes["race"] and (game["mutators"] & redeclipse(game).mutators["timed"]) else -1 )), key=lambda x: game["teams"][x]["score"] == 0): team = game["teams"][team] teamlist[team["team"]] = team with teamstable.tr as tr: tr("%s %s" % ( redeclipse(game).teamimg(team["team"]), cgi.escape(team["name"]) )) tr(redeclipse(game).scorestr(game, team["score"])) ffarounds = web.Table(["Round", "Winner", "Versus"], "Rounds", "display-table small-table") if "ffarounds" in game: donerounds = [] for ffaround in sorted(game["ffarounds"], key=lambda x: x["round"]): if ffaround["round"] in donerounds: continue haswinner = False for ffaround_s in game["ffarounds"]: if (ffaround_s["round"] == ffaround["round"] and ffaround_s["winner"]): haswinner = True break versuslist = [] for ffaround_s in game["ffarounds"]: if (ffaround_s["round"] == ffaround["round"] and not ffaround_s["winner"]): versuslist.append(web.linkif( "/player/", ffaround_s["playerhandle"], game["players"][ffaround_s["player"]]["name"])) with ffarounds.tr as tr: if haswinner and ffaround["winner"]: tr(ffaround["round"]) tr(web.linkif( "/player/", ffaround["playerhandle"], game["players"][ffaround["player"]]["name"])) if versuslist: tr(", ".join(versuslist)) else: tr("<i>AI</i>") elif not haswinner: donerounds.append(ffaround["round"]) if len(versuslist) == 1: tr(ffaround["round"]) tr('<i>AI</i>') tr(", ".join(versuslist)) else: tr(ffaround["round"]) tr('<i>Epic fail!</i>') tr(", ".join(versuslist)) affinitiestable = None if "captures" in game: affinitiestable = web.Table( ["Player", "Capturing Team", "Captured Flag"], "Flag Captures", "display-table" ) for capture in game["captures"]: with affinitiestable.tr as tr: tr(web.linkif('/player/', capture["playerhandle"], game["players"][capture["player"]]["name"])) tr(cgi.escape(teamlist[capture["capturing"]]["name"])) tr(cgi.escape(teamlist[capture["captured"]]["name"])) elif "bombings" in game: affinitiestable = web.Table( ["Player", "Bombing Team", "Bombed Base"], "Base Bombings", "display-table" ) for bombing in game["bombings"]: with affinitiestable.tr as tr: tr(web.linkif('/player/', bombing["playerhandle"], game["players"][bombing["player"]]["name"])) tr(cgi.escape(teamlist[bombing["bombing"]]["name"])) tr(cgi.escape(teamlist[bombing["bombed"]]["name"])) totalwielded = sum([w['timewielded'] for w in list(game['weapons'].values()) if w['timewielded'] is not None]) weaponstable = web.displays.weaponstable(game['weapons'], totalwielded, redeclipse(game).weaponlist, version=game) if game["mode"] == redeclipse(game).modes['race']: weaponstable = None ret = """ <div class="center"> <h2>Game #{game[id]}: {modestr} on {mapstr}</h2> {mutsstr} Duration: {duration}<br> Played: {agohtml}<br> Server: <a href="/server/{server[handle]}">{server[desc]} [{server[version]}] [{server[handle]}]</a> {teams} {players} {affinities} {ffarounds} {weapons} </div> """.format( game=game, modestr=web.link('/mode/', game["mode"], redeclipse(game).modeimg(game["mode"], 32)), mutsstr=("Mutators: %s<br>" % redeclipse(game).mutslist( game, True, True)) if game['mutators'] else '', mapstr=web.link('/map/', game["map"], game["map"]), server=server, agohtml=timeutils.agohtml(game["time"]), duration=timeutils.durstr(game["timeplayed"]), players=playerstable.html(True), teams=teamstable.html(True) if teamstable is not None else "", affinities=affinitiestable.html(True) if affinitiestable is not None else "", ffarounds=ffarounds.html(True) if "ffarounds" in game else "", weapons=weaponstable.html(True) if weaponstable is not None else "", ) else: ret = "<div class='center'><h2>No such game.</h2></div>" return web.page(ret, title="Game %s" % specific)