Scripts/OrderHall: Spawn some Warrior Order Hall NPC's and script some of them (#19902)

1 files changed, 603 insertions, 0 deletions

diff --git a/sql/updates/world/master/2019_08_25_00_world.sql b/sql/updates/world/master/2019_08_25_00_world.sql
new file mode 100644
index 00000000000..c170d9f8c07
--- /dev/null
+++ b/sql/updates/world/master/2019_08_25_00_world.sql
@@ -0,0 +1,603 @@
+SET @CGUID := 685;
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+124;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES
+(@CGUID+0, 112392, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1076.599, 7248.414, 97.78458, 0.7000231, 120, 0, 0, 0, 0, 2, 0, 0, 0, '', 24015), -- Quartermaster Durnolf
+(@CGUID+1, 93823, 1479, 7813, 7813, '0', 5090, 0, 0, 0, 1059.613, 7224.605, 100.3775, 0.03462749, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Danica the Reclaimer
+(@CGUID+2, 116609, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1071.531, 7241.38, 97.78132, 6.147542, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Battlelord's Armor
+(@CGUID+3, 96679, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1082.998, 7229.331, 98.20152, 3.558333, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Aerylia
+(@CGUID+4, 112420, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1049.514, 7135.655, 98.26167, 4.09064, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Ymirjar Lord's Set
+(@CGUID+5, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1019.195, 7165.312, 97.78876, 1.599757, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+6, 112400, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1042.552, 7139.059, 98.17068, 4.729155, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Onslaught Set
+(@CGUID+7, 96469, 1479, 7813, 7813, '0', 5107, 0, 0, 0, 796.1858, 7228.977, 106.7501, 0.01738298, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Odyn
+(@CGUID+8, 111741, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1067.51, 7324.483, 109.51, 0.05171752, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Fjornson Stonecarver
+(@CGUID+9, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 892.434, 7226.98, 97.78457, 5.579187, 120, 0, 0, 0, 0, 2, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+10, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 881.3212, 7215.812, 97.84029, 0.8428905, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+11, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1035.899, 7164.185, 97.78709, 1.637839, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+12, 112408, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1044.514, 7138.362, 98.09043, 4.533813, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Heroes' Dreadnaught Set
+(@CGUID+13, 112418, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1048.08, 7136.716, 98.11954, 4.406168, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Hellscream's Conquest Set
+(@CGUID+14, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1052.437, 7118.711, 97.76829, 5.480986, 120, 0, 0, 0, 0, 2, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+15, 112413, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1046.476, 7137.655, 98.12541, 4.404978, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Valorous Siegebreaker Set
+(@CGUID+16, 112416, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1048.076, 7136.72, 98.18303, 4.312254, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Wrynn's Conquest Set
+(@CGUID+17, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 881.3577, 7238.921, 97.81672, 5.622649, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+18, 112361, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1010.028, 7139.051, 98.17016, 5.175318, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Warbringer Armor Set
+(@CGUID+19, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1041.295, 7120.502, 97.79205, 4.123053, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+20, 112390, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1011.79, 7139.432, 98.16254, 4.938556, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Destroyer Armor Set
+(@CGUID+21, 114558, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 996.7882, 7131.478, 98.34371, 5.313775, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Greater Sparring Partner
+(@CGUID+22, 114559, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 983.5417, 7115.333, 98.34372, 5.964656, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Lesser Sparring Partner
+(@CGUID+23, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 849.691, 7241.927, 106.7698, 3.942692, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+24, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1000.208, 7109.535, 97.79235, 5.673533, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+25, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1014.392, 7122.58, 97.79585, 5.204721, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+26, 112356, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1006.404, 7137.51, 98.14191, 5.266796, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Battlegear of Wrath Set
+(@CGUID+27, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1050.693, 7111.057, 97.79233, 4.03371, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+28, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 848.368, 7212.071, 106.7691, 2.617522, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+29, 112353, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1004.611, 7136.491, 98.09541, 5.572387, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Battlegear of Might Set
+(@CGUID+30, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1010.502, 7120.085, 97.79221, 5.342214, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+31, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1066.46, 7116.097, 98.34373, 0.714711, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_weapon_inspector_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+32, 107494, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1029.283, 7122.28, 101.786, 1.365587, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Val'kyr Arena Master
+(@CGUID+33, 112577, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1021.997, 7125.033, 97.78559, 4.873281, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Weaponmaster Asvard
+(@CGUID+34, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1002.779, 7112.72, 97.79243, 5.494812, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+35, 112357, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1008.24, 7138.466, 98.09775, 5.087465, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Conqueror's Battlegear Set
+(@CGUID+36, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1009.476, 7069.135, 97.7838, 1.230678, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+37, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1068.148, 7099.457, 98.06343, 0.4467911, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_weapon_inspector_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+38, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 996.0295, 7088.243, 97.7838, 0.5178266, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+39, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1053.821, 7059.55, 98.34373, 4.876904, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_weapon_inspector_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+40, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1013.844, 7066.76, 97.7838, 1.091989, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+41, 107494, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1022.26, 7065.905, 101.786, 4.937614, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Val'kyr Arena Master
+(@CGUID+42, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1055.898, 7089.155, 97.78381, 3.174177, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+43, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 996.283, 7100.035, 97.78442, 6.270727, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+44, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1000.828, 7078.397, 97.7838, 0.4620249, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+45, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1037.589, 7066.596, 97.78381, 2.381599, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+46, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1041.092, 7068.59, 97.78381, 2.431519, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+47, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 981.2535, 7083.415, 98.34373, 3.51726, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_weapon_inspector_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+48, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1055.465, 7101.055, 97.78791, 3.54066, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+49, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1049.63, 7075.854, 97.78381, 2.568862, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+50, 107483, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1041.01, 7048.68, 98.34371, 1.974365, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Lesser Sparring Partner
+(@CGUID+51, 107483, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1008.724, 7049.438, 98.34371, 1.227951, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Lesser Sparring Partner
+(@CGUID+52, 107484, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1025.441, 7047.345, 98.34372, 1.575, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Greater Sparring Partner
+(@CGUID+53, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 787.2691, 7141.032, 107.1845, 3.962807, 120, 0, 0, 0, 0, 2, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+54, 96586, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1024.649, 7354.032, 107.6685, 1.500983, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Master Smith Helgar
+(@CGUID+55, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 799.2552, 7240.588, 106.7846, 3.108604, 120, 0, 0, 0, 0, 2, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+56, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 795.0833, 7217.432, 106.7469, 0.12223, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+57, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 795.4566, 7241.323, 106.7465, 6.263709, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+58, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 906.0347, 7238.638, 97.82867, 3.213452, 420, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_incoming_valarjar_aspirant_2', 24015), -- Valarjar Aspirant
+(@CGUID+59, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 783.9618, 7319.146, 107.1622, 5.558975, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+60, 96572, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 781.368, 7140.252, 107.1625, 0.8794658, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Stormforged Valarjar
+(@CGUID+61, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 887.0469, 7215.551, 97.8416, 1.970037, 420, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_incoming_valarjar_aspirant_1', 24015), -- Valarjar Aspirant
+(@CGUID+62, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 838.9618, 7182.88, 107.5491, 2.275736, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Shieldmaiden
+(@CGUID+63, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 839.1059, 7186.208, 107.5515, 3.687696, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Shieldmaiden
+(@CGUID+64, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 840.1702, 7270.393, 107.5516, 2.705152, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Shieldmaiden
+(@CGUID+65, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 828.2902, 7272.351, 107.5846, 2.375442, 120, 0, 0, 0, 0, 2, 0, 0, 0, '', 24015), -- Shieldmaiden
+(@CGUID+66, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 803.6049,7325.532, 107.5846, 4.506814, 540, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_leaving_valarjar_1', 24015), -- Valarjar Aspirant
+(@CGUID+67, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 831.388, 7296.055, 107.5846, 1.930207, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Valarjar Aspirant
+(@CGUID+68, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 809.3837, 7173.368, 107.0277, 5.281168, 120, 0, 0, 0, 0, 2, 0, 0, 0, '', 24015), -- Shieldmaiden
+(@CGUID+69, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 828.7118, 7184.054, 107.556, 5.624679, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+70, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 823.9757, 7169.554, 107.5535, 5.984025, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+71, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 797.1129, 7270.123, 107.5464, 1.396805, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+72, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 819.7847, 7292.21, 107.5571, 0.6717078, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Shieldmaiden
+(@CGUID+73, 113300, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 814.1077, 7229.027, 106.7456, 3.15387, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Image of Thorim
+(@CGUID+74, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 820.4601, 7153.763, 107.5452, 0.8983396, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Shieldmaiden
+(@CGUID+75, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 812.2892, 7286.124, 106.7846, 4.526197, 120, 0, 0, 0, 0, 2, 0, 0, 0, '', 24015), -- Valarjar Aspirant
+(@CGUID+76, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 805.3559, 7189.577, 107.5568, 4.634243, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+77, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 824.0938, 7156.772, 107.554, 2.579204, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Shieldmaiden
+(@CGUID+78, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 829.4011, 7162.335, 107.5629, 2.534826, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+79, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 828.6077, 7180.745, 107.5552, 0.9823219, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+80, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 827.3924, 7285.477, 107.5528, 0.9050231, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+81, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 822.0504, 7291.395, 107.5548, 0.8406721, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+82, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 839.9896, 7276.862, 107.5461, 3.406442, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+83, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1046.743, 7116.038, 97.79204, 4.075095, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_spectating_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+84, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 798.8055, 7167.791, 107.5566, 3.21311, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+85, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 818.2708, 7151.954, 107.5402, 3.27984, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+86, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 795.5208, 7295.604, 107.5576, 2.931253, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+87, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 814.1736, 7311.827, 107.5468, 5.071805, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+88, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 821.4045, 7304.61, 107.5438, 3.961463, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+89, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 843.809, 7283.556, 107.4719, 3.633651, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Valarjar Aspirant
+(@CGUID+90, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 807.2465, 7269.116, 107.5579, 3.195144, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+91, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 840.3403, 7172.121, 107.4872, 2.919409, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Valarjar Aspirant
+(@CGUID+92, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 831.3125, 7274.136, 107.5543, 1.661897, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+93, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 793.7621, 7192.156, 107.4274, 6.169437, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Valarjar Aspirant
+(@CGUID+94, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 797.5504, 7279.313, 107.5523, 5.85173, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Shieldmaiden
+(@CGUID+95, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 794.342, 7181.619, 107.5434, 5.917163, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Shieldmaiden
+(@CGUID+96, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 797.0816, 7274.227, 107.5485, 5.371294, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+97, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 784.0087, 7167.393, 107.5416, 5.713745, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Shieldmaiden
+(@CGUID+98, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 789.3386, 7161.089, 107.5541, 2.545176, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+99, 113270, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 798.5434, 7293.633, 107.5581, 4.832476, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Shieldmaiden
+(@CGUID+100, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 815.0625, 7149.273, 107.5412, 1.924815, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+101, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 796.5729, 7165.526, 107.5567, 1.24369, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+102, 103810, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 807.7656, 7309.16, 109.6824, 3.487215, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Renfield
+(@CGUID+103, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 804.5729, 7146.695, 107.5489, 0.8699546, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+104, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 793.0313, 7298.327, 107.5576, 5.071805, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+105, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 776.6667, 7302.682, 107.3829, 5.628316, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Valarjar Aspirant
+(@CGUID+106, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 800.3316, 7325.029, 107.3884, 5.443239, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Valarjar Aspirant
+(@CGUID+107, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 810.6476, 7301.071, 107.5587, 2.769743, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+108, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 808.6337, 7303.242, 107.5587, 0.4036042, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+109, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 808.1007, 7312.498, 107.5525, 5.614032, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+110, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 805.4045, 7185.153, 107.5569, 2.049371, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+111, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 795.6667, 7181.746, 107.5449, 0.1131875, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+112, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 829.2587, 7191.175, 107.5606, 0.1131875, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+113, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 794.6996, 7282.824, 107.5476, 0.7188638, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+114, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 817.0955, 7309.072, 107.5454, 3.461222, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+115, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 788.6007, 7174.139, 107.4175, 5.679673, 120, 0, 0, 0, 0, 0, 0, 0, 0, '', 24015), -- Valarjar Aspirant
+(@CGUID+116, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 831.092, 7277.778, 107.5537, 5.071805, 120, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_feasting_valarjar', 24015), -- Valarjar Aspirant
+(@CGUID+117, 93819, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 993.75, 7323.065, 123.6135, 5.650713, 30, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_valkyr_of_odyn_1', 24015), -- Val'kyr of Odyn
+(@CGUID+118, 93819, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1110.443, 7213.999, 17.28479, 3.149208, 30, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_valkyr_of_odyn_2', 24015), -- Val'kyr of Odyn
+(@CGUID+119, 93819, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1124.51, 7222.31, 42.15336, 3.232374, 30, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_valkyr_of_odyn_3', 24015), -- Val'kyr of Odyn
+(@CGUID+120, 93819, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 912.2222, 7205.531, 129.2773, 6.190696, 30, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_valkyr_of_odyn_4', 24015), -- Val'kyr of Odyn
+(@CGUID+121, 93819, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1039.444, 7133.647, 106.5698, 3.696915, 30, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_valkyr_of_odyn_5', 24015), -- Val'kyr of Odyn
+(@CGUID+122, 93819, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1107.887, 7234.073, 54.97818, 3.075214, 30, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_valkyr_of_odyn_6', 24015), -- Val'kyr of Odyn
+(@CGUID+123, 93819, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 1065.42, 7306.094, 117.8158, 2.302904, 30, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_valkyr_of_odyn_7', 24015), -- Val'kyr of Odyn
+(@CGUID+124, 96401, 1479, 7813, 7813, '0', 5997, 0, 0, 0, 771.441, 7159.936, 107.5405, 6.036823, 600, 0, 0, 0, 0, 0, 0, 0, 0, 'npc_leaving_valarjar_2', 24015); -- Valarjar Aspirant
+
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+124;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(@CGUID+2, 0, 0, 0, 1, 0, 12290, 0, 0, ''), -- Battlelord's Armor
+(@CGUID+4, 0, 0, 50331648, 1, 0, 0, 0, 0, '223760'), -- Ymirjar Lord's Set - 223760 - Ymirjar Lord's Set
+(@CGUID+6, 0, 0, 50331648, 1, 0, 0, 0, 0, '223743'), -- Onslaught Set - 223743 - Onslaught Set
+(@CGUID+7, 0, 0, 1, 1, 0, 0, 0, 0, ''), -- Odyn
+(@CGUID+8, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Fjornson Stonecarver
+(@CGUID+12, 0, 0, 50331648, 1, 0, 0, 0, 0, '223746'), -- Heroes' Dreadnaught Set - 223746 - Heroes' Dreadnaught Set
+(@CGUID+13, 0, 0, 50331648, 1, 0, 0, 0, 0, '223759'), -- Hellscream's Conquest Set - 223759 - Hellscream's Conquest Set
+(@CGUID+15, 0, 0, 50331648, 1, 0, 0, 0, 0, '223749'), -- Valorous Siegebreaker Set - 223749 - Valorous Siegebreaker Set
+(@CGUID+16, 0, 0, 50331648, 1, 0, 0, 0, 0, '223752'), -- Wrynn's Conquest Set - 223752 - Wrynn's Conquest Set
+(@CGUID+18, 0, 0, 50331648, 1, 0, 0, 0, 0, '223717'), -- Warbringer Armor Set - 223717 - Warbringer Armor Set
+(@CGUID+20, 0, 0, 50331648, 1, 0, 0, 0, 0, '223739'), -- Destroyer Armor Set - 223739 - Destroyer Armor Set
+(@CGUID+21, 0, 0, 0, 1, 0, 0, 0, 0, '98892'), -- Greater Sparring Partner - 98892 - Training Dummy Marker
+(@CGUID+22, 0, 0, 0, 1, 0, 0, 0, 0, '98892'), -- Lesser Sparring Partner - 98892 - Training Dummy Marker
+(@CGUID+26, 0, 0, 50331648, 1, 0, 0, 0, 0, '223705'), -- Battlegear of Wrath Set - 223705 - Battlegear of Wrath Set
+(@CGUID+29, 0, 0, 50331648, 1, 0, 0, 0, 0, '223700'), -- Battlegear of Might Set - 223700 - Battlegear of Might Set
+(@CGUID+33, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Weaponmaster Asvard
+(@CGUID+35, 0, 0, 50331648, 1, 0, 0, 0, 0, '223709'), -- Conqueror's Battlegear Set - 223709 - Conqueror's Battlegear Set
+(@CGUID+50, 0, 0, 0, 1, 0, 0, 0, 0, '98892'), -- Lesser Sparring Partner - 98892 - Training Dummy Marker
+(@CGUID+51, 0, 0, 0, 1, 0, 0, 0, 0, '98892'), -- Lesser Sparring Partner - 98892 - Training Dummy Marker
+(@CGUID+52, 0, 0, 0, 1, 0, 0, 0, 0, '98892'), -- Greater Sparring Partner - 98892 - Training Dummy Marker
+(@CGUID+54, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Master Smith Helgar
+(@CGUID+73, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Image of Thorim
+(@CGUID+89, 0, 0, 0, 1, 426, 0, 0, 0, ''), -- Valarjar Aspirant
+(@CGUID+91, 0, 0, 0, 1, 426, 0, 0, 0, ''), -- Valarjar Aspirant
+(@CGUID+93, 0, 0, 0, 1, 426, 0, 0, 0, ''), -- Valarjar Aspirant
+(@CGUID+105, 0, 0, 0, 1, 426, 0, 0, 0, ''), -- Valarjar Aspirant
+(@CGUID+106, 0, 0, 0, 1, 426, 0, 0, 0, ''), -- Valarjar Aspirant
+(@CGUID+115, 0, 0, 0, 1, 426, 0, 0, 0, ''); -- Valarjar Aspirant
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (93823, 93819, 96401, 113270, 96572, 103810, 107494, 96679);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(93823, 0, 0, 50331648, 1, 0, 0, 0, 0, ''), -- Danica the Reclaimer
+(93819, 0, 0, 50331648, 1, 0, 0, 0, 0, ''), -- Val'kyr of Odyn
+(96401, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Valarjar Aspirant
+(113270, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- Shieldmaiden
+(96572, 0, 0, 0, 1, 0, 0, 0, 0, '52642'), -- Stormforged Valarjar - 52642 - Dull Weapons
+(103810, 0, 0, 0, 1, 0, 0, 0, 0, '205607'), -- Renfield - 205607 - Boosted
+(107494, 0, 0, 33554432, 1, 0, 0, 0, 0, ''), -- Val'kyr Arena Master
+(96679, 0, 0, 0, 1, 0, 0, 0, 0, ''); -- Aerylia
+
+-- Pathing for Quartermaster Durnolf
+SET @PATH := (@CGUID+0) * 10;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID+0;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(@CGUID+0, @PATH, 0, 0, 1, 0, 0, 0, 0, '');
+
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(@PATH, 1, 1078.332, 7249.874, 97.78458, 0.5061455, 15000, 0, 0, 100, 0),
+(@PATH, 2, 1076.599, 7248.414, 97.78458, 0, 0, 0, 0, 100, 0),
+(@PATH, 3, 1072.833, 7244.781, 97.78458, 2.251475, 15000, 0, 0, 100, 0);
+
+-- Pathing for Stormforged Valarjar
+SET @PATH := (@CGUID+14) * 10;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID+14;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(@CGUID+14, @PATH, 0, 0, 1, 0, 0, 0, 0, '52642'); -- Stormforged Valarjar - 52642 - Dull Weapons
+
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(@PATH, 1, 1059.355, 7109.143, 98.03021, 0, 0, 0, 0, 100, 0),
+(@PATH, 2, 1062.14, 7098.445, 98.09122, 0, 0, 0, 0, 100, 0),
+(@PATH, 3, 1062.212, 7086.201, 98.07793, 0, 0, 0, 0, 100, 0),
+(@PATH, 4, 1057.238, 7073.042, 98.07264, 0, 0, 0, 0, 100, 0),
+(@PATH, 5, 1050.738, 7066.218, 97.85432, 0, 0, 0, 0, 100, 0),
+(@PATH, 6, 1041.468, 7059.611, 98.03458, 0, 0, 0, 0, 100, 0),
+(@PATH, 7, 1035.233, 7057.516, 98.04141, 0, 0, 0, 0, 100, 0),
+(@PATH, 8, 1030.441, 7056.395, 98.03458, 0, 0, 0, 0, 100, 0),
+(@PATH, 9, 1016.19, 7057.544, 98.03458, 0, 0, 0, 0, 100, 0),
+(@PATH, 10, 1001.354, 7064.85, 98.03457, 0, 0, 0, 0, 100, 0),
+(@PATH, 11, 999.6281, 7066.602, 98.03458, 0, 0, 0, 0, 100, 0),
+(@PATH, 12, 991.1783, 7078.769, 98.05251, 0, 0, 0, 0, 100, 0),
+(@PATH, 13, 988.2833, 7090.929, 98.04587, 0, 0, 0, 0, 100, 0),
+(@PATH, 14, 988.7699, 7102.168, 98.06433, 0, 0, 0, 0, 100, 0),
+(@PATH, 15, 991.3452, 7110.406, 98.0473, 0, 0, 0, 0, 100, 0),
+(@PATH, 16, 997.7927, 7119.614, 98.03343, 0, 0, 0, 0, 100, 0),
+(@PATH, 17, 1007.708, 7127.708, 98.04001, 0, 0, 0, 0, 100, 0),
+(@PATH, 18, 1009.347, 7128.678, 98.05522, 0, 0, 0, 0, 100, 0),
+(@PATH, 19, 1024.143, 7130.562, 98.03651, 0, 0, 0, 0, 100, 0),
+(@PATH, 20, 1033.394, 7130.59, 97.83824, 0, 0, 0, 0, 100, 0),
+(@PATH, 21, 1035.905, 7129.8, 98.03458, 0, 0, 0, 0, 100, 0),
+(@PATH, 22, 1039.673, 7128.535, 98.06012, 0, 0, 0, 0, 100, 0),
+(@PATH, 23, 1050.871, 7120.234, 98.03458, 0, 0, 0, 0, 100, 0);
+
+-- Pathing for Stormforged Valarjar
+SET @PATH := (@CGUID+9) * 10;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID+9;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(@CGUID+9, @PATH, 0, 0, 1, 0, 0, 0, 0, '52642'); -- Stormforged Valarjar - 52642 - Dull Weapons
+
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(@PATH, 1, 899.703, 7219.97, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 2, 909.387, 7216.78, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 3, 919.976, 7216.32, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 4, 932.529, 7216.02, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 5, 945.434, 7216.09, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 6, 956.3, 7216.17, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 7, 965.25, 7216.12, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 8, 976.085, 7217.55, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 9, 984.035, 7218.43, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 10, 991.854, 7220.49, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 11, 995.995, 7220.9, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 12, 998.682, 7220.46, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 13, 1000.88, 7217.52, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 14, 1003.06, 7213.05, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 15, 1006.04, 7208.53, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 16, 1010.58, 7203.69, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 17, 1016.79, 7200.38, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 18, 1020.13, 7198.14, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 19, 1022.56, 7194.85, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 20, 1023.03, 7190.72, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 21, 1022.07, 7185.97, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 22, 1021.28, 7180.11, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 23, 1020.18, 7171.65, 97.7846, 0, 14000, 0, 0, 100, 0),
+(@PATH, 24, 1028.04, 7170.89, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 25, 1033.46, 7173.44, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 26, 1034.11, 7178.06, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 27, 1033.23, 7181.86, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 28, 1032.5, 7189.42, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 29, 1032.85, 7195.41, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 30, 1036.11, 7198.49, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 31, 1041.39, 7201.25, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 32, 1045.58, 7204.88, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 33, 1048.67, 7207.85, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 34, 1052.05, 7212.5, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 35, 1054.7, 7216.44, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 36, 1055.88, 7220.42, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 37, 1060.33, 7221.08, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 38, 1065.39, 7218.43, 97.8289, 0, 0, 0, 0, 100, 0),
+(@PATH, 39, 1068.39, 7214.8, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 40, 1068.32, 7209.8, 97.7846, 0, 15000, 0, 0, 100, 0),
+(@PATH, 41, 1065.41, 7217.37, 97.8214, 0, 0, 0, 0, 100, 0),
+(@PATH, 42, 1061.24, 7219.92, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 43, 1056.07, 7221.62, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 44, 1053.59, 7226.19, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 45, 1053.6, 7231.76, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 46, 1053.44, 7238.03, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 47, 1049.05, 7243.52, 97.8326, 0, 0, 0, 0, 100, 0),
+(@PATH, 48, 1045.87, 7246.58, 97.8975, 0, 0, 0, 0, 100, 0),
+(@PATH, 49, 1042.33, 7249.42, 97.9682, 0, 0, 0, 0, 100, 0),
+(@PATH, 50, 1039.85, 7250.54, 97.7845, 0, 0, 0, 0, 100, 0),
+(@PATH, 51, 1036.55, 7252.61, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 52, 1034.29, 7254.71, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 53, 1034.21, 7258.83, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 54, 1034.25, 7263.33, 97.8129, 0, 0, 0, 0, 100, 0),
+(@PATH, 55, 1034.49, 7266.94, 97.8577, 0, 0, 0, 0, 100, 0),
+(@PATH, 56, 1034.63, 7269.23, 97.8861, 0, 13000, 0, 0, 100, 0),
+(@PATH, 57, 1029.1, 7268.52, 97.8802, 0, 0, 0, 0, 100, 0),
+(@PATH, 58, 1025.21, 7262.77, 97.8107, 0, 0, 0, 0, 100, 0),
+(@PATH, 59, 1024.41, 7258.54, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 60, 1023.33, 7254.99, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 61, 1019.39, 7252.49, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 62, 1015.62, 7250.6, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 63, 1010.78, 7247.79, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 64, 1006.78, 7244.65, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 65, 1003.78, 7239.71, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 66, 1001.31, 7234.52, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 67, 1000.29, 7231.48, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 68, 995.401, 7230.75, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 69, 988.91, 7231.11, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 70, 985.299, 7232.55, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 71, 978.115, 7235.72, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 72, 970.783, 7235.44, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 73, 963.299, 7235.57, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 74, 952.04, 7236, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 75, 941.611, 7236.31, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 76, 922.184, 7236.51, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 77, 901.578, 7237.24, 97.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 78, 886.344, 7237.96, 97.7846, 0, 15000, 0, 0, 100, 0);
+
+-- Pathing for Stormforged Valarjar
+SET @PATH := (@CGUID+55) * 10;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID+55;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(@CGUID+55, @PATH, 0, 0, 1, 0, 0, 0, 0, '52642'); -- Stormforged Valarjar - 52642 - Dull Weapons
+
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(@PATH, 1, 799.2552, 7240.588, 106.7846, 0, 15000, 0, 0, 100, 0),
+(@PATH, 2, 803.5764, 7240.032, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 3, 807.1285, 7241.317, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 4, 809.2222, 7248.132, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 5, 811.243, 7253.938, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 6, 814.2976, 7259.448, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 7, 813.4879, 7265.893, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 8, 813.4063, 7275.651, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 9, 813.8004, 7283.113, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 10, 810.0226, 7288.268, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 11, 803.0785, 7294.741, 106.8754, 0, 0, 0, 0, 100, 0),
+(@PATH, 12, 792.852, 7305.193, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 13, 784.3941, 7313.585, 107.1845, 0, 15000, 0, 0, 100, 0),
+(@PATH, 14, 792.852, 7305.193, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 15, 803.0785, 7294.741, 106.8754, 0, 0, 0, 0, 100, 0),
+(@PATH, 16, 810.0226, 7288.268, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 17, 813.8004, 7283.113, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 18, 813.4063, 7275.651, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 19, 813.4879, 7265.893, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 20, 814.2976, 7259.448, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 21, 811.243, 7253.938, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 22, 809.2222, 7248.132, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 23, 807.1285, 7241.317, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 24, 803.5764, 7240.032, 106.7846, 0, 0, 0, 0, 100, 0);
+
+-- Pathing for Stormforged Valarjar
+SET @PATH := (@CGUID+53) * 10;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID+53;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(@CGUID+53, @PATH, 0, 0, 1, 0, 0, 0, 0, '52642'); -- Stormforged Valarjar - 52642 - Dull Weapons
+
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(@PATH, 1, 787.2691, 7141.032, 107.1845, 0, 15000, 0, 0, 100, 0),
+(@PATH, 2, 791.7396, 7145.578, 107.0109, 0, 0, 0, 0, 100, 0),
+(@PATH, 3, 795.9323, 7149.517, 106.8352, 0, 0, 0, 0, 100, 0),
+(@PATH, 4, 801.4167, 7155.145, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 5, 806.757, 7160.366, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 6, 812.3542, 7166.497, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 7, 817.4305, 7172.878, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 8, 819.4948, 7179.916, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 9, 819.6927, 7189.042, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 10, 820.6406, 7199.277, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 11, 824.2413, 7201.967, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 12, 828.4722, 7203.042, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 13, 832.0208, 7204.906, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 14, 835.8264, 7208.015, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 15, 839.2604, 7211.28, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 16, 845.6389, 7213.393, 106.7846, 0, 15000, 0, 0, 100, 0),
+(@PATH, 17, 839.2604, 7211.28, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 18, 835.8264, 7208.015, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 19, 832.0208, 7204.906, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 20, 828.4722, 7203.042, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 21, 824.2413, 7201.967, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 22, 820.6406, 7199.277, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 23, 819.6927, 7189.042, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 24, 819.4948, 7179.916, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 25, 817.4305, 7172.878, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 26, 812.3542, 7166.497, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 27, 806.757, 7160.366, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 28, 801.4167, 7155.145, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 29, 795.9323, 7149.517, 106.8352, 0, 0, 0, 0, 100, 0),
+(@PATH, 30, 791.7396, 7145.578, 107.0109, 0, 0, 0, 0, 100, 0);
+
+-- Start Mead Hall
+
+-- Pathing for Shieldmaiden
+SET @PATH := (@CGUID+65) * 10;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID+65;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(@CGUID+65, @PATH, 0, 0, 1, 0, 0, 0, 0, ''); -- Shieldmaiden
+
+-- missing emotes
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(@PATH, 1, 821.6458, 7278.744, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 2, 817.5417, 7284.403, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 3, 813.7292, 7289.004, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 4, 809.7726, 7291.155, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 5, 806.7186, 7288.294, 107.5844, 0, 0, 0, 0, 100, 0),
+(@PATH, 6, 802.8837, 7288.68, 107.5846, 0, 0, 0, 0, 100, 0),
+(@PATH, 7, 801.5521, 7290.084, 107.5846, 0, 20000, 0, 0, 100, 0),
+(@PATH, 8, 806.4844, 7289.871, 107.2425, 0, 0, 0, 0, 100, 0),
+(@PATH, 9, 810.8333, 7287.885, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 10, 815.3386, 7283.011, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 11, 818.4531, 7278.502, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 12, 822.3646, 7270.632, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 13, 826.1702, 7270.191, 107.5846, 0, 0, 0, 0, 100, 0),
+(@PATH, 14, 830.4688, 7270.254, 107.5846, 0, 20000, 0, 0, 100, 0);
+
+-- Pathing for Valarjar Aspirant
+SET @PATH := (@CGUID+75) * 10;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID+75;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(@CGUID+75, @PATH, 0, 0, 1, 0, 0, 0, 0, ''); -- Valarjar Aspirant
+
+-- missing emotes
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(@PATH, 1, 807.4114, 7278.075, 107.5846, 0, 15000, 0, 0, 100, 0),
+(@PATH, 2, 814.585, 7297.916, 107.5846, 0, 15000, 0, 0, 100, 0),
+(@PATH, 3, 812.8472, 7289.086, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 4, 811.0191, 7279.381, 106.7846, 0, 0, 0, 0, 100, 0);
+
+-- Shieldmaiden
+SET @PATH := (@CGUID+68) * 10;
+
+DELETE FROM `creature_addon` WHERE `guid`=@CGUID+68;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(@CGUID+68, @PATH, 0, 0, 1, 0, 0, 0, 0, ''); -- Shieldmaiden
+
+-- missing emotes
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(@PATH, 1, 810.806, 7163.271, 106.8967, 0, 0, 0, 0, 100, 0),
+(@PATH, 2, 813.4445, 7160.912, 107.6182, 0, 20000, 0, 0, 100, 0),
+(@PATH, 3, 808.9236, 7166.083, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 4, 809.0608, 7170.817, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 5, 810.1614, 7177.255, 106.7846, 0, 0, 0, 0, 100, 0),
+(@PATH, 6, 806.1841, 7178.373, 107.5846, 0, 15000, 0, 0, 100, 0),
+(@PATH, 7, 812.059, 7169.183, 106.7846, 0, 0, 0, 0, 100, 0);
+
+-- End Mead Hall
+
+-- Creature Equip Templates
+DELETE FROM `creature_equip_template` WHERE (`CreatureID`=103810 AND `ID`=1) OR (`CreatureID`=96586 AND `ID`=1) OR (`CreatureID`=107484 AND `ID`=1) OR (`CreatureID`=107483 AND `ID`=1) OR (`CreatureID`=112577 AND `ID`=1) OR (`CreatureID`=107494 AND `ID`=1) OR (`CreatureID`=114559 AND `ID`=1) OR (`CreatureID`=114558 AND `ID`=1) OR (`CreatureID`=96572 AND `ID`=1) OR (`CreatureID`=96679 AND `ID`=1) OR (`CreatureID`=93823 AND `ID`=1) OR (`CreatureID`=112392 AND `ID`=1);
+INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`) VALUES
+(103810, 1, 83019, 0, 0, 0, 0, 0, 0, 0, 0), -- Renfield
+(96586, 1, 7956, 0, 0, 0, 0, 0, 0, 0, 0), -- Master Smith Helgar
+(107484, 1, 137174, 0, 0, 137266, 0, 0, 0, 0, 0), -- Greater Sparring Partner
+(107483, 1, 137263, 0, 0, 137264, 0, 0, 0, 0, 0), -- Lesser Sparring Partner
+(112577, 1, 140747, 0, 0, 0, 0, 0, 0, 0, 0), -- Weaponmaster Asvard
+(107494, 1, 137262, 0, 0, 0, 0, 0, 0, 0, 0), -- Val'kyr Arena Master
+(114559, 1, 137263, 0, 0, 137264, 0, 0, 0, 0, 0), -- Lesser Sparring Partner
+(114558, 1, 137263, 0, 0, 140748, 0, 0, 0, 0, 0), -- Greater Sparring Partner
+(96572, 1, 137174, 0, 0, 140748, 0, 0, 0, 0, 0), -- Stormforged Valarjar
+(96679, 1, 140345, 0, 0, 0, 0, 0, 0, 0, 0), -- Aerylia
+(93823, 1, 140345, 0, 0, 0, 0, 0, 0, 0, 0), -- Danica the Reclaimer
+(112392, 1, 140747, 0, 0, 0, 0, 0, 0, 0, 0); -- Quartermaster Durnolf
+
+UPDATE `creature_template` SET `minlevel`=100, `maxlevel`=100, `speed_walk`=0.888888, `BaseAttackTime`=1500, `RangeAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry`=103810; -- Renfield
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `faction`=2141, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=33587264, `unit_flags2`=2048, `VehicleId`=4866 WHERE `entry`=113300; -- Image of Thorim
+UPDATE `creature_template` SET `minlevel`=98, `maxlevel`=110, `speed_run`=1.285714, `BaseAttackTime`=1000, `RangeAttackTime`=2000, `unit_flags2`=2048, `InhabitType`=1 WHERE `entry`=113270; -- Shieldmaiden
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `npcflag`=134217731, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2048 WHERE `entry`=96586; -- Master Smith Helgar
+UPDATE `creature_template` SET `minlevel`=113, `maxlevel`=113, `faction`=7, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=131072, `unit_flags2`=2048 WHERE `entry`=107484; -- Greater Sparring Partner
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `faction`=7, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=131072, `unit_flags2`=2048 WHERE `entry`=107483; -- Lesser Sparring Partner
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112357; -- Conqueror's Battlegear Set
+UPDATE `creature_template` SET `minlevel`=5, `maxlevel`=5, `npcflag`=1, `speed_run`=1, `BaseAttackTime`=1500, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=112577; -- Weaponmaster Asvard
+UPDATE `creature_template` SET `minlevel`=100, `maxlevel`=100, `npcflag`=1, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=2, `unit_flags`=33536, `unit_flags2`=18432, `HoverHeight`=2.8 WHERE `entry`=107494; -- Val'kyr Arena Master
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112353; -- Battlegear of Might Set
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112356; -- Battlegear of Wrath Set
+UPDATE `creature_template` SET `minlevel`=112, `maxlevel`=112, `faction`=7, `BaseAttackTime`=1500, `RangeAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=114559; -- Lesser Sparring Partner
+UPDATE `creature_template` SET `minlevel`=113, `maxlevel`=113, `faction`=7, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=114558; -- Greater Sparring Partner
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112390; -- Destroyer Armor Set
+UPDATE `creature_template` SET `minlevel`=98, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `ScriptName`='' WHERE `entry`=96401; -- Valarjar Aspirant
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112361; -- Warbringer Armor Set
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112416; -- Wrynn's Conquest Set
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112413; -- Valorous Siegebreaker Set
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112418; -- Hellscream's Conquest Set
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112408; -- Heroes' Dreadnaught Set
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `npcflag`=3, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=8, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=111741; -- Fjornson Stonecarver
+UPDATE `creature_template` SET `minlevel`=111, `maxlevel`=111, `npcflag`=3, `speed_run`=1, `BaseAttackTime`=1500, `RangeAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=4196352, `ScriptName`='npc_odyn' WHERE `entry`=96469; -- Odyn
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112400; -- Onslaught Set
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=32832, `unit_flags2`=2099200 WHERE `entry`=96572; -- Stormforged Valarjar
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=112420; -- Ymirjar Lord's Set
+UPDATE `creature_template` SET `minlevel`=100, `maxlevel`=100, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=2, `unit_flags`=33536, `unit_flags2`=18432, `HoverHeight`=2.8, `InhabitType`=2|4 WHERE `entry`=93819; -- Val'kyr of Odyn
+UPDATE `creature_template` SET `minlevel`=100, `maxlevel`=100, `npcflag`=1, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=2, `unit_flags`=33536, `unit_flags2`=18432, `HoverHeight`=2.8 WHERE `entry`=96679; -- Aerylia
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_flags`=768, `unit_flags2`=67110912 WHERE `entry`=116609; -- Battlelord's Armor
+UPDATE `creature_template` SET `minlevel`=100, `maxlevel`=100, `npcflag`=3, `speed_run`=1, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=2, `unit_flags`=33536, `unit_flags2`=18432, `HoverHeight`=2.8, `InhabitType`=6, `ScriptName`='npc_danica_the_reclaimer' WHERE `entry`=93823; -- Danica the Reclaimer
+UPDATE `creature_template` SET `minlevel`=110, `maxlevel`=110, `npcflag`=4227, `BaseAttackTime`=2000, `RangeAttackTime`=2000, `unit_class`=2, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=112392; -- Quartermaster Durnolf
+
+UPDATE `creature_model_info` SET `BoundingRadius`=0.31, `CombatReach`=1.1, `VerifiedBuild`=24015 WHERE `DisplayID`=40994;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=25799;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=25204;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.31, `CombatReach`=1.5, `VerifiedBuild`=24015 WHERE `DisplayID`=71252;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=25801;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=25800;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=42722;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=42720;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.509789, `CombatReach`=1.875, `VerifiedBuild`=24015 WHERE `DisplayID`=67956;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=65680;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=65678;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=65679;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=70110;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=65681;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.748563, `CombatReach`=0.6, `VerifiedBuild`=24015 WHERE `DisplayID`=67162;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.449397, `CombatReach`=1.8, `VerifiedBuild`=24015 WHERE `DisplayID`=67937;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.509789, `CombatReach`=1.875, `VerifiedBuild`=24015 WHERE `DisplayID`=67938;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.831403, `CombatReach`=1.729, `VerifiedBuild`=24015 WHERE `DisplayID`=73429;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=67230;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.328614, `CombatReach`=1.65, `VerifiedBuild`=24015 WHERE `DisplayID`=67361;
+UPDATE `creature_model_info` SET `VerifiedBuild`=24015 WHERE `DisplayID`=21342;
+UPDATE `creature_model_info` SET `BoundingRadius`=2.03999, `CombatReach`=0.7, `VerifiedBuild`=24015 WHERE `DisplayID`=67161;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.306, `CombatReach`=1.5, `VerifiedBuild`=24015 WHERE `DisplayID`=74255;
+UPDATE `creature_model_info` SET `BoundingRadius`=2.03999, `CombatReach`=0.7, `VerifiedBuild`=24015 WHERE `DisplayID`=73300;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.3645831, `CombatReach`=1.575, `VerifiedBuild`=24015 WHERE `DisplayID`=72055;
+
+DELETE FROM `creature_queststarter` WHERE `id`=93823 AND `quest`=39654;
+INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
+(93823, 39654);
+
+DELETE FROM `scene_template` WHERE `SceneId` IN (1109);
+INSERT INTO `scene_template` (`SceneId`, `Flags`, `ScriptPackageID`, `ScriptName`) VALUES
+(1109, 11, 1489, 'scene_odyn_intro');
+
+DELETE FROM `phase_area` WHERE (`AreaId`=7813 AND `PhaseId`=5997) OR (`AreaId`=7813 AND `PhaseId`=5090) OR (`AreaId`=7813 AND `PhaseId`=5107);
+INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
+(7813, 5997, 'Warrior Order Hall - Default phase'),
+(7813, 5107, 'Warrior Order Hall - Odyn\'s phase'),
+(7813, 5090, 'Warrior Order Hall - Starting phase - Removed when quest 39654 (Odyn and the Valarjar) is completed or rewarded');
+
+DELETE FROM `graveyard_zone` WHERE `ID`=5358;
+INSERT INTO `graveyard_zone` (`ID`, `GhostZone`, `Comment`) VALUES
+(5358, 7813, 'Warrior Order Hall - Default Graveyard');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup`=5090 AND `SourceEntry`=7813;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `NegativeCondition`, `Comment`) VALUES
+(26, 5090, 7813, 0, 8, 39654, 1, 'Only in phase 5090 when quest 39654 not rewarded'),
+(26, 5090, 7813, 0, 28, 39654, 1, 'Only in phase 5090 when quest 39654 not completed');
+
+DELETE FROM `creature_text` WHERE `CreatureID`=93823;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `comment`) VALUES
+(93823, 0, 0, 'Welcome to Skyhold! Here the brave live on forever!', 12, 0, 100, 0, 0, 60356, 98601, 'Danica the Reclaimer to Player'),
+(93823, 1, 0, 'Behind you lies the Eye of Odyn, which peers across all of Azeroth! This way lies the Forge, where the mightiest weapons of the valarjar are crafted by Helgar, the greatest smith in the Halls.', 12, 0, 100, 0, 0, 60358, 98370, 'Danica the Reclaimer to Player'),
+(93823, 2, 0, 'Across the way lies the Arena of Glory, where warriors vie for supremacy in epic combat. Before us lies the Great Mead Hall where drink and stories flow freely!', 12, 0, 100, 0, 0, 60359, 105450, 'Danica the Reclaimer to Player'),
+(93823, 3, 0, 'Odyn awaits ahead. I will go forth and announce you. Be respectful!', 12, 0, 100, 0, 0, 60360, 98372, 'Danica the Reclaimer to Player');
+
+DELETE FROM `spell_target_position` WHERE `ID`=193711 AND `EffectIndex`=0;
+INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES
+(193711, 0, 1479, 834.61, 7228.57, 106.67, 24015); -- Spell: Cancel/Complete Scene - Order Formation Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS)
+
+-- GameObjects
+DELETE FROM `gameobject_template` WHERE `entry` IN (250878 /*Training Troops*/, 252887 /*Blessing of Mjolnir*/, 250879 /*Training Troops*/, 267923 /*The Legend of Odyn*/, 248980 /*The Legend of Odyn*/, 252801 /*Artifact Research Notes*/, 250880 /*Training Troops*/, 248979 /*Saga of the Valarjar*/, 267922 /*The Favored of Odyn*/, 248981 /*The Favored of Odyn*/, 258944 /*Warswords of the Valarjar Appearance*/, 244516 /*Valhallas Portal*/, 258942 /*Warswords of the Valarjar Appearance*/, 258943 /*Warswords of the Valarjar Appearance*/, 258945 /*Warswords of the Valarjar Appearance*/, 252016 /*Requisitioned Armaments*/, 245726 /*Forge of Odyn*/);
+INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `RequiredLevel`, `VerifiedBuild`) VALUES
+(250878, 45, 9510, 'Training Troops', '', '', '', 1, 158, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Training Troops
+(252887, 45, 9510, 'Blessing of Mjolnir', '', '', '', 1, 194, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Blessing of Mjolnir
+(250879, 45, 9510, 'Training Troops', '', '', '', 1, 159, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Training Troops
+(267923, 8, 9510, 'The Legend of Odyn', '', '', '', 1, 1915, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- The Legend of Odyn
+(248980, 9, 33174, 'The Legend of Odyn', '', '', '', 1.5, 5268, 0, 8, 0, 42681, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- The Legend of Odyn
+(252801, 45, 15781, 'Artifact Research Notes', '', '', '', 1, 191, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Artifact Research Notes
+(250880, 45, 9510, 'Training Troops', '', '', '', 1, 224, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Training Troops
+(248979, 9, 33173, 'Saga of the Valarjar', '', '', '', 1.5, 5795, 0, 8, 0, 42681, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Saga of the Valarjar
+(267922, 8, 9510, 'The Favored of Odyn', '', '', '', 1, 1914, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- The Favored of Odyn
+(248981, 9, 33174, 'The Favored of Odyn', '', '', '', 1.5, 5269, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- The Favored of Odyn
+(258944, 5, 37956, 'Warswords of the Valarjar Appearance', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Warswords of the Valarjar Appearance
+(244516, 5, 34055, 'Valhallas Portal', '', '', '', 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Valhallas Portal
+(258942, 5, 37958, 'Warswords of the Valarjar Appearance', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Warswords of the Valarjar Appearance
+(258943, 5, 37957, 'Warswords of the Valarjar Appearance', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Warswords of the Valarjar Appearance
+(258945, 5, 37955, 'Warswords of the Valarjar Appearance', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Warswords of the Valarjar Appearance
+(252016, 45, 9510, 'Requisitioned Armaments', '', '', '', 1, 202, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015), -- Requisitioned Armaments
+(245726, 47, 31101, 'Forge of Odyn', '', '', '', 2, 37155, 1, 0, 648, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24015); -- Forge of Odyn
+
+DELETE FROM `gameobject_template_addon` WHERE `entry` IN (250878 /*Training Troops*/, 252887 /*Blessing of Mjolnir*/, 250879 /*Training Troops*/, 252801 /*Artifact Research Notes*/, 250880 /*Training Troops*/, 258944 /*Warswords of the Valarjar Appearance*/, 258945 /*Warswords of the Valarjar Appearance*/, 258943 /*Warswords of the Valarjar Appearance*/, 258942 /*Warswords of the Valarjar Appearance*/, 252016 /*Requisitioned Armaments*/, 245726 /*Forge of Odyn*/, 252064 /*Grand Challenger's Bounty*/, 246280 /*Cylinder Collision (2 Scale)*/);
+INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`) VALUES
+(250878, 0, 262144), -- Training Troops
+(252887, 0, 262144), -- Blessing of Mjolnir
+(250879, 0, 262144), -- Training Troops
+(252801, 0, 262144), -- Artifact Research Notes
+(250880, 0, 262144), -- Training Troops
+(258944, 114, 0), -- Warswords of the Valarjar Appearance
+(258945, 114, 0), -- Warswords of the Valarjar Appearance
+(258943, 114, 0), -- Warswords of the Valarjar Appearance
+(258942, 114, 0), -- Warswords of the Valarjar Appearance
+(252016, 0, 262144), -- Requisitioned Armaments
+(245726, 0, 270336), -- Forge of Odyn
+(252064, 0, 262144), -- Grand Challenger's Bounty
+(246280, 0, 32); -- Cylinder Collision (2 Scale)
+
+SET @OGUID := 46;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+14;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 246280, 1479, 7813, 7813, '0', 5997, 0, 1067.097, 7240.936, 100.5904, 0, 0, 0, 0, 1, 120, 255, 1, 24015), -- Cylinder Collision (2 Scale) (Area: Skyhold - Difficulty: 0)
+(@OGUID+1, 250878, 1479, 7813, 7813, '0', 5997, 0, 1127.615, 7196.929, 99.71751, 2.335665, 0, 0, 0.9199028, 0.3921465, 120, 255, 1, 24015), -- Training Troops (Area: Skyhold - Difficulty: 0)
+(@OGUID+2, 244516, 1479, 7813, 7813, '0', 5997, 0, 1085.462, 7228.605, 47.26785, 1.315875, 0.522438, 0.354455, 0.4989128, 0.5937223, 120, 255, 1, 24015), -- Valhallas Portal (Area: Skyhold - Difficulty: 0)
+(@OGUID+3, 252016, 1479, 7813, 7813, '0', 5997, 0, 1069.146, 7204.144, 97.69034, 0.8474326, 0, 0, 0.4111509, 0.9115673, 120, 255, 1, 24015), -- Requisitioned Armaments (Area: Skyhold - Difficulty: 0)
+(@OGUID+4, 267922, 1479, 7813, 7813, '0', 5997, 0, 1068.727, 7311.191, 109.4267, 0, 0, 0, 0, 1, 120, 255, 1, 24015), -- The Favored of Odyn (Area: Skyhold - Difficulty: 0)
+(@OGUID+5, 250879, 1479, 7813, 7813, '0', 5997, 0, 1128.748, 7249.465, 99.71822, 3.968774, 0, 0, -0.9156837, 0.4018996, 120, 255, 1, 24015), -- Training Troops (Area: Skyhold - Difficulty: 0)
+(@OGUID+6, 259095, 1479, 7813, 7813, '0', 5997, 0, 1142.71, 7223.2, 101.819, 0, 0, 0, 0, 1, 120, 255, 1, 24015), -- [DNT] Command Table Collision Cylinder (Area: Skyhold - Difficulty: 0)
+(@OGUID+7, 248981, 1479, 7813, 7813, '0', 5997, 0, 1069.054, 7311.249, 109.4267, 0.9491548, 0, 0, 0.4569626, 0.8894859, 120, 255, 1, 24015), -- The Favored of Odyn (Area: Skyhold - Difficulty: 0)
+(@OGUID+8, 250880, 1479, 7813, 7813, '0', 5997, 0, 1122.059, 7253.297, 99.71768, 3.91156, 0, 0, -0.9268045, 0.3755441, 120, 255, 1, 24015), -- Training Troops (Area: Skyhold - Difficulty: 0)
+(@OGUID+9, 252887, 1479, 7813, 7813, '0', 5997, 0, 1054.125, 7132.937, 98.26038, 5.665893, 0, 0, -0.3037691, 0.9527457, 120, 255, 1, 24015), -- Blessing of Mjolnir (Area: Skyhold - Difficulty: 0)
+(@OGUID+10, 248979, 1479, 7813, 7813, '0', 5997, 0, 1074.019, 7322.522, 109.4267, 0, 0, 0, 0, 1, 120, 255, 1, 24015), -- Saga of the Valarjar (Area: Skyhold - Difficulty: 0)
+(@OGUID+11, 245726, 1479, 7813, 7813, '0', 5997, 0, 1030.769, 7361.063, 107.3078, 4.673286, -0.001883507, -0.01285458, -0.7206783, 0.6931479, 120, 255, 1, 24015), -- Forge of Odyn (Area: Skyhold - Difficulty: 0)
+(@OGUID+12, 267923, 1479, 7813, 7813, '0', 5997, 0, 1068.278, 7334.356, 109.4267, 0, 0, 0, 0, 1, 120, 255, 1, 24015), -- The Legend of Odyn (Area: Skyhold - Difficulty: 0)
+(@OGUID+13, 248980, 1479, 7813, 7813, '0', 5997, 0, 1068.616, 7334.295, 109.4267, 5.433888, 0, 0, -0.4120007, 0.9111835, 120, 255, 1, 24015), -- The Legend of Odyn (Area: Skyhold - Difficulty: 0)
+(@OGUID+14, 247320, 1479, 7813, 7813, '0', 5997, 0, 1030.392, 7360.578, 107.5607, 4.678151, 0, 0, -0.7191076, 0.6948987, 120, 255, 1, 24015); -- Forge of Power (Area: Skyhold - Difficulty: 0)