aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorVincent-Michael <Vincent_Michael@gmx.de>2014-04-26 02:05:29 +0200
committerVincent-Michael <Vincent_Michael@gmx.de>2014-04-26 02:05:29 +0200
commit68b508df27d20faeecf77933008f250b32f22392 (patch)
tree1fb838cea3550de5294333089c787ab0e2d751f6 /sql
parent1390621f4da88d6749e42bea0a131fae74742fa4 (diff)
Core/GameEvent: Use game_event table for blizzard birthday
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_04_26_01_world_game_event.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2014_04_26_01_world_game_event.sql b/sql/updates/world/2014_04_26_01_world_game_event.sql
new file mode 100644
index 00000000000..949c9717326
--- /dev/null
+++ b/sql/updates/world/2014_04_26_01_world_game_event.sql
@@ -0,0 +1,6 @@
+DELETE FROM `game_event` `eventEntry` IN (65,66,67,68);
+INSERT INTO `game_event` (`eventEntry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `description`, `world_event`, `announce`) VALUES
+(65, '2011-11-20 00:01:00', '2011-12-03 23:59:00', 525600, 336, 467, 'WoW''s 7th Anniversary', 0, 2),
+(66, '2012-11-18 00:01:00', '2012-12-01 23:59:00', 525600, 336, 484, 'WoW''s 8th Anniversary', 0, 2),
+(67, '2013-11-18 00:01:00', '2013-12-01 23:59:00', 525600, 336, 0/*509*/, 'WoW''s 9th Anniversary', 0, 2),
+(68, '2014-11-17 00:01:00', '2014-12-01 23:59:00', 525600, 336, 0/*514*/, 'WoW''s 10th Anniversary', 0, 2);