From 3c5b5f56f01b058142ef8c71ddbc60b562ff85d3 Mon Sep 17 00:00:00 2001 From: tkrokli Date: Thu, 4 Aug 2016 18:13:55 +0200 Subject: Core/Scripts: remove #define text in pyrewood_ambush - remove #define text from script - move say text to DB table creature_text - add enum names and values - move values in code to enum --- sql/updates/world/3.3.5/2016_08_04_04_world_335.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_08_04_04_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_08_04_04_world_335.sql b/sql/updates/world/3.3.5/2016_08_04_04_world_335.sql new file mode 100644 index 00000000000..c675a4e2ee5 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_08_04_04_world_335.sql @@ -0,0 +1,7 @@ +-- NPC ID 2058 Deathstalker Faerleia, Quest ID 452 'Pyrewood Ambush' +SET @Faerleia := 2058; + +DELETE FROM `creature_text` WHERE `entry` = @Faerleia; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(@Faerleia,0,0,'Be ready, $n. I hear the council returning. Prepare to ambush!',12,0,100,0,0,0,542,0,'Deathstalker Faerleia - SAY_PREPARE_TO_AMBUSH'), +(@Faerleia,1,0,'Well done. A blow to Arugal no doubt!', 12,0,100,0,0,0,545,0,'Deathstalker Faerleia - SAY_A_BLOW_TO_ARUGAL'); -- cgit v1.2.3