Fishing: Nightfin/Sunscale event times are off

[ghost]

Information regarding availability of nightfin/sunscale can be found in a number of places, but one example is the top post at http://db.vanillagaming.org/?item=13759#wh-comments.

The expectation is for nightfin to be fishable at all times except 12pm-6pm, and sunscale to be available at all times except 12am-6am. This is confirmed by the start time of events 47 and 48 in the game_event database table.

I observed tonight successfully fishing nightfin just after 9pm server time, only to disappear and be replaced by sunscale at sometime no later than 10pm. Given that this roughly corresponds to around 12pm GMT+0, I suspect either:

• game event database entries are being read as though they are GMT+0 rather than the server timezone
• current_time is being initialised from a different time zone (either through configuration/code, or the server OS time itself is off)

[ghost]

Just noted a possible cause: that GameEventMgr::LoadFromDB() uses function UNIX_TIMESTAMP, which seems to return a UTC time. Thanks.