aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2022_01_14_02_world.sql80
1 files changed, 80 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_14_02_world.sql b/sql/updates/world/master/2022_01_14_02_world.sql
new file mode 100644
index 00000000000..2085de94078
--- /dev/null
+++ b/sql/updates/world/master/2022_01_14_02_world.sql
@@ -0,0 +1,80 @@
+--
+DELETE FROM `npc_text` WHERE `ID` IN (28752 /*28752*/, 28969 /*28969*/, 28713 /*28713*/, 28532 /*28532*/, 24012 /*24012*/, 43245 /*43245*/, 43239 /*43239*/, 43247 /*43247*/, 17596 /*17596*/, 16405 /*16405*/, 16408 /*16408*/, 27189 /*27189*/, 27481 /*27481*/, 22591 /*22591*/, 17211 /*17211*/, 17210 /*17210*/, 43160 /*43160*/, 43175 /*43175*/, 41796 /*41796*/, 42763 /*42763*/, 43269 /*43269*/, 43055 /*43055*/, 43063 /*43063*/, 43178 /*43178*/, 43806 /*43806*/, 43086 /*43086*/, 25090 /*25090*/, 25100 /*25100*/, 24826 /*24826*/, 25478 /*25478*/, 25511 /*25511*/, 27198 /*27198*/, 26697 /*26697*/, 29526 /*29526*/, 30237 /*30237*/, 30236 /*30236*/, 30235 /*30235*/, 30234 /*30234*/, 42395 /*42395*/, 35507 /*35507*/, 30401 /*30401*/, 30285 /*30285*/, 28888 /*28888*/, 28892 /*28892*/, 28891 /*28891*/, 28890 /*28890*/, 28889 /*28889*/, 28894 /*28894*/, 28893 /*28893*/, 29843 /*29843*/, 28899 /*28899*/, 28277 /*28277*/, 32402 /*32402*/, 43638 /*43638*/, 23967 /*23967*/, 33967 /*33967*/, 38053 /*38053*/, 37391 /*37391*/, 33580 /*33580*/);
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(28752, 1, 0, 0, 0, 0, 0, 0, 0, 108069, 0, 0, 0, 0, 0, 0, 0, 41359), -- 28752
+(28969, 1, 0, 0, 0, 0, 0, 0, 0, 109137, 0, 0, 0, 0, 0, 0, 0, 41359), -- 28969
+(28713, 1, 0, 0, 0, 0, 0, 0, 0, 107769, 0, 0, 0, 0, 0, 0, 0, 41359), -- 28713
+(28532, 1, 0, 0, 0, 0, 0, 0, 0, 103229, 0, 0, 0, 0, 0, 0, 0, 41359), -- 28532
+(24012, 1, 0, 0, 0, 0, 0, 0, 0, 83113, 0, 0, 0, 0, 0, 0, 0, 41359), -- 24012
+(43245, 1, 0, 0, 0, 0, 0, 0, 0, 212116, 0, 0, 0, 0, 0, 0, 0, 41079), -- 43245
+(43239, 1, 0, 0, 0, 0, 0, 0, 0, 212110, 0, 0, 0, 0, 0, 0, 0, 41079), -- 43239
+(43247, 1, 0, 0, 0, 0, 0, 0, 0, 212118, 0, 0, 0, 0, 0, 0, 0, 41079), -- 43247
+(17596, 1, 0, 0, 0, 0, 0, 0, 0, 49717, 0, 0, 0, 0, 0, 0, 0, 40966), -- 17596
+(16405, 1, 0, 0, 0, 0, 0, 0, 0, 43359, 0, 0, 0, 0, 0, 0, 0, 40966), -- 16405
+(16408, 1, 0, 0, 0, 0, 0, 0, 0, 43410, 0, 0, 0, 0, 0, 0, 0, 40966), -- 16408
+(27189, 1, 0, 0, 0, 0, 0, 0, 0, 98342, 0, 0, 0, 0, 0, 0, 0, 40966), -- 27189
+(27481, 1, 0, 0, 0, 0, 0, 0, 0, 100043, 0, 0, 0, 0, 0, 0, 0, 40966), -- 27481
+(22591, 1, 0, 0, 0, 0, 0, 0, 0, 74283, 0, 0, 0, 0, 0, 0, 0, 40966), -- 22591
+(17211, 1, 0, 0, 0, 0, 0, 0, 0, 47569, 0, 0, 0, 0, 0, 0, 0, 40966), -- 17211
+(17210, 1, 0, 0, 0, 0, 0, 0, 0, 47564, 0, 0, 0, 0, 0, 0, 0, 40966), -- 17210
+(43160, 1, 0, 0, 0, 0, 0, 0, 0, 211858, 0, 0, 0, 0, 0, 0, 0, 41359), -- 43160
+(43175, 1, 0, 0, 0, 0, 0, 0, 0, 211875, 0, 0, 0, 0, 0, 0, 0, 41359), -- 43175
+(41796, 1, 0, 0, 0, 0, 0, 0, 0, 204717, 0, 0, 0, 0, 0, 0, 0, 41079), -- 41796
+(42763, 0, 0, 0, 0, 0, 0, 0, 0, 208593, 0, 0, 0, 0, 0, 0, 0, 41488), -- 42763
+(43269, 0, 0, 0, 0, 0, 0, 0, 0, 212173, 0, 0, 0, 0, 0, 0, 0, 41488), -- 43269
+(43055, 0, 0, 0, 0, 0, 0, 0, 0, 211425, 0, 0, 0, 0, 0, 0, 0, 41488), -- 43055
+(43063, 0, 0, 0, 0, 0, 0, 0, 0, 211433, 0, 0, 0, 0, 0, 0, 0, 41488), -- 43063
+(43178, 1, 0, 0, 0, 0, 0, 0, 0, 211879, 0, 0, 0, 0, 0, 0, 0, 41488), -- 43178
+(43806, 1, 0, 0, 0, 0, 0, 0, 0, 214459, 0, 0, 0, 0, 0, 0, 0, 41488), -- 43806
+(43086, 0, 0, 0, 0, 0, 0, 0, 0, 211476, 0, 0, 0, 0, 0, 0, 0, 41488), -- 43086
+(25090, 1, 0, 0, 0, 0, 0, 0, 0, 88630, 0, 0, 0, 0, 0, 0, 0, 40906), -- 25090
+(25100, 1, 0, 0, 0, 0, 0, 0, 0, 88646, 0, 0, 0, 0, 0, 0, 0, 40906), -- 25100
+(24826, 1, 0, 0, 0, 0, 0, 0, 0, 87559, 0, 0, 0, 0, 0, 0, 0, 40906), -- 24826
+(25478, 1, 0, 0, 0, 0, 0, 0, 0, 90146, 0, 0, 0, 0, 0, 0, 0, 40906), -- 25478
+(25511, 1, 0, 0, 0, 0, 0, 0, 0, 90173, 0, 0, 0, 0, 0, 0, 0, 40906), -- 25511
+(27198, 1, 0, 0, 0, 0, 0, 0, 0, 98504, 0, 0, 0, 0, 0, 0, 0, 40906), -- 27198
+(26697, 1, 0, 0, 0, 0, 0, 0, 0, 95486, 0, 0, 0, 0, 0, 0, 0, 40906), -- 26697
+(29526, 1, 0, 0, 0, 0, 0, 0, 0, 114640, 0, 0, 0, 0, 0, 0, 0, 40906), -- 29526
+(30237, 1, 0, 0, 0, 0, 0, 0, 0, 121384, 0, 0, 0, 0, 0, 0, 0, 41359), -- 30237
+(30236, 1, 0, 0, 0, 0, 0, 0, 0, 121382, 0, 0, 0, 0, 0, 0, 0, 41359), -- 30236
+(30235, 1, 0, 0, 0, 0, 0, 0, 0, 121380, 0, 0, 0, 0, 0, 0, 0, 41359), -- 30235
+(30234, 1, 0, 0, 0, 0, 0, 0, 0, 121378, 0, 0, 0, 0, 0, 0, 0, 41359), -- 30234
+(42395, 0, 0, 0, 0, 0, 0, 0, 0, 206668, 0, 0, 0, 0, 0, 0, 0, 41079), -- 42395
+(35507, 1, 0, 0, 0, 0, 0, 0, 0, 159390, 0, 0, 0, 0, 0, 0, 0, 41488), -- 35507
+(30401, 1, 0, 0, 0, 0, 0, 0, 0, 122118, 0, 0, 0, 0, 0, 0, 0, 41079), -- 30401
+(30285, 1, 0, 0, 0, 0, 0, 0, 0, 121595, 0, 0, 0, 0, 0, 0, 0, 41079), -- 30285
+(28888, 1, 0, 0, 0, 0, 0, 0, 0, 108893, 0, 0, 0, 0, 0, 0, 0, 41079), -- 28888
+(28892, 1, 0, 0, 0, 0, 0, 0, 0, 108902, 0, 0, 0, 0, 0, 0, 0, 41079), -- 28892
+(28891, 1, 0, 0, 0, 0, 0, 0, 0, 108899, 0, 0, 0, 0, 0, 0, 0, 41079), -- 28891
+(28890, 1, 0, 0, 0, 0, 0, 0, 0, 108897, 0, 0, 0, 0, 0, 0, 0, 41079), -- 28890
+(28889, 1, 0, 0, 0, 0, 0, 0, 0, 108895, 0, 0, 0, 0, 0, 0, 0, 41079), -- 28889
+(28894, 1, 0, 0, 0, 0, 0, 0, 0, 108904, 0, 0, 0, 0, 0, 0, 0, 41079), -- 28894
+(28893, 1, 0, 0, 0, 0, 0, 0, 0, 108903, 0, 0, 0, 0, 0, 0, 0, 41079), -- 28893
+(29843, 1, 0, 0, 0, 0, 0, 0, 0, 118722, 0, 0, 0, 0, 0, 0, 0, 41079), -- 29843
+(28899, 1, 0, 0, 0, 0, 0, 0, 0, 108932, 0, 0, 0, 0, 0, 0, 0, 41079), -- 28899
+(28277, 1, 0, 0, 0, 0, 0, 0, 0, 104890, 0, 0, 0, 0, 0, 0, 0, 41079), -- 28277
+(32402, 1, 0, 0, 0, 0, 0, 0, 0, 133871, 0, 0, 0, 0, 0, 0, 0, 41079), -- 32402
+(43638, 0, 0, 0, 0, 0, 0, 0, 0, 213205, 0, 0, 0, 0, 0, 0, 0, 41079), -- 43638
+(23967, 1, 0, 0, 0, 0, 0, 0, 0, 82766, 0, 0, 0, 0, 0, 0, 0, 40906), -- 23967
+(33967, 1, 0, 0, 0, 0, 0, 0, 0, 147162, 0, 0, 0, 0, 0, 0, 0, 40906), -- 33967
+(38053, 1, 0, 0, 0, 0, 0, 0, 0, 174937, 0, 0, 0, 0, 0, 0, 0, 40906), -- 38053
+(37391, 1, 0, 0, 0, 0, 0, 0, 0, 169609, 0, 0, 0, 0, 0, 0, 0, 40906), -- 37391
+(33580, 1, 0, 0, 0, 0, 0, 0, 0, 143466, 0, 0, 0, 0, 0, 0, 0, 40906); -- 33580
+
+UPDATE `npc_text` SET `VerifiedBuild`=40871 WHERE `ID` IN (40493, 7778, 42426);
+UPDATE `npc_text` SET `VerifiedBuild`=40906 WHERE `ID` IN (539, 13449, 42426, 34293, 34299, 33680, 33683, 36247, 37697, 33984, 18046, 33998, 2593, 39712, 24075, 10653, 27478, 7778, 25685, 14128, 5880, 5879, 25180, 38826, 39711, 30675, 34003, 17494, 29522, 28006, 27368, 14125, 26678, 26585, 27812, 16706, 27436, 28684, 28496, 28494, 9546, 27813, 12487, 31032, 5674, 13845, 29485, 28502, 30685, 26474, 26965, 27097, 27896, 26986, 27231, 27230, 14712, 14127, 27453, 27584, 27583, 27917, 28482, 9384, 27281, 29022, 13581, 9916, 7028, 9260, 6961, 16573, 9385, 14689, 10846, 9023, 9599, 10817, 12283, 12282, 1205, 38765, 563, 18292, 18302, 18299, 18463, 16559, 32787, 27472, 13375, 14421, 14180, 14087, 14043, 11662, 12937, 13035, 11691, 11688, 13089, 12718, 13702, 14041, 13735, 13842, 18324, 38114, 37618, 37614, 38060, 38074, 38058, 37933, 37545, 37792, 34160, 33579, 34711, 38121, 38122, 38123, 33191, 20227, 33584);
+UPDATE `npc_text` SET `BroadcastTextId0`=31359, `VerifiedBuild`=40906 WHERE `ID`=13841; -- 13841
+UPDATE `npc_text` SET `BroadcastTextId0`=30959, `VerifiedBuild`=40906 WHERE `ID`=13738; -- 13738
+UPDATE `npc_text` SET `BroadcastTextId0`=53144, `VerifiedBuild`=40906 WHERE `ID`=18322; -- 18322
+UPDATE `npc_text` SET `BroadcastTextId0`=32183, `VerifiedBuild`=40906 WHERE `ID`=14014; -- 14014
+UPDATE `npc_text` SET `VerifiedBuild`=40944 WHERE `ID` IN (7778, 39418, 40347, 18294, 18313, 9118, 9119, 18463, 20786, 18330, 9836, 42090, 40297, 42426, 42400, 38448, 40141, 39959, 41851, 40584, 41630, 41797, 37277, 27251, 40157, 42827, 41566, 40493, 41573, 13883, 13101, 13100, 18593, 18613, 14215, 18329, 9090, 9779, 9778, 40538, 40818, 40648, 41479, 14783, 42942, 43083, 43075, 42934, 42523, 25829);
+UPDATE `npc_text` SET `VerifiedBuild`=40966 WHERE `ID` IN (5108, 5715, 8805, 2135, 16437, 3488, 16440, 12495, 8855, 18046, 6164, 825, 16418, 5535, 3357, 5074, 27181, 7965, 16441, 5345, 16335, 16336, 5002, 17881, 5839, 5253, 17000, 17169, 822, 16181, 6413, 17772, 7175, 7241, 17511, 6595, 17418, 5084, 4474, 5099, 3194, 14940, 5046, 5089, 5139, 5162, 22269, 5006, 5716, 1734, 5193, 5228, 5355, 5294, 5566, 5556, 5434, 1619, 3421, 20019, 10846, 11042, 3653, 6159, 3666, 5454, 5455, 13441, 5431, 5233, 563, 16583, 4097, 4984, 5720, 4796, 1853, 821, 17608, 14446, 5840, 4439, 15526, 15461, 5282, 4134, 3753, 3978, 4356, 16989, 8836, 8411, 8464, 9005, 8617, 9191, 9185, 9186, 13584, 9019, 8445, 8515, 8423, 8699, 8421, 8556, 7778, 9187, 16540, 9193, 9189, 17126, 17125, 12549, 10451, 8413, 10886, 11459, 9350, 9338, 9316, 7015, 12336, 12342, 12341, 12335, 9008, 13583, 11049, 9599, 6961, 7028, 9577, 8618, 8549, 16573, 10454, 10455, 12370, 19889, 9384, 9084, 10872, 11458, 11045, 11055, 9385, 42426, 40818, 41630, 42942, 43075, 42934, 42393, 41789, 41822, 42366, 40493, 39418);
+UPDATE `npc_text` SET `BroadcastTextId0`=6479, `VerifiedBuild`=40966 WHERE `ID`=3939; -- 3939
+UPDATE `npc_text` SET `VerifiedBuild`=41031 WHERE `ID` IN (9977, 29788, 38744, 22898, 580, 40648, 43297, 42426, 40538, 7778, 24599, 28096, 37277, 14783, 42638, 42090, 39445, 39125, 39333, 39447, 42127, 40493, 40584, 41630, 40818, 27251, 39418, 39164, 42758, 42523, 41797, 43429);
+UPDATE `npc_text` SET `VerifiedBuild`=41079 WHERE `ID` IN (40648, 42482, 42426, 27251, 42366, 40297, 41975, 42719, 43243, 43048, 43001, 43227, 40584, 43267, 43266, 43265, 43002, 43225, 36247, 37697, 32151, 19888, 40493, 40077, 33815, 39447, 7778, 42091, 39164, 42758, 37249, 42090, 39549, 42088, 38448, 41851, 40818, 23466, 16587, 20638, 20632, 19935, 19934, 4513, 21138, 10221, 2593, 41841, 43065, 43059, 43056, 42823, 43483, 41479, 42127, 42929, 43180, 43264, 39125, 41630, 42141, 43297, 39418, 42778, 14740, 14742, 9118, 18297, 9580, 9579, 9578, 9090, 9779, 9778, 14690, 40347, 20651, 1511, 15909, 35814, 34324, 42407, 17608, 14783, 42394, 42393, 42488, 36652, 32148, 12539, 40535, 29837, 938, 18217, 7174, 13444, 13397, 13395, 13419, 13402, 13432, 13355, 13433, 26333, 26240, 26241, 26234, 26233, 26703, 26757, 29307, 26330, 26237, 26277, 12487, 28878, 30649, 43580, 43579, 41832);
+UPDATE `npc_text` SET `VerifiedBuild`=41323 WHERE `ID` IN (43483, 42426, 40394, 40384, 42360, 41744, 32151, 43225);
+UPDATE `npc_text` SET `VerifiedBuild`=41359 WHERE `ID` IN (37277, 29236, 29220, 29231, 14783, 29265, 29229, 29232, 29227, 40818, 29230, 29222, 29228, 29234, 29235, 29218, 29253, 28836, 29022, 37697, 14952, 14951, 14950, 14949, 14948, 14947, 14946, 14945, 14977, 14969, 14742, 14768, 14770, 37793, 14127, 37792, 42366, 43048, 43099, 42721, 43225, 40297, 42942, 43075, 43085, 42934, 40584, 43297, 41975, 43331, 42929, 43171, 43328, 30587, 8678, 12487, 13846, 41148, 41841, 42426, 41768, 7778, 31138, 14712, 14749, 14748, 14747, 14746, 14745, 14744, 18300, 18297, 9125, 9121, 18299, 12498, 18354, 2593, 14690, 14740, 31110, 31696, 30675, 31109, 29298, 30575);
+UPDATE `npc_text` SET `BroadcastTextId0`=32183, `VerifiedBuild`=41359 WHERE `ID`=14014; -- 14014
+UPDATE `npc_text` SET `VerifiedBuild`=41488 WHERE `ID` IN (39125, 38765, 9186, 8790, 17445, 42407, 14723, 563, 6194, 39329, 39549, 43449, 42426, 40818, 40339, 6922, 6882, 6876, 6923, 16716, 16726, 6694, 5516, 37144, 37367, 9977, 39164, 42758, 41975, 40297, 43048, 43268, 43267, 43266, 43265, 43099, 42721, 43163, 43225, 38529, 7778, 42114, 42084, 42087, 43061, 42823, 41630, 43180, 30737, 12487, 42942, 43085, 42934, 8077, 8076, 40466, 40471, 40469, 40468, 40335, 40449, 40400, 40394, 40384, 14783, 42366, 35500, 42978, 6935, 41148, 41811, 41814, 41789, 41822);
+UPDATE `npc_text` SET `VerifiedBuild`=41793 WHERE `ID` IN (42488, 42426, 42931, 17946, 8590, 37367, 37250, 10291, 539, 40818, 4693, 42140, 40175);
+