DB/SAI: Add or update few scripts

(cherry picked from commit 232018800c79913af3eae59a03858291a68547bc)

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");