From 8cec401f0c4c61bb69fc6353bc13e0b2c4582130 Mon Sep 17 00:00:00 2001 From: Discover- Date: Sun, 25 Dec 2011 00:29:15 +0100 Subject: Core/Scripts: Script quest Nat's Bargain. Closes #3140. --- sql/updates/world/2011_12_24_00_world_misc.sql | 10 ++++++++++ sql/updates/world/2011_12_24_00_world_sai.sql | 10 ---------- .../world/2011_12_25_00_world_areatrigger_scriptnames.sql | 3 +++ 3 files changed, 13 insertions(+), 10 deletions(-) create mode 100644 sql/updates/world/2011_12_24_00_world_misc.sql delete mode 100644 sql/updates/world/2011_12_24_00_world_sai.sql create mode 100644 sql/updates/world/2011_12_25_00_world_areatrigger_scriptnames.sql (limited to 'sql') diff --git a/sql/updates/world/2011_12_24_00_world_misc.sql b/sql/updates/world/2011_12_24_00_world_misc.sql new file mode 100644 index 00000000000..fb5816bb737 --- /dev/null +++ b/sql/updates/world/2011_12_24_00_world_misc.sql @@ -0,0 +1,10 @@ +-- Scriptname for the cages +UPDATE `gameobject_template` SET `ScriptName`='go_veil_skith_cage' WHERE `entry` IN (185202,185203,185204,185205); + +-- Texts for Captive Child +DELETE FROM `creature_text` WHERE `entry`=22314; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(22314,0,0,"Woot!",12,0,100,0,0,0,"Captive Child"), +(22314,0,1,"I think those weird bird guys were going to eat us. Gross!",12,0,100,0,0,0,"Captive Child"), +(22314,0,2,"Yay! We're free!",12,0,100,0,0,0,"Captive Child"), +(22314,0,3,"Gross!",12,0,100,0,0,0,"Captive Child"); \ No newline at end of file diff --git a/sql/updates/world/2011_12_24_00_world_sai.sql b/sql/updates/world/2011_12_24_00_world_sai.sql deleted file mode 100644 index fb5816bb737..00000000000 --- a/sql/updates/world/2011_12_24_00_world_sai.sql +++ /dev/null @@ -1,10 +0,0 @@ --- Scriptname for the cages -UPDATE `gameobject_template` SET `ScriptName`='go_veil_skith_cage' WHERE `entry` IN (185202,185203,185204,185205); - --- Texts for Captive Child -DELETE FROM `creature_text` WHERE `entry`=22314; -INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES -(22314,0,0,"Woot!",12,0,100,0,0,0,"Captive Child"), -(22314,0,1,"I think those weird bird guys were going to eat us. Gross!",12,0,100,0,0,0,"Captive Child"), -(22314,0,2,"Yay! We're free!",12,0,100,0,0,0,"Captive Child"), -(22314,0,3,"Gross!",12,0,100,0,0,0,"Captive Child"); \ No newline at end of file diff --git a/sql/updates/world/2011_12_25_00_world_areatrigger_scriptnames.sql b/sql/updates/world/2011_12_25_00_world_areatrigger_scriptnames.sql new file mode 100644 index 00000000000..4a66326ead5 --- /dev/null +++ b/sql/updates/world/2011_12_25_00_world_areatrigger_scriptnames.sql @@ -0,0 +1,3 @@ +DELETE FROM `areatrigger_scripts` WHERE `entry`=4752; +INSERT INTO `areatrigger_scripts` (`entry`,`ScriptName`) VALUES +(4752,'at_nats_landing'); \ No newline at end of file -- cgit v1.2.3