aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2016-10-15 22:57:03 +0200
committerGitHub <noreply@github.com>2016-10-15 22:57:03 +0200
commit943962d504165bd5458df5ee3a9edf19c5abbdf0 (patch)
tree26869d55b425779096d8bf42e9b0b3522c16c56f
parent0e52a0e6b12a2977e1cde1bdb2d3e536dc494983 (diff)
DB/Misc: Fix startup errors
By Malcrom
-rw-r--r--sql/updates/world/6.x/2016_10_15_01_world.sql27
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;
+--