aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2024-02-25 07:42:32 +0100
committerGitHub <noreply@github.com>2024-02-25 07:42:32 +0100
commit129b74ffb2d54927bf753b4a72df0edd8d9e4958 (patch)
treedce9fbed7cad6ba4f355eb4e6ef0211d74eb5270
parent75e38a5d8f739358421ca5eece7e3701f6b8d190 (diff)
DB/Quest: Dr. Terrible's "Building a Better Flesh Giant"
closes #27984 by CraftedRO
-rw-r--r--sql/updates/world/3.3.5/2024_02_25_00_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_02_25_00_world.sql b/sql/updates/world/3.3.5/2024_02_25_00_world.sql
new file mode 100644
index 00000000000..ad2b41c0863
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_02_25_00_world.sql
@@ -0,0 +1,5 @@
+-- Fix wrong quest item condition for Dr. Terrible's "Building a Better Flesh Giant"
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 1 AND `SourceGroup` = 30409 AND `SourceEntry` = 42772;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(1, 30409, 42772, 0, 0, 47, 0, 13042, 74, 0, 0, 0, 0, '', 'Dr. Terribles "Building a Better Flesh Giant" only drops if player has state_mask 74 Deep in the Bowels of The Underhalls'),
+(1, 30409, 42772, 0, 0, 2, 0, 42772, 1, 1, 1, 0, 0, '', 'Dr. Terribles "Building a Better Flesh Giant" will drop only if the player doesn\'t have it already');