aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/master/2023_12_28_04_world.sql20
1 files changed, 20 insertions, 0 deletions
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 <Food & Drink>
+(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 <General Goods>
+(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);