diff options
| -rw-r--r-- | sql/updates/world/master/2024_01_26_05_world.sql | 85 |
1 files changed, 85 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_01_26_05_world.sql b/sql/updates/world/master/2024_01_26_05_world.sql new file mode 100644 index 00000000000..f2910ed5db8 --- /dev/null +++ b/sql/updates/world/master/2024_01_26_05_world.sql @@ -0,0 +1,85 @@ +-- Fix Position for Spitescale Wavethrashers Entry: 38300 +UPDATE `creature` SET `position_x`=-995.6476,`position_y`=-5606.8247,`position_z`=14.584063,`Orientation`=2.827433347702026367 WHERE `guid`=308884; +UPDATE `creature` SET `position_x`=-994.92535,`position_y`=-5628.7446,`position_z`=14.470828,`Orientation`=3.246312379837036132 WHERE `guid`=308896; +UPDATE `creature` SET `position_x`=-1003.1077,`position_y`=-5617.4097,`position_z`=14.496528,`Orientation`=3.368485450744628906 WHERE `guid`=308902; +UPDATE `creature` SET `position_x`=-999.9948,`position_y`=-5612.3213,`position_z`=14.521808,`Orientation`=2.513274192810058593 WHERE `guid`=308877; +UPDATE `creature` SET `position_x`=-996.0868,`position_y`=-5626.1704,`position_z`=14.474115,`Orientation`=3.647738218307495117 WHERE `guid`=308894; +UPDATE `creature` SET `position_x`=-1003.6371,`position_y`=-5623.9395,`position_z`=14.547167,`Orientation`=3.176499128341674804 WHERE `guid`=308900; +UPDATE `creature` SET `position_x`=-966.42883,`position_y`=-5582.4478,`position_z`=14.422509,`Orientation`=2.408554315567016601 WHERE `guid`=308863; +UPDATE `creature` SET `position_x`=-972.7882,`position_y`=-5587.059,`position_z`=13.854784,`Orientation`=3.211405754089355468 WHERE `guid`=308860; +UPDATE `creature` SET `position_x`=-973.91144,`position_y`=-5589.2188,`position_z`=13.238535,`Orientation`=2.30383467674255371 WHERE `guid`=308859; +UPDATE `creature` SET `position_x`=-1004.4757,`position_y`=-5645.514,`position_z`=11.961428,`Orientation`=2.94960641860961914 WHERE `guid`=308856; +UPDATE `creature` SET `position_x`=-998.48956,`position_y`=-5641.9253,`position_z`=9.424361,`Orientation`=2.094395160675048828 WHERE `guid`=308899; +UPDATE `creature` SET `position_x`=-996.5781,`position_y`=-5639.962,`position_z`=9.640905,`Orientation`=2.984513044357299804 WHERE `guid`=308820; +UPDATE `creature` SET `position_x`=-954.8455,`position_y`=-5566.1147,`position_z`=9.606628,`Orientation`=3.630284786224365234 WHERE `guid`=308915; +UPDATE `creature` SET `position_x`=-955.0816,`position_y`=-5569.2397,`position_z`=9.704755,`Orientation`=2.984513044357299804 WHERE `guid`=308917; +UPDATE `creature` SET `position_x`=-953.9549,`position_y`=-5559.3926,`position_z`=9.469525,`Orientation`=2.984513044357299804 WHERE `guid`=308792; +UPDATE `creature` SET `position_x`=-824.23267,`position_y`=-5597.8335,`position_z`=4.8524303,`Orientation`=1.727875947952270507 WHERE `guid`=308796; +UPDATE `creature` SET `position_x`=-832.3177,`position_y`=-5602.9844,`position_z`=4.3836803,`Orientation`=1.727875947952270507 WHERE `guid`=308801; +UPDATE `creature` SET `position_x`=-835.61285,`position_y`=-5605.068,`position_z`=4.0494776,`Orientation`=1.727875947952270507 WHERE `guid`=308799; +UPDATE `creature` SET `position_x`=-837.8542,`position_y`=-5604.4375,`position_z`=3.7979403,`Orientation`=1.082104086875915527 WHERE `guid`=308803; +UPDATE `creature` SET `position_x`=-840.42706,`position_y`=-5592.9097,`position_z`=3.3593752,`Orientation`=1.553343057632446289 WHERE `guid`=308804; +UPDATE `creature` SET `position_x`=-844.69794,`position_y`=-5601.1963,`position_z`=3.0868053,`Orientation`=2.426007747650146484 WHERE `guid`=308808; +UPDATE `creature` SET `position_x`=-844.4722,`position_y`=-5610.481,`position_z`=2.8246522,`Orientation`=2.426007747650146484 WHERE `guid`=308810; +UPDATE `creature` SET `position_x`=-846.6597,`position_y`=-5612.182,`position_z`=2.4427083,`Orientation`=1.675516128540039062 WHERE `guid`=308811; +UPDATE `creature` SET `position_x`=-854.9393,`position_y`=-5607.1772,`position_z`=1.2413194,`Orientation`=2.426007747650146484 WHERE `guid`=308812; +-- Fix Position for Spitescale Siren Entry: 38301 +UPDATE `creature` SET `Orientation`=2.967059612274169921 WHERE `guid`=308818; +UPDATE `creature` SET `Orientation`=2.879793167114257812 WHERE `guid`=308819; +UPDATE `creature` SET `Orientation`=3.03687286376953125 WHERE `guid`=308892; +UPDATE `creature` SET `Orientation`=2.253309965133666992 WHERE `guid`=308802; +-- Fix Position for Darkspear Tribesman Entry: 38324 +UPDATE `creature` SET `position_x`=-975.9983,`position_y`=-5586.847,`position_z`=14.290344,`Orientation`=6.19591856 WHERE `guid`=308885; +UPDATE `creature` SET `position_x`=-998.59204,`position_y`=-5627.818,`position_z`=14.372595,`Orientation`=0.139626339 WHERE `guid`=308871; +UPDATE `creature` SET `position_x`=-1002.6111,`position_y`=-5610.7466,`position_z`=14.497152,`Orientation`=5.934119 WHERE `guid`=308878; +UPDATE `creature` SET `position_x`=-1007.4861,`position_y`=-5624.3003,`position_z`=14.585213,`Orientation`=0.314159 WHERE `guid`=308879; +UPDATE `creature` SET `position_x`=-1006.4566,`position_y`=-5618.1616,`position_z`=14.413295,`Orientation`=0.226892799 WHERE `guid`=308881; +UPDATE `creature` SET `position_x`=-998.0903,`position_y`=-5606.632,`position_z`=14.558871,`Orientation`=6.0737457 WHERE `guid`=308887; +UPDATE `creature` SET `position_x`=-1007.3802,`position_y`=-5645.1406,`position_z`=12.641352,`Orientation`=6.178465 WHERE `guid`=308846; +UPDATE `creature` SET `position_x`=-968.6094,`position_y`=-5580.4062,`position_z`=14.349838,`Orientation`=5.4279737 WHERE `guid`=308891; +UPDATE `creature` SET `position_x`=-958.1024,`position_y`=-5567.6025,`position_z`=9.812927,`Orientation`=0.17453292 WHERE `guid`=308816; +UPDATE `creature` SET `position_x`=-956.49133,`position_y`=-5558.7017,`position_z`=9.477974,`Orientation`=5.934119 WHERE `guid`=308817; +UPDATE `creature` SET `position_x`=-839.8924,`position_y`=-5589.4673,`position_z`=3.2795143,`Orientation`=5.0090947 WHERE `guid`=308794; +UPDATE `creature` SET `position_x`=-824.2808,`position_y`=-5594.203,`position_z`=4.340988,`Orientation`=4.7255187 WHERE `guid`=308786; +UPDATE `creature` SET `position_x`=-846.1632,`position_y`=-5598.057,`position_z`=2.9513893,`Orientation`=5.23598766 WHERE `guid`=308795; +UPDATE `creature` SET `position_x`=-846.65625,`position_y`=-5608.2603,`position_z`=2.4997964,`Orientation`=5.585053 WHERE `guid`=308789; +UPDATE `creature` SET `position_x`=-833.03644,`position_y`=-5599.358,`position_z`=4.090036,`Orientation`=4.7996554 WHERE `guid`=308791; +UPDATE `creature` SET `position_x`=-836.0781,`position_y`=-5602.0728,`position_z`=3.8821564,`Orientation`=4.956735 WHERE `guid`=308788; + +-- Add emotestate to Darkspear Tribesman and Shaman +DELETE FROM `creature_template_addon` WHERE `entry` IN (38324,38326); +INSERT INTO `creature_template_addon` (`entry`,`PathId`,`mount`,`StandState`,`SheathState`,`emote`,`visibilityDistanceType`,`auras`) VALUES +(38324,0,0,0,1,333,0, ''), +(38326,0,0,0,1,425,0, ''); + +-- Add to sparring template +DELETE FROM `creature_template_sparring` WHERE `Entry` IN (38324,38326,38300,38301); +INSERT INTO `creature_template_sparring` (`Entry`,`NoNPCDamageBelowHealthPct`) VALUES +(38324,85), -- Darkspear Tribesman +(38326,85), -- Darkspear Shaman +(38300,85), -- Spitescale Wavethrasher +(38301,85); -- Spitescale Siren + +-- Darkspear Shaman SAI +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=38326; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (38326) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(38326,0,0,0,0,0,100,0,0,0,3000,3000,0,11,73212,0,0,0,0,0,25,40,0,0,0,0,0,0,0,'Darkspear Shaman - In Combat - Cast "Lightning Bolt"'); + +-- Spitescale Wavethrasher SAI +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=38300; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (38300) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(38300,0,0,0,1,0,100,1,1000,1000,1000,1000,0,49,0,0,0,0,0,0,25,40,0,0,0,0,0,0,0,'Darkspear Wavethrasher - OOC - Attack closest enemy "Once"'); + +-- Spitescale Siren SAI +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=38301; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (38301) 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(38301,0,0,0,1,0,100,1,1000,1000,1000,1000,0,49,0,0,0,0,0,0,25,40,0,0,0,0,0,0,0,'Darkspear Siren - OOC - Attack closest enemy "Once"'), +(38301,0,1,0,0,0,100,0,0,0,3000,3000,0,11,32011,64,0,0,0,0,25,40,0,0,0,0,0,0,0,'Darkspear Siren - In Combat - Cast "Water Bolt"'); + +-- Update creature movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (38326); +INSERT INTO `creature_template_movement` (`CreatureId`,`Ground`,`Swim`,`Flight`,`Rooted`,`Chase`,`Random`,`InteractionPauseTimer`) VALUES +(38326,1,1,0,1,0,0,0); -- Darkspear Shaman |