From 4dfad921869915ddc7ebc1ae06493369aa9f61c8 Mon Sep 17 00:00:00 2001 From: malcrom Date: Sun, 8 Jan 2012 15:16:27 +0100 Subject: DB/text: add creature_text data for Orgrimmar Zappelin Masters from sniff closes #4630 --- sql/updates/world/2011_01_08_12_world_creature_text.sql | 6 ------ sql/updates/world/2012_01_08_12_world_creature_text.sql | 6 ++++++ sql/updates/world/2012_01_08_13_world_creature_text.sql | 7 +++++++ 3 files changed, 13 insertions(+), 6 deletions(-) delete mode 100644 sql/updates/world/2011_01_08_12_world_creature_text.sql create mode 100644 sql/updates/world/2012_01_08_12_world_creature_text.sql create mode 100644 sql/updates/world/2012_01_08_13_world_creature_text.sql (limited to 'sql') diff --git a/sql/updates/world/2011_01_08_12_world_creature_text.sql b/sql/updates/world/2011_01_08_12_world_creature_text.sql deleted file mode 100644 index a2795b906ef..00000000000 --- a/sql/updates/world/2011_01_08_12_world_creature_text.sql +++ /dev/null @@ -1,6 +0,0 @@ --- Twilight Corrupter say text -DELETE FROM `creature_text` WHERE `entry` IN (15625); -INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES -(15625,0,0, 'Come, $N. See what the Nightmare brings...',14,0,100,0,0,0, 'Twilight Corrupter'), -(15625,1,0, 'The Nightmare cannot be stopped!',14,0,100,0,0,0, 'Twilight Corrupter'), -(15625,2,0, 'Twilight Corrupter squeezes the last bit of life out of $N and swallows their soul.',16,0,100,0,0,0, 'Twilight Corrupter'); diff --git a/sql/updates/world/2012_01_08_12_world_creature_text.sql b/sql/updates/world/2012_01_08_12_world_creature_text.sql new file mode 100644 index 00000000000..a2795b906ef --- /dev/null +++ b/sql/updates/world/2012_01_08_12_world_creature_text.sql @@ -0,0 +1,6 @@ +-- Twilight Corrupter say text +DELETE FROM `creature_text` WHERE `entry` IN (15625); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(15625,0,0, 'Come, $N. See what the Nightmare brings...',14,0,100,0,0,0, 'Twilight Corrupter'), +(15625,1,0, 'The Nightmare cannot be stopped!',14,0,100,0,0,0, 'Twilight Corrupter'), +(15625,2,0, 'Twilight Corrupter squeezes the last bit of life out of $N and swallows their soul.',16,0,100,0,0,0, 'Twilight Corrupter'); diff --git a/sql/updates/world/2012_01_08_13_world_creature_text.sql b/sql/updates/world/2012_01_08_13_world_creature_text.sql new file mode 100644 index 00000000000..454bd9ae9c3 --- /dev/null +++ b/sql/updates/world/2012_01_08_13_world_creature_text.sql @@ -0,0 +1,7 @@ +-- NPC talk text insert from sniff "Orgrimmar Zeppelin Masters" +DELETE FROM `creature_text` WHERE `entry` IN (12136,26537,9564,34765) AND `groupid` IN (0); +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(12136,0,0, 'The zeppelin to Grom''gol has just arrived! All aboard for Stranglethorn!',14,0,100,0,0,0, 'Snurk Bucksquick'), +(26537,0,0, 'The zeppelin to Warsong Hold has just arrived! All aboard for Borean Tundra!',14,0,100,0,0,0, 'Greeb Ramrocket'), +(9564,0,0, 'The zeppelin to Undercity has just arrived! All aboard for Tirisfal Glades!',14,0,100,0,0,0, 'Frezza'), +(34765,0,0, 'The zeppelin to Thunder Bluff has arrived! All aboard for a smooth ride across the Barrens!',14,0,100,0,0,0, 'Zelli Hotnozzle'); -- cgit v1.2.3