aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorVincent-Michael <Vincent_Michael@gmx.de>2012-09-09 03:59:34 +0200
committerVincent-Michael <Vincent_Michael@gmx.de>2012-09-09 04:02:47 +0200
commit2317af8dd3faac12b583978e14e47fd90ade4520 (patch)
tree2a9b8111470b78331bb0e4dc1bc24ec913a9e3bb /sql/updates
parentd04f155b6529e3d86fca931075775fd34b544e29 (diff)
Core/Spells: Convert Gift of the Naaru in spell script
Closes #6545
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2012_09_09_02_world_spell_script_names.sql10
-rw-r--r--sql/updates/world/2012_09_09_03_world_spell_bonus_data.sql9
2 files changed, 19 insertions, 0 deletions
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');