diff options
author | Aokromes <Aokromes@users.noreply.github.com> | 2016-10-15 22:57:03 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2016-10-15 22:57:03 +0200 |
commit | 943962d504165bd5458df5ee3a9edf19c5abbdf0 (patch) | |
tree | 26869d55b425779096d8bf42e9b0b3522c16c56f | |
parent | 0e52a0e6b12a2977e1cde1bdb2d3e536dc494983 (diff) |
DB/Misc: Fix startup errors
By Malcrom
-rw-r--r-- | sql/updates/world/6.x/2016_10_15_01_world.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_10_15_01_world.sql b/sql/updates/world/6.x/2016_10_15_01_world.sql new file mode 100644 index 00000000000..0419bc42124 --- /dev/null +++ b/sql/updates/world/6.x/2016_10_15_01_world.sql @@ -0,0 +1,27 @@ +-- +UPDATE `npc_text` SET `BroadcastTextID0`=2461 WHERE `ID`=518; +UPDATE `npc_text` SET `BroadcastTextID0`=7459 WHERE `ID`=4782; +UPDATE `npc_text` SET `BroadcastTextID0`=7587 WHERE `ID`=4935; +UPDATE `npc_text` SET `BroadcastTextID0`=7589 WHERE `ID`=4937; +UPDATE `npc_text` SET `BroadcastTextID0`=37489 WHERE `ID`=3553; +UPDATE `npc_text` SET `BroadcastTextID0`=9978 WHERE `ID`=7240; +UPDATE `npc_text` SET `BroadcastTextID0`=11950 WHERE `ID`=8358; +UPDATE `npc_text` SET `BroadcastTextID0`=14597 WHERE `ID`=9125; +UPDATE `npc_text` SET `BroadcastTextID0`=17337 WHERE `ID`=9914; +UPDATE `npc_text` SET `Probability0`=1, `BroadcastTextID1`=50625 WHERE `ID`=13311; +UPDATE `npc_text` SET `Probability0`=1, `BroadcastTextID1`=50625 WHERE `ID`=3173; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50625 WHERE `ID`=2500; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50625 WHERE `ID`=2502; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50625 WHERE `ID`=2653; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50625 WHERE `ID`=2562; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50625 WHERE `ID`=2563; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50548 WHERE `ID`=4033; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50515 WHERE `ID`=4052; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50430 WHERE `ID`=4075; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50442 WHERE `ID`=4076; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50467 WHERE `ID`=4077; +UPDATE `npc_text` SET `Probability0`=1, `Probability1`=1, `BroadcastTextID2`=50485 WHERE `ID`=4078; + +UPDATE `creature` SET `phaseid`=169 WHERE `phaseid`=1; +UPDATE `gameobject` SET `phaseid`=169 WHERE `phaseid`=1; +-- |