diff options
| -rw-r--r-- | sql/updates/world/master/2022_03_01_18_world_2020_11_28_02_world.sql | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_01_18_world_2020_11_28_02_world.sql b/sql/updates/world/master/2022_03_01_18_world_2020_11_28_02_world.sql new file mode 100644 index 00000000000..fbebc65ac29 --- /dev/null +++ b/sql/updates/world/master/2022_03_01_18_world_2020_11_28_02_world.sql @@ -0,0 +1,48 @@ +-- Prowling Worg SAI (Source: Sniffs) +SET @ID := 24206; +UPDATE `creature_template` SET `speed_walk` = 1.2, `speed_run` = 1, `AIName` = "SmartAI" WHERE `entry` = @ID; +DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID 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 +(@ID,0,0,0,54,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Prowling Worg - On Just Summoned - Say Line 0"); + +DELETE FROM `creature_text` WHERE `CreatureID` = @ID; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(@ID,0,0,"A %s appears to defend its dinner.",16,0,100,0,0,0,22935,0,"Prowling Worg"); + +-- Iron Rune Sentinel SAI (Source: Sniffs(timers guessed)) +SET @ID := 24316; +UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = @ID; +DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID 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 +(@ID,0,0,1,0,0,100,0,5000,15000,25000,35000,0,11,48416,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Iron Rune Sentinel - In Combat - Cast 'Rune Detonation'"), +(@ID,0,1,0,61,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Iron Rune Sentinel - On Link - Say Line 0"); + +DELETE FROM `creature_text` WHERE `CreatureID` = @ID; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(@ID,0,0,"A rune on %s begins to glow brightly!",16,0,100,0,0,0,26406,0,"Iron Rune Sentinel"); + +-- Prospector Belvar SAI (Source: Sniffs) +SET @ID := 24328; +UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = @ID; +DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID AND `source_type` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` = @ID*100+0 AND `source_type` = 9; +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 +(@ID,0,0,0,19,0,100,0,11349,0,0,0,0,80,2432800,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Prospector Belvar - On Quest 'Mastering the Runes' Taken - Run Script"), + +(@ID*100+0,9,0,0,0,0,100,0,0,0,0,0,0,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0,2.530727386474609375,"Prospector Belvar - On Script - Set Orientation"), +(@ID*100+0,9,1,0,0,0,100,0,2000,2000,0,0,0,1,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,"Prospector Belvar - On Script - Say Line 0"), +(@ID*100+0,9,2,0,0,0,100,0,5000,5000,0,0,0,66,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Prospector Belvar - On Script - Set Orientation Home Position"); + +DELETE FROM `creature_text` WHERE `CreatureID` = @ID; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(@ID,0,0,"They keep their tools in boxes that look like this. Look for them near the pavilions.",12,0,100,25,0,0,23552,0,"Prospector Belvar"); + +-- Iron Colossus - missing emote +UPDATE `smart_scripts` SET `link` = 1 WHERE `entryorguid` = 30300 AND `source_type` = 0 AND `id` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 30300 AND `source_type` = 0 AND `id` = 1; +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 +(30300,0,1,0,61,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Iron Colossus - On Link - Say Line 0"); + +DELETE FROM `creature_text` WHERE `CreatureID` = 30300; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(30300,0,0,"The %s prepares to slam the ground in front of him!",41,0,100,0,0,0,33086,0,"Iron Colossus"); |