diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2015-09-22 14:56:45 +0100 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2015-10-30 14:51:51 +0100 |
| commit | d26bc41a3e4887df7abb21ff2133cf144b08df8b (patch) | |
| tree | f57a4246ce5a0bed4b51b12efe7b1bf9f02febaf | |
| parent | 26d362febc197d42a4b0cc175fa7a11f8acc81c5 (diff) | |
DB/Misc: Additional texts
(cherry picked from commit b151e369686f2e3de63ba460ccaf2173c9a6a104)
| -rw-r--r-- | sql/updates/world/2015_10_30_31_world_2015_09_22_00.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2015_10_30_31_world_2015_09_22_00.sql b/sql/updates/world/2015_10_30_31_world_2015_09_22_00.sql new file mode 100644 index 00000000000..821e9ea3856 --- /dev/null +++ b/sql/updates/world/2015_10_30_31_world_2015_09_22_00.sql @@ -0,0 +1,10 @@ +DELETE FROM `creature_text` WHERE `entry` =23257 and `groupid`=0 and `id` in(7,8,9); +DELETE FROM `creature_text` WHERE `entry` =22982 and `groupid`=0 and `id` in(5,6); + +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES + +(23257, 0, 7, 'Well one thing''s for sure, $n''s not a nugget any more!', 12, 0, 100, 0, 0, 0, 21896, 0, 'Skyguard Windcharger'), +(23257, 0, 8, 'Buzz the landing pad lately, $n?', 12, 0, 100, 0, 0, 0, 21889, 0, 'Skyguard Windcharger'), +(23257, 0, 9, 'The list of Skyguard members is long and distinguished. $n tops that list.', 12, 0, 100, 0, 0, 0, 21939, 0, 'Skyguard Windcharger'), +(22982, 0, 5, 'Well, if it isn''t our resident $g flyboy : flygirl;, $n. How''s it going, ace?', 12, 0, 100, 0, 0, 0, 21898, 0, 'Skyguard Navigator'), +(22982, 0, 6, 'Hey, it''s our ace flyer, $n!', 12, 0, 100, 0, 0, 0, 21883, 0, 'Skyguard Navigator'); |