DB/Creature: Add SAI to some Obsidian Sanctum trash mobs

closes #28518 by CraftedRO

1 files changed, 273 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2024_02_16_06_world.sql b/sql/updates/world/3.3.5/2024_02_16_06_world.sql
new file mode 100644
index 00000000000..832625fbe5d
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_02_16_06_world.sql
@@ -0,0 +1,273 @@
+-- Onyx Blaze Mistress
+SET @ENTRY := 30681;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `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,2,5000,5000,12000,13000,11,39529,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Flame Shock'),
+(@ENTRY,0,1,0,0,0,100,4,5000,5000,12000,13000,11,58940,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Flame Shock'),
+(@ENTRY,0,2,0,0,0,100,2,8000,8000,19000,22000,11,57757,0,0,0,0,0,5,0,0,0,0,0,0,0,'Cast Rain of Fire'),
+(@ENTRY,0,3,0,0,0,100,4,8000,8000,19000,22000,11,58936,0,0,0,0,0,5,0,0,0,0,0,0,0,'Cast Rain of Fire'),
+(@ENTRY,0,4,0,0,0,100,6,3000,11000,8000,15000,11,57753,0,0,0,0,0,5,0,0,0,0,0,0,0,'Cast Conjure Flame Orb');
+
+-- Onyx Brood General
+SET @ENTRY := 30680;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `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,4,0,100,3,0,0,0,0,11,57740,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Devotion Aura on Aggro'),
+(@ENTRY,0,1,0,4,0,100,5,0,0,0,0,11,58944,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Devotion Aura on Aggro'),
+(@ENTRY,0,2,0,0,0,100,6,4500,4500,11500,13500,11,13737,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Mortal Strike Shock'),
+(@ENTRY,0,3,0,0,0,100,7,6000,6000,0,0,11,57742,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Avenging Fury Shock'),
+(@ENTRY,0,4,0,2,0,100,3,0,30,0,0,11,57733,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Draconic Rage at 30% HP'),
+(@ENTRY,0,5,0,2,0,100,5,0,30,0,0,11,58942,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Draconic Rage at 30% HP'),
+(@ENTRY,0,6,0,37,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,' Onyx Brood General -  On init -  say text');
+
+DELETE FROM `creature_text` WHERE `CreatureID`=@ENTRY;
+INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextId`) VALUES
+(@ENTRY,0,0, 'Brood Guardians reporting in!',14,0,100,0,0,0, 'Onyx Brood General', 31397);
+
+-- Onyx Flight Captain
+SET @ENTRY := 30682;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `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,13,0,100,6,12000,14000,0,0,11,58953,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Pummel'),
+(@ENTRY,0,1,0,0,0,100,6,8000,9000,15000,21000,11,57759,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Hammer Drop');
+
+-- Onyx Sanctum Guardian
+SET @ENTRY := 30453;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `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,2,4000,5500,25000,31000,11,58948,0,0,0,0,0,5,0,0,0,0,0,0,0,'Cast Curse of Mending'),
+(@ENTRY,0,1,0,0,0,100,4,4000,5500,25000,31000,11,39647,0,0,0,0,0,5,0,0,0,0,0,0,0,'Cast Curse of Mending'),
+(@ENTRY,0,2,0,0,0,100,2,9000,9000,17800,19300,11,57728,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Shockwave'),
+(@ENTRY,0,3,0,0,0,100,4,9000,9000,17800,19300,11,58947,0,0,0,0,0,2,0,0,0,0,0,0,0,'Cast Shockwave'),
+(@ENTRY,0,4,0,2,0,100,7,0,30,0,0,11,53801,0,0,0,0,0,1,0,0,0,0,0,0,0,'Cast Frenzy at 30% HP'),
+(@ENTRY,0,5,0,2,0,100,7,0,30,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Say Text at 30% HP'),
+(@ENTRY,0,6,0,37,0,100,0,0,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,' Onyx Sanctum Guardian -  On init -  say text');
+
+-- NPC talk text insert
+SET @ENTRY := 30453;
+DELETE FROM `creature_text` WHERE `CreatureID`=@ENTRY;
+INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextId`) VALUES
+(@ENTRY,0,0, '%s goes into a frenzy!',16,0,100,0,0,0, 'Onyx Sanctum Guardian', 38630),
+(@ENTRY,1,0, 'Sanctum Guardians reporting in!',14,0,100,0,0,0, 'Onyx Sanctum Guardian', 31398);
+
+DELETE FROM `spell_scripts` WHERE `id`=57753;
+INSERT INTO `spell_scripts` (`id`,`effIndex`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES
+(57753,0,0,15,57752,1,0,0,0,0,0);
+
+UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80, `flags_extra` = `flags_extra` | 128 WHERE `entry`=30702;
+DELETE FROM `creature_template_movement` WHERE `CreatureId`=30702;
+INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES
+(30702, 1, 0, 1, 0, 0, 0);
+
+SET @ENTRY := 30702;
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `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,54,0,100,2,0,0,0,0,11,57750,0,0,0,0,0,1,0,0,0,0,0,0,0,'Flame Orb - On just summoned cast Flame Orb Periodic'),
+(@ENTRY,0,1,0,54,0,100,4,0,0,0,0,11,58937,0,0,0,0,0,1,0,0,0,0,0,0,0,'Flame Orb - On just summoned cast Flame Orb Periodic');
+
+-- Obsidian Sanctum waypoints
+UPDATE `creature` SET `position_x`=3350.9028, `position_y`=605.6205, `position_z`=81.4778, `orientation`=5.927615 WHERE `guid`=126408;
+UPDATE `creature` SET `MovementType`=0, `wander_distance`=0 WHERE `id` IN (30682, 30681, 30680, 30453);
+UPDATE `creature` SET `MovementType`=2, `wander_distance`=0 WHERE `guid` IN (126400, 126416, 126419, 126397, 126420);
+DELETE FROM `waypoint_data` WHERE `id` IN (1264000, 1263970, 1264190, 1264200, 1264160);
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `action_chance`) VALUES
+(1264190, 1, 3332.0102, 429.091, 78.794, 1.5062, 100),
+(1264190, 2, 3343.9570, 452.438, 85.929, 1.0978, 100),
+(1264190, 3, 3369.7429, 476.040, 89.712, 0.7208, 100),
+(1264190, 4, 3382.5805, 500.874, 95.542, 1.1017, 100),
+(1264190, 5, 3383.0485, 527.715, 97.365, 1.5533, 100),
+(1264190, 6, 3388.1821, 558.191, 93.693, 1.4002, 100),
+(1264190, 7, 3393.3735, 595.698, 89.438, 1.4512, 100),
+(1264190, 8, 3373.2280, 612.496, 86.898, 2.4644, 100),
+(1264190, 9, 3342.7526, 637.813, 84.871, 2.4487, 100),
+(1264190, 10, 3301.7080, 670.548, 84.361, 2.468, 100),
+(1264190, 11, 3270.8374, 685.738, 90.816, 2.684, 100),
+(1264190, 12, 3237.6757, 683.316, 90.025, 3.214, 100),
+(1264190, 13, 3207.4113, 681.106, 90.128, 3.214, 100),
+(1264190, 14, 3174.1948, 682.600, 83.377, 3.096, 100),
+(1264190, 15, 3141.6208, 648.341, 75.023, 3.952, 100),
+(1264190, 16, 3114.3566, 607.690, 74.483, 4.121, 100),
+(1264190, 17, 3141.6208, 648.341, 75.023, 3.952, 100),
+(1264190, 18, 3174.1948, 682.600, 83.377, 3.096, 100),
+(1264190, 19, 3207.4113, 681.106, 90.128, 3.214, 100),
+(1264190, 20, 3237.6757, 683.316, 90.025, 3.214, 100),
+(1264190, 21, 3270.8374, 685.738, 90.816, 2.684, 100),
+(1264190, 22, 3301.7080, 670.548, 84.361, 2.468, 100),
+(1264190, 23, 3342.7526, 637.813, 84.871, 2.448, 100),
+(1264190, 24, 3373.2280, 612.496, 86.898, 2.464, 100),
+(1264190, 25, 3393.3735, 595.698, 89.438, 1.451, 100),
+(1264190, 26, 3388.1821, 558.191, 93.693, 1.400, 100),
+(1264190, 27, 3383.0485, 527.715, 97.365, 1.553, 100),
+(1264190, 28, 3382.5805, 500.874, 95.542, 1.101, 100),
+(1264190, 29, 3369.7429, 476.040, 89.712, 0.720, 100),
+(1264190, 30, 3343.9570, 452.438, 85.929, 1.097, 100),
+(1264190, 31, 3332.0102, 429.091, 78.794, 1.506, 100),
+(1263970, 1, 3372.50, 598.436, 86.154, 5.66, 100),
+(1263970, 2, 3391.99, 584.598, 88.329, 5.55, 100),
+(1263970, 3, 3385.81, 556.752, 93.731, 4.49, 100),
+(1263970, 4, 3380.11, 519.343, 97.941, 4.72, 100),
+(1263970, 5, 3376.38, 486.877, 92.088, 4.62, 100),
+(1263970, 6, 3383.20, 517.591, 97.957, 1.39, 100),
+(1263970, 7, 3388.67, 556.848, 94.038, 1.37, 100),
+(1263970, 8, 3391.25, 595.820, 88.642, 1.52, 100),
+(1263970, 9, 3356.48, 624.187, 85.876, 2.46, 100),
+(1263970, 10,3321.08, 643.297, 82.100, 2.69, 100),
+(1263970, 11,3294.79, 668.056, 84.307, 2.39, 100),
+(1263970, 12,3268.38, 681.741, 90.226, 2.66, 100),
+(1263970, 13,3219.20, 687.871, 91.717, 3.01, 100),
+(1263970, 14,3183.79, 691.095, 88.156, 3.05, 100),
+(1263970, 15,3149.17, 654.760, 75.371, 3.94, 100),
+(1263970, 16,3183.79, 691.095, 88.156, 3.05, 100),
+(1263970, 17,3219.20, 687.871, 91.717, 3.01, 100),
+(1263970, 18,3268.38, 681.741, 90.226, 2.66, 100),
+(1263970, 19,3294.79, 668.056, 84.307, 2.39, 100),
+(1263970, 20,3321.08, 643.297, 82.100, 2.69, 100),
+(1263970, 21,3356.48, 624.187, 85.876, 2.46, 100),
+(1263970, 22,3391.25, 595.820, 88.642, 1.52, 100),
+(1263970, 23,3388.67, 556.848, 94.038, 1.37, 100),
+(1263970, 24,3383.20, 517.591, 97.957, 1.39, 100),
+(1263970, 25,3376.38, 486.877, 92.088, 4.62, 100),
+(1263970, 26,3380.11, 519.343, 97.941, 4.72, 100),
+(1263970, 27,3385.81, 556.752, 93.731, 4.49, 100),
+(1263970, 28,3391.99, 584.598, 88.329, 5.55, 100),
+(1263970, 29,3372.50, 598.436, 86.154, 5.66, 100),
+(1264200, 1, 3267.378, 698.5934, 92.354, 5.718285, 100),
+(1264200, 2, 3302.062, 672.2496, 84.765, 5.522720, 100),
+(1264200, 3, 3333.458, 652.1536, 84.932, 5.457532, 100),
+(1264200, 4, 3352.582, 626.3783, 85.136, 5.350718, 100),
+(1264200, 5, 3373.487, 611.5072, 86.704, 5.664877, 100),
+(1264200, 6, 3391.500, 594.7894, 88.706, 4.840994, 100),
+(1264200, 7, 3384.716, 561.2724, 92.617, 4.339125, 100),
+(1264200, 8, 3374.466, 534.5934, 96.967, 4.600662, 100),
+(1264200, 9, 3391.568, 567.7532, 90.748, 1.094646, 100),
+(1264200, 10,3391.582, 594.7891, 88.731, 1.762235, 100),
+(1264200, 11,3363.784, 617.0189, 86.301, 2.468308, 100),
+(1264200, 12,3324.081, 648.6863, 83.291, 2.468308, 100),
+(1264200, 13,3288.948, 676.7089, 87.241, 2.468308, 100),
+(1264200, 14,3263.845, 694.3148, 91.789, 2.939547, 100),
+(1264200, 15,3213.507, 690.4353, 92.251, 3.079348, 100),
+(1264200, 16,3182.588, 679.6979, 84.685, 3.670753, 100),
+(1264200, 17,3158.388, 665.5455, 76.847, 3.670753, 100),
+(1264200, 18,3137.634, 639.5677, 74.070, 4.038320, 100),
+(1264200, 19,3119.810, 617.2574, 74.045, 4.038320, 100),
+(1264200, 20,3102.376, 593.9634, 78.290, 4.862988, 100),
+(1264200, 21,3110.314, 567.3189, 88.657, 5.100964, 100),
+(1264200, 22,3115.361, 539.7775, 87.775, 4.893619, 100),
+(1264200, 23,3110.314, 567.3189, 88.657, 5.100964, 100),
+(1264200, 24,3102.376, 593.9634, 78.290, 4.862988, 100),
+(1264200, 25,3119.810, 617.2574, 74.045, 4.038320, 100),
+(1264200, 26,3137.634, 639.5677, 74.070, 4.038320, 100),
+(1264200, 27,3158.388, 665.5455, 76.847, 3.670753, 100),
+(1264200, 28,3182.588, 679.6979, 84.685, 3.670753, 100),
+(1264200, 29,3213.507, 690.4353, 92.251, 3.079348, 100),
+(1264200, 30,3263.845, 694.3148, 91.789, 2.939547, 100),
+(1264200, 31,3288.948, 676.7089, 87.241, 2.468308, 100),
+(1264200, 32,3324.081, 648.6863, 83.291, 2.468308, 100),
+(1264200, 33,3363.784, 617.0189, 86.301, 2.468308, 100),
+(1264200, 34,3391.582, 594.7891, 88.731, 1.762235, 100),
+(1264200, 35,3391.568, 567.7532, 90.748, 1.094646, 100),
+(1264200, 36,3374.466, 534.5934, 96.967, 4.600662, 100),
+(1264200, 37,3384.716, 561.2724, 92.617, 4.339125, 100),
+(1264200, 38,3391.500, 594.7894, 88.706, 4.840994, 100),
+(1264200, 39,3373.487, 611.5072, 86.704, 5.664877, 100),
+(1264200, 40,3352.582, 626.3783, 85.136, 5.350718, 100),
+(1264200, 41,3333.458, 652.1536, 84.932, 5.457532, 100),
+(1264200, 42,3302.062, 672.2496, 84.765, 5.522720, 100),
+(1264200, 43,3267.378, 698.5934, 92.354, 5.718285, 100),
+(1264000, 1, 3105.902, 624.807, 77.330, 1.0742, 100),
+(1264000, 2, 3105.188, 574.659, 84.079, 4.7302, 100),
+(1264000, 3, 3113.553, 547.966, 89.451, 5.0090, 100),
+(1264000, 4, 3124.773, 514.301, 88.815, 5.0247, 100),
+(1264000, 5, 3121.065, 479.498, 85.652, 4.6085, 100),
+(1264000, 6, 3150.509, 448.767, 74.152, 5.4763, 100),
+(1264000, 7, 3123.917, 476.544, 84.755, 2.3112, 100),
+(1264000, 8, 3126.805, 516.656, 88.732, 1.5022, 100),
+(1264000, 9, 3124.108, 554.401, 89.366, 1.6436, 100),
+(1264000, 10,3112.344, 567.310, 88.989, 2.3112, 100),
+(1264000, 11,3105.551, 601.957, 76.657, 1.5651, 100),
+(1264000, 12,3120.267, 631.088, 75.817, 1.0389, 100),
+(1264000, 13,3145.446, 657.818, 76.254, 0.8150, 100),
+(1264000, 14,3172.876, 676.411, 81.777, 0.6108, 100),
+(1264000, 15,3214.683, 691.091, 92.328, 0.3399, 100),
+(1264000, 16,3172.876, 676.411, 81.777, 0.6108, 100),
+(1264000, 17,3145.446, 657.818, 76.254, 0.8150, 100),
+(1264000, 18,3120.267, 631.088, 75.817, 1.0389, 100),
+(1264000, 19,3105.551, 601.957, 76.657, 1.5651, 100),
+(1264000, 20,3112.344, 567.310, 88.989, 2.3112, 100),
+(1264000, 21,3124.108, 554.401, 89.366, 1.6436, 100),
+(1264000, 22,3126.805, 516.656, 88.732, 1.5022, 100),
+(1264000, 23,3123.917, 476.544, 84.755, 2.3112, 100),
+(1264000, 24,3150.509, 448.767, 74.152, 5.4763, 100),
+(1264000, 25,3121.065, 479.498, 85.652, 4.6085, 100),
+(1264000, 26,3124.773, 514.301, 88.815, 5.0247, 100),
+(1264000, 27,3113.553, 547.966, 89.451, 5.0090, 100),
+(1264000, 28,3105.188, 574.659, 84.079, 4.7302, 100),
+(1264000, 29,3105.902, 624.807, 77.330, 1.0742, 100),
+(1264160, 1, 3116.570, 545.821, 89.641, 2.33874, 100),
+(1264160, 2, 3107.309, 567.170, 88.081, 1.96174, 100),
+(1264160, 3, 3100.440, 583.835, 80.126, 1.96174, 100),
+(1264160, 4, 3107.502, 609.043, 75.329, 1.29111, 100),
+(1264160, 5, 3139.049, 641.823, 74.297, 0.81201, 100),
+(1264160, 6, 3169.191, 674.250, 80.787, 0.82772, 100),
+(1264160, 7, 3190.718, 691.628, 89.769, 0.61174, 100),
+(1264160, 8, 3217.072, 686.743, 91.574, 6.09775, 100),
+(1264160, 9, 3251.472, 680.290, 90.060, 6.09775, 100),
+(1264160, 10,3280.618, 680.097, 89.147, 6.27445, 100),
+(1264160, 11,3314.501, 656.239, 83.067, 5.66970, 100),
+(1264160, 12,3338.522, 626.918, 82.767, 5.39874, 100),
+(1264160, 13,3372.639, 598.328, 86.184, 5.28485, 100),
+(1264160, 14,3395.046, 570.734, 89.737, 5.17490, 100),
+(1264160, 15,3381.180, 541.152, 96.536, 4.47196, 100),
+(1264160, 16,3380.853, 495.767, 94.225, 4.66046, 100),
+(1264160, 17,3381.180, 541.152, 96.536, 4.47196, 100),
+(1264160, 18,3395.046, 570.734, 89.737, 5.17490, 100),
+(1264160, 19,3372.639, 598.328, 86.184, 5.28485, 100),
+(1264160, 20,3338.522, 626.918, 82.767, 5.39874, 100),
+(1264160, 21,3314.501, 656.239, 83.067, 5.66970, 100),
+(1264160, 22,3280.618, 680.097, 89.147, 6.27445, 100),
+(1264160, 23,3251.472, 680.290, 90.060, 6.09775, 100),
+(1264160, 24,3217.072, 686.743, 91.574, 6.09775, 100),
+(1264160, 25,3190.718, 691.628, 89.769, 0.61174, 100),
+(1264160, 26,3169.191, 674.250, 80.787, 0.82772, 100),
+(1264160, 27,3139.049, 641.823, 74.297, 0.81201, 100),
+(1264160, 28,3107.502, 609.043, 75.329, 1.29111, 100),
+(1264160, 29,3100.440, 583.835, 80.126, 1.96174, 100),
+(1264160, 30,3107.309, 567.170, 88.081, 1.96174, 100),
+(1264160, 31,3116.570, 545.821, 89.641, 2.33874, 100);
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (30882, 31539);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(30882, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, "58547"),
+(31539, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, "58547");
+
+DELETE FROM `creature_addon` WHERE `guid` IN (126400, 126416, 126419, 126397, 126420);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `visibilityDistanceType`, `auras`) VALUES
+(126400, 1264000, 0, 0, 0, 0, 0, 1, 0, 0, 3, ""),
+(126416, 1264160, 0, 0, 0, 0, 0, 1, 0, 0, 3, ""),
+(126419, 1264190, 0, 0, 0, 0, 0, 1, 0, 0, 3, ""),
+(126397, 1263970, 0, 0, 0, 0, 0, 1, 0, 0, 3, ""),
+(126420, 1264200, 0, 0, 0, 0, 0, 1, 0, 0, 3, "");
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=126396;
+
+DELETE FROM `creature_formations` WHERE `leaderGUID` IN (126400, 126416, 126419, 126397, 126420);
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`, `point_1`, `point_2`) VALUES
+(126400, 126400, 0, 0, 515, 0, 0),
+(126400, 126406, 10, 90, 515, 2, 7),
+(126400, 126412, 15, 0, 515, 2, 7),
+(126400, 126405, 10, 270, 515, 2, 7),
+(126397, 126397, 0, 0, 515, 0, 0),
+(126397, 126408, 10, 90, 515, 2, 7),
+(126397, 126401, 15, 0, 515, 2, 7),
+(126397, 126407, 10, 270, 515, 2, 7),
+(126416, 126416, 0, 0, 515, 0, 0),
+(126416, 126417, 15, 0, 515, 0, 0),
+(126419, 126419, 0, 0, 515, 0, 0),
+(126419, 126418, 15, 0, 515, 0, 0),
+(126420, 126420, 0, 0, 515, 0, 0),
+(126420, 126421, 15, 0, 515, 0, 0);