aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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;
+--