DB/Creature: BroadcastTextID for npc_text

By 41782992, closes #13279

1 files changed, 38 insertions, 0 deletions

diff --git a/sql/updates/world/2014_10_06_01_world.sql b/sql/updates/world/2014_10_06_01_world.sql
new file mode 100644
index 00000000000..841f5bc117b
--- /dev/null
+++ b/sql/updates/world/2014_10_06_01_world.sql
@@ -0,0 +1,38 @@
+-- BroadcastTextID0
+UPDATE `npc_text` SET `BroadcastTextID0`=3962 WHERE `ID`=1620;
+UPDATE `npc_text` SET `BroadcastTextID0`=3963 WHERE `ID`=1621;
+UPDATE `npc_text` SET `BroadcastTextID0`=8806 WHERE `ID`=6789;
+UPDATE `npc_text` SET `BroadcastTextID0`=9168 WHERE `ID`=6789;
+UPDATE `npc_text` SET `BroadcastTextID0`=9626 WHERE `ID`=7002;
+UPDATE `npc_text` SET `BroadcastTextID0`=9628 WHERE `ID`=7003;
+UPDATE `npc_text` SET `BroadcastTextID0`=9630 WHERE `ID`=7004;
+UPDATE `npc_text` SET `BroadcastTextID0`=9632 WHERE `ID`=7005;
+UPDATE `npc_text` SET `BroadcastTextID0`=11275 WHERE `ID`=8060;
+UPDATE `npc_text` SET `BroadcastTextID0`=11892 WHERE `ID`=8326;
+UPDATE `npc_text` SET `BroadcastTextID0`=11894 WHERE `ID`=8327;
+UPDATE `npc_text` SET `BroadcastTextID0`=12100 WHERE `ID`=8426;
+UPDATE `npc_text` SET `BroadcastTextID0`=12280 WHERE `ID`=8516;
+UPDATE `npc_text` SET `BroadcastTextID0`=14071 WHERE `ID`=8975;
+UPDATE `npc_text` SET `BroadcastTextID0`=14386 WHERE `ID`=9064;
+UPDATE `npc_text` SET `BroadcastTextID0`=17555 WHERE `ID`=9949;
+UPDATE `npc_text` SET `BroadcastTextID0`=19019 WHERE `ID`=10339;
+UPDATE `npc_text` SET `BroadcastTextID0`=19431 WHERE `ID`=10454;
+UPDATE `npc_text` SET `BroadcastTextID0`=20459 WHERE `ID`=10733;
+UPDATE `npc_text` SET `BroadcastTextID0`=20643 WHERE `ID`=10798;
+UPDATE `npc_text` SET `BroadcastTextID0`=20883 WHERE `ID`=10830;
+UPDATE `npc_text` SET `BroadcastTextID0`=21404 WHERE `ID`=10926;
+UPDATE `npc_text` SET `BroadcastTextID0`=21535 WHERE `ID`=10967;
+UPDATE `npc_text` SET `BroadcastTextID0`=21542 WHERE `ID`=10976;
+UPDATE `npc_text` SET `BroadcastTextID0`=21610 WHERE `ID`=11026;
+UPDATE `npc_text` SET `BroadcastTextID0`=21618 WHERE `ID`=11029;
+UPDATE `npc_text` SET `BroadcastTextID0`=21814 WHERE `ID`=11059;
+
+-- npc_text
+UPDATE `npc_text` SET `BroadcastTextID0`=10796 WHERE `ID`=7804;
+UPDATE `npc_text` SET `BroadcastTextID0`=2545 WHERE `ID`=6491;
+UPDATE `npc_text` SET `BroadcastTextID0`=6877 WHERE `ID`=4194;
+
+-- creature_text
+UPDATE `creature_text` SET `BroadcastTextId`=6198 WHERE `entry`=3977 AND `groupid`=1 AND `id`=0;
+UPDATE `creature_text` SET `BroadcastTextId`=35523 WHERE `entry`=35320 AND `groupid`=0 AND `id`=0;
+UPDATE `creature_text` SET `BroadcastTextId`=35529 WHERE `entry`=35320 AND `groupid`=1 AND `id`=0;