From 120d2914bdb62f485015004ab2ea61303a815232 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Thu, 25 Jul 2013 02:25:23 +0200 Subject: DB/Spells: Fix warrior talent "Die by the Sword" --- sql/updates/world/2013_07_25_02_world_spell_misc_434.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/2013_07_25_02_world_spell_misc_434.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_07_25_02_world_spell_misc_434.sql b/sql/updates/world/2013_07_25_02_world_spell_misc_434.sql new file mode 100644 index 00000000000..040d3d58dff --- /dev/null +++ b/sql/updates/world/2013_07_25_02_world_spell_misc_434.sql @@ -0,0 +1,8 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=24 AND `SourceEntry` IN (81913,81914); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(24, 0, 81913, 0, 0, 38, 1, 20, 4, 0, 0, 0, 0, '', 'Die by the Sword (Rank 1) - 20% health or less'), +(24, 0, 81914, 0, 0, 38, 1, 20, 4, 0, 0, 0, 0, '', 'Die by the Sword (Rank 2) - 20% health or less'); + +DELETE FROM `spell_proc_event` WHERE `entry`=-81913; +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +(-81913, 0, 0, 0, 0, 0, 0, 0, 0, 0, 120); -- cgit v1.2.3