DB: Adjust guids used in previous commit

1 files changed, 455 insertions, 0 deletions

diff --git a/sql/updates/world/master/2019_08_25_01_world.sql b/sql/updates/world/master/2019_08_25_01_world.sql
new file mode 100644
index 00000000000..8e6dc8c9afd
--- /dev/null
+++ b/sql/updates/world/master/2019_08_25_01_world.sql
@@ -0,0 +1,455 @@
+-- move to another guid range
+SET @CGUID := 685;
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+124;
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+124;
+DELETE FROM `waypoint_data` WHERE `id` BETWEEN ((@CGUID+0)*10) AND ((@CGUID+124)*10);
+
+SET @OGUID := 46;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+14;
+
+SET @CGUID := 454893;
+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
+
+-- 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);
+
+SET @OGUID := 301210;
+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)