diff options
| -rw-r--r-- | sql/updates/world/2014_10_06_01_world.sql | 38 |
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; |