From 2317af8dd3faac12b583978e14e47fd90ade4520 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sun, 9 Sep 2012 03:59:34 +0200 Subject: Core/Spells: Convert Gift of the Naaru in spell script Closes #6545 --- sql/updates/world/2012_09_09_02_world_spell_script_names.sql | 10 ++++++++++ sql/updates/world/2012_09_09_03_world_spell_bonus_data.sql | 9 +++++++++ 2 files changed, 19 insertions(+) create mode 100644 sql/updates/world/2012_09_09_02_world_spell_script_names.sql create mode 100644 sql/updates/world/2012_09_09_03_world_spell_bonus_data.sql (limited to 'sql') diff --git a/sql/updates/world/2012_09_09_02_world_spell_script_names.sql b/sql/updates/world/2012_09_09_02_world_spell_script_names.sql new file mode 100644 index 00000000000..9c2beee82af --- /dev/null +++ b/sql/updates/world/2012_09_09_02_world_spell_script_names.sql @@ -0,0 +1,10 @@ +-- Gabe der Naaru +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_gift_of_naaru'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(28880,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_WARRIOR +(59542,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_PALADIN +(59543,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_HUNTER +(59544,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_PRIEST +(59545,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_DEATHKNIGHT +(59547,'spell_gen_gift_of_naaru'), -- SPELLFAMILY_SHAMAN +(59548,'spell_gen_gift_of_naaru'); -- SPELLFAMILY_MAGE diff --git a/sql/updates/world/2012_09_09_03_world_spell_bonus_data.sql b/sql/updates/world/2012_09_09_03_world_spell_bonus_data.sql new file mode 100644 index 00000000000..340bb8e28bc --- /dev/null +++ b/sql/updates/world/2012_09_09_03_world_spell_bonus_data.sql @@ -0,0 +1,9 @@ +DELETE FROM `spell_bonus_data` WHERE `entry` IN (28880,59542,59543,59544,59545,59547,59548) +INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES +(28880,0,0,0,0,'Warrior - Gabe der Naaru'), +(59542,0,0,0,0,'Paladin - Gabe der Naaru'), +(59543,0,0,0,0,'Hunter - Gabe der Naaru'), +(59544,0,0,0,0,'Priest - Gabe der Naaru'), +(59545,0,0,0,0,'Deathknight - Gabe der Naaru'), +(59547,0,0,0,0,'Shaman - Gabe der Naaru'), +(59548,0,0,0,0,'Mage - Gabe der Naaru'); -- cgit v1.2.3