diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2025-09-27 18:36:32 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-09-27 18:36:32 +0200 |
| commit | 848a3cdf4d00ba6e0fa654d52e8d0e9c7efd7da6 (patch) | |
| tree | bb47b6d905534b439335a51f6874f54f80a328c9 /sql | |
| parent | 55aee6af4fbe765a14ba30089a6a07ce95640de9 (diff) | |
DB/Conditions: Add proper conditions for Jesse Masters <Butcher>
closes #31312
by CraftedRO
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2025_09_27_02_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2025_09_27_02_world.sql b/sql/updates/world/3.3.5/2025_09_27_02_world.sql new file mode 100644 index 00000000000..9f1f1f7289d --- /dev/null +++ b/sql/updates/world/3.3.5/2025_09_27_02_world.sql @@ -0,0 +1,10 @@ +-- Add proper conditions for Jesse Masters <Butcher> +UPDATE `gossip_menu` SET `VerifiedBuild`=63305 WHERE `MenuID`=9798 AND `TextID`=13503; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (14,15,23) AND `SourceGroup` IN (9798,29244) AND `SourceEntry` IN (0,13502,13503,33454,40202); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(14, 9798, 13502, 0, 0, 47, 0, 12212, 64, 0, 1, 0, 0, '', "Show gossip menu if player does not have quest 'Replenishing the Storehouse' rewarded"), +(14, 9798, 13503, 0, 0, 47, 0, 12212, 64, 0, 0, 0, 0, '', "Show gossip menu if player has quest 'Replenishing the Storehouse' rewarded"), +(15, 9798, 0, 0, 0, 47, 0, 12212, 64, 0, 0, 0, 0, '', "Show gossip menu if player has quest 'Replenishing the Storehouse' rewarded"), +(23, 29244, 33454, 0, 0, 47, 0, 12212, 64, 0, 0, 0, 0, '', "Sell Salted Venison if player has quest 'Replenishing the Storehouse' rewarded"), +(23, 29244, 40202, 0, 0, 47, 0, 12216, 64, 0, 0, 0, 0, '', "Sell Sizzling Grizzly Flank if player has quest 'Take Their Rear!' rewarded"); |