diff options
| -rw-r--r-- | sql/updates/world/2015_04_26_02_world.sql | 57 |
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); |