DB/Texts: Added more npc_text data from 7.0.3:

1 files changed, 84 insertions, 0 deletions

diff --git a/sql/updates/world/6.x/2016_09_13_01_world.sql b/sql/updates/world/6.x/2016_09_13_01_world.sql
new file mode 100644
index 00000000000..980ec8fec4a
--- /dev/null
+++ b/sql/updates/world/6.x/2016_09_13_01_world.sql
@@ -0,0 +1,84 @@
+DELETE FROM `npc_text` WHERE `ID` IN (27918 /*27918*/, 29099 /*29099*/, 30197 /*30197*/, 20616 /*20616*/, 27175 /*27175*/, 30465 /*30465*/, 28528 /*28528*/, 29600 /*29600*/, 27558 /*27558*/, 28991 /*28991*/, 29163 /*29163*/, 30690 /*30690*/, 30689 /*30689*/, 30688 /*30688*/, 30687 /*30687*/, 28436 /*28436*/, 27277 /*27277*/, 29561 /*29561*/, 28754 /*28754*/, 28753 /*28753*/, 27399 /*27399*/, 29659 /*29659*/, 27689 /*27689*/, 29209 /*29209*/, 29210 /*29210*/, 29208 /*29208*/, 30287 /*30287*/, 29256 /*29256*/, 29191 /*29191*/, 29623 /*29623*/, 30060 /*30060*/, 29581 /*29581*/, 29580 /*29580*/, 29579 /*29579*/, 29578 /*29578*/, 29575 /*29575*/, 29574 /*29574*/, 30272 /*30272*/, 29564 /*29564*/, 29551 /*29551*/, 29385 /*29385*/, 29185 /*29185*/, 29184 /*29184*/, 29442 /*29442*/, 29441 /*29441*/, 29440 /*29440*/, 29439 /*29439*/, 29308 /*29308*/, 27693 /*27693*/, 27692 /*27692*/, 27673 /*27673*/, 27672 /*27672*/, 29914 /*29914*/, 29512 /*29512*/, 26485 /*26485*/, 26694 /*26694*/, 29640 /*29640*/, 29611 /*29611*/, 29602 /*29602*/, 29599 /*29599*/, 30540 /*30540*/, 29504 /*29504*/, 29055 /*29055*/, 27400 /*27400*/, 28006 /*28006*/, 27368 /*27368*/, 27374 /*27374*/, 30675 /*30675*/, 30507 /*30507*/, 30677 /*30677*/, 30676 /*30676*/, 30679 /*30679*/, 30678 /*30678*/, 29641 /*29641*/);
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(27918, 1, 0, 0, 0, 0, 0, 0, 0, 102673, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27918
+(29099, 1, 0, 0, 0, 0, 0, 0, 0, 111045, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29099
+(30197, 1, 1, 0, 0, 0, 0, 0, 0, 121015, 121016, 0, 0, 0, 0, 0, 0, 22566), -- 30197
+(20616, 1, 0, 0, 0, 0, 0, 0, 0, 65241, 0, 0, 0, 0, 0, 0, 0, 22566), -- 20616
+(27175, 1, 0, 0, 0, 0, 0, 0, 0, 98279, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27175
+(30465, 1, 0, 0, 0, 0, 0, 0, 0, 122302, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30465
+(28528, 1, 1, 0.1, 0, 0, 0, 0, 0, 106434, 106433, 106432, 0, 0, 0, 0, 0, 22566), -- 28528
+(29600, 1, 0, 0, 0, 0, 0, 0, 0, 115210, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29600
+(27558, 1, 0, 0, 0, 0, 0, 0, 0, 100419, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27558
+(28991, 1, 0, 0, 0, 0, 0, 0, 0, 109649, 0, 0, 0, 0, 0, 0, 0, 22566), -- 28991
+(29163, 1, 0, 0, 0, 0, 0, 0, 0, 111286, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29163
+(30690, 1, 0, 0, 0, 0, 0, 0, 0, 123248, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30690
+(30689, 1, 0, 0, 0, 0, 0, 0, 0, 123247, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30689
+(30688, 1, 0, 0, 0, 0, 0, 0, 0, 123246, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30688
+(30687, 1, 0, 0, 0, 0, 0, 0, 0, 123245, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30687
+(28436, 1, 0, 0, 0, 0, 0, 0, 0, 105915, 0, 0, 0, 0, 0, 0, 0, 22566), -- 28436
+(27277, 1, 0, 0, 0, 0, 0, 0, 0, 98939, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27277
+(29561, 1, 1, 1, 0, 0, 0, 0, 0, 114919, 114920, 114921, 0, 0, 0, 0, 0, 22566), -- 29561
+(28754, 1, 0, 0, 0, 0, 0, 0, 0, 108099, 0, 0, 0, 0, 0, 0, 0, 22566), -- 28754
+(28753, 1, 0, 0, 0, 0, 0, 0, 0, 108087, 0, 0, 0, 0, 0, 0, 0, 22566), -- 28753
+(27399, 1, 0, 0, 0, 0, 0, 0, 0, 99713, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27399
+(29659, 1, 0, 0, 0, 0, 0, 0, 0, 115619, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29659
+(27689, 1, 0, 0, 0, 0, 0, 0, 0, 101189, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27689
+(29209, 1, 0, 0, 0, 0, 0, 0, 0, 111638, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29209
+(29210, 1, 0, 0, 0, 0, 0, 0, 0, 111636, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29210
+(29208, 1, 0, 0, 0, 0, 0, 0, 0, 111637, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29208
+(30287, 1, 1, 1, 1, 0, 0, 0, 0, 121614, 121615, 121616, 121617, 0, 0, 0, 0, 22566), -- 30287
+(29256, 1, 0, 0, 0, 0, 0, 0, 0, 111852, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29256
+(29191, 1, 1, 1, 0, 0, 0, 0, 0, 111476, 111477, 111478, 0, 0, 0, 0, 0, 22566), -- 29191
+(29623, 1, 1, 0, 0, 0, 0, 0, 0, 115397, 115398, 0, 0, 0, 0, 0, 0, 22566), -- 29623
+(30060, 1, 1, 1, 0, 0, 0, 0, 0, 120666, 115233, 115234, 0, 0, 0, 0, 0, 22566), -- 30060
+(29581, 1, 0, 0, 0, 0, 0, 0, 0, 115009, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29581
+(29580, 1, 0, 0, 0, 0, 0, 0, 0, 115007, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29580
+(29579, 1, 0, 0, 0, 0, 0, 0, 0, 115002, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29579
+(29578, 1, 0, 0, 0, 0, 0, 0, 0, 115005, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29578
+(29575, 1, 0, 0, 0, 0, 0, 0, 0, 115003, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29575
+(29574, 1, 0, 0, 0, 0, 0, 0, 0, 115001, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29574
+(30272, 1, 0, 0, 0, 0, 0, 0, 0, 114971, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30272
+(29564, 1, 1, 1, 0, 0, 0, 0, 0, 114955, 114964, 114965, 0, 0, 0, 0, 0, 22566), -- 29564
+(29551, 1, 0, 0, 0, 0, 0, 0, 0, 114861, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29551
+(29385, 1, 0, 0, 0, 0, 0, 0, 0, 113234, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29385
+(29185, 1, 0, 0, 0, 0, 0, 0, 0, 111358, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29185
+(29184, 1, 0, 0, 0, 0, 0, 0, 0, 111357, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29184
+(29442, 1, 0, 0, 0, 0, 0, 0, 0, 113759, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29442
+(29441, 1, 0, 0, 0, 0, 0, 0, 0, 113758, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29441
+(29440, 1, 0, 0, 0, 0, 0, 0, 0, 113757, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29440
+(29439, 1, 0, 0, 0, 0, 0, 0, 0, 113756, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29439
+(29308, 1, 0, 0, 0, 0, 0, 0, 0, 112391, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29308
+(27693, 1, 0, 0, 0, 0, 0, 0, 0, 101203, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27693
+(27692, 1, 0, 0, 0, 0, 0, 0, 0, 101197, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27692
+(27673, 1, 0, 0, 0, 0, 0, 0, 0, 101036, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27673
+(27672, 1, 0, 0, 0, 0, 0, 0, 0, 101032, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27672
+(29914, 1, 1, 0, 0, 0, 0, 0, 0, 119447, 119448, 0, 0, 0, 0, 0, 0, 22566), -- 29914
+(29512, 1, 0, 0, 0, 0, 0, 0, 0, 114546, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29512
+(26485, 1, 0, 0, 0, 0, 0, 0, 0, 95477, 0, 0, 0, 0, 0, 0, 0, 22566), -- 26485
+(26694, 1, 0, 0, 0, 0, 0, 0, 0, 95451, 0, 0, 0, 0, 0, 0, 0, 22566), -- 26694
+(29640, 1, 0, 0, 0, 0, 0, 0, 0, 115456, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29640
+(29611, 1, 0, 0, 0, 0, 0, 0, 0, 115322, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29611
+(29602, 1, 0, 0, 0, 0, 0, 0, 0, 115219, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29602
+(29599, 1, 0, 0, 0, 0, 0, 0, 0, 115206, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29599
+(30540, 1, 0, 0, 0, 0, 0, 0, 0, 122563, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30540
+(29504, 1, 0, 0, 0, 0, 0, 0, 0, 114494, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29504
+(29055, 1, 0, 0, 0, 0, 0, 0, 0, 110401, 0, 0, 0, 0, 0, 0, 0, 22566), -- 29055
+(27400, 1, 1, 0, 0, 0, 0, 0, 0, 99713, 99714, 0, 0, 0, 0, 0, 0, 22566), -- 27400
+(28006, 1, 0, 0, 0, 0, 0, 0, 0, 103367, 0, 0, 0, 0, 0, 0, 0, 22566), -- 28006
+(27368, 1, 0, 0, 0, 0, 0, 0, 0, 99612, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27368
+(27374, 1, 0, 0, 0, 0, 0, 0, 0, 100156, 0, 0, 0, 0, 0, 0, 0, 22566), -- 27374
+(30675, 1, 0, 0, 0, 0, 0, 0, 0, 123226, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30675
+(30507, 1, 0, 0, 0, 0, 0, 0, 0, 122429, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30507
+(30677, 1, 0, 0, 0, 0, 0, 0, 0, 123232, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30677
+(30676, 1, 0, 0, 0, 0, 0, 0, 0, 118729, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30676
+(30679, 1, 0, 0, 0, 0, 0, 0, 0, 123233, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30679
+(30678, 1, 0, 0, 0, 0, 0, 0, 0, 119037, 0, 0, 0, 0, 0, 0, 0, 22566), -- 30678
+(29641, 1, 0, 0, 0, 0, 0, 0, 0, 115467, 0, 0, 0, 0, 0, 0, 0, 22566); -- 29641
+
+UPDATE `npc_text` SET `VerifiedBuild`=22566 WHERE `ID`=21408; -- 21408
+UPDATE `npc_text` SET `VerifiedBuild`=22566 WHERE `ID`=2593; -- 2593
+UPDATE `npc_text` SET `BroadcastTextId0`=10428, `VerifiedBuild`=22566 WHERE `ID`=7535; -- 7535
+UPDATE `npc_text` SET `VerifiedBuild`=22566 WHERE `ID`=17030; -- 17030
+UPDATE `npc_text` SET `VerifiedBuild`=22566 WHERE `ID`=14783; -- 14783
+UPDATE `npc_text` SET `VerifiedBuild`=22566 WHERE `ID`=5238; -- 5238
+UPDATE `npc_text` SET `VerifiedBuild`=22566 WHERE `ID`=18217; -- 18217