def act_on_logfile_line(c, this_game):
"""Actually assign things and write to the db based on a logfile line
coming through. All lines get written to the db; some will assign
irrevocable points and those should be assigned immediately. Revocable
points (high scores, lowest dungeon level, fastest wins) should be
calculated elsewhere."""
if game_is_win(this_game):
crunch_winner(c, this_game) # lots of math to do for winners
crunch_misc(c, this_game)
if loaddb.is_ghost_kill(this_game):
ghost = loaddb.extract_ghost_name(this_game['killer'])
XL = this_game['xl']
if XL > 5:
assign_team_points(c, "gkill", ghost, (XL - 5))
def act_on_logfile_line(c, this_game):
"""Actually assign things and write to the db based on a logfile line
coming through. All lines get written to the db; some will assign
irrevocable points and those should be assigned immediately. Revocable
points (high scores, lowest dungeon level, fastest wins) should be
calculated elsewhere."""
if game_is_win(this_game):
crunch_winner(c, this_game) # lots of math to do for winners
crunch_misc(c, this_game)
if loaddb.is_ghost_kill(this_game):
ghost = loaddb.extract_ghost_name(this_game['killer'])
ghost = query.canonicalize_player_name(c, ghost)
XL = this_game['xl']
if XL > 5 and ghost:
assign_team_points(c, "gkill", ghost, (XL - 5))
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)
def do_milestone_ghost(c, mile):
"""When you kill a player ghost, you get two clan points! Otherwise this
isn't terribly remarkable."""
if not mile['milestone'].startswith('banished'):
assign_team_points(c, "ghost", mile['name'], 2)
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_start = game_start_time(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 game['dur'] <= 10800:
banner.award_banner(c, player, 'makhleb', 3)
if game['sk'] == 'Invocations':
banner.award_banner(c, player, 'qazlal', 2)
if query.player_count_invo_titles(c, player) >= 3:
banner.award_banner(c, player, 'qazlal', 3)
#gods_abandoned = query.count_gods_abandoned(c, player, game_start_time(game))
#if gods_abandoned >= 9:
# assign_points(c, 'heretical_win', player, 25)
# banner.award_banner(c, player, 'lugonu', 3)
#elif gods_abandoned >= 3:
# banner.award_banner(c, player, 'lugonu', 2)
if query.check_ru_abandonment_game(c, player, game_start_time(game)):
banner.award_banner(c, player, 'lugonu', 3)
if not query.game_did_visit_lair(c, player, game_start_time(game)):
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, False)
# And the banner:
banner.award_banner(c, player, 'kikubaaqudgha', 3)
# else:
# Just 20 bonus points for winning without doing Lair.
# assign_points(c, 'lairless_win', player, 20)
if game['sklev'] < 20:
if not query.did_worship_god(c, 'Ashenzari', player, game['start'], game['end']):
if game['sklev'] < 13:
banner.award_banner(c, player, 'sif', 3)
else:
banner.award_banner(c, player, 'sif', 2)
if game['xl'] < 19:
if not query.did_sacrifice(c, 'experience', player, game['start'], game['end']):
assign_points(c, 'ruthless_efficiency', player, 25, False)
banner.award_banner(c, player, 'vehumet', 3)
#cutoff = query.time_from_str(game['end']) - datetime.timedelta(hours=27)
#if query.time_from_str(game['start']) > cutoff:
# if query.count_wins(c, player = game['name'], before = game_end, after = cutoff) > 0:
# banner.award_banner(c, player, 'oldbanner', 3)
# else:
# banner.award_banner(c, player, 'oldbanner', 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, 'dithmenos', 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, 'dithmenos', 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, 'dithmenos', 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) < 8:
if not banner.player_has_banner(c, player, ban, 3):
query.assign_stepdown_points(c, ban, player, 75)
banner.award_banner(c, player, ban, 3)
if query.is_unbeliever(c, game):
banner.award_banner(c, player, 'trog', 3)
if query.did_use_ecumenical_altar(c, game['name'], game['start'], game['end']) \
and not query.did_renounce_god(c, game['name'], game['start'], game['end']):
banner.award_banner(c, game['name'], 'hepliaklqana', 3)
if is_all_runer(game):
all_allruners = number_of_allruners_before(c, game)
assign_points(c, "nth_allrune_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)
if n_my_wins == 0:
# First win!
assign_points(c, "my_1st_win", game['name'], 100)
else:
# If the new win is a different race/class from a previous win, bonus!
for x in my_wins:
if repeat_race_class(x['charabbrev'], game['char']) == 0:
assign_points(c, "my_2nd_win_norep", game['name'], 50, False)
did_streak = query.win_is_streak(c, game['name'], game_start)
if did_streak:
# Award banner.
banner.award_banner(c, player, 'cheibriados', 2)
# 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:])
query.assign_stepdown_points(c, 'species_win:' + game['char'][0:2], game['name'], query.race_formula(wins_before, species_wins_before), False)
query.assign_stepdown_points(c, 'background_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)
query.assign_stepdown_points(c, 'god_win:' + banner_god, game['name'], query.god_formula(wins_before, god_wins_before), False)
def do_milestone_ghost(c, mile):
"""When you kill a player ghost, you get two clan points! Otherwise this
isn't terribly remarkable."""
if not mile['milestone'].startswith('banished'):
if query.count_team_points(c, mile['name'], 'ghost') < 200:
assign_team_points(c, "ghost", mile['name'], 2)
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_start = game_start_time(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 game['dur'] <= 10800:
banner.award_banner(c, player, 'makhleb', 3)
if game['sk'] == 'Invocations':
banner.award_banner(c, player, 'qazlal', 2)
if query.player_count_invo_titles(c, player) >= 3:
banner.award_banner(c, player, 'qazlal', 3)
#gods_abandoned = query.count_gods_abandoned(c, player, game_start_time(game))
#if gods_abandoned >= 9:
# assign_points(c, 'heretical_win', player, 25)
# banner.award_banner(c, player, 'lugonu', 3)
#elif gods_abandoned >= 3:
# banner.award_banner(c, player, 'lugonu', 2)
if query.check_ru_abandonment_game(c, player, game_start_time(game)):
banner.award_banner(c, player, 'lugonu', 3)
if not query.game_did_visit_lair(c, player, game_start_time(game)):
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, False)
# And the banner:
banner.award_banner(c, player, 'kikubaaqudgha', 3)
# else:
# Just 20 bonus points for winning without doing Lair.
# assign_points(c, 'lairless_win', player, 20)
if game['sklev'] < 20:
if not query.did_worship_god(c, 'Ashenzari', player, game['start'], game['end']):
if game['sklev'] < 13:
banner.award_banner(c, player, 'sif', 3)
else:
banner.award_banner(c, player, 'sif', 2)
if game['xl'] < 19:
if not query.did_sacrifice(c, 'experience', player, game['start'], game['end']):
assign_points(c, 'ruthless_efficiency', player, 25, False)
banner.award_banner(c, player, 'vehumet', 3)
#cutoff = query.time_from_str(game['end']) - datetime.timedelta(hours=27)
#if query.time_from_str(game['start']) > cutoff:
# if query.count_wins(c, player = game['name'], before = game_end, after = cutoff) > 0:
# banner.award_banner(c, player, 'oldbanner', 3)
# else:
# banner.award_banner(c, player, 'oldbanner', 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, 'dithmenos', 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, 'dithmenos', 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, 'dithmenos', 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) < 8:
if not banner.player_has_banner(c, player, ban, 3):
query.assign_stepdown_points(c, ban, player, 75)
banner.award_banner(c, player, ban, 3)
if query.is_unbeliever(c, game):
banner.award_banner(c, player, 'trog', 3)
if is_all_runer(game):
all_allruners = number_of_allruners_before(c, game)
assign_points(c, "nth_allrune_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)
if n_my_wins == 0:
# First win!
assign_points(c, "my_1st_win", game['name'], 100)
else:
# If the new win is a different race/class from a previous win, bonus!
for x in my_wins:
if repeat_race_class(x['charabbrev'], game['char']) == 0:
assign_points(c, "my_2nd_win_norep", game['name'], 50, False)
did_streak = query.win_is_streak(c, game['name'], game_start)
if did_streak:
# Award banner.
banner.award_banner(c, player, 'cheibriados', 2)
# 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:])
query.assign_stepdown_points(c, 'species_win:' + game['char'][0:2], game['name'], query.race_formula(wins_before, species_wins_before), False)
query.assign_stepdown_points(c, 'background_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)
query.assign_stepdown_points(c, 'god_win:' + banner_god, game['name'], query.god_formula(wins_before, god_wins_before), False)
def do_milestone_ghost(c, mile):
"""When you kill a player ghost, you get two clan points! Otherwise this
isn't terribly remarkable."""
if not mile["milestone"].startswith("banished"):
if query.count_team_points(c, mile["name"], "ghost") < 200:
assign_team_points(c, "ghost", mile["name"], 2)