def crunch_misc(c, g):
player = g['name']
ktyp = g['ktyp']
if ktyp != 'winning':
query.kill_active_streak(c, player)
if g['goldspent'] == 0 and g['gold'] >= 1000:
banner.award_banner(c, player, 'sif', 1)
if g['xl'] >= 9 and nemelex.is_nemelex_choice(g['char'],g['start']):
ban = 'nemelex:' + g['char']
banner.award_banner(c, player, ban, 1)
if g['xl'] >= 9 and query.check_xl9_streak(c, player, g['start']):
banner.award_banner(c, player, 'cheibriados', 1)
if g['sc'] >= 1000:
og = query.previous_combo_highscore(c, g)
if og and og[0] != player and og[1] >= 1000 and og[1] < g['sc']:
banner.award_banner(c, player, 'trog', 1)
#check_fedhas_banner(c, g)
killer = loaddb.strip_unique_qualifier(g.get('killer') or '')
if uniq.is_uniq(killer):
query_do(c,
'''INSERT INTO deaths_to_uniques
(player, uniq, start_time, end_time)
VALUES (%s, %s, %s, %s)''',
player, killer, g['start'], g['end'])
cuniqdeaths = query.count_deaths_to_distinct_uniques(c, player)
olduniqdeaths = query.lookup_deaths_to_distinct_uniques(c, player)
if cuniqdeaths > olduniqdeaths:
query.update_deaths_to_distinct_uniques(c, player, cuniqdeaths,
g['end'])
def crunch_winner(c, game):
"""A game that wins could assign a variety of irrevocable points for a
variety of different things. This function needs to calculate them all."""
player = game['name']
charabbrev = game_character(game)
game_end = game_end_time(game)
# 20 clan points for first win for a particular combo in the tournament.
if query.first_win_for_combo(c, charabbrev, game_end):
assign_team_points(c, "combo_first_win:" + charabbrev, player, 20)
# Award Okawaru banners for wins.
banner.award_banner(c, player, 'okawaru', 2)
if (game['turn'] < 50000):
banner.award_banner(c, player, 'okawaru', 3)
if not query.game_did_visit_lair(c, player, game_start_time(game)):
# assign_points(c, 'lairless_win', player, 20)
if not query.game_did_visit_branch(c, player, game_start_time(game)):
# 50 bonus points for winning without doing any branches.
assign_points(c, 'branchless_win', player, 50)
# And the banner:
banner.award_banner(c, player, 'kikubaaqudgha', 3)
else:
banner.award_banner(c, player, 'kikubaaqudgha', 2)
ogame = query.previous_combo_highscore(c, game)
if ogame and ogame[0] != player and ogame[2] == 'winning' and ogame[1] < game['sc']:
banner.award_banner(c, player, 'trog', 2)
if game['sc'] >= 10000000:
ogame = query.previous_species_highscore(c, game)
if ogame and ogame[1] >= 10000000 and ogame[1] < game['sc'] and ogame[0] != player:
banner.award_banner(c, player, 'trog', 3)
ogame = query.previous_class_highscore(c, game)
if ogame and ogame[1] >= 10000000 and ogame[1] < game['sc'] and ogame[0] != player:
banner.award_banner(c, player, 'trog', 3)
debug("%s win (%s), runes: %d" % (player, charabbrev, game.get('urune') or 0))
if nemelex.is_nemelex_choice(charabbrev, game_end):
ban = 'nemelex:' + charabbrev
if banner.count_recipients(c, ban, 3) < 5:
if not banner.player_has_banner(c, player, ban, 3):
assign_points(c, ban, player, 75)
banner.award_banner(c, player, ban, 3)
if is_all_runer(game):
all_allruners = number_of_allruners_before(c, game)
assign_points(c, "nth_all_rune_win:%d" % (all_allruners + 1),
game['name'],
get_points(all_allruners, 200, 100, 50))
# If this is my first all-rune win, 50 points!
#if query.count_wins(c, player = game['name'],
# runes = query.MAX_RUNES,
# before = game_end) == 0:
# assign_points(c, "my_1st_all_rune_win", game['name'], 50)
previous_wins = query.count_wins(c, before = game_end)
assign_points(c,
"nth_win:%d" % (previous_wins + 1),
game['name'], get_points(previous_wins, 200, 100, 50))
my_wins = query.get_winning_games(c, player = game['name'],
before = game_end)
n_my_wins = len(my_wins)
repeated = 0
if n_my_wins > 0:
repeated = repeat_race_class([x['charabbrev'] for x in my_wins],
game['char'])
if n_my_wins == 0:
# First win! I bet you don't have a streak
assign_points(c, "my_1st_win", game['name'], 100)
elif n_my_wins == 1 and repeated == 0:
# Second win! If neither repeated race or class, bonus!
assign_points(c, "my_2nd_win_norep", game['name'], 50)
#else:
# Any win gets 10 points at this point.
#assign_points(c, "my_win", game['name'], 10)
streak_wins = query.wins_in_streak_before(c, game['name'], game_end)
debug("%s win (%s), previous games in streak: %s" %
(game['name'], game['char'], streak_wins))
if not streak_wins:
query.kill_active_streak(c, player)
streak_len = -1
else:
# Award banner.
banner.award_banner(c, player, 'cheibriados', 2)
# This length could be 1 even though it involves at least two games, beware!
streak_len = compute_streak_length(streak_wins, game['char'])
if len(streak_wins) >= 2:
if compute_streak_length(streak_wins[-2:], game['char']) == 3:
banner.award_banner(c, player, 'cheibriados', 3)
streak_species = 'streak_species:'+(game['char'][0:2])
streak_class = 'streak_class:'+(game['char'][2:])
# 75 points for streak games, but only if they are with a new race and class.
assign_points(c, streak_species, game['name'], 60, False)
assign_points(c, streak_class, game['name'], 30, False)
query.update_active_streak(c, player, game_end, streak_len)
if streak_len > 1:
# Update the streaks table. We're still in the logfile transaction
# here, so it's safe.
if streak_len > loaddb.longest_streak_count(c, game['name']):
loaddb.update_streak_count(c, game, streak_len)
# Assign points for new personal records.
assign_points(c, 'my_low_turncount_win', game['name'], 5000000/game['turn'], False)
assign_points(c, 'my_low_realtime_win', game['name'], 1250000/game['dur'], False)
assign_points(c, 'my_highscore_win', game['name'], game['sc']/120000, False)
# Assign race/class points, based on the games won before the start
# of the given win.
game_start = game_start_time(game)
wins_before = query.count_wins(c, before=game_start)
species_wins_before = query.count_wins(c, before=game_start, raceabbr=game['char'][0:2])
class_wins_before = query.count_wins(c, before=game_start, classabbr=game['char'][2:])
assign_points(c, 'species_win:' + game['char'][0:2], game['name'], query.race_formula(wins_before, species_wins_before), False)
assign_points(c, 'class_win:' + game['char'][2:], game['name'], query.class_formula(wins_before, class_wins_before), False)
# and gods also
game_god = query.get_game_god(c, game)
banner_god = game_god.lower().replace(' ', '_')
if (not game_god == 'faithless'):
query.record_won_god(c, game['name'], game['end'], game_god)
god_wins_before = query.count_god_wins(c, game_god, game_start)
assign_points(c, 'god_win:' + banner_god, game['name'], query.god_formula(wins_before, god_wins_before), False)
if game['goldspent'] == 0:
if game_god == 'No God':
banner.award_banner(c, game['name'], 'sif', 3)
else:
banner.award_banner(c, game['name'], 'sif', 2)