Argent Vanguard/Argent Pinnacle/Scourgeholme phasing

This is what I’ve done so far for the Phasing during the Questline involving the Argent Vanguard, Scourgehome and ultimately unlocking the Crusader’s pinnacle. Have in mind that this is purely to set up the right auras/ quest chain/ spawns/ phases for npcs and gameobjects, and it doesn’t mean it adds support to any particular quest in the area.

[SPOILER]-- Guid for inserts
SET @NEXT := XXX;

– Correct Phasing/Quest relation for the Argent Vanguard, Crusader’s Pinnacle, Scourgeholme, The Breach, Valley of Echoes and Pit of Fiends (I didn’t use Phase IV spell id: 57675 since it sets phase to one, I don’t see the point since that’s the default phase)
– The spells are Argent Vanguard Chapter I (id: 57673), Argent Vanguard Chapter II (id: 57569) and Argent Vanguard Chapter III (id: 57674)
DELETE FROM spell_area WHERE spell IN (57673, 57569, 57674);
INSERT INTO spell_area (spell, area, quest_start, quest_start_active, quest_end, aura_spell, racemask, gender, autocast) VALUES
(57673, 4501, 0, 0, 13070, 0, 0, 2, 1),
(57673, 4504, 0, 0, 13070, 0, 0, 2, 1),
(57673, 4505, 0, 0, 13086, 0, 0, 2, 1),
(57673, 4506, 0, 0, 13086, 0, 0, 2, 1),
(57673, 4580, 0, 0, 13086, 0, 0, 2, 1),
(57673, 4593, 0, 0, 13086, 0, 0, 2, 1),
(57569, 4501, 13070, 0, 13086, 0, 0, 2, 1),
(57569, 4504, 13070, 0, 13086, 0, 0, 2, 1),
(57674, 4501, 13086, 0, 13141, 0, 0, 2, 1),
(57674, 4504, 13086, 0, 13141, 0, 0, 2, 1),
(57674, 4505, 13086, 0, 13141, 0, 0, 2, 1),
(57674, 4506, 13086, 0, 13141, 0, 0, 2, 1),
(57674, 4593, 13086, 0, 13141, 0, 0, 2, 1),
(57674, 4580, 13086, 0, 13141, 0, 0, 2, 1);

– Correct Quest chaining and requirements up until the quest “Crusader’s Pinnacle”, when the Argent Base in the pinnacle phases in
UPDATE quest_template SET PrevQuestId=13036, NextQuestId=13044, ExclusiveGroup=-13008 WHERE entry=13008; – Scourge Tactics
UPDATE quest_template SET PrevQuestId=13036, NextQuestId=13044, ExclusiveGroup=-13008 WHERE entry=13039; – Defending The Vanguard
UPDATE quest_template SET PrevQuestId=13036, NextQuestId=13044, ExclusiveGroup=-13008 WHERE entry=13040; – Curing The Incurable
UPDATE quest_template SET PrevQuestId=0, NextQuestId=13045, ExclusiveGroup=0, NextQuestInChain=13045 WHERE entry=13044; – If There Are Survivors
UPDATE quest_template SET PrevQuestId=13044, NextQuestId=13070, ExclusiveGroup=0, NextQuestInChain=13070 WHERE entry=13045; – Into The Wild Green Yonder
UPDATE quest_template SET Method=0, PrevQuestId=13045, NextQuestId=13086, ExclusiveGroup=0, NextQuestInChain=13086 WHERE entry=13070; – A Cold Front Approaches
UPDATE quest_template SET PrevQuestId=13070, NextQuestId=0, ExclusiveGroup=0, NextQuestInChain=0 WHERE entry=13086; – The Last Line Of Defense
UPDATE quest_template SET PrevQuestId=13086, NextQuestId=0, ExclusiveGroup=0, NextQuestInChain=0 WHERE entry=13104; – Once More Unto The Breach, Hero
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestInChain=0 WHERE entry=13122; – The Scourgestone
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestInChain=0 WHERE entry=13118; – The Purging of Scourgeholme
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestInChain=0 WHERE entry=13110; – The Restless Dead
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestInChain=0 WHERE entry=13125; – The Air Stands Still
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestInChain=0 WHERE entry=13130; – The Stone That Started a Revolution
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestInChain=0 WHERE entry=13135; – It Could Kill Us All
UPDATE quest_template SET PrevQuestId=0, NextQuestId=13141, ExclusiveGroup=0, NextQuestInChain=13141 WHERE entry=13139; – Into The Cold Heart Of Northrend
UPDATE quest_template SET PrevQuestId=13139, NextQuestId=13157, ExclusiveGroup=0, NextQuestInChain=13157 WHERE entry=13141; – The Battle For Crusaders Pinnacle UPDATE quest_templateSETPrevQuestId=13141, NextQuestId=0, ExclusiveGroup=0, NextQuestInChain=0 WHERE entry`=13135; – The Crusader’s Pinnacle

– Phase for objects in Crusader’s Pinnacle (Scourge controlled)
UPDATE gameobject SET phaseMask=194 WHERE id IN (192936, 192938, 192953, 192954, 192955, 192956, 192957, 192982, 192995, 193003, 192958, 192959, 192960, 192961, 192962, 192963, 192964, 192965, 192966, 192967, 192968, 192969, 192970, 192971, 192972, 192973, 192974, 192975, 192976, 192977, 192978, 192979, 192980, 192981, 192983, 192985, 192986, 192987, 192988, 192989, 192990, 192991, 192994, 192934, 192935, 192992, 192993, 193002, 192997, 192996, 192999, 193000, 193001, 192936, 192937);

– Phase for a few objects in Scourgeholme
UPDATE gameobject SET phaseMask=195 WHERE id IN (192576, 192577, 192575, 192579, 192578);

– Misc Objects in Argent Vanguard to be visible in all phases
UPDATE gameobject SET phaseMask=195 WHERE guid IN (62021, 62027, 62356, 62359, 62353, 62071, 62061);

– Duplicates of the objects in Argent Vanguard, no need to have 2 of each if they have no special interaction with a particular phase
DELETE FROM gameobject WHERE guid IN (100101, 100484, 100097, 100433, 100098, 100432, 100104, 100485);

– Phase for the walls and towers for all phases except during “The last line of defense”
UPDATE gameobject SET phaseMask=131 WHERE guid IN (61089, 61066, 61027, 61056, 61004, 60999, 60996, 60976);

– Phase for walls during “The last line of defense”, they need a separate object here because they interact directly with the phase
UPDATE gameobject SET phaseMask=64 WHERE guid IN (100441, 100440, 100438, 100439, 100437, 100436, 100435, 100434);

– Phase for objects in The Breach after “The last line of defense”
UPDATE gameobject SET phaseMask=129 WHERE id IN (192797, 192798, 192799, 192800, 192801, 192802, 192803, 192804, 192805);

– Phase for objects in The Breach before “The last line of defense”
UPDATE gameobject SET phaseMask=66 WHERE id IN (192161, 192162, 192166, 192806, 192807, 192808, 192809, 192810, 192811, 192812, 192813, 192814, 192815, 192816, 192817);

– Phase for NPCs in Argent Vanguard that should be in all phases (except during "The last line of defense)
UPDATE creature SET phaseMask=131 WHERE guid IN (121664, 124618, 124483, 121684, 121671, 121696, 121668, 121693, 121669, 121677, 121697, 121666, 121662, 121678, 121670, 121680, 121685, 121683, 121665, 121682, 121686, 121663, 121695, 124527, 124491, 124661, 123618, 124497, 124323, 124340, 124332, 207301, 207298, 207296, 207297, 207299, 207300, 124442);

– Same as with the objects, delete duplicate creatures that have no direct interaction with a particular phase, a single creature can fulfill that role.
DELETE FROM creature WHERE guid IN (207239, 207264, 207260, 207251, 207245, 207256, 207242, 207254, 207243, 207246, 207257, 207241, 207237, 207247, 207244, 207248, 207252, 207250, 207240, 207249, 207253, 207238, 207255, 207263, 207261, 207265, 207258, 207262, 207259);

– Phase for NPCs only present until “The last line of defense”
UPDATE creature SET phaseMask=2 WHERE guid IN (207229, 207228, 207234, 207233, 207232, 207235, 207236, 207227, 207222, 207230, 207231, 207223, 202409, 207225, 207226);

– Phase for Siegemaster Fezzik (He is the only one present up until and during “the last line of defense”)
UPDATE creature SET phaseMask=66 WHERE guid=207224;

– Phase for NPCs in the Valley of Echoes before “The last line of defense”
UPDATE creature SET phaseMask=2 WHERE guid IN (207290, 207289, 207288, 207294, 207293, 207295, 207284, 207282, 207286, 207285, 207287, 207291, 207283, 207281, 207292, 207280);

– Phase for Creatures on the Valley of Echoes before “The last line of defense”
UPDATE creature SET phaseMask=2 WHERE id IN (30206, 30273);

– Phase for mobs and NPCs in the Valley of Echoes and The breach after “The last line of defense”
UPDATE creature SET phaseMask=129 WHERE guid IN (124320, 124302, 124297, 124317, 124338, 124333, 124329, 124341, 124301, 124307, 124319, 124339, 124337, 124324, 124298, 124308, 124303, 124302, 124320, 124330, 124326, 124309, 124335, 124318, 124299, 124311, 124310, 124325, 124327, 124300, 124315, 124314, 124313, 124312, 124321, 124336, 124334, 124331, 124328, 121679, 121667, 121681, 121694, 121700, 121692, 203393, 121698, 121672);

– Add missing creatures (Highlord Tirion Fordring in Argent Vanguard after “the last line of defense”, The Ebon Watcher, Crusade Architect Silas and Crusade Engineer Spitzpatrick in Valley of Echoes after “the last line of defense”)
DELETE FROM creature WHERE id IN (30596, 30686, 30714, 30677);
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, MovementType) VALUES
(@NEXT, 30596, 571, 1, 128, 6376.657227, 239.053055, 396.047028, 4.8044, 300, 0, 0, 0),
(@NEXT+1, 30686, 571, 1, 128, 6370.632324, 232.238022, 396.046051, 1.352186, 300, 0, 0, 0),
(@NEXT+2, 30714, 571, 1, 128, 6371.689941, 239.699265, 396.899902, 4.792617, 300, 0, 0, 0),
(@NEXT+3, 30677, 571, 1, 128, 6259.583496, 50.420799, 388.508667, 0.846391, 300, 0, 0, 0);

– Set correct faction for Crusade Architect Silas
UPDATE creature_template SET faction_H=2070, faction_A=2070 WHERE entry=30686;

– Mount for Highlord Tirion Fordring in Argent Vanguard after “the last line of defense”
DELETE FROM creature_template_addon WHERE entry=30677
INSERT INTO creature_template_addon (entry, path_id, mount, bytes1, bytes2, emote, auras) VALUES
(30677, 0, 2325, 0, 0, 0, NULL);

– Phase for Father Gustav in Valley of Echoes after “the last line of defense”
UPDATE creature SET phaseMask=128 WHERE id=30683;

– Add missing unique creatures in Scorugeholme (The Lich king, Salranax the Flesh Render, High Priest Yath’amon and Underking Talonox – One for each phase they are in, since they are hostile mobs)
DELETE FROM creature WHERE id IN (30443, 30829, 30830, 30831);
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, MovementType) VALUES
(@NEXT+4, 30443, 571, 1, 2, 6697.528809, 583.609131, 428.332916, 4.108414, 300, 0, 0, 0),
(@NEXT+5, 30829, 571, 1, 2, 6838.717285, 594.347046, 426.230652, 4.020655, 300, 0, 0, 0),
(@NEXT+6, 30831, 571, 1, 2, 6869.587891, 422.763397, 470.783386, 1.087875, 300, 0, 0, 0),
(@NEXT+7, 30830, 571, 1, 2, 7211.243652, 667.650146, 488.187103, 2.689305, 300, 0, 0, 0),
(@NEXT+8, 30829, 571, 1, 128, 6838.717285, 594.347046, 426.230652, 4.020655, 300, 0, 0, 0),
(@NEXT+9, 30831, 571, 1, 128, 6869.587891, 422.763397, 470.783386, 1.087875, 300, 0, 0, 0),
(@NEXT+10, 30830, 571, 1, 128, 7211.243652, 667.650146, 488.187103, 2.689305, 300, 0, 0, 0);

– Lich King flag, non attackable unless he engages first
UPDATE creature_template SET unit_flags=256 WHERE entry=30443;

– Set right exp value and level for Underking Talonox
UPDATE creature_template SET exp=2, minlevel=79, maxlevel=79 WHERE entry=30830;

– Set the right phase for the already existing creatures (Including Captured crusaders)
UPDATE creature SET phaseMask=1 WHERE id IN (31037, 31039, 31043, 31040);
UPDATE creature SET phaseMask=2 WHERE id IN (30544, 30407);

– Set flag extra to 64 for creatures in Scourgeholme during the first phase, they should not give XP.
UPDATE creature_template SET flags_extra=64 WHERE entry IN (30544, 30407);

– Add the right mobs for each phase, they have a different id for each phase. Some mobs are only on 2 phases, not all 3 (Reanimated crusader and Gargoyles). They have the exact same points as their already spawned counterparts which belong to the final phase.
– NOTE: The ones with a currentwaypoint set have it simply because that’s the waypoint the of their already spawned counterpart. I use it simply as a guideline for me to create the paths for all these new ones and its changed back to 0 after I set the new paths with creature_addon later in this SQL.

– Forgotten Depths High Priest
DELETE FROM creature WHERE id IN (30203, 30543);
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, MovementType) VALUES
(@NEXT+11, 30203, 571, 1, 2, 6879.92, 493.899, 467.957, 1.67552, 300, 0, 0, 0),
(@NEXT+12, 30203, 571, 1, 2, 6916.07, 467.629, 468.799, 0.977384, 300, 0, 0, 0),
(@NEXT+13, 30203, 571, 1, 2, 6858.02, 453.902, 471.767, 4.7822, 300, 0, 0, 0),
(@NEXT+14, 30203, 571, 1, 2, 6835.59, 414.643, 471.77, 0.802851, 300, 0, 0, 0),
(@NEXT+15, 30203, 571, 1, 2, 6903.22, 430.778, 471.764, 3.56047, 300, 0, 0, 0),
(@NEXT+16, 30203, 571, 1, 2, 6881.51, 391.672, 471.771, 1.93731, 300, 0, 0, 0),
(@NEXT+17, 30203, 571, 1, 2, 6877.89, 665.768, 425.523, 1.29154, 300, 0, 0, 0),
(@NEXT+18, 30203, 571, 1, 2, 6553.27, 579.069, 419.185, 3.90954, 300, 0, 0, 0),
(@NEXT+19, 30203, 571, 1, 2, 6560.22, 584.094, 419.185, 0.645772, 300, 0, 0, 0),
(@NEXT+20, 30203, 571, 1, 2, 6747.13, 456.848, 419.284, 1.39626, 300, 0, 0, 0),
(@NEXT+21, 30203, 571, 1, 2, 7062.78, 521.156, 526.362, 5.75959, 300, 0, 0, 0),
(@NEXT+22, 30203, 571, 1, 2, 7068.11, 477.927, 530.313, 0.558505, 300, 0, 0, 0),
(@NEXT+23, 30203, 571, 1, 2, 6689.02, 570.998, 424.525, 3.9968, 300, 0, 0, 0),
(@NEXT+24, 30203, 571, 1, 2, 6745.99, 449.016, 419.284, 4.4855, 300, 0, 0, 0),
(@NEXT+25, 30203, 571, 1, 2, 6809.11, 843.341, 381.335, 3.23154, 300, 0, 1217160, 2),
(@NEXT+26, 30203, 571, 1, 2, 6901.58, 727.055, 420.546, 3.24233, 300, 0, 1217170, 2),
(@NEXT+27, 30203, 571, 1, 2, 7002.27, 602.799, 476.138, 5.93303, 300, 0, 1217200, 2),
(@NEXT+28, 30543, 571, 1, 128, 6879.92, 493.899, 467.957, 1.67552, 300, 0, 0, 0),
(@NEXT+29, 30543, 571, 1, 128, 6916.07, 467.629, 468.799, 0.977384, 300, 0, 0, 0),
(@NEXT+30, 30543, 571, 1, 128, 6858.02, 453.902, 471.767, 4.7822, 300, 0, 0, 0),
(@NEXT+31, 30543, 571, 1, 128, 6835.59, 414.643, 471.77, 0.802851, 300, 0, 0, 0),
(@NEXT+32, 30543, 571, 1, 128, 6903.22, 430.778, 471.764, 3.56047, 300, 0, 0, 0),
(@NEXT+33, 30543, 571, 1, 128, 6881.51, 391.672, 471.771, 1.93731, 300, 0, 0, 0),
(@NEXT+34, 30543, 571, 1, 128, 6877.89, 665.768, 425.523, 1.29154, 300, 0, 0, 0),
(@NEXT+35, 30543, 571, 1, 128, 6553.27, 579.069, 419.185, 3.90954, 300, 0, 0, 0),
(@NEXT+36, 30543, 571, 1, 128, 6560.22, 584.094, 419.185, 0.645772, 300, 0, 0, 0),
(@NEXT+37, 30543, 571, 1, 128, 6747.13, 456.848, 419.284, 1.39626, 300, 0, 0, 0),
(@NEXT+38, 30543, 571, 1, 128, 7062.78, 521.156, 526.362, 5.75959, 300, 0, 0, 0),
(@NEXT+39, 30543, 571, 1, 128, 7068.11, 477.927, 530.313, 0.558505, 300, 0, 0, 0),
(@NEXT+40, 30543, 571, 1, 128, 6689.02, 570.998, 424.525, 3.9968, 300, 0, 0, 0),
(@NEXT+41, 30543, 571, 1, 128, 6745.99, 449.016, 419.284, 4.4855, 300, 0, 0, 0),
(@NEXT+42, 30543, 571, 1, 128, 6809.11, 843.341, 381.335, 3.23154, 300, 0, 1217160, 2),
(@NEXT+43, 30543, 571, 1, 128, 6901.58, 727.055, 420.546, 3.24233, 300, 0, 1217170, 2),
(@NEXT+44, 30543, 571, 1, 128, 7002.27, 602.799, 476.138, 5.93303, 300, 0, 1217200, 2);

– Reanimated Crusader
DELETE FROM creature WHERE id=30202;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, MovementType) VALUES
(@NEXT+45, 30202, 571, 1, 128, 6770.55, 386.311, 421.153, 2.7317, 300, 5, 0, 1),
(@NEXT+46, 30202, 571, 1, 128, 6655.04, 328.894, 442.276, 0.929563, 300, 5, 0, 1),
(@NEXT+47, 30202, 571, 1, 128, 6448.62, 618.154, 432.265, 2.1122, 300, 5, 0, 1),
(@NEXT+48, 30202, 571, 1, 128, 6471.01, 562.99, 438.4, 3.5549, 300, 5, 0, 1),
(@NEXT+49, 30202, 571, 1, 128, 6448.03, 608.829, 433.982, 1.32629, 300, 5, 0, 1),
(@NEXT+50, 30202, 571, 1, 128, 6526.88, 512.588, 412.274, 2.77181, 300, 5, 0, 1),
(@NEXT+51, 30202, 571, 1, 128, 6513.35, 523.34, 415.136, 0.501217, 300, 5, 0, 1),
(@NEXT+52, 30202, 571, 1, 128, 6556.12, 636.946, 408.191, 1.22528, 300, 5, 0, 1),
(@NEXT+53, 30202, 571, 1, 128, 6697.52, 476.907, 401.588, 2.99677, 300, 5, 0, 1),
(@NEXT+54, 30202, 571, 1, 128, 6704.82, 441.489, 406.499, 3.35221, 300, 5, 0, 1),
(@NEXT+55, 30202, 571, 1, 128, 6723.74, 417.997, 412.953, 4.18409, 300, 5, 0, 1),
(@NEXT+56, 30202, 571, 1, 128, 6644.93, 422.78, 401.853, 3.19711, 300, 5, 0, 1),
(@NEXT+57, 30202, 571, 1, 128, 6654.72, 492.468, 398.206, 2.81552, 300, 5, 0, 1),
(@NEXT+58, 30202, 571, 1, 128, 6630.65, 458.047, 398.995, 5.84132, 300, 5, 0, 1),
(@NEXT+59, 30202, 571, 1, 128, 6661.41, 584.323, 408.676, 0.785398, 300, 5, 0, 1),
(@NEXT+60, 30202, 571, 1, 128, 6518.07, 616.422, 410.051, 2.1325, 300, 5, 0, 1),
(@NEXT+61, 30202, 571, 1, 128, 6514.78, 664.2, 399.383, 0.291176, 300, 5, 0, 1),
(@NEXT+62, 30202, 571, 1, 128, 6563.32, 539.29, 404.559, 0.919091, 300, 5, 0, 1),
(@NEXT+63, 30202, 571, 1, 128, 6617.92, 519.797, 396.795, 1.55615, 300, 5, 0, 1),
(@NEXT+64, 30202, 571, 1, 128, 6643.92, 633.926, 404.904, 1.84373, 300, 5, 0, 1),
(@NEXT+65, 30202, 571, 1, 128, 6592.97, 620.213, 408.135, 1.80125, 300, 5, 0, 1),
(@NEXT+66, 30202, 571, 1, 128, 6707.83, 535.834, 405.493, 5.84095, 300, 5, 0, 1),
(@NEXT+67, 30202, 571, 1, 128, 6758.07, 512.831, 410.903, 2.78648, 300, 5, 0, 1),
(@NEXT+68, 30202, 571, 1, 128, 6764.6, 535.115, 415.201, 3.48219, 300, 5, 0, 1),
(@NEXT+69, 30202, 571, 1, 128, 6669.68, 527.603, 401.525, 5.13205, 300, 5, 0, 1),
(@NEXT+70, 30202, 571, 1, 128, 6613, 590.876, 403.789, 2.88047, 300, 5, 0, 1),
(@NEXT+71, 30202, 571, 1, 128, 6545.45, 535.57, 407.359, 1.50529, 300, 5, 0, 1),
(@NEXT+72, 30202, 571, 1, 128, 6623.12, 684.658, 405.968, 4.4761, 300, 5, 0, 1),
(@NEXT+73, 30202, 571, 1, 128, 6584.43, 679.969, 406.644, 2.11574, 300, 5, 0, 1),
(@NEXT+74, 30202, 571, 1, 128, 6576.55, 460.06, 408.104, 0.763302, 300, 5, 0, 1),
(@NEXT+75, 30202, 571, 1, 128, 6606.58, 489.339, 398.158, 5.60417, 300, 5, 0, 1),
(@NEXT+76, 30202, 571, 1, 128, 6563.66, 505.381, 403.489, 0.430917, 300, 5, 0, 1),
(@NEXT+77, 30202, 571, 1, 128, 6579.71, 401.572, 416.112, 6.10437, 300, 5, 0, 1),
(@NEXT+78, 30202, 571, 1, 128, 6632.51, 382.456, 412.855, 5.91518, 300, 5, 0, 1),
(@NEXT+79, 30202, 571, 1, 128, 6721.48, 346.299, 424.582, 5.91108, 300, 5, 0, 1),
(@NEXT+80, 30202, 571, 1, 128, 6657.63, 385.761, 411.832, 2.05191, 300, 5, 0, 1),
(@NEXT+81, 30202, 571, 1, 128, 6709.57, 384.33, 414.698, 3.57468, 300, 5, 0, 1),
(@NEXT+82, 30202, 571, 1, 128, 6722.58, 492.852, 405.603, 5.6035, 300, 5, 0, 1);

– Forgotten Depths Underking
DELETE FROM creature WHERE guid BETWEEN @NEXT+83 and @NEXT+89 AND id=30544;
DELETE FROM creature WHERE id=30541;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, MovementType) VALUES
(@NEXT+83, 30544, 571, 1, 2, 6962.62, 734.955, 445.296, 4.4855, 300, 0, 0, 0),
(@NEXT+84, 30544, 571, 1, 2, 7056.29, 572.491, 497.073, 2.23402, 300, 0, 0, 0),
(@NEXT+85, 30544, 571, 1, 2, 7005.75, 714.752, 468.614, 3.07178, 300, 0, 0, 0),
(@NEXT+86, 30544, 571, 1, 2, 6809.11, 843.341, 381.335, 5.7554, 300, 0, 1217280, 0),
(@NEXT+87, 30544, 571, 1, 2, 6437.59, 604.262, 439.155, 0.369627, 300, 0, 1217310, 2),
(@NEXT+89, 30544, 571, 1, 2, 7002.27, 602.799, 476.138, 5.7192, 300, 0, 1217350, 0),
(@NEXT+90, 30541, 571, 1, 128, 6962.62, 734.955, 445.296, 4.4855, 300, 0, 0, 0),
(@NEXT+91, 30541, 571, 1, 128, 7056.29, 572.491, 497.073, 2.23402, 300, 0, 0, 0),
(@NEXT+92, 30541, 571, 1, 128, 7005.75, 714.752, 468.614, 3.07178, 300, 0, 0, 0),
(@NEXT+93, 30541, 571, 1, 128, 6760.42, 515.039, 411.837, 3.66099, 300, 0, 1217270, 2),
(@NEXT+94, 30541, 571, 1, 128, 6809.11, 843.341, 381.335, 5.7554, 300, 0, 1217280, 0),
(@NEXT+95, 30541, 571, 1, 128, 7002.27, 602.799, 476.138, 5.7192, 300, 0, 1217350, 0),
(@NEXT+96, 30541, 571, 1, 128, 6769.89, 628.623, 425.97, -1.65443, 300, 0, 1217290, 2),
(@NEXT+97, 30541, 571, 1, 128, 6697.87, 429.598, 406.569, 1.77104, 300, 0, 1217300, 2),
(@NEXT+98, 30541, 571, 1, 128, 6437.59, 604.262, 439.155, 0.369627, 300, 0, 1217310, 2),
(@NEXT+99, 30541, 571, 1, 128, 6622.62, 585.661, 402.875, 5.61246, 300, 0, 1217320, 2),
(@NEXT+100, 30541, 571, 1, 128, 6710.23, 685.938, 408.296, 3.24837, 300, 0, 1217330, 2),
(@NEXT+101, 30541, 571, 1, 128, 6575.6, 465.094, 407.446, 2.69257, 300, 0, 1217360, 2),
(@NEXT+102, 30541, 571, 1, 128, 6641.92, 396.595, 408.673, 2.55359, 300, 0, 1217370, 2);

– Wrathstrike Gargoyle
DELETE FROM creature WHERE id=30482;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, MovementType) VALUES
(@NEXT+103, 30482, 571, 1, 128, 7059.52, 455.611, 581.574, 3.35148, 300, 0, 1217550, 2),
(@NEXT+104, 30482, 571, 1, 128, 7009.05, 544.408, 610.468, 3.23607, 300, 0, 1217540, 2),
(@NEXT+105, 30482, 571, 1, 128, 6804.5, 702.568, 436.191, 0.0303077, 300, 0, 1217530, 2),
(@NEXT+106, 30482, 571, 1, 128, 6799.31, 642.302, 459.819, 3.88908, 300, 0, 1217520, 2),
(@NEXT+107, 30482, 571, 1, 128, 6753.66, 410.408, 446.625, 3.19529, 300, 0, 1217510, 2),
(@NEXT+108, 30482, 571, 1, 128, 6597.14, 566.743, 445.037, 1.40898, 300, 0, 1217500, 2),
(@NEXT+109, 30482, 571, 1, 128, 6596.2, 564.031, 445.111, 4.27718, 300, 0, 1217490, 2),
(@NEXT+110, 30482, 571, 1, 128, 6559.29, 413.281, 462.263, 6.13325, 300, 0, 1217480, 2);

– Set right inhabit type for the second phase version of Wrathstrike Gargoyle (They should be able to fly)
UPDATE creature_template SET InhabitType=7 WHERE entry=30482;

– Set right faction for previously not spawned creatures
UPDATE creature_template SET faction_H=2068, faction_A=2068 WHERE entry IN (30541, 30203, 30543, 30202, 30482, 30830, 30831, 30829, 30443);

– Add missing mobs in the Valley of Echoes during the first phase. The DB has no spawn info on these ones so I added them in a logical number and places, feel free to skip this part if its not “correct” enough. (If anyone has actual sniffs for the location of these mobs feel free to share)

– Forgotten Depths Slayer for first phase (id:30333, not the same one that should appear during "The last line of defense)
DELETE FROM creature WHERE id=30333;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, MovementType) VALUES
(@NEXT+111, 30333, 571, 1, 2, 6150.518066, 147.111313, 372.771057, 0.197990, 300, 7, 0, 1),
(@NEXT+112, 30333, 571, 1, 2, 6212.446777, 130.204849, 377.827118, 0.657450, 300, 7, 0, 1),
(@NEXT+113, 30333, 571, 1, 2, 6110.951660, 83.364746, 371.154419, 1.230786, 300, 7, 0, 1),
(@NEXT+114, 30333, 571, 1, 2, 6047.241699, 178.537430, 353.744293, 5.322711, 300, 7, 0, 1),
(@NEXT+115, 30333, 571, 1, 2, 6182.750000, 199.942261, 380.134705, 4.996765, 300, 7, 0, 1),
(@NEXT+116, 30333, 571, 1, 2, 6219.042480, 236.113785, 388.062317, 5.134206, 300, 7, 0, 1),
(@NEXT+117, 30333, 571, 1, 2, 6421.106445, 188.232880, 395.621826, 2.247868, 300, 7, 0, 1),
(@NEXT+118, 30333, 571, 1, 2, 6351.036621, 91.049683, 392.077698, 1.969049, 300, 7, 0, 1),
(@NEXT+119, 30333, 571, 1, 2, 6264.502930, 147.837006, 383.335876, 2.346035, 300, 7, 0, 1);

– Forgotten Depths Acolyte
DELETE FROM creature WHERE id=30205;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, MovementType) VALUES
(@NEXT+120, 30205, 571, 1, 2, 6278.386230, 199.642899, 385.989258, 5.377527, 300, 0, 0, 0),
(@NEXT+121, 30205, 571, 1, 2, 6229.345703, 133.398743, 379.961639, 3.759608, 300, 0, 0, 0),
(@NEXT+122, 30205, 571, 1, 2, 6087.062012, 136.313293, 367.117310, 4.827752, 300, 0, 0, 0),
(@NEXT+123, 30205, 571, 1, 2, 6127.606445, 172.50610, 370.652832, 6.190416, 300, 0, 0, 0),
(@NEXT+124, 30205, 571, 1, 2, 6149.881836, 220.209808, 379.919403, 5.361032, 300, 0, 0, 0),
(@NEXT+125, 30205, 571, 1, 2, 6422.211426, 148.303436, 395.890137, 1.964183, 300, 0, 0, 0),
(@NEXT+126, 30205, 571, 1, 2, 6375.815918, 81.636124, 394.968140, 2.337249, 300, 0, 0, 0),
(@NEXT+127, 30205, 571, 1, 2, 6333.330566, 29.062647, 389.581329, 1.508653, 300, 0, 0, 0),
(@NEXT+128, 30205, 571, 1, 2, 6130.472656, 172.082047, 370.962646, 5.695776, 300, 0, 0, 0);


[/SPOILER]

Pathing:

[SPOILER]-- Pathing for newly added Wrathstrike Gargoyles

– Wrathstrike Gargoyle 1
SET @NPC = (SELECT guid FROM creature WHERE id=30482 AND currentwaypoint=1217550);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 7060.05, 455.727, 581.492, 0, 0, 0, 100, 0),
(@PATH, 2, 6982.99, 465.858, 581.492, 0, 0, 0, 100, 0),
(@PATH, 3, 6963.94, 516.342, 581.492, 0, 0, 0, 100, 0),
(@PATH, 4, 7012.51, 555.944, 581.492, 0, 0, 0, 100, 0),
(@PATH, 5, 7062.92, 517.784, 566.464, 0, 0, 0, 100, 0),
(@PATH, 6, 7074.5, 487.171, 566.464, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30482 AND currentwaypoint=1217550;

– Wrathstrike Gargoyle 2
SET @NPC = (SELECT guid FROM creature WHERE id=30482 AND currentwaypoint=1217540);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6975.12, 457.238, 608.122, 0, 0, 0, 100, 0),
(@PATH, 2, 6994.13, 442.679, 608.122, 0, 0, 0, 100, 0),
(@PATH, 3, 7024.58, 437.239, 608.122, 0, 0, 0, 100, 0),
(@PATH, 4, 7055.78, 456.622, 580.705, 0, 0, 0, 100, 0),
(@PATH, 5, 7069.78, 488.277, 580.705, 0, 0, 0, 100, 0),
(@PATH, 6, 7057.18, 540.235, 608.205, 0, 0, 0, 100, 0),
(@PATH, 7, 6978.62, 537.405, 608.205, 0, 0, 0, 100, 0),
(@PATH, 8, 6960.95, 489.864, 595.233, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30482 AND currentwaypoint=1217540;

– Wrathstrike Gargoyle 3
SET @NPC = (SELECT guid FROM creature WHERE id=30482 AND currentwaypoint=1217530);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6817.71, 701.731, 436.81, 0, 0, 0, 100, 0),
(@PATH, 2, 6839.81, 671.33, 438.476, 0, 0, 0, 100, 0),
(@PATH, 3, 6771.48, 625.298, 444.032, 0, 0, 0, 100, 0),
(@PATH, 4, 6729.31, 607.063, 451.504, 0, 0, 0, 100, 0),
(@PATH, 5, 6689.26, 569.483, 444.032, 0, 0, 0, 100, 0),
(@PATH, 6, 6664.17, 580.683, 449.976, 0, 0, 0, 100, 0),
(@PATH, 7, 6657.52, 638.465, 440.893, 0, 0, 0, 100, 0),
(@PATH, 8, 6664.19, 665.048, 444.032, 0, 0, 0, 100, 0),
(@PATH, 9, 6735.33, 692.836, 433.938, 0, 0, 0, 100, 0),
(@PATH, 10, 6741.25, 694.33, 433.56, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30482 AND currentwaypoint=1217530;

– Wrathstrike Gargoyle 4
SET @NPC = (SELECT guid FROM creature WHERE id=30482 AND currentwaypoint=1217520);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6808.92, 649.929, 459.327, 0, 0, 0, 100, 0),
(@PATH, 2, 6779.63, 606.717, 465.077, 0, 0, 0, 100, 0),
(@PATH, 3, 6799.14, 541.206, 474.66, 0, 0, 0, 100, 0),
(@PATH, 4, 6863.37, 520.467, 465.077, 0, 0, 0, 100, 0),
(@PATH, 5, 6900.8, 554.799, 459.216, 0, 0, 0, 100, 0),
(@PATH, 6, 6904.96, 624.433, 471.549, 0, 0, 0, 100, 0),
(@PATH, 7, 6860.9, 661.477, 465.077, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30482 AND currentwaypoint=1217520;

– Wrathstrike Gargoyle 5
SET @NPC = (SELECT guid FROM creature WHERE id=30482 AND currentwaypoint=1217510);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6764.29, 413.94, 446.625, 0, 0, 0, 100, 0),
(@PATH, 2, 6727.13, 417.659, 446.625, 0, 0, 0, 100, 0),
(@PATH, 3, 6709.2, 445.43, 446.625, 0, 0, 0, 100, 0),
(@PATH, 4, 6714.21, 476.942, 446.625, 0, 0, 0, 100, 0),
(@PATH, 5, 6760.44, 491.312, 446.625, 0, 0, 0, 100, 0),
(@PATH, 6, 6786.47, 463.163, 446.625, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30482 AND currentwaypoint=1217510;

– Wrathstrike Gargoyle 6
SET @NPC = (SELECT guid FROM creature WHERE id=30482 AND currentwaypoint=1217500);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6589.56, 608.719, 445.037, 0, 0, 0, 100, 0),
(@PATH, 2, 6536.49, 613.397, 445.037, 0, 0, 0, 100, 0),
(@PATH, 3, 6515.31, 571.263, 445.037, 0, 0, 0, 100, 0),
(@PATH, 4, 6540.83, 538.391, 445.037, 0, 0, 0, 100, 0),
(@PATH, 5, 6561.1, 543.055, 445.037, 0, 0, 0, 100, 0),
(@PATH, 6, 6595.09, 559.099, 445.037, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30482 AND currentwaypoint=1217500;

– Wrathstrike Gargoyle 7
SET @NPC = (SELECT guid FROM creature WHERE id=30482 AND currentwaypoint=1217490);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6661.58, 545.496, 432.795, 0, 0, 0, 100, 0),
(@PATH, 2, 6659.48, 589.326, 447.184, 0, 0, 0, 100, 0),
(@PATH, 3, 6628.78, 594.459, 446.434, 0, 0, 0, 100, 0),
(@PATH, 4, 6613.69, 584.967, 446.434, 0, 0, 0, 100, 0),
(@PATH, 5, 6595.45, 562.222, 444.795, 0, 0, 0, 100, 0),
(@PATH, 6, 6595.77, 535.16, 436.934, 0, 0, 0, 100, 0),
(@PATH, 7, 6631, 528.616, 450.823, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30482 AND currentwaypoint=1217490;

– Wrathstrike Gargoyle 8
SET @NPC = (SELECT guid FROM creature WHERE id=30482 AND currentwaypoint=1217480);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6585.6, 408.848, 446.514, 0, 0, 0, 100, 0),
(@PATH, 2, 6607.57, 400.701, 444.745, 0, 0, 0, 100, 0),
(@PATH, 3, 6647.89, 401.573, 444.745, 0, 0, 0, 100, 0),
(@PATH, 4, 6667.63, 414.847, 433.912, 0, 0, 0, 100, 0),
(@PATH, 5, 6648.87, 462.506, 444.745, 0, 0, 0, 100, 0),
(@PATH, 6, 6592.11, 478.371, 444.745, 0, 0, 0, 100, 0),
(@PATH, 7, 6501.26, 474.703, 444.745, 0, 0, 0, 100, 0),
(@PATH, 8, 6484.09, 430.145, 485.097, 0, 0, 0, 100, 0),
(@PATH, 9, 6519.88, 419.711, 485.097, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30482 AND currentwaypoint=1217480;

– Pathing for newly added Forgotten Depths Underkings

– Forgotten Depths Underking 1
SET @NPC = (SELECT guid FROM creature WHERE id=30541 AND currentwaypoint=1217290);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6788.09, 633.101, 426.095, 0, 0, 0, 100, 0),
(@PATH, 2, 6789.98, 619.743, 423.47, 0, 0, 0, 100, 0),
(@PATH, 3, 6766.65, 606.497, 423.42, 0, 0, 0, 100, 0),
(@PATH, 4, 6740.19, 597.458, 425.39, 0, 0, 0, 100, 0),
(@PATH, 5, 6725.25, 595.632, 423.432, 0, 0, 0, 100, 0),
(@PATH, 6, 6713.96, 602.526, 423.595, 0, 0, 0, 100, 0),
(@PATH, 7, 6720.27, 613.862, 423.47, 0, 0, 0, 100, 0),
(@PATH, 8, 6736.25, 614.921, 423.545, 0, 0, 0, 100, 0),
(@PATH, 9, 6769.89, 628.623, 425.97, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30541 AND currentwaypoint=1217290;

– Forgotten Depths Underking 2
SET @NPC = (SELECT guid FROM creature WHERE id=30541 AND currentwaypoint=1217300);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6698.5, 458.598, 404.586, 0, 0, 0, 100, 0),
(@PATH, 2, 6695.69, 473.044, 401.838, 0, 0, 0, 100, 0),
(@PATH, 3, 6665, 494.007, 397.863, 0, 0, 0, 100, 0),
(@PATH, 4, 6621.27, 520.385, 397.423, 0, 0, 0, 100, 0),
(@PATH, 5, 6601.79, 552.183, 399.092, 0, 0, 0, 100, 0),
(@PATH, 6, 6579.75, 536.627, 401.438, 0, 0, 0, 100, 0),
(@PATH, 7, 6599.6, 508.629, 398.578, 0, 0, 0, 100, 0),
(@PATH, 8, 6627.41, 480.195, 397.408, 0, 0, 0, 100, 0),
(@PATH, 9, 6643.31, 442.918, 399.225, 0, 0, 0, 100, 0),
(@PATH, 10, 6674.23, 416.566, 405.944, 0, 0, 0, 100, 0),
(@PATH, 11, 6697.87, 429.598, 406.569, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30541 AND currentwaypoint=1217300;

– Forgotten Depths Underking 3-A
SET @NPC = (SELECT guid FROM creature WHERE id=30541 AND currentwaypoint=1217310);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6395.82, 618.184, 452.633, 0, 0, 0, 100, 0),
(@PATH, 2, 6358.26, 637.18, 462.167, 0, 0, 0, 100, 0),
(@PATH, 3, 6370.71, 666.535, 453.289, 0, 0, 0, 100, 0),
(@PATH, 4, 6375.45, 676.189, 445.42, 0, 0, 0, 100, 0),
(@PATH, 5, 6407.42, 688.589, 434.416, 0, 0, 0, 100, 0),
(@PATH, 6, 6429.66, 650.562, 435.434, 0, 0, 0, 100, 0),
(@PATH, 7, 6461.86, 627.093, 426.405, 0, 0, 0, 100, 0),
(@PATH, 8, 6482.61, 623.854, 419.051, 0, 0, 0, 100, 0),
(@PATH, 9, 6486.97, 594.615, 420.488, 0, 0, 0, 100, 0),
(@PATH, 10, 6457.97, 595.352, 432.948, 0, 0, 0, 100, 0),
(@PATH, 11, 6437.59, 604.262, 439.155, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30541 AND currentwaypoint=1217310;

– Forgotten Depths Underking 3-B
SET @NPC = (SELECT guid FROM creature WHERE id=30544 AND currentwaypoint=1217310);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6395.82, 618.184, 452.633, 0, 0, 0, 100, 0),
(@PATH, 2, 6358.26, 637.18, 462.167, 0, 0, 0, 100, 0),
(@PATH, 3, 6370.71, 666.535, 453.289, 0, 0, 0, 100, 0),
(@PATH, 4, 6375.45, 676.189, 445.42, 0, 0, 0, 100, 0),
(@PATH, 5, 6407.42, 688.589, 434.416, 0, 0, 0, 100, 0),
(@PATH, 6, 6429.66, 650.562, 435.434, 0, 0, 0, 100, 0),
(@PATH, 7, 6461.86, 627.093, 426.405, 0, 0, 0, 100, 0),
(@PATH, 8, 6482.61, 623.854, 419.051, 0, 0, 0, 100, 0),
(@PATH, 9, 6486.97, 594.615, 420.488, 0, 0, 0, 100, 0),
(@PATH, 10, 6457.97, 595.352, 432.948, 0, 0, 0, 100, 0),
(@PATH, 11, 6437.59, 604.262, 439.155, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30544 AND currentwaypoint=1217310;

– Forgotten Depths Underking 4
SET @NPC = (SELECT guid FROM creature WHERE id=30541 AND currentwaypoint=1217320);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6618.91, 606.085, 403.839, 0, 0, 0, 100, 0),
(@PATH, 2, 6608.22, 599.539, 403.875, 0, 0, 0, 100, 0),
(@PATH, 3, 6613.37, 574.047, 401.125, 0, 0, 0, 100, 0),
(@PATH, 4, 6638.76, 543.87, 399.563, 0, 0, 0, 100, 0),
(@PATH, 5, 6667.59, 521.002, 401.025, 0, 0, 0, 100, 0),
(@PATH, 6, 6697.97, 501.482, 400.775, 0, 0, 0, 100, 0),
(@PATH, 7, 6711.98, 522.746, 404.353, 0, 0, 0, 100, 0),
(@PATH, 8, 6702.31, 534.57, 405.75, 0, 0, 0, 100, 0),
(@PATH, 9, 6679.62, 541.533, 402.209, 0, 0, 0, 100, 0),
(@PATH, 10, 6660.61, 557.771, 404.938, 0, 0, 0, 100, 0),
(@PATH, 11, 6639.28, 577.426, 402.927, 0, 0, 0, 100, 0),
(@PATH, 12, 6622.62, 585.661, 402.875, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30541 AND currentwaypoint=1217320;

– Forgotten Depths Underking 5
SET @NPC = (SELECT guid FROM creature WHERE id=30541 AND currentwaypoint=1217330);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6746.43, 700.445, 407.534, 0, 0, 0, 100, 0),
(@PATH, 2, 6767.77, 702.447, 407.514, 0, 0, 0, 100, 0),
(@PATH, 3, 6780.88, 716.948, 410.264, 0, 0, 0, 100, 0),
(@PATH, 4, 6761.32, 729.055, 407.659, 0, 0, 0, 100, 0),
(@PATH, 5, 6723.36, 725.67, 406.194, 0, 0, 0, 100, 0),
(@PATH, 6, 6706.1, 712.006, 411.069, 0, 0, 0, 100, 0),
(@PATH, 7, 6687.8, 701.721, 412.302, 0, 0, 0, 100, 0),
(@PATH, 8, 6668.08, 685.327, 409.231, 0, 0, 0, 100, 0),
(@PATH, 9, 6660.25, 674.05, 407.891, 0, 0, 0, 100, 0),
(@PATH, 10, 6667.72, 662.234, 407.017, 0, 0, 0, 100, 0),
(@PATH, 11, 6710.23, 685.938, 408.296, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30541 AND currentwaypoint=1217330;

– Forgotten Depths Underking 6
SET @NPC = (SELECT guid FROM creature WHERE id=30541 AND currentwaypoint=1217360);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6552.96, 457.401, 412.93, 0, 0, 0, 100, 0),
(@PATH, 2, 6551.69, 432.508, 416.436, 0, 0, 0, 100, 0),
(@PATH, 3, 6568.85, 415.311, 415.444, 0, 0, 0, 100, 0),
(@PATH, 4, 6572.9, 410.44, 415.694, 0, 0, 0, 100, 0),
(@PATH, 5, 6577.95, 406.559, 415.694, 0, 0, 0, 100, 0),
(@PATH, 6, 6591.15, 393.959, 416.312, 0, 0, 0, 100, 0),
(@PATH, 7, 6624.85, 389.377, 412.855, 0, 0, 0, 100, 0),
(@PATH, 8, 6642.71, 398.137, 408.048, 0, 0, 0, 100, 0),
(@PATH, 9, 6642.51, 414.137, 403.978, 0, 0, 0, 100, 0),
(@PATH, 10, 6613.73, 435.694, 403.495, 0, 0, 0, 100, 0),
(@PATH, 11, 6598.72, 453.969, 403.196, 0, 0, 0, 100, 0),
(@PATH, 12, 6575.6, 465.094, 407.446, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30541 AND currentwaypoint=1217360;

– Forgotten Depths Underking 7
SET @NPC = (SELECT guid FROM creature WHERE id=30541 AND currentwaypoint=1217370);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6665.69, 385.118, 411.923, 0, 0, 0, 100, 0),
(@PATH, 2, 6688.12, 372.121, 414.309, 0, 0, 0, 100, 0),
(@PATH, 3, 6681.71, 337.864, 421.782, 0, 0, 0, 100, 0),
(@PATH, 4, 6711.15, 330.663, 422.912, 0, 0, 0, 100, 0),
(@PATH, 5, 6729, 353.407, 426.957, 0, 0, 0, 100, 0),
(@PATH, 6, 6759.39, 371.963, 426.169, 0, 0, 0, 100, 0),
(@PATH, 7, 6742.83, 378.436, 419.544, 0, 0, 0, 100, 0),
(@PATH, 8, 6710.78, 380.507, 415.679, 0, 0, 0, 100, 0),
(@PATH, 9, 6685.82, 397.148, 408.809, 0, 0, 0, 100, 0),
(@PATH, 10, 6655.42, 406.866, 405.478, 0, 0, 0, 100, 0),
(@PATH, 11, 6641.92, 396.595, 408.673, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30541 AND currentwaypoint=1217370;

– Forgotten Depths Underking 8
SET @NPC = (SELECT guid FROM creature WHERE id=30541 AND currentwaypoint=1217270);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6751.58, 521.709, 409.087, 0, 0, 0, 100, 0),
(@PATH, 2, 6775.59, 535.639, 418.22, 0, 0, 0, 100, 0),
(@PATH, 3, 6790.69, 546.924, 424.095, 0, 0, 0, 100, 0),
(@PATH, 4, 6797.82, 545.099, 424.47, 0, 0, 0, 100, 0),
(@PATH, 5, 6787.22, 530.424, 421.059, 0, 0, 0, 100, 0),
(@PATH, 6, 6760.42, 515.039, 411.837, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30541 AND currentwaypoint=1217270;

– Pathing for newly added Forgotten Depths High Priests. There are A and B versions because only the ones from the last phase were already spawned in DB and had their pathing. This didn’t occur with the Forgotten Depths Underkings because their first phase counterpats were already spawned (at least the ones with paths, the rest weren’t). 2 of them don’t get the current waypoint removed yet because its used for a guideline for creature_formations later.

– Forgotten Depths High Priest 1-A
SET @NPC = (SELECT guid FROM creature WHERE id=30203 AND currentwaypoint=1217160);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6845.23, 827.966, 390.654, 0, 0, 0, 100, 0),
(@PATH, 2, 6869.87, 814.437, 394.231, 0, 0, 0, 100, 0),
(@PATH, 3, 6885.91, 795.247, 398.76, 0, 0, 0, 100, 0),
(@PATH, 4, 6889.42, 776.747, 410.135, 0, 0, 0, 100, 0),
(@PATH, 5, 6887.17, 765.483, 417.106, 0, 0, 0, 100, 0),
(@PATH, 6, 6916.54, 751.385, 415.552, 0, 0, 0, 100, 0),
(@PATH, 7, 6922.71, 770.234, 412.379, 0, 0, 0, 100, 0),
(@PATH, 8, 6936.68, 795.657, 409.292, 0, 0, 0, 100, 0),
(@PATH, 9, 6946.95, 821.291, 405.551, 0, 0, 0, 100, 0),
(@PATH, 10, 6940.67, 819.911, 406.551, 0, 0, 0, 100, 0),
(@PATH, 11, 6918.09, 776.126, 411.879, 0, 0, 0, 100, 0),
(@PATH, 12, 6903.68, 745.868, 416.802, 0, 0, 0, 100, 0),
(@PATH, 13, 6892.57, 727.713, 418.396, 0, 0, 0, 100, 0),
(@PATH, 14, 6855.19, 723.309, 414.328, 0, 0, 0, 100, 0),
(@PATH, 15, 6810.95, 714.736, 409.567, 0, 0, 0, 100, 0),
(@PATH, 16, 6778.23, 711.31, 408.139, 0, 0, 0, 100, 0),
(@PATH, 17, 6749.77, 708.742, 407.159, 0, 0, 0, 100, 0),
(@PATH, 18, 6724.11, 709.65, 409.563, 0, 0, 0, 100, 0),
(@PATH, 19, 6720.02, 695.631, 407.296, 0, 0, 0, 100, 0),
(@PATH, 20, 6730.44, 731.649, 404.319, 0, 0, 0, 100, 0),
(@PATH, 21, 6727.1, 774.371, 385.328, 0, 0, 0, 100, 0),
(@PATH, 22, 6722.82, 816.964, 376.654, 0, 0, 0, 100, 0),
(@PATH, 23, 6733.84, 849.984, 376.012, 0, 0, 0, 100, 0),
(@PATH, 24, 6753.25, 867.14, 376.46, 0, 0, 0, 100, 0),
(@PATH, 25, 6786.71, 850.127, 379.337, 0, 0, 0, 100, 0),
(@PATH, 26, 6817.16, 840.912, 382.21, 0, 0, 0, 100, 0);

– Forgotten Depths High Priest 1-B
SET @NPC = (SELECT guid FROM creature WHERE id=30543 AND currentwaypoint=1217160);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6845.23, 827.966, 390.654, 0, 0, 0, 100, 0),
(@PATH, 2, 6869.87, 814.437, 394.231, 0, 0, 0, 100, 0),
(@PATH, 3, 6885.91, 795.247, 398.76, 0, 0, 0, 100, 0),
(@PATH, 4, 6889.42, 776.747, 410.135, 0, 0, 0, 100, 0),
(@PATH, 5, 6887.17, 765.483, 417.106, 0, 0, 0, 100, 0),
(@PATH, 6, 6916.54, 751.385, 415.552, 0, 0, 0, 100, 0),
(@PATH, 7, 6922.71, 770.234, 412.379, 0, 0, 0, 100, 0),
(@PATH, 8, 6936.68, 795.657, 409.292, 0, 0, 0, 100, 0),
(@PATH, 9, 6946.95, 821.291, 405.551, 0, 0, 0, 100, 0),
(@PATH, 10, 6940.67, 819.911, 406.551, 0, 0, 0, 100, 0),
(@PATH, 11, 6918.09, 776.126, 411.879, 0, 0, 0, 100, 0),
(@PATH, 12, 6903.68, 745.868, 416.802, 0, 0, 0, 100, 0),
(@PATH, 13, 6892.57, 727.713, 418.396, 0, 0, 0, 100, 0),
(@PATH, 14, 6855.19, 723.309, 414.328, 0, 0, 0, 100, 0),
(@PATH, 15, 6810.95, 714.736, 409.567, 0, 0, 0, 100, 0),
(@PATH, 16, 6778.23, 711.31, 408.139, 0, 0, 0, 100, 0),
(@PATH, 17, 6749.77, 708.742, 407.159, 0, 0, 0, 100, 0),
(@PATH, 18, 6724.11, 709.65, 409.563, 0, 0, 0, 100, 0),
(@PATH, 19, 6720.02, 695.631, 407.296, 0, 0, 0, 100, 0),
(@PATH, 20, 6730.44, 731.649, 404.319, 0, 0, 0, 100, 0),
(@PATH, 21, 6727.1, 774.371, 385.328, 0, 0, 0, 100, 0),
(@PATH, 22, 6722.82, 816.964, 376.654, 0, 0, 0, 100, 0),
(@PATH, 23, 6733.84, 849.984, 376.012, 0, 0, 0, 100, 0),
(@PATH, 24, 6753.25, 867.14, 376.46, 0, 0, 0, 100, 0),
(@PATH, 25, 6786.71, 850.127, 379.337, 0, 0, 0, 100, 0),
(@PATH, 26, 6817.16, 840.912, 382.21, 0, 0, 0, 100, 0);

– Forgotten Depths High Priest 2-A
SET @NPC = (SELECT guid FROM creature WHERE id=30203 AND currentwaypoint=1217170);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6877.06, 727.294, 415.646, 0, 0, 0, 100, 0),
(@PATH, 2, 6840.86, 720.367, 413.578, 0, 0, 0, 100, 0),
(@PATH, 3, 6804.06, 715.519, 409.067, 0, 0, 0, 100, 0),
(@PATH, 4, 6775.7, 711.378, 408.139, 0, 0, 0, 100, 0),
(@PATH, 5, 6775.7, 706.114, 408.014, 0, 0, 0, 100, 0),
(@PATH, 6, 6806.69, 710.446, 409.317, 0, 0, 0, 100, 0),
(@PATH, 7, 6840.86, 715.128, 414.078, 0, 0, 0, 100, 0),
(@PATH, 8, 6885.64, 719.654, 417.771, 0, 0, 0, 100, 0),
(@PATH, 9, 6901.58, 727.055, 420.546, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30203 AND currentwaypoint=1217170;

– Forgotten Depths High Priest 2-B
SET @NPC = (SELECT guid FROM creature WHERE id=30543 AND currentwaypoint=1217170);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 6877.06, 727.294, 415.646, 0, 0, 0, 100, 0),
(@PATH, 2, 6840.86, 720.367, 413.578, 0, 0, 0, 100, 0),
(@PATH, 3, 6804.06, 715.519, 409.067, 0, 0, 0, 100, 0),
(@PATH, 4, 6775.7, 711.378, 408.139, 0, 0, 0, 100, 0),
(@PATH, 5, 6775.7, 706.114, 408.014, 0, 0, 0, 100, 0),
(@PATH, 6, 6806.69, 710.446, 409.317, 0, 0, 0, 100, 0),
(@PATH, 7, 6840.86, 715.128, 414.078, 0, 0, 0, 100, 0),
(@PATH, 8, 6885.64, 719.654, 417.771, 0, 0, 0, 100, 0),
(@PATH, 9, 6901.58, 727.055, 420.546, 0, 0, 0, 100, 0);

UPDATE creature SET currentwaypoint=0 WHERE id=30543 AND currentwaypoint=1217170;

– Forgotten Depths High Priest 3-A
SET @NPC = (SELECT guid FROM creature WHERE id=30203 AND currentwaypoint=1217200);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 7028.06, 593.528, 484.848, 0, 0, 0, 100, 0),
(@PATH, 2, 7050.86, 587.232, 490.487, 0, 0, 0, 100, 0),
(@PATH, 3, 7088.02, 583.536, 496.767, 0, 0, 0, 100, 0),
(@PATH, 4, 7135.53, 587.626, 498.11, 0, 0, 0, 100, 0),
(@PATH, 5, 7174.15, 581.088, 498.373, 0, 0, 0, 100, 0),
(@PATH, 6, 7200, 579.166, 498.248, 0, 0, 0, 100, 0),
(@PATH, 7, 7217.31, 586.021, 496.983, 0, 0, 0, 100, 0),
(@PATH, 8, 7203.83, 615.728, 490.388, 0, 0, 0, 100, 0),
(@PATH, 9, 7164.62, 625.286, 496.707, 0, 0, 0, 100, 0),
(@PATH, 10, 7126.29, 619.13, 497.944, 0, 0, 0, 100, 0),
(@PATH, 11, 7094.89, 587.951, 498.017, 0, 0, 0, 100, 0),
(@PATH, 12, 7050.28, 590.763, 490.362, 0, 0, 0, 100, 0),
(@PATH, 13, 7013.81, 602.295, 479.513, 0, 0, 0, 100, 0),
(@PATH, 14, 6987.71, 624.076, 465.805, 0, 0, 0, 100, 0),
(@PATH, 15, 6964.91, 625.148, 460.924, 0, 0, 0, 100, 0),
(@PATH, 16, 6944.73, 587.153, 467.576, 0, 0, 0, 100, 0),
(@PATH, 17, 6927.86, 556.953, 466.828, 0, 0, 0, 100, 0),
(@PATH, 18, 6919.79, 527.804, 467.056, 0, 0, 0, 100, 0),
(@PATH, 19, 6907.68, 497.326, 466.719, 0, 0, 0, 100, 0),
(@PATH, 20, 6914.34, 512.11, 466.681, 0, 0, 0, 100, 0),
(@PATH, 21, 6926.01, 537.956, 466.578, 0, 0, 0, 100, 0),
(@PATH, 22, 6938.29, 577.003, 466.951, 0, 0, 0, 100, 0),
(@PATH, 23, 6952.16, 594.699, 466.951, 0, 0, 0, 100, 0),
(@PATH, 24, 6969.78, 616.559, 463.68, 0, 0, 0, 100, 0),
(@PATH, 25, 6985.14, 615.594, 467.305, 0, 0, 0, 100, 0),
(@PATH, 26, 7002.27, 602.799, 476.138, 0, 0, 0, 100, 0);

– Forgotten Depths High Priest 3-B
SET @NPC = (SELECT guid FROM creature WHERE id=30543 AND currentwaypoint=1217200);
SET @PATH := @NPC * 10;

DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id) VALUES (@NPC,@PATH);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH, 1, 7028.06, 593.528, 484.848, 0, 0, 0, 100, 0),
(@PATH, 2, 7050.86, 587.232, 490.487, 0, 0, 0, 100, 0),
(@PATH, 3, 7088.02, 583.536, 496.767, 0, 0, 0, 100, 0),
(@PATH, 4, 7135.53, 587.626, 498.11, 0, 0, 0, 100, 0),
(@PATH, 5, 7174.15, 581.088, 498.373, 0, 0, 0, 100, 0),
(@PATH, 6, 7200, 579.166, 498.248, 0, 0, 0, 100, 0),
(@PATH, 7, 7217.31, 586.021, 496.983, 0, 0, 0, 100, 0),
(@PATH, 8, 7203.83, 615.728, 490.388, 0, 0, 0, 100, 0),
(@PATH, 9, 7164.62, 625.286, 496.707, 0, 0, 0, 100, 0),
(@PATH, 10, 7126.29, 619.13, 497.944, 0, 0, 0, 100, 0),
(@PATH, 11, 7094.89, 587.951, 498.017, 0, 0, 0, 100, 0),
(@PATH, 12, 7050.28, 590.763, 490.362, 0, 0, 0, 100, 0),
(@PATH, 13, 7013.81, 602.295, 479.513, 0, 0, 0, 100, 0),
(@PATH, 14, 6987.71, 624.076, 465.805, 0, 0, 0, 100, 0),
(@PATH, 15, 6964.91, 625.148, 460.924, 0, 0, 0, 100, 0),
(@PATH, 16, 6944.73, 587.153, 467.576, 0, 0, 0, 100, 0),
(@PATH, 17, 6927.86, 556.953, 466.828, 0, 0, 0, 100, 0),
(@PATH, 18, 6919.79, 527.804, 467.056, 0, 0, 0, 100, 0),
(@PATH, 19, 6907.68, 497.326, 466.719, 0, 0, 0, 100, 0),
(@PATH, 20, 6914.34, 512.11, 466.681, 0, 0, 0, 100, 0),
(@PATH, 21, 6926.01, 537.956, 466.578, 0, 0, 0, 100, 0),
(@PATH, 22, 6938.29, 577.003, 466.951, 0, 0, 0, 100, 0),
(@PATH, 23, 6952.16, 594.699, 466.951, 0, 0, 0, 100, 0),
(@PATH, 24, 6969.78, 616.559, 463.68, 0, 0, 0, 100, 0),
(@PATH, 25, 6985.14, 615.594, 467.305, 0, 0, 0, 100, 0),
(@PATH, 26, 7002.27, 602.799, 476.138, 0, 0, 0, 100, 0);

-- The following are the paths for the newly added mobs that have the same spawn spot as a mob (different phase and id) that already had a path. The paths are exactly the same as their already spawned counterparts.

[/SPOILER]

A couple of crature_formations

[SPOILER]-- Create creature formations based on already existing ones. Also remove the final current waypoints.

– Creature Formation 1-A
SET @LEADER = (SELECT guid FROM creature WHERE id=30203 AND currentwaypoint=1217200);
SET @NPC = (SELECT guid FROM creature WHERE id=30544 AND currentwaypoint=1217350);

INSERT INTO creature_formations (leaderGUID,memberGUID,dist,angle,groupAI) VALUES
(@LEADER, @LEADER, 0, 0, 2),
(@LEADER, @NPC, 3, 0, 2);

UPDATE creature SET currentwaypoint=0 WHERE id=30203 AND currentwaypoint=1217200;
UPDATE creature SET currentwaypoint=0 WHERE id=30544 AND currentwaypoint=1217350;

– Creature Formation 1-B
SET @LEADER = (SELECT guid FROM creature WHERE id=30543 AND currentwaypoint=1217200);
SET @NPC = (SELECT guid FROM creature WHERE id=30541 AND currentwaypoint=1217350);

INSERT INTO creature_formations (leaderGUID,memberGUID,dist,angle,groupAI) VALUES
(@LEADER, @LEADER, 0, 0, 2),
(@LEADER, @NPC, 3, 0, 2);

UPDATE creature SET currentwaypoint=0 WHERE id=30543 AND currentwaypoint=1217200;
UPDATE creature SET currentwaypoint=0 WHERE id=30541 AND currentwaypoint=1217350;

– Creature Formation 2-A
SET @LEADER = (SELECT guid FROM creature WHERE id=30203 AND currentwaypoint=1217160);
SET @NPC = (SELECT guid FROM creature WHERE id=30544 AND currentwaypoint=1217280);

INSERT INTO creature_formations (leaderGUID,memberGUID,dist,angle,groupAI) VALUES
(@LEADER, @LEADER, 0, 0, 2),
(@LEADER, @NPC, 3, 0, 2);

UPDATE creature SET currentwaypoint=0 WHERE id=30203 AND currentwaypoint=1217160;
UPDATE creature SET currentwaypoint=0 WHERE id=30544 AND currentwaypoint=1217280;

– Creature Formation 2-B
SET @LEADER = (SELECT guid FROM creature WHERE id=30543 AND currentwaypoint=1217160);
SET @NPC = (SELECT guid FROM creature WHERE id=30541 AND currentwaypoint=1217280);

INSERT INTO creature_formations (leaderGUID,memberGUID,dist,angle,groupAI) VALUES
(@LEADER, @LEADER, 0, 0, 2),
(@LEADER, @NPC, 3, 0, 2);

UPDATE creature SET currentwaypoint=0 WHERE id=30543 AND currentwaypoint=1217160;
UPDATE creature SET currentwaypoint=0 WHERE id=30541 AND currentwaypoint=1217280;


[/SPOILER]

SAIs

[SPOILER]-- High Priest Yath’amon SAI

SET @ENTRY := 30831;
SET @SPELL_MIND_FLAY := 38243;
SET @SPELL_ENCASING_WEBS := 4962;
SET @SPELL_PSYCHIC_SCREAM := 34322;
SET @SPELL_VENOMOUS_BITE := 61705;

UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,0,0,100,0,1000,15000,5000,18000,11,@SPELL_MIND_FLAY,0,0,0,0,0,2,0,0,0,0,0,0,0,‘High Priest Yath’‘amon - Mind Flay’),
(@ENTRY,0,1,2,0,0,100,0,10000,20000,12000,22000,11,@SPELL_ENCASING_WEBS,0,0,0,0,0,2,0,0,0,0,0,0,0,‘High Priest Yath’‘amon - Encasing Webs’),
(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,11,@SPELL_VENOMOUS_BITE,0,0,0,0,0,2,0,0,0,0,0,0,0,‘High Priest Yath’‘amon - Venomous Bite’),
(@ENTRY,0,3,0,0,0,100,0,15000,40000,15000,40000,11,@SPELL_PSYCHIC_SCREAM,0,0,0,0,0,2,0,0,0,0,0,0,0,‘High Priest Yath’‘amon - Psychic Scream’);

– Salranax the Flesh Render

SET @ENTRY := 30829;
SET @SPELL_FROST_ARMOR := 18100;
SET @SPELL_COUNTERSPELL := 15122;
SET @SPELL_FIREBALL := 15242;
SET @SPELL_CONE_OF_COLD := 15244;

UPDATE creature_template SET AIName=‘SmartAI’ WHERE entry=@ENTRY;
DELETE FROM smart_scripts WHERE 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,action_type,action_param1,action_param2,action_param3,action_param4,action_param5,action_param6,target_type,target_param1,target_param2,target_param3,target_x,target_y,target_z,target_o,comment) VALUES
(@ENTRY,0,0,0,23,0,100,0,@SPELL_FROST_ARMOR,0,2000,2000,11,@SPELL_FROST_ARMOR,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Salranax the Flesh Render - Frost Armor if aura not present’),
(@ENTRY,0,1,0,0,0,100,0,20000,25000,20000,25000,11,@SPELL_COUNTERSPELL,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Salranax the Flesh Render - Counterspell’),
(@ENTRY,0,2,0,0,0,100,0,1000,2000,4000,8000,11,@SPELL_FIREBALL,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Salranax the Flesh Render - Fireball’),
(@ENTRY,0,3,0,0,0,100,0,10000,30000,10000,30000,11,@SPELL_CONE_OF_COLD,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Salranax the Flesh Render - Cone of Cold’);


[/SPOILER]

TO DO:

  • Add script and support for the quest “The Last Line of Defense” (id: 13086). Cannons missing vehicle data. Frostbrood Destroyers (id: 30575) for that quest need correct data. Forgotten Depth Slayers (id: 30593) for that quest need correct data.

  • Add script and support for the quest “The Battle for Crusader’s pinnacle” (id: 13141). Planting the banner at the pile of bones doesn’t start the fight event.

  • Add quotes and support for the Lich King (id: 30443) that is present during the first phase. He should also summon first phase versions of Frostbrood Destroyers (id: 30486) every now and then.

  • Add correct damage and abilities for the 3 named mobs required for the quest “The Air Stands Still” (id: 13125). Salranax the Flesh Render (id: 30829), High Priest Yath’amon (id: 30831) and Underking Talonox (id: 30830).

  • Add abilities to all creatures in Scourgeholme and the Valley of Echoes:

-Wrathstrike Gargoyle (id: 30482 and 31040)

-Forgotten Depths Underking (id: 30544, 30541 and 31039)

-Forgotten Depths High Priest (id: 30203, 30543 and 31037)

-Reanimated Crusader (id: 30202 and 31043)

-Carrion Fleshstripper (id: 30206)

-Forgotten Depths Slayer (id: 30333)

-Forgotten Depths Acolyte (id: 30205)

-Forgotten Depths Ambusher (id: 30204)

This is all I’ve made. If anyone has any opinion about it or thinks there should be some change in the SQLs please say so, would be very much appreciated.

A small summary to know from which Q to which Q is each pahse:

Argent Vanguard Chapter I (id: 57673) - First phase (in game Phase 2); from the start until “A Cold Front Approaches” (id: 13070) is completed.

Argent Vanguard Chapter II (id: 57569) - Second phase (in game Phase 64), used only for the Quest “The Last Line of Defense” (id: 13086); Starts when you finish “A Cold Front Approaches” (id: 13070) and ends when you finish “The Last Line of Defense” (id: 13086).

Argent Vanguard Chapter III (id: 57674) - Third phase (in game Phase 128); Starts when you finish “The Last Line of Defense” (id: 13086) and ends when you finish “The Battle for Crusader’s pinnacle” (id: 13141).

Last phase (in game Phase 1). This is the last state of the zone and it remains like this after you finish “The Battle for Crusader’s pinnacle” (id: 13141).

Looks good! =)

I suggest removing all the upper comma’s from numbers, they don’t follow the code standards. As well as maybe comment which spell is done in the spell_area SQL? (spellname) /emoticons/default_smile.png

+1

Added the aura names and Id next to the summary at the end.

I’ll remove the upper comma’s soon.

EDIT: Removed upper comma’s and also added a comment with the name and ids of the phase auras at the start.

some very nice work here, malcrom will want to have a look at this…

WTF is an “upper comma” ? They are called single quotes. (single quotation marks)

This is the shit I like to see. I have a sniff of the cannons just need to get it parsed. I already have the walls spawned for that phase.

Yeah the walls and towers for the phase during the last line of defense are already spawned, they just needed the right phase (64).

As for the cannons, from what I’ve seen they also get some sort of base under them, I guess its a GO but I couldn’t find it.

you can see them in that video, some sort of round wooden platform.

2 go’s under each.

Good job. I would like to point some things:

  • in the first SQL there are some missing delete statements; always delete what you are inserting

  • when assigning creature/GO guids you should do a “SET @NEXT = XXX;” at the top of the sql and then use @NEXT+0, @NEXT+1, etc when needed

I didn’t use DELETES when inserting creatures because while there are some missing it doesn’t mean there are none at all. Or should I delete the existing ones anyways and reinsert them? The only other place I see where I should have used DELETE is when I inserted into creature_template_addon, right?.

As for the guids, which value should I start with then? I thought that if I did it like this it simply assigned them the first open value in the table.

Always do your sql in a way that it can be ran over and over with the same result. Your present sql can only be ran once.

I’m amazed that there are no core work involved in all this (except the spells/abilities used here). Only SAI, which shows that it’s damn efficient!

using the guid 0 it will automatically assign a value but it is a bad practice. In the sql that you “give us” it should be “SET @NEXT = XXX;” (We’ll assign a number later); for testing you can use high values like 300000.

When inserting in creature delete by guid and by entry e.g “DELETE FROM creature WHERE guid BETWEEN @NEXT and @NEXT+50 AND id IN (1,2,3);” or you can simply delete by creature entry if you are inserting ALL the spawns of that entry

All inserts should be prefixed with a delete query; creature_template_addon too

Thx, I’ll remake those wrong/missing parts then.

Done, updated the first part, is it alright like this?

I’ll try to do the SAIs for the named mobs soon.

Everything seems all right, keep up the good work /emoticons/default_wink.png

It’s also a good idea to do this:

-- Guid for inserts SET @NEXT := XXX; -- Need 128 [/sql]

or something similar, just to make it a bit easier for whoever will be assigning the GUIDs to figure out if they can squeeze it in an empty set of unused GUIDs or whatever.

The GOs below the cannon seems to be some kind of barrel with the image of an axe upon it.

Perhaps that helps finding the right GO…

Updated first post SAIs for 2 of the mobs- High Priest Yath’amon and Salranax the Flesh Render. (I couldn’t get enough info on Underking Talonox’s spells frequency)

If anyone can provide with any combat logs or videos or anything about any mob in Valley of Echoes or scourgeholme it would be greatly appreciated.

Hmmm befoure quest last line of defence i see all mobs for that quest but when i get this quest i dont see any of these and canons are not spawned.