-- Misc.
UPDATE creature_template SET EXPANSION=2, minhealth=126000, maxhealth=126000, armor=9730, faction_A=1619, faction_H=1619, npcflag=131, baseattacktime=2000, unit_flags=2, mingold=0, maxgold=0 WHERE entry=15350;
-- Quest-ek (nem mind) törlése
DELETE FROM creature_questrelation WHERE quest IN (11340, 11339, 11341, 14164, 13407, 11342, 13428, 14181, 14182, 14183, 22426, 24226, 24225, 24221, 24216, 24217);
DELETE FROM creature_involvedrelation WHERE quest IN (11340, 11339, 11341, 14164, 13407, 11342, 13428, 14181, 14182, 14183, 22426, 24226, 24225, 24221, 24216, 24217);
-- Vendor rész
DELETE FROM npc_vendor WHERE entry=15350;
INSERT INTO npc_vendor (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
VALUES
('15350', '54637', '0', '0', '2991'),
('15350', '54637', '0', '0', '2992'),
('15350', '54637', '0', '0', '2993'),
('15350', '54637', '0', '0', '2994'),
('15350', '54637', '0', '0', '2995'),
('15350', '54637', '0', '0', '2996');
-- Gossip
DELETE FROM gossip_menu_option WHERE menu_id=6598;
INSERT INTO gossip_menu_option (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
VALUES
('6598', '0', '0', 'GOSSIP_OPTION_QUESTGIVER', '2', '2', '0', '0', '0', '0', '0', '', '15', '11', '1', '0', '0', '0', '0', '0', '0'),
('6598', '1', '1', 'Redeem marks the battlefield to honor.', '3', '128', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
DELETE FROM gossip_menu WHERE entry=6598;
INSERT INTO gossip_menu (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
VALUES
('6598', '7819', '0', '0', '0', '0', '0', '0');
--Quest
DELETE FROM creature_questrelation WHERE id=15350;
INSERT INTO creature_questrelation (`id`, `quest`)
VALUES
('15350', '13476');
UPDATE quest_template SET `Method`='1', `QuestFlags`='8', `Details`='Serving the Horde in one of the great battles against the Alliance is a source of great honor! The few however, that have served the Horde in ALL of our active battlefronts are our truly great fighters. We shall vanquish our opponents, not by fighting isolated skirmishes, but by waging a well-coordinated war.$B$BGo forth and crush the Alliance on every front! For Honor! For the Horde!', `Objectives`='Bring a Mark of Honor from each battleground to a Horde Warbringer in any Horde capital city, Shattrath, Dalaran, or Wintergrasp.', `CompletedText`='Return to Horde Warbringer.', `ReqItemId5`='20560', `ReqItemId6`='47395', `ReqItemCount5`='1', `ReqItemCount6`='1' WHERE entry=13476;
DELETE FROM creature_involvedrelation WHERE id=15350;
INSERT INTO creature_involvedrelation (`id`, `quest`)
VALUES
('15350', '13476');