DB/Misc: Respawn Temple of Atal'Hakkar

By Malcrom

1 files changed, 191 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_03_12_00_world.sql b/sql/updates/world/master/2017_03_12_00_world.sql
new file mode 100644
index 00000000000..f31a1adaff8
--- /dev/null
+++ b/sql/updates/world/master/2017_03_12_00_world.sql
@@ -0,0 +1,191 @@
+-- Remove all creature and gameobject spawns from map 109
+DELETE FROM `creature` WHERE `map`=109;
+DELETE FROM `creature_addon` WHERE `guid` NOT IN (SELECT `guid` FROM `creature`);
+DELETE FROM `gameobject` WHERE `map`=109;
+DELETE FROM `gameobject_addon` WHERE `guid` NOT IN (SELECT `guid` FROM `gameobject`);
+
+-- Remove old waypoint and formation
+DELETE FROM `waypoint_data` WHERE `id`=336580;
+DELETE FROM `creature_formations` WHERE `leaderGUID`=33658;
+
+-- Respawn creatures
+SET @CGUID := 251251;
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+104;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0,2914,109,0,0,1,169,0,0,0,-391.7645,92.71431,-90.86712,2.963046,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+1,2914,109,0,0,1,169,0,0,0,-297.3856,83.04854,-91.09061,5.10778,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+2,2914,109,0,0,1,169,0,0,0,-373.0406,75.03958,-131.447,6.026293,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+3,2914,109,0,0,1,169,0,0,0,-350.5063,130.2023,-148.9032,4.741959,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+4,2914,109,0,0,1,169,0,0,0,-362.848,19.92291,-69.3923,2.376379,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+5,2914,109,0,0,1,169,0,0,0,-385.5145,96.50134,-90.8524,0.9270402,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+6,2914,109,0,0,1,169,0,0,0,-335.1277,117.8011,-131.8474,4.69864,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+7,2914,109,0,0,1,169,0,0,0,-343.1481,147.2007,-69.48788,3.194419,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+8,2914,109,0,0,1,169,0,0,0,-370.7447,114.9868,-53.94633,3.545005,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+9,2914,109,0,0,1,169,0,0,0,-384.5314,144.2719,-131.0453,1.560693,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+10,2914,109,0,0,1,169,0,0,0,-330.103,91.94751,-131.8486,1.032488,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+11,2914,109,0,0,1,169,0,0,0,-453.8755,62.06911,-91.34988,0.01065614,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+12,2914,109,0,0,1,169,0,0,0,-380.4706,234.1404,-90.86153,5.561656,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+13,2914,109,0,0,1,169,0,0,0,-530.8884,173.2607,-54.09545,4.296912,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+14,2914,109,0,0,1,169,0,0,0,-471.3307,132.4887,-91.2021,5.689507,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+15,2914,109,0,0,1,169,0,0,0,-520.3876,101.4895,-91.3147,3.617042,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+16,2914,109,0,0,1,169,0,0,0,-410.2076,17.6556,-53.94635,1.266128,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+17,2914,109,0,0,1,169,0,0,0,-418.8355,10.57873,-90.85738,3.625298,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+18,2914,109,0,0,1,169,0,0,0,-561.3115,85.38955,-53.94634,1.311812,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+19,2914,109,0,0,1,169,0,0,0,-550.7628,238.5096,-90.85101,4.550307,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+20,2914,109,0,0,1,169,0,0,0,-553.0972,171.8572,-148.8329,5.010252,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+21,2914,109,0,0,1,169,0,0,0,-575.9153,173.6673,-69.40138,1.920732,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+22,2914,109,0,0,1,169,0,0,0,-599.1094,37.05124,-69.35283,3.874078,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+23,2914,109,0,0,1,169,0,0,0,-550.9071,-45.36851,-90.85987,1.508554,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+24,2914,109,0,0,1,169,0,0,0,-473.8655,-90.09864,-90.82753,0.8830038,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+25,2914,109,0,0,1,169,0,0,0,-586.1681,96.41691,-90.8886,2.928523,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+26,2914,109,0,0,1,169,0,0,0,-659.7747,98.07658,-90.83157,2.423705,7200,10,0,0,0,1,0,0,0,23420), -- Snake
+(@CGUID+27,4075,109,0,0,1,169,0,0,0,-400.682,114.956,-90.88896,5.410521,7200,5,0,0,0,1,0,0,0,23420), -- Rat
+(@CGUID+28,5270,109,0,0,1,169,0,0,0,-447.8171,-94.08572,-90.74416,0.4712389,7200,0,0,0,0,0,0,0,0,23420), -- Atal'ai Corpse Eater
+(@CGUID+29,5270,109,0,0,1,169,0,0,0,-467.206,-78.2681,-90.74416,6.126106,7200,0,0,0,0,0,0,0,0,23420), -- Atal'ai Corpse Eater
+(@CGUID+30,5270,109,0,0,1,169,0,0,0,-482.5509,-95.60172,-90.74413,0.1570796,7200,0,0,0,0,0,0,0,0,23420), -- Atal'ai Corpse Eater
+(@CGUID+31,5271,109,0,0,1,169,0,0,0,-464.562,-72.68608,-90.82753,2.204456,7200,5,0,0,0,1,0,0,0,23420), -- Atal'ai Deathwalker
+(@CGUID+32,5271,109,0,0,1,169,0,0,0,-446.4457,-58.11845,-90.82753,1.58986,7200,5,0,0,0,1,0,0,0,23420), -- Atal'ai Deathwalker
+(@CGUID+33,5271,109,0,0,1,169,0,0,0,-444.6522,-62.20423,-90.82753,1.023607,7200,5,0,0,0,1,0,0,0,23420), -- Atal'ai Deathwalker
+(@CGUID+34,5271,109,0,0,1,169,0,0,0,-439.6707,-63.28101,-90.82754,1.623751,7200,5,0,0,0,1,0,0,0,23420), -- Atal'ai Deathwalker
+(@CGUID+35,5271,109,0,0,1,169,0,0,0,-465.2634,-113.7335,-90.82754,5.017375,7200,5,0,0,0,1,0,0,0,23420), -- Atal'ai Deathwalker
+(@CGUID+36,5271,109,0,0,1,169,0,0,0,-483.5921,-91.84483,-90.82753,2.841005,7200,5,0,0,0,1,0,0,0,23420), -- Atal'ai Deathwalker
+(@CGUID+37,5271,109,0,0,1,169,0,0,0,-445.1136,-96.93134,-90.82754,0.8437377,7200,5,0,0,0,1,0,0,0,23420), -- Atal'ai Deathwalker
+(@CGUID+38,5271,109,0,0,1,169,0,0,0,-456.6964,-115.6961,-90.82754,2.00841,7200,5,0,0,0,1,0,0,0,23420), -- Atal'ai Deathwalker
+(@CGUID+39,5271,109,0,0,1,169,0,0,0,-461.7546,-116.2956,-90.82754,3.120245,7200,5,0,0,0,1,0,0,0,23420), -- Atal'ai Deathwalker
+(@CGUID+40,5273,109,0,0,1,169,0,0,0,-447.6101,-90.90454,-90.74416,0.3141593,7200,0,0,0,0,0,0,0,0,23420), -- Atal'ai High Priest
+(@CGUID+41,5273,109,0,0,1,169,0,0,0,-466.795,-75.1546,-90.74416,6.038839,7200,0,0,0,0,0,0,0,0,23420), -- Atal'ai High Priest
+(@CGUID+42,5273,109,0,0,1,169,0,0,0,-482.4889,-98.03719,-90.74413,0.2268928,7200,0,0,0,0,0,0,0,0,23420), -- Atal'ai High Priest
+(@CGUID+43,5277,109,0,0,1,169,0,0,0,-426.139,149.15,-90.86597,0,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Scalebane
+(@CGUID+44,5277,109,0,0,1,169,0,0,0,-431.377,151.999,-90.87086,0,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Scalebane
+(@CGUID+45,5277,109,0,0,1,169,0,0,0,-531.7289,-2.317528,-90.87706,1.848868,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Scalebane
+(@CGUID+46,5277,109,0,0,1,169,0,0,0,-492.801,158.289,-90.87627,2.094395,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Scalebane
+(@CGUID+47,5277,109,0,0,1,169,0,0,0,-498.174,154.402,-90.89397,2.042035,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Scalebane
+(@CGUID+48,5277,109,0,0,1,169,0,0,0,-472.358,123.8472,-92.62939,0.7541064,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Scalebane
+(@CGUID+49,5277,109,0,0,1,169,0,0,0,-534.657,85.7447,-90.85626,0.08726646,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Scalebane
+(@CGUID+50,5277,109,0,0,1,169,0,0,0,-608.471,88.55717,-90.88,0.5234659,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Scalebane
+(@CGUID+51,5277,109,0,0,1,169,0,0,0,-536.5082,-23.17718,-90.87449,1.932496,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Scalebane
+(@CGUID+52,5280,109,0,0,1,169,0,0,0,-400.144,89.33968,-90.96929,2.217634,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Wyrmkin
+(@CGUID+53,5280,109,0,0,1,169,0,0,0,-401.9817,99.9511,-91.01981,1.148299,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Wyrmkin
+(@CGUID+54,5280,109,0,0,1,169,0,0,0,-441.192,158.193,-90.86047,1.029744,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Wyrmkin
+(@CGUID+55,5280,109,0,0,1,169,0,0,0,-509.098,148.96,-90.87476,1.972222,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Wyrmkin
+(@CGUID+56,5280,109,0,0,1,169,0,0,0,-535.051,104.645,-90.84557,6.230825,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Wyrmkin
+(@CGUID+57,5280,109,0,0,1,169,0,0,0,-577.2277,88.03854,-90.89156,5.811761,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Wyrmkin
+(@CGUID+58,5283,109,0,0,1,169,0,0,0,-436.663,155.508,-90.86127,0,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Wanderer
+(@CGUID+59,5283,109,0,0,1,169,0,0,0,-425.7377,20.74667,-90.86224,4.838341,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Wanderer
+(@CGUID+60,5283,109,0,0,1,169,0,0,0,-426.2425,31.72558,-90.86756,0.7503557,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Wanderer
+(@CGUID+61,5283,109,0,0,1,169,0,0,0,-477.4931,38.0046,-91.1981,3.647987,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Wanderer
+(@CGUID+62,5283,109,0,0,1,169,0,0,0,-534.236,98.6094,-90.86726,0,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Wanderer
+(@CGUID+63,5283,109,0,0,1,169,0,0,0,-486.3944,131.7047,-90.8932,2.237499,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Wanderer
+(@CGUID+64,5283,109,0,0,1,169,0,0,0,-503.997,151.997,-90.87257,2.007129,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Wanderer
+(@CGUID+65,5283,109,0,0,1,169,0,0,0,-485.0161,64.96117,-91.35719,0.006376389,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Wanderer
+(@CGUID+66,5283,109,0,0,1,169,0,0,0,-533.941,91.717,-90.87527,0.03490658,7200,0,0,0,0,0,0,0,0,23420), -- Nightmare Wanderer
+(@CGUID+67,5291,109,0,0,1,169,0,0,0,-541.5712,220.0541,-90.87822,0.824063,7200,10,0,0,0,1,0,0,0,23420), -- Hakkari Frostwing
+(@CGUID+68,5709,109,0,0,1,169,0,0,0,-659.994,-34.0331,-90.75176,1.570796,100000,0,0,0,0,0,0,0,0,23420), -- Shade of Eranikus Auras: 12535
+(@CGUID+69,5710,109,0,0,1,169,0,0,0,-426.677,-85.7376,-88.14076,3.211406,100000,0,0,0,0,0,0,0,0,23420), -- Jammal'an the Prophet Auras: 13540
+(@CGUID+70,5711,109,0,0,1,169,0,0,0,-422.358,-90.3028,-88.14076,2.670354,100000,0,0,0,0,0,0,0,0,23420), -- Ogom the Wretched
+(@CGUID+71,5719,109,0,0,1,169,0,0,0,-644.0954,103.4418,-90.83388,1.538336,100000,0,0,0,0,0,0,0,0,23420), -- Morphaz
+(@CGUID+72,5722,109,0,0,1,169,0,0,0,-646.8446,123.2024,-90.83407,1.896411,100000,0,0,0,0,2,0,0,0,23420), -- Hazzas
+(@CGUID+73,8319,109,0,0,1,169,0,0,0,-412.121,89.07365,-91.25427,5.683999,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+74,8319,109,0,0,1,169,0,0,0,-415.6204,17.37282,-90.85455,5.497725,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+75,8319,109,0,0,1,169,0,0,0,-417.0536,97.89166,-91.37733,1.575108,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+76,8319,109,0,0,1,169,0,0,0,-409.2819,94.67287,-91.19025,2.275331,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+77,8319,109,0,0,1,169,0,0,0,-409.2788,103.2943,-91.19566,0.2032617,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+78,8319,109,0,0,1,169,0,0,0,-482.5124,54.14182,-90.73199,3.989406,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+79,8319,109,0,0,1,169,0,0,0,-517.7172,-9.163269,-90.88219,6.203471,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+80,8319,109,0,0,1,169,0,0,0,-494.7203,115.1694,-91.45649,2.123726,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+81,8319,109,0,0,1,169,0,0,0,-431.4855,18.93935,-90.86681,2.461974,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+82,8319,109,0,0,1,169,0,0,0,-472.3421,57.3814,-91.15324,6.006916,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+83,8319,109,0,0,1,169,0,0,0,-528.6029,-14.66052,-90.8753,0.710825,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+84,8319,109,0,0,1,169,0,0,0,-471.7129,111.2018,-94.21333,1.931837,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+85,8319,109,0,0,1,169,0,0,0,-468.8151,42.51549,-91.3223,6.098307,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+86,8319,109,0,0,1,169,0,0,0,-437.4339,29.28942,-90.8299,4.519087,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+87,8319,109,0,0,1,169,0,0,0,-483.501,114.9935,-93.00551,1.365626,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+88,8319,109,0,0,1,169,0,0,0,-492.5755,55.41818,-91.47742,0.7905921,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+89,8319,109,0,0,1,169,0,0,0,-423.7304,5.791389,-90.86142,3.021764,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+90,8319,109,0,0,1,169,0,0,0,-481.961,107.5453,-93.7262,0.329198,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+91,8319,109,0,0,1,169,0,0,0,-587.5513,93.37126,-90.8896,0.7776415,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+92,8319,109,0,0,1,169,0,0,0,-577.8292,101.8179,-90.89187,3.430871,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+93,8319,109,0,0,1,169,0,0,0,-528.2789,-24.42307,-90.87498,5.528183,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+94,8319,109,0,0,1,169,0,0,0,-539.3814,-15.17866,-90.87458,3.776974,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+95,8319,109,0,0,1,169,0,0,0,-597.5604,98.73322,-90.8828,0.9480065,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+96,8319,109,0,0,1,169,0,0,0,-605.0175,104.3474,-90.88022,2.455177,7200,10,0,0,0,1,0,0,0,23420), -- Nightmare Whelp
+(@CGUID+97,8336,109,0,0,1,169,0,0,0,-450.4607,279.401,-90.68311,5.138166,7200,10,0,0,0,1,0,0,0,23420), -- Hakkari Sapper
+(@CGUID+98,8336,109,0,0,1,169,0,0,0,-398.2993,218.2589,-90.8858,2.77635,7200,10,0,0,0,1,0,0,0,23420), -- Hakkari Sapper
+(@CGUID+99,8336,109,0,0,1,169,0,0,0,-382.1383,268.5124,-90.83797,4.101222,7200,10,0,0,0,1,0,0,0,23420), -- Hakkari Sapper
+(@CGUID+100,8336,109,0,0,1,169,0,0,0,-552.1206,271.8993,-90.84313,5.187577,7200,10,0,0,0,1,0,0,0,23420), -- Hakkari Sapper
+(@CGUID+101,8336,109,0,0,1,169,0,0,0,-485.9989,269.6494,-90.70238,1.800563,7200,10,0,0,0,1,0,0,0,23420), -- Hakkari Sapper
+(@CGUID+102,46077,109,0,0,1,169,0,0,0,-335.004,95.3998,-90.84537,6.230825,7200,0,0,0,0,0,0,0,0,23420), -- Lord Itharius
+(@CGUID+103,53488,109,0,0,1,169,0,0,0,-337.3487,95.75773,-90.84531,0,7200,0,0,0,0,0,0,0,0,23420), -- Summon Enabler Stalker
+(@CGUID+104,53488,109,0,0,1,169,0,0,0,-359.1744,96.10281,-90.78771,0,7200,0,0,0,0,0,0,0,0,23420); -- Summon Enabler Stalker
+
+-- Auras (Atal'ai Deathwalker, Nightmare Scalebane)
+DELETE FROM `creature_template_addon` WHERE `entry` IN (5271,5277,5709);
+INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
+(5271,0,0,0,1,0, '8278'),(5277,0,0,0,1,0, '12099'),(5709,0,0,0,1,0, '12535');
+
+-- Shade of Eranikus SAI
+SET @ENTRY := 5709;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
+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,1,0,100,3,1000,1000,1000,1000,90,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shade of Eranikus - OOC - Set Bytes_1 (No Repeat) (Normal Dungeon)"),
+(@ENTRY,0,1,2,4,0,100,2,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shade of Eranikus - On Aggro - Say Line 0 (Normal Dungeon)"),
+(@ENTRY,0,2,3,61,0,100,0,0,0,0,0,91,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shade of Eranikus - On Aggro - Remove Bytes_1 (Normal Dungeon)"),
+(@ENTRY,0,3,0,61,0,100,0,0,0,0,0,38,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shade of Eranikus - On Aggro - Set In Combat With Zone (Normal Dungeon)"),
+(@ENTRY,0,4,0,0,0,100,2,7200,13300,16900,32100,11,12891,0,0,0,0,0,2,0,0,0,0,0,0,0,"Shade of Eranikus - In Combat - Cast 'Acid Breath' (Normal Dungeon)"),
+(@ENTRY,0,5,0,9,0,100,2,0,5,7300,19200,11,12787,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shade of Eranikus - Within 0-5 Range - Cast 'Thrash' (Normal Dungeon)"),
+(@ENTRY,0,6,0,0,0,100,2,14300,14300,28800,39200,11,12890,1,0,0,0,0,2,0,0,0,0,0,0,0,"Shade of Eranikus - In Combat - Cast 'Deep Slumber' (Normal Dungeon)"),
+(@ENTRY,0,7,0,0,0,100,2,17000,20000,18000,22000,11,11876,0,0,0,0,0,1,0,0,0,0,0,0,0,"Shade of Eranikus - In Combat - Cast 'War Stomp' (Normal Dungeon)");
+
+-- Jammal'an the Prophet SAI
+SET @ENTRY := 5710;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
+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,1,10,0,100,2,0,85,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Jammal'an the Prophet - Within 0-85 Range Out of Combat LoS - Say Line 0"),
+(@ENTRY,0,1,0,61,0,100,2,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Jammal'an the Prophet - Within 0-85 Range Out of Combat LoS - Set Event Phase 1"),
+(@ENTRY,0,2,0,0,1,100,2,0,0,31400,76200,1,1,0,0,0,0,0,2,0,0,0,0,0,0,0,"Jammal'an the Prophet - In Combat - Say Line 1"),
+(@ENTRY,0,3,0,0,1,100,2,8100,35600,20100,52900,11,12468,0,0,0,0,0,2,0,0,0,0,0,0,0,"Jammal'an the Prophet - In Combat - Cast 'Flamestrike'"),
+(@ENTRY,0,4,0,0,1,100,2,6200,16500,26100,36600,11,8376,0,0,0,0,0,1,0,0,0,0,0,0,0,"Jammal'an the Prophet - In Combat - Cast 'Earthgrab Totem'"),
+(@ENTRY,0,5,6,0,1,100,2,16300,19900,31400,53500,11,12479,0,0,0,0,0,2,0,0,0,0,0,0,0,"Jammal'an the Prophet - In combat - Cast 'Hex of Jammal'an' (Phase 1)"),
+(@ENTRY,0,6,0,61,1,100,2,0,0,0,0,1,2,0,0,0,0,0,2,0,0,0,0,0,0,0,"Jammal'an the Prophet - Out of Combat - Say Line 2 (Phase 1)"),
+(@ENTRY,0,7,8,2,1,100,3,0,30,0,0,11,12492,0,0,0,0,0,1,0,0,0,0,0,0,0,"Jammal'an the Prophet - Between 0-30% Health - Cast 'Healing Wave' (Phase 1) (No Repeat)"),
+(@ENTRY,0,8,0,61,1,100,2,0,0,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Jammal'an the Prophet - Between 0-30% Health - Say Line 3 (Phase 1) (No Repeat)"),
+(@ENTRY,0,9,0,5,1,100,2,0,0,0,0,4,5863,0,0,0,0,0,1,0,0,0,0,0,0,0,"Jammal'an the Prophet - On Killed Unit - Play Sound 5863 (Phase 1) (No Repeat)"),
+(@ENTRY,0,10,11,6,1,100,2,0,0,0,0,12,5721,1,300000,0,0,0,8,0,0,0,-472,106,-95,0,"Jammal'an the Prophet - On Just Died - Summon Creature 'Dreamscythe' (Phase 1)"),
+(@ENTRY,0,11,0,61,1,100,2,0,0,0,0,12,5720,1,300000,0,0,0,8,0,0,0,-467,85,-95,4,"Jammal'an the Prophet - On Just Died - Summon Creature 'Weaver' (Phase 1)");
+
+-- Pathing for Hazzas Entry: 5722
+SET @NPC := @CGUID+72;
+SET @PATH := @NPC * 10;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,-673.3382,107.9363,-90.83135,0,0,1,0,100,0),
+(@PATH,2,-673.3691,83.96611,-90.83269,0,0,1,0,100,0),
+(@PATH,3,-665.6964,60.20914,-90.83466,0,0,1,0,100,0),
+(@PATH,4,-649.8461,60.03304,-90.83689,0,0,1,0,100,0),
+(@PATH,5,-641.7433,84.01611,-90.83711,0,0,1,0,100,0),
+(@PATH,6,-641.6724,107.8836,-90.84185,0,0,1,0,100,0),
+(@PATH,7,-649.6785,131.596,-90.82949,0,0,1,0,100,0),
+(@PATH,8,-665.834,131.5032,-90.82989,0,0,1,0,100,0);
+
+-- Set Formation/Group Combat Assistance Hazzas / Morphaz
+DELETE FROM `creature_formations` WHERE `leaderGUID`=@CGUID+72;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`) VALUES
+(@CGUID+72,@CGUID+72,0,0,2),
+(@CGUID+72,@CGUID+71,10,360,2);
+
+-- Respawn gameobjects
+SET @OGUID := 203021;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+7;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 148418, 109, 0, 0, 1, 169, 0, -435.975, 249.375, -90.8275, 1.221729, 0, 0, 0.573576, 0.8191524, 7200, 255, 0, 23420), -- Eternal Flame
+(@OGUID+1, 148419, 109, 0, 0, 1, 169, 0, -498.729, 250.433, -90.8275, 3.176533, 0, 0, -0.9998474, 0.01746928, 7200, 255, 0, 23420), -- Eternal Flame
+(@OGUID+2, 148420, 109, 0, 0, 1, 169, 0, -498.091, 302.458, -90.8275, 3.071766, 0, 0, 0.9993906, 0.03490613, 7200, 255, 0, 23420), -- Eternal Flame
+(@OGUID+3, 148421, 109, 0, 0, 1, 169, 0, -435.404, 302.006, -90.8275, 2.792518, 0, 0, 0.984807, 0.1736523, 7200, 255, 0, 23420), -- Eternal Flame
+(@OGUID+4, 149431, 109, 0, 0, 1, 169, 0, -518.1542, -85.23531, -74.48801, 3.141593, 0, 0, -1, 0, 7200, 255, 0, 23420), -- forcefield
+(@OGUID+5, 149432, 109, 0, 0, 1, 169, 0, -518.3807, 276.6208, -90.89765, 3.141593, 0, 0, -1, 0, 7200, 255, 0, 23420), -- DOOR1
+(@OGUID+6, 149433, 109, 0, 0, 1, 169, 0, -415.7127, 276.6208, -90.89765, 3.141593, 0, 0, -1, 0, 7200, 255, 0, 23420), -- DOOR2
+(@OGUID+7, 208321, 109, 0, 0, 1, 169, 0, -467.1617, 256.4199, -90.59743, 3.33359, 0, 0, -0.9953957, 0.09585124, 7200, 255, 1, 23420); -- Shrine of the Soulflayer