Решено Ярмарка новолуния

[wankuk]

Будет ли на сервере ярмарка новолуния ?

 

[Божество]

уже проходит

 

[wankuk]

а где ?

 

[wankuk]

в златоземье ничего нет

 

[Термоштепсель]

подправил отображение некоторых игровых ивентов, включая ярмарку новолуния, в календаре на 2026 год

Спойлер: Код для разработчика

-- db hotfix
SET @HOTFIX_ID     := 558000;
SET @HOLIDAYS_HASH := 1972272076; -- Holidays.db2 0x758E7BCC


DELETE FROM `hotfix_data` WHERE `TableHash`=@HOLIDAYS_HASH AND `RecordID` IN (479, 423, 327, 201, 181);
INSERT INTO `hotfix_data` (`Id`, `TableHash`, `RecordID`, `Timestamp`, `Deleted`) VALUES
(@HOTFIX_ID+0, @HOLIDAYS_HASH, 479, 0, 0), -- Darkmoon Faire
(@HOTFIX_ID+1, @HOLIDAYS_HASH, 423, 0, 0), -- Love is in the Air
(@HOTFIX_ID+2, @HOLIDAYS_HASH, 327, 0, 0), -- Lunar Festival
(@HOTFIX_ID+3, @HOLIDAYS_HASH, 201, 0, 0), -- Children's Week
(@HOTFIX_ID+4, @HOLIDAYS_HASH, 181, 0, 0); -- Noblegarden


DELETE FROM `holidays` WHERE `ID` IN (479, 423, 327, 201, 181);
INSERT INTO `holidays` (`ID`, `Date1`, `Date2`, `Date3`, `Date4`, `Date5`, `Date6`, `Date7`, `Date8`, `Date9`, `Date10`, `Date11`, `Date12`, `Date13`, `Date14`, `Date15`, `Date16`, `Duration1`, `Duration2`, `Duration3`, `Duration4`, `Duration5`, `Duration6`, `Duration7`, `Duration8`, `Duration9`, `Duration10`, `Region`, `Looping`, `CalendarFlags1`, `CalendarFlags2`, `CalendarFlags3`, `CalendarFlags4`, `CalendarFlags5`, `CalendarFlags6`, `CalendarFlags7`, `CalendarFlags8`, `CalendarFlags9`, `CalendarFlags10`, `Priority`, `CalendarFilterType`, `Flags`, `HolidayNameID`, `HolidayDescriptionID`, `TextureFileDataID1`, `TextureFileDataID2`, `TextureFileDataID3`, `VerifiedBuild`) VALUES
(479, 431044608, 436238336, 436697088, 437696512, 439400448, 440416256, 441530368, 442546176, 443004928, 444659712, 445675520, 446134272, 447805440, 0, 0, 0, 48, 168, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 201, 235448, 235447, 235446, -1), -- Darkmoon Faire: Fri, 05 Dec 2025 - Fri, 04 Dec 2026
(423, 420526720, 437402240, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 336, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, -1, 1, 9, 9, 235468, 235467, 235466, -1), -- Love is in the Air: Mon, 03 Feb 2025 - Mon, 09 Feb 2026
(327, 419887744, 437516928, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 336, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, -1, 1, 18, 17, 235471, 235470, 235469, -1), -- Lunar Festival: Tue, 28 Jan 2025 - Mon, 16 Feb 2026
(201, 423033472, 439794304, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, -1, 1, 13, 12, 235445, 235444, 235443, -1), -- Children's Week: Mon, 28 Apr 2025 - Mon, 27 Apr 2026
(181, 422918784, 439450240, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, -1, 1, 15, 14, 235477, 235476, 235475, -1); -- Noblegarden: Mon, 21 Apr 2025 - Mon, 06 Apr 2026

и скорректировал дату старта этих событий

Спойлер: Код для разработчика

-- db world
UPDATE `game_event` SET `start_time`='2025-01-05 00:01:00', `end_time`='2035-07-05 15:30:00', `occurence`=40320 WHERE `eventEntry`=75 AND `holiday`=479; -- Darkmoon Faire
UPDATE `game_event` SET `start_time`='2025-02-09 07:31:00', `end_time`='2035-07-05 15:30:00' WHERE `eventEntry`=8 AND `holiday`=423; -- Love is in the Air
UPDATE `game_event` SET `start_time`='2025-02-16 07:31:00', `end_time`='2035-07-05 15:30:00' WHERE `eventEntry`=7 AND `holiday`=327; -- Lunar Festival
UPDATE `game_event` SET `start_time`='2025-04-27 07:31:00', `end_time`='2035-07-05 15:30:00' WHERE `eventEntry`=10 AND `holiday`=201; -- Children's Week
UPDATE `game_event` SET `start_time`='2025-04-06 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=525600 WHERE `eventEntry`=9 AND `holiday`=181; -- Noblegarden

 

[wankuk]

спасибо