diff options
| author | tkrokli <tkrokli@gmail.com> | 2016-08-04 18:13:55 +0200 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2016-08-04 18:13:55 +0200 |
| commit | 3c5b5f56f01b058142ef8c71ddbc60b562ff85d3 (patch) | |
| tree | 455ad6c6bf75c5371af78358dae78b1383a195f7 /sql | |
| parent | 91b2351876bbe13a898dcf5698c7a37cc38e56f5 (diff) | |
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
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2016_08_04_04_world_335.sql | 7 |
1 files changed, 7 insertions, 0 deletions
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'); |