PvP rewards vendors. Season 6

-- 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 vendorsUPDATE `creature_template` SET `npcflag`=128 WHERE entry IN(34073, 34036, 34058, 34076, 34061, 34082);-- Delete old 3.0 arena vendor Zom Bocom, DalaranDELETE FROM `creature` WHERE id=31865;-- Spawn new 3.1 arena vendor Zom Bocom, DalaranDELETE 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 requiredREPLACE 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.0DELETE FROM `creature` WHERE id=32832;-- spawn 3.1 version of that vendorDELETE 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 versionDELETE 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.0DELETE FROM `creature` WHERE id=32381;-- spawn 3.1 version of that vendorDELETE 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.0DELETE FROM `creature` WHERE id=32383;-- spawn 3.1 version of that vendorDELETE 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 npcDELETE FROM `creature` WHERE id=31864;-- spawn 3.1 version of that vendorDELETE 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 npcDELETE FROM `creature` WHERE id=32385;-- spawn 3.1 version of that vendorDELETE 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 npcDELETE FROM `creature` WHERE id=32380;-- spawn 3.1 version of that vendorDELETE 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 requiredREPLACE 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 2350REPLACE 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