-- Arena vendors fix starts here
-- this will fix PvP rewards vendors in SW, Org and Dalaran to correctly sell Season 6 arena items

-- flag some creatures as vendors
UPDATE `creature_template` SET `npcflag`=128 WHERE entry IN(34073, 34036, 34058, 34076, 34061, 34082);

-- Delete old 3.0 arena vendor Zom Bocom, Dalaran
DELETE FROM `creature` WHERE id=31865;
-- Spawn new 3.1 arena vendor Zom Bocom, Dalaran
DELETE FROM `creature` WHERE id=33923;
INSERT INTO `creature`  (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(33923, 571, 1, 1, 26465, 0, 5761.27, 579.184, 615.052, 1.91986, 300, 0, 0, 8025, 0, 0, 0);
-- Add Sell items to this guy :D Sells Hateful item sets and commendation of bravery for Honor and AP, no rating required
REPLACE INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(33923,41085,0,0,2440),
(33923,41155,0,0,2440),
(33923,41203,0,0,2440),
(33923,41676,0,0,2440),
(33923,41665,0,0,2440),
(33923,41659,0,0,2440),
(33923,40781,0,0,2440),
(33923,40820,0,0,2440),
(33923,40841,0,0,2440),
(33923,41991,0,0,2440),
(33923,42001,0,0,2440),
(33923,42003,0,0,2440),
(33923,41319,0,0,2440),
(33923,41296,0,0,2440),
(33923,41308,0,0,2440),
(33923,41670,0,0,2440),
(33923,41653,0,0,2440),
(33923,41648,0,0,2440),
(33923,41079,0,0,2440),
(33923,41149,0,0,2440),
(33923,41162,0,0,2440),
(33923,40989,0,0,2440),
(33923,41017,0,0,2440),
(33923,41031,0,0,2440),
(33923,41852,0,0,2440),
(33923,41862,0,0,2440),
(33923,41857,0,0,2440),
(33923,40904,0,0,2440),
(33923,40931,0,0,2440),
(33923,40937,0,0,2440),
(33923,40783,0,0,2440),
(33923,40819,0,0,2440),
(33923,40840,0,0,2440),
(33923,40988,0,0,2440),
(33923,41011,0,0,2440),
(33923,41025,0,0,2440),
(33923,41913,0,0,2440),
(33923,41925,0,0,2440),
(33923,41919,0,0,2440),
(33923,40782,0,0,2440),
(33923,40821,0,0,2440),
(33923,40842,0,0,2440),
(33923,41944,0,0,2440),
(33923,41950,0,0,2440),
(33923,41957,0,0,2440),
(33923,41325,0,0,2440),
(33923,41302,0,0,2440),
(33923,41314,0,0,2440),
(33923,41215,0,0,2445),
(33923,41713,0,0,2445),
(33923,40860,0,0,2445),
(33923,42009,0,0,2445),
(33923,41273,0,0,2445),
(33923,41681,0,0,2445),
(33923,41209,0,0,2445),
(33923,41042,0,0,2445),
(33923,41867,0,0,2445),
(33923,40961,0,0,2445),
(33923,40859,0,0,2445),
(33923,41036,0,0,2445),
(33923,41931,0,0,2445),
(33923,40861,0,0,2445),
(33923,41963,0,0,2445),
(33923,41279,0,0,2445),
(33923,41141,0,0,2443),
(33923,41771,0,0,2443),
(33923,40803,0,0,2443),
(33923,42015,0,0,2443),
(33923,41284,0,0,2443),
(33923,41765,0,0,2443),
(33923,41135,0,0,2443),
(33923,41005,0,0,2443),
(33923,41872,0,0,2443),
(33923,40925,0,0,2443),
(33923,40801,0,0,2443),
(33923,40999,0,0,2443),
(33923,41938,0,0,2443),
(33923,40802,0,0,2443),
(33923,41969,0,0,2443),
(33923,41291,0,0,2443),
(33923,45706,0,0,2596);
-- end

-- delete honor points vendor in Orgrimmar 3.0
DELETE FROM `creature` WHERE id=32832;
-- spawn 3.1 version of that vendor
DELETE FROM `creature` WHERE id=34061;
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(34061, 1, 1, 1, 0, 0, 1660.45, -4192.31, 56.1557, 4.33458, 300, 0, 0, 1, 0, 0, 0);
-- add sellitems for this guy. he sells hateful sets for honor points (no AP)
REPLACE INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(34061,41085,0,0,2559),
(34061,41155,0,0,2559),
(34061,41203,0,0,2559),
(34061,41676,0,0,2559),
(34061,41665,0,0,2559),
(34061,41659,0,0,2559),
(34061,40781,0,0,2559),
(34061,40820,0,0,2559),
(34061,40841,0,0,2559),
(34061,41991,0,0,2559),
(34061,42001,0,0,2559),
(34061,42003,0,0,2559),
(34061,41319,0,0,2559),
(34061,41296,0,0,2559),
(34061,41308,0,0,2559),
(34061,41670,0,0,2559),
(34061,41653,0,0,2559),
(34061,41648,0,0,2559),
(34061,41079,0,0,2559),
(34061,41149,0,0,2559),
(34061,41162,0,0,2559),
(34061,40989,0,0,2559),
(34061,41017,0,0,2559),
(34061,41031,0,0,2559),
(34061,41852,0,0,2559),
(34061,41862,0,0,2559),
(34061,41857,0,0,2559),
(34061,40904,0,0,2559),
(34061,40931,0,0,2559),
(34061,40937,0,0,2559),
(34061,40783,0,0,2559),
(34061,40819,0,0,2559),
(34061,40840,0,0,2559),
(34061,40988,0,0,2559),
(34061,41011,0,0,2559),
(34061,41025,0,0,2559),
(34061,41913,0,0,2559),
(34061,41925,0,0,2559),
(34061,41919,0,0,2559),
(34061,40782,0,0,2559),
(34061,40821,0,0,2559),
(34061,40842,0,0,2559),
(34061,41944,0,0,2559),
(34061,41950,0,0,2559),
(34061,41957,0,0,2559),
(34061,41325,0,0,2559),
(34061,41302,0,0,2559),
(34061,41314,0,0,2559),
(34061,41215,0,0,2560),
(34061,41713,0,0,2560),
(34061,40860,0,0,2560),
(34061,42009,0,0,2560),
(34061,41273,0,0,2560),
(34061,41681,0,0,2560),
(34061,41209,0,0,2560),
(34061,41042,0,0,2560),
(34061,41867,0,0,2560),
(34061,40961,0,0,2560),
(34061,40859,0,0,2560),
(34061,41036,0,0,2560),
(34061,41931,0,0,2560),
(34061,40861,0,0,2560),
(34061,41963,0,0,2560),
(34061,41279,0,0,2560),
(34061,41141,0,0,2560),
(34061,41771,0,0,2560),
(34061,40803,0,0,2560),
(34061,42015,0,0,2560),
(34061,41284,0,0,2560),
(34061,41765,0,0,2560),
(34061,41135,0,0,2560),
(34061,41005,0,0,2560),
(34061,41872,0,0,2560),
(34061,40925,0,0,2560),
(34061,40801,0,0,2560),
(34061,40999,0,0,2560),
(34061,41938,0,0,2560),
(34061,40802,0,0,2560),
(34061,41969,0,0,2560),
(34061,41291,0,0,2560);
-- end

-- same thing as above, alliance version
DELETE FROM `creature` WHERE id=32834;
DELETE FROM `creature` WHERE id=34082;
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(34082, 0, 1, 1, 28301, 0, -8784.57, 417.977, 105.316, 0.645772, 180, 0, 0, 11828, 0, 0, 0);
-- add sellitems for this guy. he sells hateful sets for honor points (no AP)
REPLACE INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(34082,41085,0,0,2559),
(34082,41155,0,0,2559),
(34082,41203,0,0,2559),
(34082,41676,0,0,2559),
(34082,41665,0,0,2559),
(34082,41659,0,0,2559),
(34082,40781,0,0,2559),
(34082,40820,0,0,2559),
(34082,40841,0,0,2559),
(34082,41991,0,0,2559),
(34082,42001,0,0,2559),
(34082,42003,0,0,2559),
(34082,41319,0,0,2559),
(34082,41296,0,0,2559),
(34082,41308,0,0,2559),
(34082,41670,0,0,2559),
(34082,41653,0,0,2559),
(34082,41648,0,0,2559),
(34082,41079,0,0,2559),
(34082,41149,0,0,2559),
(34082,41162,0,0,2559),
(34082,40989,0,0,2559),
(34082,41017,0,0,2559),
(34082,41031,0,0,2559),
(34082,41852,0,0,2559),
(34082,41862,0,0,2559),
(34082,41857,0,0,2559),
(34082,40904,0,0,2559),
(34082,40931,0,0,2559),
(34082,40937,0,0,2559),
(34082,40783,0,0,2559),
(34082,40819,0,0,2559),
(34082,40840,0,0,2559),
(34082,40988,0,0,2559),
(34082,41011,0,0,2559),
(34082,41025,0,0,2559),
(34082,41913,0,0,2559),
(34082,41925,0,0,2559),
(34082,41919,0,0,2559),
(34082,40782,0,0,2559),
(34082,40821,0,0,2559),
(34082,40842,0,0,2559),
(34082,41944,0,0,2559),
(34082,41950,0,0,2559),
(34082,41957,0,0,2559),
(34082,41325,0,0,2559),
(34082,41302,0,0,2559),
(34082,41314,0,0,2559),
(34082,41215,0,0,2560),
(34082,41713,0,0,2560),
(34082,40860,0,0,2560),
(34082,42009,0,0,2560),
(34082,41273,0,0,2560),
(34082,41681,0,0,2560),
(34082,41209,0,0,2560),
(34082,41042,0,0,2560),
(34082,41867,0,0,2560),
(34082,40961,0,0,2560),
(34082,40859,0,0,2560),
(34082,41036,0,0,2560),
(34082,41931,0,0,2560),
(34082,40861,0,0,2560),
(34082,41963,0,0,2560),
(34082,41279,0,0,2560),
(34082,41141,0,0,2560),
(34082,41771,0,0,2560),
(34082,40803,0,0,2560),
(34082,42015,0,0,2560),
(34082,41284,0,0,2560),
(34082,41765,0,0,2560),
(34082,41135,0,0,2560),
(34082,41005,0,0,2560),
(34082,41872,0,0,2560),
(34082,40925,0,0,2560),
(34082,40801,0,0,2560),
(34082,40999,0,0,2560),
(34082,41938,0,0,2560),
(34082,40802,0,0,2560),
(34082,41969,0,0,2560),
(34082,41291,0,0,2560);
-- end

-- delete honor points vendor in Stormwind 3.0
DELETE FROM `creature` WHERE id=32381;
-- spawn 3.1 version of that vendor
DELETE FROM `creature` WHERE id=34073;
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(34073, 0, 1, 1, 12917, 0, -8788.36, 425.628, 105.316, 6.12611, 180, 0, 0, 11828, 0, 0, 0);

-- add sellitems for this guy. he sells Hateful rings, Deadly non-set items, and trinket for honor points (no AP)
REPLACE INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(34073,42129,0,0,2559),
(34073,42130,0,0,2559),
(34073,42132,0,0,2559),
(34073,42131,0,0,2559),
(34073,42128,0,0,2559),
(34073,41629,0,0,2559),
(34073,41616,0,0,2559),
(34073,41831,0,0,2559),
(34073,41634,0,0,2559),
(34073,41620,0,0,2559),
(34073,41835,0,0,2559),
(34073,41897,0,0,2559),
(34073,41880,0,0,2559),
(34073,40974,0,0,2559),
(34073,40879,0,0,2559),
(34073,40975,0,0,2559),
(34073,40880,0,0,2559),
(34073,41074,0,0,2559),
(34073,41054,0,0,2559),
(34073,41229,0,0,2559),
(34073,41902,0,0,2559),
(34073,41884,0,0,2559),
(34073,41069,0,0,2559),
(34073,41048,0,0,2559),
(34073,41234,0,0,2559),
(34073,42114,0,0,2561),
(34073,42115,0,0,2561),
(34073,42064,0,0,2561),
(34073,42066,0,0,2561),
(34073,42062,0,0,2561),
(34073,42065,0,0,2561),
(34073,42063,0,0,2561),
(34073,42067,0,0,2561),
(34073,42068,0,0,2561),
(34073,42030,0,0,2561),
(34073,42032,0,0,2561),
(34073,42029,0,0,2561),
(34073,42033,0,0,2561),
(34073,42031,0,0,2561),
(34073,42027,0,0,2561),
(34073,42028,0,0,2561),
(34073,41639,0,0,2560),
(34073,41059,0,0,2560),
(34073,41624,0,0,2560),
(34073,41839,0,0,2560),
(34073,40982,0,0,2560),
(34073,40888,0,0,2560),
(34073,41908,0,0,2560),
(34073,41892,0,0,2560),
(34073,41064,0,0,2560),
(34073,41224,0,0,2560),
(34073,42110,0,0,2605),
(34073,42112,0,0,2605),
(34073,42123,0,0,2605);
-- end ally honor vendor2

-- delete honor points vendor in Orgri 3.0
DELETE FROM `creature` WHERE id=32383;
-- spawn 3.1 version of that vendor
DELETE FROM `creature` WHERE id=34036;
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(34036, 1, 1, 1, 0, 0, 1671.19, -4201.64, 56.1558, 3.55233, 300, 0, 0, 1, 0, 0, 0);

-- add sellitems for this guy. he sells Hateful rings, Deadly non-set items, and trinket for honor points (no AP)
REPLACE INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(34036,42129,0,0,2559),
(34036,42130,0,0,2559),
(34036,42132,0,0,2559),
(34036,42131,0,0,2559),
(34036,42128,0,0,2559),
(34036,41629,0,0,2559),
(34036,41616,0,0,2559),
(34036,41831,0,0,2559),
(34036,41634,0,0,2559),
(34036,41620,0,0,2559),
(34036,41835,0,0,2559),
(34036,41897,0,0,2559),
(34036,41880,0,0,2559),
(34036,40974,0,0,2559),
(34036,40879,0,0,2559),
(34036,40975,0,0,2559),
(34036,40880,0,0,2559),
(34036,41074,0,0,2559),
(34036,41054,0,0,2559),
(34036,41229,0,0,2559),
(34036,41902,0,0,2559),
(34036,41884,0,0,2559),
(34036,41069,0,0,2559),
(34036,41048,0,0,2559),
(34036,41234,0,0,2559),
(34036,42114,0,0,2561),
(34036,42115,0,0,2561),
(34036,42064,0,0,2561),
(34036,42066,0,0,2561),
(34036,42062,0,0,2561),
(34036,42065,0,0,2561),
(34036,42063,0,0,2561),
(34036,42067,0,0,2561),
(34036,42068,0,0,2561),
(34036,42030,0,0,2561),
(34036,42032,0,0,2561),
(34036,42029,0,0,2561),
(34036,42033,0,0,2561),
(34036,42031,0,0,2561),
(34036,42027,0,0,2561),
(34036,42028,0,0,2561),
(34036,41639,0,0,2560),
(34036,41624,0,0,2560),
(34036,41839,0,0,2560),
(34036,40982,0,0,2560),
(34036,41059,0,0,2560),
(34036,40888,0,0,2560),
(34036,41908,0,0,2560),
(34036,41892,0,0,2560),
(34036,41064,0,0,2560),
(34036,41224,0,0,2560),
(34036,42110,0,0,2605),
(34036,42112,0,0,2605),
(34036,42122,0,0,2605);
-- end Horde honor vendor2

-- Dalaran Arena vendor2.
-- delete 3.0 version of this npc
DELETE FROM `creature` WHERE id=31864;
-- spawn 3.1 version of that vendor
DELETE FROM `creature` WHERE id=33922;
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(33922, 571, 1, 1, 26464, 0, 5753.53, 585.632, 615.052, 0.139626, 300, 0, 0, 8025, 0, 0, 0);
-- Add sellitems for this guy. Sells Deadly gear for honor AP and requires rating.
REPLACE INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(33922,42588,0,0,2608),
(33922,42583,0,0,2608),
(33922,42578,0,0,2608),
(33922,42852,0,0,2608),
(33922,42614,0,0,2608),
(33922,42620,0,0,2608),
(33922,42607,0,0,2608),
(33922,42602,0,0,2608),
(33922,42597,0,0,2608),
(33922,41142,0,0,2609),
(33922,41772,0,0,2609),
(33922,40806,0,0,2609),
(33922,42016,0,0,2609),
(33922,41286,0,0,2609),
(33922,41766,0,0,2609),
(33922,41136,0,0,2609),
(33922,41006,0,0,2609),
(33922,41873,0,0,2609),
(33922,40926,0,0,2609),
(33922,40804,0,0,2609),
(33922,41000,0,0,2609),
(33922,41939,0,0,2609),
(33922,40805,0,0,2609),
(33922,41970,0,0,2609),
(33922,41292,0,0,2609),
(33922,41204,0,0,2610),
(33922,41666,0,0,2610),
(33922,40845,0,0,2610),
(33922,42004,0,0,2610),
(33922,41297,0,0,2610),
(33922,41654,0,0,2610),
(33922,41198,0,0,2610),
(33922,41032,0,0,2610),
(33922,41863,0,0,2610),
(33922,40938,0,0,2610),
(33922,40844,0,0,2610),
(33922,41026,0,0,2610),
(33922,41926,0,0,2610),
(33922,40846,0,0,2610),
(33922,41958,0,0,2610),
(33922,41303,0,0,2610),
(33922,41086,0,0,2611),
(33922,41660,0,0,2611),
(33922,40784,0,0,2611),
(33922,41997,0,0,2611),
(33922,41309,0,0,2611),
(33922,41649,0,0,2611),
(33922,41080,0,0,2611),
(33922,40991,0,0,2611),
(33922,41850,0,0,2611),
(33922,40905,0,0,2611),
(33922,40786,0,0,2611),
(33922,40990,0,0,2611),
(33922,41920,0,0,2611),
(33922,40785,0,0,2611),
(33922,41951,0,0,2611),
(33922,41315,0,0,2611),
(33922,41156,0,0,2612),
(33922,41677,0,0,2612),
(33922,40824,0,0,2612),
(33922,41992,0,0,2612),
(33922,41320,0,0,2612),
(33922,41671,0,0,2612),
(33922,41150,0,0,2612),
(33922,41018,0,0,2612),
(33922,41853,0,0,2612),
(33922,40932,0,0,2612),
(33922,40823,0,0,2612),
(33922,41012,0,0,2612),
(33922,41914,0,0,2612),
(33922,40825,0,0,2612),
(33922,41945,0,0,2612),
(33922,41326,0,0,2612),
(33922,41216,0,0,2613),
(33922,41714,0,0,2613),
(33922,40863,0,0,2613),
(33922,42010,0,0,2613),
(33922,41274,0,0,2613),
(33922,41682,0,0,2613),
(33922,41210,0,0,2613),
(33922,41043,0,0,2613),
(33922,41868,0,0,2613),
(33922,40962,0,0,2613),
(33922,40862,0,0,2613),
(33922,41037,0,0,2613),
(33922,41933,0,0,2613),
(33922,40864,0,0,2613),
(33922,41964,0,0,2613),
(33922,41280,0,0,2613),
(33922,45706,0,0,2596);
-- end dalaran vendor2


-- Orgrimmar vendor3.
-- delete 3.0 version of this npc
DELETE FROM `creature` WHERE id=32385;
-- spawn 3.1 version of that vendor
DELETE FROM `creature` WHERE id=34058;
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(34058, 1, 1, 1, 0, 0, 1644.16, -4195.4, 56.1549, 5.44986, 300, 0, 0, 1, 0, 0, 0);
-- Add sellitems for this gal. Sells furious nonset gear for honor and requires rating.
REPLACE INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(34058,41640,0,0,2614),
(34058,41625,0,0,2614),
(34058,41840,0,0,2614),
(34058,40983,0,0,2614),
(34058,40889,0,0,2614),
(34058,41909,0,0,2614),
(34058,41893,0,0,2614),
(34058,41065,0,0,2614),
(34058,41060,0,0,2614),
(34058,41225,0,0,2614),
(34058,41630,0,0,2615),
(34058,41617,0,0,2615),
(34058,41832,0,0,2615),
(34058,41898,0,0,2615),
(34058,41881,0,0,2615),
(34058,40976,0,0,2615),
(34058,40881,0,0,2615),
(34058,41070,0,0,2615),
(34058,41051,0,0,2615),
(34058,41235,0,0,2615),
(34058,41635,0,0,2616),
(34058,41621,0,0,2616),
(34058,41836,0,0,2616),
(34058,40977,0,0,2616),
(34058,40882,0,0,2616),
(34058,41075,0,0,2616),
(34058,41055,0,0,2616),
(34058,41230,0,0,2616),
(34058,41903,0,0,2616),
(34058,41885,0,0,2616),
(34058,42037,0,0,2617),
(34058,42039,0,0,2617),
(34058,42036,0,0,2617),
(34058,42040,0,0,2617),
(34058,42038,0,0,2617),
(34058,46373,0,0,2617),
(34058,42034,0,0,2617),
(34058,42035,0,0,2617),
(34058,42116,0,0,2618),
(34058,42117,0,0,2618),
(34058,42071,0,0,2619),
(34058,42073,0,0,2619),
(34058,42069,0,0,2619),
(34058,42072,0,0,2619),
(34058,42070,0,0,2619),
(34058,42074,0,0,2619),
(34058,42075,0,0,2619),
(34058,42126,0,0,2568);
-- end horde vendor3

-- SW vendor3.
-- delete 3.0 version of this npc
DELETE FROM `creature` WHERE id=32380;
-- spawn 3.1 version of that vendor
DELETE FROM `creature` WHERE id=34076;
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(34076, 0, 1, 1, 21512, 0, -8779.48, 432.525, 105.316, 4.5204, 180, 0, 0, 7048, 0, 0, 0);

-- Add sellitems for this gal. Sells furious nonset gear for honor and requires rating.
REPLACE INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(34076,41640,0,0,2614),
(34076,41625,0,0,2614),
(34076,41840,0,0,2614),
(34076,40983,0,0,2614),
(34076,40889,0,0,2614),
(34076,41909,0,0,2614),
(34076,41893,0,0,2614),
(34076,41065,0,0,2614),
(34076,41060,0,0,2614),
(34076,41225,0,0,2614),
(34076,41630,0,0,2615),
(34076,41617,0,0,2615),
(34076,41832,0,0,2615),
(34076,41898,0,0,2615),
(34076,41881,0,0,2615),
(34076,40976,0,0,2615),
(34076,40881,0,0,2615),
(34076,41070,0,0,2615),
(34076,41051,0,0,2615),
(34076,41235,0,0,2615),
(34076,41635,0,0,2616),
(34076,41621,0,0,2616),
(34076,41836,0,0,2616),
(34076,40977,0,0,2616),
(34076,40882,0,0,2616),
(34076,41075,0,0,2616),
(34076,41055,0,0,2616),
(34076,41230,0,0,2616),
(34076,41903,0,0,2616),
(34076,41885,0,0,2616),
(34076,42037,0,0,2617),
(34076,42039,0,0,2617),
(34076,42036,0,0,2617),
(34076,42040,0,0,2617),
(34076,42038,0,0,2617),
(34076,46373,0,0,2617),
(34076,42034,0,0,2617),
(34076,42035,0,0,2617),
(34076,42116,0,0,2618),
(34076,42117,0,0,2618),
(34076,42071,0,0,2619),
(34076,42073,0,0,2619),
(34076,42069,0,0,2619),
(34076,42072,0,0,2619),
(34076,42070,0,0,2619),
(34076,42074,0,0,2619),
(34076,42075,0,0,2619),
(34076,42124,0,0,2568);
-- end ally vendor3

-- the preultimate dalaran vendor3 :D
-- Delete old 3.0 arena vendor 
DELETE FROM `creature` WHERE id=31863;
-- Spawn new 3.1 arena vendor 
DELETE FROM `creature` WHERE id=33921;
INSERT INTO `creature`  (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(33921, 571, 1, 1, 26463, 0, 5751.82, 583.454, 615.052, 6.14356, 300, 0, 0, 8025, 0, 0, 0);

-- Add Sell items to this guy :D Sells Furious item sets, weapons etc. for Honor and AP, BIG rating required
REPLACE INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(33921,41143,0,0,2621),
(33921,41773,0,0,2621),
(33921,40809,0,0,2621),
(33921,42017,0,0,2621),
(33921,41287,0,0,2621),
(33921,41767,0,0,2621),
(33921,41137,0,0,2621),
(33921,41007,0,0,2621),
(33921,41874,0,0,2621),
(33921,40972,0,0,2621),
(33921,40807,0,0,2621),
(33921,41001,0,0,2621),
(33921,41940,0,0,2621),
(33921,40808,0,0,2621),
(33921,41971,0,0,2621),
(33921,41293,0,0,2621),
(33921,41205,0,0,2340),
(33921,41667,0,0,2340),
(33921,40848,0,0,2340),
(33921,42005,0,0,2340),
(33921,41298,0,0,2340),
(33921,41655,0,0,2340),
(33921,41199,0,0,2340),
(33921,41033,0,0,2340),
(33921,41864,0,0,2340),
(33921,40939,0,0,2340),
(33921,40847,0,0,2340),
(33921,41027,0,0,2340),
(33921,41927,0,0,2340),
(33921,40849,0,0,2340),
(33921,41959,0,0,2340),
(33921,41304,0,0,2340),
(33921,41087,0,0,2622),
(33921,41661,0,0,2622),
(33921,40787,0,0,2622),
(33921,41998,0,0,2622),
(33921,41310,0,0,2622),
(33921,41650,0,0,2622),
(33921,41081,0,0,2622),
(33921,40993,0,0,2622),
(33921,41859,0,0,2622),
(33921,40907,0,0,2622),
(33921,40789,0,0,2622),
(33921,40992,0,0,2622),
(33921,41921,0,0,2622),
(33921,40788,0,0,2622),
(33921,41953,0,0,2622),
(33921,41316,0,0,2622),
(33921,42364,0,0,2623),
(33921,42323,0,0,2623),
(33921,42318,0,0,2623),
(33921,42385,0,0,2623),
(33921,44422,0,0,2623),
(33921,42333,0,0,2623),
(33921,42496,0,0,2623),
(33921,42491,0,0,2623),
(33921,42328,0,0,2623),
(33921,42486,0,0,2623),
(33921,42391,0,0,2623),
(33921,44421,0,0,2623),
(33921,42209,0,0,2624),
(33921,42353,0,0,2624),
(33921,42276,0,0,2624),
(33921,42261,0,0,2624),
(33921,42243,0,0,2624),
(33921,42286,0,0,2624),
(33921,42347,0,0,2624),
(33921,42565,0,0,2628),
(33921,42571,0,0,2628),
(33921,42560,0,0,2628),
(33921,41157,0,0,2629),
(33921,41678,0,0,2629),
(33921,40827,0,0,2629),
(33921,41993,0,0,2629),
(33921,41321,0,0,2629),
(33921,41672,0,0,2629),
(33921,41151,0,0,2629),
(33921,41019,0,0,2629),
(33921,41854,0,0,2629),
(33921,40933,0,0,2629),
(33921,40826,0,0,2629),
(33921,41013,0,0,2629),
(33921,41915,0,0,2629),
(33921,40828,0,0,2629),
(33921,41946,0,0,2629),
(33921,41327,0,0,2629),
(33921,42514,0,0,2384),
(33921,42589,0,0,2384),
(33921,42584,0,0,2384),
(33921,42579,0,0,2384),
(33921,42853,0,0,2384),
(33921,42615,0,0,2384),
(33921,42520,0,0,2384),
(33921,42621,0,0,2384),
(33921,42608,0,0,2384),
(33921,42603,0,0,2384),
(33921,42598,0,0,2384),
(33921,42503,0,0,2384),
(33921,42451,0,0,2384),
(33921,41217,0,0,2470),
(33921,41715,0,0,2470),
(33921,40868,0,0,2470),
(33921,42011,0,0,2470),
(33921,41275,0,0,2470),
(33921,41683,0,0,2470),
(33921,41211,0,0,2470),
(33921,41044,0,0,2470),
(33921,41869,0,0,2470),
(33921,40963,0,0,2470),
(33921,40866,0,0,2470),
(33921,41038,0,0,2470),
(33921,41934,0,0,2470),
(33921,40869,0,0,2470),
(33921,41965,0,0,2470),
(33921,41281,0,0,2470),
(33921,45706,0,0,2596);
-- dalaran vendor3 ends here

-- ultimate dalaran vendor4
-- despawn the vendor who's there atm (water vendor)
DELETE FROM `creature` WHERE id=30885;
-- Spawn new 3.1 arena items vendor 
DELETE FROM `creature` WHERE id=34087;
INSERT INTO `creature`  (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(34087, 571, 1, 1, 29076, 657 , 5759.52, 577.122, 615.052, 2.19912, 300, 0, 0, 6986, 0, 0, 0);
-- Add Sell items to this guy :D Sells Furious weapons for  AP, Ridiculus BIG rating required 2350
REPLACE INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(34087,45961,0,0,2635),
(34087,45962,0,0,2635),
(34087,45967,0,0,2635),
(34087,45968,0,0,2635),
(34087,45963,0,0,2635),
(34087,45964,0,0,2635),
(34087,45966,0,0,2635),
(34087,45965,0,0,2635),
(34087,45969,0,0,2634),
(34087,45957,0,0,2634),
(34087,45960,0,0,2634),
(34087,45958,0,0,2634),
(34087,45959,0,0,2634),
(34087,45970,0,0,2633),
(34087,45971,0,0,2633),
(34087,45954,0,0,2632),
(34087,45950,0,0,2632),
(34087,45953,0,0,2632),
(34087,45949,0,0,2632),
(34087,45952,0,0,2632),
(34087,45951,0,0,2632),
(34087,45956,0,0,2632),
(34087,45938,0,0,2632),
(34087,45030,0,0,2632),
(34087,45937,0,0,2632),
(34087,45955,0,0,2632),
(34087,45948,0,0,2632);
-- end