-- Creates the quests to exchange the Battleground Marks of Honor. First three quests are the horde quests for Warsong Gulch, Arathi Basin and Eye of the Storm (in order). The last three are the Alliance equivalents (on the same order). Change the Entry Number as you see fit for your database.

INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `Type`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `OfferRewardText`, `RequestItemsText`, `ReqItemId1`, `ReqItemCount1`, `RewItemId1`, `RewItemCount1`) VALUES
('7500', '2597', '51', '41', '0', '1791', '1', 'Warsong Gulch Mark of Honor Exchange', 'Your commitment to The Horde\'s Warsong Gulch battles is also recognized among The Frostwolf Clan, $N.', '$N, if you have proved your worth for the Warsong Outriders in Warsong Gulch, then bring me two Warsong Gulch Marks of Honor and I will exchange it for one Alterac Valley equivalent.', '20558', '2', '20560', '1'),
('7501', '2597', '51', '41', '0', '1791', '1', 'Arathi Basin Mark of Honor Exchange', 'Your commitment to The Horde\'s Arathi Basin battles is also recognized among The Frostwolf Clan, $N.', '$N, if you have proved your worth for The Defilers in Arathi Basin, then bring me two Arathi Basin Marks of Honor and I will exchange it for one Alterac Valley equivalent.', '20559', '2', '20560', '1'),
('7502', '2597', '51', '41', '0', '1791', '1', 'Eye of the Storm Mark of Honor Exchange', 'Your commitment to The Horde\'s Eye of the Storm battles is also recognized among The Frostwolf Clan, $N.', '$N, if you have proved your worth for our Blood Elf allies in the Eye of the Storm, then bring me two Eye of the Storm Marks of Honor and I will exchange it for one Alterac Valley equivalent.', '29024', '2', '20560', '1'),
('7503', '2597', '51', '41', '0', '1791', '1', 'Warsong Gulch Mark of Honor Exchange', 'Your commitment to The Alliance\'s Warsong Gulch battles is also recognized among The Frostwolf Clan, $N.', '$N, if you have proved your worth for the Silverwing Sentinels in Warsong Gulch, then bring me two Warsong Gulch Marks of Honor and I will exchange it for one Alterac Valley equivalent.', '20558', '2', '20560', '1'),
('7504', '2597', '51', '41', '0', '1791', '1', 'Arathi Basin Mark of Honor Exchange', 'Your commitment to The Alliance\'s Arathi Basin battles is also recognized among The Frostwolf Clan, $N.', '$N, if you have proved your worth for the League of Arathor in Warsong Gulch, then bring me two Arathi Basin Marks of Honor and I will exchange it for one Alterac Valley equivalent.', '20559', '2', '20560', '1'),
('7505', '2597', '51', '41', '0', '1791', '1', 'Eye of the Storm Mark of Honor Exchange', 'Your commitment to The Alliance\'s Eye of the Storm battles is also recognized among The Frostwolf Clan, $N.', '$N, if you have proved your worth for our Draenei in the Eye of the Storm, then bring me two Warsong Gulch Marks of Honor and I will exchange it for one Alterac Valley equivalent.', '29024', '2', '20560', '1');

-- Alterac Valley: MinLevel = 51 Type = 41 (PVP) RequiredRaces = 690 (Horde Version) 1101 (Alliance Version), but using 1791 for testing purposes since the above failed.
-- QuestFlags = 1024 (Don't appear on Quest Log) SpecialFlags = 1 (Repeatable)
-- Title = <Battleground> Mark of Honor Exchange
-- OfferRewardText = Your commitment to The <faction>'s battles is also recognized among The <faction>, $N.
-- RequestItemsText = If you have proved your worth for The <faction> in <Battleground>, then bring me two Warsong Gulch Marks of Honor and I will exchange it for one Alterac Valley equivalent.
-- ReqItemId = 20558 (WSG) 29024 (EotS) 20559 (AB) ReqItemCount = 2 RewItemId = 20560 RewItemCount = 1



-- Creates the NPC's. Again, change Entry numbers as you see fit.

INSERT INTO `creature_template`(`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `faction_A`, `faction_H`, `npcflag`, `unit_flags`, `type`) VALUES
('50015', '12081', '12081', '12081', '12081', 'Frostwolf Stone Guard', 'Frostwolf Clan Commendations', '80', '80', '18000', '18000', '1214', '1214', '3', '0', '7'),
('50016', '13383', '13383', '13383', '13383', 'Stormpike Corporal', 'Stormpike Guard Commendations', '80', '80', '18000', '18000', '1216', '1216', '3', '0', '7');

-- ModelID for Frostwolf Stone Guard = 12081 | ModelID for Stormpike Corporal = 13383
-- Name = Frostwolf Stone Guard <Frostwolf Clan> | Stormpike Corporal <Stormpike Guard>
-- Frostwolf Faction = 1214 | Stormpike Faction = 1216
-- npcflag = 2 (Quest Giver) | unit_flags = 2 (non-attackable) | type = 7 (Humanoid)



-- Creates Creature QuestRelations:
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES
('50015', '7500'),
('50015', '7501'),
('50015', '7502'),
('50016', '7503'),
('50016', '7504'),
('50016', '7505');


-- Spawns the creatures on the World. Horde NPC is in ; Alliance NPC is in the Hall of Arms in Ironforge. As previously, change GUID's as needed.

DELETE FROM `creature` WHERE `id` > '49999';
INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
('200000', '50015', '1', '1978.263306', '-4789.445801', '55.796906', '5.533096', '300'),
('200001', '50016', '0', '-5071.212402', '-1293.463989', '512.276855', '0.624691', '300');