From 129b74ffb2d54927bf753b4a72df0edd8d9e4958 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 25 Feb 2024 07:42:32 +0100 Subject: DB/Quest: Dr. Terrible's "Building a Better Flesh Giant" closes #27984 by CraftedRO --- sql/updates/world/3.3.5/2024_02_25_00_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/3.3.5/2024_02_25_00_world.sql (limited to 'sql/updates/world') 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'); -- cgit v1.2.3