DB/Creature: Add script to Field Marshal Rohamus

1 files changed, 16 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2021_08_10_02_world.sql b/sql/updates/world/3.3.5/2021_08_10_02_world.sql
new file mode 100644
index 00000000000..1c5cf60cb39
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_08_10_02_world.sql
@@ -0,0 +1,16 @@
+--
+UPDATE `creature_template` SET `AIName` = "SmartAI" WHERE `entry` = 19316;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 19316 AND `source_type` = 0;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 1931600 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
+(19316,0,0,0,1,0,100,0,60000,90000,60000,90000,0,80,1931600,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Field Marshal Rohamus - Out of Combat - Run Script"),
+
+(1931600,9,0,0,0,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Field Marshal Rohamus - On Script - Say Line 0"),
+(1931600,9,1,0,0,0,100,0,4000,4000,0,0,0,5,275,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Field Marshal Rohamus - On Script - Play Emote 275");
+
+DELETE FROM `creature_text` WHERE `CreatureID` = 19316;
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(19316,0,0,"Tear it down, soldiers! We're shippin' this thing back to Stormwind!",12,7,100,22,0,0,16576,0,"Field Marshal Rohamus"),
+(19316,0,1,"We're gonna melt this hunk of junk down and make weapons with the ingots! Let's see how the Legion likes a taste of fel reaver served up Alliance style!",12,7,100,22,0,0,16577,0,"Field Marshal Rohamus"),
+(19316,0,2,"Well done, soldiers! We weren't about to let the filthy animals of the Horde show us up!",12,7,100,22,0,0,16578,0,"Field Marshal Rohamus"),
+(19316,0,3,"Let them throw another one of these overgrown tin cans at us! We'll show them what the Alliance is made of!",12,7,100,22,0,0,16579,0,"Field Marshal Rohamus");