Jump to content

  • Announcements

    • Xmat

      Pravidlo pro postování v TTT

      Do sekce Tipy, triky, tutoriály nepatří žádné dotazy.   Postujte sem vaše návody, tipy a různé další věci jež uznáte za vhodné sdělit zdejšímu osazenstvu, ale veškeré dotazy směřujte do sekce Všeobecná diskuse.
    • Replik

      Seznam návodů a důležitých témat v této sekci

      Pro lepší přehlednost jsem vytvořil tento seznam, který vás, méně zkušené, lépe provede touto sekcí. Věřím, že zde najdete, co hledáte. Vypsané jsou návody, které jsou oficiálně uznané jako návody. Běžné diskuze, které neposkytují postupy a rady zvěřejněny nejsou.   Instalace vlastního MaNGOS Serveru Díky těmto návodům budete (měli by jste být) schopni vytvořit a následně spustit váš vlastní server. Nastavení je pro verze s i bez datadisku.   Instalace MaNGOS Serveru (bez datadisku TBC) - Autor Benny Instalace MaNGOS Serveru (s datadiskem TBC) - Autor Malfik Instalace MaNGOS Serveru v prostředí Linux - Autor charlie Instalace MaNGOS Serveru v prostředí Linux - Autor kupkoid   Chyby a jejich řešení při přihlašování k serveru - Autor Cybe   Zálohování uživatelských dat   Dávkový soubor (BAT soubor) pro vytvoření SQL záloh - Autor Replik   Kompilování - tvoření vlastních release (revizí)   Tvorba kompilací pro Win32 (MangoScript) - Autor bLuma   Ostatní - těžko zařaditelné, ale neznamená to, že nejsou dobré   VIP Systém - Autor charlie Tvorba Webových stránek pro MaNGOS - Autor zahuba Tvorba teleportačních NPC (MangoScript) - Autor Replik Registrační web (původně předělaná SPORA) Funkční pro Antrix i MaNGOS - Autor Replik Nastavení a spuštění Minimanager pro MaNGOS - Autor BlackMartin Nastavení MaNGOS Website - Autor Artorius   Samozřejmě jsou zde i jiné návody, ale tyto jsou nejvíce používané, proto věřím, že vám budou nápomocné. Tuto sekci budeme upravovat podle potřeby. Pokud by jste něco nenašli nebo si nevěděli rady, hledejte na fóru a teprve potom založte vlastní topik. Pokud nějaký autor vytvoří kvalitní návod a chtěl by ho zveřejnit i v tomto seznamu, doporučuji, aby mi napsal zprávu skrze PM.   Díky a přeji hezký den na WoWResource   Replik
    • Aristo

      Příspěvky tam, kde nemají co dělat

      Dodržujte zákaz přispívání do topiků s repaky pokud si to zakladatelé nepřejí!! Opakované psaní příspěvků bude trestáno warnem.
    • Aristo

      Používání spoilerů

      Poslední dobou má většina uživatelů fora zvláštní nutkání postovat extrémně dlouhé texty nebo kódy, které zabírají v nejedenom případu i 80% obsahu celé stránky a hodně tak zvedají nepřehlednost v topiku. Chtěl bych všechny uživatele požádat, aby při postování citací, jakýchkoliv kódů, errorů, atp... delších než 30 řádků používali funkci spoileru.   Funkci vyvoláte příkazem [spoiler] text [/spoiler]   Ukázka:  
Sign in to follow this  
Followers 0
ZechY

Relentless

By ZechY, in Opravy

Recommended Posts

ZechY    253

ZechY
Posted (edited)

Chybí vám na serveru Relentless itemy u vendoru? Mě chyběli a tak jsem brouzdal a narazil na tohle:

 

Shoulders

 

-- Clean up before Insert
DELETE FROM `npc_vendor` WHERE `item` IN (42012,41966,41935,41870,41716,41276,41282,41684,41218,41212,41045,41039,40871,40964,40872,40870);

-- Insert Shoulders to Argex Irongut <Veteran Arena Vendor> with proper Extended Cost
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
-- Warlock
(33924,42012,0,0,2692),
-- Mage
(33924,41966,0,0,2692),
-- Priest
(33924,41935,0,0,2692),
(33924,41870,0,0,2692),
-- Druid
(33924,41716,0,0,2692),
(33924,41276,0,0,2692),
(33924,41282,0,0,2692),
-- Rogue
(33924,41684,0,0,2692),
-- Hunter
(33924,41218,0,0,2692),
-- Shaman
(33924,41212,0,0,2692),
(33924,41045,0,0,2692),
(33924,41039,0,0,2692),
-- Death Knight
(33924,40871,0,0,2692),
-- Paladin
(33924,40964,0,0,2692),
(33924,40872,0,0,2692),
-- Warrior
(33924,40870,0,0,2692);

-- Insert Shoulders to Kezzik the Striker <Veteran Arena Vendor> with proper Extended Cost
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
-- Warlock
(33931,42012,0,0,2692),
-- Mage
(33931,41966,0,0,2692),
-- Priest
(33931,41935,0,0,2692),
(33931,41870,0,0,2692),
-- Druid
(33931,41716,0,0,2692),
(33931,41276,0,0,2692),
(33931,41282,0,0,2692),
-- Rogue
(33931,41684,0,0,2692),
-- Hunter
(33931,41218,0,0,2692),
-- Shaman
(33931,41212,0,0,2692),
(33931,41045,0,0,2692),
(33931,41039,0,0,2692),
-- Death Knight
(33931,40871,0,0,2692),
-- Paladin
(33931,40964,0,0,2692),
(33931,40872,0,0,2692),
-- Warrior
(33931,40870,0,0,2692);

-- Insert Shoulders to Nargle Lashcord <Veteran Arena Vendor> with proper Extended Cost
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
-- Warlock
(33927,42012,0,0,2692),
-- Mage
(33927,41966,0,0,2692),
-- Priest
(33927,41935,0,0,2692),
(33927,41870,0,0,2692),
-- Druid
(33927,41716,0,0,2692),
(33927,41276,0,0,2692),
(33927,41282,0,0,2692),
-- Rogue
(33927,41684,0,0,2692),
-- Hunter
(33927,41218,0,0,2692),
-- Shaman
(33927,41212,0,0,2692),
(33927,41045,0,0,2692),
(33927,41039,0,0,2692),
-- Death Knight
(33927,40871,0,0,2692),
-- Paladin
(33927,40964,0,0,2692),
(33927,40872,0,0,2692),
-- Warrior
(33927,40870,0,0,2692);

 

Special Weapon`s

-- Trapjaw Rix <Exceptional Arena Weaponry>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 34092;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES

-- Tabard
(34092,49086,0,0,2722),

-- Rating 2200 items (only 3v3 or 5v5)
-- Two hand, Ranged
-- 4250 Arena Points  EC: 2694
(34092,48420,0,0,2694),
(34092,48422,0,0,2694),
(34092,48424,0,0,2694),
(34092,48412,0,0,2694),
(34092,48414,0,0,2694),
(34092,48410,0,0,2694),
(34092,48402,0,0,2694),
(34092,48404,0,0,2694),
(34092,48406,0,0,2694),

-- Main Hand
-- 3585 Arena Points  EC: 2696
(34092,48408,0,0,2696),

-- One Hand
-- 3000 Arena Points  EC: 2697

-- Off Hand
-- 1245 Arena Points  EC: 2699
(34092,48426,0,0,2699),
(34092,48428,0,0,2699),
(34092,48432,0,0,2699);


-- Blazzek the Biter <Exceptional Arena Weaponry>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 34090;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES

-- Tabard
(34090,49086,0,0,2722),

-- Rating 2200 items (only 3v3 or 5v5)
-- Two hand, Ranged
-- 4250 Arena Points  EC: 2694
(34090,48420,0,0,2694),
(34090,48422,0,0,2694),
(34090,48424,0,0,2694),
(34090,48412,0,0,2694),
(34090,48414,0,0,2694),
(34090,48410,0,0,2694),
(34090,48402,0,0,2694),
(34090,48404,0,0,2694),
(34090,48406,0,0,2694),

-- Main Hand
-- 3585 Arena Points  EC: 2696
(34090,48408,0,0,2696),

-- One Hand
-- 3000 Arena Points  EC: 2697

-- Off Hand
-- 1245 Arena Points  EC: 2699
(34090,48426,0,0,2699),
(34090,48428,0,0,2699),
(34090,48432,0,0,2699);


-- Grex Brainboiler <Exceptional Arena Weaponry>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 34091;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES

-- Tabard
(34091,49086,0,0,2722),

-- Rating 2200 items (only 3v3 or 5v5)
-- Two hand, Ranged
-- 4250 Arena Points  EC: 2694
(34091,48420,0,0,2694),
(34091,48422,0,0,2694),
(34091,48424,0,0,2694),
(34091,48412,0,0,2694),
(34091,48414,0,0,2694),
(34091,48410,0,0,2694),
(34091,48402,0,0,2694),
(34091,48404,0,0,2694),
(34091,48406,0,0,2694),

-- Main Hand
-- 3585 Arena Points  EC: 2696
(34091,48408,0,0,2696),

-- One Hand
-- 3000 Arena Points  EC: 2697

-- Off Hand
-- 1245 Arena Points  EC: 2699
(34091,48426,0,0,2699),
(34091,48428,0,0,2699),
(34091,48432,0,0,2699);

 

Mělo by to fungovat na TDB databázi.

 

Převzato z trinitydatabase.org

Edited by ZechY

Share this post

Link to post
Share on other sites

ZechY    253

ZechY
Posted

Tím chybý myslí neprodávaly se ty itemy.

 

 

Samozřejmě, špatně jsem se vyjádřil :)

Share this post

Link to post
Share on other sites

overy    23

overy
Posted (edited)

taky sem pridam neco z trinitydatabase.org

 


-- Evee Copperspring <Arena Vendor>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 33928;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
(33928,45706,0,0,2596),
(33928,41087,0,0,2611),
(33928,41143,0,0,2609),
(33928,41157,0,0,2612),
(33928,41205,0,0,2610),
(33928,41217,0,0,2613),
(33928,42589,0,0,2608),
(33928,42584,0,0,2608),
(33928,42579,0,0,2608),
(33928,42853,0,0,2608),
(33928,42615,0,0,2608),
(33928,40907,0,0,2611),
(33928,40927,0,0,2609),
(33928,40933,0,0,2612),
(33928,40939,0,0,2610),
(33928,40963,0,0,2613),
(33928,40789,0,0,2611),
(33928,40807,0,0,2609),
(33928,40826,0,0,2612),
(33928,40847,0,0,2610),
(33928,40866,0,0,2613),
(33928,40788,0,0,2611),
(33928,40808,0,0,2609),
(33928,40828,0,0,2612),
(33928,40849,0,0,2610),
(33928,40869,0,0,2613),
(33928,42621,0,0,2608),
(33928,42608,0,0,2608),
(33928,42603,0,0,2608),
(33928,42598,0,0,2608);

-- Blood Guard Zar'shi <Northrend Armor Quartermaster>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 34062;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
-- Items sold by 31600 Honor Points
(34062,41142,0,0,2560),
(34062,41216,0,0,2560),
(34062,41772,0,0,2560),
(34062,41714,0,0,2560),
(34062,40806,0,0,2560),
(34062,40863,0,0,2560),
(34062,42010,0,0,2560),
(34062,42016,0,0,2560),
(34062,41286,0,0,2560),
(34062,41274,0,0,2560),
(34062,41766,0,0,2560),
(34062,41682,0,0,2560),
(34062,41136,0,0,2560),
(34062,41210,0,0,2560),
(34062,41006,0,0,2560),
(34062,41043,0,0,2560),
(34062,41873,0,0,2560),
(34062,41868,0,0,2560),
(34062,40926,0,0,2560),
(34062,40962,0,0,2560),
(34062,40804,0,0,2560),
(34062,40862,0,0,2560),
(34062,41000,0,0,2560),
(34062,41037,0,0,2560),
(34062,41939,0,0,2560),
(34062,41933,0,0,2560),
(34062,40805,0,0,2560),
(34062,40864,0,0,2560),
(34062,41964,0,0,2560),
(34062,41970,0,0,2560),
(34062,41292,0,0,2560),
(34062,41280,0,0,2560),
-- Items sold by 49600 Honor Points
(34062,41156,0,0,2559),
(34062,41204,0,0,2559),
(34062,41086,0,0,2559),
(34062,41677,0,0,2559),
(34062,41666,0,0,2559),
(34062,41660,0,0,2559),
(34062,40784,0,0,2559),
(34062,40824,0,0,2559),
(34062,40845,0,0,2559),
(34062,41992,0,0,2559),
(34062,41997,0,0,2559),
(34062,42004,0,0,2559),
(34062,41320,0,0,2559),
(34062,41297,0,0,2559),
(34062,41309,0,0,2559),
(34062,41671,0,0,2559),
(34062,41654,0,0,2559),
(34062,41649,0,0,2559),
(34062,41080,0,0,2559),
(34062,41150,0,0,2559),
(34062,41198,0,0,2559),
(34062,40991,0,0,2559),
(34062,41018,0,0,2559),
(34062,41032,0,0,2559),
(34062,41853,0,0,2559),
(34062,41863,0,0,2559),
(34062,41858,0,0,2559),
(34062,40905,0,0,2559),
(34062,40932,0,0,2559),
(34062,40938,0,0,2559),
(34062,40786,0,0,2559),
(34062,40823,0,0,2559),
(34062,40844,0,0,2559),
(34062,40990,0,0,2559),
(34062,41012,0,0,2559),
(34062,41026,0,0,2559),
(34062,41914,0,0,2559),
(34062,41926,0,0,2559),
(34062,41920,0,0,2559),
(34062,40785,0,0,2559),
(34062,40825,0,0,2559),
(34062,40846,0,0,2559),
(34062,41945,0,0,2559),
(34062,41951,0,0,2559),
(34062,41958,0,0,2559),
(34062,41326,0,0,2559),
(34062,41303,0,0,2559),
(34062,41315,0,0,2559);


-- Knight-Lieutenant Moonstrike <Northrend Armor Quartermaster>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 34083;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
-- Items sold by 31600 Honor Points
(34083,41142,0,0,2560),
(34083,41216,0,0,2560),
(34083,41772,0,0,2560),
(34083,41714,0,0,2560),
(34083,40806,0,0,2560),
(34083,40863,0,0,2560),
(34083,42010,0,0,2560),
(34083,42016,0,0,2560),
(34083,41286,0,0,2560),
(34083,41274,0,0,2560),
(34083,41766,0,0,2560),
(34083,41682,0,0,2560),
(34083,41136,0,0,2560),
(34083,41210,0,0,2560),
(34083,41006,0,0,2560),
(34083,41043,0,0,2560),
(34083,41873,0,0,2560),
(34083,41868,0,0,2560),
(34083,40926,0,0,2560),
(34083,40962,0,0,2560),
(34083,40804,0,0,2560),
(34083,40862,0,0,2560),
(34083,41000,0,0,2560),
(34083,41037,0,0,2560),
(34083,41939,0,0,2560),
(34083,41933,0,0,2560),
(34083,40805,0,0,2560),
(34083,40864,0,0,2560),
(34083,41964,0,0,2560),
(34083,41970,0,0,2560),
(34083,41292,0,0,2560),
(34083,41280,0,0,2560),
-- Items sold by 49600 Honor Points
(34083,41156,0,0,2559),
(34083,41204,0,0,2559),
(34083,41086,0,0,2559),
(34083,41677,0,0,2559),
(34083,41666,0,0,2559),
(34083,41660,0,0,2559),
(34083,40784,0,0,2559),
(34083,40824,0,0,2559),
(34083,40845,0,0,2559),
(34083,41992,0,0,2559),
(34083,41997,0,0,2559),
(34083,42004,0,0,2559),
(34083,41320,0,0,2559),
(34083,41297,0,0,2559),
(34083,41309,0,0,2559),
(34083,41671,0,0,2559),
(34083,41654,0,0,2559),
(34083,41649,0,0,2559),
(34083,41080,0,0,2559),
(34083,41150,0,0,2559),
(34083,41198,0,0,2559),
(34083,40991,0,0,2559),
(34083,41018,0,0,2559),
(34083,41032,0,0,2559),
(34083,41853,0,0,2559),
(34083,41863,0,0,2559),
(34083,41858,0,0,2559),
(34083,40905,0,0,2559),
(34083,40932,0,0,2559),
(34083,40938,0,0,2559),
(34083,40786,0,0,2559),
(34083,40823,0,0,2559),
(34083,40844,0,0,2559),
(34083,40990,0,0,2559),
(34083,41012,0,0,2559),
(34083,41026,0,0,2559),
(34083,41914,0,0,2559),
(34083,41926,0,0,2559),
(34083,41920,0,0,2559),
(34083,40785,0,0,2559),
(34083,40825,0,0,2559),
(34083,40846,0,0,2559),
(34083,41945,0,0,2559),
(34083,41951,0,0,2559),
(34083,41958,0,0,2559),
(34083,41326,0,0,2559),
(34083,41303,0,0,2559),
(34083,41315,0,0,2559);

-- Vendor Fix - Harold Winston. 3.2 Vendor items.
DELETE FROM `npc_vendor` WHERE `entry` = 32172; -- Remove Old inventory and insert NEW inventory.
INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
-- Replacing Old Gems with new epic gems.
-- (32172,36918,0,0,2484), -- Scarlet Ruby
(32172,36919,0,0,2706), -- Cardinal Ruby - Replaced Scarlet Ruby as of 3.2.
-- (32172,36921,0,0,2484), -- Autumn's Glow
(32172,36922,0,0,2706), -- King's Amber - Replaced Autums Glow as of 3.2.
-- (32172,36924,0,0,2484), -- Sky Sapphire
(32172,36925,0,0,2706), -- Majestic Zircon - Replaced Sky Sapphire as of 3.2.
-- (32172,36927,0,0,2484), -- Twilight Opal
(32172,36928,0,0,2484), -- Dreadstone - Replaced Twilight Opal as of 3.2.
-- (32172,36930,0,0,2484), -- Monarch Topaz -- Orange
(32172,36931,0,0,2484), -- Ametrine - Replaced Monarch Topaz as of 3.2.
-- (32172,36933,0,0,2484), -- Forest Emerald
(32172,36934,0,0,2484), -- Eye of Zul - Replaced Forest Emerald as of 3.2
-- Old stuff. Stays as is.
(32172,40585,0,0,0), -- Signet of the Kirin Tor
(32172,40586,0,0,0), -- Band of the Kirin Tor
(32172,40678,0,0,2523), -- Pendant of the Outcast Hero
(32172,40679,0,0,2523), -- Chained Military Gorget
(32172,40680,0,0,2523), -- Encircling Burnished Gold Chains
(32172,40681,0,0,2523), -- Lattice Choker of Light
(32172,40717,0,0,2534), -- Ring of Invincibility
(32172,40718,0,0,2534), -- Signet of the Impregnable Fortress
(32172,40719,0,0,2534), -- Band of Channeled Magic
(32172,40720,0,0,2534), -- Renewal of Life
(32172,44934,0,0,0), -- Loop of the Kirin Tor
(32172,44935,0,0,0), -- Ring of the Kirin Tor
(32172,45688,0,0,2592), -- Inscribed Band of the Kirin Tor
(32172,45689,0,0,2593), -- Inscribed Loop of the Kirin Tor
(32172,45690,0,0,2594), -- Inscribed Ring of the Kirin Tor
(32172,45691,0,0,2595), -- Inscribed Signet of the Kirin Tor
(32172,45819,0,0,2606), -- Spiked Battleguard Choker
(32172,45820,0,0,2606), -- Broach of the Wailing Night
(32172,45821,0,0,2606), -- Shard of the Crystal Forest
(32172,45822,0,0,2606), -- Evoker's Charm
(32172,45823,0,0,2606), -- Frozen Tear of Elune
-- New Triumph Badge Rings added in 3.2.
(32172,47732,0,0,2685), -- Band of the Invoker
(32172,47729,0,0,2685), -- Bloodshed Band
(32172,47731,0,0,2685), -- Clutch of Fortification
(32172,47730,0,0,2685), -- Dexterous Brightstone Ring
(32172,47733,0,0,2685), -- Dexterous Brightstone Ring
-- New Etched Kirin Tor Rings added in 3.2. iLevel 226
(32172,48954,0,0,2702), -- Etched Band of the Kirin Tor
(32172,48955,0,0,2703), -- Etched Loop of the Kirin Tor
(32172,48956,0,0,2704), -- Etched Ring of the Kirin Tor
(32172,48957,0,0,2705); -- Etched Signet of the Kirin Tor

-- Kezzik the Striker <Veteran Arena Vendor>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 33931;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
-- Items sold by 31600 Honor Points
(33931,45706,0,0,2596), -- Commendation of Bravery
-- Rating 1800 items
-- Two hand, Ranged
-- 50000 honor points, 1400 arena points 
(33931,42366,0,0,2693),
(33931,42324,0,0,2693),
(33931,42319,0,0,2693),
(33931,42386,0,0,2693),
(33931,44424,0,0,2693),
(33931,42334,0,0,2693),
(33931,42498,0,0,2693),
(33931,42492,0,0,2693),
(33931,42329,0,0,2693),
(33931,42487,0,0,2693),
(33931,44423,0,0,2693),
-- Main Hand
-- 35000 honor points, 1200 arena points
(33931,49189,0,0,2695),
(33931,42354,0,0,2695),
(33931,42262,0,0,2695),
(33931,42348,0,0,2695),
-- Idol, Libram, Sigil, Totem, Wand
-- 1150 arena points
(33931,42515,0,0,2700),
(33931,42591,0,0,2700),
(33931,42585,0,0,2700),
(33931,42580,0,0,2700),
(33931,42854,0,0,2700),
(33931,42616,0,0,2700),
(33931,42521,0,0,2700),
(33931,42622,0,0,2700),
(33931,42609,0,0,2700),
(33931,42604,0,0,2700),
(33931,42599,0,0,2700),
(33931,42504,0,0,2700),
(33931,49185,0,0,2700),
(33931,42483,0,0,2700),
-- One Hand, Off Hand
-- 15000 honor points, 1100 arena points
(33931,42282,0,0,2698),
(33931,42234,0,0,2698),
(33931,42210,0,0,2698),
(33931,42229,0,0,2698),
(33931,42267,0,0,2698),
(33931,42272,0,0,2698),
(33931,42257,0,0,2698),
(33931,42277,0,0,2698),
(33931,42292,0,0,2698),
(33931,42244,0,0,2698),
(33931,42250,0,0,2698),
(33931,42287,0,0,2698),
-- Shield, Held in Off Hand
-- 300 arena points
(33931,42566,0,0,2701),
(33931,49187,0,0,2701),
(33931,42527,0,0,2701),
(33931,42539,0,0,2701),
(33931,42572,0,0,2701),
(33931,42533,0,0,2701),
(33931,42561,0,0,2701);

-- Xazi Smolderpipe <Arena Vendor>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 33926;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
(33926,45706,0,0,2596),
(33926,41087,0,0,2611),
(33926,41143,0,0,2609),
(33926,41157,0,0,2612),
(33926,41205,0,0,2610),
(33926,41217,0,0,2613),
(33926,41773,0,0,2609),
(33926,41678,0,0,2612),
(33926,41667,0,0,2610),
(33926,41661,0,0,2611),
(33926,41715,0,0,2613),
(33926,40787,0,0,2611),
(33926,40809,0,0,2609),
(33926,40827,0,0,2612),
(33926,40848,0,0,2610),
(33926,40868,0,0,2613),
(33926,42011,0,0,2613),
(33926,41993,0,0,2612),
(33926,42017,0,0,2609),
(33926,41998,0,0,2611),
(33926,42005,0,0,2610),
(33926,42589,0,0,2608),
(33926,42584,0,0,2608),
(33926,42579,0,0,2608),
(33926,41287,0,0,2609),
(33926,41321,0,0,2612),
(33926,41298,0,0,2610),
(33926,41310,0,0,2611),
(33926,41275,0,0,2613),
(33926,41767,0,0,2609),
(33926,41672,0,0,2612),
(33926,41655,0,0,2610),
(33926,41683,0,0,2613),
(33926,41650,0,0,2611),
(33926,42853,0,0,2608),
(33926,42615,0,0,2608),
(33926,41081,0,0,2611),
(33926,41137,0,0,2609),
(33926,41151,0,0,2612),
(33926,41199,0,0,2610),
(33926,41211,0,0,2613),
(33926,40993,0,0,2611),
(33926,41007,0,0,2609),
(33926,41019,0,0,2612),
(33926,41033,0,0,2610),
(33926,41044,0,0,2613),
(33926,41874,0,0,2609),
(33926,41854,0,0,2612),
(33926,41864,0,0,2610),
(33926,41869,0,0,2613),
(33926,41859,0,0,2611),
(33926,40907,0,0,2611),
(33926,40927,0,0,2609),
(33926,40933,0,0,2612),
(33926,40939,0,0,2610),
(33926,40963,0,0,2613),
(33926,40789,0,0,2611),
(33926,40807,0,0,2609),
(33926,40826,0,0,2612),
(33926,40847,0,0,2610),
(33926,40866,0,0,2613),
(33926,40992,0,0,2611),
(33926,41001,0,0,2609),
(33926,41013,0,0,2612),
(33926,41027,0,0,2610),
(33926,41038,0,0,2613),
(33926,41940,0,0,2609),
(33926,41915,0,0,2612),
(33926,41927,0,0,2610),
(33926,41934,0,0,2613),
(33926,41921,0,0,2611),
(33926,40788,0,0,2611),
(33926,40808,0,0,2609),
(33926,40828,0,0,2612),
(33926,40849,0,0,2610),
(33926,40869,0,0,2613),
(33926,42621,0,0,2608),
(33926,41965,0,0,2613),
(33926,41946,0,0,2612),
(33926,41971,0,0,2609),
(33926,41953,0,0,2611),
(33926,41959,0,0,2610),
(33926,42608,0,0,2608),
(33926,42603,0,0,2608),
(33926,42598,0,0,2608),
(33926,41293,0,0,2609),
(33926,41327,0,0,2612),
(33926,41304,0,0,2610),
(33926,41316,0,0,2611),
(33926,41281,0,0,2613);

-- Zom Bocom <Apprentice Arena Vendor>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 33925;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
(33925,41086,0,0,2440),
(33925,41156,0,0,2440),
(33925,41204,0,0,2440),
(33925,41677,0,0,2440),
(33925,41666,0,0,2440),
(33925,41660,0,0,2440),
(33925,40784,0,0,2440),
(33925,40824,0,0,2440),
(33925,40845,0,0,2440),
(33925,41992,0,0,2440),
(33925,41997,0,0,2440),
(33925,42004,0,0,2440),
(33925,41320,0,0,2440),
(33925,41297,0,0,2440),
(33925,41309,0,0,2440),
(33925,41671,0,0,2440),
(33925,41654,0,0,2440),
(33925,41649,0,0,2440),
(33925,41080,0,0,2440),
(33925,41150,0,0,2440),
(33925,41198,0,0,2440),
(33925,40991,0,0,2440),
(33925,41018,0,0,2440),
(33925,41032,0,0,2440),
(33925,41853,0,0,2440),
(33925,41863,0,0,2440),
(33925,41858,0,0,2440),
(33925,40905,0,0,2440),
(33925,40932,0,0,2440),
(33925,40938,0,0,2440),
(33925,40786,0,0,2440),
(33925,40823,0,0,2440),
(33925,40844,0,0,2440),
(33925,40990,0,0,2440),
(33925,41012,0,0,2440),
(33925,41026,0,0,2440),
(33925,41914,0,0,2440),
(33925,41926,0,0,2440),
(33925,41920,0,0,2440),
(33925,40785,0,0,2440),
(33925,40825,0,0,2440),
(33925,40846,0,0,2440),
(33925,41945,0,0,2440),
(33925,41951,0,0,2440),
(33925,41958,0,0,2440),
(33925,41326,0,0,2440),
(33925,41303,0,0,2440),
(33925,41315,0,0,2440),
(33925,41216,0,0,2445),
(33925,41714,0,0,2445),
(33925,40863,0,0,2445),
(33925,42010,0,0,2445),
(33925,41274,0,0,2445),
(33925,41682,0,0,2445),
(33925,41210,0,0,2445),
(33925,41043,0,0,2445),
(33925,41868,0,0,2445),
(33925,40962,0,0,2445),
(33925,40862,0,0,2445),
(33925,41037,0,0,2445),
(33925,41933,0,0,2445),
(33925,40864,0,0,2445),
(33925,41964,0,0,2445),
(33925,41280,0,0,2445),
(33925,41142,0,0,2443),
(33925,41772,0,0,2443),
(33925,40806,0,0,2443),
(33925,42016,0,0,2443),
(33925,41286,0,0,2443),
(33925,41766,0,0,2443),
(33925,41136,0,0,2443),
(33925,41006,0,0,2443),
(33925,41873,0,0,2443),
(33925,40926,0,0,2443),
(33925,40804,0,0,2443),
(33925,41000,0,0,2443),
(33925,41939,0,0,2443),
(33925,40805,0,0,2443),
(33925,41970,0,0,2443),
(33925,41292,0,0,2443),
(33925,45706,0,0,2596);
-- According to ofi forums and wowwiki this items are no more for buying
-- (33925,42588,0,0,386),
-- (33925,42583,0,0,386),
-- (33925,42578,0,0,386),
-- (33925,42852,0,0,386),
-- (33925,42614,0,0,386),
-- (33925,42620,0,0,386),
-- (33925,42607,0,0,386),
-- (33925,42602,0,0,386),
-- (33925,42597,0,0,386);

-- Trapjaw Rix <Exceptional Arena Weaponry>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 34092;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES

-- Tabard
(34092,49086,0,0,2722),

-- Rating 2200 items (only 3v3 or 5v5)
-- Two hand, Ranged
-- 4250 Arena Points  EC: 2694
(34092,48420,0,0,2694),
(34092,48422,0,0,2694),
(34092,48424,0,0,2694),
(34092,48412,0,0,2694),
(34092,48414,0,0,2694),
(34092,48410,0,0,2694),
(34092,48402,0,0,2694),
(34092,48404,0,0,2694),
(34092,48406,0,0,2694),
(34092,42392,0,0,2694),

-- Main Hand
-- 3585 Arena Points  EC: 2696
(34092,48408,0,0,2696),

-- One Hand
-- 3000 Arena Points  EC: 2697

-- Off Hand
-- 1245 Arena Points  EC: 2699
(34092,48426,0,0,2699),
(34092,48428,0,0,2699),
(34092,48432,0,0,2699);


-- Blazzek the Biter <Exceptional Arena Weaponry>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 34090;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES

-- Tabard
(34090,49086,0,0,2722),

-- Rating 2200 items (only 3v3 or 5v5)
-- Two hand, Ranged
-- 4250 Arena Points  EC: 2694
(34090,48420,0,0,2694),
(34090,48422,0,0,2694),
(34090,48424,0,0,2694),
(34090,48412,0,0,2694),
(34090,48414,0,0,2694),
(34090,48410,0,0,2694),
(34090,48402,0,0,2694),
(34090,48404,0,0,2694),
(34090,48406,0,0,2694),
(34090,42392,0,0,2694),
-- Main Hand
-- 3585 Arena Points  EC: 2696
(34090,48408,0,0,2696),

-- One Hand
-- 3000 Arena Points  EC: 2697

-- Off Hand
-- 1245 Arena Points  EC: 2699
(34090,48426,0,0,2699),
(34090,48428,0,0,2699),
(34090,48432,0,0,2699);


-- Grex Brainboiler <Exceptional Arena Weaponry>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 34091;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES

-- Tabard
(34091,49086,0,0,2722),

-- Rating 2200 items (only 3v3 or 5v5)
-- Two hand, Ranged
-- 4250 Arena Points  EC: 2694
(34091,48420,0,0,2694),
(34091,48422,0,0,2694),
(34091,48424,0,0,2694),
(34091,48412,0,0,2694),
(34091,48414,0,0,2694),
(34091,48410,0,0,2694),
(34091,48402,0,0,2694),
(34091,48404,0,0,2694),
(34091,48406,0,0,2694),
(34091,42392,0,0,2694),
-- Main Hand
-- 3585 Arena Points  EC: 2696
(34091,48408,0,0,2696),

-- One Hand
-- 3000 Arena Points  EC: 2697

-- Off Hand
-- 1245 Arena Points  EC: 2699
(34091,48426,0,0,2699),
(34091,48428,0,0,2699),
(34091,48432,0,0,2699);

-- Argex Irongut <Veteran Arena Vendor>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 33924;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
-- SET RELENTLESS
(33924,45706,0,0,2596),
(33924,41088,0,0,2688),
(33924,41144,0,0,2689),
(33924,41206,0,0,2691),
(33924,41158,0,0,2690),
(33924,41774,0,0,2689),
(33924,41679,0,0,2690),
(33924,41668,0,0,2691),
(33924,41662,0,0,2688),
(33924,40791,0,0,2688),
(33924,40811,0,0,2689),
(33924,40830,0,0,2690),
(33924,40851,0,0,2691),
(33924,41994,0,0,2690),
(33924,42018,0,0,2689),
(33924,41999,0,0,2688),
(33924,42006,0,0,2691),
(33924,41288,0,0,2689),
(33924,41322,0,0,2690),
(33924,41299,0,0,2691),
(33924,41311,0,0,2688),
(33924,41768,0,0,2689),
(33924,41673,0,0,2690),
(33924,41656,0,0,2691),
(33924,41651,0,0,2688),
(33924,41082,0,0,2688),
(33924,41138,0,0,2689),
(33924,41152,0,0,2690),
(33924,41200,0,0,2691),
(33924,40995,0,0,2688),
(33924,41008,0,0,2689),
(33924,41020,0,0,2690),
(33924,41034,0,0,2691),
(33924,41875,0,0,2689),
(33924,41855,0,0,2690),
(33924,41865,0,0,2691),
(33924,41860,0,0,2688),
(33924,40910,0,0,2688),
(33924,40928,0,0,2689),
(33924,40934,0,0,2690),
(33924,40940,0,0,2691),
(33924,40790,0,0,2688),
(33924,40810,0,0,2689),
(33924,40829,0,0,2690),
(33924,40850,0,0,2691),
(33924,40994,0,0,2688),
(33924,41002,0,0,2689),
(33924,41014,0,0,2690),
(33924,41028,0,0,2691),
(33924,41941,0,0,2689),
(33924,41916,0,0,2690),
(33924,41928,0,0,2691),
(33924,41922,0,0,2688),
(33924,40792,0,0,2688),
(33924,40812,0,0,2689),
(33924,40831,0,0,2690),
(33924,40852,0,0,2691),
(33924,41947,0,0,2690),
(33924,41972,0,0,2689),
(33924,41954,0,0,2688),
(33924,41960,0,0,2691),
(33924,41294,0,0,2689),
(33924,41328,0,0,2690),
(33924,41305,0,0,2691),
(33924,41317,0,0,2688),
-- Items sold by 31600 Honor Points
-- Rating 1800 items
-- Two hand, Ranged
-- 50000 honor points, 1400 arena points 
(33924,42366,0,0,2693),
(33924,42324,0,0,2693),
(33924,42319,0,0,2693),
(33924,42386,0,0,2693),
(33924,44424,0,0,2693),
(33924,42334,0,0,2693),
(33924,42498,0,0,2693),
(33924,42492,0,0,2693),
(33924,42329,0,0,2693),
(33924,42487,0,0,2693),
(33924,44423,0,0,2693),
-- Main Hand
-- 35000 honor points, 1200 arena points
(33924,49189,0,0,2695),
(33924,42354,0,0,2695),
(33924,42262,0,0,2695),
(33924,42348,0,0,2695),
-- Idol, Libram, Sigil, Totem, Wand
-- 1150 arena points
(33924,42515,0,0,2700),
(33924,42591,0,0,2700),
(33924,42585,0,0,2700),
(33924,42580,0,0,2700),
(33924,42854,0,0,2700),
(33924,42616,0,0,2700),
(33924,42521,0,0,2700),
(33924,42622,0,0,2700),
(33924,42609,0,0,2700),
(33924,42604,0,0,2700),
(33924,42599,0,0,2700),
(33924,42504,0,0,2700),
(33924,49185,0,0,2700),
(33924,42483,0,0,2700),
-- One Hand, Off Hand
-- 15000 honor points, 1100 arena points
(33924,42282,0,0,2698),
(33924,42234,0,0,2698),
(33924,42210,0,0,2698),
(33924,42229,0,0,2698),
(33924,42267,0,0,2698),
(33924,42272,0,0,2698),
(33924,42257,0,0,2698),
(33924,42277,0,0,2698),
(33924,42292,0,0,2698),
(33924,42244,0,0,2698),
(33924,42250,0,0,2698),
(33924,42287,0,0,2698),
-- Shield, Held in Off Hand
-- 300 arena points
(33924,49187,0,0,2701),
(33924,42527,0,0,2701),
(33924,42539,0,0,2701),
(33924,42572,0,0,2701),
(33924,42533,0,0,2701),
(33924,42561,0,0,2701),
(33924,42566,0,0,2701);

-- Nargle Lashcord <Veteran Arena Vendor>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 33927;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
-- SET RELENTLESS
(33927,45706,0,0,2596),
(33927,41088,0,0,2688),
(33927,41144,0,0,2689),
(33927,41206,0,0,2691),
(33927,41158,0,0,2690),
(33927,41774,0,0,2689),
(33927,41679,0,0,2690),
(33927,41668,0,0,2691),
(33927,41662,0,0,2688),
(33927,40791,0,0,2688),
(33927,40811,0,0,2689),
(33927,40830,0,0,2690),
(33927,40851,0,0,2691),
(33927,41994,0,0,2690),
(33927,42018,0,0,2689),
(33927,41999,0,0,2688),
(33927,42006,0,0,2691),
(33927,41288,0,0,2689),
(33927,41322,0,0,2690),
(33927,41299,0,0,2691),
(33927,41311,0,0,2688),
(33927,41768,0,0,2689),
(33927,41673,0,0,2690),
(33927,41656,0,0,2691),
(33927,41651,0,0,2688),
(33927,41082,0,0,2688),
(33927,41138,0,0,2689),
(33927,41152,0,0,2690),
(33927,41200,0,0,2691),
(33927,40995,0,0,2688),
(33927,41008,0,0,2689),
(33927,41020,0,0,2690),
(33927,41034,0,0,2691),
(33927,41875,0,0,2689),
(33927,41855,0,0,2690),
(33927,41865,0,0,2691),
(33927,41860,0,0,2688),
(33927,40910,0,0,2688),
(33927,40928,0,0,2689),
(33927,40934,0,0,2690),
(33927,40940,0,0,2691),
(33927,40790,0,0,2688),
(33927,40810,0,0,2689),
(33927,40829,0,0,2690),
(33927,40850,0,0,2691),
(33927,40994,0,0,2688),
(33927,41002,0,0,2689),
(33927,41014,0,0,2690),
(33927,41028,0,0,2691),
(33927,41941,0,0,2689),
(33927,41916,0,0,2690),
(33927,41928,0,0,2691),
(33927,41922,0,0,2688),
(33927,40792,0,0,2688),
(33927,40812,0,0,2689),
(33927,40831,0,0,2690),
(33927,40852,0,0,2691),
(33927,41947,0,0,2690),
(33927,41972,0,0,2689),
(33927,41954,0,0,2688),
(33927,41960,0,0,2691),
(33927,41294,0,0,2689),
(33927,41328,0,0,2690),
(33927,41305,0,0,2691),
(33927,41317,0,0,2688),
-- Items sold by 31600 Honor Points
-- Rating 1800 items
-- Two hand, Ranged
-- 50000 honor points, 1400 arena points 
(33927,42366,0,0,2693),
(33927,42324,0,0,2693),
(33927,42319,0,0,2693),
(33927,42386,0,0,2693),
(33927,44424,0,0,2693),
(33927,42334,0,0,2693),
(33927,42498,0,0,2693),
(33927,42492,0,0,2693),
(33927,42329,0,0,2693),
(33927,42487,0,0,2693),
(33927,44423,0,0,2693),
-- Main Hand
-- 35000 honor points, 1200 arena points
(33927,49189,0,0,2695),
(33927,42354,0,0,2695),
(33927,42262,0,0,2695),
(33927,42348,0,0,2695),
-- Idol, Libram, Sigil, Totem, Wand
-- 1150 arena points
(33927,42515,0,0,2700),
(33927,42591,0,0,2700),
(33927,42585,0,0,2700),
(33927,42580,0,0,2700),
(33927,42854,0,0,2700),
(33927,42616,0,0,2700),
(33927,42521,0,0,2700),
(33927,42622,0,0,2700),
(33927,42609,0,0,2700),
(33927,42604,0,0,2700),
(33927,42599,0,0,2700),
(33927,42504,0,0,2700),
(33927,49185,0,0,2700),
(33927,42483,0,0,2700),
-- One Hand, Off Hand
-- 15000 honor points, 1100 arena points
(33927,42282,0,0,2698),
(33927,42234,0,0,2698),
(33927,42210,0,0,2698),
(33927,42229,0,0,2698),
(33927,42267,0,0,2698),
(33927,42272,0,0,2698),
(33927,42257,0,0,2698),
(33927,42277,0,0,2698),
(33927,42292,0,0,2698),
(33927,42244,0,0,2698),
(33927,42250,0,0,2698),
(33927,42287,0,0,2698),
-- Shield, Held in Off Hand
-- 300 arena points
(33927,42566,0,0,2701),
(33927,49187,0,0,2701),
(33927,42527,0,0,2701),
(33927,42539,0,0,2701),
(33927,42572,0,0,2701),
(33927,42533,0,0,2701),
(33927,42561,0,0,2701);

-- Lieutenant Tristia <Veteran Armor Quartermaster>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 34077;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
-- Rating 1650 items
-- 62000 honor points
(34077,42133,0,0,2718),
(34077,42134,0,0,2718),
(34077,42136,0,0,2718),
(34077,42137,0,0,2718),
(34077,42135,0,0,2718),
-- Rating 1250 items
-- 62000 honor points
(34077,41631,0,0,2712),
(34077,41618,0,0,2712),
(34077,41833,0,0,2712),
(34077,49179,0,0,2712),
(34077,41899,0,0,2712),
(34077,41882,0,0,2712),
(34077,40978,0,0,2712),
(34077,40883,0,0,2712),
(34077,41071,0,0,2712),
(34077,41052,0,0,2712),
(34077,41236,0,0,2712),
-- Rating 1300 items
-- 62000 honor points
(34077,41636,0,0,2713),
(34077,41622,0,0,2713),
(34077,41837,0,0,2713),
(34077,40979,0,0,2713),
(34077,40884,0,0,2713),
(34077,41076,0,0,2713),
(34077,41056,0,0,2713),
(34077,41231,0,0,2713),
(34077,49183,0,0,2713),
(34077,41904,0,0,2713),
(34077,41886,0,0,2713),
-- Rating 1500 items
-- 47400 honor points
(34077,42118,0,0,2717),
(34077,42119,0,0,2717),
-- Rating 1750 items
-- 47400 honor points
(34077,42078,0,0,2715),
(34077,42080,0,0,2715),
(34077,42076,0,0,2715),
(34077,42079,0,0,2715),
(34077,42077,0,0,2715),
(34077,42081,0,0,2715),
(34077,42082,0,0,2715),
-- Rating 1450 items
-- 47400 honor points
(34077,42044,0,0,2716),
(34077,42046,0,0,2716),
(34077,42043,0,0,2716),
(34077,42047,0,0,2716),
(34077,42045,0,0,2716),
(34077,46374,0,0,2716),
(34077,42041,0,0,2716),
(34077,42042,0,0,2716),
-- Rating 1200 items
-- 39400 honor points
(34077,41641,0,0,2714),
(34077,41626,0,0,2714),
(34077,41841,0,0,2714),
(34077,40984,0,0,2714),
(34077,40890,0,0,2714),
(34077,49181,0,0,2714),
(34077,41910,0,0,2714),
(34077,41894,0,0,2714),
(34077,41066,0,0,2714),
(34077,41061,0,0,2714),
(34077,41226,0,0,2714);

-- Doris Volanthius <Veteran Armor Quartermaster>
-- Remove data for Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 34059;
-- Insert completed data
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`ExtendedCost`) VALUES
-- Rating 1650 items
-- 62000 honor points
(34059,42133,0,0,2718),
(34059,42134,0,0,2718),
(34059,42136,0,0,2718),
(34059,42137,0,0,2718),
(34059,42135,0,0,2718),
-- Rating 1250 items
-- 62000 honor points
(34059,41631,0,0,2712),
(34059,41618,0,0,2712),
(34059,41833,0,0,2712),
(34059,49179,0,0,2712),
(34059,41899,0,0,2712),
(34059,41882,0,0,2712),
(34059,40978,0,0,2712),
(34059,40883,0,0,2712),
(34059,41071,0,0,2712),
(34059,41052,0,0,2712),
(34059,41236,0,0,2712),
-- Rating 1300 items
-- 62000 honor points
(34059,41636,0,0,2713),
(34059,41622,0,0,2713),
(34059,41837,0,0,2713),
(34059,40979,0,0,2713),
(34059,40884,0,0,2713),
(34059,41076,0,0,2713),
(34059,41056,0,0,2713),
(34059,41231,0,0,2713),
(34059,49183,0,0,2713),
(34059,41904,0,0,2713),
(34059,41886,0,0,2713),
-- Rating 1500 items
-- 47400 honor points
(34059,42118,0,0,2717),
(34059,42119,0,0,2717),
-- Rating 1750 items
-- 47400 honor points
(34059,42078,0,0,2715),
(34059,42080,0,0,2715),
(34059,42076,0,0,2715),
(34059,42079,0,0,2715),
(34059,42077,0,0,2715),
(34059,42081,0,0,2715),
(34059,42082,0,0,2715),
-- Rating 1450 items
-- 47400 honor points
(34059,42044,0,0,2716),
(34059,42046,0,0,2716),
(34059,42043,0,0,2716),
(34059,42047,0,0,2716),
(34059,42045,0,0,2716),
(34059,46374,0,0,2716),
(34059,42041,0,0,2716),
(34059,42042,0,0,2716),
-- Rating 1200 items
-- 39400 honor points
(34059,41641,0,0,2714),
(34059,41626,0,0,2714),
(34059,41841,0,0,2714),
(34059,40984,0,0,2714),
(34059,40890,0,0,2714),
(34059,49181,0,0,2714),
(34059,41910,0,0,2714),
(34059,41894,0,0,2714),
(34059,41066,0,0,2714),
(34059,41061,0,0,2714),
(34059,41226,0,0,2714);

-- Vendor Fix - Enchanter Erodin <Heirloom Vendor>
DELETE FROM `npc_vendor` WHERE `entry` = 35508; -- Remove Old inventory and insert NEW inventory.
-- Creating inventory.
INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(35508,42944,0,0,2524), -- Balanced Heartseeker
(35508,42943,0,0,2551), -- Bloodied Arcanite Reaper
(35508,42950,0,0,2524), -- Champion Herod's Shoulder
(35508,48677,0,0,2524), -- Champion's Deathdealer Breastplate
(35508,42946,0,0,2551), -- Charmed Ancient Bone Bow
(35508,42948,0,0,2532), -- Devout Aurastone Hammer
(35508,42947,0,0,2551), -- Dignified Headmaster's Charge
(35508,42992,0,0,2532), -- Discerning Eye of the Beast
(35508,42951,0,0,2524), -- Mystical Pauldrons of Elements
(35508,48683,0,0,2524), -- Mystical Vest of Elements
(35508,48685,0,0,2524), -- Polished Breastplate of Valor
(35508,42949,0,0,2524), -- Polished Spaulders of Valor
(35508,48687,0,0,2524), -- Preened Ironfeather Breastplate
(35508,42984,0,0,2524), -- Preened Ironfeather Shoulders
(35508,48718,0,0,2551), -- Repurposed Lava Dredger
(35508,42952,0,0,2524), -- Stained Shadowcraft Spaulders
(35508,48689,0,0,2524), -- Stained Shadowcraft Tunic
(35508,42991,0,0,2532), -- Swift Hand of Justice
(35508,42985,0,0,2524), -- Tattered Dreadmist Mantle
(35508,48691,0,0,2524), -- Tattered Dreadmist Robe
(35508,42945,0,0,2524), -- Venerable Dal'Rend's Sacred Charge
(35508,48716,0,0,2524); -- Venerable Mass of McGowan

-- Vendor Fix - Enchanter Isian <Heirloom Vendor>
DELETE FROM `npc_vendor` WHERE `entry` = 35507; -- Remove Old inventory and insert NEW inventory.
-- Creating inventory.
INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(35507,42944,0,0,2524), -- Balanced Heartseeker
(35507,42943,0,0,2551), -- Bloodied Arcanite Reaper
(35507,42950,0,0,2524), -- Champion Herod's Shoulder
(35507,48677,0,0,2524), -- Champion's Deathdealer Breastplate
(35507,42946,0,0,2551), -- Charmed Ancient Bone Bow
(35507,42948,0,0,2532), -- Devout Aurastone Hammer
(35507,42947,0,0,2551), -- Dignified Headmaster's Charge
(35507,42992,0,0,2532), -- Discerning Eye of the Beast
(35507,42951,0,0,2524), -- Mystical Pauldrons of Elements
(35507,48683,0,0,2524), -- Mystical Vest of Elements
(35507,48685,0,0,2524), -- Polished Breastplate of Valor
(35507,42949,0,0,2524), -- Polished Spaulders of Valor
(35507,48687,0,0,2524), -- Preened Ironfeather Breastplate
(35507,42984,0,0,2524), -- Preened Ironfeather Shoulders
(35507,48718,0,0,2551), -- Repurposed Lava Dredger
(35507,42952,0,0,2524), -- Stained Shadowcraft Spaulders
(35507,48689,0,0,2524), -- Stained Shadowcraft Tunic
(35507,42991,0,0,2532), -- Swift Hand of Justice
(35507,42985,0,0,2524), -- Tattered Dreadmist Mantle
(35507,48691,0,0,2524), -- Tattered Dreadmist Robe
(35507,42945,0,0,2524), -- Venerable Dal'Rend's Sacred Charge
(35507,48716,0,0,2524); -- Venerable Mass of McGowan

Edited by overy

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0
Go To Topic Listing Opravy
×