aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorVincent-Michael <Vincent_Michael@gmx.de>2013-07-21 14:09:16 +0200
committerVincent-Michael <Vincent_Michael@gmx.de>2013-07-21 14:09:16 +0200
commitfaa3dc9608a5d630e7c732de30dd8bc6b0eba124 (patch)
treebecdc0bc746a18aeac5efaa3bc8dc53eccd36ae8 /sql
parentef50383811365f302028fbaaa8d7682ef51436bc (diff)
Core/Spells: Update/Convert priest "Phantasm" for 4.3.4
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2013_07_21_03_world_spell_script_misc_434.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/2013_07_21_03_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_21_03_world_spell_script_misc_434.sql
new file mode 100644
index 00000000000..2b4933fd433
--- /dev/null
+++ b/sql/updates/world/2013_07_21_03_world_spell_script_misc_434.sql
@@ -0,0 +1,13 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=-47569;
+INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES
+(-47569,'spell_pri_phantasm');
+
+DELETE FROM `spell_ranks` WHERE `first_spell_id`=47569;
+INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES
+(47569, 47569, 1),
+(47569, 47570, 2);
+
+DELETE FROM `spell_proc_event` WHERE `entry` IN (47569,47570);
+INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
+(47569, 0, 6, 16384, 0, 0, 16384, 0, 0, 100, 0),
+(47570, 0, 6, 16384, 0, 0, 16384, 0, 0, 100, 0);