From 4d111c10f0389b0fc762e58df0fb7003fb4ec11e Mon Sep 17 00:00:00 2001 From: Warpten Date: Sat, 1 Dec 2012 14:58:56 +0100 Subject: Scripts/Spells: Fixed Rogue's Recuperate, Mage's Conjure Refreshment and Paladin's Sacred Shield. Also fixed SQL file naming. --- .../world/2012_11_25_02_world_spell_script_names.sql | 9 +++++++++ .../world/2012_11_25_world_spell_script_names.sql | 9 --------- .../world/2012_12_01_00_world_spell_script_names.sql | 16 ++++++++++++++++ 3 files changed, 25 insertions(+), 9 deletions(-) create mode 100644 sql/updates/world/2012_11_25_02_world_spell_script_names.sql delete mode 100644 sql/updates/world/2012_11_25_world_spell_script_names.sql create mode 100644 sql/updates/world/2012_12_01_00_world_spell_script_names.sql (limited to 'sql') diff --git a/sql/updates/world/2012_11_25_02_world_spell_script_names.sql b/sql/updates/world/2012_11_25_02_world_spell_script_names.sql new file mode 100644 index 00000000000..f0dd277cc96 --- /dev/null +++ b/sql/updates/world/2012_11_25_02_world_spell_script_names.sql @@ -0,0 +1,9 @@ +DELETE FROM spell_linked_spell WHERE spell_trigger = 73325; +INSERT INTO spell_linked_spell (spell_trigger, spell_effect, type, comment) VALUES +(73325, 92833, 0, "Priest - Leap of Faith"); + +DELETE FROM spell_script_names WHERE spell_id = 92833; +DELETE FROM spell_script_names WHERE spell_id = -139; +INSERT INTO spell_script_names (spell_id, ScriptName) VALUES +(92833, "spell_pri_leap_of_faith_effect_trigger"), +(139, "spell_pri_renew"); -- Minus doesnt matter, theres no rank any more diff --git a/sql/updates/world/2012_11_25_world_spell_script_names.sql b/sql/updates/world/2012_11_25_world_spell_script_names.sql deleted file mode 100644 index f0dd277cc96..00000000000 --- a/sql/updates/world/2012_11_25_world_spell_script_names.sql +++ /dev/null @@ -1,9 +0,0 @@ -DELETE FROM spell_linked_spell WHERE spell_trigger = 73325; -INSERT INTO spell_linked_spell (spell_trigger, spell_effect, type, comment) VALUES -(73325, 92833, 0, "Priest - Leap of Faith"); - -DELETE FROM spell_script_names WHERE spell_id = 92833; -DELETE FROM spell_script_names WHERE spell_id = -139; -INSERT INTO spell_script_names (spell_id, ScriptName) VALUES -(92833, "spell_pri_leap_of_faith_effect_trigger"), -(139, "spell_pri_renew"); -- Minus doesnt matter, theres no rank any more diff --git a/sql/updates/world/2012_12_01_00_world_spell_script_names.sql b/sql/updates/world/2012_12_01_00_world_spell_script_names.sql new file mode 100644 index 00000000000..bd13cb8ef9d --- /dev/null +++ b/sql/updates/world/2012_12_01_00_world_spell_script_names.sql @@ -0,0 +1,16 @@ +-- Conjure Refreshment +DELETE FROM `spell_script_names` WHERE `spell_id`=42955; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(42955, 'spell_mage_conjure_refreshment'); + +-- Sacred Shield +DELETE FROM spell_proc_event WHERE entry=85285; +INSERT INTO spell_proc_event (entry, Cooldown) VALUES(85285, 60); +DELETE FROM spell_script_names WHERE spell_id=85285; +INSERT INTO spell_script_names (spell_id, ScriptName) VALUES +(85285, 'spell_pal_sacred_shield'); + +-- Recuperate +DELETE FROM spell_script_names WHERE spell_id=73651; +INSERT INTO spell_script_names (spell_id, ScriptName) VALUES +(73651, "spell_rog_recuperate"); -- cgit v1.2.3