From 0b94293dba4a3fa202ec1fe24f16f76d0aef7496 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Thu, 18 Jul 2013 15:23:09 +0200 Subject: Core/Spells: Convert/Update more spells for 4.3.4 --- .../world/2013_07_18_01_world_spell_script_misc_434.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/updates/world/2013_07_18_01_world_spell_script_misc_434.sql (limited to 'sql') diff --git a/sql/updates/world/2013_07_18_01_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_18_01_world_spell_script_misc_434.sql new file mode 100644 index 00000000000..b5eecfcc8e7 --- /dev/null +++ b/sql/updates/world/2013_07_18_01_world_spell_script_misc_434.sql @@ -0,0 +1,16 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (-46951,23780,33896,37594,37705,23551,23552,23572); +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-46951,'spell_warr_sword_and_board'), +(23780,'spell_item_aegis_of_preservation'), +(33896,'spell_item_desperate_defense'), +(37594,'spell_pri_item_greater_heal_refund'), +(37705,'spell_pal_item_healing_discount'), +(23551,'spell_sha_item_lightning_shield'), +(23552,'spell_sha_item_lightning_shield_trigger'), +(23572,'spell_sha_item_mana_surge'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (46951); +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(46951, 46951, 1), +(46951, 46952, 2), +(46951, 46953, 3); -- cgit v1.2.3