diff options
| author | Kinzcool <kinzzcool@hotmail.com> | 2014-04-21 12:52:29 -0400 |
|---|---|---|
| committer | Kinzcool <kinzzcool@hotmail.com> | 2014-04-21 12:52:29 -0400 |
| commit | 4fa511c3a8ec134ba7bbe6031fb3ca696095c219 (patch) | |
| tree | 7cb4915bc871f04fc862e7f46c09bae3f8e4b04e | |
| parent | 58cb866fe5e8a3990b25ba8f712ccc4990295ea1 (diff) | |
DB/CreatureText: "A few" manual updates to assign the proper BroadcastTextID to the typoed creature_texts -- because fuck you typos (Part V)
* Corrected ~2200 typos
| -rw-r--r-- | sql/updates/world/2014_04_21_04_world_broadcast_text_conversion.sql | 2229 |
1 files changed, 2229 insertions, 0 deletions
diff --git a/sql/updates/world/2014_04_21_04_world_broadcast_text_conversion.sql b/sql/updates/world/2014_04_21_04_world_broadcast_text_conversion.sql new file mode 100644 index 00000000000..85bfabe352a --- /dev/null +++ b/sql/updates/world/2014_04_21_04_world_broadcast_text_conversion.sql @@ -0,0 +1,2229 @@ +UPDATE `creature_text` SET `BroadcastTextID`=1853 WHERE `entry`=253 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=67 WHERE `entry`=270 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=111 WHERE `entry`=314 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=110 WHERE `entry`=314 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=25 WHERE `entry`=349 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26 WHERE `entry`=349 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27 WHERE `entry`=349 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29 WHERE `entry`=349 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30 WHERE `entry`=349 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1874 WHERE `entry`=435 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1875 WHERE `entry`=435 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1874 WHERE `entry`=436 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1875 WHERE `entry`=436 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1874 WHERE `entry`=437 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1875 WHERE `entry`=437 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1874 WHERE `entry`=440 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1875 WHERE `entry`=440 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=10 WHERE `entry`=467 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=489 WHERE `entry`=467 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1874 WHERE `entry`=485 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1875 WHERE `entry`=485 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=479 WHERE `entry`=550 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1874 WHERE `entry`=615 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1875 WHERE `entry`=615 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=4714 WHERE `entry`=620 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6065 WHERE `entry`=639 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5619 WHERE `entry`=644 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1149 WHERE `entry`=646 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4378 WHERE `entry`=836 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1935 WHERE `entry`=1051 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1935 WHERE `entry`=1053 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1935 WHERE `entry`=1054 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=9589 WHERE `entry`=1063 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1935 WHERE `entry`=1169 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=435 WHERE `entry`=1222 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=39711 WHERE `entry`=1268 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=455 WHERE `entry`=1364 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=125 WHERE `entry`=1373 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=128 WHERE `entry`=1373 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=184 WHERE `entry`=1395 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=448 WHERE `entry`=1399 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=446 WHERE `entry`=1399 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=179 WHERE `entry`=1402 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=185 WHERE `entry`=1402 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=179 WHERE `entry`=1405 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=185 WHERE `entry`=1405 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=9776 WHERE `entry`=1416 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9779 WHERE `entry`=1416 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=764 WHERE `entry`=1493 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=778 WHERE `entry`=1493 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=775 WHERE `entry`=1493 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=774 WHERE `entry`=1493 AND `groupid`=0 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=777 WHERE `entry`=1493 AND `groupid`=0 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=326 WHERE `entry`=1754 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=324 WHERE `entry`=1755 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=425 WHERE `entry`=1931 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=428 WHERE `entry`=1931 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=534 WHERE `entry`=1950 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=539 WHERE `entry`=1951 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=481 WHERE `entry`=1978 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=482 WHERE `entry`=1978 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=543 WHERE `entry`=1978 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=544 WHERE `entry`=1978 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=541 WHERE `entry`=1978 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=484 WHERE `entry`=1978 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=537 WHERE `entry`=1978 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=538 WHERE `entry`=1978 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1240 WHERE `entry`=2080 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1159 WHERE `entry`=2080 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1156 WHERE `entry`=2080 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1158 WHERE `entry`=2080 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1174 WHERE `entry`=2080 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=576 WHERE `entry`=2211 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1927 WHERE `entry`=2287 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1935 WHERE `entry`=2428 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=623 WHERE `entry`=2435 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3827 WHERE `entry`=2691 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3400 WHERE `entry`=2748 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6536 WHERE `entry`=2748 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6537 WHERE `entry`=2748 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6215 WHERE `entry`=2748 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=846 WHERE `entry`=2768 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=847 WHERE `entry`=2768 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=889 WHERE `entry`=2768 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=928 WHERE `entry`=2917 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=935 WHERE `entry`=2917 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=936 WHERE `entry`=2917 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=941 WHERE `entry`=2917 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1011 WHERE `entry`=3054 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1017 WHERE `entry`=3274 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1017 WHERE `entry`=3275 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1015 WHERE `entry`=3301 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4926 WHERE `entry`=3389 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1079 WHERE `entry`=3395 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1017 WHERE `entry`=3397 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1031 WHERE `entry`=3439 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1033 WHERE `entry`=3439 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1041 WHERE `entry`=3439 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1044 WHERE `entry`=3439 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1085 WHERE `entry`=3448 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1088 WHERE `entry`=3448 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1066 WHERE `entry`=3465 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1068 WHERE `entry`=3465 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1074 WHERE `entry`=3465 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1075 WHERE `entry`=3465 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1072 WHERE `entry`=3465 AND `groupid`=4 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=1073 WHERE `entry`=3465 AND `groupid`=4 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=1098 WHERE `entry`=3504 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1107 WHERE `entry`=3520 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1108 WHERE `entry`=3520 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1105 WHERE `entry`=3520 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=1188 WHERE `entry`=3584 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1216 WHERE `entry`=3616 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1217 WHERE `entry`=3616 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1280 WHERE `entry`=3644 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1264 WHERE `entry`=3678 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1276 WHERE `entry`=3678 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1234 WHERE `entry`=3695 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6194 WHERE `entry`=3975 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6196 WHERE `entry`=3975 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18023 WHERE `entry`=3977 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1376 WHERE `entry`=3981 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1874 WHERE `entry`=4065 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1875 WHERE `entry`=4065 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=2569 WHERE `entry`=4306 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=2571 WHERE `entry`=4306 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=22419 WHERE `entry`=4351 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22419 WHERE `entry`=4352 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1874 WHERE `entry`=4462 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1875 WHERE `entry`=4462 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1874 WHERE `entry`=4463 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1875 WHERE `entry`=4463 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1482 WHERE `entry`=4508 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1483 WHERE `entry`=4508 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1547 WHERE `entry`=4508 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1484 WHERE `entry`=4508 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1485 WHERE `entry`=4508 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1486 WHERE `entry`=4508 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1487 WHERE `entry`=4508 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1488 WHERE `entry`=4508 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1490 WHERE `entry`=4508 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1493 WHERE `entry`=4508 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1494 WHERE `entry`=4508 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1475 WHERE `entry`=4509 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6202 WHERE `entry`=4543 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6203 WHERE `entry`=4543 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6170 WHERE `entry`=4831 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6172 WHERE `entry`=4832 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6213 WHERE `entry`=4854 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1663 WHERE `entry`=4966 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1732 WHERE `entry`=4980 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1756 WHERE `entry`=5089 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7124 WHERE `entry`=5391 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1628 WHERE `entry`=5391 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1855 WHERE `entry`=5391 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2052 WHERE `entry`=5702 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2053 WHERE `entry`=5702 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2054 WHERE `entry`=5702 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2055 WHERE `entry`=5702 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2059 WHERE `entry`=5702 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4364 WHERE `entry`=5721 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6586 WHERE `entry`=5901 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6599 WHERE `entry`=5901 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2139 WHERE `entry`=5955 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2141 WHERE `entry`=5955 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2145 WHERE `entry`=6015 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39713 WHERE `entry`=6119 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2383 WHERE `entry`=6176 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3090 WHERE `entry`=6182 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2421 WHERE `entry`=6238 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2301 WHERE `entry`=6248 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2318 WHERE `entry`=6248 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2320 WHERE `entry`=6248 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1935 WHERE `entry`=6523 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=2629 WHERE `entry`=6546 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3012 WHERE `entry`=6669 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=2704 WHERE `entry`=6669 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3761 WHERE `entry`=7766 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3790 WHERE `entry`=7780 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3817 WHERE `entry`=7780 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3794 WHERE `entry`=7784 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3795 WHERE `entry`=7784 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3796 WHERE `entry`=7784 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=3797 WHERE `entry`=7784 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3816 WHERE `entry`=7784 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6173 WHERE `entry`=7800 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6176 WHERE `entry`=7800 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6175 WHERE `entry`=7800 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4365 WHERE `entry`=7804 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3812 WHERE `entry`=7805 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3794 WHERE `entry`=7806 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3795 WHERE `entry`=7806 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3796 WHERE `entry`=7806 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=3797 WHERE `entry`=7806 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3812 WHERE `entry`=7806 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3816 WHERE `entry`=7806 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3794 WHERE `entry`=7807 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3795 WHERE `entry`=7807 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3796 WHERE `entry`=7807 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=3797 WHERE `entry`=7807 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=3816 WHERE `entry`=7807 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39712 WHERE `entry`=7955 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4051 WHERE `entry`=7998 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4052 WHERE `entry`=7998 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4129 WHERE `entry`=7998 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4132 WHERE `entry`=7998 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4136 WHERE `entry`=7998 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4327 WHERE `entry`=7998 AND `groupid`=18 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4446 WHERE `entry`=7998 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4504 WHERE `entry`=8516 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9008 WHERE `entry`=8516 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1610 WHERE `entry`=9316 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7302 WHERE `entry`=9453 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4925 WHERE `entry`=9458 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1254 WHERE `entry`=9524 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4973 WHERE `entry`=9543 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4949 WHERE `entry`=9546 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10620 WHERE `entry`=9546 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5158 WHERE `entry`=9623 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5159 WHERE `entry`=9623 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5157 WHERE `entry`=9623 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5156 WHERE `entry`=9623 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5392 WHERE `entry`=9999 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=5393 WHERE `entry`=9999 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9794 WHERE `entry`=10162 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8287 WHERE `entry`=10184 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5544 WHERE `entry`=10262 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=7365 WHERE `entry`=10300 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7378 WHERE `entry`=10300 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=7434 WHERE `entry`=10300 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5648 WHERE `entry`=10427 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=5654 WHERE `entry`=10427 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6006 WHERE `entry`=10541 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6008 WHERE `entry`=10541 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=6011 WHERE `entry`=10541 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=5774 WHERE `entry`=10556 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6149 WHERE `entry`=10638 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6453 WHERE `entry`=11136 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6455 WHERE `entry`=11136 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=6530 WHERE `entry`=11143 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=6542 WHERE `entry`=11218 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=6867 WHERE `entry`=11218 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1909 WHERE `entry`=11339 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1909 WHERE `entry`=11340 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1909 WHERE `entry`=11350 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1909 WHERE `entry`=11351 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1909 WHERE `entry`=11356 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10601 WHERE `entry`=11380 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10449 WHERE `entry`=11380 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7657 WHERE `entry`=11502 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7661 WHERE `entry`=11502 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7685 WHERE `entry`=11502 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8573 WHERE `entry`=11502 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9973 WHERE `entry`=11583 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9974 WHERE `entry`=11583 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=9883 WHERE `entry`=11583 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9972 WHERE `entry`=11583 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9971 WHERE `entry`=11583 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9851 WHERE `entry`=11583 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9853 WHERE `entry`=11583 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30668 WHERE `entry`=11583 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7303 WHERE `entry`=11596 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7302 WHERE `entry`=11596 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=10025 WHERE `entry`=11677 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1935 WHERE `entry`=11680 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=1909 WHERE `entry`=11830 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=1909 WHERE `entry`=11831 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11282 WHERE `entry`=11832 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11290 WHERE `entry`=11832 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=11291 WHERE `entry`=11832 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=11295 WHERE `entry`=11832 AND `groupid`=5 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=11329 WHERE `entry`=11832 AND `groupid`=9 AND `id`=9; +UPDATE `creature_text` SET `BroadcastTextID`=10866 WHERE `entry`=11832 AND `groupid`=10 AND `id`=10; +UPDATE `creature_text` SET `BroadcastTextID`=10874 WHERE `entry`=11832 AND `groupid`=15 AND `id`=15; +UPDATE `creature_text` SET `BroadcastTextID`=10055 WHERE `entry`=11947 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10378 WHERE `entry`=11947 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10057 WHERE `entry`=11947 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10374 WHERE `entry`=11948 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=8839 WHERE `entry`=11948 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=10054 WHERE `entry`=11949 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10056 WHERE `entry`=11949 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9967 WHERE `entry`=12017 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9968 WHERE `entry`=12017 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7612 WHERE `entry`=12018 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7566 WHERE `entry`=12018 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7561 WHERE `entry`=12018 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7657 WHERE `entry`=12018 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7661 WHERE `entry`=12018 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8253 WHERE `entry`=12056 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7393 WHERE `entry`=12116 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7394 WHERE `entry`=12116 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7419 WHERE `entry`=12116 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7422 WHERE `entry`=12116 AND `groupid`=21 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7424 WHERE `entry`=12116 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7668 WHERE `entry`=12423 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7668 WHERE `entry`=12427 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7668 WHERE `entry`=12428 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7668 WHERE `entry`=12429 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=7668 WHERE `entry`=12430 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9961 WHERE `entry`=12435 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9962 WHERE `entry`=12435 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9963 WHERE `entry`=12435 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9591 WHERE `entry`=12435 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8555 WHERE `entry`=12717 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8278 WHERE `entry`=12858 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8282 WHERE `entry`=12858 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8281 WHERE `entry`=12858 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8398 WHERE `entry`=12921 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8465 WHERE `entry`=12997 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9886 WHERE `entry`=13020 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9887 WHERE `entry`=13020 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9888 WHERE `entry`=13020 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9965 WHERE `entry`=13020 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9964 WHERE `entry`=13020 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=8888 WHERE `entry`=13602 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9764 WHERE `entry`=14020 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9793 WHERE `entry`=14020 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=9447 WHERE `entry`=14368 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10460 WHERE `entry`=14507 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10451 WHERE `entry`=14509 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10459 WHERE `entry`=14510 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10027 WHERE `entry`=14517 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10452 WHERE `entry`=14517 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31956 WHERE `entry`=14688 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31957 WHERE `entry`=14688 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10160 WHERE `entry`=14823 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=10447 WHERE `entry`=14834 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10594 WHERE `entry`=14834 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10805 WHERE `entry`=15203 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10805 WHERE `entry`=15204 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10805 WHERE `entry`=15205 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10803 WHERE `entry`=15206 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10803 WHERE `entry`=15207 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10803 WHERE `entry`=15208 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10686 WHERE `entry`=15209 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10686 WHERE `entry`=15211 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10686 WHERE `entry`=15212 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10803 WHERE `entry`=15220 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11343 WHERE `entry`=15299 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11345 WHERE `entry`=15299 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11695 WHERE `entry`=15299 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11346 WHERE `entry`=15299 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11347 WHERE `entry`=15299 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28803 WHERE `entry`=15299 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10805 WHERE `entry`=15305 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10686 WHERE `entry`=15307 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11439 WHERE `entry`=15341 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11437 WHERE `entry`=15341 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11436 WHERE `entry`=15341 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11067 WHERE `entry`=15341 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11429 WHERE `entry`=15341 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10992 WHERE `entry`=15371 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10993 WHERE `entry`=15371 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=10908 WHERE `entry`=15378 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10912 WHERE `entry`=15378 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10904 WHERE `entry`=15380 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10913 WHERE `entry`=15380 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10920 WHERE `entry`=15381 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10925 WHERE `entry`=15381 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10931 WHERE `entry`=15381 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10926 WHERE `entry`=15381 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10933 WHERE `entry`=15381 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10934 WHERE `entry`=15381 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10916 WHERE `entry`=15382 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10932 WHERE `entry`=15382 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10922 WHERE `entry`=15382 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10929 WHERE `entry`=15382 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11734 WHERE `entry`=15420 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11735 WHERE `entry`=15420 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11717 WHERE `entry`=15420 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11028 WHERE `entry`=15471 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11030 WHERE `entry`=15491 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11296 WHERE `entry`=15491 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=11294 WHERE `entry`=15491 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=11298 WHERE `entry`=15491 AND `groupid`=4 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=11314 WHERE `entry`=15491 AND `groupid`=9 AND `id`=9; +UPDATE `creature_text` SET `BroadcastTextID`=11315 WHERE `entry`=15491 AND `groupid`=10 AND `id`=10; +UPDATE `creature_text` SET `BroadcastTextID`=11319 WHERE `entry`=15491 AND `groupid`=12 AND `id`=12; +UPDATE `creature_text` SET `BroadcastTextID`=11442 WHERE `entry`=15516 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13462 WHERE `entry`=15550 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19911 WHERE `entry`=15608 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11270 WHERE `entry`=15625 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11323 WHERE `entry`=15628 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11326 WHERE `entry`=15628 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=11289 WHERE `entry`=15629 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11310 WHERE `entry`=15633 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11312 WHERE `entry`=15633 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=15339 WHERE `entry`=15687 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15086 WHERE `entry`=15687 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=15126 WHERE `entry`=15690 AND `groupid`=6 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13092 WHERE `entry`=15928 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13093 WHERE `entry`=15928 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13095 WHERE `entry`=15928 AND `groupid`=5 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=13084 WHERE `entry`=15929 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13024 WHERE `entry`=15930 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13041 WHERE `entry`=15936 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13043 WHERE `entry`=15936 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13045 WHERE `entry`=15936 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13047 WHERE `entry`=15936 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13048 WHERE `entry`=15936 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13050 WHERE `entry`=15936 AND `groupid`=2 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=12013 WHERE `entry`=15941 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12014 WHERE `entry`=15945 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13064 WHERE `entry`=15954 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12994 WHERE `entry`=15990 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32335 WHERE `entry`=16011 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=4428 WHERE `entry`=16028 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11931 WHERE `entry`=16031 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13029 WHERE `entry`=16060 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13027 WHERE `entry`=16060 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13026 WHERE `entry`=16060 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13028 WHERE `entry`=16060 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13102 WHERE `entry`=16063 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13100 WHERE `entry`=16063 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13034 WHERE `entry`=16064 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13039 WHERE `entry`=16064 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13040 WHERE `entry`=16064 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13010 WHERE `entry`=16065 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13014 WHERE `entry`=16065 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13011 WHERE `entry`=16065 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15334 WHERE `entry`=16151 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13456 WHERE `entry`=16151 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12193 WHERE `entry`=16220 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12787 WHERE `entry`=16263 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12786 WHERE `entry`=16263 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=12189 WHERE `entry`=16295 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12191 WHERE `entry`=16295 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12690 WHERE `entry`=16325 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12690 WHERE `entry`=16326 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13847 WHERE `entry`=16406 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13825 WHERE `entry`=16407 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13878 WHERE `entry`=16414 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13885 WHERE `entry`=16460 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13884 WHERE `entry`=16460 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13919 WHERE `entry`=16468 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13944 WHERE `entry`=16470 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13949 WHERE `entry`=16481 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13949 WHERE `entry`=16482 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13408 WHERE `entry`=16483 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13409 WHERE `entry`=16483 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=12451 WHERE `entry`=16483 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13410 WHERE `entry`=16483 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=13441 WHERE `entry`=16483 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13411 WHERE `entry`=16483 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13442 WHERE `entry`=16483 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=13958 WHERE `entry`=16485 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13514 WHERE `entry`=16524 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13569 WHERE `entry`=16524 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13532 WHERE `entry`=16524 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12520 WHERE `entry`=16534 AND `groupid`=0 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=13965 WHERE `entry`=16544 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12707 WHERE `entry`=16578 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12618 WHERE `entry`=16589 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12625 WHERE `entry`=16589 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=12547 WHERE `entry`=16590 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=12635 WHERE `entry`=16590 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19051 WHERE `entry`=16769 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15594 WHERE `entry`=16807 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15575 WHERE `entry`=16807 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=15589 WHERE `entry`=16807 AND `groupid`=2 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=16924 WHERE `entry`=16809 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16925 WHERE `entry`=16809 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13181 WHERE `entry`=16847 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13182 WHERE `entry`=16847 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=13289 WHERE `entry`=16993 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13413 WHERE `entry`=17073 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13418 WHERE `entry`=17073 AND `groupid`=0 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=13414 WHERE `entry`=17073 AND `groupid`=0 AND `id`=9; +UPDATE `creature_text` SET `BroadcastTextID`=13417 WHERE `entry`=17073 AND `groupid`=0 AND `id`=10; +UPDATE `creature_text` SET `BroadcastTextID`=13416 WHERE `entry`=17073 AND `groupid`=0 AND `id`=11; +UPDATE `creature_text` SET `BroadcastTextID`=13415 WHERE `entry`=17073 AND `groupid`=0 AND `id`=12; +UPDATE `creature_text` SET `BroadcastTextID`=13448 WHERE `entry`=17085 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13447 WHERE `entry`=17085 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13589 WHERE `entry`=17226 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13591 WHERE `entry`=17226 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13610 WHERE `entry`=17226 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13595 WHERE `entry`=17230 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13622 WHERE `entry`=17233 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13623 WHERE `entry`=17233 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13624 WHERE `entry`=17233 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13625 WHERE `entry`=17233 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13626 WHERE `entry`=17233 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13627 WHERE `entry`=17233 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13616 WHERE `entry`=17238 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13617 WHERE `entry`=17238 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13619 WHERE `entry`=17238 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14084 WHERE `entry`=17243 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14090 WHERE `entry`=17243 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13775 WHERE `entry`=17243 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13999 WHERE `entry`=17306 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17498 WHERE `entry`=17306 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17502 WHERE `entry`=17306 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17503 WHERE `entry`=17306 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17504 WHERE `entry`=17306 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=17501 WHERE `entry`=17306 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13981 WHERE `entry`=17307 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17634 WHERE `entry`=17308 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17635 WHERE `entry`=17308 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=17637 WHERE `entry`=17308 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13776 WHERE `entry`=17318 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13978 WHERE `entry`=17375 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13837 WHERE `entry`=17375 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=13979 WHERE `entry`=17375 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=15130 WHERE `entry`=17377 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17671 WHERE `entry`=17377 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=15132 WHERE `entry`=17377 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17672 WHERE `entry`=17377 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17679 WHERE `entry`=17381 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17680 WHERE `entry`=17381 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17681 WHERE `entry`=17381 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=17683 WHERE `entry`=17381 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17685 WHERE `entry`=17381 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13874 WHERE `entry`=17392 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14000 WHERE `entry`=17455 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14001 WHERE `entry`=17455 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14212 WHERE `entry`=17521 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15074 WHERE `entry`=17534 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15068 WHERE `entry`=17535 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15066 WHERE `entry`=17535 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15069 WHERE `entry`=17535 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15067 WHERE `entry`=17535 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20472 WHERE `entry`=17536 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17493 WHERE `entry`=17537 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17495 WHERE `entry`=17537 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17497 WHERE `entry`=17537 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15135 WHERE `entry`=17543 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15136 WHERE `entry`=17543 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19276 WHERE `entry`=17546 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15133 WHERE `entry`=17546 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15155 WHERE `entry`=17547 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15156 WHERE `entry`=17547 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14361 WHERE `entry`=17547 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20941 WHERE `entry`=17711 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17786 WHERE `entry`=17725 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18220 WHERE `entry`=17767 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18223 WHERE `entry`=17767 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18224 WHERE `entry`=17767 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18225 WHERE `entry`=17767 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18537 WHERE `entry`=17772 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18541 WHERE `entry`=17772 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18543 WHERE `entry`=17772 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15309 WHERE `entry`=17772 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17716 WHERE `entry`=17796 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17704 WHERE `entry`=17797 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17728 WHERE `entry`=17798 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=17729 WHERE `entry`=17798 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14459 WHERE `entry`=17807 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14464 WHERE `entry`=17807 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18238 WHERE `entry`=17808 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18233 WHERE `entry`=17808 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18231 WHERE `entry`=17808 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18232 WHERE `entry`=17808 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17506 WHERE `entry`=17826 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17508 WHERE `entry`=17826 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17509 WHERE `entry`=17826 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18248 WHERE `entry`=17842 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18255 WHERE `entry`=17842 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18254 WHERE `entry`=17842 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=18252 WHERE `entry`=17842 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18251 WHERE `entry`=17842 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18247 WHERE `entry`=17842 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18544 WHERE `entry`=17852 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18734 WHERE `entry`=17852 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15312 WHERE `entry`=17852 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15909 WHERE `entry`=17862 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16673 WHERE `entry`=17862 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16674 WHERE `entry`=17862 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16677 WHERE `entry`=17862 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15893 WHERE `entry`=17876 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15908 WHERE `entry`=17876 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17610 WHERE `entry`=17876 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17611 WHERE `entry`=17876 AND `groupid`=11 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17612 WHERE `entry`=17876 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17613 WHERE `entry`=17876 AND `groupid`=12 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17601 WHERE `entry`=17876 AND `groupid`=13 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=16814 WHERE `entry`=17879 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16817 WHERE `entry`=17879 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16816 WHERE `entry`=17879 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16821 WHERE `entry`=17880 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16822 WHERE `entry`=17880 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16824 WHERE `entry`=17880 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16823 WHERE `entry`=17880 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16827 WHERE `entry`=17881 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16828 WHERE `entry`=17881 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16829 WHERE `entry`=17881 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16832 WHERE `entry`=17881 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=10645 WHERE `entry`=17881 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18244 WHERE `entry`=17888 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18240 WHERE `entry`=17888 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17888 WHERE `entry`=17941 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17889 WHERE `entry`=17941 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17892 WHERE `entry`=17941 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17893 WHERE `entry`=17941 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17894 WHERE `entry`=17941 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10869 WHERE `entry`=17949 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10871 WHERE `entry`=17949 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10873 WHERE `entry`=17949 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10876 WHERE `entry`=17949 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10878 WHERE `entry`=17949 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14413 WHERE `entry`=17959 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18261 WHERE `entry`=17968 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18265 WHERE `entry`=17968 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14990 WHERE `entry`=17968 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14724 WHERE `entry`=17969 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14725 WHERE `entry`=17969 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14726 WHERE `entry`=17969 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14727 WHERE `entry`=17969 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14728 WHERE `entry`=17969 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19944 WHERE `entry`=17975 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19945 WHERE `entry`=17975 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19947 WHERE `entry`=17975 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19948 WHERE `entry`=17975 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19949 WHERE `entry`=17975 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19936 WHERE `entry`=17976 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19937 WHERE `entry`=17976 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19938 WHERE `entry`=17976 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19939 WHERE `entry`=17976 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17562 WHERE `entry`=17976 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19941 WHERE `entry`=17976 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20022 WHERE `entry`=17977 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20028 WHERE `entry`=17977 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=10755 WHERE `entry`=17980 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15483 WHERE `entry`=18069 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16021 WHERE `entry`=18096 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=16023 WHERE `entry`=18096 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16694 WHERE `entry`=18096 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16692 WHERE `entry`=18096 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=16696 WHERE `entry`=18096 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14811 WHERE `entry`=18146 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14808 WHERE `entry`=18146 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14809 WHERE `entry`=18146 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14810 WHERE `entry`=18146 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15050 WHERE `entry`=18168 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15332 WHERE `entry`=18168 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=15052 WHERE `entry`=18168 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15051 WHERE `entry`=18168 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15000 WHERE `entry`=18209 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15009 WHERE `entry`=18210 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15001 WHERE `entry`=18210 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17771 WHERE `entry`=18341 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17772 WHERE `entry`=18341 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17774 WHERE `entry`=18341 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17775 WHERE `entry`=18341 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17776 WHERE `entry`=18341 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21067 WHERE `entry`=18341 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17780 WHERE `entry`=18344 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17781 WHERE `entry`=18344 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17782 WHERE `entry`=18344 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=15297 WHERE `entry`=18369 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15466 WHERE `entry`=18373 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17648 WHERE `entry`=18373 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17650 WHERE `entry`=18373 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17651 WHERE `entry`=18373 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17646 WHERE `entry`=18373 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17073 WHERE `entry`=18385 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15468 WHERE `entry`=18400 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15371 WHERE `entry`=18407 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15424 WHERE `entry`=18445 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15473 WHERE `entry`=18471 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15475 WHERE `entry`=18471 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17733 WHERE `entry`=18472 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17734 WHERE `entry`=18472 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17735 WHERE `entry`=18472 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17736 WHERE `entry`=18472 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=17737 WHERE `entry`=18472 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17738 WHERE `entry`=18472 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17739 WHERE `entry`=18472 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17769 WHERE `entry`=18473 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17765 WHERE `entry`=18473 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17767 WHERE `entry`=18473 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17768 WHERE `entry`=18473 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=17763 WHERE `entry`=18473 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17764 WHERE `entry`=18473 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17762 WHERE `entry`=18473 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19738 WHERE `entry`=18473 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15542 WHERE `entry`=18554 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19159 WHERE `entry`=18554 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19164 WHERE `entry`=18554 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19520 WHERE `entry`=18598 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19521 WHERE `entry`=18598 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17573 WHERE `entry`=18667 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17575 WHERE `entry`=18667 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17576 WHERE `entry`=18667 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17577 WHERE `entry`=18667 AND `groupid`=7 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19873 WHERE `entry`=18698 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18799 WHERE `entry`=18708 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15895 WHERE `entry`=18728 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17860 WHERE `entry`=18731 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17863 WHERE `entry`=18731 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=17865 WHERE `entry`=18731 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17866 WHERE `entry`=18731 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17869 WHERE `entry`=18732 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17870 WHERE `entry`=18732 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=17867 WHERE `entry`=18732 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17872 WHERE `entry`=18732 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=15882 WHERE `entry`=18760 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15883 WHERE `entry`=18760 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=15887 WHERE `entry`=18760 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20854 WHERE `entry`=18805 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20372 WHERE `entry`=18805 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20066 WHERE `entry`=18831 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20068 WHERE `entry`=18831 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20070 WHERE `entry`=18831 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=20072 WHERE `entry`=18831 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20073 WHERE `entry`=18831 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20074 WHERE `entry`=18831 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=20075 WHERE `entry`=18831 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18869 WHERE `entry`=18879 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16094 WHERE `entry`=18929 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16097 WHERE `entry`=18929 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=16093 WHERE `entry`=18929 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=16972 WHERE `entry`=18999 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=16970 WHERE `entry`=18999 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=16971 WHERE `entry`=18999 AND `groupid`=0 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=16978 WHERE `entry`=18999 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=20116 WHERE `entry`=19044 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20117 WHERE `entry`=19044 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20118 WHERE `entry`=19044 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20119 WHERE `entry`=19044 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20120 WHERE `entry`=19044 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20121 WHERE `entry`=19044 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20122 WHERE `entry`=19044 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20123 WHERE `entry`=19044 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=22060 WHERE `entry`=19196 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16296 WHERE `entry`=19196 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20038 WHERE `entry`=19218 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19956 WHERE `entry`=19219 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19955 WHERE `entry`=19219 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19953 WHERE `entry`=19219 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18725 WHERE `entry`=19220 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19962 WHERE `entry`=19221 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=16307 WHERE `entry`=19223 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16318 WHERE `entry`=19227 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16319 WHERE `entry`=19227 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=16323 WHERE `entry`=19227 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=16324 WHERE `entry`=19227 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16318 WHERE `entry`=19227 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=16319 WHERE `entry`=19227 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=16320 WHERE `entry`=19227 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16322 WHERE `entry`=19227 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=16321 WHERE `entry`=19227 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=16611 WHERE `entry`=19283 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=16456 WHERE `entry`=19308 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16454 WHERE `entry`=19308 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=16526 WHERE `entry`=19378 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16586 WHERE `entry`=19394 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16591 WHERE `entry`=19394 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16804 WHERE `entry`=19412 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20141 WHERE `entry`=19440 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17593 WHERE `entry`=19442 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16773 WHERE `entry`=19456 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16774 WHERE `entry`=19456 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20906 WHERE `entry`=19516 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20908 WHERE `entry`=19516 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20909 WHERE `entry`=19516 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20907 WHERE `entry`=19516 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16898 WHERE `entry`=19523 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16895 WHERE `entry`=19523 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16902 WHERE `entry`=19523 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16917 WHERE `entry`=19523 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16916 WHERE `entry`=19524 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16919 WHERE `entry`=19524 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16901 WHERE `entry`=19524 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=14044 WHERE `entry`=19524 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16903 WHERE `entry`=19524 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=16921 WHERE `entry`=19524 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17001 WHERE `entry`=19535 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19660 WHERE `entry`=19541 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=16985 WHERE `entry`=19606 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19073 WHERE `entry`=19606 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20195 WHERE `entry`=19622 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19006 WHERE `entry`=19622 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19053 WHERE `entry`=19622 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20204 WHERE `entry`=19622 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20205 WHERE `entry`=19622 AND `groupid`=9 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20202 WHERE `entry`=19622 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20201 WHERE `entry`=19622 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20207 WHERE `entry`=19622 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18621 WHERE `entry`=19664 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18616 WHERE `entry`=19664 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18617 WHERE `entry`=19664 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=17244 WHERE `entry`=19666 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17239 WHERE `entry`=19685 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17270 WHERE `entry`=19685 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17271 WHERE `entry`=19685 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17272 WHERE `entry`=19685 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17245 WHERE `entry`=19685 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17274 WHERE `entry`=19685 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17250 WHERE `entry`=19685 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17276 WHERE `entry`=19685 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17277 WHERE `entry`=19685 AND `groupid`=15 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17278 WHERE `entry`=19685 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17279 WHERE `entry`=19685 AND `groupid`=18 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17280 WHERE `entry`=19685 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17262 WHERE `entry`=19685 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20029 WHERE `entry`=19710 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20032 WHERE `entry`=19710 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20710 WHERE `entry`=19710 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17353 WHERE `entry`=19720 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17354 WHERE `entry`=19720 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18166 WHERE `entry`=19830 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18165 WHERE `entry`=19831 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18167 WHERE `entry`=19831 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17571 WHERE `entry`=19926 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19948 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19948 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19948 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19948 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19948 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19952 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19952 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19952 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19952 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19952 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19957 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19957 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19957 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19957 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19957 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19991 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19991 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19991 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19991 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19991 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19992 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19992 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19992 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19992 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19992 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19993 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19993 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19993 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19993 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19993 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19994 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19994 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19994 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19994 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19994 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19995 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19995 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19995 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19995 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19995 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19996 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19996 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19996 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19996 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19996 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19997 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19997 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19997 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19997 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19997 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=19998 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=19998 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=19998 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=19998 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=19998 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=20858 WHERE `entry`=20060 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20847 WHERE `entry`=20062 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20861 WHERE `entry`=20063 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11074 WHERE `entry`=20064 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=20095 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=20095 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=20095 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=20095 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=20095 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=18952 WHERE `entry`=20095 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18948 WHERE `entry`=20095 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18951 WHERE `entry`=20095 AND `groupid`=2 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=17596 WHERE `entry`=20100 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17657 WHERE `entry`=20129 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17658 WHERE `entry`=20129 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17659 WHERE `entry`=20129 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17660 WHERE `entry`=20129 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17661 WHERE `entry`=20129 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17663 WHERE `entry`=20129 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17664 WHERE `entry`=20129 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17662 WHERE `entry`=20129 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17665 WHERE `entry`=20129 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17666 WHERE `entry`=20129 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18155 WHERE `entry`=20209 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=20334 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=20334 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=20334 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=20334 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=20334 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=17993 WHERE `entry`=20342 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17992 WHERE `entry`=20342 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=18060 WHERE `entry`=20344 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18061 WHERE `entry`=20344 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17978 WHERE `entry`=20344 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17985 WHERE `entry`=20344 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17987 WHERE `entry`=20344 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17982 WHERE `entry`=20344 AND `groupid`=17 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17984 WHERE `entry`=20344 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17974 WHERE `entry`=20344 AND `groupid`=21 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=17975 WHERE `entry`=20344 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18041 WHERE `entry`=20353 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18043 WHERE `entry`=20353 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18155 WHERE `entry`=20417 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18155 WHERE `entry`=20418 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18155 WHERE `entry`=20440 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=20756 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=20756 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=20756 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=20756 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=20756 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=20765 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=20765 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=20765 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=20765 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=20765 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=20766 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=20766 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=20766 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=20766 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=20766 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=20768 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=20768 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=20768 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=20768 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=20768 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=20812 WHERE `entry`=20812 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20046 WHERE `entry`=20870 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20047 WHERE `entry`=20870 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20049 WHERE `entry`=20870 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20050 WHERE `entry`=20870 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19978 WHERE `entry`=20885 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19980 WHERE `entry`=20885 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19984 WHERE `entry`=20885 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19986 WHERE `entry`=20885 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19990 WHERE `entry`=20885 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19968 WHERE `entry`=20886 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19969 WHERE `entry`=20886 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19972 WHERE `entry`=20886 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19973 WHERE `entry`=20886 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19974 WHERE `entry`=20886 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19975 WHERE `entry`=20886 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19976 WHERE `entry`=20886 AND `groupid`=5 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=19977 WHERE `entry`=20886 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19103 WHERE `entry`=20904 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19104 WHERE `entry`=20904 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19107 WHERE `entry`=20904 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19109 WHERE `entry`=20904 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19813 WHERE `entry`=20912 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19814 WHERE `entry`=20912 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19818 WHERE `entry`=20912 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19819 WHERE `entry`=20912 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19824 WHERE `entry`=20977 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19825 WHERE `entry`=20977 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19827 WHERE `entry`=20977 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19828 WHERE `entry`=20977 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19829 WHERE `entry`=20977 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18668 WHERE `entry`=21027 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18669 WHERE `entry`=21027 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18715 WHERE `entry`=21066 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=18793 WHERE `entry`=21114 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=19140 WHERE `entry`=21118 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19453 WHERE `entry`=21118 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19455 WHERE `entry`=21118 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19093 WHERE `entry`=21118 AND `groupid`=6 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=20085 WHERE `entry`=21212 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19679 WHERE `entry`=21212 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20095 WHERE `entry`=21212 AND `groupid`=6 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=20933 WHERE `entry`=21213 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20934 WHERE `entry`=21213 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20938 WHERE `entry`=21213 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20939 WHERE `entry`=21213 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=20940 WHERE `entry`=21213 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20701 WHERE `entry`=21213 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20703 WHERE `entry`=21213 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20000 WHERE `entry`=21214 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20004 WHERE `entry`=21214 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19595 WHERE `entry`=21215 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19597 WHERE `entry`=21215 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19993 WHERE `entry`=21215 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19994 WHERE `entry`=21215 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19995 WHERE `entry`=21215 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=19996 WHERE `entry`=21215 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19997 WHERE `entry`=21215 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=19501 WHERE `entry`=21215 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19999 WHERE `entry`=21215 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20235 WHERE `entry`=21216 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20236 WHERE `entry`=21216 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20238 WHERE `entry`=21216 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20233 WHERE `entry`=21216 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20239 WHERE `entry`=21216 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=21238 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=21238 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=21238 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=21238 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=21238 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=21296 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=21296 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=21296 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=21296 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=21296 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=19179 WHERE `entry`=21409 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19158 WHERE `entry`=21469 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19187 WHERE `entry`=21504 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19188 WHERE `entry`=21504 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19191 WHERE `entry`=21504 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19162 WHERE `entry`=21504 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19163 WHERE `entry`=21504 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19194 WHERE `entry`=21504 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19170 WHERE `entry`=21504 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19610 WHERE `entry`=21769 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=19494 WHERE `entry`=21797 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21808 WHERE `entry`=22083 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=22160 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=22160 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=22160 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=22160 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=22160 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=21366 WHERE `entry`=22181 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20114 WHERE `entry`=22314 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20109 WHERE `entry`=22314 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=20166 WHERE `entry`=22381 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21050 WHERE `entry`=22384 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21033 WHERE `entry`=22384 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21049 WHERE `entry`=22384 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=21034 WHERE `entry`=22384 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=21035 WHERE `entry`=22384 AND `groupid`=1 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=20314 WHERE `entry`=22458 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20333 WHERE `entry`=22458 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20361 WHERE `entry`=22458 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20342 WHERE `entry`=22464 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20523 WHERE `entry`=22834 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20525 WHERE `entry`=22834 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20538 WHERE `entry`=22834 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21098 WHERE `entry`=22871 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21099 WHERE `entry`=22871 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21100 WHERE `entry`=22871 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=21101 WHERE `entry`=22871 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=21103 WHERE `entry`=22871 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21106 WHERE `entry`=22871 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21090 WHERE `entry`=22887 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=21091 WHERE `entry`=22887 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21092 WHERE `entry`=22887 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=21088 WHERE `entry`=22887 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21087 WHERE `entry`=22887 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=21095 WHERE `entry`=22887 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21096 WHERE `entry`=22887 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21093 WHERE `entry`=22887 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21959 WHERE `entry`=22898 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21019 WHERE `entry`=22898 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21499 WHERE `entry`=22917 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22036 WHERE `entry`=22917 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20757 WHERE `entry`=22924 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20756 WHERE `entry`=22924 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20648 WHERE `entry`=22940 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20783 WHERE `entry`=22940 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20664 WHERE `entry`=22940 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20784 WHERE `entry`=22940 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=20782 WHERE `entry`=22940 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=20781 WHERE `entry`=22940 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21770 WHERE `entry`=22947 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21777 WHERE `entry`=22947 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21741 WHERE `entry`=22948 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21743 WHERE `entry`=22948 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21738 WHERE `entry`=22949 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21737 WHERE `entry`=22949 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21732 WHERE `entry`=22950 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21730 WHERE `entry`=22950 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21729 WHERE `entry`=22950 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21713 WHERE `entry`=22951 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21707 WHERE `entry`=22952 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21704 WHERE `entry`=22952 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21699 WHERE `entry`=22952 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21703 WHERE `entry`=22952 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21785 WHERE `entry`=22990 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21784 WHERE `entry`=22990 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21344 WHERE `entry`=22990 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20768 WHERE `entry`=22992 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20770 WHERE `entry`=22993 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20771 WHERE `entry`=22994 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11074 WHERE `entry`=22997 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=20902 WHERE `entry`=23089 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21250 WHERE `entry`=23089 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21825 WHERE `entry`=23141 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21350 WHERE `entry`=23319 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21761 WHERE `entry`=23418 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21763 WHERE `entry`=23418 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=21753 WHERE `entry`=23419 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21754 WHERE `entry`=23419 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=21755 WHERE `entry`=23419 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21757 WHERE `entry`=23419 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21758 WHERE `entry`=23419 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21748 WHERE `entry`=23420 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=21751 WHERE `entry`=23420 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=21750 WHERE `entry`=23420 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23612 WHERE `entry`=23557 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23613 WHERE `entry`=23557 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23614 WHERE `entry`=23557 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=23308 WHERE `entry`=23574 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23236 WHERE `entry`=23574 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23587 WHERE `entry`=23578 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23314 WHERE `entry`=23578 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23313 WHERE `entry`=23578 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22589 WHERE `entry`=23579 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22052 WHERE `entry`=23602 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=22168 WHERE `entry`=23618 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=22167 WHERE `entry`=23618 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=22788 WHERE `entry`=23671 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23041 WHERE `entry`=23678 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23044 WHERE `entry`=23678 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28559 WHERE `entry`=23685 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28560 WHERE `entry`=23685 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=28561 WHERE `entry`=23685 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=6196 WHERE `entry`=23775 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23175 WHERE `entry`=23863 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23177 WHERE `entry`=23863 AND `groupid`=4 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`=22371 WHERE `entry`=23864 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22647 WHERE `entry`=24035 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=22641 WHERE `entry`=24035 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=22640 WHERE `entry`=24035 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=22649 WHERE `entry`=24035 AND `groupid`=0 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=22645 WHERE `entry`=24035 AND `groupid`=0 AND `id`=7; +UPDATE `creature_text` SET `BroadcastTextID`=22637 WHERE `entry`=24035 AND `groupid`=0 AND `id`=8; +UPDATE `creature_text` SET `BroadcastTextID`=22652 WHERE `entry`=24035 AND `groupid`=0 AND `id`=9; +UPDATE `creature_text` SET `BroadcastTextID`=22646 WHERE `entry`=24035 AND `groupid`=0 AND `id`=10; +UPDATE `creature_text` SET `BroadcastTextID`=22638 WHERE `entry`=24035 AND `groupid`=0 AND `id`=11; +UPDATE `creature_text` SET `BroadcastTextID`=22650 WHERE `entry`=24035 AND `groupid`=0 AND `id`=12; +UPDATE `creature_text` SET `BroadcastTextID`=22642 WHERE `entry`=24035 AND `groupid`=0 AND `id`=13; +UPDATE `creature_text` SET `BroadcastTextID`=22648 WHERE `entry`=24035 AND `groupid`=0 AND `id`=15; +UPDATE `creature_text` SET `BroadcastTextID`=22651 WHERE `entry`=24035 AND `groupid`=0 AND `id`=16; +UPDATE `creature_text` SET `BroadcastTextID`=35293 WHERE `entry`=24120 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=22834 WHERE `entry`=24120 AND `groupid`=0 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=29532 WHERE `entry`=24200 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29533 WHERE `entry`=24200 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24294 WHERE `entry`=24358 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23241 WHERE `entry`=24375 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23810 WHERE `entry`=24539 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23812 WHERE `entry`=24539 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25430 WHERE `entry`=24560 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25432 WHERE `entry`=24560 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25433 WHERE `entry`=24560 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25435 WHERE `entry`=24560 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25437 WHERE `entry`=24560 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25438 WHERE `entry`=24560 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25431 WHERE `entry`=24560 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23818 WHERE `entry`=24639 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23819 WHERE `entry`=24639 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23820 WHERE `entry`=24639 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25386 WHERE `entry`=24664 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25390 WHERE `entry`=24664 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25391 WHERE `entry`=24664 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25392 WHERE `entry`=24664 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25393 WHERE `entry`=24664 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27418 WHERE `entry`=24710 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27419 WHERE `entry`=24710 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27420 WHERE `entry`=24710 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27435 WHERE `entry`=24711 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27436 WHERE `entry`=24711 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27438 WHERE `entry`=24711 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23701 WHERE `entry`=24711 AND `groupid`=4 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=25425 WHERE `entry`=24723 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25426 WHERE `entry`=24723 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23753 WHERE `entry`=24723 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25623 WHERE `entry`=24744 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25625 WHERE `entry`=24744 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23752 WHERE `entry`=24744 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23830 WHERE `entry`=24788 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23821 WHERE `entry`=24788 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23822 WHERE `entry`=24788 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25496 WHERE `entry`=24850 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24429 WHERE `entry`=24875 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24432 WHERE `entry`=24877 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25223 WHERE `entry`=24882 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25220 WHERE `entry`=24882 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25628 WHERE `entry`=24882 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25635 WHERE `entry`=24882 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25636 WHERE `entry`=24882 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23981 WHERE `entry`=24891 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=23982 WHERE `entry`=24891 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25504 WHERE `entry`=24892 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25508 WHERE `entry`=24892 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25505 WHERE `entry`=24892 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25228 WHERE `entry`=24895 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25229 WHERE `entry`=24895 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24016 WHERE `entry`=24981 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24014 WHERE `entry`=24981 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=25643 WHERE `entry`=25038 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25261 WHERE `entry`=25038 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24175 WHERE `entry`=25132 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24173 WHERE `entry`=25144 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24184 WHERE `entry`=25144 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=24210 WHERE `entry`=25162 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24214 WHERE `entry`=25162 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24215 WHERE `entry`=25162 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24219 WHERE `entry`=25162 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24197 WHERE `entry`=25162 AND `groupid`=17 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24198 WHERE `entry`=25162 AND `groupid`=18 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24424 WHERE `entry`=25165 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25519 WHERE `entry`=25165 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24426 WHERE `entry`=25166 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25514 WHERE `entry`=25166 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25515 WHERE `entry`=25166 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=25518 WHERE `entry`=25166 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25517 WHERE `entry`=25166 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25245 WHERE `entry`=25248 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25246 WHERE `entry`=25248 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25244 WHERE `entry`=25248 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25847 WHERE `entry`=25250 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25842 WHERE `entry`=25251 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25848 WHERE `entry`=25251 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25849 WHERE `entry`=25251 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25549 WHERE `entry`=25315 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25550 WHERE `entry`=25315 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=25551 WHERE `entry`=25315 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25552 WHERE `entry`=25315 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=24808 WHERE `entry`=25315 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24825 WHERE `entry`=25315 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25199 WHERE `entry`=25315 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25705 WHERE `entry`=25315 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25822 WHERE `entry`=25319 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24822 WHERE `entry`=25319 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25190 WHERE `entry`=25319 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25191 WHERE `entry`=25319 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25192 WHERE `entry`=25319 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25193 WHERE `entry`=25319 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25194 WHERE `entry`=25319 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25541 WHERE `entry`=25319 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24601 WHERE `entry`=25322 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24599 WHERE `entry`=25322 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=24675 WHERE `entry`=25416 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24735 WHERE `entry`=25478 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24736 WHERE `entry`=25478 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24738 WHERE `entry`=25478 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24739 WHERE `entry`=25478 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24756 WHERE `entry`=25478 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24768 WHERE `entry`=25589 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25545 WHERE `entry`=25608 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=24873 WHERE `entry`=25678 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=27839 WHERE `entry`=25758 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24967 WHERE `entry`=25773 AND `groupid`=0 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=25000 WHERE `entry`=25814 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=25002 WHERE `entry`=25814 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=25245 WHERE `entry`=25827 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25246 WHERE `entry`=25827 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25244 WHERE `entry`=25827 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25245 WHERE `entry`=25828 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25246 WHERE `entry`=25828 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25244 WHERE `entry`=25828 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25085 WHERE `entry`=25885 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25196 WHERE `entry`=26046 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25198 WHERE `entry`=26046 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25366 WHERE `entry`=26170 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25845 WHERE `entry`=26170 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25846 WHERE `entry`=26170 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25850 WHERE `entry`=26170 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25362 WHERE `entry`=26203 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25363 WHERE `entry`=26203 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25364 WHERE `entry`=26203 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29941 WHERE `entry`=26529 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29949 WHERE `entry`=26530 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29950 WHERE `entry`=26530 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=29952 WHERE `entry`=26530 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31344 WHERE `entry`=26533 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31347 WHERE `entry`=26533 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31348 WHERE `entry`=26533 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31349 WHERE `entry`=26533 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=30412 WHERE `entry`=26533 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30413 WHERE `entry`=26533 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=30414 WHERE `entry`=26533 AND `groupid`=4 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=30415 WHERE `entry`=26533 AND `groupid`=4 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=31345 WHERE `entry`=26533 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31346 WHERE `entry`=26533 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=30275 WHERE `entry`=26533 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30276 WHERE `entry`=26533 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30277 WHERE `entry`=26533 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30278 WHERE `entry`=26533 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28528 WHERE `entry`=26533 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25806 WHERE `entry`=26588 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26891 WHERE `entry`=26588 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30041 WHERE `entry`=26630 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30042 WHERE `entry`=26630 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26932 WHERE `entry`=26631 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28035 WHERE `entry`=26631 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29611 WHERE `entry`=26632 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29612 WHERE `entry`=26632 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29616 WHERE `entry`=26632 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29617 WHERE `entry`=26632 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25866 WHERE `entry`=26648 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25957 WHERE `entry`=26654 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29676 WHERE `entry`=26668 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29677 WHERE `entry`=26668 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=29678 WHERE `entry`=26668 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29679 WHERE `entry`=26668 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31452 WHERE `entry`=26687 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31454 WHERE `entry`=26693 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31462 WHERE `entry`=26693 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=27809 WHERE `entry`=26693 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31463 WHERE `entry`=26693 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27809 WHERE `entry`=26693 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29597 WHERE `entry`=26731 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29594 WHERE `entry`=26731 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29607 WHERE `entry`=26794 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29627 WHERE `entry`=26796 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29628 WHERE `entry`=26796 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29629 WHERE `entry`=26796 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=24942 WHERE `entry`=26817 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31464 WHERE `entry`=26861 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31469 WHERE `entry`=26861 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31470 WHERE `entry`=26861 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31471 WHERE `entry`=26861 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=31472 WHERE `entry`=26861 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=31466 WHERE `entry`=26861 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31467 WHERE `entry`=26861 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31468 WHERE `entry`=26861 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26113 WHERE `entry`=26935 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26112 WHERE `entry`=26935 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26106 WHERE `entry`=26971 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26108 WHERE `entry`=26971 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26544 WHERE `entry`=27003 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26186 WHERE `entry`=27003 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26187 WHERE `entry`=27003 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26481 WHERE `entry`=27209 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26483 WHERE `entry`=27209 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26547 WHERE `entry`=27355 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26436 WHERE `entry`=27373 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26437 WHERE `entry`=27373 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26449 WHERE `entry`=27376 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26458 WHERE `entry`=27381 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29532 WHERE `entry`=27390 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29533 WHERE `entry`=27390 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26641 WHERE `entry`=27411 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=26539 WHERE `entry`=27411 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=26644 WHERE `entry`=27411 AND `groupid`=4 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=26716 WHERE `entry`=27455 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26718 WHERE `entry`=27455 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26732 WHERE `entry`=27455 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27207 WHERE `entry`=27455 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27211 WHERE `entry`=27455 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27214 WHERE `entry`=27455 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27215 WHERE `entry`=27455 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26657 WHERE `entry`=27463 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26659 WHERE `entry`=27463 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=26656 WHERE `entry`=27463 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=26717 WHERE `entry`=27480 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26731 WHERE `entry`=27480 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27209 WHERE `entry`=27480 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27212 WHERE `entry`=27480 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27217 WHERE `entry`=27480 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27218 WHERE `entry`=27480 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26684 WHERE `entry`=27482 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26682 WHERE `entry`=27482 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=26683 WHERE `entry`=27482 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=26865 WHERE `entry`=27619 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26867 WHERE `entry`=27624 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29960 WHERE `entry`=27629 AND `groupid`=0 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=28879 WHERE `entry`=27629 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31801 WHERE `entry`=27654 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31802 WHERE `entry`=27654 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31878 WHERE `entry`=27656 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31876 WHERE `entry`=27656 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=26937 WHERE `entry`=27658 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25992 WHERE `entry`=27692 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28136 WHERE `entry`=27692 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28255 WHERE `entry`=27692 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28259 WHERE `entry`=27692 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28257 WHERE `entry`=27692 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27032 WHERE `entry`=27719 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27027 WHERE `entry`=27726 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27028 WHERE `entry`=27726 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=27033 WHERE `entry`=27726 AND `groupid`=3 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=27030 WHERE `entry`=27727 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27031 WHERE `entry`=27727 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=25992 WHERE `entry`=27755 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28136 WHERE `entry`=27755 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28256 WHERE `entry`=27755 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28258 WHERE `entry`=27755 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28257 WHERE `entry`=27755 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25992 WHERE `entry`=27756 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28136 WHERE `entry`=27756 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28254 WHERE `entry`=27756 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28260 WHERE `entry`=27756 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28257 WHERE `entry`=27756 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27051 WHERE `entry`=27784 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27050 WHERE `entry`=27784 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27080 WHERE `entry`=27784 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27065 WHERE `entry`=27784 AND `groupid`=15 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27077 WHERE `entry`=27784 AND `groupid`=18 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27066 WHERE `entry`=27784 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27070 WHERE `entry`=27784 AND `groupid`=21 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27055 WHERE `entry`=27784 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27126 WHERE `entry`=27842 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=27128 WHERE `entry`=27842 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30163 WHERE `entry`=27842 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27239 WHERE `entry`=27899 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27251 WHERE `entry`=27899 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27306 WHERE `entry`=27899 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27305 WHERE `entry`=27899 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27287 WHERE `entry`=27899 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29563 WHERE `entry`=27975 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29567 WHERE `entry`=27975 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=29568 WHERE `entry`=27975 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=29574 WHERE `entry`=27975 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29558 WHERE `entry`=27977 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29582 WHERE `entry`=27978 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29586 WHERE `entry`=27978 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37770 WHERE `entry`=27990 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28079 WHERE `entry`=28012 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27389 WHERE `entry`=28012 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=27452 WHERE `entry`=28041 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=35005 WHERE `entry`=28041 AND `groupid`=0 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=27513 WHERE `entry`=28068 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=27508 WHERE `entry`=28068 AND `groupid`=2 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=30525 WHERE `entry`=28070 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30526 WHERE `entry`=28070 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=28121 WHERE `entry`=28070 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30522 WHERE `entry`=28070 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30562 WHERE `entry`=28070 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30563 WHERE `entry`=28070 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31555 WHERE `entry`=28070 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27589 WHERE `entry`=28070 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27591 WHERE `entry`=28070 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30523 WHERE `entry`=28070 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30559 WHERE `entry`=28070 AND `groupid`=17 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30560 WHERE `entry`=28070 AND `groupid`=18 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30565 WHERE `entry`=28070 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30566 WHERE `entry`=28070 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30567 WHERE `entry`=28070 AND `groupid`=21 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30568 WHERE `entry`=28070 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30577 WHERE `entry`=28070 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30578 WHERE `entry`=28070 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30580 WHERE `entry`=28070 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30582 WHERE `entry`=28070 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30583 WHERE `entry`=28070 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30584 WHERE `entry`=28070 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27497 WHERE `entry`=28090 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=27496 WHERE `entry`=28090 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=29932 WHERE `entry`=28103 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28904 WHERE `entry`=28113 AND `groupid`=0 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=28293 WHERE `entry`=28120 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28289 WHERE `entry`=28120 AND `groupid`=2 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=28340 WHERE `entry`=28120 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28279 WHERE `entry`=28120 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28317 WHERE `entry`=28121 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=28353 WHERE `entry`=28121 AND `groupid`=4 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=28368 WHERE `entry`=28122 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=28365 WHERE `entry`=28122 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=28377 WHERE `entry`=28122 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28384 WHERE `entry`=28122 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=28393 WHERE `entry`=28122 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28391 WHERE `entry`=28122 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=28392 WHERE `entry`=28122 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=28873 WHERE `entry`=28122 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25358 WHERE `entry`=28189 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=25361 WHERE `entry`=28189 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27690 WHERE `entry`=28205 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27685 WHERE `entry`=28205 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=27990 WHERE `entry`=28214 AND `groupid`=3 AND `id`=7; +UPDATE `creature_text` SET `BroadcastTextID`=27981 WHERE `entry`=28214 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28163 WHERE `entry`=28215 AND `groupid`=1 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=28143 WHERE `entry`=28215 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=28186 WHERE `entry`=28215 AND `groupid`=2 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=28185 WHERE `entry`=28215 AND `groupid`=3 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=28161 WHERE `entry`=28215 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28139 WHERE `entry`=28215 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28233 WHERE `entry`=28216 AND `groupid`=2 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=27699 WHERE `entry`=28256 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=27761 WHERE `entry`=28328 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=27803 WHERE `entry`=28355 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29267 WHERE `entry`=28406 AND `groupid`=0 AND `id`=8; +UPDATE `creature_text` SET `BroadcastTextID`=28098 WHERE `entry`=28486 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28097 WHERE `entry`=28486 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=28100 WHERE `entry`=28486 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=28458 WHERE `entry`=28521 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=30531 WHERE `entry`=28546 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30532 WHERE `entry`=28546 AND `groupid`=2 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=30533 WHERE `entry`=28546 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=29015 WHERE `entry`=28557 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29016 WHERE `entry`=28557 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29012 WHERE `entry`=28557 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=28515 WHERE `entry`=28566 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31411 WHERE `entry`=28586 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31421 WHERE `entry`=28587 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29968 WHERE `entry`=28601 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29142 WHERE `entry`=28610 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29150 WHERE `entry`=28610 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29151 WHERE `entry`=28610 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29152 WHERE `entry`=28610 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29135 WHERE `entry`=28610 AND `groupid`=8 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=29137 WHERE `entry`=28610 AND `groupid`=8 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=29133 WHERE `entry`=28610 AND `groupid`=8 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=29136 WHERE `entry`=28610 AND `groupid`=8 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=28647 WHERE `entry`=28659 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28650 WHERE `entry`=28659 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28936 WHERE `entry`=28667 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32271 WHERE `entry`=28684 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32283 WHERE `entry`=28684 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32281 WHERE `entry`=28684 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32282 WHERE `entry`=28684 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=32278 WHERE `entry`=28684 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32275 WHERE `entry`=28684 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28701 WHERE `entry`=28717 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=28856 WHERE `entry`=28787 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31764 WHERE `entry`=28859 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31767 WHERE `entry`=28859 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31768 WHERE `entry`=28859 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31773 WHERE `entry`=28859 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31774 WHERE `entry`=28859 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31775 WHERE `entry`=28859 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31778 WHERE `entry`=28859 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31779 WHERE `entry`=28859 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33657 WHERE `entry`=28859 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31784 WHERE `entry`=28859 AND `groupid`=15 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31785 WHERE `entry`=28859 AND `groupid`=15 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31786 WHERE `entry`=28859 AND `groupid`=15 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=31787 WHERE `entry`=28859 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31318 WHERE `entry`=28860 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31320 WHERE `entry`=28860 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31909 WHERE `entry`=28860 AND `groupid`=8 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31910 WHERE `entry`=28860 AND `groupid`=8 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=7798 WHERE `entry`=28902 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29048 WHERE `entry`=28907 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29049 WHERE `entry`=28907 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29051 WHERE `entry`=28907 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29052 WHERE `entry`=28907 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29208 WHERE `entry`=28912 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29142 WHERE `entry`=28939 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29150 WHERE `entry`=28939 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29151 WHERE `entry`=28939 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29152 WHERE `entry`=28939 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29135 WHERE `entry`=28939 AND `groupid`=8 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=29137 WHERE `entry`=28939 AND `groupid`=8 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=29133 WHERE `entry`=28939 AND `groupid`=8 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=29136 WHERE `entry`=28939 AND `groupid`=8 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=29142 WHERE `entry`=28940 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29150 WHERE `entry`=28940 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29151 WHERE `entry`=28940 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29152 WHERE `entry`=28940 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29135 WHERE `entry`=28940 AND `groupid`=8 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=29137 WHERE `entry`=28940 AND `groupid`=8 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=29133 WHERE `entry`=28940 AND `groupid`=8 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=29136 WHERE `entry`=28940 AND `groupid`=8 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=29128 WHERE `entry`=28948 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29433 WHERE `entry`=28948 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29437 WHERE `entry`=28948 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29223 WHERE `entry`=29001 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29338 WHERE `entry`=29032 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29289 WHERE `entry`=29032 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29339 WHERE `entry`=29032 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29397 WHERE `entry`=29032 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29314 WHERE `entry`=29032 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29326 WHERE `entry`=29032 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29387 WHERE `entry`=29032 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29407 WHERE `entry`=29032 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29398 WHERE `entry`=29032 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29328 WHERE `entry`=29032 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29374 WHERE `entry`=29032 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29362 WHERE `entry`=29032 AND `groupid`=30 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29340 WHERE `entry`=29032 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29352 WHERE `entry`=29032 AND `groupid`=32 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29315 WHERE `entry`=29032 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29388 WHERE `entry`=29032 AND `groupid`=34 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29294 WHERE `entry`=29032 AND `groupid`=35 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29408 WHERE `entry`=29032 AND `groupid`=36 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29341 WHERE `entry`=29032 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29329 WHERE `entry`=29032 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29409 WHERE `entry`=29032 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29376 WHERE `entry`=29032 AND `groupid`=42 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29342 WHERE `entry`=29032 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29317 WHERE `entry`=29032 AND `groupid`=47 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29410 WHERE `entry`=29032 AND `groupid`=51 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29303 WHERE `entry`=29032 AND `groupid`=53 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29338 WHERE `entry`=29061 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29289 WHERE `entry`=29061 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29339 WHERE `entry`=29061 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29397 WHERE `entry`=29061 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29314 WHERE `entry`=29061 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29326 WHERE `entry`=29061 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29387 WHERE `entry`=29061 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29407 WHERE `entry`=29061 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29398 WHERE `entry`=29061 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29328 WHERE `entry`=29061 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29374 WHERE `entry`=29061 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29362 WHERE `entry`=29061 AND `groupid`=30 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29340 WHERE `entry`=29061 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29352 WHERE `entry`=29061 AND `groupid`=32 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29315 WHERE `entry`=29061 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29388 WHERE `entry`=29061 AND `groupid`=34 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29294 WHERE `entry`=29061 AND `groupid`=35 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29408 WHERE `entry`=29061 AND `groupid`=36 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29341 WHERE `entry`=29061 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29329 WHERE `entry`=29061 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29409 WHERE `entry`=29061 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29376 WHERE `entry`=29061 AND `groupid`=42 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29342 WHERE `entry`=29061 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29317 WHERE `entry`=29061 AND `groupid`=47 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29410 WHERE `entry`=29061 AND `groupid`=51 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29319 WHERE `entry`=29061 AND `groupid`=53 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29338 WHERE `entry`=29065 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29289 WHERE `entry`=29065 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29339 WHERE `entry`=29065 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29397 WHERE `entry`=29065 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29314 WHERE `entry`=29065 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29326 WHERE `entry`=29065 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29387 WHERE `entry`=29065 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29407 WHERE `entry`=29065 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29398 WHERE `entry`=29065 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29328 WHERE `entry`=29065 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29374 WHERE `entry`=29065 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29362 WHERE `entry`=29065 AND `groupid`=30 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29340 WHERE `entry`=29065 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29352 WHERE `entry`=29065 AND `groupid`=32 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29315 WHERE `entry`=29065 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29388 WHERE `entry`=29065 AND `groupid`=34 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29294 WHERE `entry`=29065 AND `groupid`=35 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29408 WHERE `entry`=29065 AND `groupid`=36 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29341 WHERE `entry`=29065 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29329 WHERE `entry`=29065 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29409 WHERE `entry`=29065 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29376 WHERE `entry`=29065 AND `groupid`=42 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29342 WHERE `entry`=29065 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29317 WHERE `entry`=29065 AND `groupid`=47 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29410 WHERE `entry`=29065 AND `groupid`=51 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29319 WHERE `entry`=29065 AND `groupid`=53 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29338 WHERE `entry`=29067 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29289 WHERE `entry`=29067 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29339 WHERE `entry`=29067 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29397 WHERE `entry`=29067 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29314 WHERE `entry`=29067 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29326 WHERE `entry`=29067 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29387 WHERE `entry`=29067 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29407 WHERE `entry`=29067 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29398 WHERE `entry`=29067 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29328 WHERE `entry`=29067 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29374 WHERE `entry`=29067 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29362 WHERE `entry`=29067 AND `groupid`=30 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29340 WHERE `entry`=29067 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29352 WHERE `entry`=29067 AND `groupid`=32 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29315 WHERE `entry`=29067 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29388 WHERE `entry`=29067 AND `groupid`=34 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29294 WHERE `entry`=29067 AND `groupid`=35 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29408 WHERE `entry`=29067 AND `groupid`=36 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29341 WHERE `entry`=29067 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29329 WHERE `entry`=29067 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29409 WHERE `entry`=29067 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29376 WHERE `entry`=29067 AND `groupid`=42 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29342 WHERE `entry`=29067 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29317 WHERE `entry`=29067 AND `groupid`=47 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29410 WHERE `entry`=29067 AND `groupid`=51 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29303 WHERE `entry`=29067 AND `groupid`=53 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29338 WHERE `entry`=29068 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29289 WHERE `entry`=29068 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29339 WHERE `entry`=29068 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29397 WHERE `entry`=29068 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29314 WHERE `entry`=29068 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29326 WHERE `entry`=29068 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29387 WHERE `entry`=29068 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29407 WHERE `entry`=29068 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29398 WHERE `entry`=29068 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29328 WHERE `entry`=29068 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29374 WHERE `entry`=29068 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29362 WHERE `entry`=29068 AND `groupid`=30 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29340 WHERE `entry`=29068 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29352 WHERE `entry`=29068 AND `groupid`=32 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29315 WHERE `entry`=29068 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29388 WHERE `entry`=29068 AND `groupid`=34 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29294 WHERE `entry`=29068 AND `groupid`=35 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29408 WHERE `entry`=29068 AND `groupid`=36 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29341 WHERE `entry`=29068 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29329 WHERE `entry`=29068 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29409 WHERE `entry`=29068 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29376 WHERE `entry`=29068 AND `groupid`=42 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29342 WHERE `entry`=29068 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29317 WHERE `entry`=29068 AND `groupid`=47 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29410 WHERE `entry`=29068 AND `groupid`=51 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29303 WHERE `entry`=29068 AND `groupid`=53 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29338 WHERE `entry`=29070 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29289 WHERE `entry`=29070 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29339 WHERE `entry`=29070 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29397 WHERE `entry`=29070 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29314 WHERE `entry`=29070 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29326 WHERE `entry`=29070 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29387 WHERE `entry`=29070 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29407 WHERE `entry`=29070 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29398 WHERE `entry`=29070 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29328 WHERE `entry`=29070 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29374 WHERE `entry`=29070 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29362 WHERE `entry`=29070 AND `groupid`=30 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29340 WHERE `entry`=29070 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29352 WHERE `entry`=29070 AND `groupid`=32 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29315 WHERE `entry`=29070 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29388 WHERE `entry`=29070 AND `groupid`=34 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29294 WHERE `entry`=29070 AND `groupid`=35 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29408 WHERE `entry`=29070 AND `groupid`=36 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29341 WHERE `entry`=29070 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29329 WHERE `entry`=29070 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29409 WHERE `entry`=29070 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29376 WHERE `entry`=29070 AND `groupid`=42 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29342 WHERE `entry`=29070 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29317 WHERE `entry`=29070 AND `groupid`=47 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29410 WHERE `entry`=29070 AND `groupid`=51 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29303 WHERE `entry`=29070 AND `groupid`=53 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29338 WHERE `entry`=29071 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29289 WHERE `entry`=29071 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29339 WHERE `entry`=29071 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29397 WHERE `entry`=29071 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29314 WHERE `entry`=29071 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29326 WHERE `entry`=29071 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29387 WHERE `entry`=29071 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29407 WHERE `entry`=29071 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29398 WHERE `entry`=29071 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29328 WHERE `entry`=29071 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29374 WHERE `entry`=29071 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29362 WHERE `entry`=29071 AND `groupid`=30 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29340 WHERE `entry`=29071 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29352 WHERE `entry`=29071 AND `groupid`=32 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29315 WHERE `entry`=29071 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29388 WHERE `entry`=29071 AND `groupid`=34 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29294 WHERE `entry`=29071 AND `groupid`=35 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29408 WHERE `entry`=29071 AND `groupid`=36 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29341 WHERE `entry`=29071 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29329 WHERE `entry`=29071 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29409 WHERE `entry`=29071 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29376 WHERE `entry`=29071 AND `groupid`=42 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29342 WHERE `entry`=29071 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29317 WHERE `entry`=29071 AND `groupid`=47 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29410 WHERE `entry`=29071 AND `groupid`=51 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29303 WHERE `entry`=29071 AND `groupid`=53 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29338 WHERE `entry`=29072 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29289 WHERE `entry`=29072 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29339 WHERE `entry`=29072 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29397 WHERE `entry`=29072 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29314 WHERE `entry`=29072 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29326 WHERE `entry`=29072 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29387 WHERE `entry`=29072 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29407 WHERE `entry`=29072 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29398 WHERE `entry`=29072 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29328 WHERE `entry`=29072 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29374 WHERE `entry`=29072 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29362 WHERE `entry`=29072 AND `groupid`=30 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29340 WHERE `entry`=29072 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29352 WHERE `entry`=29072 AND `groupid`=32 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29315 WHERE `entry`=29072 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29388 WHERE `entry`=29072 AND `groupid`=34 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29294 WHERE `entry`=29072 AND `groupid`=35 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29408 WHERE `entry`=29072 AND `groupid`=36 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29341 WHERE `entry`=29072 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29329 WHERE `entry`=29072 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29409 WHERE `entry`=29072 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29376 WHERE `entry`=29072 AND `groupid`=42 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29342 WHERE `entry`=29072 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29317 WHERE `entry`=29072 AND `groupid`=47 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29410 WHERE `entry`=29072 AND `groupid`=51 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29303 WHERE `entry`=29072 AND `groupid`=53 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29338 WHERE `entry`=29073 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29289 WHERE `entry`=29073 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29339 WHERE `entry`=29073 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29397 WHERE `entry`=29073 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29314 WHERE `entry`=29073 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29326 WHERE `entry`=29073 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29387 WHERE `entry`=29073 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29407 WHERE `entry`=29073 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29398 WHERE `entry`=29073 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29328 WHERE `entry`=29073 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29374 WHERE `entry`=29073 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29362 WHERE `entry`=29073 AND `groupid`=30 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29340 WHERE `entry`=29073 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29352 WHERE `entry`=29073 AND `groupid`=32 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29315 WHERE `entry`=29073 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29388 WHERE `entry`=29073 AND `groupid`=34 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29294 WHERE `entry`=29073 AND `groupid`=35 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29408 WHERE `entry`=29073 AND `groupid`=36 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29341 WHERE `entry`=29073 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29329 WHERE `entry`=29073 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29409 WHERE `entry`=29073 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29376 WHERE `entry`=29073 AND `groupid`=42 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29342 WHERE `entry`=29073 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29317 WHERE `entry`=29073 AND `groupid`=47 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29410 WHERE `entry`=29073 AND `groupid`=51 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29303 WHERE `entry`=29073 AND `groupid`=53 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29338 WHERE `entry`=29074 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29289 WHERE `entry`=29074 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29339 WHERE `entry`=29074 AND `groupid`=19 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29397 WHERE `entry`=29074 AND `groupid`=20 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29314 WHERE `entry`=29074 AND `groupid`=22 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29326 WHERE `entry`=29074 AND `groupid`=23 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29387 WHERE `entry`=29074 AND `groupid`=24 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29407 WHERE `entry`=29074 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29398 WHERE `entry`=29074 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29328 WHERE `entry`=29074 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29374 WHERE `entry`=29074 AND `groupid`=29 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29362 WHERE `entry`=29074 AND `groupid`=30 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29340 WHERE `entry`=29074 AND `groupid`=31 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29352 WHERE `entry`=29074 AND `groupid`=32 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29315 WHERE `entry`=29074 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29388 WHERE `entry`=29074 AND `groupid`=34 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29294 WHERE `entry`=29074 AND `groupid`=35 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29408 WHERE `entry`=29074 AND `groupid`=36 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29341 WHERE `entry`=29074 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29329 WHERE `entry`=29074 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29409 WHERE `entry`=29074 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29376 WHERE `entry`=29074 AND `groupid`=42 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29342 WHERE `entry`=29074 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29317 WHERE `entry`=29074 AND `groupid`=47 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29410 WHERE `entry`=29074 AND `groupid`=51 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29319 WHERE `entry`=29074 AND `groupid`=53 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32308 WHERE `entry`=29120 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32311 WHERE `entry`=29120 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32309 WHERE `entry`=29120 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=32317 WHERE `entry`=29120 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32314 WHERE `entry`=29120 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32316 WHERE `entry`=29120 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=32313 WHERE `entry`=29120 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=29694 WHERE `entry`=29173 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29696 WHERE `entry`=29173 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29722 WHERE `entry`=29173 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29731 WHERE `entry`=29173 AND `groupid`=8 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=29738 WHERE `entry`=29173 AND `groupid`=8 AND `id`=11; +UPDATE `creature_text` SET `BroadcastTextID`=29740 WHERE `entry`=29173 AND `groupid`=8 AND `id`=13; +UPDATE `creature_text` SET `BroadcastTextID`=29760 WHERE `entry`=29173 AND `groupid`=26 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29768 WHERE `entry`=29173 AND `groupid`=33 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29781 WHERE `entry`=29173 AND `groupid`=43 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29851 WHERE `entry`=29173 AND `groupid`=67 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29744 WHERE `entry`=29175 AND `groupid`=27 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29745 WHERE `entry`=29175 AND `groupid`=28 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29835 WHERE `entry`=29175 AND `groupid`=59 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29843 WHERE `entry`=29175 AND `groupid`=60 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29845 WHERE `entry`=29175 AND `groupid`=61 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29846 WHERE `entry`=29175 AND `groupid`=62 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29848 WHERE `entry`=29175 AND `groupid`=64 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29849 WHERE `entry`=29175 AND `groupid`=65 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29850 WHERE `entry`=29175 AND `groupid`=66 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29780 WHERE `entry`=29183 AND `groupid`=44 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29785 WHERE `entry`=29183 AND `groupid`=48 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29826 WHERE `entry`=29183 AND `groupid`=57 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29827 WHERE `entry`=29183 AND `groupid`=58 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29870 WHERE `entry`=29196 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29875 WHERE `entry`=29196 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29758 WHERE `entry`=29204 AND `groupid`=71 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29775 WHERE `entry`=29227 AND `groupid`=38 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29777 WHERE `entry`=29227 AND `groupid`=40 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29776 WHERE `entry`=29228 AND `groupid`=39 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31805 WHERE `entry`=29266 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31337 WHERE `entry`=29266 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29688 WHERE `entry`=29280 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31713 WHERE `entry`=29304 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31430 WHERE `entry`=29305 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=30388 WHERE `entry`=29305 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32535 WHERE `entry`=29306 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31895 WHERE `entry`=29308 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31901 WHERE `entry`=29308 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31902 WHERE `entry`=29308 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=31899 WHERE `entry`=29308 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31897 WHERE `entry`=29308 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31888 WHERE `entry`=29309 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31891 WHERE `entry`=29309 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31886 WHERE `entry`=29309 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31703 WHERE `entry`=29310 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=32052 WHERE `entry`=29313 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=31822 WHERE `entry`=29315 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31823 WHERE `entry`=29315 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31824 WHERE `entry`=29315 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=30238 WHERE `entry`=29369 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30646 WHERE `entry`=29434 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30140 WHERE `entry`=29466 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30139 WHERE `entry`=29466 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=30141 WHERE `entry`=29466 AND `groupid`=0 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=30209 WHERE `entry`=29519 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30205 WHERE `entry`=29519 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30214 WHERE `entry`=29519 AND `groupid`=1 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=30209 WHERE `entry`=29520 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30205 WHERE `entry`=29520 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30214 WHERE `entry`=29520 AND `groupid`=1 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=30209 WHERE `entry`=29565 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30205 WHERE `entry`=29565 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30214 WHERE `entry`=29565 AND `groupid`=1 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=30209 WHERE `entry`=29566 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30205 WHERE `entry`=29566 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30214 WHERE `entry`=29566 AND `groupid`=1 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=30209 WHERE `entry`=29567 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30205 WHERE `entry`=29567 AND `groupid`=1 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30214 WHERE `entry`=29567 AND `groupid`=1 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=30625 WHERE `entry`=29579 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30622 WHERE `entry`=29579 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30631 WHERE `entry`=29579 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30400 WHERE `entry`=29686 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=30484 WHERE `entry`=29881 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=30488 WHERE `entry`=29881 AND `groupid`=0 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=30511 WHERE `entry`=29884 AND `groupid`=8 AND `id`=8; +UPDATE `creature_text` SET `BroadcastTextID`=30511 WHERE `entry`=29884 AND `groupid`=9 AND `id`=9; +UPDATE `creature_text` SET `BroadcastTextID`=30712 WHERE `entry`=29919 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30715 WHERE `entry`=30007 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30687 WHERE `entry`=30007 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30832 WHERE `entry`=30098 AND `groupid`=0 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=30833 WHERE `entry`=30098 AND `groupid`=0 AND `id`=4; +UPDATE `creature_text` SET `BroadcastTextID`=30834 WHERE `entry`=30098 AND `groupid`=0 AND `id`=5; +UPDATE `creature_text` SET `BroadcastTextID`=30835 WHERE `entry`=30098 AND `groupid`=0 AND `id`=6; +UPDATE `creature_text` SET `BroadcastTextID`=30836 WHERE `entry`=30098 AND `groupid`=0 AND `id`=7; +UPDATE `creature_text` SET `BroadcastTextID`=30793 WHERE `entry`=30146 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30794 WHERE `entry`=30146 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=30848 WHERE `entry`=30190 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30850 WHERE `entry`=30190 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30854 WHERE `entry`=30190 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30986 WHERE `entry`=30292 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31499 WHERE `entry`=30313 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31506 WHERE `entry`=30313 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31507 WHERE `entry`=30313 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31517 WHERE `entry`=30313 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36993 WHERE `entry`=30344 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36997 WHERE `entry`=30344 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31006 WHERE `entry`=30377 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31007 WHERE `entry`=30377 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31015 WHERE `entry`=30377 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31017 WHERE `entry`=30377 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31173 WHERE `entry`=30404 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32002 WHERE `entry`=30449 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32003 WHERE `entry`=30449 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32008 WHERE `entry`=30449 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32006 WHERE `entry`=30449 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32007 WHERE `entry`=30449 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31986 WHERE `entry`=30451 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31987 WHERE `entry`=30451 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31991 WHERE `entry`=30451 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31989 WHERE `entry`=30451 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31993 WHERE `entry`=30452 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31995 WHERE `entry`=30452 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31999 WHERE `entry`=30452 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31997 WHERE `entry`=30452 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31161 WHERE `entry`=30462 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13058 WHERE `entry`=30549 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13059 WHERE `entry`=30549 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=33116 WHERE `entry`=30549 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31474 WHERE `entry`=30658 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36997 WHERE `entry`=30824 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31487 WHERE `entry`=30840 AND `groupid`=2 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=31488 WHERE `entry`=30840 AND `groupid`=3 AND `id`=3; +UPDATE `creature_text` SET `BroadcastTextID`=31523 WHERE `entry`=30884 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=31539 WHERE `entry`=30891 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29576 WHERE `entry`=30897 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30606 WHERE `entry`=30897 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30607 WHERE `entry`=30897 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29575 WHERE `entry`=30898 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30603 WHERE `entry`=30898 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30604 WHERE `entry`=30898 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30605 WHERE `entry`=30898 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29561 WHERE `entry`=30899 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29579 WHERE `entry`=30899 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=29580 WHERE `entry`=30899 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30611 WHERE `entry`=30899 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30612 WHERE `entry`=30899 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30613 WHERE `entry`=30899 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=30614 WHERE `entry`=30899 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31858 WHERE `entry`=30956 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31584 WHERE `entry`=30994 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=34057 WHERE `entry`=31125 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33085 WHERE `entry`=31125 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31727 WHERE `entry`=31134 AND `groupid`=1 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=31892 WHERE `entry`=31135 AND `groupid`=9 AND `id`=9; +UPDATE `creature_text` SET `BroadcastTextID`=31885 WHERE `entry`=31135 AND `groupid`=12 AND `id`=12; +UPDATE `creature_text` SET `BroadcastTextID`=31931 WHERE `entry`=31135 AND `groupid`=15 AND `id`=15; +UPDATE `creature_text` SET `BroadcastTextID`=31938 WHERE `entry`=31135 AND `groupid`=16 AND `id`=16; +UPDATE `creature_text` SET `BroadcastTextID`=31939 WHERE `entry`=31135 AND `groupid`=17 AND `id`=17; +UPDATE `creature_text` SET `BroadcastTextID`=31949 WHERE `entry`=31135 AND `groupid`=20 AND `id`=20; +UPDATE `creature_text` SET `BroadcastTextID`=31858 WHERE `entry`=31161 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31935 WHERE `entry`=31277 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=31944 WHERE `entry`=31279 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32628 WHERE `entry`=32295 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=32874 WHERE `entry`=32443 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=11298 WHERE `entry`=32845 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34314 WHERE `entry`=32857 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34318 WHERE `entry`=32857 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33145 WHERE `entry`=32865 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33270 WHERE `entry`=32865 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=34239 WHERE `entry`=32865 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33274 WHERE `entry`=32865 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33950 WHERE `entry`=32865 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33952 WHERE `entry`=32865 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34014 WHERE `entry`=32871 AND `groupid`=18 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33605 WHERE `entry`=32906 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34130 WHERE `entry`=32914 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=34119 WHERE `entry`=32915 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=34332 WHERE `entry`=32927 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34334 WHERE `entry`=32927 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33490 WHERE `entry`=33113 AND `groupid`=3 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=33492 WHERE `entry`=33113 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33504 WHERE `entry`=33113 AND `groupid`=11 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=33505 WHERE `entry`=33113 AND `groupid`=11 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=34307 WHERE `entry`=33118 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34311 WHERE `entry`=33118 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34312 WHERE `entry`=33118 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=34342 WHERE `entry`=33134 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34349 WHERE `entry`=33134 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=33351 WHERE `entry`=33210 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34369 WHERE `entry`=33242 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34050 WHERE `entry`=33271 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34052 WHERE `entry`=33271 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34056 WHERE `entry`=33271 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33471 WHERE `entry`=33271 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34359 WHERE `entry`=33280 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34363 WHERE `entry`=33280 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34364 WHERE `entry`=33280 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=34360 WHERE `entry`=33288 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34298 WHERE `entry`=33350 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34244 WHERE `entry`=33350 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33636 WHERE `entry`=33350 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34300 WHERE `entry`=33350 AND `groupid`=3 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=33668 WHERE `entry`=33350 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33966 WHERE `entry`=33350 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34033 WHERE `entry`=33350 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34305 WHERE `entry`=33350 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33664 WHERE `entry`=33436 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33670 WHERE `entry`=33437 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33609 WHERE `entry`=33441 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34354 WHERE `entry`=33515 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=33656 WHERE `entry`=33523 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34674 WHERE `entry`=33533 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33616 WHERE `entry`=33552 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34188 WHERE `entry`=33552 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=33813 WHERE `entry`=33788 AND `groupid`=0 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=34034 WHERE `entry`=33972 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34032 WHERE `entry`=33973 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34035 WHERE `entry`=33974 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34511 WHERE `entry`=33993 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=34057 WHERE `entry`=33993 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35031 WHERE `entry`=34715 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35194 WHERE `entry`=34780 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35195 WHERE `entry`=34780 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35227 WHERE `entry`=34980 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35692 WHERE `entry`=34990 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35703 WHERE `entry`=34995 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35696 WHERE `entry`=34995 AND `groupid`=6 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=35697 WHERE `entry`=34995 AND `groupid`=6 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=35717 WHERE `entry`=34996 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35338 WHERE `entry`=35005 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35335 WHERE `entry`=35005 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35334 WHERE `entry`=35005 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35337 WHERE `entry`=35005 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35336 WHERE `entry`=35005 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35759 WHERE `entry`=35119 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35760 WHERE `entry`=35119 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=35360 WHERE `entry`=35127 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35818 WHERE `entry`=35476 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=35977 WHERE `entry`=35642 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36531 WHERE `entry`=36476 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36529 WHERE `entry`=36476 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37222 WHERE `entry`=36477 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37223 WHERE `entry`=36477 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37224 WHERE `entry`=36477 AND `groupid`=1 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=36550 WHERE `entry`=36477 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36536 WHERE `entry`=36477 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37225 WHERE `entry`=36477 AND `groupid`=5 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=37226 WHERE `entry`=36477 AND `groupid`=5 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=36842 WHERE `entry`=36477 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38486 WHERE `entry`=36497 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38490 WHERE `entry`=36497 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38489 WHERE `entry`=36497 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38547 WHERE `entry`=36502 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38547 WHERE `entry`=36502 AND `groupid`=4 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=38547 WHERE `entry`=36502 AND `groupid`=4 AND `id`=2; +UPDATE `creature_text` SET `BroadcastTextID`=37368 WHERE `entry`=36502 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36659 WHERE `entry`=36502 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36658 WHERE `entry`=36502 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38020 WHERE `entry`=36502 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38020 WHERE `entry`=36502 AND `groupid`=9 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=38073 WHERE `entry`=36597 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38046 WHERE `entry`=36597 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38043 WHERE `entry`=36597 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38038 WHERE `entry`=36597 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38041 WHERE `entry`=36597 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39695 WHERE `entry`=36597 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38075 WHERE `entry`=36597 AND `groupid`=15 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38076 WHERE `entry`=36597 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38078 WHERE `entry`=36597 AND `groupid`=18 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39004 WHERE `entry`=36597 AND `groupid`=21 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37688 WHERE `entry`=36612 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36553 WHERE `entry`=36612 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37830 WHERE `entry`=36626 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37823 WHERE `entry`=36626 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37829 WHERE `entry`=36626 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37836 WHERE `entry`=36627 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37064 WHERE `entry`=36627 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37063 WHERE `entry`=36627 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37833 WHERE `entry`=36627 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37834 WHERE `entry`=36627 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37872 WHERE `entry`=36627 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36708 WHERE `entry`=36658 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36714 WHERE `entry`=36658 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37234 WHERE `entry`=36658 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38718 WHERE `entry`=36658 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38715 WHERE `entry`=36658 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38716 WHERE `entry`=36658 AND `groupid`=9 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=38714 WHERE `entry`=36658 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36628 WHERE `entry`=36658 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37843 WHERE `entry`=36678 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37848 WHERE `entry`=36678 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37847 WHERE `entry`=36678 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37846 WHERE `entry`=36678 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37844 WHERE `entry`=36678 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38499 WHERE `entry`=36678 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37839 WHERE `entry`=36678 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37841 WHERE `entry`=36678 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37878 WHERE `entry`=36789 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37852 WHERE `entry`=36789 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36720 WHERE `entry`=36838 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36720 WHERE `entry`=36839 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37511 WHERE `entry`=36853 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38550 WHERE `entry`=36853 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37109 WHERE `entry`=36853 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37134 WHERE `entry`=36853 AND `groupid`=8 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=37139 WHERE `entry`=36853 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38135 WHERE `entry`=36855 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38122 WHERE `entry`=36855 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38130 WHERE `entry`=36855 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38133 WHERE `entry`=36855 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38123 WHERE `entry`=36855 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38124 WHERE `entry`=36855 AND `groupid`=14 AND `id`=1; +UPDATE `creature_text` SET `BroadcastTextID`=38128 WHERE `entry`=36855 AND `groupid`=15 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38125 WHERE `entry`=36855 AND `groupid`=16 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38669 WHERE `entry`=36954 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38670 WHERE `entry`=36954 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36994 WHERE `entry`=36954 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36821 WHERE `entry`=36955 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38537 WHERE `entry`=36955 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38539 WHERE `entry`=36955 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36992 WHERE `entry`=36955 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36990 WHERE `entry`=36955 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36846 WHERE `entry`=36990 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=36923 WHERE `entry`=37119 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37075 WHERE `entry`=37122 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37664 WHERE `entry`=37123 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37658 WHERE `entry`=37123 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37535 WHERE `entry`=37124 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37662 WHERE `entry`=37125 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37163 WHERE `entry`=37126 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37164 WHERE `entry`=37129 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37165 WHERE `entry`=37129 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37640 WHERE `entry`=37187 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37643 WHERE `entry`=37187 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37648 WHERE `entry`=37187 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37649 WHERE `entry`=37187 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37461 WHERE `entry`=37200 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37504 WHERE `entry`=37200 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37505 WHERE `entry`=37200 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37591 WHERE `entry`=37221 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37592 WHERE `entry`=37221 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37593 WHERE `entry`=37221 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37594 WHERE `entry`=37221 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37595 WHERE `entry`=37221 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37602 WHERE `entry`=37221 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37568 WHERE `entry`=37223 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37571 WHERE `entry`=37223 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37572 WHERE `entry`=37223 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37604 WHERE `entry`=37225 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37611 WHERE `entry`=37225 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37585 WHERE `entry`=37225 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37588 WHERE `entry`=37225 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37589 WHERE `entry`=37225 AND `groupid`=15 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37617 WHERE `entry`=37226 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37616 WHERE `entry`=37226 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37075 WHERE `entry`=37491 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37664 WHERE `entry`=37493 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37658 WHERE `entry`=37493 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37662 WHERE `entry`=37495 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37168 WHERE `entry`=37554 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38540 WHERE `entry`=37554 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38541 WHERE `entry`=37554 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38543 WHERE `entry`=37554 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38538 WHERE `entry`=37554 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37320 WHERE `entry`=37592 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37321 WHERE `entry`=37592 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37380 WHERE `entry`=37596 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37381 WHERE `entry`=37596 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37376 WHERE `entry`=37596 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37370 WHERE `entry`=37597 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37372 WHERE `entry`=37597 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37373 WHERE `entry`=37597 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37374 WHERE `entry`=37597 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37375 WHERE `entry`=37597 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37376 WHERE `entry`=37597 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37458 WHERE `entry`=37813 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37644 WHERE `entry`=37813 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38630 WHERE `entry`=37813 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37994 WHERE `entry`=37813 AND `groupid`=12 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37477 WHERE `entry`=37813 AND `groupid`=13 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37485 WHERE `entry`=37846 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37493 WHERE `entry`=37846 AND `groupid`=10 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37545 WHERE `entry`=37879 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38065 WHERE `entry`=37955 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38063 WHERE `entry`=37955 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38066 WHERE `entry`=37955 AND `groupid`=8 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38064 WHERE `entry`=37955 AND `groupid`=9 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38069 WHERE `entry`=37955 AND `groupid`=11 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38972 WHERE `entry`=37970 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38007 WHERE `entry`=37972 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=13022 WHERE `entry`=37972 AND `groupid`=4 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38005 WHERE `entry`=37972 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38624 WHERE `entry`=37973 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38079 WHERE `entry`=38004 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37931 WHERE `entry`=38112 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37949 WHERE `entry`=38113 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37954 WHERE `entry`=38113 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37369 WHERE `entry`=38160 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=37387 WHERE `entry`=38161 AND `groupid`=0 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38286 WHERE `entry`=38335 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38287 WHERE `entry`=38335 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38286 WHERE `entry`=38338 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38287 WHERE `entry`=38338 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38512 WHERE `entry`=38472 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38512 WHERE `entry`=38485 AND `groupid`=1 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=38111 WHERE `entry`=38995 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39411 WHERE `entry`=39368 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39384 WHERE `entry`=39368 AND `groupid`=14 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39709 WHERE `entry`=39712 AND `groupid`=2 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39725 WHERE `entry`=39712 AND `groupid`=6 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=39784 WHERE `entry`=39746 AND `groupid`=3 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40065 WHERE `entry`=39863 AND `groupid`=5 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=41619 WHERE `entry`=39863 AND `groupid`=7 AND `id`=0; +UPDATE `creature_text` SET `BroadcastTextID`=40411 WHERE `entry`=40416 AND `groupid`=0 AND `id`=1; + + +UPDATE `creature_text` AS `A` +INNER JOIN `broadcast_text` AS `B` ON `A`.`BroadcastTextID`=`B`.`ID` +SET `A`.`text`=`B`.`MaleText` +WHERE `A`.`BroadcastTextID`!=0; + +UPDATE `creature_text` AS `A` +INNER JOIN `broadcast_text` AS `B` ON `A`.`BroadcastTextID`=`B`.`ID` +SET `A`.`text`=`B`.`FemaleText` +WHERE `A`.`BroadcastTextID`!=0 AND `A`.`text`=''; |