diff options
| -rw-r--r-- | sql/updates/world/2015_06_06_08_world.sql | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/sql/updates/world/2015_06_06_08_world.sql b/sql/updates/world/2015_06_06_08_world.sql new file mode 100644 index 00000000000..6e11c906871 --- /dev/null +++ b/sql/updates/world/2015_06_06_08_world.sql @@ -0,0 +1,40 @@ +-- +UPDATE `creature_text` SET `BroadcastTextId`=10537 WHERE `entry`= 14875 AND `groupid`= 1 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=10601 WHERE `entry`= 11380 AND `groupid`= 0 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=16206 WHERE `entry`= 19172 AND `groupid`= 0 AND `id`= 2; +UPDATE `creature_text` SET `BroadcastTextId`=16211 WHERE `entry`= 19177 AND `groupid`= 0 AND `id`= 2; +UPDATE `creature_text` SET `BroadcastTextId`=16463 WHERE `entry`= 20102 AND `groupid`= 8 AND `id`= 2; +UPDATE `creature_text` SET `BroadcastTextId`=23175 WHERE `entry`= 23863 AND `groupid`= 2 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=23176 WHERE `entry`= 23863 AND `groupid`= 3 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=23177 WHERE `entry`= 23863 AND `groupid`= 4 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=23178 WHERE `entry`= 23863 AND `groupid`= 5 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=23179 WHERE `entry`= 23863 AND `groupid`= 6 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=23181 WHERE `entry`= 23863 AND `groupid`= 8 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=23182 WHERE `entry`= 23863 AND `groupid`= 8 AND `id`= 1; +UPDATE `creature_text` SET `BroadcastTextId`=23183 WHERE `entry`= 23863 AND `groupid`= 9 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=24340 WHERE `entry`= 19173 AND `groupid`= 8 AND `id`= 4; +UPDATE `creature_text` SET `BroadcastTextId`=24351 WHERE `entry`= 19148 AND `groupid`= 0 AND `id`= 2; +UPDATE `creature_text` SET `BroadcastTextId`=28844 WHERE `entry`= 29 AND `groupid`= 1 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=29304 WHERE `entry`= 22515 AND `groupid`= 6 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=29305 WHERE `entry`= 22515 AND `groupid`= 7 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=29306 WHERE `entry`= 22515 AND `groupid`= 8 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=29307 WHERE `entry`= 22515 AND `groupid`= 9 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=29308 WHERE `entry`= 22515 AND `groupid`= 10 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=37650, `Sound`=17073 WHERE `entry`= 37893 AND `groupid`= 0 AND `id`= 0; +UPDATE `creature_text` SET `text`="The Devourer awaits...", `BroadcastTextId`=38487 WHERE `entry`= 36497 AND `groupid`= 2 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=6198 WHERE `entry`= 3977 AND `groupid`= 1 AND `id`= 0; +UPDATE `creature_text` SET `BroadcastTextId`=19407 WHERE `entry`= 21699 AND `groupid`= 1 AND `id`= 0; +UPDATE `creature_text` SET `text`="Alright, let's go.", `BroadcastTextId`=5227 WHERE `entry`= 3692 AND `groupid`= 0 AND `id`= 0; +UPDATE `creature_text` SET `text`="Oh no! Here they come!", `BroadcastTextId`=3744 WHERE `entry`= 3692 AND `groupid`= 1 AND `id`= 0; +UPDATE `creature_text` SET `text`="Thank you again, $n. I'll make my way to the road now. When you can, find Terenthis and let him know we escaped.", `BroadcastTextId`=1236 WHERE `entry`= 3692 AND `groupid`= 2 AND `id`= 0; +UPDATE `creature_text` SET `text`="We made it, my friend. Remember to find Terenthis and let him know we're safe. Thank you again.", `BroadcastTextId`=1243 WHERE `entry`= 3692 AND `groupid`= 3 AND `id`= 0; +UPDATE `creature_text` SET `text`="Grimclaw?! Easy there, my friend... where is your master Volcor?", `BroadcastTextId`=1227 WHERE `entry`= 3693 AND `groupid`= 1 AND `id`= 0; +UPDATE `creature_text` SET `text`="I understand, my friend. I shall find someone to help your master. Go back to him now, or at least stay close.", `BroadcastTextId`=1232 WHERE `entry`= 3693 AND `groupid`= 2 AND `id`= 0; +UPDATE `creature_text` SET `text`="What is happening?", `BroadcastTextId`=13848 WHERE `entry`= 3693 AND `groupid`= 3 AND `id`= 0; +UPDATE `creature_text` SET `text`="Grimclaw?! Easy there, my friend... where is your master Volcor?", `BroadcastTextId`=1227 WHERE `entry`= 3693 AND `groupid`= 4 AND `id`= 0; +UPDATE `creature_text` SET `text`="There... that should help. Now, tell me what's happened, Grimclaw.", `BroadcastTextId`=1230 WHERE `entry`= 3693 AND `groupid`= 5 AND `id`= 0; +UPDATE `creature_text` SET `text`="Whoa, whoa there, my friend. One moment...", `BroadcastTextId`=1229 WHERE `entry`= 3693 AND `groupid`= 6 AND `id`= 0; +UPDATE `creature_text` SET `text`="I understand, my friend. I shall find someone to help your master. Go back to him now, or at least stay close.", `BroadcastTextId`=1232 WHERE `entry`= 3693 AND `groupid`= 7 AND `id`= 0; +UPDATE `creature_text` SET `text`="Now you're gonna get it good, $n!", `BroadcastTextId`=1961 WHERE `entry`= 4961 AND `groupid`= 0 AND `id`= 0; +UPDATE `creature_text` SET `text`="Interesting...", `BroadcastTextId`=19066 WHERE `entry`= 7207 AND `groupid`= 0 AND `id`= 0; +UPDATE `creature_text` SET `text`="That makes sense!", `BroadcastTextId`=65162 WHERE `entry`= 9117 AND `groupid`= 0 AND `id`= 0; |