aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorWyrserth <wyrserth@protonmail.com>2019-07-20 23:34:32 +0200
committerShauren <shauren.trinity@gmail.com>2021-12-16 23:32:02 +0100
commit63a11b1067456d89fcf239d01841f6352a7ed2f9 (patch)
tree22294adb43bf36011d15dc0f762bf18316c5c88d
parentc597bf8f70daa92914b3bef957505b8097e324dd (diff)
DB/Conditions: the spell Flatulate used by Reanimated Abomination involved in the quest That's Abominable! should only hit the Scourge minions required by the quest.
(cherry picked from commit ec34d90aca1d7d8206878d4523179380ad91953c)
-rw-r--r--sql/updates/world/master/2021_12_16_23_world_2019_07_20_09_world.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_16_23_world_2019_07_20_09_world.sql b/sql/updates/world/master/2021_12_16_23_world_2019_07_20_09_world.sql
new file mode 100644
index 00000000000..6c76d16a2f7
--- /dev/null
+++ b/sql/updates/world/master/2021_12_16_23_world_2019_07_20_09_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=59564;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13, 3, 59564, 0, 0, 31, 0, 3, 31142, 0, 0, 0, 0, "", "Spell Flatulate hits Icy Ghoul"),
+(13, 3, 59564, 0, 1, 31, 0, 3, 31147, 0, 0, 0, 0, "", "Spell Flatulate hits Vicious Geist"),
+(13, 3, 59564, 0, 2, 31, 0, 3, 31205, 0, 0, 0, 0, "", "Spell Flatulate hits Risen Alliance Soldier");