[DB] Kalu'ak Fishing Derby

[manstfu]

Current Behaviour

Event Kalu'ak Fishing Derby has wrong starting time, it should start at 14:00pm server time based on in-game calendar, currently it starts at 20:00pm

azerothcore-wotlk/data/sql/updates/db_world/2024_01_23_00.sql

Lines 63 to 64 in 7afaaae

	UPDATE `game_event` SET `start_time` = '2014-03-22 19:00:00', `end_time` = '2030-12-31 12:00:00' WHERE `eventEntry` = 63;
	UPDATE `game_event` SET `start_time` = '2014-03-22 20:00:00', `end_time` = '2030-12-31 12:00:00' WHERE `eventEntry` = 64;

Expected Blizzlike Behaviour

Start based on in-game calendar time

• event 63 should start at 13:00pm
• event 64 should start at 14:00pm

Source

https://www.youtube.com/watch?v=ArVjLHbFuCo notice server time under radar

Steps to reproduce the problem

Wait till saturday 20:00pm server time

Extra Notes

Posible fix:

UPDATE `game_event` SET `start_time` = '2014-03-22 13:00:00' WHERE `eventEntry` = 63;
UPDATE `game_event` SET `start_time` = '2014-03-22 14:00:00' WHERE `eventEntry` = 64;

AC rev. hash/commit

rev. 9487b30

Operating system

Debian 12

Custom changes or Modules

No response