1 files changed, 320 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_04_22_00_world.sql b/sql/updates/world/master/2018_04_22_00_world.sql
new file mode 100644
index 00000000000..124e041bb22
--- /dev/null
+++ b/sql/updates/world/master/2018_04_22_00_world.sql
@@ -0,0 +1,320 @@
+-- 
+UPDATE `quest_template_addon` SET `ProvidedItemCount` = 1 WHERE `ID` IN (24471, 24623, 24813, 27671, 26333, 31156, 35057);
+DELETE FROM `quest_template_addon` WHERE `ID` IN (31541, 31543, 31544, 32836, 32838, 32840, 32842, 32844, 32846, 32848, 32850, 32852, 32854, 32856, 32858, 37469, 37565, 37653, 38015, 38035, 38307, 38407, 38505, 38507, 38552, 38641, 38646, 38697, 38724, 38777, 38784, 38785, 38786, 38789, 38790, 38791, 38795, 38796, 38797, 38800, 38801, 38802, 38806, 38937, 39060, 39125, 39142, 39277, 39305, 39327, 39330, 39333, 39334, 39338, 39341, 39343, 39345, 39347, 39390, 39405, 39430, 39431, 39595, 39645, 39656, 39790, 39791, 39847, 39876, 39877, 39883, 39942, 39950, 39951, 39952, 39987, 40003, 40011, 40013, 40015, 40018, 40020, 40022, 40024, 40025, 40028, 40029, 40030, 40032, 40034, 40036, 40038, 40040, 40062, 40064, 40065, 40120, 40129, 40131, 40133, 40136, 40141, 40143, 40151, 40156, 40169, 40217, 40228, 40267, 40321, 40349, 40350, 40351, 40352, 40353, 40354, 40355, 40356, 40357, 40358, 40359, 40360, 40361, 40362, 40363, 40370, 40519, 40539, 40545, 40558, 40570, 40615, 40647, 40725, 40749, 40794, 40798, 40832, 40859, 40860, 40862, 40869, 40872, 40890, 40901, 40904, 40919, 40947, 40956, 40960, 40961, 40963, 41112, 41137, 41167, 41168, 41178, 41179, 41187, 41216, 41255, 41436, 41626, 41770, 41771, 41778, 41784, 41787, 41919, 42006, 42042, 42079, 42090, 42133, 42147, 42213, 42244, 42387, 42406, 42430, 42454, 42487, 42494, 42503, 42510, 42640, 42641, 42707, 42750, 42884, 42955, 42956, 42962, 43003, 43376, 43565, 43819, 43826, 43827, 43926, 43942, 44112, 44153, 44448, 44457, 44490, 44546, 44558, 44672, 44684, 44685, 44719, 44733, 44754, 44767, 44813, 44815, 44816, 44842, 44925, 44926, 44928, 45026, 45044, 45051, 45061, 45062, 45063, 45064, 45065, 45118, 45159, 45176, 45260, 45261, 45262, 45263, 45265, 45266, 45267, 45268, 45269, 45296, 45342, 45346, 45405, 45482, 45545, 45570, 45586, 45726, 45747, 45748, 45749, 45750, 45751, 45752, 45753, 45754, 45755, 45756, 45757, 45758, 45759, 45760, 45761, 45762, 45771, 46268, 46683, 46689, 46690, 46695, 46701, 46725, 46810, 46935, 46946, 47049, 47050, 47051, 47052, 47067, 47102, 47180, 47220, 47563, 47745, 47750, 47882, 47987, 48027, 48028, 48029, 48034, 48035, 48036, 48037, 48038, 48039, 48040, 48041, 48042, 48056, 48065, 48078, 48231, 48483, 48559, 48560, 48637, 48640, 48691, 48864, 48954, 49077);
+INSERT INTO `quest_template_addon` (`ID`, `ProvidedItemCount`) VALUES
+(31541, 1),
+(31543, 1),
+(31544, 1),
+(32836, 1),
+(32838, 1),
+(32840, 1),
+(32842, 1),
+(32844, 1),
+(32846, 1),
+(32848, 1),
+(32850, 1),
+(32852, 1),
+(32854, 1),
+(32856, 1),
+(32858, 1),
+(37469, 1),
+(37565, 1),
+(37653, 1),
+(38015, 1),
+(38035, 1),
+(38307, 1),
+(38407, 1),
+(38505, 1),
+(38507, 1),
+(38552, 1),
+(38641, 1),
+(38646, 1),
+(38697, 1),
+(38724, 1),
+(38777, 1),
+(38784, 1),
+(38785, 1),
+(38786, 1),
+(38789, 1),
+(38790, 1),
+(38791, 1),
+(38795, 1),
+(38796, 1),
+(38797, 1),
+(38800, 1),
+(38801, 1),
+(38802, 1),
+(38806, 1),
+(38937, 1),
+(39060, 1),
+(39125, 1),
+(39142, 1),
+(39277, 1),
+(39305, 1),
+(39327, 1),
+(39330, 1),
+(39333, 1),
+(39334, 1),
+(39338, 1),
+(39341, 1),
+(39343, 1),
+(39345, 1),
+(39347, 1),
+(39390, 1),
+(39405, 1),
+(39430, 1),
+(39431, 1),
+(39595, 1),
+(39645, 1),
+(39656, 1),
+(39790, 1),
+(39791, 1),
+(39847, 1),
+(39876, 1),
+(39877, 1),
+(39883, 1),
+(39942, 1),
+(39950, 1),
+(39951, 1),
+(39952, 1),
+(39987, 1),
+(40003, 1),
+(40011, 1),
+(40013, 1),
+(40015, 1),
+(40018, 1),
+(40020, 1),
+(40022, 1),
+(40024, 1),
+(40025, 1),
+(40028, 1),
+(40029, 1),
+(40030, 1),
+(40032, 1),
+(40034, 1),
+(40036, 1),
+(40038, 1),
+(40040, 1),
+(40062, 1),
+(40064, 1),
+(40065, 1),
+(40120, 1),
+(40129, 1),
+(40131, 1),
+(40133, 1),
+(40136, 1),
+(40141, 1),
+(40143, 1),
+(40151, 1),
+(40156, 1),
+(40169, 1),
+(40217, 1),
+(40228, 1),
+(40267, 1),
+(40321, 1),
+(40349, 1),
+(40350, 1),
+(40351, 1),
+(40352, 1),
+(40353, 1),
+(40354, 1),
+(40355, 1),
+(40356, 1),
+(40357, 1),
+(40358, 1),
+(40359, 1),
+(40360, 1),
+(40361, 1),
+(40362, 1),
+(40363, 1),
+(40370, 1),
+(40519, 1),
+(40539, 1),
+(40545, 1),
+(40558, 1),
+(40570, 1),
+(40615, 1),
+(40647, 1),
+(40725, 1),
+(40749, 1),
+(40794, 1),
+(40798, 1),
+(40832, 1),
+(40859, 1),
+(40860, 1),
+(40862, 1),
+(40869, 1),
+(40872, 1),
+(40890, 1),
+(40901, 1),
+(40904, 1),
+(40919, 1),
+(40947, 1),
+(40956, 1),
+(40960, 1),
+(40961, 1),
+(40963, 1),
+(41112, 1),
+(41137, 1),
+(41167, 1),
+(41168, 1),
+(41178, 1),
+(41179, 1),
+(41187, 1),
+(41216, 1),
+(41255, 1),
+(41436, 1),
+(41626, 1),
+(41770, 1),
+(41771, 1),
+(41778, 1),
+(41784, 1),
+(41787, 1),
+(41919, 1),
+(42006, 1),
+(42042, 1),
+(42079, 1),
+(42090, 1),
+(42133, 1),
+(42147, 1),
+(42213, 1),
+(42244, 1),
+(42387, 1),
+(42406, 1),
+(42430, 1),
+(42454, 1),
+(42487, 1),
+(42494, 1),
+(42503, 1),
+(42510, 1),
+(42640, 1),
+(42641, 1),
+(42707, 1),
+(42750, 1),
+(42884, 1),
+(42955, 1),
+(42956, 1),
+(42962, 1),
+(43003, 1),
+(43376, 1),
+(43565, 1),
+(43819, 1),
+(43826, 1),
+(43827, 1),
+(43926, 1),
+(43942, 1),
+(44112, 1),
+(44153, 1),
+(44448, 1),
+(44457, 1),
+(44490, 1),
+(44546, 1),
+(44558, 1),
+(44672, 1),
+(44684, 1),
+(44685, 1),
+(44719, 1),
+(44733, 1),
+(44754, 1),
+(44767, 1),
+(44813, 1),
+(44815, 1),
+(44816, 1),
+(44842, 1),
+(44925, 1),
+(44926, 1),
+(44928, 1),
+(45026, 1),
+(45044, 1),
+(45051, 1),
+(45061, 1),
+(45062, 1),
+(45063, 1),
+(45064, 1),
+(45065, 1),
+(45118, 1),
+(45159, 1),
+(45176, 1),
+(45260, 1),
+(45261, 1),
+(45262, 1),
+(45263, 1),
+(45265, 1),
+(45266, 1),
+(45267, 1),
+(45268, 1),
+(45269, 1),
+(45296, 1),
+(45342, 1),
+(45346, 1),
+(45405, 1),
+(45482, 1),
+(45545, 1),
+(45570, 1),
+(45586, 1),
+(45726, 1),
+(45747, 1),
+(45748, 1),
+(45749, 1),
+(45750, 1),
+(45751, 1),
+(45752, 1),
+(45753, 1),
+(45754, 1),
+(45755, 1),
+(45756, 1),
+(45757, 1),
+(45758, 1),
+(45759, 1),
+(45760, 1),
+(45761, 1),
+(45762, 1),
+(45771, 1),
+(46268, 1),
+(46683, 1),
+(46689, 1),
+(46690, 1),
+(46695, 1),
+(46701, 1),
+(46725, 1),
+(46810, 1),
+(46935, 1),
+(46946, 1),
+(47049, 1),
+(47050, 1),
+(47051, 1),
+(47052, 1),
+(47067, 1),
+(47102, 1),
+(47180, 1),
+(47220, 1),
+(47563, 1),
+(47745, 1),
+(47750, 1),
+(47882, 1),
+(47987, 1),
+(48027, 1),
+(48028, 1),
+(48029, 1),
+(48034, 1),
+(48035, 1),
+(48036, 1),
+(48037, 1),
+(48038, 1),
+(48039, 1),
+(48040, 1),
+(48041, 1),
+(48042, 1),
+(48056, 1),
+(48065, 1),
+(48078, 1),
+(48231, 1),
+(48483, 1),
+(48559, 1),
+(48560, 1),
+(48637, 1),
+(48640, 1),
+(48691, 1),
+(48864, 1),
+(48954, 1),
+(49077, 1);