diff options
| author | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-04-26 04:46:54 +0200 |
|---|---|---|
| committer | Vincent-Michael <Vincent_Michael@gmx.de> | 2014-04-26 04:46:54 +0200 |
| commit | ab85c1546fcf0d931873090ea570299303545299 (patch) | |
| tree | 2352bf8ce572b93655c7321c05b81c4cd0cdef61 /sql | |
| parent | 0242f04f1c1425f25f28c5168935ce2d22a4c0d2 (diff) | |
Core/Achievements: Fixed WoW''s 4th-8th Anniversary
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_04_26_01_world_game_event.sql | 21 |
1 files changed, 16 insertions, 5 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 index 949c9717326..7155b2b1719 100644 --- a/sql/updates/world/2014_04_26_01_world_game_event.sql +++ b/sql/updates/world/2014_04_26_01_world_game_event.sql @@ -1,6 +1,17 @@ -DELETE FROM `game_event` `eventEntry` IN (65,66,67,68); +DELETE FROM `game_event` WHERE `eventEntry` IN (65,66,67,68,69,70,71); 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); +(65, '2008-11-23 00:01:00', '2008-11-23 23:59:00', 525600, 1440, 0, 'WoW''s 4th Anniversary', 0, 2), +(66, '2009-11-22 00:01:00', '2009-12-06 23:59:00', 525600, 10080, 0, 'WoW''s 5th Anniversary', 0, 2), +(67, '2010-11-30 00:01:00', '2010-12-14 23:59:00', 525600, 10080, 0, 'WoW''s 6th Anniversary', 0, 2), +(68, '2011-11-20 00:01:00', '2010-12-03 23:59:00', 525600, 10080, 467, 'WoW''s 7th Anniversary', 0, 2), +(69, '2012-11-18 00:01:00', '2012-12-01 23:59:00', 525600, 10080, 484, 'WoW''s 8th Anniversary', 0, 2), +(70, '2013-11-18 00:01:00', '2013-12-01 23:59:00', 525600, 10080, 0/*509*/, 'WoW''s 9th Anniversary', 0, 2), +(71, '2014-11-17 00:01:00', '2014-12-01 23:59:00', 525600, 10080, 0/*514*/, 'WoW''s 10th Anniversary', 0, 2); + +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (9058, 12562,16082,17804,18500); +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(9058, 23, 65, 0, ''), -- WoW''s 4th Anniversary' +(12562, 23, 66, 0, ''), -- WoW''s 5th Anniversary +(16082, 23, 67, 0, ''), -- WoW''s 6th Anniversary +(17804, 16, 467, 0, ''), -- WoW''s 7th Anniversary +(18500, 16, 484, 0, ''); -- WoW''s 8th Anniversary |