diff options
| -rw-r--r-- | sql/updates/world/2015_04_26_00_world.sql | 182 |
1 files changed, 182 insertions, 0 deletions
diff --git a/sql/updates/world/2015_04_26_00_world.sql b/sql/updates/world/2015_04_26_00_world.sql new file mode 100644 index 00000000000..c982bf2def9 --- /dev/null +++ b/sql/updates/world/2015_04_26_00_world.sql @@ -0,0 +1,182 @@ +-- Vendors Elwynn Forest (19865) + +UPDATE `npc_vendor` SET `VerifiedBuild` = 19865 WHERE `entry` IN (6367, 74, 1213, 151, 295, 2046, 844, 1650, 384, 3935, 3937, 190); + +DELETE FROM `npc_vendor` WHERE `entry` IN (78, 955, 152, 958, 959, 894, 896, 1645, 1249, 1250, 54, 1198, 465, 66); +INSERT INTO `npc_vendor` (`entry`, `item`, `slot`, `maxcount`, `ExtendedCost`, `Type`, `VerifiedBuild`) VALUES +-- 78 (Janos Hammerknuckle) +(78, 2131, 1, 0, 0, 1, 19865), +(78, 1194, 2, 0, 0, 1, 19865), +(78, 2134, 3, 0, 0, 1, 19865), +(78, 2479, 4, 0, 0, 1, 19865), +(78, 2130, 5, 0, 0, 1, 19865), +(78, 2480, 6, 0, 0, 1, 19865), +(78, 2139, 7, 0, 0, 1, 19865), +(78, 2132, 8, 0, 0, 1, 19865), +-- 955 (Sergeant De Vries) +(955, 2723, 1, 0, 0, 1, 19865), +(955, 2593, 2, 0, 0, 1, 19865), +(955, 2596, 3, 0, 0, 1, 19865), +(955, 2594, 4, 0, 0, 1, 19865), +(955, 2595, 5, 0, 0, 1, 19865), +(955, 83095, 6, 0, 0, 1, 19865), +(955, 82343, 7, 0, 0, 1, 19865), +(955, 83094, 8, 0, 0, 1, 19865), +(955, 82344, 9, 0, 0, 1, 19865), +(955, 159, 10, 0, 0, 1, 19865), +(955, 1179, 11, 0, 0, 1, 19865), +(955, 1205, 12, 0, 0, 1, 19865), +(955, 1708, 13, 0, 0, 1, 19865), +(955, 1645, 14, 0, 0, 1, 19865), +(955, 8766, 15, 0, 0, 1, 19865), +-- 152 (Brother Danil) +(152, 4540, 1, 0, 0, 1, 19865), +(152, 159, 2, 0, 0, 1, 19865), +(152, 4496, 3, 0, 0, 1, 19865), +-- 958 +(958, 64670, 1, 0, 0, 1, 19865), +(958, 63388, 2, 0, 0, 1, 19865), +(958, 79249, 3, 0, 0, 1, 19865), +(958, 3371, 4, 0, 0, 1, 19865), +(958, 2455, 608, 2, 0, 1, 19865), +(958, 3013, 609, 3, 0, 1, 19865), +(958, 3012, 615, 1, 0, 1, 19865), +(958, 1181, 610, 2, 0, 1, 19865), +(958, 955, 611, 2, 0, 1, 19865), +(958, 1180, 612, 2, 0, 1, 19865), +(958, 954, 613, 2, 0, 1, 19865), +(958, 858, 614, 3, 0, 1, 19865), +-- 959 +(959, 795, 1, 0, 0, 1, 19865), +(959, 3602, 2, 0, 0, 1, 19865), +(959, 794, 3, 0, 0, 1, 19865), +(959, 792, 4, 0, 0, 1, 19865), +(959, 3603, 5, 0, 0, 1, 19865), +(959, 793, 6, 0, 0, 1, 19865), +-- 894 (Homer Stonefield) +(894, 4536, 1, 0, 0, 1, 19865), +(894, 4537, 2, 0, 0, 1, 19865), +(894, 4538, 3, 0, 0, 1, 19865), +(894, 4539, 4, 0, 0, 1, 19865), +(894, 4602, 5, 0, 0, 1, 19865), +(894, 8953, 6, 0, 0, 1, 19865), +-- 896 (Veldan Lightfoot) +(896, 799, 1, 0, 0, 1, 19865), +(896, 1839, 2, 0, 0, 1, 19865), +(896, 798, 3, 0, 0, 1, 19865), +(896, 796, 4, 0, 0, 1, 19865), +(896, 1840, 5, 0, 0, 1, 19865), +(896, 797, 6, 0, 0, 1, 19865), +(896, 846, 7, 0, 0, 1, 19865), +(896, 1843, 8, 0, 0, 1, 19865), +(896, 845, 9, 0, 0, 1, 19865), +(896, 843, 10, 0, 0, 1, 19865), +(896, 1844, 11, 0, 0, 1, 19865), +(896, 844, 12, 0, 0, 1, 19865), +-- 1645 (Quartermaster Hicks) +(1645, 2520, 1, 0, 0, 1, 19865), +(1645, 2521, 2, 0, 0, 1, 19865), +(1645, 2522, 3, 0, 0, 1, 19865), +(1645, 2523, 4, 0, 0, 1, 19865), +(1645, 2524, 5, 0, 0, 1, 19865), +(1645, 2525, 6, 0, 0, 1, 19865), +(1645, 2526, 7, 0, 0, 1, 19865), +(1645, 2527, 8, 0, 0, 1, 19865), +-- 1249 (Quartermaster Hudson) +(1249, 2392, 1, 0, 0, 1, 19865), +(1249, 2393, 2, 0, 0, 1, 19865), +(1249, 2394, 3, 0, 0, 1, 19865), +(1249, 2395, 4, 0, 0, 1, 19865), +(1249, 2396, 5, 0, 0, 1, 19865), +(1249, 2397, 6, 0, 0, 1, 19865), +(1249, 17186, 7, 0, 0, 1, 19865), +(1249, 1201, 8, 0, 0, 1, 19865), +-- 1250 +(1250, 159, 1, 0, 0, 1, 19865), +(1250, 4540, 2, 0, 0, 1, 19865), +(1250, 4496, 3, 0, 0, 1, 19865), +(1250, 4498, 4, 0, 0, 1, 19865), +(1250, 4470, 5, 0, 0, 1, 19865), +(1250, 5042, 6, 0, 0, 1, 19865), +(1250, 7005, 7, 0, 0, 1, 19865), +(1250, 2901, 8, 0, 0, 1, 19865), +(1250, 85663, 9, 0, 0, 1, 19865), +(1250, 5956, 10, 0, 0, 1, 19865), +(1250, 6256, 11, 0, 0, 1, 19865), +(1250, 6217, 12, 0, 0, 1, 19865), +(1250, 2678, 13, 0, 0, 1, 19865), +(1250, 30817, 14, 0, 0, 1, 19865), +(1250, 2320, 15, 0, 0, 1, 19865), +(1250, 2880, 16, 0, 0, 1, 19865), +(1250, 3371, 17, 0, 0, 1, 19865), +(1250, 4289, 18, 0, 0, 1, 19865), +(1250, 6529, 19, 0, 0, 1, 19865), +(1250, 2604, 20, 0, 0, 1, 19865), +(1250, 2324, 21, 0, 0, 1, 19865), +(1250, 6260, 22, 0, 0, 1, 19865), +(1250, 39354, 23, 0, 0, 1, 19865), +(1250, 20815, 24, 0, 0, 1, 19865), +(1250, 39505, 25, 0, 0, 1, 19865), +(1250, 6272, 204, 1, 0, 1, 19865), +-- 54 (Corina Steele) +(54, 2489, 1, 0, 0, 1, 19865), +(54, 2492, 2, 0, 0, 1, 19865), +(54, 2491, 3, 0, 0, 1, 19865), +(54, 2494, 4, 0, 0, 1, 19865), +(54, 2495, 5, 0, 0, 1, 19865), +(54, 2488, 6, 0, 0, 1, 19865), +(54, 2490, 7, 0, 0, 1, 19865), +(54, 2493, 8, 0, 0, 1, 19865), +-- 1198 +(1198, 2506, 1, 0, 0, 1, 19865), +(1198, 2507, 2, 0, 0, 1, 19865), +-- 465 (Barkeep Dobbins) +(465, 1939, 1, 0, 0, 1, 19865), +(465, 159, 2, 0, 0, 1, 19865), +(465, 1179, 3, 0, 0, 1, 19865), +(465, 1205, 4, 0, 0, 1, 19865), +(465, 1708, 5, 0, 0, 1, 19865), +(465, 1645, 6, 0, 0, 1, 19865), +(465, 8766, 7, 0, 0, 1, 19865), +(465, 2723, 8, 0, 0, 1, 19865), +(465, 2593, 9, 0, 0, 1, 19865), +(465, 2596, 10, 0, 0, 1, 19865), +(465, 2594, 11, 0, 0, 1, 19865), +(465, 2595, 12, 0, 0, 1, 19865), +(465, 83095, 13, 0, 0, 1, 19865), +(465, 82343, 14, 0, 0, 1, 19865), +(465, 83094, 15, 0, 0, 1, 19865), +(465, 82344, 16, 0, 0, 1, 19865), +(465, 2070, 17, 0, 0, 1, 19865), +(465, 414, 18, 0, 0, 1, 19865), +(465, 422, 19, 0, 0, 1, 19865), +(465, 1707, 20, 0, 0, 1, 19865), +(465, 3927, 21, 0, 0, 1, 19865), +(465, 8932, 22, 0, 0, 1, 19865), +-- 66 (Tharynn Bouden) +(66, 7005, 1, 0, 0, 1, 19865), +(66, 2901, 2, 0, 0, 1, 19865), +(66, 85663, 3, 0, 0, 1, 19865), +(66, 5956, 4, 0, 0, 1, 19865), +(66, 6256, 5, 0, 0, 1, 19865), +(66, 6217, 6, 0, 0, 1, 19865), +(66, 2678, 7, 0, 0, 1, 19865), +(66, 30817, 8, 0, 0, 1, 19865), +(66, 2320, 9, 0, 0, 1, 19865), +(66, 2880, 10, 0, 0, 1, 19865), +(66, 3371, 11, 0, 0, 1, 19865), +(66, 4289, 12, 0, 0, 1, 19865), +(66, 6529, 13, 0, 0, 1, 19865), +(66, 2604, 14, 0, 0, 1, 19865), +(66, 2324, 15, 0, 0, 1, 19865), +(66, 6260, 16, 0, 0, 1, 19865), +(66, 39354, 17, 0, 0, 1, 19865), +(66, 20815, 18, 0, 0, 1, 19865), +(66, 39505, 19, 0, 0, 1, 19865), +(66, 6325, 20, 0, 0, 1, 19865), +(66, 6328, 21, 0, 0, 1, 19865), +(66, 6270, 184, 1, 0, 1, 19865); + +UPDATE `npc_vendor` SET `incrtime`=9000 WHERE `item`=6270; +UPDATE `npc_vendor` SET `incrtime`=7200 WHERE `item`=6272; +UPDATE `npc_vendor` SET `incrtime`=9000 WHERE `entry`=958 AND `item` IN (2455, 3013, 1181, 955, 1180, 954, 858, 3012); |