From 9c24f3ecd3053c47f07eedff33ce2be2103fa4f6 Mon Sep 17 00:00:00 2001 From: malcrom Date: Thu, 28 Dec 2023 01:47:36 +0100 Subject: DB/Durotar: Added vendor items for Torenda and Goratin Closes #29526 --- sql/updates/world/master/2023_12_28_04_world.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/world/master/2023_12_28_04_world.sql diff --git a/sql/updates/world/master/2023_12_28_04_world.sql b/sql/updates/world/master/2023_12_28_04_world.sql new file mode 100644 index 00000000000..b5f7f7ccb74 --- /dev/null +++ b/sql/updates/world/master/2023_12_28_04_world.sql @@ -0,0 +1,20 @@ +-- Add missing vendor items to Darkspear Hold +DELETE FROM `npc_vendor` WHERE `entry` IN (39031,39032); +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES +-- Torenda +(39031, 1, 117, 0, 0, 1, 0, 0, 52649), +(39031, 2, 2287, 0, 0, 1, 0, 0, 52649), +(39031, 3, 3770, 0, 0, 1, 0, 0, 52649), +(39031, 4, 3771, 0, 0, 1, 0, 0, 52649), +(39031, 5, 4599, 0, 0, 1, 0, 0, 52649), +(39031, 6, 8952, 0, 0, 1, 0, 0, 52649), +(39031, 7, 159, 0, 0, 1, 0, 0, 52649), +(39031, 8, 1179, 0, 0, 1, 0, 0, 52649), +(39031, 9, 1205, 0, 0, 1, 0, 0, 52649), +(39031, 10, 1708, 0, 0, 1, 0, 0, 52649), +(39031, 11, 1645, 0, 0, 1, 0, 0, 52649), +(39031, 12, 8766, 0, 0, 1, 0, 0, 52649), +-- Gora'tin +(39032, 1, 4540, 0, 0, 1, 0, 0, 52649), +(39032, 2, 159, 0, 0, 1, 0, 0, 52649), +(39032, 3, 4496, 0, 0, 1, 0, 0, 52649); -- cgit v1.2.3