1 files changed, 443 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_04_24_00_world.sql b/sql/updates/world/master/2018_04_24_00_world.sql
new file mode 100644
index 00000000000..d8c34506212
--- /dev/null
+++ b/sql/updates/world/master/2018_04_24_00_world.sql
@@ -0,0 +1,443 @@
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 164 WHERE `ID` IN (38505, 38507, 38543, 38544, 38545, 38546, 38547, 38549, 38550, 38551, 44926, 45044, 45051, 46701);
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 165 WHERE `ID` IN (46689, 46690, 46695, 48078);
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 171 WHERE `ID` IN (30122, 39327, 39330, 39333, 39334, 39338, 39341, 39343, 39345, 39347, 39390, 39430, 39431, 39645, 44112);
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 182 WHERE `ID` IN (40013, 40015, 40018, 40020, 40022, 40024, 40025, 40028, 40029, 40030, 40032, 40034, 40036, 40038, 40040, 48027, 48028, 48029);
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 185 WHERE `ID` IN (30330, 30331, 33022);
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 197 WHERE `ID` = 46683;
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 202 WHERE `ID` IN (40545, 40859, 40860, 40862, 40869, 40872, 48056, 48065);
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 356 WHERE `ID` IN (30613, 30658, 30678, 31664, 36131, 36132, 36201, 36202, 36608, 36609, 36611, 36882, 40960, 40961);
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 755 WHERE `ID` IN (29969, 29970, 39183, 39184, 39185, 39186, 39187, 40539, 40558);
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 773 WHERE `ID` IN (39695, 39847, 39942, 39950, 39951, 39952, 40062, 40064, 40065);
+UPDATE `quest_template_addon` SET `RequiredSkillId` = 794 WHERE `ID` IN (40349, 40350, 40351, 40352, 40353, 40354, 40355, 40356, 40357, 40358, 40359, 40360, 40361, 40362, 40363, 41167, 41168, 41178, 41179, 41187);
+
+DELETE FROM `quest_template_addon` WHERE `ID` IN (30328, 30329, 30332, 30584, 30585, 30586, 30588, 30597, 30598, 30698, 30700, 30701, 30753, 30754, 30763, 31443, 31444, 31446, 31752, 32107, 32435, 32436, 33018, 33019, 33020, 33021, 33023, 33024, 33025, 33026, 33027, 33107, 33139, 33146, 33358, 34193, 34194, 34758, 34774, 34846, 35066, 35071, 35072, 35073, 35074, 35075, 35296, 36141, 36199, 36404, 36510, 36511, 36513, 36514, 36515, 36517, 36612, 36616, 36800, 36802, 36803, 36804, 36805, 36806, 36870, 37270, 38243, 38287, 38290, 38293, 38296, 38399, 38406, 38499, 38500, 38501, 38502, 38506, 38513, 38514, 38515, 38518, 38519, 38522, 38523, 38524, 38525, 38526, 38527, 38528, 38530, 38531, 38532, 38533, 38534, 38536, 38537, 38538, 38539, 38540, 38541, 38542, 38559, 38563, 38564, 38833, 38944, 38945, 38946, 38947, 38948, 38949, 38950, 38951, 38952, 38953, 38954, 38955, 38956, 38957, 38958, 38959, 38960, 38961, 38962, 38963, 38964, 38965, 38966, 38967, 38968, 38969, 38970, 38971, 38974, 38975, 38976, 38977, 38978, 38979, 38980, 38981, 38982, 38983, 39175, 39176, 39177, 39195, 39283, 39325, 39326, 39328, 39329, 39331, 39332, 39335, 39336, 39337, 39339, 39340, 39342, 39344, 39346, 39348, 39349, 39350, 39351, 39566, 39602, 39605, 39667, 39680, 39681, 39699, 39702, 39726, 39729, 39931, 39932, 39933, 39934, 39935, 39936, 39937, 39938, 39939, 39940, 39941, 39943, 39944, 39945, 39946, 39947, 39948, 39949, 39953, 39954, 39955, 39956, 39957, 39958, 39959, 39960, 39961, 40014, 40016, 40017, 40019, 40021, 40023, 40026, 40031, 40033, 40035, 40037, 40039, 40041, 40042, 40052, 40056, 40057, 40058, 40059, 40060, 40061, 40063, 40176, 40177, 40178, 40179, 40180, 40181, 40182, 40183, 40184, 40185, 40186, 40187, 40188, 40189, 40190, 40191, 40192, 40193, 40194, 40195, 40196, 40197, 40198, 40199, 40200, 40201, 40202, 40203, 40204, 40205, 40206, 40207, 40208, 40209, 40210, 40211, 40212, 40213, 40214, 40215, 40241, 40302, 40303, 40304, 40327, 40415, 40523, 40524, 40525, 40526, 40527, 40528, 40529, 40530, 40531, 40532, 40533, 40534, 40535, 40536, 40538, 40540, 40541, 40542, 40543, 40544, 40546, 40547, 40556, 40557, 40559, 40560, 40561, 40562, 40753, 40854, 40855, 40856, 40857, 40858, 40861, 40863, 40864, 40865, 40866, 40867, 40868, 40870, 40871, 40873, 40874, 40875, 40876, 40877, 40878, 40879, 40880, 40881, 40882, 40988, 40989, 40990, 40991, 41010, 41157, 41158, 41159, 41160, 41161, 41162, 41163, 41164, 41165, 41166, 41169, 41170, 41171, 41172, 41173, 41174, 41175, 41176, 41177, 41180, 41181, 41182, 41183, 41184, 41185, 41186, 41188, 41189, 41190, 41191, 41192, 41193, 41802, 41889, 41985, 42058, 42081, 42214, 42215, 42245, 42250, 42255, 42303, 42308, 42309, 42323, 42333, 42334, 42340, 42345, 42350, 42351, 43726, 43929, 44449, 44581, 44741, 44863, 44927, 44952, 45055, 45057, 46119, 46128, 46678, 46679, 46680, 46681, 46682, 46684, 46685, 46686, 46687, 46688, 46691, 46692, 46693, 46694, 46696, 46697, 46698, 46699, 46700, 46709, 47092, 47093, 47094, 47095, 47096, 48002, 48013, 48016, 48053, 48054, 48055, 48069, 48074, 48075, 48076);
+INSERT INTO `quest_template_addon` (`ID`, `RequiredSkillID`) VALUES
+(30328, 185),
+(30329, 185),
+(30332, 185),
+(30584, 356),
+(30585, 356),
+(30586, 356),
+(30588, 356),
+(30597, 171),
+(30598, 356),
+(30698, 356),
+(30700, 356),
+(30701, 356),
+(30753, 356),
+(30754, 356),
+(30763, 356),
+(31443, 356),
+(31444, 356),
+(31446, 356),
+(31752, 202),
+(32107, 356),
+(32435, 356),
+(32436, 356),
+(33018, 185),
+(33019, 185),
+(33020, 185),
+(33021, 185),
+(33023, 185),
+(33024, 185),
+(33025, 185),
+(33026, 185),
+(33027, 185),
+(33107, 185),
+(33139, 185),
+(33146, 185),
+(33358, 185),
+(34193, 182),
+(34194, 356),
+(34758, 356),
+(34774, 202),
+(34846, 356),
+(35066, 356),
+(35071, 356),
+(35072, 356),
+(35073, 356),
+(35074, 356),
+(35075, 356),
+(35296, 185),
+(36141, 356),
+(36199, 356),
+(36404, 182),
+(36510, 356),
+(36511, 356),
+(36513, 356),
+(36514, 356),
+(36515, 356),
+(36517, 356),
+(36612, 356),
+(36616, 356),
+(36800, 356),
+(36802, 356),
+(36803, 356),
+(36804, 356),
+(36805, 356),
+(36806, 356),
+(36870, 356),
+(37270, 202),
+(38243, 202),
+(38287, 202),
+(38290, 202),
+(38293, 202),
+(38296, 202),
+(38399, 202),
+(38406, 356),
+(38499, 164),
+(38500, 164),
+(38501, 164),
+(38502, 164),
+(38506, 164),
+(38513, 164),
+(38514, 164),
+(38515, 164),
+(38518, 164),
+(38519, 164),
+(38522, 164),
+(38523, 164),
+(38524, 164),
+(38525, 164),
+(38526, 164),
+(38527, 164),
+(38528, 164),
+(38530, 164),
+(38531, 164),
+(38532, 164),
+(38533, 164),
+(38534, 164),
+(38536, 164),
+(38537, 164),
+(38538, 164),
+(38539, 164),
+(38540, 164),
+(38541, 164),
+(38542, 164),
+(38559, 164),
+(38563, 164),
+(38564, 164),
+(38833, 164),
+(38944, 197),
+(38945, 197),
+(38946, 197),
+(38947, 197),
+(38948, 197),
+(38949, 197),
+(38950, 197),
+(38951, 197),
+(38952, 197),
+(38953, 197),
+(38954, 197),
+(38955, 197),
+(38956, 197),
+(38957, 197),
+(38958, 197),
+(38959, 197),
+(38960, 197),
+(38961, 197),
+(38962, 197),
+(38963, 197),
+(38964, 197),
+(38965, 197),
+(38966, 197),
+(38967, 197),
+(38968, 197),
+(38969, 197),
+(38970, 197),
+(38971, 197),
+(38974, 197),
+(38975, 197),
+(38976, 197),
+(38977, 197),
+(38978, 197),
+(38979, 197),
+(38980, 197),
+(38981, 197),
+(38982, 197),
+(38983, 197),
+(39175, 755),
+(39176, 755),
+(39177, 755),
+(39195, 755),
+(39283, 356),
+(39325, 171),
+(39326, 171),
+(39328, 171),
+(39329, 171),
+(39331, 171),
+(39332, 171),
+(39335, 171),
+(39336, 171),
+(39337, 171),
+(39339, 171),
+(39340, 171),
+(39342, 171),
+(39344, 171),
+(39346, 171),
+(39348, 171),
+(39349, 171),
+(39350, 171),
+(39351, 171),
+(39566, 171),
+(39602, 197),
+(39605, 197),
+(39667, 197),
+(39680, 164),
+(39681, 164),
+(39699, 164),
+(39702, 164),
+(39726, 164),
+(39729, 164),
+(39931, 773),
+(39932, 773),
+(39933, 773),
+(39934, 773),
+(39935, 773),
+(39936, 773),
+(39937, 773),
+(39938, 773),
+(39939, 773),
+(39940, 773),
+(39941, 773),
+(39943, 773),
+(39944, 773),
+(39945, 773),
+(39946, 773),
+(39947, 773),
+(39948, 773),
+(39949, 773),
+(39953, 773),
+(39954, 773),
+(39955, 773),
+(39956, 773),
+(39957, 773),
+(39958, 165),
+(39959, 773),
+(39960, 773),
+(39961, 773),
+(40014, 182),
+(40016, 182),
+(40017, 182),
+(40019, 182),
+(40021, 182),
+(40023, 182),
+(40026, 182),
+(40031, 182),
+(40033, 182),
+(40035, 182),
+(40037, 182),
+(40039, 182),
+(40041, 182),
+(40042, 182),
+(40052, 773),
+(40056, 773),
+(40057, 773),
+(40058, 773),
+(40059, 773),
+(40060, 773),
+(40061, 773),
+(40063, 773),
+(40176, 165),
+(40177, 165),
+(40178, 165),
+(40179, 165),
+(40180, 165),
+(40181, 165),
+(40182, 165),
+(40183, 165),
+(40184, 165),
+(40185, 165),
+(40186, 165),
+(40187, 165),
+(40188, 165),
+(40189, 165),
+(40190, 165),
+(40191, 165),
+(40192, 165),
+(40193, 165),
+(40194, 165),
+(40195, 165),
+(40196, 165),
+(40197, 165),
+(40198, 165),
+(40199, 165),
+(40200, 165),
+(40201, 165),
+(40202, 165),
+(40203, 165),
+(40204, 165),
+(40205, 165),
+(40206, 165),
+(40207, 165),
+(40208, 165),
+(40209, 165),
+(40210, 165),
+(40211, 165),
+(40212, 165),
+(40213, 165),
+(40214, 165),
+(40215, 165),
+(40241, 165),
+(40302, 755),
+(40303, 755),
+(40304, 755),
+(40327, 165),
+(40415, 165),
+(40523, 755),
+(40524, 755),
+(40525, 755),
+(40526, 755),
+(40527, 755),
+(40528, 755),
+(40529, 755),
+(40530, 755),
+(40531, 755),
+(40532, 755),
+(40533, 755),
+(40534, 755),
+(40535, 755),
+(40536, 755),
+(40538, 755),
+(40540, 755),
+(40541, 755),
+(40542, 755),
+(40543, 755),
+(40544, 755),
+(40546, 755),
+(40547, 755),
+(40556, 755),
+(40557, 755),
+(40559, 755),
+(40560, 755),
+(40561, 755),
+(40562, 755),
+(40753, 202),
+(40854, 202),
+(40855, 202),
+(40856, 202),
+(40857, 794),
+(40858, 202),
+(40861, 202),
+(40863, 202),
+(40864, 202),
+(40865, 202),
+(40866, 202),
+(40867, 202),
+(40868, 202),
+(40870, 202),
+(40871, 202),
+(40873, 202),
+(40874, 202),
+(40875, 202),
+(40876, 202),
+(40877, 202),
+(40878, 202),
+(40879, 202),
+(40880, 202),
+(40881, 202),
+(40882, 202),
+(40988, 185),
+(40989, 185),
+(40990, 185),
+(40991, 185),
+(41010, 356),
+(41157, 794),
+(41158, 794),
+(41159, 794),
+(41160, 164),
+(41161, 794),
+(41162, 794),
+(41163, 794),
+(41164, 794),
+(41165, 794),
+(41166, 794),
+(41169, 794),
+(41170, 794),
+(41171, 794),
+(41172, 794),
+(41173, 794),
+(41174, 794),
+(41175, 794),
+(41176, 794),
+(41177, 794),
+(41180, 794),
+(41181, 794),
+(41182, 794),
+(41183, 794),
+(41184, 794),
+(41185, 794),
+(41186, 794),
+(41188, 794),
+(41189, 794),
+(41190, 794),
+(41191, 794),
+(41192, 794),
+(41193, 794),
+(41802, 794),
+(41889, 165),
+(41985, 129),
+(42058, 129),
+(42081, 171),
+(42214, 755),
+(42215, 129),
+(42245, 129),
+(42250, 129),
+(42255, 129),
+(42303, 129),
+(42308, 129),
+(42309, 129),
+(42323, 129),
+(42333, 129),
+(42334, 129),
+(42340, 129),
+(42345, 129),
+(42350, 129),
+(42351, 129),
+(43726, 773),
+(43929, 773),
+(44449, 164),
+(44581, 185),
+(44741, 197),
+(44863, 164),
+(44927, 164),
+(44952, 164),
+(45055, 164),
+(45057, 164),
+(46119, 202),
+(46128, 202),
+(46678, 197),
+(46679, 197),
+(46680, 197),
+(46681, 197),
+(46682, 197),
+(46684, 165),
+(46685, 165),
+(46686, 165),
+(46687, 165),
+(46688, 165),
+(46691, 165),
+(46692, 165),
+(46693, 165),
+(46694, 165),
+(46696, 164),
+(46697, 164),
+(46698, 164),
+(46699, 164),
+(46700, 164),
+(46709, 164),
+(47092, 164),
+(47093, 164),
+(47094, 164),
+(47095, 164),
+(47096, 164),
+(48002, 171),
+(48013, 171),
+(48016, 171),
+(48053, 164),
+(48054, 164),
+(48055, 164),
+(48069, 202),
+(48074, 197),
+(48075, 755),
+(48076, 755);