aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorSnapperRy <snapperryen@gmail.com>2016-10-03 23:47:41 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2017-03-05 01:06:44 +0100
commit30153510e804c6fd05439e8920605185874b3453 (patch)
tree07b5f53e8e1f5c6e13ecc181446d26c0aa456c3c /sql
parent8c7b3c8a2bd4cc8ab07213c07d0e9527ed77b4f2 (diff)
Script/Quest: A Cry For Help: (#18026)
- Add missing dialogue from Cowlen. - Timers and emotes. (cherry picked from commit 790844e72d40cd2c99a3a235a7186173af575417) Rename two SQL files. (cherry picked from commit 283aec96560f66a72b4d563eefbccdbee2de10ea)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2017_03_04_32_world_2016_10_03_04_world.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_03_04_32_world_2016_10_03_04_world.sql b/sql/updates/world/master/2017_03_04_32_world_2016_10_03_04_world.sql
new file mode 100644
index 00000000000..f0718ebe6ea
--- /dev/null
+++ b/sql/updates/world/master/2017_03_04_32_world_2016_10_03_04_world.sql
@@ -0,0 +1,12 @@
+--
+UPDATE `creature_text` SET `language`=7, `BroadcastTextid`=13770 WHERE `entry`=17312 AND `groupid`=1;
+UPDATE `creature_text` SET `emote`=5 WHERE `entry`=17312 AND `groupid`=2;
+UPDATE `creature_text` SET `emote`=22 WHERE `entry`=17312 AND `groupid`=3;
+UPDATE `creature_text` SET `emote`=5 WHERE `entry`=17312 AND `groupid`=4;
+
+DELETE FROM `creature_text` WHERE `entry`=17311;
+INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(17311, 0, 0, "Daughter!", 12, 7, 100, 0, 0, 0, 13749, 0, "Cowlen");
+
+UPDATE `script_waypoint` SET `waittime`=3000 WHERE `entry`=17312 AND `pointid`=28;
+UPDATE `script_waypoint` SET `waittime`=5000 WHERE `entry`=17312 AND `pointid`=29;