DB/Misc: Added massparsed 9.1.0 npc_text data

1 files changed, 124 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_14_01_world.sql b/sql/updates/world/master/2022_01_14_01_world.sql
new file mode 100644
index 00000000000..932d4be0884
--- /dev/null
+++ b/sql/updates/world/master/2022_01_14_01_world.sql
@@ -0,0 +1,124 @@
+-- 
+DELETE FROM `npc_text` WHERE `ID` IN (42778 /*42778*/, 43075 /*43075*/, 43076 /*43076*/, 43085 /*43085*/, 43429 /*43429*/, 39079 /*39079*/, 39367 /*39367*/, 40136 /*40136*/, 42161 /*42161*/, 42827 /*42827*/, 41702 /*41702*/, 41705 /*41705*/, 41706 /*41706*/, 41704 /*41704*/, 41825 /*41825*/, 41824 /*41824*/, 41823 /*41823*/, 41732 /*41732*/, 43383 /*43383*/, 17590 /*17590*/, 17589 /*17589*/, 14448 /*14448*/, 40125 /*40125*/, 43242 /*43242*/, 43166 /*43166*/, 41478 /*41478*/, 40056 /*40056*/, 41477 /*41477*/, 39113 /*39113*/, 42843 /*42843*/, 14957 /*14957*/, 17551 /*17551*/, 43251 /*43251*/, 43148 /*43148*/, 43147 /*43147*/, 43065 /*43065*/, 43448 /*43448*/, 43447 /*43447*/, 43432 /*43432*/, 43316 /*43316*/, 43315 /*43315*/, 43430 /*43430*/, 41886 /*41886*/, 41731 /*41731*/, 43087 /*43087*/, 43078 /*43078*/, 39577 /*39577*/, 39399 /*39399*/, 39585 /*39585*/, 39398 /*39398*/, 39397 /*39397*/, 41233 /*41233*/, 43154 /*43154*/, 43167 /*43167*/, 43068 /*43068*/, 43064 /*43064*/, 43061 /*43061*/, 43059 /*43059*/, 43056 /*43056*/, 43182 /*43182*/, 43238 /*43238*/, 42962 /*42962*/, 43069 /*43069*/, 43067 /*43067*/, 43057 /*43057*/, 19940 /*19940*/, 40678 /*40678*/, 43116 /*43116*/, 43446 /*43446*/, 43366 /*43366*/, 43435 /*43435*/, 43436 /*43436*/, 43434 /*43434*/, 40826 /*40826*/, 41401 /*41401*/, 40475 /*40475*/, 42855 /*42855*/, 43066 /*43066*/, 43277 /*43277*/, 43404 /*43404*/, 43403 /*43403*/, 43164 /*43164*/, 43279 /*43279*/, 43276 /*43276*/, 42863 /*42863*/, 42749 /*42749*/, 42786 /*42786*/, 43083 /*43083*/, 43353 /*43353*/);
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(42778, 0, 0, 0, 0, 0, 0, 0, 0, 208607, 0, 0, 0, 0, 0, 0, 0, 40725), -- 42778
+(43075, 0, 0, 0, 0, 0, 0, 0, 0, 211469, 0, 0, 0, 0, 0, 0, 0, 40593), -- 43075
+(43076, 0, 0, 0, 0, 0, 0, 0, 0, 211470, 0, 0, 0, 0, 0, 0, 0, 40593), -- 43076
+(43085, 0, 0, 0, 0, 0, 0, 0, 0, 211475, 0, 0, 0, 0, 0, 0, 0, 40593), -- 43085
+(43429, 1, 1, 1, 0, 0, 0, 0, 0, 204097, 204099, 204104, 0, 0, 0, 0, 0, 40120), -- 43429
+(39079, 1, 0, 0, 0, 0, 0, 0, 0, 183498, 0, 0, 0, 0, 0, 0, 0, 39318), -- 39079
+(39367, 1, 0, 0, 0, 0, 0, 0, 0, 185696, 0, 0, 0, 0, 0, 0, 0, 40725), -- 39367
+(40136, 1, 0, 0, 0, 0, 0, 0, 0, 193568, 0, 0, 0, 0, 0, 0, 0, 40593), -- 40136
+(42161, 1, 1, 1, 1, 0, 0, 0, 0, 206146, 206147, 206148, 206149, 0, 0, 0, 0, 40593), -- 42161
+(42827, 0, 0, 0, 0, 0, 0, 0, 0, 209187, 0, 0, 0, 0, 0, 0, 0, 40593), -- 42827
+(41702, 1, 0, 0, 0, 0, 0, 0, 0, 204232, 0, 0, 0, 0, 0, 0, 0, 40443), -- 41702
+(41705, 1, 0, 0, 0, 0, 0, 0, 0, 204236, 0, 0, 0, 0, 0, 0, 0, 40443), -- 41705
+(41706, 1, 0, 0, 0, 0, 0, 0, 0, 204237, 0, 0, 0, 0, 0, 0, 0, 40443), -- 41706
+(41704, 1, 0, 0, 0, 0, 0, 0, 0, 204235, 0, 0, 0, 0, 0, 0, 0, 40443), -- 41704
+(41825, 1, 0, 0, 0, 0, 0, 0, 0, 204812, 0, 0, 0, 0, 0, 0, 0, 40443), -- 41825
+(41824, 1, 0, 0, 0, 0, 0, 0, 0, 204811, 0, 0, 0, 0, 0, 0, 0, 40443), -- 41824
+(41823, 1, 0, 0, 0, 0, 0, 0, 0, 204810, 0, 0, 0, 0, 0, 0, 0, 40443), -- 41823
+(41732, 1, 0, 0, 0, 0, 0, 0, 0, 201950, 0, 0, 0, 0, 0, 0, 0, 40120), -- 41732
+(43383, 1, 0, 0, 0, 0, 0, 0, 0, 212514, 0, 0, 0, 0, 0, 0, 0, 40120), -- 43383
+(17590, 1, 0, 0, 0, 0, 0, 0, 0, 49642, 0, 0, 0, 0, 0, 0, 0, 40120), -- 17590
+(17589, 1, 0, 0, 0, 0, 0, 0, 0, 49640, 0, 0, 0, 0, 0, 0, 0, 40120), -- 17589
+(14448, 1, 0, 0, 0, 0, 0, 0, 0, 34046, 0, 0, 0, 0, 0, 0, 0, 39653), -- 14448
+(40125, 1, 0, 0, 0, 0, 0, 0, 0, 193319, 0, 0, 0, 0, 0, 0, 0, 39335), -- 40125
+(43242, 1, 0, 0, 0, 0, 0, 0, 0, 212113, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43242
+(43166, 1, 0, 0, 0, 0, 0, 0, 0, 211864, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43166
+(41478, 1, 0, 0, 0, 0, 0, 0, 0, 202368, 0, 0, 0, 0, 0, 0, 0, 40443), -- 41478
+(40056, 1, 1, 1, 0, 0, 0, 0, 0, 192588, 192589, 192590, 0, 0, 0, 0, 0, 40443), -- 40056
+(41477, 1, 0, 0, 0, 0, 0, 0, 0, 202367, 0, 0, 0, 0, 0, 0, 0, 40443), -- 41477
+(39113, 1, 0, 0, 0, 0, 0, 0, 0, 183704, 0, 0, 0, 0, 0, 0, 0, 40443), -- 39113
+(42843, 1, 0, 0, 0, 0, 0, 0, 0, 209274, 0, 0, 0, 0, 0, 0, 0, 40120), -- 42843
+(14957, 1, 0, 0, 0, 0, 0, 0, 0, 36372, 0, 0, 0, 0, 0, 0, 0, 39804), -- 14957
+(17551, 1, 0, 0, 0, 0, 0, 0, 0, 49190, 0, 0, 0, 0, 0, 0, 0, 39804), -- 17551
+(43251, 1, 0, 0, 0, 0, 0, 0, 0, 212122, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43251
+(43148, 0, 0, 0, 0, 0, 0, 0, 0, 211774, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43148
+(43147, 0, 0, 0, 0, 0, 0, 0, 0, 211772, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43147
+(43065, 0, 0, 0, 0, 0, 0, 0, 0, 211435, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43065
+(43448, 1, 0, 0, 0, 0, 0, 0, 0, 212622, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43448
+(43447, 1, 0, 0, 0, 0, 0, 0, 0, 212620, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43447
+(43432, 0, 0, 0, 0, 0, 0, 0, 0, 212592, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43432
+(43316, 0, 0, 0, 0, 0, 0, 0, 0, 212316, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43316
+(43315, 0, 0, 0, 0, 0, 0, 0, 0, 212314, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43315
+(43430, 0, 0, 0, 0, 0, 0, 0, 0, 212588, 0, 0, 0, 0, 0, 0, 0, 39318), -- 43430
+(41886, 1, 0, 0, 0, 0, 0, 0, 0, 205099, 0, 0, 0, 0, 0, 0, 0, 40725), -- 41886
+(41731, 1, 0, 0, 0, 0, 0, 0, 0, 204438, 0, 0, 0, 0, 0, 0, 0, 39653), -- 41731
+(43087, 0, 0, 0, 0, 0, 0, 0, 0, 211477, 0, 0, 0, 0, 0, 0, 0, 39653), -- 43087
+(43078, 0, 0, 0, 0, 0, 0, 0, 0, 211472, 0, 0, 0, 0, 0, 0, 0, 39653), -- 43078
+(39577, 1, 0, 0, 0, 0, 0, 0, 0, 187297, 0, 0, 0, 0, 0, 0, 0, 39335), -- 39577
+(39399, 1, 0, 0, 0, 0, 0, 0, 0, 186020, 0, 0, 0, 0, 0, 0, 0, 39335), -- 39399
+(39585, 1, 0, 0, 0, 0, 0, 0, 0, 187299, 0, 0, 0, 0, 0, 0, 0, 39335), -- 39585
+(39398, 1, 0, 0, 0, 0, 0, 0, 0, 186019, 0, 0, 0, 0, 0, 0, 0, 39335), -- 39398
+(39397, 1, 0, 0, 0, 0, 0, 0, 0, 186016, 0, 0, 0, 0, 0, 0, 0, 39335), -- 39397
+(41233, 1, 0, 0, 0, 0, 0, 0, 0, 201216, 0, 0, 0, 0, 0, 0, 0, 39289), -- 41233
+(43154, 0, 0, 0, 0, 0, 0, 0, 0, 211812, 0, 0, 0, 0, 0, 0, 0, 39289), -- 43154
+(43167, 1, 0, 0, 0, 0, 0, 0, 0, 211865, 0, 0, 0, 0, 0, 0, 0, 39289), -- 43167
+(43068, 0, 0, 0, 0, 0, 0, 0, 0, 211438, 0, 0, 0, 0, 0, 0, 0, 39289), -- 43068
+(43064, 0, 0, 0, 0, 0, 0, 0, 0, 211434, 0, 0, 0, 0, 0, 0, 0, 39289), -- 43064
+(43061, 0, 0, 0, 0, 0, 0, 0, 0, 211431, 0, 0, 0, 0, 0, 0, 0, 39289), -- 43061
+(43059, 0, 0, 0, 0, 0, 0, 0, 0, 211429, 0, 0, 0, 0, 0, 0, 0, 39289), -- 43059
+(43056, 0, 0, 0, 0, 0, 0, 0, 0, 211426, 0, 0, 0, 0, 0, 0, 0, 39289), -- 43056
+(43182, 1, 0, 0, 0, 0, 0, 0, 0, 211883, 0, 0, 0, 0, 0, 0, 0, 39229), -- 43182
+(43238, 1, 0, 0, 0, 0, 0, 0, 0, 212109, 0, 0, 0, 0, 0, 0, 0, 39229), -- 43238
+(42962, 0, 0, 0, 0, 0, 0, 0, 0, 210523, 0, 0, 0, 0, 0, 0, 0, 40725), -- 42962
+(43069, 0, 0, 0, 0, 0, 0, 0, 0, 211439, 0, 0, 0, 0, 0, 0, 0, 40725), -- 43069
+(43067, 0, 0, 0, 0, 0, 0, 0, 0, 211437, 0, 0, 0, 0, 0, 0, 0, 40725), -- 43067
+(43057, 0, 0, 0, 0, 0, 0, 0, 0, 211427, 0, 0, 0, 0, 0, 0, 0, 40725), -- 43057
+(19940, 1, 1, 1, 0, 0, 0, 0, 0, 61283, 61284, 61262, 0, 0, 0, 0, 0, 39804), -- 19940
+(40678, 1, 0, 0, 0, 0, 0, 0, 0, 197850, 0, 0, 0, 0, 0, 0, 0, 39427), -- 40678
+(43116, 0, 0, 0, 0, 0, 0, 0, 0, 211569, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43116
+(43446, 1, 0, 0, 0, 0, 0, 0, 0, 212619, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43446
+(43366, 0, 0, 0, 0, 0, 0, 0, 0, 212476, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43366
+(43435, 0, 0, 0, 0, 0, 0, 0, 0, 212600, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43435
+(43436, 0, 0, 0, 0, 0, 0, 0, 0, 212596, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43436
+(43434, 0, 0, 0, 0, 0, 0, 0, 0, 212594, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43434
+(40826, 1, 1, 1, 1, 0, 0, 0, 0, 198903, 198956, 198957, 198958, 0, 0, 0, 0, 40725), -- 40826
+(41401, 1, 1, 1, 0, 0, 0, 0, 0, 201964, 201962, 201960, 0, 0, 0, 0, 0, 40725), -- 41401
+(40475, 1, 0, 0, 0, 0, 0, 0, 0, 195977, 0, 0, 0, 0, 0, 0, 0, 40725), -- 40475
+(42855, 0, 0, 0, 0, 0, 0, 0, 0, 209338, 0, 0, 0, 0, 0, 0, 0, 40725), -- 42855
+(43066, 0, 0, 0, 0, 0, 0, 0, 0, 211436, 0, 0, 0, 0, 0, 0, 0, 40120), -- 43066
+(43277, 1, 0, 0, 0, 0, 0, 0, 0, 212213, 0, 0, 0, 0, 0, 0, 0, 40000), -- 43277
+(43404, 0, 0, 0, 0, 0, 0, 0, 0, 212550, 0, 0, 0, 0, 0, 0, 0, 39335), -- 43404
+(43403, 1, 1, 0, 0, 0, 0, 0, 0, 191537, 191538, 0, 0, 0, 0, 0, 0, 39335), -- 43403
+(43164, 1, 0, 0, 0, 0, 0, 0, 0, 211862, 0, 0, 0, 0, 0, 0, 0, 39229), -- 43164
+(43279, 0, 0, 0, 0, 0, 0, 0, 0, 212215, 0, 0, 0, 0, 0, 0, 0, 39229), -- 43279
+(43276, 0, 0, 0, 0, 0, 0, 0, 0, 212211, 0, 0, 0, 0, 0, 0, 0, 39229), -- 43276
+(42863, 0, 0, 0, 0, 0, 0, 0, 0, 209382, 0, 0, 0, 0, 0, 0, 0, 39229), -- 42863
+(42749, 1, 0, 0, 0, 0, 0, 0, 0, 208227, 0, 0, 0, 0, 0, 0, 0, 39229), -- 42749
+(42786, 1, 0, 0, 0, 0, 0, 0, 0, 208866, 0, 0, 0, 0, 0, 0, 0, 39229), -- 42786
+(43083, 0, 0, 0, 0, 0, 0, 0, 0, 211474, 0, 0, 0, 0, 0, 0, 0, 39229), -- 43083
+(43353, 1, 0, 0, 0, 0, 0, 0, 0, 206666, 0, 0, 0, 0, 0, 0, 0, 39229); -- 43353
+
+UPDATE `npc_text` SET `VerifiedBuild`=39229 WHERE `ID` IN (40297, 42426, 7778, 42127, 40007, 40563, 39067, 41904, 40584, 40538, 41851, 40141, 41750, 42400, 42084, 37277, 37932, 39549, 42488, 40648, 41729, 42360, 40523, 40938, 41013, 40425, 40392, 41744, 41630, 14783, 40214, 41789);
+UPDATE `npc_text` SET `VerifiedBuild`=39262 WHERE `ID` IN (42426, 40275, 18217, 15864, 7778, 13584);
+UPDATE `npc_text` SET `VerifiedBuild`=39282 WHERE `ID` IN (7778, 41832, 42426, 42726, 42127, 42091, 42088, 40007);
+UPDATE `npc_text` SET `VerifiedBuild`=39289 WHERE `ID` IN (37932, 14783, 40140, 41851, 7778, 42366, 39333, 39329, 42606, 42426, 40584, 39959, 41750, 40297);
+UPDATE `npc_text` SET `VerifiedBuild`=39291 WHERE `ID` IN (40818, 7778, 42426, 41479, 42482, 40493, 42088, 39549, 39329, 39445, 39447, 39333, 42087, 42084, 42127, 14783, 40297, 40007, 42726, 40648, 41975);
+UPDATE `npc_text` SET `VerifiedBuild`=39318 WHERE `ID` IN (40543, 41483, 42606, 14783, 40584, 40007, 40297, 40818, 41904, 38847);
+UPDATE `npc_text` SET `BroadcastTextId0`=212591, `VerifiedBuild`=39318 WHERE `ID`=41797; -- 41797
+UPDATE `npc_text` SET `VerifiedBuild`=39335 WHERE `ID` IN (40818, 41987, 41504, 40355, 40356, 41490, 39333, 39196, 40007, 40196, 41359, 40174, 7778, 41483, 40165, 32123, 40297, 42426, 7199, 7198, 7134, 7154, 7256, 7156, 39959, 41495, 40141, 14783, 28096, 41466, 41849, 41498, 41851, 40538, 40584, 42127, 40543, 37277, 17219, 40347, 38632, 41847, 41499, 41850, 39549, 41975, 42488, 39834, 42141, 17627, 17946, 18217, 1517, 1516, 15909, 16587, 19935, 19934, 6896, 16726, 39332, 40214, 41433, 39426, 39933, 39932, 39999, 42606, 41148, 39164, 39445, 41744, 42080);
+UPDATE `npc_text` SET `BroadcastTextId0`=207992, `VerifiedBuild`=39335 WHERE `ID`=39503; -- 39503
+UPDATE `npc_text` SET `BroadcastTextId0`=212591, `VerifiedBuild`=39335 WHERE `ID`=41797; -- 41797
+UPDATE `npc_text` SET `VerifiedBuild`=39427 WHERE `ID` IN (42426, 39445, 39447, 39333, 40007, 27251, 40818, 7778, 39125, 42091, 40493, 42606, 42127, 39196, 40061, 40584, 41814, 40491, 38529, 39332, 39968, 40088, 40297, 40214, 41700, 2280, 18376, 18342, 17941, 9125, 9121, 18299, 18314, 18313, 18318, 12498, 18354, 37277, 10000, 40347, 14783);
+UPDATE `npc_text` SET `VerifiedBuild`=39497 WHERE `ID` IN (7778, 40297, 42426, 40818, 27251, 18303, 18302, 18304, 18308, 9836, 18330, 14783, 40007, 39445, 39333);
+UPDATE `npc_text` SET `VerifiedBuild`=39498 WHERE `ID`=42426;
+UPDATE `npc_text` SET `VerifiedBuild`=39617 WHERE `ID` IN (40297, 41975, 42088, 42090, 42426);
+UPDATE `npc_text` SET `VerifiedBuild`=39653 WHERE `ID` IN (39164, 40538, 40584, 2593, 30675, 17941, 16258, 17218, 5841, 37277, 27251, 14783, 7778, 14507, 16633, 2278, 14358, 14338, 14337, 14346, 40347, 15665, 938, 16535, 15468, 15318, 15458, 15490, 15500, 15484, 15252, 15251, 15275, 933, 41931, 36652, 32151, 32148, 12539, 9073, 13583, 19888, 40535, 41975, 42426, 42482, 40297, 41904, 39333, 42360, 40613, 40523, 40938, 41013, 40425, 40392, 41396, 41700, 42366, 42488, 40214, 42090, 40493);
+UPDATE `npc_text` SET `BroadcastTextId0`=212591, `VerifiedBuild`=39653 WHERE `ID`=41797; -- 41797
+UPDATE `npc_text` SET `BroadcastTextId0`=33513, `VerifiedBuild`=39653 WHERE `ID`=14344; -- 14344
+UPDATE `npc_text` SET `BroadcastTextId0`=6630, `VerifiedBuild`=39653 WHERE `ID`=4037; -- 4037
+UPDATE `npc_text` SET `BroadcastTextId0`=207992, `VerifiedBuild`=39653 WHERE `ID`=39503; -- 39503
+UPDATE `npc_text` SET `VerifiedBuild`=39804 WHERE `ID` IN (42488, 38765, 40347, 7174, 15701, 15688, 15693, 15694, 15689, 15692, 15696, 15691, 15700, 15697, 15698, 15690, 15695, 15667, 15595, 15546, 14881, 15566, 16824, 13584, 15549, 15544, 15550, 15551, 15543, 15508, 15516, 15534, 15431, 15418, 15419, 15420, 15387, 15326, 15313, 15243, 15422, 14985, 14990, 15007, 14799, 14603, 15012, 14880, 1853, 14981, 14789, 14593, 14601, 17576, 15121, 14698, 14697, 14705, 14703, 14702, 14700, 14731, 14684, 17552, 14590, 14681, 14694, 27251, 2593, 19935, 19934, 37146, 699, 20651, 16633, 42407, 1272, 7013, 522, 17838, 5500, 5497, 7778, 4862, 17134, 17127, 17125, 5285, 7021, 4786, 15312, 4935, 4973, 16491, 16489, 5006, 5716, 4998, 15309, 32119);
+UPDATE `npc_text` SET `BroadcastTextId0`=34959, `VerifiedBuild`=39804 WHERE `ID`=14605; -- 14605
+UPDATE `npc_text` SET `BroadcastTextId0`=6718, `VerifiedBuild`=39804 WHERE `ID`=4072; -- 4072
+UPDATE `npc_text` SET `VerifiedBuild`=40000 WHERE `ID` IN (933, 1235, 18205, 14783, 18613, 13873, 39221, 41280, 42127, 13584, 40532, 7778, 42726, 42426, 41729, 40535, 38631, 39959, 40494, 41848, 43048, 43264, 42519, 42518, 42517, 42516, 40538, 43099, 42721, 43180, 43227, 40007, 42366, 40297, 41009, 42393, 42716, 40335, 41597, 40493, 39196, 41535, 39333, 41814, 18269, 8238, 38448, 41849, 40584, 43225, 43331);
+UPDATE `npc_text` SET `VerifiedBuild`=40120 WHERE `ID` IN (37782, 41850, 38448, 39959, 41849, 43483, 42426, 7778, 42758, 40584, 38847, 37277, 40491, 40297, 15859, 15858, 40535, 41744, 14468, 40493, 42606, 39240, 39332, 41438, 42488, 42482, 41841, 41852, 40538, 40494, 41848, 42400, 40007, 42366, 39333, 41832, 42461, 41975, 40532, 938, 8883, 14507, 1514, 1517, 1516, 15909, 19935, 19934, 16980, 20651, 14432, 4837, 37146, 33494, 33453, 32003, 35814, 17608, 2593, 41783, 35501, 31949, 40648, 11211, 11210, 41598, 41904, 43264, 42719, 42929, 12134, 12968, 13155, 18280, 39164, 18390, 7381, 41729, 39842, 42086, 41789, 42115, 42114, 40818, 15265, 33720, 33719, 32670, 32658, 39070, 42580, 42579, 41483, 13584, 39125, 43180, 42823, 41148, 42861, 38633, 41847, 41750, 33525, 15853, 41822, 41500, 40347);
+UPDATE `npc_text` SET `BroadcastTextId0`=212591, `VerifiedBuild`=40120 WHERE `ID`=41797; -- 41797
+UPDATE `npc_text` SET `VerifiedBuild`=40443 WHERE `ID` IN (39541, 42426, 40133, 42941, 39959, 41750, 38631, 7778, 41058, 40741, 40005, 41822, 40584, 38448, 38633, 40367, 40493, 42523, 42495, 39333, 39329, 39445, 40818, 39097, 39098, 39099, 40061, 38895, 40050, 39756, 38632, 40686, 42152, 41566, 27251, 41877, 40140, 41847, 40538, 40141, 37782, 40157, 41573, 39233, 42047, 38900, 42826, 41821, 40938, 41013, 40425, 40392, 40171, 43483);
+UPDATE `npc_text` SET `VerifiedBuild`=40593 WHERE `ID` IN (42200, 42199, 42942, 42934, 14783, 40686, 42523, 42426, 43483, 33495, 580, 40157, 42826, 40493, 41573, 11645, 7868, 9191, 40171, 41729, 39097, 39098, 39099, 38895, 40061, 40050, 40501, 40648, 40275, 7778, 6104, 41572, 40347, 13584, 820, 18046, 7740, 27251, 42861, 42758, 16703, 34007, 40584, 33796, 33728, 41566, 34299, 33795, 933, 11625);
+UPDATE `npc_text` SET `BroadcastTextId0`=212591, `VerifiedBuild`=40593 WHERE `ID`=41797; -- 41797
+UPDATE `npc_text` SET `VerifiedBuild`=40725 WHERE `ID` IN (40686, 42766, 39164, 42758, 34711, 7174, 40347, 36245, 33984, 36247, 42426, 42861, 38847, 42523, 40157, 40493, 40833, 40834, 41961, 40375, 32856, 36114, 38248, 7778, 40584, 41592, 42126, 42140, 37250, 37367, 37419, 37568, 8790, 9186, 14723, 42407, 17946, 563, 38517, 41232, 39415, 41707, 39368, 41539, 41885, 39225, 40827, 40823, 40815, 37277, 37351, 34007, 34011, 41148, 39843, 39842, 38765, 40538, 40035, 40034, 40091, 40092, 32653, 18217, 34927, 37644, 37146, 43180, 41573, 27251, 42826, 41566, 42823, 11645, 43483, 9119, 18297, 938, 16633, 17880, 14543, 39515, 39081, 39054, 40819, 40825, 39019, 39020, 39021, 39024, 39016, 39022, 39017, 39023, 39018, 13584, 40557, 41925, 40083, 36051, 42964, 43331, 42393, 42514, 16587, 6795, 7740);
+UPDATE `npc_text` SET `BroadcastTextId0`=212591, `VerifiedBuild`=40725 WHERE `ID`=41797; -- 41797
+UPDATE `npc_text` SET `BroadcastTextId0`=50116, `VerifiedBuild`=40725 WHERE `ID`=17713; -- 17713