From d952c90754d2e17ca32b573a07cf15246a8ac372 Mon Sep 17 00:00:00 2001 From: azazel 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/updates/9666_world_spell_script_names.sql | 39 +++++++++++++++++++++++++++ 1 file changed, 39 insertions(+) create mode 100644 sql/updates/9666_world_spell_script_names.sql (limited to 'sql/updates') 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