From 5c97594a1691b78ab881437985dc5eeebb31a979 Mon Sep 17 00:00:00 2001 From: Nyeriah Date: Thu, 27 Aug 2015 18:52:30 -0300 Subject: DB/Conditions: Simplify the conditions for Kael'thas Ressurection spell Sorry for the oversight, thanks @joschiwald --- sql/updates/world/2015_08_27_00_world.sql | 12 ++++-------- 1 file changed, 4 insertions(+), 8 deletions(-) (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 index 3bc4f9e043b..a0519693f9e 100644 --- a/sql/updates/world/2015_08_27_00_world.sql +++ b/sql/updates/world/2015_08_27_00_world.sql @@ -1,10 +1,6 @@ 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'); +(13, 3, 36450, 0, 0, 31, 0, 3, 20060, 0, 0, 0, '', 'Kael\'thas Ressurection hit only Lord Sanguinar'), +(13, 3, 36450, 0, 1, 31, 0, 3, 20062, 0, 0, 0, '', 'Kael\'thas Ressurection hit only Grand Astromancer Capernian'), +(13, 3, 36450, 0, 2, 31, 0, 3, 20063, 0, 0, 0, '', 'Kael\'thas Ressurection hit only Master Engineer Telonicus'), +(13, 3, 36450, 0, 3, 31, 0, 3, 20064, 0, 0, 0, '', 'Kael\'thas Ressurection hit only Thaladred the Darkener'); -- cgit v1.2.3