Argent Vanguard/Argent Pinnacle/Scourgeholme phasing

qaywsx · July 25, 2011, 1:50pm

Like I said, the quest is not working yet, the phasing is fine, but since the quest is not yet scripted you can’t get past that phase.

Tassader · August 15, 2011, 3:28am

The first post is missing PrevQuestId (and SkillOrClassMask) for quest 13105 - that is DK-only version of quest 13104 (13104 should be unaviable to DKs)

You will then need to use conditions table to link these 2 quests to the following 6.

l0g0s · January 30, 2012, 4:13pm

No more changes to this quest? is it possible to completed if applied your code?

thanks

Trista · February 23, 2012, 9:02am

http://www.trinityco…r-stands-still/ - all things connected with Salranax, Hight Priest and Talonox should be deleted.

In short the quest works as it should, to have all spawns you need to apply his first spoiler part. /Without the parts the are connected with the bosses, except Lich King./

Darion has like 3k+ if left without change I calculated the exact values needed and changed WDB, you can use them or just remove that part. Rest is working as intented.

Anyway, finished this part.

Inky · February 23, 2012, 3:45pm

Has this been pushed yet? It’s looking pretty damn good!

I’m kind of getting new in this, but I’ll see what I can do to make a fix as soon as I’m capable…

Cheers!

Trista · February 28, 2012, 7:58pm

Updates last post here with all info.

Trista · March 1, 2012, 8:24am

Updated last post with all the changes.

Green_Code · March 11, 2012, 10:49pm

Can somebody make a complete Script of this or at least give a to-do?

Would love to work on this

Trista · March 11, 2012, 11:36pm

Yeah:

Last Line of Defense - cannons need a spawn + objects under them. Also need to fix their skills /which saddly is ubber hard or atleast I couldn’t do anything, so kinda stalled it for now/. Also 1 Frostbrood Destroyer should spawn around cannon when it is being used and attack it, while do half circle after each hit.

Into the Wild Green Younder - this quest has wrong quest credit data. When you save webbed argent crusader, he needs to be drop off near the inifrmary to get credit, currently you get one wherever he is dropped.

The Lich King needs to be spawned + scripted for 1st phase. /mentioned in 1st post/.

The Battle for the Pinnacle isn’t touched at all, so need hell of a scripting.

That is all I can think of for now. TBH The Last Line of Defense is like mini LOTR battle, so has tons of work to do I just merely spawned some stuff. Oh, yeah and 1 Forgotten Depths Prist should be spawned around Salronox for the Air Stands Still.

That’s all I can think of atm and all left from what was stated in 1st post. I tested it till Last Line of Defense perhaps after there are more.

Green_Code · March 21, 2012, 2:13pm

Oke, i would be interested in doing the Battle for the Pinnacle. But i have no sniffs. If someone coud send me a PM or something…would be nice…

I am kinda confused why there are so much scripts in this tread… could you update your first post and maybe seperate each quest?

l0g0s · March 21, 2012, 4:48pm

anyone can put de ID of the object where de cannons are on?

a least like that we can spawn them better.

Trista · March 22, 2012, 9:21am

@Green_Code - I’m not the creator of this issue. I updated this post with all the stuff done so far, check it.

@l0g0s - http://www.trinityco…ine-of-defense/ - here is a separate one for The Last Line of Defense since it is too big and require too much work, there are ids of the objects, if you read it, feel free to spawn them, but it is a bit tricky, I’ve described the problem there.

– What has been done so far –

This all can be insert with no problems including The Last Line of Defense what has been done so far. /though I suggest to wait, if not going to work on it/.

The first spoiler fix script/style/import errors and add some fixes like DK special quest /class restriction and the normal one/ and remove some unused stuff that are done in the scripts further below. /that is appart from what the original creator did + it/.

[SPOILER]SET @NEXT := 300000;
– 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 id=13008; – Scourge Tactics
UPDATE quest_template SET PrevQuestId=13036, NextQuestId=13044, ExclusiveGroup=-13008 WHERE id=13039; – Defending The Vanguard
UPDATE quest_template SET PrevQuestId=13036, NextQuestId=13044, ExclusiveGroup=-13008 WHERE id=13040; – Curing The Incurable
UPDATE quest_template SET PrevQuestId=0, NextQuestId=13045, ExclusiveGroup=0, NextQuestidChain=13045 WHERE id=13044; – If There Are Survivors
UPDATE quest_template SET PrevQuestId=13044, NextQuestId=13070, ExclusiveGroup=0, NextQuestidChain=13070 WHERE id=13045; – Into The Wild Green Yonder
UPDATE quest_template SET Method=0, PrevQuestId=13045, NextQuestId=13086, ExclusiveGroup=0, NextQuestidChain=13086 WHERE id=13070; – A Cold Front Approaches
UPDATE quest_template SET PrevQuestId=13070, NextQuestId=0, ExclusiveGroup=0, NextQuestidChain=0 WHERE id=13086; – The Last Line Of Defense
– Fix restrictions for DK and all rest classes without DK
UPDATE quest_template SET PrevQuestId=13086, RequiredClasses=32,NextQuestId=0, ExclusiveGroup=0, NextQuestidChain=0 WHERE id=13104; – Once More Unto The Breach, Hero /Death Knight’s Special/
UPDATE quest_template SET PrevQuestId=13086, RequiredClasses=1502,NextQuestId=0, ExclusiveGroup=0, NextQuestidChain=0 WHERE id=13105; – Once More Unto The Breach, Hero
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestidChain=0 WHERE id=13122; – The Scourgestone
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestidChain=0 WHERE id=13118; – The Purging of Scourgeholme
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestidChain=0 WHERE id=13110; – The Restless Dead
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestidChain=0 WHERE id=13125; – The Air Stands Still
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestidChain=0 WHERE id=13130; – The Stone That Started a Revolution
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestidChain=0 WHERE id=13135; – It Could Kill Us All
UPDATE quest_template SET PrevQuestId=0, NextQuestId=13141, ExclusiveGroup=0, NextQuestidChain=13141 WHERE id=13139; – Into The Cold Heart Of Northrend
UPDATE quest_template SET PrevQuestId=13139, NextQuestId=13157, ExclusiveGroup=0, NextQuestidChain=13157 WHERE id=13141; – The Battle For Crusaders Pinnacle UPDATE quest_templateSETPrevQuestId=13141, NextQuestId=0, ExclusiveGroup=0, NextQuestidChain=0 WHERE id=13135; -- The Crusader's Pinnacle -- Phase for objects in Crusader's Pinnacle (Scourge controlled) UPDATE gameobjectSETphaseMask=194 WHERE idIN (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 UPDATEgameobjectSETphaseMask=195 WHERE idIN (192576, 192577, 192575, 192579, 192578); -- Misc Objects in Argent Vanguard to be visible in all phases UPDATEgameobjectSETphaseMask=195 WHERE guidIN (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 FROMgameobjectWHEREguidIN (100101, 100484, 100097, 100433, 100098, 100432, 100104, 100485); -- Phase for the walls and towers for all phases except during "The last line of defense" UPDATEgameobjectSETphaseMask=131 WHERE guidIN (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 UPDATEgameobjectSETphaseMask=64 WHERE guidIN (100441, 100440, 100438, 100439, 100437, 100436, 100435, 100434); -- Phase for objects in The Breach after "The last line of defense" UPDATEgameobjectSETphaseMask=129 WHERE idIN (192797, 192798, 192799, 192800, 192801, 192802, 192803, 192804, 192805); -- Phase for objects in The Breach before "The last line of defense" UPDATEgameobjectSETphaseMask=66 WHERE idIN (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) UPDATEcreatureSETphaseMask=131 WHERE guidIN (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 FROMcreatureWHEREguidIN (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" UPDATEcreatureSETphaseMask=2 WHERE guidIN (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") UPDATEcreatureSETphaseMask=66 WHERE guid=207224; -- Phase for NPCs in the Valley of Echoes before "The last line of defense" UPDATE creatureSETphaseMask=2 WHERE guidIN (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" UPDATEcreatureSETphaseMask=2 WHERE idIN (30206, 30273); -- Phase for mobs and NPCs in the Valley of Echoes and The breach after "The last line of defense" UPDATEcreatureSETphaseMask=129 WHERE guidIN (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 FROMcreatureWHEREidIN (30596, 30686, 30714, 30677); INSERT INTOcreature (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_templateSETfaction_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_addonWHEREentry=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 creatureSETphaseMask=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 creatureWHEREidIN (30443); INSERT INTOcreature (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); -- Lich King flag, non attackable unless he engages first UPDATE creature_templateSETunit_flags=256 WHERE entry=30443; -- Set the right phase for the already existing creatures (Including Captured crusaders) UPDATE creatureSETphaseMask=1 WHERE idIN (31037, 31039, 31040); UPDATEcreatureSETphaseMask=2 WHERE idIN (30544, 30407); UPDATEcreatureSETphaseMask=128 WHERE id=31043; -- Set flag extra to 64 for creatures in Scourgeholme during the first phase, they should not give XP. UPDATE creature_templateSETflags_extra=64 WHERE entryIN (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 FROMcreatureWHEREidIN (30203, 30543); INSERT INTOcreature (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 creatureWHEREid=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, 1, 6770.55, 386.311, 421.153, 2.7317, 300, 5, 0, 1), (@NEXT+46, 30202, 571, 1, 1, 6655.04, 328.894, 442.276, 0.929563, 300, 5, 0, 1), (@NEXT+47, 30202, 571, 1, 1, 6448.62, 618.154, 432.265, 2.1122, 300, 5, 0, 1), (@NEXT+48, 30202, 571, 1, 1, 6471.01, 562.99, 438.4, 3.5549, 300, 5, 0, 1), (@NEXT+49, 30202, 571, 1, 1, 6448.03, 608.829, 433.982, 1.32629, 300, 5, 0, 1), (@NEXT+50, 30202, 571, 1, 1, 6526.88, 512.588, 412.274, 2.77181, 300, 5, 0, 1), (@NEXT+51, 30202, 571, 1, 1, 6513.35, 523.34, 415.136, 0.501217, 300, 5, 0, 1), (@NEXT+52, 30202, 571, 1, 1, 6556.12, 636.946, 408.191, 1.22528, 300, 5, 0, 1), (@NEXT+53, 30202, 571, 1, 1, 6697.52, 476.907, 401.588, 2.99677, 300, 5, 0, 1), (@NEXT+54, 30202, 571, 1, 1, 6704.82, 441.489, 406.499, 3.35221, 300, 5, 0, 1), (@NEXT+55, 30202, 571, 1, 1, 6723.74, 417.997, 412.953, 4.18409, 300, 5, 0, 1), (@NEXT+56, 30202, 571, 1, 1, 6644.93, 422.78, 401.853, 3.19711, 300, 5, 0, 1), (@NEXT+57, 30202, 571, 1, 1, 6654.72, 492.468, 398.206, 2.81552, 300, 5, 0, 1), (@NEXT+58, 30202, 571, 1, 1, 6630.65, 458.047, 398.995, 5.84132, 300, 5, 0, 1), (@NEXT+59, 30202, 571, 1, 1, 6661.41, 584.323, 408.676, 0.785398, 300, 5, 0, 1), (@NEXT+60, 30202, 571, 1, 1, 6518.07, 616.422, 410.051, 2.1325, 300, 5, 0, 1), (@NEXT+61, 30202, 571, 1, 1, 6514.78, 664.2, 399.383, 0.291176, 300, 5, 0, 1), (@NEXT+62, 30202, 571, 1, 1, 6563.32, 539.29, 404.559, 0.919091, 300, 5, 0, 1), (@NEXT+63, 30202, 571, 1, 1, 6617.92, 519.797, 396.795, 1.55615, 300, 5, 0, 1), (@NEXT+64, 30202, 571, 1, 1, 6643.92, 633.926, 404.904, 1.84373, 300, 5, 0, 1), (@NEXT+65, 30202, 571, 1, 1, 6592.97, 620.213, 408.135, 1.80125, 300, 5, 0, 1), (@NEXT+66, 30202, 571, 1, 1, 6707.83, 535.834, 405.493, 5.84095, 300, 5, 0, 1), (@NEXT+67, 30202, 571, 1, 1, 6758.07, 512.831, 410.903, 2.78648, 300, 5, 0, 1), (@NEXT+68, 30202, 571, 1, 1, 6764.6, 535.115, 415.201, 3.48219, 300, 5, 0, 1), (@NEXT+69, 30202, 571, 1, 1, 6669.68, 527.603, 401.525, 5.13205, 300, 5, 0, 1), (@NEXT+70, 30202, 571, 1, 1, 6613, 590.876, 403.789, 2.88047, 300, 5, 0, 1), (@NEXT+71, 30202, 571, 1, 1, 6545.45, 535.57, 407.359, 1.50529, 300, 5, 0, 1), (@NEXT+72, 30202, 571, 1, 1, 6623.12, 684.658, 405.968, 4.4761, 300, 5, 0, 1), (@NEXT+73, 30202, 571, 1, 1, 6584.43, 679.969, 406.644, 2.11574, 300, 5, 0, 1), (@NEXT+74, 30202, 571, 1, 1, 6576.55, 460.06, 408.104, 0.763302, 300, 5, 0, 1), (@NEXT+75, 30202, 571, 1, 1, 6606.58, 489.339, 398.158, 5.60417, 300, 5, 0, 1), (@NEXT+76, 30202, 571, 1, 1, 6563.66, 505.381, 403.489, 0.430917, 300, 5, 0, 1), (@NEXT+77, 30202, 571, 1, 1, 6579.71, 401.572, 416.112, 6.10437, 300, 5, 0, 1), (@NEXT+78, 30202, 571, 1, 1, 6632.51, 382.456, 412.855, 5.91518, 300, 5, 0, 1), (@NEXT+79, 30202, 571, 1, 1, 6721.48, 346.299, 424.582, 5.91108, 300, 5, 0, 1), (@NEXT+80, 30202, 571, 1, 1, 6657.63, 385.761, 411.832, 2.05191, 300, 5, 0, 1), (@NEXT+81, 30202, 571, 1, 1, 6709.57, 384.33, 414.698, 3.57468, 300, 5, 0, 1), (@NEXT+82, 30202, 571, 1, 1, 6722.58, 492.852, 405.603, 5.6035, 300, 5, 0, 1); -- Forgotten Depths Underking DELETE FROM creatureWHEREguidBETWEEN @NEXT+83 and @NEXT+89 ANDid=30544; DELETE FROM creatureWHEREid=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 creatureWHEREid=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_templateSETInhabitType=7 WHERE entry=30482; -- Set right faction for previously not spawned creatures UPDATE creature_templateSETfaction_H=2068, faction_A=2068 WHERE entryIN (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 FROMcreatureWHEREid=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 creatureWHEREid=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);

-- Guid for inserts

[/SPOILER]

[Q] - The Air Stands Still: http://www.trinityco…r-stands-still/

Here are SAIs for all creatures mentioned in creator first post /that doesn’t include full support for Pinnacle + some stuff from The Last Line of Defense/:

[SPOILER]-- Forgotten Depths Underking ID:31039
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 31039;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=31039;
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
(31039,0,1,0,0,0,100,0,1000,2000,2000,7000,11,60802,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Underking - IC - Cast spell Mandible Crush’),
(31039,0,2,0,0,0,100,0,1500,2000,7000,12000,11,50283,0,0,0,0,0,0,0,2,0,0,0,0,0,‘Forgotten Depths Underking IC - Cast spell Blinding Swarm’);
– Forgotten Depths Underking ID: 30544
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30544;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30544;
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
(30544,0,1,0,0,0,100,0,1000,2000,2000,7000,11,60802,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Underking - IC - Cast spell Mandible Crush’),
(30544,0,2,0,0,0,100,0,1500,2000,7000,12000,11,50283,0,0,0,0,0,0,0,2,0,0,0,0,0,‘Forgotten Depths Underking - IC - Cast spell Blinding Swarm’);
– Forgotten Depths Underking ID: 30541
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30541;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30541;
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
(30541,0,1,0,0,0,100,0,1000,2000,2000,7000,11,60802,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Underking - IC - Cast spell Mandible Crush’),
(30541,0,2,0,0,0,100,0,1500,2000,7000,12000,11,50283,0,0,0,0,0,0,0,2,0,0,0,0,0,‘orgotten Depths Underking - IC - Cast spell Blinding Swarm’);
– Carrion Fleshstripper ID: 35201
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 35201;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=35201;
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
(35201,0,1,0,0,0,100,0,1000,2000,15000,17000,11,35201,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Carrion Fleshstripper IC - Cast spell Paralytic Poison’);
– Wrathstrike Gargoyle ID: 30482
UPDATE creature_template SET mechanic_immune_mask = 67108864, AIName= ‘SmartAI’ WHERE entry= 30482;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30482;
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
(30482,0,1,0,0,0,100,0,1000,2000,2500,7000,11,16564,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Wrathstrike Gargoyle IC - Cast spell Paralytic Poison’);
– Wrathstrike Gargoyle ID: 31040
UPDATE creature_template SET mechanic_immune_mask = 67108864,AIName= ‘SmartAI’ WHERE entry= 31040;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=31040;
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
(31040,0,1,0,0,0,100,0,1000,2000,2500,7000,11,16564,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Wrathstrike Gargoyle - IC - Cast spell Paralytic Poison’);
– Reanimated Crusader ID: 30202
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30202;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30202;
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
(30202,0,0,0,0,0,100,0,1000,5000,6500,12000,11,32674,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Reanimated Crusader - IC - Cast Avenger"s Shield’),
(30202,0,1,0,0,0,100,0,5000,10000,8500,20000,11,58154,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Reanimated Crusader - IC - Hammer of Injustice’),
(30202,0,2,0,2,0,100,0,10,90,7000,15000,11,58153,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Reanimated Crusader - On health percentage - Cast Unholy Light on self after Hammer of Injustice’),
(30202,0,3,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Reanimated Crusader - On friendly HP deficit - Cast Unholy Light on allies’);
– Forgotten Depths Slayer ID: 30333
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30333;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30333;
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
(30333,0,0,0,4,0,100,0,2000,20000,0,0,11,56223,0,0,0,0,0,19,30673,20,0,0,0,0,0,‘Forgotten Depths Slayer - On aggro - Cast Web Rope’), – On fight with Crusader webs them /dwarf/
(30333,0,1,0,0,0,100,0,1000,5000,2500,6500,11,54185,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Slayer - IC - Cast spell Claw Slash’);
– Forgotten Depths Slayer ID: 30593
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30593;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30593;
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
(30593,0,0,0,4,0,100,0,2000,20000,0,0,11,56223,0,0,0,0,0,19,30672,20,0,0,0,0,0,‘Forgotten Depths Slayer - On aggro - Cast Web Rope’), – On fight with Crusader webs them /belf/
(30593,0,1,0,0,0,100,0,1000,5000,2500,6500,11,54185,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Slayer - IC - Cast spell Claw Slash’);
– Forgotten Depths Slayer ID: 30673
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30673;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30673;
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
(30673,0,0,0,4,0,100,0,2000,20000,0,0,11,56223,0,0,0,0,0,19,30673,20,0,0,0,0,0,‘Forgotten Depths Slayer - On aggro - Cast Web Rope’), – On fight with Crusader webs them /dwarf/
(30673,0,1,0,0,0,100,0,1000,5000,2500,6500,11,54185,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Slayer - IC - Cast spell Claw Slash’);
– Forgotten Depths Acolyte ID: 30205
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30205;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30205;
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
(30205,0,0,0,4,0,100,0,2000,20000,0,0,11,56223,0,0,0,0,0,19,30672,20,0,0,0,0,0,‘Forgotten Depths Acolyte - On aggro - Spell cast Web Rope’), – On fight with Crusader webs them /belf/
(30205,0,1,0,0,0,100,0,1000,5000,30000,30000,11,60781,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Acolyte - IC - Cast spell Curse of Mending’),
(30205,0,2,0,0,0,100,0,1000,5000,2500,6500,11,16583,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Acolyte - IC - Cast spell Shadow Shock’);
– Forgotten Depths Ambusher ID: 30204
DELETE FROM creature_template_addon WHERE entry=30204;
INSERT INTO creature_template_addon (entry,bytes1) VALUES – Debugs the go out of snow animation
(30204,9);
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30204;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30204;
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
(30204,0,0,1,4,0,100,1,0,0,0,0,11,56418,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Ambusher - On aggro - Cast spell emerge From Snow /only visual + sent fly in air effect’), – If it is summoned by a cacoon it will knock back the player, if not most likely not
(30204,0,1,2,61,0,100,1,56418,0,0,0,91,9,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Forgotten Depths Ambusher - Linkedw ith event 0 - Remove field byte from creature addon that make it emerge on surface’),
(30204,0,2,0,61,0,100,1,56418,0,0,0,19,33554432,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Forgotten Depths Ambusher - Linked with event 1 - Remove field flag to make selectable’),
(30204,0,3,0,0,0,100,0,1000,5000,2500,6500,11,40505,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Ambusher - IC - Cast spell cleave’);
– Add SAI for Crusader of Virtue (Blood elf) /the 100+k one/
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 31033;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=31033;
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
(31033,0,0,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Crusader of Virtue (Blood elf) - On friendly HP deficit - Heal damaged friendly unit’);
– Add SAI for Crusader of Virtue (Dwarf)
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30672;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30672;
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
(30672,0,0,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Crusader of Virtue (Dwarf) - On friendly HP deficit - Heal damaged friendly unit’),
(30672,0,1,2,8,0,100,1,56223,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Dwarf) - On hit by spell web robe - Set unseen’),
(30672,0,2,3,61,0,100,1,56223,0,0,0,12,30407,7,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Dwarf) - Linked with event 1 - Summon Webbed crusader’),
(30672,0,3,0,61,0,100,0,56223,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Dwarf) - Linked with event 2 - Despawn’);
– Add SAI for Crusader of Virtue (Blood elf)
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30189;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30189;
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
(30189,0,0,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Crusader of Virtue (Blood elf) - On friendly HP deficit - Heal damaged friendly unit’),
(30189,0,1,2,8,0,100,1,56223,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Blood elf) - On hit by spell web robe - Set unseen’),
(30189,0,2,3,61,0,100,1,56223,0,0,0,12,30407,7,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Blood elf) - Linked with event 1 - Summon Webbed crusader’),
(30189,0,3,0,61,0,100,0,56223,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Blood elf) - Linked with event 2 - Despawn’);
– Add SAI for Frostbrood Destroyer - 30575
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30575;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30575;
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
(30575,0,1,0,0,0,100,0,1000,4000,10000,15000,11,53363,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Frostbrood Destroyer - IC - Spell cast Wing Buffet’),
(30575,0,2,0,0,0,100,0,2000,6500,10000,12000,11,57477,7,0,0,0,0,1,0,0,0,0,0,0,0,‘Frostbrood Destroyer - IC - Spell cast Freezing breath’);

-- SAIs for some world creatures

[/SPOILER]

[SPOILER]-- Fix Freed Crusader ID: 30274 mechanic - this is a small fix to an old Svanon script, couldn’t find the final version or there were some bugs, so remaked some stuff to face right direction and giving random buffs /the new addition/.
– Add SAI for Freed Crusader
SET @Freed_Crusader := 30274;
SET @Script0 := 320274000;
SET @Script1 := 320274001;
SET @Script2 := 320274002;
SET @Script3 := 320274003;
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry=30274;
DELETE FROM smart_scripts WHERE entryorguid IN (30274, @Script0, @Script1,@Script2,@Script3);
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
(@Freed_Crusader,0,0,1,54,0,100,0,0,0,0,0,87,@Script0,@Script1,@Script2,@Script0,@Script1,@Script2,1,0,0,0,0,0,0,0, ‘Freed Crusader - On creature summoned - Start random action list’),
– Action list 00
(@Script0,9,0,0,0,0,100,0,0,0,0,0,11,56525,0,0,0,0,0,21,20,0,0,0,0,0,0,‘Action 0 - BoFK’),
– Action list 01
(@Script1,9,0,0,0,0,100,0,0,0,0,0,11,56521,0,0,0,0,0,21,20,0,0,0,0,0,0,‘Action 0 - BoW’),
– Action list 02
(@Script2,9,0,0,0,0,100,0,0,0,0,0,11,56520,0,0,0,0,0,21,20,0,0,0,0,0,0,‘Action 0 - BoM’),
– Continue normal events
(@Freed_Crusader,0,1,0,61,0,100,0,0,0,0,0,1,0,1000,0,0,0,0,1,0,0,0,0,0,0,0, ‘Freed Crusader - Linked with event 0 - Say text 0’),
(@Freed_Crusader,0,2,0,52,0,100,0,0,30274,0,0,80,@Script3,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Freed Crusader - On text end - Start action list script 3’),
– Action list 03
(@Script3,9,0,0,0,0,100,0,0,0,0,0,11,58053,0,0,0,0,0,21,20,0,0,0,0,0,0, ‘Action 0 - Cast Holy Light on ally’),
(@Script3,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,6283.2700020,78.926147,391.827209,4, ‘Action 1 - Set orientation South /with target position/’), – Fixed now
(@Script3,9,2,0,0,0,100,0,2000,2000,0,0,46,20,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Action 2 - Run 20 yards’),
(@Script3,9,3,0,0,0,100,0,0,0,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Action 3 - Despawn after 3000 ms’);
– Fixed the text, had some errors
DELETE FROM creature_text WHERE entry=@Freed_Crusader;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(@Freed_Crusader,0,0,‘Thank you and farewell, friend. I must return to the Argent Vanguard.’,12,0,100,0,0,0,‘Freed Crusader gratitude’);

[/SPOILER]
Reanimated crusaders are fixed now, they had wrong phases, as for the quest “The Restless Dead” - I rewritted it.

[SPOILER]-- Fix [Q]{A/H} The Restless Dead - ID: 13110
– Reanimated Crusader SAI
SET @Reanimated_Crusader := 31043;
SET @Credit := 30546;
SET @HolyWater := 57806;
– Replace required npcorgameobject, because there was wrong unusused creature /not credit, since the spell that must hit the requirednpc has 31043 as set and not 30546, also the npc name has “unused” stated/.
UPDATE quest_template SET RequiredNpcOrGo1=@Reanimated_Crusader WHERE Id=13110;
– Аdd SAI for Reanimated Crusader
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry=@Reanimated_Crusader;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@Reanimated_Crusader;
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
(@Reanimated_Crusader,0,0,0,25,0,100,0,0,0,0,0,19,33554432,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Reanimated Crusader - On spawn/respawn - Remove flag unselectable’),
(@Reanimated_Crusader,0,1,0,8,0,100,0,@HolyWater,0,0,0,18,33554432,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Reanimated Crusader - On hit by spell Holy Water - Set field flag unselectable /to prevent more uses of the spell - acts as condition/’),
(@Reanimated_Crusader,0,2,0,0,0,100,0,1000,5000,6500,12000,11,32674,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Reanimated Crusader - IC - Cast Avenger"s Shield’),
(@Reanimated_Crusader,0,3,0,0,0,100,0,5000,10000,8500,20000,11,58154,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Reanimated Crusader - IC - Hammer of Injustice’),
(@Reanimated_Crusader,0,4,0,2,0,100,0,10,90,7000,15000,11,58153,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Reanimated Crusader - On health percentage - Cast Unholy Light on self after Hammer of Injustice’),
(@Reanimated_Crusader,0,5,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Reanimated Crusader - On friendly HP deficit - Cast Unholy Light on allies’);

[/SPOILER]
P.S.: As for the rest I just postphoned the entire work, since there were some things that were way beyond my limits and some stuff that core couldn’t handle yet, so I kinda started fixining easier stuff to gain more knowledge.

Discover · March 22, 2012, 4:11pm

thesensei, please start following codestyle for comment lines, else we will not apply your fixes once complete. /emoticons/default_smile.png

Good job by the way!

NPC NAME - EVENT TYPE - ACTION TYPE

ZxBiohazardZx · May 28, 2012, 9:28am

Pushed to repo today are:

Spawns & Spell_Area from post1:

– Guid for inserts
SET @NEXT := 134704; – need 129
– 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);
– 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);
– 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;
– 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);
– 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);

– – Spawnfixes –

– 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.
DELETE FROM creature WHERE id IN (30596,30686,30714,30677,30443,30829,30830,30831,30203,30543,30202,30541,30482,30333,30205);
DELETE FROM creature WHERE guid BETWEEN @NEXT+83 and @NEXT+89 AND id=30544;
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,MovementType) VALUES
– 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”)
(@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),
– 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)
(@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),
– Forgotten Depths High Priest
(@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
(@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
(@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
(@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),
– 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)
(@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
(@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);

Pathings & Formations (again from post 1)

– 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.
– 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);

– 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;

Quest-Chainings (from theSensei’s post)

– 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 id=13008; – Scourge Tactics
UPDATE quest_template SET PrevQuestId=13036, NextQuestId=13044, ExclusiveGroup=-13008 WHERE id=13039; – Defending The Vanguard
UPDATE quest_template SET PrevQuestId=13036, NextQuestId=13044, ExclusiveGroup=-13008 WHERE id=13040; – Curing The Incurable
UPDATE quest_template SET PrevQuestId=0, NextQuestId=13045, ExclusiveGroup=0, NextQuestIdChain=13045 WHERE id=13044; – If There Are Survivors
UPDATE quest_template SET PrevQuestId=13044, NextQuestId=13070, ExclusiveGroup=0, NextQuestIdChain=13070 WHERE id=13045; – Into The Wild Green Yonder
UPDATE quest_template SET Method=0, PrevQuestId=13045, NextQuestId=13086, ExclusiveGroup=0, NextQuestIdChain=13086 WHERE id=13070; – A Cold Front Approaches
UPDATE quest_template SET PrevQuestId=13070, NextQuestId=0, ExclusiveGroup=0, NextQuestidChain=0 WHERE id=13086; – The Last Line Of Defense
– Fix restrictions for DK and all rest classes without DK
UPDATE quest_template SET PrevQuestId=13086, RequiredClasses=32,NextQuestId=0, ExclusiveGroup=0, NextQuestIdChain=0 WHERE id=13104; – Once More Unto The Breach, Hero /Death Knight’s Special/
UPDATE quest_template SET PrevQuestId=13086, RequiredClasses=1502,NextQuestId=0, ExclusiveGroup=0, NextQuestIdChain=0 WHERE id=13105; – Once More Unto The Breach, Hero
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestIdChain=0 WHERE id=13122; – The Scourgestone
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestIdChain=0 WHERE id=13118; – The Purging of Scourgeholme
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestIdChain=0 WHERE id=13110; – The Restless Dead
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestIdChain=0 WHERE id=13125; – The Air Stands Still
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestIdChain=0 WHERE id=13130; – The Stone That Started a Revolution
UPDATE quest_template SET PrevQuestId=13104, NextQuestId=13139, ExclusiveGroup=-13122, NextQuestIdChain=0 WHERE id=13135; – It Could Kill Us All
UPDATE quest_template SET PrevQuestId=0, NextQuestId=13141, ExclusiveGroup=0, NextQuestIdChain=13141 WHERE id=13139; – Into The Cold Heart Of Northrend
UPDATE quest_template SET PrevQuestId=13139, NextQuestId=13157, ExclusiveGroup=0, NextQuestIdChain=13157 WHERE id=13141; – The Battle For Crusaders Pinnacle UPDATE quest_templateSETPrevQuestId=13141, NextQuestId=0, ExclusiveGroup=0, NextQuestIdChain=0 WHERE id`=13135; – The Crusader’s Pinnacle

SAI from both posts:

– 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’);

– SAIs for some world creatures
– Forgotten Depths Underking ID:31039
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 31039;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=31039;
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
(31039,0,1,0,0,0,100,0,1000,2000,2000,7000,11,60802,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Underking - IC - Cast spell Mandible Crush’),
(31039,0,2,0,0,0,100,0,1500,2000,7000,12000,11,50283,0,0,0,0,0,0,0,2,0,0,0,0,0,‘Forgotten Depths Underking IC - Cast spell Blinding Swarm’);
– Forgotten Depths Underking ID: 30544
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30544;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30544;
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
(30544,0,1,0,0,0,100,0,1000,2000,2000,7000,11,60802,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Underking - IC - Cast spell Mandible Crush’),
(30544,0,2,0,0,0,100,0,1500,2000,7000,12000,11,50283,0,0,0,0,0,0,0,2,0,0,0,0,0,‘Forgotten Depths Underking - IC - Cast spell Blinding Swarm’);
– Forgotten Depths Underking ID: 30541
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30541;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30541;
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
(30541,0,1,0,0,0,100,0,1000,2000,2000,7000,11,60802,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Underking - IC - Cast spell Mandible Crush’),
(30541,0,2,0,0,0,100,0,1500,2000,7000,12000,11,50283,0,0,0,0,0,0,0,2,0,0,0,0,0,‘orgotten Depths Underking - IC - Cast spell Blinding Swarm’);
– Carrion Fleshstripper ID: 35201
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 35201;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=35201;
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
(35201,0,1,0,0,0,100,0,1000,2000,15000,17000,11,35201,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Carrion Fleshstripper IC - Cast spell Paralytic Poison’);
– Wrathstrike Gargoyle ID: 30482
UPDATE creature_template SET mechanic_immune_mask = 67108864, AIName= ‘SmartAI’ WHERE entry= 30482;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30482;
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
(30482,0,1,0,0,0,100,0,1000,2000,2500,7000,11,16564,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Wrathstrike Gargoyle IC - Cast spell Paralytic Poison’);
– Wrathstrike Gargoyle ID: 31040
UPDATE creature_template SET mechanic_immune_mask = 67108864,AIName= ‘SmartAI’ WHERE entry= 31040;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=31040;
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
(31040,0,1,0,0,0,100,0,1000,2000,2500,7000,11,16564,1,0,0,0,0,2,0,0,0,0,0,0,0,‘Wrathstrike Gargoyle - IC - Cast spell Paralytic Poison’);
– Reanimated Crusader ID: 30202
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30202;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30202;
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
(30202,0,0,0,0,0,100,0,1000,5000,6500,12000,11,32674,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Reanimated Crusader - IC - Cast Avenger"s Shield’),
(30202,0,1,0,0,0,100,0,5000,10000,8500,20000,11,58154,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Reanimated Crusader - IC - Hammer of Injustice’),
(30202,0,2,0,2,0,100,0,10,90,7000,15000,11,58153,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Reanimated Crusader - On health percentage - Cast Unholy Light on self after Hammer of Injustice’),
(30202,0,3,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Reanimated Crusader - On friendly HP deficit - Cast Unholy Light on allies’);
– Forgotten Depths Slayer ID: 30333
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30333;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30333;
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
(30333,0,0,0,4,0,100,0,2000,20000,0,0,11,56223,0,0,0,0,0,19,30673,20,0,0,0,0,0,‘Forgotten Depths Slayer - On aggro - Cast Web Rope’), – On fight with Crusader webs them /dwarf/
(30333,0,1,0,0,0,100,0,1000,5000,2500,6500,11,54185,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Slayer - IC - Cast spell Claw Slash’);
– Forgotten Depths Slayer ID: 30593
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30593;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30593;
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
(30593,0,0,0,4,0,100,0,2000,20000,0,0,11,56223,0,0,0,0,0,19,30672,20,0,0,0,0,0,‘Forgotten Depths Slayer - On aggro - Cast Web Rope’), – On fight with Crusader webs them /belf/
(30593,0,1,0,0,0,100,0,1000,5000,2500,6500,11,54185,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Slayer - IC - Cast spell Claw Slash’);
– Forgotten Depths Slayer ID: 30673
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30673;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30673;
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
(30673,0,0,0,4,0,100,0,2000,20000,0,0,11,56223,0,0,0,0,0,19,30673,20,0,0,0,0,0,‘Forgotten Depths Slayer - On aggro - Cast Web Rope’), – On fight with Crusader webs them /dwarf/
(30673,0,1,0,0,0,100,0,1000,5000,2500,6500,11,54185,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Slayer - IC - Cast spell Claw Slash’);
– Forgotten Depths Acolyte ID: 30205
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30205;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30205;
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
(30205,0,0,0,4,0,100,0,2000,20000,0,0,11,56223,0,0,0,0,0,19,30672,20,0,0,0,0,0,‘Forgotten Depths Acolyte - On aggro - Spell cast Web Rope’), – On fight with Crusader webs them /belf/
(30205,0,1,0,0,0,100,0,1000,5000,30000,30000,11,60781,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Acolyte - IC - Cast spell Curse of Mending’),
(30205,0,2,0,0,0,100,0,1000,5000,2500,6500,11,16583,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Acolyte - IC - Cast spell Shadow Shock’);
– Forgotten Depths Ambusher ID: 30204
DELETE FROM creature_template_addon WHERE entry=30204;
INSERT INTO creature_template_addon (entry,bytes1) VALUES – Debugs the go out of snow animation
(30204,9);
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30204;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30204;
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
(30204,0,0,1,4,0,100,1,0,0,0,0,11,56418,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Ambusher - On aggro - Cast spell emerge From Snow /only visual + sent fly in air effect’), – If it is summoned by a cacoon it will knock back the player, if not most likely not
(30204,0,1,2,61,0,100,1,56418,0,0,0,91,9,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Forgotten Depths Ambusher - Linkedw ith event 0 - Remove field byte from creature addon that make it emerge on surface’),
(30204,0,2,0,61,0,100,1,56418,0,0,0,19,33554432,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Forgotten Depths Ambusher - Linked with event 1 - Remove field flag to make selectable’),
(30204,0,3,0,0,0,100,0,1000,5000,2500,6500,11,40505,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Forgotten Depths Ambusher - IC - Cast spell cleave’);
– Add SAI for Crusader of Virtue (Blood elf) /the 100+k one/
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 31033;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=31033;
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
(31033,0,0,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Crusader of Virtue (Blood elf) - On friendly HP deficit - Heal damaged friendly unit’);
– Add SAI for Crusader of Virtue (Dwarf)
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30672;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30672;
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
(30672,0,0,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Crusader of Virtue (Dwarf) - On friendly HP deficit - Heal damaged friendly unit’),
(30672,0,1,2,8,0,100,1,56223,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Dwarf) - On hit by spell web robe - Set unseen’),
(30672,0,2,3,61,0,100,1,56223,0,0,0,12,30407,7,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Dwarf) - Linked with event 1 - Summon Webbed crusader’),
(30672,0,3,0,61,0,100,0,56223,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Dwarf) - Linked with event 2 - Despawn’);
– Add SAI for Crusader of Virtue (Blood elf)
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30189;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30189;
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
(30189,0,0,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Crusader of Virtue (Blood elf) - On friendly HP deficit - Heal damaged friendly unit’),
(30189,0,1,2,8,0,100,1,56223,0,0,0,47,0,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Blood elf) - On hit by spell web robe - Set unseen’),
(30189,0,2,3,61,0,100,1,56223,0,0,0,12,30407,7,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Blood elf) - Linked with event 1 - Summon Webbed crusader’),
(30189,0,3,0,61,0,100,0,56223,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Crusader of Virtue (Blood elf) - Linked with event 2 - Despawn’);
– Add SAI for Frostbrood Destroyer - 30575
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry= 30575;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=30575;
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
(30575,0,1,0,0,0,100,0,1000,4000,10000,15000,11,53363,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Frostbrood Destroyer - IC - Spell cast Wing Buffet’),
(30575,0,2,0,0,0,100,0,2000,6500,10000,12000,11,57477,7,0,0,0,0,1,0,0,0,0,0,0,0,‘Frostbrood Destroyer - IC - Spell cast Freezing breath’);
– Fix Freed Crusader ID: 30274 mechanic - this is a small fix to an old Svanon script, couldn’t find the final version or there were some bugs, so remaked some stuff to face right direction and giving random buffs /the new addition/.
– Add SAI for Freed Crusader
SET @Freed_Crusader := 30274;
SET @Script0 := 320274000;
SET @Script1 := 320274001;
SET @Script2 := 320274002;
SET @Script3 := 320274003;
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry=30274;
DELETE FROM smart_scripts WHERE entryorguid IN (30274, @Script0, @Script1,@Script2,@Script3);
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
(@Freed_Crusader,0,0,1,54,0,100,0,0,0,0,0,87,@Script0,@Script1,@Script2,@Script0,@Script1,@Script2,1,0,0,0,0,0,0,0, ‘Freed Crusader - On creature summoned - Start random action list’),
– Action list 00
(@Script0,9,0,0,0,0,100,0,0,0,0,0,11,56525,0,0,0,0,0,21,20,0,0,0,0,0,0,‘Action 0 - BoFK’),
– Action list 01
(@Script1,9,0,0,0,0,100,0,0,0,0,0,11,56521,0,0,0,0,0,21,20,0,0,0,0,0,0,‘Action 0 - BoW’),
– Action list 02
(@Script2,9,0,0,0,0,100,0,0,0,0,0,11,56520,0,0,0,0,0,21,20,0,0,0,0,0,0,‘Action 0 - BoM’),
– Continue normal events
(@Freed_Crusader,0,1,0,61,0,100,0,0,0,0,0,1,0,1000,0,0,0,0,1,0,0,0,0,0,0,0, ‘Freed Crusader - Linked with event 0 - Say text 0’),
(@Freed_Crusader,0,2,0,52,0,100,0,0,30274,0,0,80,@Script3,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Freed Crusader - On text end - Start action list script 3’),
– Action list 03
(@Script3,9,0,0,0,0,100,0,0,0,0,0,11,58053,0,0,0,0,0,21,20,0,0,0,0,0,0, ‘Action 0 - Cast Holy Light on ally’),
(@Script3,9,1,0,0,0,100,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,6283.2700020,78.926147,391.827209,4, ‘Action 1 - Set orientation South /with target position/’), – Fixed now
(@Script3,9,2,0,0,0,100,0,2000,2000,0,0,46,20,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Action 2 - Run 20 yards’),
(@Script3,9,3,0,0,0,100,0,0,0,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Action 3 - Despawn after 3000 ms’);
– Fixed the text, had some errors
DELETE FROM creature_text WHERE entry=@Freed_Crusader;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(@Freed_Crusader,0,0,‘Thank you and farewell, friend. I must return to the Argent Vanguard.’,12,0,100,0,0,0,‘Freed Crusader gratitude’);

– Fix [Q]{A/H} The Restless Dead - ID: 13110
– Reanimated Crusader SAI
SET @Reanimated_Crusader := 31043;
SET @Credit := 30546;
SET @HolyWater := 57806;
– Replace required npcorgameobject, because there was wrong unusused creature /not credit, since the spell that must hit the requirednpc has 31043 as set and not 30546, also the npc name has “unused” stated/.
UPDATE quest_template SET RequiredNpcOrGo1=@Reanimated_Crusader WHERE Id=13110;
– Аdd SAI for Reanimated Crusader
UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entry=@Reanimated_Crusader;
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid=@Reanimated_Crusader;
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
(@Reanimated_Crusader,0,0,0,25,0,100,0,0,0,0,0,19,33554432,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Reanimated Crusader - On spawn/respawn - Remove flag unselectable’),
(@Reanimated_Crusader,0,1,0,8,0,100,0,@HolyWater,0,0,0,18,33554432,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Reanimated Crusader - On hit by spell Holy Water - Set field flag unselectable /to prevent more uses of the spell - acts as condition/’),
(@Reanimated_Crusader,0,2,0,0,0,100,0,1000,5000,6500,12000,11,32674,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Reanimated Crusader - IC - Cast Avenger"s Shield’),
(@Reanimated_Crusader,0,3,0,0,0,100,0,5000,10000,8500,20000,11,58154,0,0,0,0,0,2,0,0,0,0,0,0,0,‘Reanimated Crusader - IC - Hammer of Injustice’),
(@Reanimated_Crusader,0,4,0,2,0,100,0,10,90,7000,15000,11,58153,0,0,0,0,0,1,0,0,0,0,0,0,0,‘Reanimated Crusader - On health percentage - Cast Unholy Light on self after Hammer of Injustice’),
(@Reanimated_Crusader,0,5,0,14,0,100,0,1000,20,8000,20000,11,58153,0,0,0,0,0,7,0,0,0,0,0,0,0,‘Reanimated Crusader - On friendly HP deficit - Cast Unholy Light on allies’);