[3.3.5] DB/Event: Game event start dates

Description: Fix timer for Love in the air.

Current behaviour: In game.

Steps to reproduce the problem:

1.Wrong Timer for event.

Branch(es): 335

TC hash/commit:
TrinityCore rev. 1c86d28+ 2016-02-26 17:54:46 -0300 (master branch) (Unix, Release)
TDB version:
TDB 3.3.5 60
Operating system:
Linux & Windows

FIx is : Apply on table world db.

UPDATE `game_event` SET `start_time`= '2016-02-15 19:01:00' WHERE `eventEntry`= 8;

Your suggested fix could be valid (I don't know), just a few codestyle details in your query to be fixed:

UPDATE `game_event` SET `start_time`= '2013-02-15 19:01:00' WHERE `eventEntry`= 8;

• no need for LIMIT 1 because there is only 1 event row in that table where eventEntry= 8
• parentheses ( ) not needed at that end part, it is a format chosen by your editor app
• generally speaking, TC don't use single quotes '8' around numbers if they count as number values (date/time group obviously needs quoting because of spaces and punctuation)

Ho thanks man :)

[joschiwald]

we live in year 2016

Fix now :)

[Aokromes]

Since it already expired it's useless to push it with 2013 or 2016, and on 2017 very likely will use a different date.

Ref:
Year Love is in the Air dates
2007, 2008, 2009 February 11 - February 16
2010 February 07 - February 20
2011 February 06 - February 20
2012 February 05 - February 18
2013 February 11 - February 24
2014 February 10 - February 24
2015 February 02 - February 16

http://i.imgur.com/livHaps.jpg
http://i.imgur.com/gxbLVbl.jpg

Ok ho miss in calendar :( lol sorry

[Demonid]

Should we update all wotlk world events to these dates?

http://www.wowhead.com/events#holidays:0+2+1

[Aokromes]

IMHO, the priority must be ingame calendar, then wowhead.

event	retail	3.3.5a	tc
Noblegarden	2016/03/28 - 2016/04/04	2016/03/27 - 2016/04/02	2016/04/03 - 2016/04/10
Children's Week	2016/05/02 - 2016/05/09	no data ingame calendar	2016/04/27 - 2016/05/04
Midsummer	2016/06/21 - 2016/07/05	2016/06/21 - 2016/07/04	2016/06/20 - 2016/07/04
Fireworks	2016/07/04 - 2016/07/05	2016/07/04 - 2016/07/04	no data on tc
Harvest Festival	2016/09/09 - 2016/09/16	no data ingame calendar	2016/09/12 - 2016/09/19
Pirates' Day	2016/09/19 - 2016/09/20	2016/09/19 - 2016/09/19	2016/09/18 - 2016/09/19
Brewfest	2016/09/20 - 2016/10/06	2016/09/20 - 2016/10/05	2016/09/19 - 2016/10/04
Hallow's End	2016/10/18 - 2016/11/01	2016/10/18 - 2016/11/31	2016/09/19 - 2016/10/04
Day of Dead	2016/11/01 - 2016/11/03	2016/11/01 - 2016/11/02	2016/10/31 - 2016/11/02
Pilgrim's Bounty	2016/11/21 - 2016/11/28	no data ingame calendar	2016/11/23 - 2016/11/30
Winter Veil	2016/12/16 - 2017/01/02	2016/12/15 - 2017/01/02	2016/12/23 - 2016/12/31
Darkmoon Faire	2016/03/06 - 2016/03/13	no data ingame calendar	2016/02/28 - 2016/03/05
Love is in Air	2017/02/07 - 2017/02/21	no data ingame calendar	2016/02/28 - 2016/03/05

[Kittnz]

Love is in the air is not even in there @Aokromes

[Aokromes]

I don't have added it because no data on wowhead/ingame wow 6 calendar for 2017.

[Aokromes]

Updated by 396498b