DB/Vendors: Updated vendors in Westfall to 6.x (19865)

1 files changed, 57 insertions, 0 deletions

diff --git a/sql/updates/world/2015_04_26_02_world.sql b/sql/updates/world/2015_04_26_02_world.sql
new file mode 100644
index 00000000000..3dbd6acdef1
--- /dev/null
+++ b/sql/updates/world/2015_04_26_02_world.sql
@@ -0,0 +1,57 @@
+-- Vendors Westfall (19865)
+
+UPDATE `npc_vendor` SET `VerifiedBuild` = 19865 WHERE `entry` IN (42497, 8931, 1670, 233, 491, 4305);
+
+DELETE FROM `npc_vendor` WHERE `entry` IN (1668, 8934, 43948, 10045);
+INSERT INTO `npc_vendor` (`entry`, `item`, `slot`, `maxcount`, `ExtendedCost`, `Type`, `VerifiedBuild`) VALUES
+-- 1668 (William MacGregor)
+(1668, 2507, 1, 0, 0, 1, 19865),
+(1668, 3026, 2, 0, 0, 1, 19865),
+(1668, 11304, 41, 1, 0, 1, 19865),
+-- 8934 (Christopher Hewen)
+(8934, 7005, 1, 0, 0, 1, 19865),
+(8934, 2901, 2, 0, 0, 1, 19865),
+(8934, 85663, 3, 0, 0, 1, 19865),
+(8934, 5956, 4, 0, 0, 1, 19865),
+(8934, 6256, 5, 0, 0, 1, 19865),
+(8934, 6217, 6, 0, 0, 1, 19865),
+(8934, 2678, 7, 0, 0, 1, 19865),
+(8934, 30817, 8, 0, 0, 1, 19865),
+(8934, 2320, 9, 0, 0, 1, 19865),
+(8934, 2880, 10, 0, 0, 1, 19865),
+(8934, 3371, 11, 0, 0, 1, 19865),
+(8934, 4289, 12, 0, 0, 1, 19865),
+(8934, 6529, 13, 0, 0, 1, 19865),
+(8934, 2604, 14, 0, 0, 1, 19865),
+(8934, 2324, 15, 0, 0, 1, 19865),
+(8934, 6260, 16, 0, 0, 1, 19865),
+(8934, 39354, 17, 0, 0, 1, 19865),
+(8934, 20815, 18, 0, 0, 1, 19865),
+(8934, 39505, 19, 0, 0, 1, 19865),
+(8934, 2321, 20, 0, 0, 1, 19865),
+(8934, 6530, 21, 0, 0, 1, 19865),
+(8934, 2605, 22, 0, 0, 1, 19865),
+(8934, 4291, 23, 0, 0, 1, 19865),
+(8934, 3466, 24, 0, 0, 1, 19865),
+(8934, 3857, 25, 0, 0, 1, 19865),
+(8934, 4399, 26, 0, 0, 1, 19865),
+(8934, 4400, 27, 0, 0, 1, 19865),
+(8934, 6532, 28, 0, 0, 1, 19865),
+(8934, 8343, 29, 0, 0, 1, 19865),
+(8934, 14341, 30, 0, 0, 1, 19865),
+(8934, 2325, 31, 0, 0, 1, 19865),
+(8934, 4341, 32, 0, 0, 1, 19865),
+(8934, 4342, 33, 0, 0, 1, 19865),
+(8934, 4340, 34, 0, 0, 1, 19865),
+-- 43948 (Private Jackson)
+(43948, 851, 1, 0, 0, 1, 19865),
+(43948, 1198, 2, 0, 0, 1, 19865),
+(43948, 2207, 3, 0, 0, 1, 19865),
+(43948, 2027, 4, 0, 0, 1, 19865),
+(43948, 2208, 5, 0, 0, 1, 19865),
+(43948, 2024, 6, 0, 0, 1, 19865),
+(43948, 2209, 7, 0, 0, 1, 19865),
+(43948, 922, 8, 0, 0, 1, 19865),
+(43948, 923, 9, 0, 0, 1, 19865),
+-- 10045 (Kirk Maxwell)
+(10045, 37460, 1, 0, 0, 1, 19865);