def show_match_page(match_id):
cur = g.db.execute(
"""SELECT mp.participant_id, p.name, mp.kills, mp.deaths,
mp.assists, c.img_url, t.team_name, s1.img_url, s2.img_url, mp.item_set FROM
match_participant AS mp, summoners AS s1, summoners AS s2,
playerinfo AS p, champions AS c, teams as t
WHERE mp.match_id = ? AND
s1.id = mp.spell_id_one AND
s2.id = mp.spell_id_two AND
p.player_id = mp.player_id AND
c.id = mp.champion AND t.team_id = mp.team_id
ORDER BY mp.participant_id""", [int(match_id)])
m = [
dict(participant_id=row[0],
name=row[1],
kills=row[2],
deaths=row[3],
assists=row[4],
img_url=row[5],
team_name=row[6],
spell1=row[7],
spell2=row[8],
item_set=json.loads(row[9]),
safe_set=row[9]) for row in cur.fetchall()
]
version = riot_api.get_version()
return render_template('match.html',
match=m,
version=version,
dropdown=get_dropdown_menu())
def show_league_matches(league_id):
query = " and match_details.region_id = %s " % str(league_id)
m = get_list_of_matches(query)
version = riot_api.get_version()
return render_template('matches.html',
matches=m,
version=version,
dropdown=get_dropdown_menu())
def show_match_page(match_id):
cur = g.db.execute("""SELECT mp.participant_id, p.name, mp.kills, mp.deaths,
mp.assists, c.img_url, t.team_name, s1.img_url, s2.img_url, mp.item_set FROM
match_participant AS mp, summoners AS s1, summoners AS s2,
playerinfo AS p, champions AS c, teams as t
WHERE mp.match_id = ? AND
s1.id = mp.spell_id_one AND
s2.id = mp.spell_id_two AND
p.player_id = mp.player_id AND
c.id = mp.champion AND t.team_id = mp.team_id
ORDER BY mp.participant_id""", [int(match_id)])
m = [dict(participant_id = row[0], name = row[1], kills = row[2],
deaths = row[3], assists = row[4], img_url = row[5],
team_name = row[6], spell1 = row[7], spell2 = row[8],
item_set = json.loads(row[9]), safe_set = row[9]) for row in cur.fetchall()]
version = riot_api.get_version()
return render_template('match.html', match = m, version = version, dropdown = get_dropdown_menu())
def show_league_matches(league_id):
query = " and match_details.region_id = %s " % str(league_id)
m = get_list_of_matches(query)
version = riot_api.get_version()
return render_template('matches.html', matches = m, version = version, dropdown = get_dropdown_menu())
