From 98c8dc346ad5c84e548a966daba77a5e0098ee59 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Thu, 18 Jul 2013 12:05:57 +0200 Subject: Core/Spells: Convert/Update more spells in spell script for 4.3.4 --- .../world/2013_07_18_00_world_spell_script_misc_434.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/world/2013_07_18_00_world_spell_script_misc_434.sql (limited to 'sql') diff --git a/sql/updates/world/2013_07_18_00_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_18_00_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..9eed10846cb --- /dev/null +++ b/sql/updates/world/2013_07_18_00_world_spell_script_misc_434.sql @@ -0,0 +1,15 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-31641,50421,-30881); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-31641,'spell_mage_blazing_speed'), +(50421,'spell_dk_scent_of_blood'), +(-30881,'spell_sha_nature_guardian'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (31641,30881); +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(31641, 31641, 1), +(31641, 31642, 2), +(30881, 30881, 1), +(30881, 30883, 2), +(30881, 30884, 3); + +DELETE FROM `spell_proc_event` WHERE `entry` IN (30881,30883,30884); -- cgit v1.2.3