def assign_top_player_banners(c): rows = query_rows_with_ties(c, '''SELECT name, score_full FROM players WHERE score_full > 0''', 'score_full', 3, 1) def do_banner(r, nth): award_banner(c, r[0], '1top_player', 100*(1+nth), temp=True) return True query.do_place_numeric(rows, do_banner)
def assign_top_clan_banners(c): rows = query_rows_with_ties(c, '''SELECT owner, total_score FROM teams WHERE total_score > 0''', 'total_score', 3, 1) def do_banner(r, nth): award_clan_banner(c, r[0], '2top_clan', 10*(1+nth)) return True query.do_place_numeric(rows, do_banner)
def assign_top_clan_banners(c): rows = query_rows_with_ties( c, '''SELECT owner, total_score FROM teams WHERE total_score > 0''', 'total_score', 3, 1) def do_banner(r, nth): award_clan_banner(c, r[0], '2top_clan', 10 * (1 + nth)) return True query.do_place_numeric(rows, do_banner)
def assign_top_player_banners(c): rows = query_rows_with_ties( c, '''SELECT name, score_full FROM players WHERE score_full > 0''', 'score_full', 3, 1) def do_banner(r, nth): award_banner(c, r[0], '1top_player', 100 * (1 + nth), temp=True) return True query.do_place_numeric(rows, do_banner)
def assign_top_clan_banners(c): rows = query_rows_with_ties(c, '''SELECT owner, total_score FROM teams WHERE total_score > 0''', 'total_score', 3, 1) def do_banner(r, nth): award_clan_banner(c, r[0], '2top_clan', 10*(1+nth)) return True query.do_place_numeric(rows, do_banner) def do_saint(r, prestige): for player in query.get_saints(c, r[0]): award_banner(c, player, 'beogh', prestige, temp=True) rows = query_rows_with_ties(c, '''SELECT owner, total_score FROM teams WHERE total_score > 0''', 'total_score', 5, 1) for r in rows: do_saint(r, 3) rows = query_rows_with_ties(c, '''SELECT owner, total_score FROM teams WHERE total_score > 0''', 'total_score', 20, 1) for r in rows: do_saint(r, 2)