def check_banners(c):
award_player_banners(c, 'zin',
query_first_col(c, '''SELECT player
FROM all_hellpan_kills'''),
3)
award_player_banners(c, 'zin',
query_first_col(c, '''SELECT player
FROM have_hellpan_kills'''),
2)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''
SELECT player, COUNT(DISTINCT MID(charabbrev,1,2)) AS race_count,
COUNT(DISTINCT MID(charabbrev,3,2)) AS class_count
FROM
(SELECT player, charabbrev FROM games WHERE xl>=9
UNION
SELECT player, charabbrev FROM milestones WHERE xl>=9) AS T
GROUP BY player
HAVING race_count >= 5 AND class_count >= 5'''),
1)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_rune'''),
2)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_win'''),
3)
award_player_banners(c, 'fedhas',
query_first_col(c,
'''SELECT player FROM orbrun_tomb'''),
3)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 65'''),
3)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 45'''),
2)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 25'''),
1)
rows = query_rows(c, '''SELECT * FROM nearby_uniques''')
for r in rows:
a = uniq.how_deep(r[1])
b = uniq.how_deep(r[2])
d = 3 - (r[4] - r[3])
if b < a:
a = b
if d < a:
a = d
banner.award_banner(c, r[0], 'vehumet', a)
def check_banners(c):
award_player_banners(c, 'zin',
query_first_col(c, '''SELECT player
FROM all_hellpan_kills'''),
3)
award_player_banners(c, 'zin',
query_first_col(c, '''SELECT player
FROM have_hellpan_kills'''),
2)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_nine'''),
1)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_rune'''),
2)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_win'''),
3)
award_player_banners(c, 'fedhas',
query_first_col(c,
'''SELECT player FROM orbrun_tomb'''),
3)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 65'''),
3)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 45'''),
2)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 25'''),
1)
rows = query_rows(c, '''SELECT * FROM nearby_uniques''')
for r in rows:
a = uniq.how_deep(r[1])
b = uniq.how_deep(r[2])
d = 3 - (r[4] - r[3])
if b < a:
a = b
if d < a:
a = d
banner.award_banner(c, r[0], 'vehumet', a)
def check_banners(c):
award_player_banners(c, 'zin',
query_first_col(c, '''SELECT player
FROM all_hellpan_kills'''),
3)
award_player_banners(c, 'zin',
query_first_col(c, '''SELECT player
FROM have_hellpan_kills'''),
2)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''
SELECT player, COUNT(DISTINCT MID(charabbrev,1,2)) AS race_count,
COUNT(DISTINCT MID(charabbrev,3,2)) AS class_count
FROM
(SELECT player, charabbrev FROM games WHERE xl>=9
UNION
SELECT player, charabbrev FROM milestones WHERE xl>=9) AS T
GROUP BY player
HAVING race_count >= 5 AND class_count >= 5'''),
1)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_rune'''),
2)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_win'''),
3)
award_player_banners(c, 'fedhas',
query_first_col(c,
'''SELECT player FROM orbrun_tomb'''),
3)
for row in query_rows(c, '''SELECT player, orbrun_tomb_count FROM orbrun_tomb'''):
assign_points(c, "orbrun_tomb", row[0], 25, False)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 72'''),
3)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 52'''),
2)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 32'''),
1)
def check_banners(c):
award_player_banners(c, 'zin',
query_first_col(c, '''SELECT player
FROM all_hellpan_kills'''),
3)
award_player_banners(c, 'zin',
query_first_col(c, '''SELECT player
FROM have_hellpan_kills'''),
2)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''
SELECT player, COUNT(DISTINCT MID(charabbrev,1,2)) AS race_count,
COUNT(DISTINCT MID(charabbrev,3,2)) AS class_count
FROM
(SELECT player, charabbrev FROM games WHERE xl>=9
UNION
SELECT player, charabbrev FROM milestones WHERE xl>=9) AS T
GROUP BY player
HAVING race_count >= 5 AND class_count >= 5'''),
1)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_rune'''),
2)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_win'''),
3)
award_player_banners(c, 'fedhas',
query_first_col(c,
'''SELECT player FROM orbrun_tomb'''),
3)
for row in query_rows(c, '''SELECT player, orbrun_tomb_count FROM orbrun_tomb'''):
assign_points(c, "orbrun_tomb", row[0], 25, False)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 72'''),
3)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 52'''),
2)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM kunique_times
WHERE nuniques >= 32'''),
1)
def check_banners(c):
award_player_banners(c, 'zin',
query_first_col(c, '''SELECT player
FROM all_hellpan_kills'''),
3)
award_player_banners(c, 'zin',
query_first_col(c, '''SELECT player
FROM have_hellpan_kills'''),
2)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''
SELECT player, COUNT(DISTINCT MID(charabbrev,1,2)) AS race_count,
COUNT(DISTINCT MID(charabbrev,3,2)) AS class_count
FROM
(SELECT player, charabbrev FROM games WHERE xl>=9
UNION
SELECT player, charabbrev FROM milestones WHERE xl>=9) AS T
GROUP BY player
HAVING race_count >= 5 AND class_count >= 5'''),
1)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_rune'''),
2)
award_player_banners(c, 'jiyva',
query_first_col(c,
'''SELECT player FROM fivefives_win'''),
3)
award_player_banners(c, 'fedhas',
query_first_col(c,
'''SELECT player FROM orbrun_tomb'''),
3)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM unique_kill_count
WHERE score >= 78'''),
3)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM unique_kill_count
WHERE score >= 54'''),
2)
award_player_banners(c, 'yredelemnul',
query_first_col(c,
'''SELECT player FROM unique_kill_count
WHERE score >= 27'''),
1)
def check_banners(c):
award_player_banners(
c,
"zin",
query_first_col(
c,
"""SELECT player
FROM all_hellpan_kills""",
),
3,
)
award_player_banners(
c,
"zin",
query_first_col(
c,
"""SELECT player
FROM have_hellpan_kills""",
),
2,
)
award_player_banners(
c,
"jiyva",
query_first_col(
c,
"""
SELECT player, COUNT(DISTINCT MID(charabbrev,1,2)) AS race_count,
COUNT(DISTINCT MID(charabbrev,3,2)) AS class_count
FROM
(SELECT player, charabbrev FROM games WHERE xl>=9
UNION
SELECT player, charabbrev FROM milestones WHERE xl>=9) AS T
GROUP BY player
HAVING race_count >= 5 AND class_count >= 5""",
),
1,
)
award_player_banners(c, "jiyva", query_first_col(c, """SELECT player FROM fivefives_rune"""), 2)
award_player_banners(c, "jiyva", query_first_col(c, """SELECT player FROM fivefives_win"""), 3)
award_player_banners(c, "fedhas", query_first_col(c, """SELECT player FROM orbrun_tomb"""), 3)
for row in query_rows(c, """SELECT player, orbrun_tomb_count FROM orbrun_tomb"""):
assign_points(c, "orbrun_tomb", row[0], 25, False)
award_player_banners(
c,
"yredelemnul",
query_first_col(
c,
"""SELECT player FROM kunique_times
WHERE nuniques >= 72""",
),
3,
)
award_player_banners(
c,
"yredelemnul",
query_first_col(
c,
"""SELECT player FROM kunique_times
WHERE nuniques >= 52""",
),
2,
)
award_player_banners(
c,
"yredelemnul",
query_first_col(
c,
"""SELECT player FROM kunique_times
WHERE nuniques >= 32""",
),
1,
)
