From 234d0c17d6400fb5d395f3c640846967e4ec2e3a Mon Sep 17 00:00:00 2001 From: Nyeriah Date: Thu, 27 Aug 2015 17:29:54 -0300 Subject: DB/Conditions: Missing spell target conditions for Kael'thas advisor Ressurection spell --- sql/updates/world/2015_08_27_00_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/2015_08_27_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/2015_08_27_00_world.sql b/sql/updates/world/2015_08_27_00_world.sql new file mode 100644 index 00000000000..3bc4f9e043b --- /dev/null +++ b/sql/updates/world/2015_08_27_00_world.sql @@ -0,0 +1,10 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` = 36450; +INSERT INTO `conditions`(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`,`ConditionValue2`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 36450, 0, 0, 31, 0, 3, 20060, 0, 0, 0, '', 'Kael\'thas Ressurection EFFECT_0 hit only Lord Sanguinar'), +(13, 1, 36450, 0, 1, 31, 0, 3, 20062, 0, 0, 0, '', 'Kael\'thas Ressurection EFFECT_0 hit only Grand Astromancer Capernian'), +(13, 1, 36450, 0, 2, 31, 0, 3, 20063, 0, 0, 0, '', 'Kael\'thas Ressurection EFFECT_0 hit only Master Engineer Telonicus'), +(13, 1, 36450, 0, 3, 31, 0, 3, 20064, 0, 0, 0, '', 'Kael\'thas Ressurection EFFECT_0 hit only Thaladred the Darkener'), +(13, 2, 36450, 0, 0, 31, 0, 3, 20060, 0, 0, 0, '', 'Kael\'thas Ressurection EFFECT_1 hit only Lord Sanguinar'), +(13, 2, 36450, 0, 1, 31, 0, 3, 20062, 0, 0, 0, '', 'Kael\'thas Ressurection EFFECT_1 hit only Grand Astromancer Capernian'), +(13, 2, 36450, 0, 2, 31, 0, 3, 20063, 0, 0, 0, '', 'Kael\'thas Ressurection EFFECT_1 hit only Master Engineer Telonicus'), +(13, 2, 36450, 0, 3, 31, 0, 3, 20064, 0, 0, 0, '', 'Kael\'thas Ressurection EFFECT_1 hit only Thaladred the Darkener'); -- cgit v1.2.3