From d952c90754d2e17ca32b573a07cf15246a8ac372 Mon Sep 17 00:00:00 2001
From: azazel <none@none>
Date: Sun, 29 Aug 2010 22:40:23 +0600
Subject: Spell Scripts: * add new file spell_item.cpp for spells used by items
 (but not by quests) * move some dummy effects of generic spells to scripts *
 implement spell for quest 12937 Relief for the Fallen. Closes issue #3070

--HG--
branch : trunk
---
 sql/base/world_database.sql                   | 19 ++++++++++---
 sql/updates/9666_world_spell_script_names.sql | 39 +++++++++++++++++++++++++++
 2 files changed, 54 insertions(+), 4 deletions(-)
 create mode 100644 sql/updates/9666_world_spell_script_names.sql

(limited to 'sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index b4af6b72227..1b8df6a1fbf 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -14820,8 +14820,19 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 -- quest
 ( 45449, 'spell_q11587_arcane_prisoner_rescue'),
 ( 46023, 'spell_q11730_ultrasonic_screwdriver'),
+( 52308, 'spell_q12683_take_sputum_sample'),
+( 55804, 'spell_q12937_relief_for_the_fallen'),
+-- item
+(  8063, 'spell_item_deviate_fish'),
+( 67019, 'spell_item_flask_of_the_north'),
+( 13280, 'spell_item_gnomish_death_ray'),
+( 33060, 'spell_item_make_a_wish'),
+( 13120, 'spell_item_net_o_matic'),
+( 16589, 'spell_item_noggenfogger_elixir'),
+(  8213, 'spell_item_savory_deviate_delight'),
+( 59640, 'spell_item_underbelly_elixir'),
 -- warrior
-( 12975,'spell_warr_last_stand'),
+( 12975, 'spell_warr_last_stand'),
 -- paladin
 ( 20425, 'spell_pal_judgement_of_command'),
 ( 63521, 'spell_pal_guarded_by_the_light'),
@@ -14845,9 +14856,9 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 47948, 'spell_pri_pain_and_suffering_proc'),
 (-47540, 'spell_pri_penance'),
 -- death knight
-(-49158,'spell_dk_corpse_explosion'),
-( 50524,'spell_dk_runic_power_feed'),
-(-55090,'spell_dk_scourge_strike'),
+(-49158, 'spell_dk_corpse_explosion'),
+( 50524, 'spell_dk_runic_power_feed'),
+(-55090, 'spell_dk_scourge_strike'),
 -- shaman
 ( 39610, 'spell_sha_mana_tide_totem'),
 ( -1535, 'spell_sha_fire_nova'),
diff --git a/sql/updates/9666_world_spell_script_names.sql b/sql/updates/9666_world_spell_script_names.sql
new file mode 100644
index 00000000000..af4089f4284
--- /dev/null
+++ b/sql/updates/9666_world_spell_script_names.sql
@@ -0,0 +1,39 @@
+-- 8063 Deviate Fish
+DELETE FROM `spell_script_names` WHERE `spell_id`=8063 AND `ScriptName`='spell_item_deviate_fish';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (8063,'spell_item_deviate_fish');
+
+-- 67019 Flask of the North
+DELETE FROM `spell_script_names` WHERE `spell_id`=67019 AND `ScriptName`='spell_item_flask_of_the_north';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (67019,'spell_item_flask_of_the_north');
+
+-- 13280 Gnomish Death Ray
+DELETE FROM `spell_script_names` WHERE `spell_id`=13280 AND `ScriptName`='spell_item_gnomish_death_ray';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (13280,'spell_item_gnomish_death_ray');
+
+-- 33060 Make a Wish
+DELETE FROM `spell_script_names` WHERE `spell_id`=33060 AND `ScriptName`='spell_item_make_a_wish';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (33060,'spell_item_make_a_wish');
+
+-- 13120 Net-o-Matic
+DELETE FROM `spell_script_names` WHERE `spell_id`=13120 AND `ScriptName`='spell_item_net_o_matic';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (13120,'spell_item_net_o_matic');
+
+-- 16589 Noggenfogger Elixir
+DELETE FROM `spell_script_names` WHERE `spell_id`=16589 AND `ScriptName`='spell_item_noggenfogger_elixir';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (16589,'spell_item_noggenfogger_elixir');
+
+-- 8213 Savory Deviate Delight
+DELETE FROM `spell_script_names` WHERE `spell_id`=8213 AND `ScriptName`='spell_item_savory_deviate_delight';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (8213,'spell_item_savory_deviate_delight');
+
+-- 52308 Take Sputum Sample
+DELETE FROM `spell_script_names` WHERE `spell_id`=52308 AND `ScriptName`='spell_q12683_take_sputum_sample';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (52308,'spell_q12683_take_sputum_sample');
+
+-- 59640 Underbelly Elixir
+DELETE FROM `spell_script_names` WHERE `spell_id`=59640 AND `ScriptName`='spell_item_underbelly_elixir';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (59640,'spell_item_underbelly_elixir');
+
+-- 55804 Healing Finished
+DELETE FROM `spell_script_names` WHERE `spell_id`=55804 AND `ScriptName`='spell_q12937_relief_for_the_fallen';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (55804,'spell_q12937_relief_for_the_fallen');
-- 
cgit v1.2.3