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_templateSET
PrevQuestId=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).