DB/Misc: Auchenai Crypts

Cherry pick From https://github.com/cmangos/wotlk-db/commit/a671b0ed6821bf1a1d8dd94105656db725daa709
By Grz3s

1 files changed, 416 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_05_11_00_world.sql b/sql/updates/world/3.3.5/2019_05_11_00_world.sql
new file mode 100644
index 00000000000..c436c2b9f0e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_05_11_00_world.sql
@@ -0,0 +1,416 @@
+-- Auchenai Crypts
+DELETE FROM `creature` WHERE `guid` = 104176;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`, `curmana`, `spawndist`, `MovementType`) VALUES
+(104176, 18778, 558, 3, 1, 141.688, -17.801, 9.30814, 2.129302, 7200, 3785, 2790, 0, 0);
+UPDATE `creature_template` SET `unit_flags` = 0, `flags_extra` = `flags_extra`|128 WHERE `entry` IN (18778,20304);
+DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (18778,20304);
+INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`) VALUES
+(18778, 0, 0, 1, 0), (20304, 0, 0, 1, 0);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` IN (32930);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(13, 1, 32930, 0, 31, 3, 18778, 0, 0, '', "");
+
+DELETE FROM `smart_scripts`   WHERE `entryorguid` IN (-83375,-83377) 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
+(-83375, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 11, 32930, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Auchenai Soulpriest - On reset - Cast Blue Beam"),
+(-83375, 0, 1, 0, 0, 0, 100, 2, 1000, 1000, 6000, 9000, 11, 32860, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Soulpriest - In Combat - Cast Shadow Bolt'),
+(-83375, 0, 2, 0, 0, 0, 100, 4, 1000, 1000, 6000, 9000, 11, 38378, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Soulpriest - In Combat - Cast Shadow Bolt'),
+(-83375, 0, 3, 0, 0, 0, 100, 0, 12000, 15000, 25000, 25000, 11, 32859, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Soulpriest - In Combat - Cast Falter'),
+(-83375, 0, 4, 0, 0, 0, 100, 2, 5000, 6000, 50000, 50000, 11, 32858, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Soulpriest - In Combat - Cast Touch of the Forgotten'),
+(-83375, 0, 5, 0, 0, 0, 100, 4, 5000, 6000, 50000, 50000, 11, 38377, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Soulpriest - In Combat - Cast Touch of the Forgotten'),
+(-83377, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 11, 32930, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Auchenai Soulpriest - On reset - Cast Blue Beam"),
+(-83377, 0, 1, 0, 0, 0, 100, 2, 1000, 1000, 6000, 9000, 11, 32860, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Soulpriest - In Combat - Cast Shadow Bolt'),
+(-83377, 0, 2, 0, 0, 0, 100, 4, 1000, 1000, 6000, 9000, 11, 38378, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Soulpriest - In Combat - Cast Shadow Bolt'),
+(-83377, 0, 3, 0, 0, 0, 100, 0, 12000, 15000, 25000, 25000, 11, 32859, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Soulpriest - In Combat - Cast Falter'),
+(-83377, 0, 4, 0, 0, 0, 100, 2, 5000, 6000, 50000, 50000, 11, 32858, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Soulpriest - In Combat - Cast Touch of the Forgotten'),
+(-83377, 0, 5, 0, 0, 0, 100, 4, 5000, 6000, 50000, 50000, 11, 38377, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'Auchenai Soulpriest - In Combat - Cast Touch of the Forgotten');
+
+-- Flying Raging Soul
+UPDATE `creature_template` SET `unit_flags` = 0, `flags_extra` = `flags_extra`|128 WHERE `entry` IN (18726,20307);
+DELETE FROM `creature` WHERE `guid` IN (104186, 104200, 104340, 104343, 104369, 104500);
+INSERT INTO `creature` (`guid`, `id`,`map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`, `curmana`, `spawndist`, `MovementType`) VALUES
+(104186, 18726, 558, 3, 1, 72.23869, -139.2275, 41.15045, 0.7930897, 7200, 3914, 2846, 0, 2),
+(104200, 18726, 558, 3, 1, 25.64213, -339.9637, 45.4259, 4.855016, 7200, 3914, 2846, 0, 2),
+(104340, 18726, 558, 3, 1, 147.2713, 46.16996, 24.40821, 3.304033, 7200, 3914, 2846, 0, 2),
+(104343, 18726, 558, 3, 1, 148.9696, -195.7763, 26.32425, 3.020732, 7200, 3914, 2846, 0, 2),
+(104369, 18726, 558, 3, 1, 228.2336, -154.235, 39.60511, 4.203284, 7200, 3914, 2846, 0, 2),
+(104500, 18726, 558, 3, 1, -23.60418, -384.0119, 52.44639, 1.562078, 7200, 3914, 2846, 0, 2);
+DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (18726,20307);
+INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`) VALUES
+(18726, 0, 0, 1, 0), (20307, 0, 0, 1, 0);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (104186, 104200, 104340, 104343, 104369, 104500);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`, `visibilityDistanceType`) VALUES
+(104186, 1041860, 0, 0, 0, 0, '32460', 3),
+(104200, 1042000, 0, 0, 0, 0, '32460', 3),
+(104340, 1043400, 0, 0, 0, 0, '32460', 3),
+(104343, 1043430, 0, 0, 0, 0, '32460', 3),
+(104369, 1043690, 0, 0, 0, 0, '32460', 3),
+(104500, 1045000, 0, 0, 0, 0, '32460', 3);
+
+-- waypoints
+DELETE FROM `waypoint_data` WHERE `id` IN (1041860, 1042000, 1043400, 1043430, 1043690, 1045000);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`,`orientation`,`move_type`,`action_chance`,`wpguid`) VALUES
+-- #44353
+(1041860,1,-20.0318,-137.465,43.2731,000,0,6.1988,0,100,0),
+(1041860,2,72.2387,-139.227,41.0532,2000,0,0.0098567,0,100,0),
+-- #44354
+(1042000,1,25.589,-434.98,46.7206,2000,0,4.67513,0,100,0),
+(1042000,2,25.6421,-339.964,45.4259,2000,0,1.45108,0,100,0),
+-- #44355
+(1043400,1,146.815,-46.1878,25.3337,2000,0,2.0794,0,100,0),
+(1043400,2,147.271,46.17,24.4082,2000,0,1.29006,0,100,0),
+-- #44356
+(1043430,1,93.4215,-196.428,32.1182,0,0,0.0294966,0,100,0),
+(1043430,2,91.0446,-196.97,29.245,0,0,0.0294966,0,100,0),
+(1043430,3,148.97,-195.776,26.3242,0,0,0.0294966,0,100,0),
+-- #44374
+(1043690,1,228.0246,-154.6508,42.45242,0,0,0,0,100,0),
+(1043690,2,225.3313,-160.4796,42.92464,0,0,0,0,100,0),
+(1043690,3,226.2643,-167.0521,43.61908,0,0,0,0,100,0),
+(1043690,4,228.9986,-171.2268,44.09132,0,0,0,0,100,0),
+(1043690,5,234.1654,-174.739,44.61909,0,0,0,0,100,0),
+(1043690,6,240.2302,-175.1677,44.75796,0,0,0,0,100,0),
+(1043690,7,245.7996,-173.5961,44.83619,0,0,0,0,100,0),
+(1043690,8,250.7344,-170.3529,44.89179,0,0,0,0,100,0),
+(1043690,9,253.1533,-164.7733,44.44733,0,0,0,0,100,0),
+(1043690,10,251.4086,-158.4295,43.8496,0,0,0,0,100,0),
+(1043690,11,247.6237,-153.5221,43.16824,0,0,0,0,100,0),
+(1043690,12,241.5865,-149.2656,42.47379,0,0,0,0,100,0),
+(1043690,13,236.1653,-148.9468,42.22376,0,0,0,0,100,0),
+(1043690,14,231.1449,-151.0212,42.19597,0,0,0,0,100,0),
+-- #44375
+(1045000,1,-22.8491,-341.315,52.3623,2000,0,4.63425,0,100,0),
+(1045000,2,-22.9796,-434.141,52.2505,2000,0,1.60654,0,100,0);
+
+-- Phasing Stalker 
+DELETE FROM `creature` WHERE `guid` IN (104501, 104503, 104526, 104534, 104535);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`, `curmana`, `spawndist`, `MovementType`) VALUES
+(104501, 18559, 558, 3, 1, 1, 60.7609, 14.71426, 3.013803, 4.572762, 120, 4892, 8538, 0, 2),
+(104503, 18559, 558, 3, 1, 1, 108.4743, -168.0823, 14.76628, 4.031711, 120, 4892, 8538, 0, 2),
+(104526, 18559, 558, 3, 1, 1, 252.8566, -143.3315, 31.52239, 3.944444, 120, 4892, 8538, 0, 2),
+(104534, 18559, 558, 3, 1, 1, 244.7959, -108.7978, 26.6746, 5.410521, 120, 4892, 8538, 0, 2),
+(104535, 18559, 558, 3, 1, 1, -133.7521, -394.2897, 26.58947, 5.358066, 120, 4892, 8538, 0, 2);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (104501, 104503, 104526, 104534, 104535);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(104501, 1045010, 0, 0, 1, 0, ''),
+(104503, 1045030, 0, 0, 1, 0, ''),
+(104526, 1045260, 0, 0, 1, 0, ''),
+(104534, 1045340, 0, 0, 1, 0, ''),
+(104535, 1045350, 0, 0, 1, 0, '');
+
+DELETE FROM `waypoint_scripts` WHERE id IN (495);
+INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `guid`) VALUES
+(495,1,15,33422,1,0,518);
+
+-- waypoints
+DELETE FROM `waypoint_data` WHERE `id` IN (1045010, 1045030, 1045260, 1045340, 1045350);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`,`orientation`,`move_type`,`action_chance`,`wpguid`) VALUES
+-- #44376
+(1045010,1,60.7609, 14.71426, 3.013803,4000,495,4.572762,0,100,0),
+(1045010,2,60.93705,-19.73963,2.797255,2000,1,4.91534,0,100,0),
+-- #44377
+(1045030,1,108.4743,-168.0823,14.76628,4000,495,4.031711,0,100,0),
+(1045030,2,93.5499,-166.973,15.2408,0,0,0,0,100,0),
+(1045030,3,87.3811,-167.817,15.2925,0,0,0,0,100,0),
+(1045030,4,83.1063,-169.717,15.299,0,0,0,0,100,0),
+(1045030,5,80.6213,-173.26,15.3327,2000,1,0,0,100,0),
+-- #44415
+(1045260,1,244.7959,-108.7978,26.6746,4000,495,5.410521,0,100,0),
+(1045260,2,244.18,-83.3991,26.5913,0,0,0,0,100,0),
+(1045260,3,244.243,-61.4379,26.5913,2000,1,1.7439,0,100,0),
+-- #44378
+(1045340,1,252.8566,-143.3315,31.52239,4000,495,3.944444,0,100,0),
+(1045340,2,239.474,-140.565,26.592,0,0,0,0,100,0),
+(1045340,3,232.99,-142.095,26.5913,0,0,0,0,100,0),
+(1045340,4,226.853,-145.607,26.5924,0,0,0,0,100,0),
+(1045340,5,223.005,-149.411,26.5913,0,0,0,0,100,0),
+(1045340,6,219.412,-156.105,26.5913,0,0,0,0,100,0),
+(1045340,7,218.315,-163.06,26.5913,0,0,0,0,100,0),
+(1045340,8,219.385,-170.84,26.5913,0,0,0,0,100,0),
+(1045340,9,222.656,-177.147,26.5913,0,0,0,0,100,0),
+(1045340,10,229.725,-182.67,26.5913,0,0,0,0,100,0),
+(1045340,11,233.935,-186.756,26.5913,0,0,0,0,100,0),
+(1045340,12,235.006,-191.854,26.5913,2000,1,0,0,100,0),
+-- #44416
+(1045350,1,-133.7521,-394.2897,26.58947,4000,495,3.944444,0,100,0),
+(1045350,2,-149.727,-393.6,26.5896,0,0,0,0,100,0),
+(1045350,3,-151.597,-388.018,26.5896,0,0,0,0,100,0),
+(1045350,4,-151.722,-368.615,26.5891,2000,1,0,0,100,0);
+
+-- Phasing Soldier
+DELETE FROM `creature` WHERE `guid` IN (104638, 104705, 104706, 104762);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`, `curmana`, `spawndist`, `MovementType`) VALUES
+(104638, 18556, 558, 3, 1, 1, 126.1766, 27.94813, -0.04512966, 5.288348, 60, 6116, 0, 0, 2),
+(104705, 18556, 558, 3, 1, 1, 170.2127, -18.67884, 1.893939, 6.126106, 60, 6116, 0, 0, 2),
+(104706, 18556, 558, 3, 1, 1, 234.8801, -118.7665, 26.67463, 0.6283185, 60, 6116, 0, 0, 2),
+(104762, 18556, 558, 3, 1, 1, 254.0859, 16.28111, 1.211097, 3.996804, 60, 6116, 0, 0, 2);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (104638, 104705, 104706, 104762);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(104638, 1046380, 0, 0, 1, 0, ''),
+(104705, 1047050, 0, 0, 1, 0, ''),
+(104706, 1047060, 0, 0, 1, 0, ''),
+(104762, 1047620, 0, 0, 1, 0, '');
+
+-- waypoints
+DELETE FROM `waypoint_data` WHERE `id` IN (1046380,1047050,1047060,1047620);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`,`orientation`,`move_type`,`action_chance`,`wpguid`) VALUES
+-- #44422
+(1046380,1,126.1766,27.94813,-0.04512966,4000,495,5.288348,0,100,0),
+(1046380,2,130.413,14.816,-0.128968,0,0,4.73591,0,100,0),
+(1046380,3,133.132,0.717417,-0.128914,0,0,5.1286,0,100,0),
+(1046380,4,143.315,-5.41157,1.58459,0,0,5.92184,0,100,0),
+(1046380,5,158.808,-6.77153,1.31353,0,0,5.84487,0,100,0),
+(1046380,6,163.114,-11.3245,1.29405,0,0,5.18357,0,100,0),
+(1046380,7,166.81,-15.4839,2.5976,2000,1,5.37599,0,100,0),
+-- #56027
+(1047050,1,170.2127,-18.67884,1.893939,4000,495,6.126106,0,100,0),
+(1047050,2,184.873,-19.2238,-0.123683,0,0,0.673793,0,100,0),
+(1047050,3,192.66,-5.28754,-0.120491,0,0,1.47881,0,100,0),
+(1047050,4,193.01,4.14019,-0.120491,0,0,1.76234,0,100,0),
+(1047050,5,190.2,11.8762,-0.121558,0,0,1.31317,0,100,0),
+(1047050,6,191.501,15.6137,2.23181,2000,1,1.85266,0,100,0),
+-- #56029
+(1047060,1,234.8801,-118.7665,26.67463,4000,495,0.6283185,0,100,0),
+(1047060,2,234.39,-90.9739,26.5913,0,0,1.40655,0,100,0),
+(1047060,3,235.578,-85.3769,26.5913,0,0,1.70814,0,100,0),
+(1047060,4,232.895,-74.7759,26.5913,2000,1,1.64609,0,100,0),
+-- #56030
+(1047620,1,254.0859,16.28111,1.211097,4000,495,3.996804,0,100,0),
+(1047620,2,248.956,13.8873,-0.0516049,0,0,4.57014,0,100,0),
+(1047620,3,247.572,-5.56347,-0.05535,0,0,4.1853,0,100,0),
+(1047620,4,240.99,-13.6141,-0.0627278,0,0,4.28347,0,100,0),
+(1047620,5,239.211,-17.6737,-0.0641297,0,0,4.53873,0,100,0),
+(1047620,6,241.667,-27.1563,-0.0669469,0,0,5.4537,0,100,0),
+(1047620,7,244.899,-29.4505,2.24718,2000,1,5.77571,0,100,0);
+
+-- Phasing Cleric
+DELETE FROM `creature` WHERE `guid` IN (104763, 104764, 104771, 104774);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`, `curmana`, `spawndist`, `MovementType`) VALUES
+(104763, 18557, 558, 3, 1, 1, 103.5104, -31.66116, 2.187038, 1.361357, 90, 4892, 8370, 0, 2), 
+(104764, 18557, 558, 3, 1, 1, -138.9091, -205.6192, 26.67431, 2.75762, 90, 4892, 8370, 0, 2),
+(104771, 18557, 558, 3, 1, 1, 186.351, -184.6046, 26.61729, 1.586355, 90, 4892, 8370, 0, 2), 
+(104774, 18557, 558, 3, 1, 1, 265.7227, -167.3999, 26.67464, 3.647738, 90, 4892, 8370, 0, 2);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (104763, 104764, 104771, 104774);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(104763, 1047630, 0, 0, 1, 0, ''),
+(104764, 1047640, 0, 0, 1, 0, ''),
+(104771, 1047710, 0, 0, 1, 0, ''),
+(104774, 1047740, 0, 0, 1, 0, '');
+
+-- waypoints
+DELETE FROM `waypoint_data` WHERE `id` IN (1047630, 1047640, 1047710, 1047740);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`,`orientation`,`move_type`,`action_chance`,`wpguid`) VALUES
+-- #56031
+(1047630,1,103.5104,-31.66116,2.187038,4000,495,1.361357,0,100,0),
+(1047630,2,104.433,-26.1661,-0.0697232,0,0,1.6325,0,100,0),
+(1047630,3,102.222,-12.2622,0.17732,0,0,1.4675,0,100,0),
+(1047630,4,105.19,-1.24617,-0.0426896,0,0,1.56018,0,100,0),
+(1047630,5,104.13,9.48964,0.251931,0,0,1.71947,0,100,0),
+(1047630,6,103.15,15.0193,-0.0717281,0,0,1.56396,0,100,0),
+(1047630,7,106.842,21.3685,0.224192,0,0,0.659183,0,100,0),
+(1047630,8,112.74,22.792,-0.0508767,2000,1,0.164383,0,100,0),
+-- #56033
+(1047640,1,-138.9091,-205.6192,26.67431,4000,495,2.75762,0,100,0),
+(1047640,2,-140.285,-181.608,26.5911,0,0,1.47598,0,100,0),
+(1047640,3,-138.759,-174.98,26.5916,0,0,1.22465,0,100,0),
+(1047640,4,-136.741,-171.113,26.5926,0,0,0.732993,0,100,0),
+(1047640,5,-133.77,-169.383,26.591,0,0,0.248402,0,100,0),
+(1047640,6,-129.733,-169.142,26.5893,2000,1,0.223269,0,100,0),
+-- #56034
+(1047710,1,186.351,-184.6046,26.61729,4000,495,1.586355,0,100,0),
+(1047710,2,186.827,-139.192,26.5154,2000,1,2.37055,0,100,0),
+-- #56035
+(1047740,1,265.7227,-167.3999,26.67464,4000,495,3.647738,0,100,0),
+(1047740,2,255.79,-172.018,26.5913,0,0,3.93556,0,100,0),
+(1047740,3,248.786,-179.103,29.9438,0,0,3.71048,0,100,0),
+(1047740,4,242.514,-182.389,28.7502,0,0,3.35077,0,100,0),
+(1047740,5,237.058,-182.979,26.5913,0,0,3.06253,0,100,0),
+(1047740,6,231.523,-180.122,26.5913,0,0,3.28951,0,100,0),
+(1047740,7,227.297,-181.833,26.5913,0,0,3.6987,0,100,0),
+(1047740,8,222.569,-185.367,26.5913,2000,1,3.92565,0,100,0);
+
+-- Phasing Sorcerer
+DELETE FROM `creature` WHERE `guid` IN (104775, 104779, 104780, 104782, 104783, 104784, 104785);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`, `curmana`, `spawndist`, `MovementType`) VALUES
+(104775, 18558, 558, 3, 1, 1, 235.8882, 37.07132, 26.68999, 6.230825, 180, 4731, 8538, 0, 2),
+(104779, 18558, 558, 3, 1, 1, 127.6753, -9.820141, 0.9926163, 4.747295, 180, 4731, 8538, 0, 2),
+(104780, 18558, 558, 3, 1, 1, -150.5842, -157.2742, 26.67392, 2.111848, 180, 4731, 8538, 0, 2),
+(104782, 18558, 558, 3, 1, 1, 63.40744, -175.2639, 15.4378, 6.143559, 180, 4731, 8538, 0, 2),
+(104783, 18558, 558, 3, 1, 1, 163.4202, -22.14446, 3.989299, 3.508112, 180, 4731, 8538, 0, 2),
+(104784, 18558, 558, 3, 1, 1, 219.379, 0.330607, 28.41068, 3.909538, 180, 4731, 8538, 0, 2),
+(104785, 18558, 558, 3, 1, 1, 182.6577, -140.5554, 26.481, 2.251475, 180, 4731, 8538, 0, 2);
+
+DELETE FROM `creature_addon` WHERE `guid` IN (104775, 104779, 104780, 104782, 104783, 104784, 104785);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(104775, 1047750, 0, 0, 1, 0, ''),
+(104779, 1047790, 0, 0, 1, 0, ''),
+(104780, 1047800, 0, 0, 1, 0, ''),
+(104782, 1047820, 0, 0, 1, 0, ''),
+(104783, 1047830, 0, 0, 1, 0, ''),
+(104784, 1047840, 0, 0, 1, 0, ''),
+(104785, 1047850, 0, 0, 1, 0, '');
+
+-- waypoints
+DELETE FROM `waypoint_data` WHERE `id` IN (1047750, 1047790, 1047800, 1047820, 1047830, 1047840, 1047850);
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`,`orientation`,`move_type`,`action_chance`,`wpguid`) VALUES
+-- #56036
+(1047750,1,235.8882,37.07132,26.68999,4000,495,6.230825,0,100,0),
+(1047750,2,239.259,37.7349,26.6029,0,0,0.0645036,0,100,0),
+(1047750,3,256.93,38.6263,13.3965,0,0,0.0095253,0,100,0),
+(1047750,4,269.565,37.909,13.4,0,0,5.97698,0,100,0),
+(1047750,5,272.876,36.4516,13.4071,0,0,5.51203,0,100,0),
+(1047750,6,274.621,31.0997,13.4011,0,0,4.88842,0,100,0),
+(1047750,7,274.341,20.9334,13.395,0,0,4.73348,0,100,0),
+(1047750,8,274.476,2.9775,-0.0701511,2000,1,4.74526,0,100,0),
+-- #56038
+(1047790,1,127.6753,-9.820141,0.9926163,4000,495,4.747295,0,100,0),
+(1047790,2,129.718,-18.8049,5.70304,0,0,4.75462,0,100,0),
+(1047790,3,130.379,-25.2794,8.45543,0,0,5.11433,0,100,0),
+(1047790,4,133.553,-30.3262,11.2518,0,0,5.57378,0,100,0),
+(1047790,5,139.812,-33.5707,13.4815,0,0,5.96333,0,100,0),
+(1047790,6,162.159,-39.9172,12.2277,2000,1,5.94841,0,100,0),
+-- #56045
+(1047800,1,-150.5842,-157.2742,26.67392,4000,495,2.111848,0,100,0),
+(1047800,2,-149.429,-185.735,26.5896,0,0,4.56091,0,100,0),
+(1047800,3,-150.932,-204.497,26.5896,2000,1,4.51771,0,100,0),
+-- #56047
+(1047820,1,63.40744,-175.2639,15.4378,4000,495,6.143559,0,100,0),
+(1047820,2,64.7937,-157.134,15.3266,0,0,1.75359,0,100,0),
+(1047820,3,63.5111,-153.674,15.2878,0,0,2.37484,0,100,0),
+(1047820,4,60.752,-151.984,15.3325,0,0,2.9953,0,100,0),
+(1047820,5,58.266,-151.812,15.3223,0,0,3.70452,0,100,0),
+(1047820,6,54.7178,-154.831,15.2635,0,0,3.49953,0,100,0),
+(1047820,7,37.6081,-157.491,14.737,0,0,3.13589,0,100,0),
+(1047820,8,33.8367,-155.836,14.4978,2000,1,2.64423,0,100,0),
+-- #56048
+(1047830,1,163.4202,-22.14446,3.989299,4000,495,3.508112,0,100,0),
+(1047830,2,161.65,-24.0089,3.37202,0,0,3.68489,0,100,0),
+(1047830,3,155.926,-27.0396,7.4329,0,0,3.21914,0,100,0),
+(1047830,4,148.549,-26.228,9.19468,0,0,3.24506,0,100,0),
+(1047830,5,132.089,-33.6267,12.8042,0,0,3.71394,0,100,0),
+(1047830,6,126.817,-37.1354,12.2635,2000,1,3.73358,0,100,0),
+-- #56050
+(1047840,1,219.379,0.330607,28.41068,4000,495,3.909538,0,100,0),
+(1047840,2,214.701,-6.09303,27.1319,0,0,4.23051,0,100,0),
+(1047840,3,212.107,-14.6145,27.3325,0,0,4.67976,0,100,0),
+(1047840,4,212.901,-23.2855,26.8425,0,0,5.13371,0,100,0),
+(1047840,5,216.698,-27.9429,26.5917,0,0,5.67642,0,100,0),
+(1047840,6,224.025,-30.2683,27.3426,0,0,0.171554,0,100,0),
+(1047840,7,251.498,-29.3868,26.6004,0,0,6.11557,0,100,0),
+(1047840,8,274.178,-32.1791,26.5917,2000,1,6.2216,0,100,0),
+-- #56051
+(1047850,1,182.6577,-140.5554,26.481,4000,495,2.251475,0,100,0),
+(1047850,2,180.946,-148.912,26.3075,0,0,4.15175,0,100,0),
+(1047850,3,173.12,-151.982,26.3432,0,0,3.34908,0,100,0),
+(1047850,4,161.632,-153.271,25.9648,0,0,3.1221,0,100,0),
+(1047850,5,145.97,-152.706,13.7712,2000,1,3.13306,0,100,0);
+
+-- Auchenai Monk
+UPDATE `creature_template_addon` SET `bytes1` = 0, `emote` = 0 WHERE `entry` = 18497;
+DELETE FROM `creature_addon` WHERE guid IN (83389,83390,83391,83392,83394,83395,83404,83406,83407,83408,83409);
+INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`, `visibilityDistanceType`) VALUES 
+(83389,0,8,1,0,"",3),
+(83390,0,0,1,0,"",3),
+(83391,0,0,1,0,"",3),
+(83392,0,0,1,0,"",3),
+(83394,0,0,1,375,"",3),
+(83395,0,8,1,0,"",3),
+(83404,0,0,1,0,"",3),
+(83406,0,0,1,0,"",3),
+(83407,0,8,1,0,"",3),
+(83408,0,8,1,0,"",3),
+(83409,0,0,1,375,"",3);
+
+DELETE FROM `waypoint_scripts` WHERE id IN (496);
+INSERT INTO `waypoint_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`,`guid`) VALUES
+(496,2,15,68442,1,0,520), 
+(496,8,14,68442,1,0,521);
+
+-- #83390
+UPDATE `creature` SET `position_x` = 125.4166, `position_y` = -3.267882, `position_z` = 0.2067913, `orientation` = 2.443461, `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 83390;
+DELETE FROM `creature_addon` WHERE `guid` IN (83390);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`, `visibilityDistanceType`) VALUES
+(83390, 833900, 0, 0, 1, 0, '', 3);
+DELETE FROM `waypoint_data` WHERE `id` = 833900;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`,`orientation`,`move_type`,`action_chance`,`wpguid`) VALUES
+(833900,1,141.006,2.68584,-0.128801,0,0,0,0,100,0),
+(833900,2,159.988,3.10692,-0.127278,0,0,0,0,100,0),
+(833900,3,164.698,7.8893,-0.12723,0,0,0,0,100,0),
+(833900,4,164.759,26.825,-0.0149954,0,0,0,0,100,0),
+(833900,5,159.95,30.5454,-0.107823,0,0,0,0,100,0),
+(833900,6,154.02,33.0068,-0.0870224,0,0,0,0,100,0),
+(833900,7,153.852,38.8914,4.25014,10000,496,1.58277,0,100,0),
+(833900,8,150.685,32.9604,-0.0868603,0,0,0,0,100,0),
+(833900,9,132.422,30.3528,-0.107012,0,0,0,0,100,0),
+(833900,10,129.487,24.9777,-0.127918,0,0,0,0,100,0),
+(833900,11,129.114,-2.94603,0.100162,0,0,0,0,100,0),
+(833900,12,125.4166,-3.267882,0.2067913,10000,496,2.443461,0,100,0);
+
+-- #83394
+UPDATE `creature` SET `position_x` = -127.4433, `position_y` = -159.4812, `position_z` = 26.589, `orientation` = 6.056293, `MovementType` = 0, `spawndist` = 0 WHERE `guid` = 83394;
+
+-- #83404
+UPDATE `creature` SET `MovementType` = 2, `spawndist` = 0 WHERE `guid` = 83404;
+DELETE FROM `waypoint_data` WHERE `id` = 834040;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`action`,`orientation`,`move_type`,`action_chance`,`wpguid`) VALUES
+(834040,1,223.202,16.427,-0.0725319,9000,0,3.08626,0,100,0),
+(834040,2,237.233,16.056,-0.0609689,9000,0,6.27105,0,100,0);
+DELETE FROM `creature_addon` WHERE `guid` IN (83404);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`, `visibilityDistanceType`) VALUES
+(83404, 834040, 0, 0, 1, 0, '', 3);
+
+-- #83406
+UPDATE `creature` SET `MovementType` = 0, `spawndist` = 0 WHERE `guid` = 83406;
+DELETE FROM `waypoint_data` WHERE `id` = 834060;
+UPDATE `creature_addon` SET `path_id`=0 WHERE `guid` IN (83406);
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (83386);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(83386, 83386, 0, 0, 515),
+(83386, 83406, 3, 90, 515);
+
+-- #83391
+UPDATE `creature` SET `MovementType` = 0, `spawndist` = 0 WHERE `guid` = 83391;
+DELETE FROM `waypoint_data` WHERE `id` = 833910;
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (83372);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(83372, 83372, 0, 0, 515),
+(83372, 83391, 3, 90, 515);
+
+-- #83392
+UPDATE `creature` SET `id` = 18495, `curhealth` = 13720, `curmana` = 8370 WHERE `guid` = 83392;
+UPDATE `creature` SET `MovementType` = 0, `spawndist` = 0 WHERE `guid` IN (83378,83385);
+DELETE FROM `waypoint_data` WHERE `id` IN (833780,833850);
+UPDATE `creature_addon` SET `path_id`=0 WHERE `guid` IN (83378,83385);
+UPDATE `creature_addon` SET `path_id`=833920 WHERE `guid` IN (83392);
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (83392);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`) VALUES
+(83392, 83392, 0, 0, 515),
+(83392, 83378, 3, 45, 515),
+(83392, 83385, 3, 315, 515);
+
+-- Raging Soul
+DELETE FROM `creature` WHERE `guid` IN (104786, 104787, 104788, 104794, 104806, 104807, 104808, 104809);
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `curhealth`, `curmana`, `spawndist`, `MovementType`) VALUES
+(104786, 18506, 558, 3, 1, 0, 107.435, -162.702, 14.7348, 3.12299, 7200, 2602, 2790, 0, 0),
+(104787, 18506, 558, 3, 1, 0, 65.5859, -162.649, 15.4433, 6.20175, 7200, 2602, 2790, 0, 0),
+(104788, 18506, 558, 3, 1, 0, 83.0079, -170.105, 15.2972, 2.91093, 7200, 2602, 2790, 0, 0),
+(104794, 18506, 558, 3, 1, 0, 25.4440, -164.100, 13.8690, 1.15943, 7200, 2602, 2790, 0, 0),
+(104806, 18506, 558, 3, 1, 0, 132.754, -162.814, 12.6510, 0.00417, 7200, 2602, 2790, 0, 0),
+(104807, 18506, 558, 3, 1, 0, 53.7874, -164.232, 15.2894, 2.94663, 7200, 2602, 2790, 0, 0),
+(104808, 18506, 558, 3, 1, 0, 84.1240, -157.022, 15.2885, 2.88737, 7200, 2602, 2790, 0, 0),
+(104809, 18506, 558, 3, 1, 0, 40.2054, -163.242, 14.8459, 1.35584, 7200, 2602, 2790, 0, 0);
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN(18506);
+INSERT INTO `creature_template_addon` (entry, auras) VALUES (18506, '35841 35850');
+
+DELETE FROM `smart_scripts`   WHERE `entryorguid` IN (18506) 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
+(18506, 0, 0, 0, 0, 0, 100, 3, 0, 0, 0, 0, 11, 32888, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Raging Soul - In Combat - Cast 'Rage' (No Repeat) (Dungeon)"),
+(18506, 0, 1, 0, 0, 0, 100, 5, 0, 0, 0, 0, 11, 38380, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Raging Soul - In Combat - Cast 'Rage' (No Repeat) (Dungeon)"),
+(18506, 0, 2, 0, 25, 0, 100, 0, 0, 0, 0, 0, 47, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Raging Soul - On reset - Set visible Off"),
+(18506, 0, 3, 0, 4, 0, 100, 0, 0, 0, 0, 0, 47, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Raging Soul - On aggro - Set visible On");