DB/Texts: Updated npc_text data from 7.0.3

1 files changed, 44 insertions, 0 deletions

diff --git a/sql/updates/world/6.x/2016_09_26_01_world.sql b/sql/updates/world/6.x/2016_09_26_01_world.sql
new file mode 100644
index 00000000000..a3d792d23dc
--- /dev/null
+++ b/sql/updates/world/6.x/2016_09_26_01_world.sql
@@ -0,0 +1,44 @@
+DELETE FROM `npc_text` WHERE `ID` IN (26678 /*26678*/, 28832 /*28832*/, 26585 /*26585*/, 29194 /*29194*/, 28805 /*28805*/, 30340 /*30340*/, 27379 /*27379*/, 27218 /*27218*/, 28603 /*28603*/, 27527 /*27527*/, 28880 /*28880*/, 28919 /*28919*/, 30146 /*30146*/, 30589 /*30589*/, 28819 /*28819*/, 30262 /*30262*/, 26915 /*26915*/, 26917 /*26917*/, 26916 /*26916*/, 26707 /*26707*/, 28995 /*28995*/, 28687 /*28687*/, 28533 /*28533*/, 25533 /*25533*/, 25868 /*25868*/, 25869 /*25869*/, 26006 /*26006*/, 29719 /*29719*/, 30323 /*30323*/, 28813 /*28813*/, 27106 /*27106*/, 26154 /*26154*/, 25989 /*25989*/);
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(26678, 1, 0, 0, 0, 0, 0, 0, 0, 95400, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26678
+(28832, 1, 0, 0, 0, 0, 0, 0, 0, 108547, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28832
+(26585, 1, 0, 0, 0, 0, 0, 0, 0, 94924, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26585
+(29194, 1, 0, 0, 0, 0, 0, 0, 0, 111485, 0, 0, 0, 0, 0, 0, 0, 22624), -- 29194
+(28805, 1, 0, 0, 0, 0, 0, 0, 0, 108366, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28805
+(30340, 1, 0, 0, 0, 0, 0, 0, 0, 120838, 0, 0, 0, 0, 0, 0, 0, 22624), -- 30340
+(27379, 1, 0, 0, 0, 0, 0, 0, 0, 99648, 0, 0, 0, 0, 0, 0, 0, 22624), -- 27379
+(27218, 1, 0, 0, 0, 0, 0, 0, 0, 98671, 0, 0, 0, 0, 0, 0, 0, 22624), -- 27218
+(28603, 1, 0, 0, 0, 0, 0, 0, 0, 106945, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28603
+(27527, 1, 0, 0, 0, 0, 0, 0, 0, 100253, 0, 0, 0, 0, 0, 0, 0, 22624), -- 27527
+(28880, 1, 0, 0, 0, 0, 0, 0, 0, 108805, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28880
+(28919, 1, 0, 0, 0, 0, 0, 0, 0, 109036, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28919
+(30146, 1, 0, 0, 0, 0, 0, 0, 0, 120832, 0, 0, 0, 0, 0, 0, 0, 22624), -- 30146
+(30589, 1, 0, 0, 0, 0, 0, 0, 0, 122710, 0, 0, 0, 0, 0, 0, 0, 22624), -- 30589
+(28819, 1, 0, 0, 0, 0, 0, 0, 0, 108383, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28819
+(30262, 1, 0, 0, 0, 0, 0, 0, 0, 121463, 0, 0, 0, 0, 0, 0, 0, 22624), -- 30262
+(26915, 1, 0, 0, 0, 0, 0, 0, 0, 96671, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26915
+(26917, 1, 0, 0, 0, 0, 0, 0, 0, 96675, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26917
+(26916, 1, 0, 0, 0, 0, 0, 0, 0, 96674, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26916
+(26707, 1, 0, 0, 0, 0, 0, 0, 0, 95524, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26707
+(28995, 1, 0, 0, 0, 0, 0, 0, 0, 109693, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28995
+(28687, 1, 0, 0, 0, 0, 0, 0, 0, 107614, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28687
+(28533, 1, 0, 0, 0, 0, 0, 0, 0, 106482, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28533
+(25533, 1, 0, 0, 0, 0, 0, 0, 0, 90247, 0, 0, 0, 0, 0, 0, 0, 22624), -- 25533
+(25868, 1, 0, 0, 0, 0, 0, 0, 0, 91584, 0, 0, 0, 0, 0, 0, 0, 22624), -- 25868
+(25869, 1, 0, 0, 0, 0, 0, 0, 0, 91585, 0, 0, 0, 0, 0, 0, 0, 22624), -- 25869
+(26006, 1, 0, 0, 0, 0, 0, 0, 0, 92418, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26006
+(29719, 1, 0, 0, 0, 0, 0, 0, 0, 115829, 0, 0, 0, 0, 0, 0, 0, 22624), -- 29719
+(30323, 1, 0, 0, 0, 0, 0, 0, 0, 121771, 0, 0, 0, 0, 0, 0, 0, 22624), -- 30323
+(28813, 1, 0, 0, 0, 0, 0, 0, 0, 108424, 0, 0, 0, 0, 0, 0, 0, 22624), -- 28813
+(27106, 1, 0, 0, 0, 0, 0, 0, 0, 97607, 0, 0, 0, 0, 0, 0, 0, 22624), -- 27106
+(26154, 1, 0, 0, 0, 0, 0, 0, 0, 92912, 0, 0, 0, 0, 0, 0, 0, 22624), -- 26154
+(25989, 1, 0, 0, 0, 0, 0, 0, 0, 92343, 0, 0, 0, 0, 0, 0, 0, 22624); -- 25989
+
+UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=16830; -- 16830
+UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=12709; -- 12709
+UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=12709; -- 12709
+UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=17627; -- 17627
+UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=16830; -- 16830
+UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=24248; -- 24248
+UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=13349; -- 13349
+UPDATE `npc_text` SET `VerifiedBuild`=22624 WHERE `ID`=13583; -- 13583