aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/2011_02_04_0_game_event.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/2011_02_04_0_game_event.sql b/sql/updates/world/2011_02_04_0_game_event.sql
new file mode 100644
index 00000000000..1e84cce9883
--- /dev/null
+++ b/sql/updates/world/2011_02_04_0_game_event.sql
@@ -0,0 +1,15 @@
+-- Update start date of game event for 2011
+-- Based on retail IG calendar
+UPDATE `game_event` SET `start_time` = '2011-06-21 00:01:00' WHERE `entry`=1; -- Midsummer Fire Festival
+UPDATE `game_event` SET `start_time` = '2011-12-15 06:00:00' WHERE `entry`=2; -- Winter Veil
+UPDATE `game_event` SET `start_time` = '2011-02-06 00:01:00' WHERE `entry`=3; -- Darkmoon Faire - Terrokkar Forest
+UPDATE `game_event` SET `start_time` = '2011-03-06 00:01:00' WHERE `entry`=4; -- Darkmoon Faire - Elwynn Forest
+UPDATE `game_event` SET `start_time` = '2011-01-02 00:01:00' WHERE `entry`=5; -- Darkmoon Faire - Mulgore
+UPDATE `game_event` SET `start_time` = '2011-01-23 00:01:00' WHERE `entry`=7; -- Lunar Festival
+UPDATE `game_event` SET `start_time` = '2011-02-06 00:01:00' WHERE `entry`=8; -- Love is in the Air
+UPDATE `game_event` SET `start_time` = '2011-04-24 00:01:00' WHERE `entry`=9; -- Noblegarden
+UPDATE `game_event` SET `start_time` = '2011-05-01 00:01:00' WHERE `entry`=10; -- Childrens Week
+UPDATE `game_event` SET `start_time` = '2011-09-06 00:01:00' WHERE `entry`=11; -- Harvest Festival
+UPDATE `game_event` SET `start_time` = '2011-10-18 01:00:00' WHERE `entry`=12; -- Hallow's End
+UPDATE `game_event` SET `start_time` = '2011-03-03 00:01:00' WHERE `entry`=23; -- Darkmoon Faire Building - Elwynn Forest
+UPDATE `game_event` SET `start_time` = '2011-09-19 00:01:00' WHERE `entry`=52; -- Pirates Day