diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_07_25_00_world_spell_script_names.sql | 22 | ||||
| -rw-r--r-- | sql/updates/world/2013_07_25_01_world_conditions.sql | 2 |
2 files changed, 24 insertions, 0 deletions
diff --git a/sql/updates/world/2013_07_25_00_world_spell_script_names.sql b/sql/updates/world/2013_07_25_00_world_spell_script_names.sql new file mode 100644 index 00000000000..14e6d16df44 --- /dev/null +++ b/sql/updates/world/2013_07_25_00_world_spell_script_names.sql @@ -0,0 +1,22 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( +'spell_warl_banish', +'spell_dru_enrage', +'spell_pri_mana_burn', +'spell_pri_guardian_spirit', +'spell_dk_improved_blood_presence', +'spell_dk_improved_frost_presence', +'spell_dk_improved_unholy_presence', +'spell_dk_presence' +); + +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(-710, 'spell_warl_banish'), +(5229, 'spell_dru_enrage'), +(8129, 'spell_pri_mana_burn'), +(47788, 'spell_pri_guardian_spirit'), +(-50365,'spell_dk_improved_blood_presence'), +(-50384,'spell_dk_improved_frost_presence'), +(-50391,'spell_dk_improved_unholy_presence'), +(48266, 'spell_dk_presence'), +(48263, 'spell_dk_presence'), +(48265, 'spell_dk_presence'); diff --git a/sql/updates/world/2013_07_25_01_world_conditions.sql b/sql/updates/world/2013_07_25_01_world_conditions.sql new file mode 100644 index 00000000000..1990fe3094b --- /dev/null +++ b/sql/updates/world/2013_07_25_01_world_conditions.sql @@ -0,0 +1,2 @@ +-- Fix gossip condition for Bat Handler Camille <Bat Handler> +UPDATE `conditions` SET `ConditionTypeOrReference`=28 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8894 AND `SourceEntry`=0 AND `ConditionValue1`=11229; |