Merge pull request #4616 from kandera/fix_seasonal_quest_reset

Core/Quests: Add implementation of seasonal quest reset

2 files changed, 395 insertions, 0 deletions

diff --git a/sql/updates/world/2012_01_03_00_world_game_event_seasonal_questrelation.sql b/sql/updates/world/2012_01_03_00_world_game_event_seasonal_questrelation.sql
new file mode 100644
index 00000000000..b4ff9c1da5e
--- /dev/null
+++ b/sql/updates/world/2012_01_03_00_world_game_event_seasonal_questrelation.sql
@@ -0,0 +1,387 @@
+DROP TABLE IF EXISTS `game_event_seasonal_questrelation`;
+CREATE TABLE `game_event_seasonal_questrelation` (
+  `quest` mediumint(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `event` mediumint(10) NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
+  PRIMARY KEY (`quest`,`event`),
+  KEY `idx_quest` (`quest`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
+
+INSERT INTO `game_event_seasonal_questrelation` (`quest`,`event`) VALUES
+	(1657, 12),
+	(1658, 12),
+	(6961, 2),
+	(6962, 2),
+	(6963, 2),
+	(6964, 2),
+	(6983, 3),
+	(6984, 3),
+	(7021, 2),
+	(7022, 2),
+	(7023, 2),
+	(7024, 2),
+	(7025, 2),
+	(7042, 2),
+	(7043, 2),
+	(7045, 2),
+	(7061, 2),
+	(7062, 2),
+	(7063, 2),
+	(8149, 11),
+	(8150, 11),
+	(8311, 12),
+	(8312, 12),
+	(8322, 12),
+	(8353, 12),
+	(8354, 12),
+	(8355, 12),
+	(8356, 12),
+	(8357, 12),
+	(8358, 12),
+	(8359, 12),
+	(8360, 12),
+	(8373, 12),
+	(8409, 12),
+	(8744, 52),
+	(8746, 2),
+	(8762, 2),
+	(8763, 2),
+	(8767, 52),
+	(8768, 52),
+	(8769, 52),
+	(8788, 52),
+	(8799, 2),
+	(8803, 52),
+	(8827, 2),
+	(8828, 2),
+	(8860, 6),
+	(8861, 6),
+	(8868, 7),
+	(8897, 8),
+	(8898, 8),
+	(8899, 8),
+	(8900, 8),
+	(8901, 8),
+	(8902, 8),
+	(8903, 8),
+	(8904, 8),
+	(8971, -1),
+	(8972, -1),
+	(8973, -1),
+	(8974, -1),
+	(8975, -1),
+	(8976, -1),
+	(8979, 8),
+	(8980, 8),
+	(8981, 8),
+	(8982, 8),
+	(8983, 8),
+	(8984, 8),
+	(8993, 8),
+	(9024, 8),
+	(9025, 8),
+	(9026, 8),
+	(9027, 8),
+	(9028, 8),
+	(11131, 12),
+	(11135, 12),
+	(11219, 12),
+	(11220, 12),
+	(11242, 12),
+	(11356, 12),
+	(11357, 12),
+	(11360, 12),
+	(11361, 12),
+	(11392, 12),
+	(11401, 12),
+	(11403, 12),
+	(11404, 12),
+	(11405, 12),
+	(11435, 12),
+	(11439, 12),
+	(11440, 12),
+	(11449, 12),
+	(11450, 12),
+	(11528, 52),
+	(11558, 8),
+	(11580, 1),
+	(11581, 1),
+	(11583, 1),
+	(11584, 1),
+	(11696, 1),
+	(11732, 1),
+	(11734, 1),
+	(11735, 1),
+	(11736, 1),
+	(11737, 1),
+	(11738, 1),
+	(11739, 1),
+	(11740, 1),
+	(11741, 1),
+	(11742, 1),
+	(11743, 1),
+	(11744, 1),
+	(11745, 1),
+	(11746, 1),
+	(11747, 1),
+	(11748, 1),
+	(11749, 1),
+	(11750, 1),
+	(11751, 1),
+	(11752, 1),
+	(11753, 1),
+	(11754, 1),
+	(11755, 1),
+	(11756, 1),
+	(11757, 1),
+	(11758, 1),
+	(11759, 1),
+	(11760, 1),
+	(11761, 1),
+	(11762, 1),
+	(11763, 1),
+	(11764, 1),
+	(11765, 1),
+	(11766, 1),
+	(11767, 1),
+	(11768, 1),
+	(11769, 1),
+	(11770, 1),
+	(11771, 1),
+	(11772, 1),
+	(11773, 1),
+	(11774, 1),
+	(11775, 1),
+	(11776, 1),
+	(11777, 1),
+	(11778, 1),
+	(11779, 1),
+	(11780, 1),
+	(11781, 1),
+	(11782, 1),
+	(11783, 1),
+	(11784, 1),
+	(11785, 1),
+	(11786, 1),
+	(11787, 1),
+	(11799, 1),
+	(11800, 1),
+	(11801, 1),
+	(11802, 1),
+	(11803, 1),
+	(11804, 1),
+	(11805, 1),
+	(11806, 1),
+	(11807, 1),
+	(11808, 1),
+	(11809, 1),
+	(11810, 1),
+	(11811, 1),
+	(11812, 1),
+	(11813, 1),
+	(11814, 1),
+	(11815, 1),
+	(11816, 1),
+	(11817, 1),
+	(11818, 1),
+	(11819, 1),
+	(11820, 1),
+	(11821, 1),
+	(11822, 1),
+	(11823, 1),
+	(11824, 1),
+	(11825, 1),
+	(11826, 1),
+	(11827, 1),
+	(11828, 1),
+	(11829, 1),
+	(11830, 1),
+	(11831, 1),
+	(11832, 1),
+	(11833, 1),
+	(11834, 1),
+	(11835, 1),
+	(11836, 1),
+	(11837, 1),
+	(11838, 1),
+	(11839, 1),
+	(11840, 1),
+	(11841, 1),
+	(11842, 1),
+	(11843, 1),
+	(11844, 1),
+	(11845, 1),
+	(11846, 1),
+	(11847, 1),
+	(11848, 1),
+	(11849, 1),
+	(11850, 1),
+	(11851, 1),
+	(11852, 1),
+	(11853, 1),
+	(11854, 1),
+	(11855, 1),
+	(11856, 1),
+	(11857, 1),
+	(11858, 1),
+	(11859, 1),
+	(11860, 1),
+	(11861, 1),
+	(11862, 1),
+	(11863, 1),
+	(11937, 1),
+	(11976, 1),
+	(12133, 12),
+	(12135, 12),
+	(12139, 12),
+	(12155, 12),
+	(12286, -1),
+	(12313, 24),
+	(12331, 12),
+	(12332, 12),
+	(12333, 12),
+	(12334, 12),
+	(12335, 12),
+	(12336, 12),
+	(12337, 12),
+	(12338, 12),
+	(12339, 12),
+	(12340, 12),
+	(12341, 12),
+	(12342, 12),
+	(12343, 12),
+	(12344, 12),
+	(12345, 12),
+	(12346, 12),
+	(12347, 12),
+	(12348, 12),
+	(12349, 12),
+	(12350, 12),
+	(12351, 12),
+	(12352, 12),
+	(12353, 12),
+	(12354, 12),
+	(12355, 12),
+	(12356, 12),
+	(12357, 12),
+	(12358, 12),
+	(12359, 12),
+	(12360, 12),
+	(12361, 12),
+	(12362, 12),
+	(12363, 12),
+	(12364, 12),
+	(12365, 12),
+	(12366, 12),
+	(12367, 12),
+	(12368, 12),
+	(12369, 12),
+	(12370, 12),
+	(12371, 12),
+	(12373, 12),
+	(12374, 12),
+	(12375, 12),
+	(12376, 12),
+	(12377, 12),
+	(12378, 12),
+	(12379, 12),
+	(12380, 12),
+	(12381, 12),
+	(12382, 12),
+	(12383, 12),
+	(12384, 12),
+	(12385, 12),
+	(12386, 12),
+	(12387, 12),
+	(12388, 12),
+	(12389, 12),
+	(12390, 12),
+	(12391, 12),
+	(12392, 12),
+	(12393, 12),
+	(12394, 12),
+	(12395, 12),
+	(12396, 12),
+	(12397, 12),
+	(12398, 12),
+	(12399, 12),
+	(12400, 12),
+	(12401, 12),
+	(12402, 12),
+	(12403, 12),
+	(12404, 12),
+	(12405, 12),
+	(12406, 12),
+	(12407, 12),
+	(12408, 12),
+	(12409, 12),
+	(12410, 12),
+	(12940, 12),
+	(12941, 12),
+	(12944, 12),
+	(12945, 12),
+	(12946, 12),
+	(12947, 12),
+	(12950, 12),
+	(13203, 52),
+	(13433, 12),
+	(13434, 12),
+	(13435, 12),
+	(13436, 12),
+	(13437, 12),
+	(13438, 12),
+	(13439, 12),
+	(13440, 12),
+	(13441, 12),
+	(13442, 12),
+	(13443, 12),
+	(13444, 12),
+	(13445, 12),
+	(13446, 12),
+	(13447, 12),
+	(13448, 12),
+	(13449, 12),
+	(13450, 12),
+	(13451, 12),
+	(13452, 12),
+	(13453, 12),
+	(13454, 12),
+	(13455, 12),
+	(13456, 12),
+	(13457, 12),
+	(13458, 12),
+	(13459, 12),
+	(13460, 12),
+	(13461, 12),
+	(13462, 12),
+	(13463, 12),
+	(13464, 12),
+	(13465, 12),
+	(13466, 12),
+	(13467, 12),
+	(13468, 12),
+	(13469, 12),
+	(13470, 12),
+	(13471, 12),
+	(13472, 12),
+	(13473, 12),
+	(13474, 12),
+	(13485, 1),
+	(13486, 1),
+	(13487, 1),
+	(13488, 1),
+	(13489, 1),
+	(13490, 1),
+	(13491, 1),
+	(13492, 1),
+	(13493, 1),
+	(13494, 1),
+	(13495, 1),
+	(13496, 1),
+	(13497, 1),
+	(13498, 1),
+	(13499, 1),
+	(13500, 1),
+	(13501, 12),
+	(13548, 12),
+	(13966, 52);
+
diff --git a/sql/updates/world/2012_01_03_01_characters_character_queststatus_seasonal.sql b/sql/updates/world/2012_01_03_01_characters_character_queststatus_seasonal.sql
new file mode 100644
index 00000000000..88264c424cc
--- /dev/null
+++ b/sql/updates/world/2012_01_03_01_characters_character_queststatus_seasonal.sql
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS `character_queststatus_seasonal`;
+CREATE TABLE `character_queststatus_seasonal` (
+  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+  `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
+  `event` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event Identifier',
+  PRIMARY KEY (`guid`,`quest`),
+  KEY `idx_guid` (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
\ No newline at end of file