aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2015-08-29 23:30:04 +0200
committerMitchesD <majklprofik@seznam.cz>2015-10-20 15:36:05 +0200
commit630e482f91d8480c78308b99090a39e59036af8b (patch)
tree3fcb9731b29f45babf3c51b849f753c1382f1d12
parent5b4feb7ffdbf27ad697948d47e990389ee166b58 (diff)
DB/Conditions: Fix conditions for Mortar and Fire Cannon
Author: @joschiwald Closes #15080 (cherry picked from commit 6fedea54ef3f1c678f0869807ac38b1db72351fd)
-rw-r--r--sql/updates/world/2015_10_20_01_world_2015_08_29_04.sql11
1 files changed, 11 insertions, 0 deletions
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');