DB/Seasonal:

* Added missing seasonal quest in game_event_seasonal_questrelation table
* Remove all event = 0 in character_queststatus_seasonal table

2 files changed, 80 insertions, 0 deletions

diff --git a/sql/updates/characters/2014_04_30_00_character_queststatus_seasonal.sql b/sql/updates/characters/2014_04_30_00_character_queststatus_seasonal.sql
new file mode 100644
index 00000000000..0c063b29df0
--- /dev/null
+++ b/sql/updates/characters/2014_04_30_00_character_queststatus_seasonal.sql
@@ -0,0 +1 @@
+DELETE FROM `character_queststatus_seasonal` WHERE `event` = 0;
diff --git a/sql/updates/world/2014_04_30_00_world_game_event_seasonal_questrelation.sql b/sql/updates/world/2014_04_30_00_world_game_event_seasonal_questrelation.sql
new file mode 100644
index 00000000000..15e830d924b
--- /dev/null
+++ b/sql/updates/world/2014_04_30_00_world_game_event_seasonal_questrelation.sql
@@ -0,0 +1,79 @@
+DELETE FROM `game_event_seasonal_questrelation` WHERE `questId` IN (
+171, 172, 558, 910, 911, 915, 925, 1468, 1479, 1558, 1687, 1800, 4822, 5502, 10942, 10943, 10945, 10950, 10951, 10952, 10953, 10954, 10956, 10960, 10962, 10963, 10966, 10967, 10968, 11974, 11975, 13926, 13927, 13929, 13930, 13933, 13934, 13937, 13938, 13950, 13951, 13952, 13954, 13955, 13956, 13957, 13959, 13960, 14022, 14023, 14024, 14028, 14030, 14033, 14035, 14036, 14037, 14040, 14041, 14043, 14044, 14047, 14064, 14065, 14166, 14167, 14168, 14169, 14170, 14171, 14172, 14173, 14174, 14175, 14176, 14177);
+INSERT INTO `game_event_seasonal_questrelation` (`questId`, `eventEntry`) VALUES
+(171, 10),
+(172, 10),
+(558, 10),
+(910, 10),
+(911, 10),
+(915, 10),
+(925, 10),
+(1468, 10),
+(1479, 10),
+(1558, 10),
+(1687, 10),
+(1800, 10),
+(4822, 10),
+(5502, 10),
+(10942, 10),
+(10943, 10),
+(10945, 10),
+(10950, 10),
+(10951, 10),
+(10952, 10),
+(10953, 10),
+(10954, 10),
+(10956, 10),
+(10960, 10),
+(10962, 10),
+(10963, 10),
+(10966, 10),
+(10967, 10),
+(10968, 10),
+(11974, 10),
+(11975, 10),
+(13926, 10),
+(13927, 10),
+(13929, 10),
+(13930, 10),
+(13933, 10),
+(13934, 10),
+(13937, 10),
+(13938, 10),
+(13950, 10),
+(13951, 10),
+(13952, 10),
+(13954, 10),
+(13955, 10),
+(13956, 10),
+(13957, 10),
+(13959, 10),
+(13960, 10),
+(14022, 26),
+(14023, 26),
+(14024, 26),
+(14028, 26),
+(14030, 26),
+(14033, 26),
+(14035, 26),
+(14036, 26),
+(14037, 26),
+(14040, 26),
+(14041, 26),
+(14043, 26),
+(14044, 26),
+(14047, 26),
+(14064, 26),
+(14065, 26),
+(14166, 51),
+(14167, 51),
+(14168, 51),
+(14169, 51),
+(14170, 51),
+(14171, 51),
+(14172, 51),
+(14173, 51),
+(14174, 51),
+(14175, 51),
+(14176, 51),
+(14177, 51);