DB/Nighthold: Added spawns up to third boss

1 files changed, 440 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_07_09_01_world.sql b/sql/updates/world/master/2025_07_09_01_world.sql
new file mode 100644
index 00000000000..e024d4f7651
--- /dev/null
+++ b/sql/updates/world/master/2025_07_09_01_world.sql
@@ -0,0 +1,440 @@
+SET @CGUID := 6005172;
+SET @OGUID := 6002808;
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+103;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 113128, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -118.767776489257812, 3502.79931640625, -253.702682495117187, 6.269642829895019531, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Withered Skulker (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+1, 113321, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -124.709373474121093, 3499.428466796875, -253.702682495117187, 3.345258951187133789, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Shambling Hungerer (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+2, 113608, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 1, -143.90625, 3522.828125, -253.792572021484375, 5.472584247589111328, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Kirin Tor Guardian (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+3, 113367, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -117.592018127441406, 3511.796142578125, -253.7926025390625, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Dead Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+4, 113605, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 1, -149.244796752929687, 3521.432373046875, -253.792572021484375, 5.622315406799316406, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Kirin Tor Guardian (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+5, 113321, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -86.0594024658203125, 3476.509765625, -253.702682495117187, 1.669560909271240234, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Shambling Hungerer (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+6, 113128, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -94.077789306640625, 3477.690185546875, -253.702667236328125, 2.260243654251098632, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Withered Skulker (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+7, 113321, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -117.918403625488281, 3508.413330078125, -253.792572021484375, 1.756104350090026855, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Shambling Hungerer (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+8, 113608, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 1, -145.298614501953125, 3516.421142578125, -253.792572021484375, 5.717064380645751953, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Kirin Tor Guardian (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+9, 113605, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 1, -149.36285400390625, 3525.670166015625, -253.792572021484375, 5.622315406799316406, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Kirin Tor Guardian (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+10, 113321, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -96.2256927490234375, 3484.25341796875, -253.792572021484375, 1.453219294548034667, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Shambling Hungerer (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+11, 113608, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 1, -139.607635498046875, 3526.150146484375, -253.792572021484375, 5.493102073669433593, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Kirin Tor Guardian (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+12, 113605, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 1, -143.166671752929687, 3531.407958984375, -253.792572021484375, 5.622315406799316406, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Kirin Tor Guardian (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+13, 113128, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -98.3774032592773437, 3479.05419921875, -253.702667236328125, 3.269167184829711914, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Withered Skulker (Area: The Nighthold - Difficulty: Normal) CreateObject1 (possible waypoints or random movement)
+(@CGUID+14, 113321, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -111.472358703613281, 3500.10791015625, -252.905807495117187, 4.078732490539550781, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Shambling Hungerer (Area: The Nighthold - Difficulty: Normal) CreateObject1 (possible waypoints or random movement)
+(@CGUID+15, 110791, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 1, -138.805557250976562, 3528.4453125, -253.792572021484375, 5.645331382751464843, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- First Arcanist Thalyssra (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+16, 113367, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -117.513893127441406, 3491.41748046875, -252.953048706054687, 5.946882247924804687, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Dead Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+17, 113321, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -102.080307006835937, 3474.606689453125, -253.702667236328125, 2.510324716567993164, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Shambling Hungerer (Area: The Nighthold - Difficulty: Normal) CreateObject1 (possible waypoints or random movement)
+(@CGUID+18, 113608, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 1, -134.788192749023437, 3526.928955078125, -253.792572021484375, 5.179539203643798828, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Kirin Tor Guardian (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+19, 113605, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 1, -138.355911254882812, 3530.928955078125, -253.792572021484375, 5.622315406799316406, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Kirin Tor Guardian (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+20, 110792, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 1, -145.819442749023437, 3520.991455078125, -253.792572021484375, 5.674764156341552734, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Archmage Khadgar (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+21, 113321, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -92.564239501953125, 3469.80810546875, -253.792572021484375, 1.77908635139465332, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Shambling Hungerer (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+22, 113321, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -118.086807250976562, 3494.725830078125, -252.953048706054687, 5.216488361358642578, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Shambling Hungerer (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+23, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 22.27149581909179687, 3497.4921875, -250.624496459960937, 1.399570226669311523, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+24, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -45.7948799133300781, 3448.744140625, -264.702667236328125, 2.089443206787109375, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+25, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 37.15688323974609375, 3487.361083984375, -250.702667236328125, 5.84848642349243164, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+26, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -45.0664710998535156, 3448.14208984375, -264.702667236328125, 5.471076488494873046, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+27, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -41.7365341186523437, 3443.045166015625, -264.702667236328125, 2.479804754257202148, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+28, 108360, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -54.974609375, 3422.9140625, -265.702667236328125, 2.050849437713623046, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Acidmaw Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 209791 - Scorpid Tail)
+(@CGUID+29, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -59.8141288757324218, 3427.184326171875, -265.34454345703125, 3.75414276123046875, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+30, 113367, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -92.8350677490234375, 3472.642333984375, -253.792572021484375, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Dead Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+31, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -58.1164321899414062, 3451.06396484375, -264.718780517578125, 0.249328061938285827, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+32, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 6.39926910400390625, 3491.147216796875, -250.700286865234375, 0.147908300161361694, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+33, 108359, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 3.42062234878540039, 3510.46923828125, -250.526123046875, 3.973680734634399414, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Volatile Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 209787 - Scorpid Tail, 204697 - Scorpid Swarm)
+(@CGUID+34, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 24.94460105895996093, 3505.53271484375, -250.093307495117187, 1.893960833549499511, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+35, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -68.0499343872070312, 3444.553955078125, -264.38067626953125, 3.146606683731079101, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+36, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 21.370849609375, 3506.54443359375, -250.618499755859375, 0.002600718522444367, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+37, 108360, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 0.649198412895202636, 3497.483154296875, -250.70269775390625, 5.27477884292602539, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Acidmaw Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 209791 - Scorpid Tail)
+(@CGUID+38, 108359, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -41.4216384887695312, 3449.21826171875, -264.702667236328125, 0.237328976392745971, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Volatile Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 209787 - Scorpid Tail, 204697 - Scorpid Swarm)
+(@CGUID+39, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 10.33648586273193359, 3514.092041015625, -250.626373291015625, 3.324578523635864257, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+40, 116819, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -118.383682250976562, 3370.538330078125, -250.352706909179687, 0.701389253139495849, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Suramar Portal (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 232277 - Portal Visual)
+(@CGUID+41, 68553, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -67.611114501953125, 3421.6650390625, -255.213653564453125, 0.746599078178405761, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- SLG Generic MoP (Large AOI) (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 232575 - Door Lock)
+(@CGUID+42, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -0.24447134137153625, 3495.381103515625, -250.296417236328125, 1.603345394134521484, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+43, 108360, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 30.23184776306152343, 3499.084716796875, -249.905807495117187, 0.640548110008239746, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Acidmaw Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 209791 - Scorpid Tail)
+(@CGUID+44, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -49.9715957641601562, 3442.9873046875, -265.70269775390625, 3.84560704231262207, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+45, 113367, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, -95.361114501953125, 3487.28564453125, -253.792572021484375, 5.872241497039794921, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Dead Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+46, 111081, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 190.704864501953125, 3179.17626953125, -236.929641723632812, 2.028520822525024414, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fulminant (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+47, 111075, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 214.47222900390625, 3204.005126953125, -236.929611206054687, 2.645701885223388671, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Chaotoid (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+48, 111075, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 87.07465362548828125, 3266.86279296875, -224.712112426757812, 0.697065353393554687, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Chaotoid (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+49, 111071, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 326.432281494140625, 3208.229248046875, -236.929534912109375, 6.09361886978149414, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Pulsauron (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 205647 - Shield)
+(@CGUID+50, 111081, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 113.0694427490234375, 3258.37939453125, -225.653945922851562, 2.34285140037536621, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fulminant (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+51, 111071, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 201.90972900390625, 3205.790771484375, -236.929611206054687, 0.937276840209960937, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Pulsauron (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 205647 - Shield)
+(@CGUID+52, 111221, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 34.69965362548828125, 3489.729248046875, -250.6934814453125, 2.719180107116699218, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Xal'atath (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+53, 111081, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 348.1632080078125, 3183.723876953125, -236.929534912109375, 3.543871164321899414, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fulminant (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+54, 111073, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 201.90972900390625, 3205.790771484375, -236.929611206054687, 2.356194496154785156, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Pulsauron (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+55, 111081, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 205.092010498046875, 3193.729248046875, -236.929611206054687, 2.645701885223388671, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fulminant (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+56, 111075, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 179.6684112548828125, 3174.67529296875, -236.929641723632812, 2.645701885223388671, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Chaotoid (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+57, 111081, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 333.338531494140625, 3200.5244140625, -236.929534912109375, 4.218255996704101562, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fulminant (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+58, 92879, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 127.302093505859375, 3255.49560546875, -207.144760131835937, 2.347121715545654296, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- SLG Generic Stalker (Gigantic AOI) (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+59, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 45.04083633422851562, 3494.18896484375, -250.702667236328125, 1.577419400215148925, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+60, 102263, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 97.861114501953125, 3439.279541015625, -250.146652221679687, 2.608376979827880859, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Skorpyron (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 206947 - Chitinous Exoskeleton)
+(@CGUID+61, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 43.09438323974609375, 3475.54833984375, -250.37176513671875, 4.461749553680419921, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+62, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 45.9929046630859375, 3485.778076171875, -250.670364379882812, 2.434560298919677734, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+63, 108360, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 50.10416793823242187, 3486.3994140625, -250.6915283203125, 1.624155044555664062, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Acidmaw Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 209791 - Scorpid Tail)
+(@CGUID+64, 108361, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 56.89659500122070312, 3492.492431640625, -250.70269775390625, 0.128631338477134704, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Crystalline Scorpid (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 204376 - Scorpid Tail)
+(@CGUID+65, 111075, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 15.35763931274414062, 3378.468017578125, -238.614486694335937, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Chaotoid (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+66, 111071, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 14.70659732818603515, 3367.600830078125, -238.614486694335937, 2.739698648452758789, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Pulsauron (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 205647 - Shield)
+(@CGUID+67, 104415, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 252.0968170166015625, 3176.944580078125, -236.899505615234375, 0.540582537651062011, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Chronomatic Anomaly (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+68, 111081, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 125.2569427490234375, 3270.005126953125, -225.653945922851562, 2.34285140037536621, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fulminant (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+69, 111075, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 16.23611068725585937, 3357.84375, -238.614425659179687, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Chaotoid (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+70, 108144, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 383.614593505859375, 3330.2666015625, -226.64984130859375, 6.018045425415039062, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Trilliax's Imprint (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 214881 - Deactivated Construct)
+(@CGUID+71, 111071, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 73.72222137451171875, 3309.030517578125, -222.6734619140625, 0.427074432373046875, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Pulsauron (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 205647 - Shield)
+(@CGUID+72, 111073, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 73.72222137451171875, 3309.030517578125, -222.6734619140625, 5.478291511535644531, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Pulsauron (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+73, 111075, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 120.6684036254882812, 3262.423583984375, -225.6539306640625, 2.356617450714111328, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Chaotoid (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+74, 111081, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 83.41666412353515625, 3299.286376953125, -222.741348266601562, 2.351413488388061523, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fulminant (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+75, 68553, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 241.4184112548828125, 3399.46435546875, 171.80084228515625, 5.355021953582763671, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- SLG Generic MoP (Large AOI) (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+76, 104288, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 489.10589599609375, 3341.0625, -225.589248657226562, 3.991032361984252929, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Trilliax (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 206482 - Arcane Seepage, 223945 - Trilliax Dead Cosmetic)
+(@CGUID+77, 68553, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 280.338531494140625, 3383.18310546875, 178.4551544189453125, 0, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- SLG Generic MoP (Large AOI) (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: )
+(@CGUID+78, 108303, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 476.282989501953125, 3234.372314453125, -226.649856567382812, 1.784607172012329101, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Trilliax's Imprint (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 214881 - Deactivated Construct)
+(@CGUID+79, 111075, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 115.2656326293945312, 3296.66748046875, -224.725234985351562, 3.936352968215942382, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Chaotoid (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+80, 111071, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 187.7309112548828125, 3163.361083984375, -236.929641723632812, 0.937496662139892578, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Pulsauron (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 205647 - Shield)
+(@CGUID+81, 111073, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 187.7309112548828125, 3163.361083984375, -236.929641723632812, 5.497786998748779296, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Pulsauron (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+82, 111081, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 340.77777099609375, 3191.802001953125, -236.92950439453125, 3.875035762786865234, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Fulminant (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+83, 111071, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 353.39410400390625, 3178.0634765625, -236.92950439453125, 6.09361886978149414, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Pulsauron (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 205647 - Shield)
+(@CGUID+84, 108469, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 91.5850677490234375, 3443.3828125, -250.063323974609375, 0.799993336200714111, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Arcane Tether (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 215321 - Cage Rematch)
+(@CGUID+85, 112255, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 454.26910400390625, 3307.150146484375, -225.61138916015625, 3.926671266555786132, 604800, 0, 0, 0, NULL, NULL, NULL, NULL, 61609), -- Sludgerax (Area: The Nighthold - Difficulty: Normal) CreateObject1 (Auras: 223710 - Bursting Slime, 223721 - Death Cosmetic State)
+(@CGUID+86, 113512, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 354.6319580078125, 3255.5556640625, -225.702667236328125, 2.42238926887512207, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+87, 113512, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 408.900970458984375, 3218.289794921875, -225.702682495117187, 1.366734862327575683, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+88, 113512, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 368.334381103515625, 3263.427978515625, -225.702667236328125, 5.772593498229980468, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+89, 113512, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 416.589569091796875, 3206.459716796875, -224.702682495117187, 3.898638486862182617, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+90, 113512, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 367.875274658203125, 3241.8427734375, -225.702667236328125, 2.029626131057739257, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+91, 113512, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 399.998046875, 3211.496337890625, -225.702682495117187, 6.059175014495849609, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+92, 113512, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 381.18402099609375, 3249.397705078125, -225.702667236328125, 5.588403701782226562, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+93, 113512, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 354.503387451171875, 3267.586181640625, -224.66766357421875, 4.629853725433349609, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+94, 112251, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 466.5252685546875, 3290.373046875, -225.709152221679687, 4.686144828796386718, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+95, 113512, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 395.66473388671875, 3227.083984375, -225.702682495117187, 5.619397640228271484, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+96, 112251, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 466.52337646484375, 3281.564208984375, -225.667236328125, 4.666083335876464843, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+97, 113512, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 404.84039306640625, 3227.641845703125, -225.702682495117187, 2.488675832748413085, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+98, 112251, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 476.4794921875, 3288.109130859375, -225.702682495117187, 2.184254884719848632, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+99, 112251, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 427.8795166015625, 3338.83203125, -225.702682495117187, 4.503642559051513671, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+100, 112251, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 493.348419189453125, 3321.600830078125, -225.70184326171875, 4.085736274719238281, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+101, 112251, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 464.4493408203125, 3340.029052734375, -225.702667236328125, 5.486156463623046875, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+102, 112251, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 489.7137451171875, 3319.791015625, -225.702667236328125, 2.57419753074645996, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609), -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@CGUID+103, 112251, 1530, 8025, 8025, '14,15,16,17', 0, 0, 0, 0, 429.304107666015625, 3331.740966796875, -225.648773193359375, 1.311860561370849609, 604800, 4, 0, 1, NULL, NULL, NULL, NULL, 61609); -- Putrid Sludge (Area: The Nighthold - Difficulty: Normal) CreateObject1
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+103;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(@CGUID+2, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 0, ''), -- Kirin Tor Guardian
+(@CGUID+4, 0, 0, 0, 0, 0, 1, 0, 425, 0, 0, 0, 0, ''), -- Kirin Tor Guardian
+(@CGUID+8, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 0, ''), -- Kirin Tor Guardian
+(@CGUID+9, 0, 0, 0, 0, 0, 1, 0, 425, 0, 0, 0, 0, ''), -- Kirin Tor Guardian
+(@CGUID+11, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 0, ''), -- Kirin Tor Guardian
+(@CGUID+12, 0, 0, 0, 0, 0, 1, 0, 425, 0, 0, 0, 0, ''), -- Kirin Tor Guardian
+(@CGUID+18, 0, 0, 0, 0, 0, 1, 0, 333, 0, 0, 0, 0, ''), -- Kirin Tor Guardian
+(@CGUID+19, 0, 0, 0, 0, 0, 1, 0, 425, 0, 0, 0, 0, ''), -- Kirin Tor Guardian
+(@CGUID+41, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '232575'), -- SLG Generic MoP (Large AOI) - 232575 - Door Lock
+(@CGUID+84, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '215321'); -- Arcane Tether - 215321 - Cage Rematch
+
+-- GameObject
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+75;
+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, 247972, 1530, 8025, 8025, '14,15,16,17', 0, 0, -34.8819465637207031, 2830.158935546875, -80.3632965087890625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 604800, 255, 1, 61609), -- Suramar Raid - Doomlord - Destructible Bridge - 01 - MRN (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+1, 247973, 1530, 8025, 8025, '14,15,16,17', 0, 0, -34.8819465637207031, 2830.158935546875, -80.3632965087890625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 604800, 255, 1, 61609), -- Suramar Raid - Doomlord - Destructible Bridge - 03 - MRN (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+2, 253462, 1530, 8025, 8025, '14,15,16,17', 0, 0, 347.977447509765625, 3201.056396484375, 72.6627655029296875, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Platform (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+3, 247970, 1530, 8025, 8025, '14,15,16,17', 0, 0, -34.8819465637207031, 2830.158935546875, -80.3632965087890625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 604800, 255, 1, 61609), -- Suramar Raid - Doomlord - Destructible Bridge - 04 - MRN (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+4, 247971, 1530, 8025, 8025, '14,15,16,17', 0, 0, -34.8819465637207031, 2830.158935546875, -80.3632965087890625, 3.665196180343627929, 0, 0, -0.96592521667480468, 0.258821308612823486, 604800, 255, 1, 61609), -- Suramar Raid - Doomlord - Destructible Bridge - 02 - MRN (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+5, 253128, 1530, 8025, 8025, '14,15,16,17', 0, 0, -154.295135498046875, 3516.369873046875, -249.363723754882812, 0.802550375461578369, 0, 0, 0.390592575073242187, 0.92056363821029663, 604800, 255, 1, 61609), -- Instance Portal (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+6, 258846, 1530, 8025, 8025, '14,15,16,17', 0, 0, -118.38043212890625, 3370.476318359375, -250.723464965820312, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Doodad_7NB_NIGHTBORN_TELEPORTER_BASE004 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+7, 254240, 1530, 8025, 8025, '14,15,16,17', 0, 0, -69.11529541015625, 3420.236328125, -265.130126953125, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 61609), -- Sealed Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+8, 265470, 1530, 8025, 8025, '14,15,16,17', 0, 0, 638.8380126953125, 4056.74462890625, 0.101563811302185058, 0.444904416799545288, 0, 0, 0.220622062683105468, 0.97535938024520874, 604800, 255, 24, 61609), -- Doodad_7NB_NIGHTBORN_GONDOLA_LARGE_LongPath004 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+9, 248932, 1530, 8025, 8025, '14,15,16,17', 0, 0, 586.8807373046875, 3167.00830078125, 198.06121826171875, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 61609), -- Doodad_7NE_Nightelf_AcademyDoor001 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+10, 251683, 1530, 8025, 8025, '14,15,16,17', 0, 0, 255.55242919921875, 3316.56298828125, 148.778045654296875, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_Door_med005 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+11, 253923, 1530, 8025, 8025, '14,15,16,17', 0, 0, 226.570159912109375, 3357.473388671875, 173.6265869140625, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 0, 61609), -- Dreadlord Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+12, 252435, 1530, 8025, 8025, '14,15,16,17', 0, 0, 607.7684326171875, 3188.0009765625, 195.9592742919921875, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Doodad_7DU_SURAMARRAID_ASTRODOME01_CollisionOnly001 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+13, 254242, 1530, 8025, 8025, '14,15,16,17', 0, 0, 479.94891357421875, 3114.2294921875, 173.41259765625, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 61609), -- Observatory Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+14, 251610, 1530, 8025, 8025, '14,15,16,17', 0, 0, 341.044830322265625, 3076.997802734375, 227.220611572265625, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_Door_Small005 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+15, 251982, 1530, 8025, 8025, '14,15,16,17', 0, 0, 238.22747802734375, 3091.3076171875, 146.79107666015625, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_Door_Large002 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+16, 254243, 1530, 8025, 8025, '14,15,16,17', 0, 0, 492.03076171875, 3127.706298828125, 150.652923583984375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 61609), -- Observatory Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+17, 251519, 1530, 8025, 8025, '14,15,16,17', 0, 0, 128.619598388671875, 3254.373779296875, -225.611740112304687, 2.356189966201782226, 0, 0, 0.923878669738769531, 0.38268551230430603, 604800, 255, 1, 61609), -- Nightwell Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+18, 252105, 1530, 8025, 8025, '14,15,16,17', 0, 0, 60.75360107421875, 3475.99560546875, -249.978256225585937, 5.458010673522949218, 0, 0, -0.40098094940185546, 0.916086375713348388, 604800, 255, 0, 61609), -- Arcane-imbued Wood Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+19, 251611, 1530, 8025, 8025, '14,15,16,17', 0, 0, 318.4244384765625, 3099.8974609375, 296.643798828125, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 61609), -- Chamber Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+20, 258847, 1530, 8025, 8025, '14,15,16,17', 0, 0, 142.034881591796875, 3186.99658203125, 110.980499267578125, 6.187193870544433593, 0, 0, -0.04797744750976562, 0.998848438262939453, 604800, 255, 1, 61609), -- Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+21, 251983, 1530, 8025, 8025, '14,15,16,17', 0, 0, 461.11053466796875, 3181.485107421875, 148.608612060546875, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_Door_Large003 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+22, 251608, 1530, 8025, 8025, '14,15,16,17', 0, 0, 223.9024200439453125, 3194.115234375, 227.220611572265625, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 604800, 255, 1, 61609), -- Doodad_7DU_SuramarRaid_Door_Small001 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+23, 251686, 1530, 8025, 8025, '14,15,16,17', 0, 0, 250.6351470947265625, 3347.349609375, 173.602630615234375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 61609), -- Dreadlord Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+24, 254241, 1530, 8025, 8025, '14,15,16,17', 0, 0, 549.4324951171875, 3208.2275390625, 109.3601531982421875, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 604800, 255, 1, 61609), -- Portcullis (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+25, 251398, 1530, 8025, 8025, '14,15,16,17', 0, 0, 400.234466552734375, 3251.70458984375, -224.424545288085937, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 0, 61609), -- Trilliax Portcullis Entrance (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+26, 253988, 1530, 8025, 8025, '14,15,16,17', 0, 0, 101.1123809814453125, 2954.1923828125, 108.9106597900390625, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_CourtyardGate001 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+27, 251609, 1530, 8025, 8025, '14,15,16,17', 0, 0, 246.8431396484375, 3171.53515625, 296.643798828125, 2.356189966201782226, 0, 0, 0.923878669738769531, 0.38268551230430603, 604800, 255, 1, 61609), -- Chamber Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+28, 251832, 1530, 8025, 8025, '14,15,16,17', 0, 0, 610.50177001953125, 2761.565185546875, 125.2497329711914062, 3.936825513839721679, 0, 0, -0.92198657989501953, 0.387221813201904296, 604800, 255, 0, 61609), -- Botanist Door Right (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+29, 251984, 1530, 8025, 8025, '14,15,16,17', 0, 0, 558.0550537109375, 3084.6484375, 148.594879150390625, 2.356189966201782226, 0, 0, 0.923878669738769531, 0.38268551230430603, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_Door_med008 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+30, 251687, 1530, 8025, 8025, '14,15,16,17', 0, 0, 293.26605224609375, 3389.95654296875, 173.602630615234375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 61609), -- Dreadlord Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+31, 251981, 1530, 8025, 8025, '14,15,16,17', 0, 0, 326.77935791015625, 3179.859375, 146.79107666015625, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_Door_Large001 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+32, 253989, 1530, 8025, 8025, '14,15,16,17', 0, 0, 577.79864501953125, 3430.87890625, 108.9106597900390625, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Doodad_7DU_SuramarRaid_CourtyardGate002 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+33, 251833, 1530, 8025, 8025, '14,15,16,17', 0, 0, 674.5069580078125, 2828.928955078125, 125.2497329711914062, 3.948512077331542968, 0, 0, -0.919708251953125, 0.392602503299713134, 604800, 255, 0, 61609), -- Botanist Door Left (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+34, 251684, 1530, 8025, 8025, '14,15,16,17', 0, 0, 531.46649169921875, 3176.8427734375, 148.5205078125, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_Door_med006 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+35, 266174, 1530, 8025, 8025, '14,15,16,17', 0, 0, 282.348541259765625, 3135.404541015625, 464.98046875, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 604800, 255, 1, 61609), -- The Eye of Aman'thul (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+36, 253924, 1530, 8025, 8025, '14,15,16,17', 0, 0, 283.19757080078125, 3414.100830078125, 173.6265869140625, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 0, 61609), -- Dreadlord Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+37, 251685, 1530, 8025, 8025, '14,15,16,17', 0, 0, 466.397064208984375, 3111.55419921875, 148.5205078125, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_Door_med007 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+38, 251397, 1530, 8025, 8025, '14,15,16,17', 0, 0, 418.25244140625, 3269.7470703125, -224.569900512695312, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 0, 61609), -- Trilliax Portcullis Entrance (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+39, 252315, 1530, 8025, 8025, '14,15,16,17', 0, 0, 241.671661376953125, 3176.3056640625, 227.220611572265625, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 61609), -- Doodad_7DU_SuramarRaid_Door_Small012 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+40, 251612, 1530, 8025, 8025, '14,15,16,17', 0, 0, 323.344146728515625, 3176.3916015625, 227.2296142578125, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Doodad_7DU_SuramarRaid_Door_Small007 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+41, 251988, 1530, 8025, 8025, '14,15,16,17', 0, 0, 326.74737548828125, 3091.6240234375, 438.94061279296875, 0.785398900508880615, 0, 0, 0.382683753967285156, 0.923879444599151611, 604800, 255, 1, 61609), -- Nighthold Focusing Statue (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+42, 266173, 1530, 8025, 8025, '14,15,16,17', 0, 0, 323.8570556640625, 3385.086669921875, 148.778045654296875, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_Door_med001 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+43, 250242, 1530, 8025, 8025, '14,15,16,17', 0, 0, 406.70782470703125, 3323.2880859375, -225.561599731445312, 1.291544198989868164, 0, 0, 0.601815223693847656, 0.798635363578796386, 604800, 255, 1, 61609), -- Trilliax Portcullis 02 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+44, 252348, 1530, 8025, 8025, '14,15,16,17', 0, 0, 370.307708740234375, 3221.55517578125, -225.780380249023437, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Anomaly Exit (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+45, 254238, 1530, 8025, 8025, '14,15,16,17', 0, 0, 324.9207763671875, 3909.510498046875, 0.101563811302185058, 5.729412078857421875, 0, 0, -0.2733621597290039, 0.961911201477050781, 604800, 255, 24, 61609), -- Gondola (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+46, 250243, 1530, 8025, 8025, '14,15,16,17', 0, 0, 495.447509765625, 3347.27392578125, -225.561599731445312, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 61609), -- Trilliax Portcullis Exit (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+47, 252349, 1530, 8025, 8025, '14,15,16,17', 0, 0, 162.0253143310546875, 3220.87548828125, -225.780380249023437, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 0, 61609), -- Anomaly Entrance (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+48, 266182, 1530, 8025, 8025, '14,15,16,17', 0, 0, 282.351226806640625, 3135.40234375, 465.8343505859375, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 61609), -- Statue Energy Conduit (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+49, 252103, 1530, 8025, 8025, '14,15,16,17', 0, 0, 60.613739013671875, 3411.80419921875, -250.388992309570312, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Arcane-imbued Wood Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+50, 252318, 1530, 8025, 8025, '14,15,16,17', 0, 0, 282.351226806640625, 3135.40234375, 465.82000732421875, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 604800, 255, 1, 61609), -- The Eye of Aman'thul (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+51, 260985, 1530, 8025, 8025, '14,15,16,17', 0, 0, 282.351226806640625, 3135.40234375, 465.82000732421875, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 604800, 255, 1, 61609), -- The Eye of Aman'thul (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+52, 254239, 1530, 8025, 8025, '14,15,16,17', 0, 0, 492.336151123046875, 4064.585205078125, 0.101563811302185058, 4.919407844543457031, 0, 0, -0.63026046752929687, 0.776383757591247558, 604800, 255, 24, 61609), -- Gondola (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+53, 252322, 1530, 8025, 8025, '14,15,16,17', 0, 0, 273.400177001953125, 3135.166259765625, -237.064682006835937, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Doodad_7sr_suramar_nightwellfx002 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+54, 266183, 1530, 8025, 8025, '14,15,16,17', 0, 0, 282.351226806640625, 3135.40234375, 465.8343505859375, 2.356189966201782226, 0, 0, 0.923878669738769531, 0.38268551230430603, 604800, 255, 1, 61609), -- Statue Energy Conduit (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+55, 251401, 1530, 8025, 8025, '14,15,16,17', 0, 0, 607.7684326171875, 3188.0009765625, 195.9592742919921875, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Doodad_7DU_SuramarRaid_Astrodome001 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+56, 252319, 1530, 8025, 8025, '14,15,16,17', 0, 0, 326.30255126953125, 3179.779052734375, 438.94061279296875, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 604800, 255, 1, 61609), -- Nighthold Focusing Statue (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+57, 254276, 1530, 8025, 8025, '14,15,16,17', 0, 0, 684.08709716796875, 3851.78125, 0.101563811302185058, 3.483622074127197265, 0, 0, -0.98541259765625, 0.170182302594184875, 604800, 255, 24, 61609), -- Gondola (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+58, 250241, 1530, 8025, 8025, '14,15,16,17', 0, 0, 470.959564208984375, 3258.6171875, -225.561599731445312, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 604800, 255, 1, 61609), -- Trilliax Portcullis 01 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+59, 266180, 1530, 8025, 8025, '14,15,16,17', 0, 0, 282.351226806640625, 3135.40234375, 465.8343505859375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 604800, 255, 1, 61609), -- Statue Energy Conduit (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+60, 252316, 1530, 8025, 8025, '14,15,16,17', 0, 0, 323.24102783203125, 3094.773193359375, 227.220611572265625, 2.356189966201782226, 0, 0, 0.923878669738769531, 0.38268551230430603, 604800, 255, 0, 61609), -- Doodad_7DU_SuramarRaid_Door_Small013 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+61, 259929, 1530, 8025, 8025, '14,15,16,17', 0, 0, 617.34210205078125, 3812.0908203125, 0.101563811302185058, 5.317407608032226562, -0.00087165832519531, 0.002904891967773437, -0.46433353424072265, 0.885655224323272705, 604800, 255, 24, 61609), -- Doodad_7NB_NIGHTBORN_GONDOLA_LARGE_ShortSouth01 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+62, 252320, 1530, 8025, 8025, '14,15,16,17', 0, 0, 238.592376708984375, 3091.17919921875, 438.94061279296875, 5.497790813446044921, 0, 0, -0.38268184661865234, 0.923880219459533691, 604800, 255, 1, 61609), -- Nighthold Focusing Statue (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+63, 253178, 1530, 8025, 8025, '14,15,16,17', 0, 0, 269.55902099609375, 3370.911376953125, 172.6356964111328125, 2.364389657974243164, 0, 0, 0.925439834594726562, 0.378894597291946411, 604800, 255, 0, 61609), -- Balcony Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+64, 266181, 1530, 8025, 8025, '14,15,16,17', 0, 0, 282.351226806640625, 3135.40234375, 465.8343505859375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Statue Energy Conduit (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+65, 265469, 1530, 8025, 8025, '14,15,16,17', 0, 0, 817.164306640625, 3901.79638671875, 0.101563811302185058, 4.196184158325195312, 0, 0, -0.86417102813720703, 0.503198206424713134, 604800, 255, 24, 61609), -- Doodad_7NB_NIGHTBORN_GONDOLA_LARGE_LongPath003 (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+66, 266395, 1530, 8025, 8025, '14,15,16,17', 0, 0, 282.351226806640625, 3135.40234375, 465.8199462890625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 604800, 255, 1, 61609), -- The Eye of Aman'thul (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+67, 252321, 1530, 8025, 8025, '14,15,16,17', 0, 0, 238.147552490234375, 3179.334228515625, 438.94061279296875, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 604800, 255, 1, 61609), -- Nighthold Focusing Statue (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+68, 242174, 1530, 8025, 8025, '14,15,16,17', 0, 0, -960.4443359375, 4324.99658203125, 740.15814208984375, 0.890116631984710693, 0, 0, 0.430510520935058593, 0.902585566043853759, 604800, 255, 1, 61609), -- Violet Hold Gate (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+69, 251844, 1530, 8025, 8025, '14,15,16,17', 0, 0, 1100.499755859375, 3435.92578125, 20.76276588439941406, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 604800, 255, 1, 61609), -- Door (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+70, 254145, 1530, 8025, 8025, '14,15,16,17', 0, 0, 441.9613037109375, 3749.5859375, 0.101563811302185058, 3.18517923355102539, 0, 0, -0.99976253509521484, 0.021791517734527587, 604800, 255, 24, 61609), -- Gondola (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+71, 251033, 1530, 8025, 8025, '14,15,16,17', 0, 0, -967.25384521484375, 4435.98486328125, 735.7366943359375, 2.164205789566040039, 0, 0, 0.882946968078613281, 0.469472706317901611, 604800, 255, 1, 61609), -- Facade (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+72, 254147, 1530, 8025, 8025, '14,15,16,17', 0, 0, 1234.8172607421875, 3738.015869140625, 0.151466310024261474, 1.957394242286682128, 0.000288963317871093, -0.00159168243408203, 0.829769134521484375, 0.558104455471038818, 604800, 255, 24, 61609), -- Gondola (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+73, 254148, 1530, 8025, 8025, '14,15,16,17', 0, 0, 869.8609619140625, 4216.87744140625, 0.101563692092895507, 4.781013011932373046, 0, 0, -0.68243312835693359, 0.730948090553283691, 604800, 255, 24, 61609), -- Gondola (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+74, 254149, 1530, 8025, 8025, '14,15,16,17', 0, 0, 1007.9725341796875, 3777.788330078125, 0.101517051458358764, 2.947497129440307617, 0, 0, 0.995294570922851562, 0.09689553827047348, 604800, 255, 24, 61609), -- Gondola (Area: The Nighthold - Difficulty: Normal) CreateObject1
+(@OGUID+75, 266919, 1530, 8025, 8025, '14,15,16,17', 0, 0, 1235.945556640625, 4205.98046875, -65.1804656982421875, 2.617989301681518554, 0, 0, 0.965925216674804687, 0.258821308612823486, 604800, 255, 1, 61609); -- The Nighthold Portcullis (Area: The Nighthold - Difficulty: Normal) CreateObject1
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+75;
+INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES
+(@OGUID+0, 0, 0, 0, 1, 0, 0), -- Suramar Raid - Doomlord - Destructible Bridge - 01 - MRN
+(@OGUID+1, 0, 0, 0, 1, 0, 0), -- Suramar Raid - Doomlord - Destructible Bridge - 03 - MRN
+(@OGUID+2, 0, 0, 0, 1, 0, 0), -- Platform
+(@OGUID+3, 0, 0, 0, 1, 0, 0), -- Suramar Raid - Doomlord - Destructible Bridge - 04 - MRN
+(@OGUID+4, 0, 0, 0, 1, 0, 0), -- Suramar Raid - Doomlord - Destructible Bridge - 02 - MRN
+(@OGUID+6, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7NB_NIGHTBORN_TELEPORTER_BASE004
+(@OGUID+7, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Sealed Door
+(@OGUID+8, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7NB_NIGHTBORN_GONDOLA_LARGE_LongPath004
+(@OGUID+9, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7NE_Nightelf_AcademyDoor001
+(@OGUID+10, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_med005
+(@OGUID+11, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Dreadlord Door
+(@OGUID+12, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SURAMARRAID_ASTRODOME01_CollisionOnly001
+(@OGUID+13, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Observatory Door
+(@OGUID+14, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_Small005
+(@OGUID+15, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_Large002
+(@OGUID+16, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Observatory Door
+(@OGUID+17, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Nightwell Door
+(@OGUID+18, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Arcane-imbued Wood Door
+(@OGUID+19, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Chamber Door
+(@OGUID+20, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Door
+(@OGUID+21, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_Large003
+(@OGUID+22, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_Small001
+(@OGUID+23, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Dreadlord Door
+(@OGUID+24, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Portcullis
+(@OGUID+25, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Trilliax Portcullis Entrance
+(@OGUID+26, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_CourtyardGate001
+(@OGUID+27, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Chamber Door
+(@OGUID+29, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_med008
+(@OGUID+30, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Dreadlord Door
+(@OGUID+31, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_Large001
+(@OGUID+32, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_CourtyardGate002
+(@OGUID+34, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_med006
+(@OGUID+35, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- The Eye of Aman'thul
+(@OGUID+36, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Dreadlord Door
+(@OGUID+37, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_med007
+(@OGUID+38, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Trilliax Portcullis Entrance
+(@OGUID+39, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_Small012
+(@OGUID+40, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_Small007
+(@OGUID+41, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Nighthold Focusing Statue
+(@OGUID+42, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_med001
+(@OGUID+43, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Trilliax Portcullis 02
+(@OGUID+44, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Anomaly Exit
+(@OGUID+45, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Gondola
+(@OGUID+46, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Trilliax Portcullis Exit
+(@OGUID+47, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Anomaly Entrance
+(@OGUID+48, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 12318), -- Statue Energy Conduit
+(@OGUID+49, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Arcane-imbued Wood Door
+(@OGUID+50, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 12317), -- The Eye of Aman'thul
+(@OGUID+51, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- The Eye of Aman'thul
+(@OGUID+52, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Gondola
+(@OGUID+53, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7sr_suramar_nightwellfx002
+(@OGUID+54, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 12318), -- Statue Energy Conduit
+(@OGUID+55, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Astrodome001
+(@OGUID+56, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 10418), -- Nighthold Focusing Statue
+(@OGUID+57, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Gondola
+(@OGUID+58, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Trilliax Portcullis 01
+(@OGUID+59, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 12318), -- Statue Energy Conduit
+(@OGUID+60, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7DU_SuramarRaid_Door_Small013
+(@OGUID+61, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7NB_NIGHTBORN_GONDOLA_LARGE_ShortSouth01
+(@OGUID+62, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Nighthold Focusing Statue
+(@OGUID+64, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 12318), -- Statue Energy Conduit
+(@OGUID+65, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Doodad_7NB_NIGHTBORN_GONDOLA_LARGE_LongPath003
+(@OGUID+66, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- The Eye of Aman'thul
+(@OGUID+67, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Nighthold Focusing Statue
+(@OGUID+68, 0, 0, -0.33380699157714843, 0.942641437053680419, 0, 0), -- Violet Hold Gate
+(@OGUID+69, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Door
+(@OGUID+70, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Gondola
+(@OGUID+71, 0, 0, -0.33380699157714843, 0.942641437053680419, 0, 0), -- Facade
+(@OGUID+72, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Gondola
+(@OGUID+73, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Gondola
+(@OGUID+74, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Gondola
+(@OGUID+75, 0, 0, -0.86602526903152465, 0.500000238418579101, 0, 0); -- The Nighthold Portcullis
+
+-- Template Addon
+DELETE FROM `creature_template_addon` WHERE `entry` IN (108303 /*108303 (Trilliax's Imprint) - Deactivated Construct*/, 104288 /*104288 (Trilliax) - Arcane Seepage, Trilliax Dead Cosmetic*/, 108144 /*108144 (Trilliax's Imprint) - Deactivated Construct*/, 104415 /*104415 (Chronomatic Anomaly)*/, 111071 /*111071 (Pulsauron) - Shield*/, 102263 /*102263 (Skorpyron) - Chitinous Exoskeleton*/, 101340 /*101340 (Crystal Spine) - Chitinous Exoskeleton*/, 104154 /*104154 (Gul'dan) - Gul'dan, The Eye of Aman'thul, Fel Scythe, Parasitic Wound, Parasitic Wound, Encounter Bounds Aura (Broken Room), Encounter Bounds Aura (Intact Room)*/, 101342 /*101342 (Crystal Spine) - Chitinous Exoskeleton*/, 101337 /*101337 (Crystal Mandible)*/, 103725 /*103725 (Krosus)*/, 101339 /*101339 (Crystal Spine) - Chitinous Exoskeleton*/, 103999 /*103999 (Krosus)*/, 101338 /*101338 (Crystal Mandible)*/, 101335 /*101335 (Crystal Tail)*/, 114438 /*114438 (The Eye of Aman'thul) - Ride Vehicle Hardcoded, Encounter Bounds Aura (Broken Room), Encounter Bounds Aura (Intact Room)*/, 116819 /*116819 (Suramar Portal) - Portal Visual*/, 108359 /*108359 (Volatile Scorpid) - Scorpid Tail, Scorpid Swarm*/, 108360 /*108360 (Acidmaw Scorpid) - Scorpid Tail*/, 108361 /*108361 (Crystalline Scorpid) - Scorpid Tail*/, 113367 /*113367 (Dead Crystalline Scorpid) - Scorpid Tail*/, 112255 /*112255 (Sludgerax) - Bursting Slime, Death Cosmetic State*/, 112332 /*112332 (Sludgerax) - Ride Vehicle Hardcoded*/);
+INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(108303, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '214881'), -- 108303 (Trilliax's Imprint) - Deactivated Construct
+(104288, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '206482 223945'), -- 104288 (Trilliax) - Arcane Seepage, Trilliax Dead Cosmetic
+(108144, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '214881'), -- 108144 (Trilliax's Imprint) - Deactivated Construct
+(104415, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, ''), -- 104415 (Chronomatic Anomaly)
+(111071, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '205647'), -- 111071 (Pulsauron) - Shield
+(102263, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '206947'), -- 102263 (Skorpyron) - Chitinous Exoskeleton
+(101340, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, '204975'), -- 101340 (Crystal Spine) - Chitinous Exoskeleton
+(101342, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, '204975'), -- 101342 (Crystal Spine) - Chitinous Exoskeleton
+(101337, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 101337 (Crystal Mandible)
+(103725, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 103725 (Krosus)
+(101339, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, '204975'), -- 101339 (Crystal Spine) - Chitinous Exoskeleton
+(103999, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 103999 (Krosus)
+(101338, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 101338 (Crystal Mandible)
+(101335, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 101335 (Crystal Tail)
+(114438, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 4, '227371 206261'), -- 114438 (The Eye of Aman'thul) - Ride Vehicle Hardcoded, Encounter Bounds Aura (Broken Room), Encounter Bounds Aura (Intact Room)
+(116819, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '232277'), -- 116819 (Suramar Portal) - Portal Visual
+(108359, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '209787 204697'), -- 108359 (Volatile Scorpid) - Scorpid Tail, Scorpid Swarm
+(108360, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '209791'), -- 108360 (Acidmaw Scorpid) - Scorpid Tail
+(108361, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '204376'), -- 108361 (Crystalline Scorpid) - Scorpid Tail
+(113367, 0, 0, 7, 0, 0, 1, 0, 0, 0, 0, 0, 0, '204376'), -- 113367 (Dead Crystalline Scorpid) - Scorpid Tail
+(112255, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '223710 223721'), -- 112255 (Sludgerax) - Bursting Slime, Death Cosmetic State
+(112332, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 112332 (Sludgerax) - Ride Vehicle Hardcoded
+
+-- Template
+UPDATE `creature_template` SET `flags_extra` = 128 WHERE `entry` = 116819;
+
+UPDATE `gameobject_template` SET `VerifiedBuild`=61609 WHERE `entry` IN (242174, 251844, 251033, 266919, 254149, 254148, 254147, 254145, 254239, 254276, 248932, 251984, 265470, 251401, 252435, 259929, 254242, 251684, 266173, 254243, 254241, 253989, 253988, 252315, 251983, 251982, 251981, 251687, 251685, 251612, 251611, 251610, 251609, 251608, 265469, 254238, 253924, 251686, 251683, 253923, 252322, 251519, 258846, 253128, 247973, 247972, 247971, 247970);
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=251832; -- Botanist Door Right
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=251833; -- Botanist Door Left
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry` IN (251988, 252319, 252320, 252321); -- Nighthold Focusing Statue
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry` IN (266182, 266180, 266183, 266181); -- Statue Energy Conduit
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry` IN (252318, 266395, 266174, 260985); -- The Eye of Aman'thul
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=252316; -- Doodad_7DU_SuramarRaid_Door_Small013
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=250243; -- Trilliax Portcullis Exit
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=250241; -- Trilliax Portcullis 01
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry` IN (251397, 251398); -- Trilliax Portcullis Entrance
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=253178; -- Balcony Door
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=252348; -- Anomaly Exit
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=250242; -- Trilliax Portcullis 02
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=258847; -- Door
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=252349; -- Anomaly Entrance
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry` IN (252103, 252105); -- Arcane-imbued Wood Door
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=254240; -- Sealed Door
+UPDATE `gameobject_template` SET `ContentTuningId`=619, `VerifiedBuild`=61609 WHERE `entry`=253462; -- Platform
+
+-- Difficulty
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=619, `StaticFlags1`=0x100, `VerifiedBuild`=61609 WHERE (`Entry`=108303 AND `DifficultyID`=0); -- 108303 (Trilliax's Imprint) - Sessile
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=619, `StaticFlags1`=0x100, `VerifiedBuild`=61609 WHERE (`Entry`=104288 AND `DifficultyID`=14); -- 104288 (Trilliax) - Sessile
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=619, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=111081 AND `DifficultyID`=14); -- 111081 (Fulminant) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=619, `StaticFlags3`=0x2000000, `VerifiedBuild`=61609 WHERE (`Entry`=111073 AND `DifficultyID`=14); -- 111073 (Pulsauron) - CannotTurn
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=619, `StaticFlags1`=0x100, `VerifiedBuild`=61609 WHERE (`Entry`=108144 AND `DifficultyID`=0); -- 108144 (Trilliax's Imprint) - Sessile
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=619, `VerifiedBuild`=61609 WHERE (`Entry`=111072 AND `DifficultyID`=14); -- 111072 (Pulsauron) - 
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=619, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=104415 AND `DifficultyID`=14); -- 104415 (Chronomatic Anomaly) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=619, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=111071 AND `DifficultyID`=14); -- 111071 (Pulsauron) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=619, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=111075 AND `DifficultyID`=14); -- 111075 (Chaotoid) - CanSwim
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=619, `VerifiedBuild`=61609 WHERE (`Entry`=102263 AND `DifficultyID`=14); -- 102263 (Skorpyron) - 
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=92879 AND `DifficultyID`=14); -- 92879 (SLG Generic Stalker (Gigantic AOI)) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=101340 AND `DifficultyID`=0); -- 101340 (Crystal Spine) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=619, `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=104154 AND `DifficultyID`=14); -- 104154 (Gul'dan) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=101342 AND `DifficultyID`=0); -- 101342 (Crystal Spine) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=101337 AND `DifficultyID`=0); -- 101337 (Crystal Mandible) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000000, `VerifiedBuild`=61609 WHERE (`Entry`=103725 AND `DifficultyID`=0); -- 103725 (Krosus) - Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=101339 AND `DifficultyID`=0); -- 101339 (Crystal Spine) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=103999 AND `DifficultyID`=0); -- 103999 (Krosus) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=101338 AND `DifficultyID`=0); -- 101338 (Crystal Mandible) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=101335 AND `DifficultyID`=0); -- 101335 (Crystal Tail) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=114438 AND `DifficultyID`=0); -- 114438 (The Eye of Aman'thul) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=116819 AND `DifficultyID`=0); -- 116819 (Suramar Portal) - Sessile, Floating - CannotTurn
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=619, `VerifiedBuild`=61609 WHERE (`Entry`=108359 AND `DifficultyID`=14); -- 108359 (Volatile Scorpid) - 
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=619, `VerifiedBuild`=61609 WHERE (`Entry`=108360 AND `DifficultyID`=14); -- 108360 (Acidmaw Scorpid) - 
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=619, `VerifiedBuild`=61609 WHERE (`Entry`=108361 AND `DifficultyID`=14); -- 108361 (Crystalline Scorpid) - 
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=110792 AND `DifficultyID`=0); -- 110792 (Archmage Khadgar) - CanSwim
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=110791 AND `DifficultyID`=0); -- 110791 (First Arcanist Thalyssra) - CanSwim
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=113605 AND `DifficultyID`=0); -- 113605 (Kirin Tor Guardian) - CanSwim
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=113367 AND `DifficultyID`=0); -- 113367 (Dead Crystalline Scorpid) - Sessile, Floating
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=113608 AND `DifficultyID`=0); -- 113608 (Kirin Tor Guardian) - CanSwim
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=619, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=113321 AND `DifficultyID`=14); -- 113321 (Shambling Hungerer) - CanSwim
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=1, `LevelScalingDeltaMax`=1, `ContentTuningID`=619, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=113128 AND `DifficultyID`=14); -- 113128 (Withered Skulker) - CanSwim
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=619, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=104881 AND `DifficultyID`=14); -- 104881 (Spellblade Aluriel) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=619, `StaticFlags1`=0x10000100, `VerifiedBuild`=61609 WHERE (`Entry`=112255 AND `DifficultyID`=14); -- 112255 (Sludgerax) - Sessile, CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=619, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=112251 AND `DifficultyID`=14); -- 112251 (Putrid Sludge) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=619, `StaticFlags1`=0x10000000, `VerifiedBuild`=61609 WHERE (`Entry`=113512 AND `DifficultyID`=14); -- 113512 (Putrid Sludge) - CanSwim
+UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=3, `LevelScalingDeltaMax`=3, `ContentTuningID`=619, `StaticFlags1`=0x20000100, `VerifiedBuild`=61609 WHERE (`Entry`=112332 AND `DifficultyID`=0); -- 112332 (Sludgerax) - Sessile, Floating
+
+-- Static Flag override
+DELETE FROM `creature_static_flags_override` WHERE `SpawnId` = @CGUID+41;
+INSERT INTO `creature_static_flags_override` (`SpawnId`, `DifficultyId`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`) VALUES
+(@CGUID+41, 14, 0x20000100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(@CGUID+41, 15, 0x20000100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(@CGUID+41, 16, 0x20000100, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
+(@CGUID+41, 17, 0x20000100, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+
+-- Creature template movement
+DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (108361,108360,108359);
+INSERT INTO `creature_template_movement` (`CreatureId`, `HoverInitiallyEnabled`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES
+(108361, NULL, 0, 2, NULL),
+(108360, NULL, 0, 2, NULL),
+(108359, NULL, 0, 2, NULL);
+
+-- Spellclick
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 102263;
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
+(102263, 48754, 1, 0);
+
+-- Vehicle
+DELETE FROM `vehicle_template_accessory` WHERE (`entry`=102263 AND `seat_id` IN (5,4,2,1,0,3));
+INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES
+(102263, 101340, 5, 0, 'Skorpyron - Crystal Spine', 8, 0), -- Skorpyron - Crystal Spine
+(102263, 101342, 4, 0, 'Skorpyron - Crystal Spine', 8, 0), -- Skorpyron - Crystal Spine
+(102263, 101337, 2, 0, 'Skorpyron - Crystal Mandible', 8, 0), -- Skorpyron - Crystal Mandible
+(102263, 101339, 1, 0, 'Skorpyron - Crystal Spine', 8, 0), -- Skorpyron - Crystal Spine
+(102263, 101335, 0, 0, 'Skorpyron - Crystal Tail', 8, 0), -- Skorpyron - Crystal Tail
+(102263, 101338, 3, 0, 'Skorpyron - Crystal Mandible', 8, 0); -- Skorpyron - Crystal Mandible
+
+-- Shambling Hungerer smart ai
+SET @ENTRY := 113321;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES
+(@ENTRY, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 85, 225476, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On reset - Self: Cast spell 225476 on self', '');
+
+UPDATE `creature` SET `StringId` = 'CosmeticCannibalize' WHERE `guid` IN (@CGUID+7, @CGUID+22, @CGUID+10, @CGUID+21);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 22 AND `SourceEntry` = 113321 AND `SourceId` = 0;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES 
+(22, 1, 113321, 0, 0, 58, 1, 0, 0, 0, 'CosmeticCannibalize', 0, 'Object has StringID CosmeticCannibalize');
+
+DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 13) AND (`SourceEntry` IN (225476));
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES 
+(13, 1, 225476, 0, 0, 51, 0, 5, 113367, 0, '', 0, 'Potential target of the spell is TYPEID_UNIT, entry is 113367');
+
+-- Path for Chronomatic Anomaly
+SET @ENTRY := 104415;
+SET @PATHOFFSET := 0;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x2, 4.2743, 'Chronomatic Anomaly - Cyclic Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, 258.30844, 3180.089, -236.89952, NULL, 0),
+(@PATH, 1, 276.67728, 3183.743, -236.89954, NULL, 0),
+(@PATH, 2, 295.04608, 3180.089, -236.89954, NULL, 0),
+(@PATH, 3, 310.6184, 3169.684, -236.89952, NULL, 0),
+(@PATH, 4, 321.02347, 3154.1118, -236.89957, NULL, 0),
+(@PATH, 5, 324.67725, 3135.743, -236.89952, NULL, 0),
+(@PATH, 6, 321.02344, 3117.374, -236.89954, NULL, 0),
+(@PATH, 7, 310.61835, 3101.8018, -236.89954, NULL, 0),
+(@PATH, 8, 295.046, 3091.3967, -236.89955, NULL, 0),
+(@PATH, 9, 276.6772, 3087.743, -236.89955, NULL, 0),
+(@PATH, 10, 258.30838, 3091.3967, -236.89952, NULL, 0),
+(@PATH, 11, 242.73608, 3101.8018, -236.89955, NULL, 0),
+(@PATH, 12, 232.331, 3117.3743, -236.89954, NULL, 0),
+(@PATH, 13, 228.67723, 3135.743, -236.89954, NULL, 0),
+(@PATH, 14, 232.33102, 3154.1118, -236.89954, NULL, 0),
+(@PATH, 15, 242.73613, 3169.684, -236.89952, NULL, 0);
+
+UPDATE `creature` SET `wander_distance`=0, `MovementType`=2 WHERE `guid`=@CGUID+67;
+UPDATE `creature_template_addon` SET `PathId` = @PATH WHERE `entry` = 104415;