aboutsummaryrefslogtreecommitdiff
path: root/sql
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 /sql
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)
Diffstat (limited to 'sql')
-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");