From 8ddee77640c63363e5cc9dc5ac27b02518fad656 Mon Sep 17 00:00:00 2001 From: schneefux Date: Thu, 16 Mar 2017 21:18:25 +0100 Subject: show mvp labels --- main.py | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) (limited to 'main.py') diff --git a/main.py b/main.py index 9279887..e4783d1 100644 --- a/main.py +++ b/main.py @@ -80,6 +80,8 @@ async def vainsocial(name: str, region: str = None): """Retrieves a player's stats.""" query = """ SELECT + participant_stats_scorelabels.label AS score_label, + ROUND((100*score)::NUMERIC, 0) AS score, player.name, player.shard_id, match.game_mode, @@ -88,10 +90,14 @@ async def vainsocial(name: str, region: str = None): participant.kills, participant.deaths, participant.assists, participant.farm, player.skill_tier, player.played, player.wins, player.last_match_created_date::text - FROM match, roster, participant, player where + FROM match, roster, participant, player, participant_stats, participant_stats_scorelabels WHERE match.api_id=roster.match_api_id AND roster.api_id=participant.roster_api_id AND participant.player_api_id=player.api_id AND + participant_stats.participant_api_id=participant.api_id AND + participant.winner=participant_stats_scorelabels.winner AND + participant_stats_scorelabels.lower <= participant_stats.score AND + participant_stats.score < participant_stats_scorelabels.upper AND player.name=$1 AND player.last_match_created_date::text<>$2 ORDER BY match.created_at DESC LIMIT 1 @@ -128,7 +134,7 @@ async def vainsocial(name: str, region: str = None): value=("%(wins)i wins / %(played)i games\n" + "https://vainsocial.com/players/%(shard_id)s/%(name)s/?utm_source=discord&utm_medium=vainsocial") % data) emb.add_field(name="Last match", - value=("%(result)s %(mode)s as %(hero)s %(kills)i/%(deaths)i/%(assists)i\n" + + value=("%(result)s %(mode)s as %(hero)s %(kills)i/%(deaths)i/%(assists)i (%(score_label)s %(score)s%%))\n" + "https://vainsocial.com/matches/%(match_api_id)s/?utm_source=discord&utm_medium=vainsocial") % data) emb.set_footer(text="Vainsocial - Vainglory social stats service") -- cgit v1.3.1