aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorSpp <none@none>2010-11-16 11:52:31 +0100
committerSpp <none@none>2010-11-16 11:52:31 +0100
commit3e2c1a416946b8301f5c96b47500724dacc835e9 (patch)
tree681bbe208132bb01a612decdf0b0acddeddab734 /sql/updates
parent0dc3d771e11d650b1a328ef4b2ac49059afc5b85 (diff)
Scripts: Fix quests "...Or Maybe We Don't" and "Smoke 'Em Out"
Author: Lopin Closes issue 4741 --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/10453_world_creature_template.sql6
-rw-r--r--sql/updates/10453_world_script_text.sql9
2 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/10453_world_creature_template.sql b/sql/updates/10453_world_creature_template.sql
new file mode 100644
index 00000000000..1c869eb10ef
--- /dev/null
+++ b/sql/updates/10453_world_creature_template.sql
@@ -0,0 +1,6 @@
+-- Quest ...Or Maybe We Don't (12138, 12198)
+UPDATE `creature_template` SET `ScriptName`='npc_lightning_sentry' WHERE `entry`=26407; -- Lightning Sentry
+
+-- Quest Smoke 'Em Out (12323, 12324)
+UPDATE `creature_template` SET `ScriptName`='npc_venture_co_straggler',`AIName`='' WHERE `entry`=27570;
+
diff --git a/sql/updates/10453_world_script_text.sql b/sql/updates/10453_world_script_text.sql
new file mode 100644
index 00000000000..f107787e051
--- /dev/null
+++ b/sql/updates/10453_world_script_text.sql
@@ -0,0 +1,9 @@
+-- Quest Smoke Em Out
+DELETE FROM `script_texts` WHERE `entry` BETWEEN (-1603539) AND (-1603535);
+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
+ (27570,-1603535,'We\'re all gonna die!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say1'),
+ (27570,-1603536,'Gotta get out of here!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say2'),
+ (27570,-1603537,'No way I\'m stickin\' around!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say3'),
+ (27570,-1603538,'Forget this! I\'m going home!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say4'),
+ (27570,-1603539,'I didn\'t sign up for this!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'Smoke \'Em Out - Say5');
+