Gnomeregan: Implemented Blastmaster Emi Shortfuse Event.

--HG--
branch : trunk

3 files changed, 55 insertions, 0 deletions

diff --git a/sql/updates/7033_world_script_texts.sql b/sql/updates/7033_world_script_texts.sql
new file mode 100644
index 00000000000..efb88bde319
--- /dev/null
+++ b/sql/updates/7033_world_script_texts.sql
@@ -0,0 +1,33 @@
+DELETE FROM `script_texts` WHERE `npc_entry` IN (7998,7361);
+DELETE FROM `script_texts` WHERE `entry` IN (-1090001,-1090002,-1090003,-1090004,-1090005,-1090006,-1090007,-1090008,-1090009,-1090010,-1090011,-1090012,-1090013,-1090014,-1090015,-1090016,-1090017,-1090018,-1090019,-1090020,-1090021,-1090022,-1090023,-1090024,-1090025,-1090026,-1090027,-1090028);
+INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES
+   (7998,-1090000,'With your help, I can evaluate these tunnels.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090001,'Let''s see if we can find out where these Troggs are coming from... and put a stop to the invasion!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090002,'Such devastation... what horrible mess...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090003,'It''s quiet here...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090004,'...too quiet.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090005,'Look! Over there at the tunnel wall!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090006,'Trogg incrusion! Defend me while i blast the hole closed!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090007,'The charges are set. Get back before they blow!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090008,'Incoming blast in 10 seconds!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''),
+   (7998,-1090009,'Incoming blast in 5 seconds. Clear the tunnel!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''),
+   (7998,-1090010,'FIRE IN THE HOLE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''),
+   (7998,-1090011,'Well done! Without your help I would have never been able to thwart that wave of troggs.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090012,'Did you hear something?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090013,'I heard something over there.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090014,'More troggs! Ward them off as I prepare the explosives!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090015,'The final charge is set. Stand back!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''),
+   (7998,-1090016,'The final charge is set. Stand back!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090017,'Incoming blast in 10 seconds!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''),
+   (7998,-1090018,'Incoming blast in 5 seconds. Clear the tunnel!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''),
+   (7998,-1090019,'I don''t think one charge is going to cut it. Keep fending them off!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090020,'FIRE IN THE HOLE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''),
+   (7998,-1090021,'Well done! Without your help I would have never been able to thwart that wave of troggs.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090022,'Did you hear something?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090023,'I heard something over there.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090024,'More troggs! Ward them off as I prepare the explosives!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090025,'The final charge is set. Stand back!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''),
+   (7998,-1090026,'10 seconds to blast! Stand back!!!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''),
+   (7998,-1090027,'5 seconds until detonation!!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''),
+   (7361,-1090028,'We come from below! You can never stop us!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'');
+
diff --git a/sql/updates/7033_world_script_waypoints.sql b/sql/updates/7033_world_script_waypoints.sql
new file mode 100644
index 00000000000..5da669458cf
--- /dev/null
+++ b/sql/updates/7033_world_script_waypoints.sql
@@ -0,0 +1,18 @@
+DELETE FROM `script_waypoint` WHERE `entry`=7998;
+INSERT INTO `script_waypoint` VALUES
+    (7998,1,-511.065,-134.51,-152.493,0,''),
+    (7998,2,-511.862,-131.76,-152.932,0,''),
+    (7998,3,-513.319,-126.733,-156.095,0,''),
+    (7998,4,-515.969,-118.962,-156.109,0,''),
+    (7998,5,-518.983,-111.608,-155.923,0,''),
+    (7998,6,-522.392,-101.145,-155.228,0,''),
+    (7998,7,-523.941,-96.9487,-154.823,0,''),
+    (7998,8,-531.938,-104.249,-156.031,0,''),
+    (7998,9,-533.141,-105.332,-156.017,30000,''),
+    (7998,10,-541.3,-96.7414,-155.895,30000,''),
+    (7998,11,-517.556,-106.826,-155.149,0,''),
+    (7998,12,-508.757,-103.227,-151.742,30000,''),
+    (7998,13,-512.396,-86.3113,-151.642,30000,''),
+    (7998,14,-520.928,-117.679,-156.119,0,''),
+    (7998,15,-521.717,-119.564,-156.114,0,'');
+
diff --git a/sql/updates/7033_world_scriptname.sql b/sql/updates/7033_world_scriptname.sql
new file mode 100644
index 00000000000..27c83c0bdfa
--- /dev/null
+++ b/sql/updates/7033_world_scriptname.sql
@@ -0,0 +1,4 @@
+UPDATE `creature_template` SET `ScriptName`='npc_blastmaster_emi_shortfuse' WHERE `entry`=7998;
+UPDATE `creature_template` SET `ScriptName`='boss_grubbis' WHERE `entry`=7361;
+UPDATE `instance_template` SET `script`='instance_gnomeregan' WHERE `map`=90;
+