From 630e482f91d8480c78308b99090a39e59036af8b Mon Sep 17 00:00:00 2001 From: Killyana Date: Sat, 29 Aug 2015 23:30:04 +0200 Subject: DB/Conditions: Fix conditions for Mortar and Fire Cannon Author: @joschiwald Closes #15080 (cherry picked from commit 6fedea54ef3f1c678f0869807ac38b1db72351fd) --- sql/updates/world/2015_10_20_01_world_2015_08_29_04.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/2015_10_20_01_world_2015_08_29_04.sql (limited to 'sql') diff --git a/sql/updates/world/2015_10_20_01_world_2015_08_29_04.sql b/sql/updates/world/2015_10_20_01_world_2015_08_29_04.sql new file mode 100644 index 00000000000..b0ffc1fb0c5 --- /dev/null +++ b/sql/updates/world/2015_10_20_01_world_2015_08_29_04.sql @@ -0,0 +1,11 @@ +-- +-- Removed useless conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (62290,62307,62357,62489,62635); +-- Adjusted incorrect conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (62363,65044,65045); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition` ,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,2,62363,0,0,31,0,3,33214,0,0,0,'','Flame Leviathan - Anti-Air Rocket'), +(13,1,65044,0,0,32,0,0x18, 0,0,0,0,'','Flame Leviathan - Flames'), -- should hit everything +(13,2,65044,0,0,31,0,3,33090,0,0,0,'','Flame Leviathan - Flames'), +(13,1,65045,0,0,32,0,0x18, 0,0,0,0,'','Flame Leviathan - Flames'), -- should hit everything +(13,2,65045,0,0,31,0,3,33090,0,0,0,'','Flame Leviathan - Flames'); -- cgit v1.2.3