/*setovky*/
update npc_vendor set extendedcost = 2340 where extendedcost = 2688;
update npc_vendor set extendedcost = 2689 where extendedcost = 2689;
update npc_vendor set extendedcost = 2629 where extendedcost = 2690;
update npc_vendor set extendedcost = 2691 where extendedcost = 2691;
update npc_vendor set extendedcost = 2470 where extendedcost = 2692;

/*high rele*/
DELETE FROM `npc_vendor` WHERE (`entry`=34092);
INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES
(34092, 48402, 0, 0, 26),
(34092, 48404, 0, 0, 26),
(34092, 48406, 0, 0, 26),
(34092, 48408, 0, 0, 148),
(34092, 48410, 0, 0, 26),
(34092, 48412, 0, 0, 26),
(34092, 48414, 0, 0, 26),
(34092, 48420, 0, 0, 26),
(34092, 48422, 0, 0, 26),
(34092, 48424, 0, 0, 26),
(34092, 48426, 0, 0, 21),
(34092, 48428, 0, 0, 21),
(34092, 48432, 0, 0, 21),
(34092, 48435, 0, 0, 21),
(34092, 48438, 0, 0, 21),
(34092, 48440, 0, 0, 21),
(34092, 48442, 0, 0, 21),
(34092, 48444, 0, 0, 21),
(34092, 48507, 0, 0, 133),
(34092, 48509, 0, 0, 133),
(34092, 48511, 0, 0, 133),
(34092, 48513, 0, 0, 133),
(34092, 48515, 0, 0, 133),
(34092, 48517, 0, 0, 26),
(34092, 48519, 0, 0, 148),
(34092, 48521, 0, 0, 26),
(34092, 48523, 0, 0, 26),
(34092, 49086, 0, 0, 2374),
(34092, 49191, 0, 0, 148);

/*rele doplnky*/
update npc_vendor set extendedcost = 2471 where extendedcost = 2714;
update npc_vendor set extendedcost = 2618 where extendedcost = 2712;
update npc_vendor set extendedcost = 2567 where extendedcost = 2713;
update npc_vendor set extendedcost = 2472 where extendedcost = 2717;
update npc_vendor set extendedcost = 2715 where extendedcost = 2716;

/*extended costy*/


insert into `item_extended_cost` (`entry`, `honor`, `arena_points`, `bracket`, `rating`) values('26','-1','-1','0','2100');
insert into `item_extended_cost` (`entry`, `honor`, `arena_points`, `bracket`, `rating`) values('21','-1','-1','0','2100');
insert into `item_extended_cost` (`entry`, `honor`, `arena_points`, `bracket`, `rating`) values('133','-1','-1','0','2100');
insert into `item_extended_cost` (`entry`, `honor`, `arena_points`, `bracket`, `rating`) values('148','-1','-1','0','2100');
insert into `item_extended_cost` (`entry`, `honor`, `arena_points`, `bracket`, `rating`) values('2569','-1','-1','1','1700');
insert into `item_extended_cost` (`entry`, `honor`, `arena_points`, `bracket`, `rating`) values('2964','-1','-1','1','1600');
insert into `item_extended_cost` (`entry`, `honor`, `arena_points`, `bracket`, `rating`) values('2963','-1','-1','1','1500');
insert into `item_extended_cost` (`entry`, `honor`, `arena_points`, `bracket`, `rating`) values('2374','-1','-1','0','2150');

/*deadly zbrane*/
INSERT INTO `npc_vendor` VALUES
(33926, 42327, 0, 0, 2965),
(33926, 42362, 0, 0, 2965),
(33926, 42384, 0, 0, 2965),
(33926, 44420, 0, 0, 2965),
(33926, 42390, 0, 0, 2965),
(33926, 44419, 0, 0, 2965),
(33926, 42317, 0, 0, 2965),
(33926, 42322, 0, 0, 2965),
(33926, 42332, 0, 0, 2965),
(33926, 42490, 0, 0, 2965),
(33926, 42495, 0, 0, 2965),
(33926, 42485, 0, 0, 2965),

(33926, 42346, 0, 0, 2959),
(33926, 42352, 0, 0, 2959),

(33926, 42260, 0, 0, 2960),
(33926, 42208, 0, 0, 2960),
(33926, 42275, 0, 0, 2960),
(33926, 42242, 0, 0, 2960),
(33926, 42285, 0, 0, 2960),
(33926, 42237, 0, 0, 2960),

(33926, 42280, 0, 0, 2262),
(33926, 42227, 0, 0, 2262),
(33926, 42232, 0, 0, 2262),
(33926, 42265, 0, 0, 2262),
(33926, 42270, 0, 0, 2262),
(33926, 42255, 0, 0, 2262),
(33926, 42290, 0, 0, 2262),
(33926, 42248, 0, 0, 2262);

UPDATE `creature_template` SET `subname` = 'WG Arena Rewards', `npcflag` = 4224 WHERE `entry` = 34090;

DELETE FROM npc_vendor WHERE entry = 34090;
INSERT INTO `npc_vendor` VALUES
(34090, 51573, 0, 0, 2692),
(34090, 51572, 0, 0, 2692),
(34090, 51581, 0, 0, 2692),
(34090, 51580, 0, 0, 2692),
(34090, 51578, 0, 0, 2692),
(34090, 51579, 0, 0, 2692),
(34090, 51577, 0, 0, 2692),
(34090, 51574, 0, 0, 2692),
(34090, 51575, 0, 0, 2692),
(34090, 51576, 0, 0, 2692),

(34090, 46083, 0, 0, 2569),
(34090, 46085, 0, 0, 2569),
(34090, 46081, 0, 0, 2569),
(34090, 46084, 0, 0, 2569),
(34090, 46082, 0, 0, 2569),

(34090, 51570, 0, 0, 2963),
(34090, 51571, 0, 0, 2963),

(34090, 51568, 0, 0, 2964),
(34090, 51569, 0, 0, 2964);

update npc_vendor set extendedcost = 2946 where item = 42282;
update npc_vendor set extendedcost = 2946 where item = 42229;
update npc_vendor set extendedcost = 2946 where item = 42234;
update npc_vendor set extendedcost = 2946 where item = 42267;
update npc_vendor set extendedcost = 2946 where item = 42272;
update npc_vendor set extendedcost = 2946 where item = 42257;
update npc_vendor set extendedcost = 2946 where item = 42292;
update npc_vendor set extendedcost = 2946 where item = 42250;
update npc_vendor set extendedcost = 2946 where item = 49187;
update npc_vendor set extendedcost = 2946 where item = 42527;
update npc_vendor set extendedcost = 2946 where item = 42539;
update npc_vendor set extendedcost = 2946 where item = 42533;
update npc_vendor set extendedcost = 2946 where item = 42566;
update npc_vendor set extendedcost = 2946 where item = 42572;
update npc_vendor set extendedcost = 2946 where item = 42561;