From b6a5d667e2844a41d8c23fadbe5268ddde254db0 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sun, 21 Jul 2013 17:46:08 +0200 Subject: Core/Spells: Update/Convert priest "Body and Soul" for 4.3.4 --- .../world/2013_07_21_06_world_spell_script_names_434.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/2013_07_21_06_world_spell_script_names_434.sql (limited to 'sql') diff --git a/sql/updates/world/2013_07_21_06_world_spell_script_names_434.sql b/sql/updates/world/2013_07_21_06_world_spell_script_names_434.sql new file mode 100644 index 00000000000..46219538973 --- /dev/null +++ b/sql/updates/world/2013_07_21_06_world_spell_script_names_434.sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=-64127; +INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES +(-64127,'spell_pri_body_and_soul'); + +DELETE FROM `spell_ranks` WHERE `first_spell_id`=64127; +INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES +(64127, 64127, 1), +(64127, 64129, 2); + +DELETE FROM `spell_proc_event` WHERE `entry` IN (64127,64129); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(64127, 0, 6, 0x1, 0x1, 0x80000, 0, 0, 0, 100, 0), +(64129, 0, 6, 0x1, 0x1, 0x80000, 0, 0, 0, 100, 0); -- cgit v1.2.3