aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorDr-J <daniel.jarrott0@gmail.com>2014-08-19 11:57:03 +0100
committerDr-J <daniel.jarrott0@gmail.com>2014-08-19 11:57:03 +0100
commit803d0c3b168bacc7c5a2c09d3c1bf6c7e9227056 (patch)
treecd8b6e119143b1a0c1d37804f39d454c552b3efd /sql
parentd15bbc63de8aca43262917966bf9c1c8651cb497 (diff)
DB/Misc:Missing Emotes
Add missing emotes for Image of Loken and High Abbot Landgren for quest scripts,
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_08_19_00_world_misc.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2014_08_19_00_world_misc.sql b/sql/updates/world/2014_08_19_00_world_misc.sql
new file mode 100644
index 00000000000..49d8f11fbdb
--- /dev/null
+++ b/sql/updates/world/2014_08_19_00_world_misc.sql
@@ -0,0 +1,9 @@
+UPDATE `creature_text` SET `emote`=51 WHERE `entry`=27212;
+UPDATE `creature_text` SET `emote`=1 WHERE `entry`=27439 AND `groupid`=0 AND `id`=0;
+UPDATE `creature_text` SET `emote`=6 WHERE `entry`=27439 AND `groupid`=1 AND `id`=0;
+UPDATE `creature_text` SET `emote`=1 WHERE `entry`=27439 AND `groupid`=2 AND `id`=0;
+UPDATE `creature_text` SET `emote`=25 WHERE `entry`=27439 AND `groupid`=3 AND `id`=0;
+UPDATE `creature_text` SET `emote`=274 WHERE `entry`=27439 AND `groupid`=4 AND `id`=0;
+UPDATE `creature_text` SET `sound`=2943 WHERE `entry`=27439 AND `groupid`=5 AND `id`=0;
+
+UPDATE `smart_scripts` SET `event_param1`=30 WHERE `entryorguid`=17831 AND `source_type`=0 AND `id`=4 AND `link`=5;