From 22cbefbc697e5f85d206af672af29ec30a32b733 Mon Sep 17 00:00:00 2001 From: schneefux Date: Tue, 7 Nov 2017 19:46:41 +0100 Subject: add vampirism and healing columns to phase point --- crunch_phases.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'crunch_phases.sql') diff --git a/crunch_phases.sql b/crunch_phases.sql index e194dfa..5a82162 100644 --- a/crunch_phases.sql +++ b/crunch_phases.sql @@ -65,10 +65,15 @@ select sum(ability_aacrit_damage_dealt), sum(heal_heal_hero), sum(heal_healed_hero), + sum(heal_heal_ally), + sum(heal_healed_ally), sum(heal_heal_other), sum(heal_healed_other), sum(heal_rcvd_heal_hero), sum(heal_rcvd_healed_hero), + sum(heal_rcvd_healed_vamp), + sum(heal_rcvd_heal_ally), + sum(heal_rcvd_healed_ally), sum(heal_rcvd_heal_other), sum(heal_rcvd_healed_other), _ph_item_uses_insert @@ -135,4 +140,17 @@ ability_aa_damage_true = ability_aa_damage_true + values(ability_aa_damage_true) ability_aa_damage_dealt = ability_aa_damage_dealt + values(ability_aa_damage_dealt), ability_aacrit_damage_true = ability_aacrit_damage_true + values(ability_aacrit_damage_true), ability_aacrit_damage_dealt = ability_aacrit_damage_dealt + values(ability_aacrit_damage_dealt), +heal_heal_hero = heal_heal_hero + values(heal_heal_hero), +heal_healed_hero = heal_healed_hero + values(heal_healed_hero), +heal_heal_ally = heal_heal_ally + values(heal_heal_ally), +heal_healed_ally = heal_healed_ally + values(heal_healed_ally), +heal_heal_other = heal_heal_other + values(heal_heal_other), +heal_healed_other = heal_healed_other + values(heal_healed_other), +heal_rcvd_heal_hero = heal_rcvd_heal_hero + values(heal_rcvd_heal_hero), +heal_rcvd_healed_hero = heal_rcvd_healed_hero + values(heal_rcvd_healed_hero), +heal_rcvd_healed_vamp = heal_rcvd_healed_vamp + values(heal_rcvd_healed_vamp), +heal_rcvd_heal_ally = heal_rcvd_heal_ally + values(heal_rcvd_heal_ally), +heal_rcvd_healed_ally = heal_rcvd_healed_ally + values(heal_rcvd_healed_ally), +heal_rcvd_heal_other = heal_rcvd_heal_other + values(heal_rcvd_heal_other), +heal_rcvd_healed_other = heal_rcvd_healed_other + values(heal_rcvd_healed_other), _ph_item_uses_update -- cgit v1.3.1