diff options
| -rw-r--r-- | sql/updates/world/2014_04_14_01_world_broadcast_text_conversion.sql | 632 |
1 files changed, 632 insertions, 0 deletions
diff --git a/sql/updates/world/2014_04_14_01_world_broadcast_text_conversion.sql b/sql/updates/world/2014_04_14_01_world_broadcast_text_conversion.sql new file mode 100644 index 00000000000..bd7eb2bc673 --- /dev/null +++ b/sql/updates/world/2014_04_14_01_world_broadcast_text_conversion.sql @@ -0,0 +1,632 @@ +UPDATE `creature_text` SET `BroadcastTextID`=548 WHERE `entry`=36954 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1106 WHERE `entry`=3520 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1110 WHERE `entry`=3520 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1111 WHERE `entry`=3520 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=1189 WHERE `entry`=3584 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1224 WHERE `entry`=3667 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1279 WHERE `entry`=3843 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1282 WHERE `entry`=3843 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1283 WHERE `entry`=3843 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1284 WHERE `entry`=3843 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1285 WHERE `entry`=3843 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1330 WHERE `entry`=3568 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1356 WHERE `entry`=3946 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1357 WHERE `entry`=3946 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1358 WHERE `entry`=3946 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1425 WHERE `entry`=4049 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1426 WHERE `entry`=4049 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1528 WHERE `entry`=2991 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1528 WHERE `entry`=1373 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1679 WHERE `entry`=5042 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1682 WHERE `entry`=5042 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1685 WHERE `entry`=5042 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=1721 WHERE `entry`=5045 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2049 WHERE `entry`=5702 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2050 WHERE `entry`=5702 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2051 WHERE `entry`=5702 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2056 WHERE `entry`=5702 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2057 WHERE `entry`=5702 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2058 WHERE `entry`=5702 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2060 WHERE `entry`=5702 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2184 WHERE `entry`=5888 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2229 WHERE `entry`=2017 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2229 WHERE `entry`=2018 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2230 WHERE `entry`=2017 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=2230 WHERE `entry`=3277 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2230 WHERE `entry`=2018 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=2231 WHERE `entry`=2015 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2231 WHERE `entry`=2017 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=2231 WHERE `entry`=2018 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=2358 WHERE `entry`=6182 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2360 WHERE `entry`=6182 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2369 WHERE `entry`=6182 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3261 WHERE `entry`=7228 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4050 WHERE `entry`=7998 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4130 WHERE `entry`=7998 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4131 WHERE `entry`=7998 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4133 WHERE `entry`=7998 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4134 WHERE `entry`=7998 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4135 WHERE `entry`=7998 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4206 WHERE `entry`=7998 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4208 WHERE `entry`=7998 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4209 WHERE `entry`=7998 AND `groupid`=15 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4325 WHERE `entry`=7998 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4326 WHERE `entry`=7998 AND `groupid`=17 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4730 WHERE `entry`=9316 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5269 WHERE `entry`=6182 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5405 WHERE `entry`=9997 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5406 WHERE `entry`=9997 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5611 WHERE `entry`=9818 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5612 WHERE `entry`=10680 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5613 WHERE `entry`=9818 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5614 WHERE `entry`=10681 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5926 WHERE `entry`=10646 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5927 WHERE `entry`=10646 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5928 WHERE `entry`=10646 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5929 WHERE `entry`=10646 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5930 WHERE `entry`=10646 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6169 WHERE `entry`=4831 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6198 WHERE `entry`=3977 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6532 WHERE `entry`=3977 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7375 WHERE `entry`=10300 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7379 WHERE `entry`=10300 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=7380 WHERE `entry`=10300 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7385 WHERE `entry`=10300 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7386 WHERE `entry`=10300 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7388 WHERE `entry`=10300 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7389 WHERE `entry`=12116 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7390 WHERE `entry`=12116 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7391 WHERE `entry`=10300 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7392 WHERE `entry`=10300 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7399 WHERE `entry`=28917 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7410 WHERE `entry`=10300 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7411 WHERE `entry`=10300 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=7412 WHERE `entry`=10300 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7413 WHERE `entry`=12116 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7414 WHERE `entry`=12116 AND `groupid`=15 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7415 WHERE `entry`=12116 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7417 WHERE `entry`=12116 AND `groupid`=17 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7418 WHERE `entry`=12116 AND `groupid`=18 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7427 WHERE `entry`=12116 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7428 WHERE `entry`=12116 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7431 WHERE `entry`=12116 AND `groupid`=25 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7435 WHERE `entry`=10300 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7467 WHERE `entry`=10300 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7596 WHERE `entry`=12337 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7597 WHERE `entry`=12337 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=7599 WHERE `entry`=12337 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=7780 WHERE `entry`=12429 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7781 WHERE `entry`=12429 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7784 WHERE `entry`=12430 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7785 WHERE `entry`=12430 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8286 WHERE `entry`=10184 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8288 WHERE `entry`=10184 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8290 WHERE `entry`=10184 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8329 WHERE `entry`=17900 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8329 WHERE `entry`=17901 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10369 WHERE `entry`=14517 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10375 WHERE `entry`=11949 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10443 WHERE `entry`=14510 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10448 WHERE `entry`=14510 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10450 WHERE `entry`=14515 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10461 WHERE `entry`=14515 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10472 WHERE `entry`=14515 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10903 WHERE `entry`=15378 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10911 WHERE `entry`=15378 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11311 WHERE `entry`=15633 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=12187 WHERE `entry`=16295 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12188 WHERE `entry`=16295 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12190 WHERE `entry`=16295 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12220 WHERE `entry`=16208 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12767 WHERE `entry`=16522 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12846 WHERE `entry`=17071 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12852 WHERE `entry`=15953 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12853 WHERE `entry`=15953 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12854 WHERE `entry`=15953 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12854 WHERE `entry`=21212 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=12855 WHERE `entry`=15953 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=12856 WHERE `entry`=15953 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12857 WHERE `entry`=15953 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=12858 WHERE `entry`=15953 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13013 WHERE `entry`=16065 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13015 WHERE `entry`=16065 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13016 WHERE `entry`=16065 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13255 WHERE `entry`=16993 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13290 WHERE `entry`=16993 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13292 WHERE `entry`=16993 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13396 WHERE `entry`=16457 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13397 WHERE `entry`=15402 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13500 WHERE `entry`=17119 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13590 WHERE `entry`=17226 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13659 WHERE `entry`=16993 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13744 WHERE `entry`=17312 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13745 WHERE `entry`=17312 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13746 WHERE `entry`=17312 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13747 WHERE `entry`=17312 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13748 WHERE `entry`=17312 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13883 WHERE `entry`=16460 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13886 WHERE `entry`=16461 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13898 WHERE `entry`=16461 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15070 WHERE `entry`=17534 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15071 WHERE `entry`=17534 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15072 WHERE `entry`=17534 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15073 WHERE `entry`=17534 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15079 WHERE `entry`=16457 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15080 WHERE `entry`=16457 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15081 WHERE `entry`=16457 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15082 WHERE `entry`=16457 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15083 WHERE `entry`=16457 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=15084 WHERE `entry`=16457 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=15171 WHERE `entry`=17892 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=15174 WHERE `entry`=17892 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15884 WHERE `entry`=18760 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15979 WHERE `entry`=18887 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16082 WHERE `entry`=18887 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16314 WHERE `entry`=19223 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16932 WHERE `entry`=19546 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17075 WHERE `entry`=18385 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17598 WHERE `entry`=20098 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17656 WHERE `entry`=20129 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17667 WHERE `entry`=20129 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17668 WHERE `entry`=20129 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17669 WHERE `entry`=20129 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17696 WHERE `entry`=17797 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17697 WHERE `entry`=17797 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17698 WHERE `entry`=17797 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=17701 WHERE `entry`=17797 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17702 WHERE `entry`=17797 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18538 WHERE `entry`=17772 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18539 WHERE `entry`=17772 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18540 WHERE `entry`=17772 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18542 WHERE `entry`=17772 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18670 WHERE `entry`=21027 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18671 WHERE `entry`=21027 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18672 WHERE `entry`=21027 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18675 WHERE `entry`=21027 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=18684 WHERE `entry`=21027 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18685 WHERE `entry`=21027 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18688 WHERE `entry`=21027 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19063 WHERE `entry`=21193 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19263 WHERE `entry`=10181 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19718 WHERE `entry`=21983 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19940 WHERE `entry`=17976 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19942 WHERE `entry`=17976 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19959 WHERE `entry`=19221 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19961 WHERE `entry`=19221 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19963 WHERE `entry`=19221 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19964 WHERE `entry`=19221 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19965 WHERE `entry`=19221 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19966 WHERE `entry`=19221 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19979 WHERE `entry`=20885 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19981 WHERE `entry`=20885 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19982 WHERE `entry`=20885 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19983 WHERE `entry`=20885 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19985 WHERE `entry`=20885 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19987 WHERE `entry`=20885 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19988 WHERE `entry`=20885 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19989 WHERE `entry`=20885 AND `groupid`=6 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=20055 WHERE `entry`=20885 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20056 WHERE `entry`=20885 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20057 WHERE `entry`=20885 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20062 WHERE `entry`=28917 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20086 WHERE `entry`=21212 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20087 WHERE `entry`=21212 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20088 WHERE `entry`=21212 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20089 WHERE `entry`=21212 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20090 WHERE `entry`=21212 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=20091 WHERE `entry`=21212 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=20092 WHERE `entry`=21212 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20093 WHERE `entry`=21212 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20094 WHERE `entry`=15953 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20094 WHERE `entry`=21212 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20096 WHERE `entry`=21212 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20210 WHERE `entry`=21212 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20708 WHERE `entry`=23002 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20715 WHERE `entry`=23002 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20720 WHERE `entry`=23002 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20752 WHERE `entry`=22924 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20753 WHERE `entry`=22924 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20758 WHERE `entry`=22924 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20848 WHERE `entry`=20062 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20849 WHERE `entry`=18805 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20850 WHERE `entry`=18805 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20851 WHERE `entry`=18805 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20852 WHERE `entry`=18805 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20853 WHERE `entry`=18805 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=20855 WHERE `entry`=18805 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21357 WHERE `entry`=22947 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21489 WHERE `entry`=23197 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21607 WHERE `entry`=22924 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21711 WHERE `entry`=22951 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21712 WHERE `entry`=22951 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21715 WHERE `entry`=22951 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21716 WHERE `entry`=22951 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21717 WHERE `entry`=22951 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21719 WHERE `entry`=22951 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21752 WHERE `entry`=23419 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21756 WHERE `entry`=23419 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21766 WHERE `entry`=22947 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21767 WHERE `entry`=22947 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=21768 WHERE `entry`=22947 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21769 WHERE `entry`=22947 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21771 WHERE `entry`=22947 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=21772 WHERE `entry`=22947 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21774 WHERE `entry`=22947 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21776 WHERE `entry`=22947 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=22208 WHERE `entry`=23197 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=22244 WHERE `entry`=23768 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22245 WHERE `entry`=23768 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22246 WHERE `entry`=23768 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22247 WHERE `entry`=23768 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22249 WHERE `entry`=23768 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22379 WHERE `entry`=23573 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22562 WHERE `entry`=4979 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=23042 WHERE `entry`=23678 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=23043 WHERE `entry`=23678 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=23605 WHERE `entry`=24532 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23607 WHERE `entry`=24532 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23609 WHERE `entry`=24532 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24423 WHERE `entry`=25165 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24452 WHERE `entry`=25165 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24812 WHERE `entry`=25584 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24816 WHERE `entry`=25584 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24820 WHERE `entry`=25584 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25195 WHERE `entry`=26046 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25197 WHERE `entry`=26046 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25221 WHERE `entry`=24895 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25226 WHERE `entry`=24895 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25227 WHERE `entry`=24895 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25434 WHERE `entry`=24560 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25436 WHERE `entry`=24560 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25439 WHERE `entry`=24560 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25440 WHERE `entry`=24560 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25513 WHERE `entry`=25166 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25516 WHERE `entry`=25166 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25520 WHERE `entry`=25165 AND `groupid`=8 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=25521 WHERE `entry`=25165 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25522 WHERE `entry`=25165 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25637 WHERE `entry`=25038 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25638 WHERE `entry`=25038 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25639 WHERE `entry`=25038 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25640 WHERE `entry`=25038 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25642 WHERE `entry`=25038 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25802 WHERE `entry`=26588 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25803 WHERE `entry`=26588 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25804 WHERE `entry`=26588 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25805 WHERE `entry`=26588 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25809 WHERE `entry`=26588 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25810 WHERE `entry`=26588 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25843 WHERE `entry`=25251 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25854 WHERE `entry`=26648 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25863 WHERE `entry`=26648 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25864 WHERE `entry`=26648 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25865 WHERE `entry`=26648 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25867 WHERE `entry`=26648 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25868 WHERE `entry`=26648 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25869 WHERE `entry`=26648 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25870 WHERE `entry`=26648 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25934 WHERE `entry`=26762 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26110 WHERE `entry`=26935 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26176 WHERE `entry`=26723 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26191 WHERE `entry`=27115 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26884 WHERE `entry`=26935 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26889 WHERE `entry`=26935 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26890 WHERE `entry`=26935 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26892 WHERE `entry`=26588 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26893 WHERE `entry`=26588 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26894 WHERE `entry`=26588 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26914 WHERE `entry`=27646 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26915 WHERE `entry`=26935 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26916 WHERE `entry`=26935 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26917 WHERE `entry`=26935 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26918 WHERE `entry`=27646 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26919 WHERE `entry`=27646 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27026 WHERE `entry`=27726 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=27326 WHERE `entry`=26497 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27330 WHERE `entry`=26497 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27337 WHERE `entry`=27933 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27527 WHERE `entry`=28148 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27528 WHERE `entry`=28148 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28102 WHERE `entry`=27928 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=28104 WHERE `entry`=27928 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28105 WHERE `entry`=27928 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=28497 WHERE `entry`=28534 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28505 WHERE `entry`=28532 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28509 WHERE `entry`=28532 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28546 WHERE `entry`=28568 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28548 WHERE `entry`=28568 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28760 WHERE `entry`=28532 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28799 WHERE `entry`=28754 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28800 WHERE `entry`=28754 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28832 WHERE `entry`=28785 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28842 WHERE `entry`=28785 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28843 WHERE `entry`=28785 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28857 WHERE `entry`=28787 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28859 WHERE `entry`=28787 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28860 WHERE `entry`=28787 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28862 WHERE `entry`=28787 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28864 WHERE `entry`=28787 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28865 WHERE `entry`=28787 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28876 WHERE `entry`=28785 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28947 WHERE `entry`=28401 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29007 WHERE `entry`=28917 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29237 WHERE `entry`=28401 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29263 WHERE `entry`=28406 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=29269 WHERE `entry`=29050 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29272 WHERE `entry`=29050 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29274 WHERE `entry`=29050 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29276 WHERE `entry`=29050 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29424 WHERE `entry`=28030 AND `groupid`=0 AND `id`=7; +UPDATE `creature_text` SET `BroadcastTextID`=29426 WHERE `entry`=28030 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=29427 WHERE `entry`=28030 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29428 WHERE `entry`=28030 AND `groupid`=0 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=29429 WHERE `entry`=28030 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29431 WHERE `entry`=28030 AND `groupid`=0 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=29564 WHERE `entry`=27975 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29566 WHERE `entry`=27975 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29570 WHERE `entry`=27975 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29593 WHERE `entry`=26731 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29595 WHERE `entry`=26731 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29596 WHERE `entry`=26731 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29598 WHERE `entry`=26731 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29618 WHERE `entry`=26723 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29619 WHERE `entry`=26723 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29620 WHERE `entry`=26723 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29621 WHERE `entry`=26723 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29672 WHERE `entry`=26668 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29675 WHERE `entry`=26668 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29680 WHERE `entry`=26668 AND `groupid`=5 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=29681 WHERE `entry`=26668 AND `groupid`=5 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=29682 WHERE `entry`=26668 AND `groupid`=5 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=29683 WHERE `entry`=26668 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29684 WHERE `entry`=29281 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29686 WHERE `entry`=26668 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29687 WHERE `entry`=26668 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29980 WHERE `entry`=24068 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30509 WHERE `entry`=27915 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30608 WHERE `entry`=30897 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30750 WHERE `entry`=30086 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30789 WHERE `entry`=29310 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30807 WHERE `entry`=30154 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30808 WHERE `entry`=30012 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30809 WHERE `entry`=30012 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=30811 WHERE `entry`=30012 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=30821 WHERE `entry`=30086 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30822 WHERE `entry`=30162 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30828 WHERE `entry`=30162 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30862 WHERE `entry`=29310 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31215 WHERE `entry`=30501 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31216 WHERE `entry`=30501 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31481 WHERE `entry`=30836 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31482 WHERE `entry`=30836 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31483 WHERE `entry`=30836 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31484 WHERE `entry`=30836 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31485 WHERE `entry`=30836 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31489 WHERE `entry`=30839 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31490 WHERE `entry`=30839 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=31528 WHERE `entry`=30945 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31530 WHERE `entry`=30945 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31531 WHERE `entry`=30945 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31532 WHERE `entry`=30955 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31533 WHERE `entry`=30945 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31534 WHERE `entry`=30945 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31699 WHERE `entry`=29310 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31700 WHERE `entry`=29310 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31701 WHERE `entry`=29310 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31702 WHERE `entry`=29310 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31704 WHERE `entry`=29310 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=31705 WHERE `entry`=29310 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31706 WHERE `entry`=29310 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31707 WHERE `entry`=29310 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31708 WHERE `entry`=29310 AND `groupid`=5 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=31709 WHERE `entry`=29310 AND `groupid`=5 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=31710 WHERE `entry`=29310 AND `groupid`=5 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=31718 WHERE `entry`=31134 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31723 WHERE `entry`=31134 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31725 WHERE `entry`=31134 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31726 WHERE `entry`=31134 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31728 WHERE `entry`=31134 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31740 WHERE `entry`=31134 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31744 WHERE `entry`=31135 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31745 WHERE `entry`=31135 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31746 WHERE `entry`=31135 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=31753 WHERE `entry`=31135 AND `groupid`=27 AND `id`=27; +UPDATE `creature_text` SET `BroadcastTextID`=31755 WHERE `entry`=31135 AND `groupid`=4 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=31770 WHERE `entry`=31135 AND `groupid`=6 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=31771 WHERE `entry`=31135 AND `groupid`=5 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=31820 WHERE `entry`=31135 AND `groupid`=8 AND `id`=8; +UPDATE `creature_text` SET `BroadcastTextID`=31835 WHERE `entry`=31161 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31835 WHERE `entry`=30956 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31852 WHERE `entry`=31161 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31852 WHERE `entry`=30956 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31853 WHERE `entry`=31161 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31853 WHERE `entry`=30956 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31882 WHERE `entry`=31242 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31883 WHERE `entry`=31242 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31921 WHERE `entry`=31135 AND `groupid`=11 AND `id`=11; +UPDATE `creature_text` SET `BroadcastTextID`=31930 WHERE `entry`=31135 AND `groupid`=13 AND `id`=13; +UPDATE `creature_text` SET `BroadcastTextID`=31940 WHERE `entry`=31135 AND `groupid`=19 AND `id`=19; +UPDATE `creature_text` SET `BroadcastTextID`=31945 WHERE `entry`=31135 AND `groupid`=24 AND `id`=24; +UPDATE `creature_text` SET `BroadcastTextID`=31946 WHERE `entry`=31135 AND `groupid`=25 AND `id`=25; +UPDATE `creature_text` SET `BroadcastTextID`=31948 WHERE `entry`=31135 AND `groupid`=26 AND `id`=26; +UPDATE `creature_text` SET `BroadcastTextID`=31951 WHERE `entry`=31135 AND `groupid`=21 AND `id`=21; +UPDATE `creature_text` SET `BroadcastTextID`=31955 WHERE `entry`=31135 AND `groupid`=22 AND `id`=22; +UPDATE `creature_text` SET `BroadcastTextID`=31994 WHERE `entry`=30452 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31996 WHERE `entry`=30452 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31998 WHERE `entry`=30452 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=32000 WHERE `entry`=30452 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32626 WHERE `entry`=32295 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32627 WHERE `entry`=32295 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32629 WHERE `entry`=32295 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32959 WHERE `entry`=30452 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32959 WHERE `entry`=30452 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33303 WHERE `entry`=32906 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33312 WHERE `entry`=32906 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33366 WHERE `entry`=33220 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33367 WHERE `entry`=33220 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33370 WHERE `entry`=32906 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33423 WHERE `entry`=33273 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33424 WHERE `entry`=33273 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33425 WHERE `entry`=33273 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33426 WHERE `entry`=33273 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33427 WHERE `entry`=32906 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33436 WHERE `entry`=33303 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33437 WHERE `entry`=33303 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33517 WHERE `entry`=32906 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33518 WHERE `entry`=32906 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33519 WHERE `entry`=32906 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33520 WHERE `entry`=32906 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33524 WHERE `entry`=32906 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33658 WHERE `entry`=33495 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33665 WHERE `entry`=33436 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33666 WHERE `entry`=33436 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33667 WHERE `entry`=33436 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33991 WHERE `entry`=32906 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34107 WHERE `entry`=32906 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=34162 WHERE `entry`=33515 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34341 WHERE `entry`=33515 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34343 WHERE `entry`=33134 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34344 WHERE `entry`=33134 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34345 WHERE `entry`=33134 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34346 WHERE `entry`=33134 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34347 WHERE `entry`=33134 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34348 WHERE `entry`=33134 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34350 WHERE `entry`=33134 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34351 WHERE `entry`=33134 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34352 WHERE `entry`=33134 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34353 WHERE `entry`=33134 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34356 WHERE `entry`=33134 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34358 WHERE `entry`=33515 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34367 WHERE `entry`=33241 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34450 WHERE `entry`=33515 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34635 WHERE `entry`=26917 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34967 WHERE `entry`=34497 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34968 WHERE `entry`=34496 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34974 WHERE `entry`=34496 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34975 WHERE `entry`=34497 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35034 WHERE `entry`=34721 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35035 WHERE `entry`=34721 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35037 WHERE `entry`=34721 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35039 WHERE `entry`=34765 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35229 WHERE `entry`=34928 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35231 WHERE `entry`=34928 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35232 WHERE `entry`=34928 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35738 WHERE `entry`=34496 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35738 WHERE `entry`=34497 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35739 WHERE `entry`=34496 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35739 WHERE `entry`=34497 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35740 WHERE `entry`=34496 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=35740 WHERE `entry`=34497 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=35740 WHERE `entry`=23775 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35740 WHERE `entry`=3976 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35741 WHERE `entry`=34496 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35741 WHERE `entry`=34497 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35745 WHERE `entry`=34496 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35745 WHERE `entry`=34497 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35746 WHERE `entry`=34496 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35746 WHERE `entry`=34497 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35762 WHERE `entry`=34928 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35763 WHERE `entry`=34928 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35764 WHERE `entry`=34928 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35765 WHERE `entry`=34928 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35766 WHERE `entry`=34928 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=36845 WHERE `entry`=36990 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36847 WHERE `entry`=36990 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36854 WHERE `entry`=36993 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36855 WHERE `entry`=36993 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36856 WHERE `entry`=36993 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36991 WHERE `entry`=36955 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36998 WHERE `entry`=36955 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36998 WHERE `entry`=37554 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37020 WHERE `entry`=37126 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37022 WHERE `entry`=37126 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37024 WHERE `entry`=37126 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37065 WHERE `entry`=37126 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37108 WHERE `entry`=36853 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37135 WHERE `entry`=37126 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37136 WHERE `entry`=36853 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37137 WHERE `entry`=36853 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37138 WHERE `entry`=36853 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37140 WHERE `entry`=36853 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37170 WHERE `entry`=37554 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37171 WHERE `entry`=37554 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37263 WHERE `entry`=36764 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=37263 WHERE `entry`=36765 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=37263 WHERE `entry`=36766 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=37263 WHERE `entry`=36767 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=37263 WHERE `entry`=36770 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=37263 WHERE `entry`=36771 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=37263 WHERE `entry`=36772 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=37263 WHERE `entry`=36773 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=37371 WHERE `entry`=37597 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37377 WHERE `entry`=37597 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37382 WHERE `entry`=37596 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37383 WHERE `entry`=37596 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37384 WHERE `entry`=37596 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37478 WHERE `entry`=36993 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37479 WHERE `entry`=36993 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37480 WHERE `entry`=36993 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37484 WHERE `entry`=37846 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37486 WHERE `entry`=37846 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37487 WHERE `entry`=37846 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37488 WHERE `entry`=37846 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37490 WHERE `entry`=37846 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37491 WHERE `entry`=37846 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37492 WHERE `entry`=37846 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37494 WHERE `entry`=37846 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37540 WHERE `entry`=36990 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37541 WHERE `entry`=36990 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37546 WHERE `entry`=37188 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37564 WHERE `entry`=37223 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37569 WHERE `entry`=37223 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37570 WHERE `entry`=37223 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37573 WHERE `entry`=37223 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37574 WHERE `entry`=37221 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37574 WHERE `entry`=37223 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37575 WHERE `entry`=37223 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37576 WHERE `entry`=37223 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37596 WHERE `entry`=37221 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37597 WHERE `entry`=37221 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37598 WHERE `entry`=37221 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37599 WHERE `entry`=37221 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37600 WHERE `entry`=37221 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37600 WHERE `entry`=37223 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37601 WHERE `entry`=37221 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37653 WHERE `entry`=37126 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37654 WHERE `entry`=37126 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37781 WHERE `entry`=26917 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37894 WHERE `entry`=37846 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37997 WHERE `entry`=38004 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38048 WHERE `entry`=37955 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38053 WHERE `entry`=37955 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38058 WHERE `entry`=37955 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=38062 WHERE `entry`=37955 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38067 WHERE `entry`=37955 AND `groupid`=8 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=38068 WHERE `entry`=37955 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38536 WHERE `entry`=36955 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38538 WHERE `entry`=36955 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38542 WHERE `entry`=37554 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38551 WHERE `entry`=36955 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38551 WHERE `entry`=37554 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38672 WHERE `entry`=36853 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39925 WHERE `entry`=39747 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39932 WHERE `entry`=39747 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39933 WHERE `entry`=39747 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=39934 WHERE `entry`=39747 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40320 WHERE `entry`=40329 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40321 WHERE `entry`=40329 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40322 WHERE `entry`=40329 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40323 WHERE `entry`=40329 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40324 WHERE `entry`=40329 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40334 WHERE `entry`=40184 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40598 WHERE `entry`=40429 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40599 WHERE `entry`=40429 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40600 WHERE `entry`=40429 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40601 WHERE `entry`=40429 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40602 WHERE `entry`=40429 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40603 WHERE `entry`=40429 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40604 WHERE `entry`=40429 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40605 WHERE `entry`=40429 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40606 WHERE `entry`=40429 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=49785 WHERE `entry`=21212 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=71184 WHERE `entry`=9458 AND `groupid`=0 AND `id`=2; |