Лучший рыболов Азерота

Probelych® · Декабрь 14, 2025

Не стартует https://www.wowhead.com/ru/quest=44765 которая начинается в воскресенье в 14:00 по серверному времени
поэтому не возможно выполнить ачивку https://www.wowhead.com/ru/achievement=306

Термоштепсель · Декабрь 14, 2025

дополнение к https://forum.skyblood.ru/threads/Ярмарка-новолуния.4146/#post-6169

- в календарь залетало еще некоторое количество событий которые не отображались до этого, а также поправлены даты их проведения
- теперь в календаре событие "Рыбомания Тернистой долины" будет отображаться иконкой и скорректирована дата старта события

- структура sqlчика совместима с https://github.com/Fragrus/LegionCore-7.3.5

SQL:

-- 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, 321, 404, 590, 559, 562, 587, 591, 643, 561, 563, 565, 592, 301);
INSERT INTO `hotfix_data` (`Id`, `TableHash`, `RecordID`, `Timestamp`, `Deleted`) VALUES 
(@HOTFIX_ID+0, @HOLIDAYS_HASH, 479, 0, 0), -- Darkmoon Faire  Event
(@HOTFIX_ID+1, @HOLIDAYS_HASH, 423, 0, 0), -- Love is in the Air Event
(@HOTFIX_ID+2, @HOLIDAYS_HASH, 327, 0, 0), -- Lunar Festival Event
(@HOTFIX_ID+3, @HOLIDAYS_HASH, 201, 0, 0), -- Children's Week Event
(@HOTFIX_ID+4, @HOLIDAYS_HASH, 181, 0, 0), -- Noblegarden Event
(@HOTFIX_ID+5, @HOLIDAYS_HASH, 321, 0, 0), -- Harvest Festival Event
(@HOTFIX_ID+6, @HOLIDAYS_HASH, 404, 0, 0), -- Pilgrim's Bounty Event
(@HOTFIX_ID+7, @HOLIDAYS_HASH, 590, 0, 0), -- WoW's Anniversary
(@HOTFIX_ID+8, @HOLIDAYS_HASH, 559, 0, 0), -- Outland Timewalking Dungeon Event
(@HOTFIX_ID+9, @HOLIDAYS_HASH, 562, 0, 0), -- Northrend Timewalking Dungeon Event
(@HOTFIX_ID+10, @HOLIDAYS_HASH, 587, 0, 0), -- Cataclysm Timewalking Dungeon Event
(@HOTFIX_ID+11, @HOLIDAYS_HASH, 591, 0, 0), -- Legion Dungeon Event
(@HOTFIX_ID+12, @HOLIDAYS_HASH, 643, 0, 0), -- Mists of Pandaria Timewalking Dungeon Event
(@HOTFIX_ID+13, @HOLIDAYS_HASH, 561, 0, 0), -- Arena Skirmish Bonus Event
(@HOTFIX_ID+14, @HOLIDAYS_HASH, 563, 0, 0), -- Battleground Bonus Event
(@HOTFIX_ID+15, @HOLIDAYS_HASH, 565, 0, 0), -- Pet Battle Bonus Event
(@HOTFIX_ID+16, @HOLIDAYS_HASH, 592, 0, 0), -- World Quest Bonus Event

(@HOTFIX_ID+17, @HOLIDAYS_HASH, 301, 0, 0); -- Stranglethorn Fishing Extravaganza Event

-- добавляем актуальные события у которых закончились сроки годности в календаре и обновляем им даты проведения
-- добавляем "Рыбомании Тернистой долины"(301) иконку в календаре

DELETE FROM `holidays` WHERE `ID` IN 
(479, 423, 327, 201, 181, 321, 404, 590, 559, 562, 587, 591, 643, 561, 563, 565, 592, 301);
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, 290486272, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 48, 168, 456, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 1, 1, 201, 235448, 235447, 235446, -1), -- Darkmoon Faire Event, "Fri, 02 Jun 2017 00:00:00 GMT" + 2 Days, 4 Weeks Cooldown
(423, 521288320, 0, 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 Event, 1 Year Cooldown
(327, 521403008, 0, 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 Event, 1 Year Cooldown
(201, 523680384, 0, 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 Event, 1 Year Cooldown
(181, 523336320, 0, 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 Event, 1 Year Cooldown
(321, 528824960, 0, 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, 17, 16, 235465, 235464, 235463, -1), -- Harvest Festival Event, 1 Year Cooldown
(404, 530938496, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 167, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, -1, 1, 101, 101, 235465, 235464, 235463, -1), -- Pilgrim's Bounty Event, 1 Year Cooldown
(590, 430176896, 447052416, 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, 0, -1, 1, 242, 188, 1084434, 1084433, 1084432, -1), -- WoW's Anniversary
(559, 296030656, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 2856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 239, 222, 1129674, 1129673, 1129672, -1), -- Outland Timewalking Dungeon Event, "Tue, 21 Nov 2017 07:00:00 GMT", 18 Weeks Cooldown
(562, 292557312, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 2856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 237, 220, 1129686, 1129685, 1129684, -1), -- Northrend Timewalking Dungeon Event, "Tue, 01 Aug 2017 08:00:00 GMT", 18 Weeks Cooldown
(587, 293016064, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 2856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 239, 224, 1304688, 1304687, 1304686, -1), -- Cataclysm Timewalking Dungeon Event, "Tue, 29 Aug 2017 08:00:00 GMT", 18 Weeks Cooldown
(591, 292786688, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 2856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 243, 225, 1467047, 1467046, 1467045, -1), -- Legion Dungeon Event, "Tue, 15 Aug 2017 08:00:00 GMT", 18 Weeks Cooldown
(643, 295801280, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 2856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 239, 237, 1530590, 1530589, 1530588, -1), -- Mists of Pandaria Timewalking Dungeon Event, "Tue, 07 Nov 2017 07:00:00 GMT", 18 Weeks Cooldown
(561, 295031296, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 2856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 238, 221, 1129680, 1129679, 1129678, -1), -- Arena Skirmish Bonus Event, "Tue, 24 Oct 2017 08:00:00 GMT", 18 Weeks Cooldown
(563, 294015488, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 2856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 236, 236, 1129671, 1129670, 1129669, -1), -- Battleground Bonus Event, "Tue, 26 Sep 2017 08:00:00 GMT", 18 Weeks Cooldown
(565, 294801920, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 2856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 234, 217, 1129677, 1129676, 1129675, -1), -- Pet Battle Bonus Event, "Tue, 10 Oct 2017 08:00:00 GMT", 18 Weeks Cooldown
(592, 293786112, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 168, 2856, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 1, 244, 226, 1467050, 1467049, 1467048, -1), -- World Quest Bonus Event, "Tue, 12 Sep 2017 08:00:00 GMT", 18 Weeks Cooldown

(301, 536855424, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 6, 4, 235458, 0, 0, -1); -- Stranglethorn Fishing Extravaganza Event, 1 Week Cooldown

SQL:

-- db world

SET @EVENT_ID := 250; -- +8

-- обновляем имеющиеся в базе даты проведения у добавленных событий для синхронизации с календарем
-- исправляем айди события у "Бонус за битвы питомцев"(565) на верный
-- корректируем дату старта события "Рыбомании Тернистой долины"(301)

UPDATE `game_event` SET `start_time`='2017-06-03 00:01:00', `end_time`='2035-07-05 15:30:00', `occurence`=40320 WHERE `eventEntry`=3 AND `holiday`=0; -- Darkmoon Faire (Building)
UPDATE `game_event` SET `start_time`='2017-06-04 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', `occurence`=525600 WHERE `eventEntry`=8 AND `holiday`=423; -- Love is in the Air Event
UPDATE `game_event` SET `start_time`='2025-02-16 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=525600 WHERE `eventEntry`=7 AND `holiday`=327; -- Lunar Festival Event
UPDATE `game_event` SET `start_time`='2025-04-27 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=525600 WHERE `eventEntry`=10 AND `holiday`=201; -- Children's Week Event
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 Event
UPDATE `game_event` SET `start_time`='2025-09-21 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=525600 WHERE `eventEntry`=11 AND `holiday`=321; -- Harvest Festival Event
UPDATE `game_event` SET `start_time`='2025-11-22 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=525600 WHERE `eventEntry`=26 AND `holiday`=404; -- Pilgrim's Bounty Event
UPDATE `game_event` SET `start_time`='2017-11-21 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=181440 WHERE `eventEntry`=96 AND `holiday`=559; -- Outland Timewalking Dungeon Event
UPDATE `game_event` SET `start_time`='2017-08-01 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=181440 WHERE `eventEntry`=90 AND `holiday`=562; -- Northrend Timewalking Dungeon Event
UPDATE `game_event` SET `start_time`='2017-08-29 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=181440 WHERE `eventEntry`=94 AND `holiday`=587; -- Cataclysm Timewalking Dungeon Event
UPDATE `game_event` SET `start_time`='2017-08-15 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=181440 WHERE `eventEntry`=97 AND `holiday`=591; -- Legion Dungeon Event
UPDATE `game_event` SET `start_time`='2017-11-07 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=181440 WHERE `eventEntry`=98 AND `holiday`=643; -- Mists of Pandaria Timewalking Dungeon Event
UPDATE `game_event` SET `start_time`='2017-10-24 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=181440 WHERE `eventEntry`=95 AND `holiday`=561; -- Arena Skirmish Bonus Event
UPDATE `game_event` SET `start_time`='2017-09-26 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=181440 WHERE `eventEntry`=92 AND `holiday`=563; -- Battleground Bonus Event
UPDATE `game_event` SET `holiday`=565 WHERE `eventEntry`=93 AND `holiday`=564;
UPDATE `game_event` SET `start_time`='2017-10-10 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=181440 WHERE `eventEntry`=93 AND `holiday`=565; -- Pet Battle Bonus Event
UPDATE `game_event` SET `start_time`='2017-09-12 07:31:00', `end_time`='2035-07-05 15:30:00', `occurence`=181440 WHERE `eventEntry`=91 AND `holiday`=592; -- World Quest Bonus Event

UPDATE `game_event` SET `start_time`='2025-01-05 00:01:00', `end_time`='2035-07-05 15:30:00' WHERE `eventEntry`=14 AND `holiday`=0; -- Stranglethorn Fishing Extravaganza Announce
UPDATE `game_event` SET `start_time`='2025-01-05 14:01:00', `end_time`='2035-07-05 15:30:00' WHERE `eventEntry`=15 AND `holiday`=301; -- Stranglethorn Fishing Extravaganza Fishing Pools
UPDATE `game_event` SET `start_time`='2025-01-05 13:01:00', `end_time`='2035-07-05 15:30:00' WHERE `eventEntry`=62 AND `holiday`=0; -- Stranglethorn Fishing Extravaganza Turn-ins

-- добавляем недостающие

DELETE FROM `game_event` WHERE `eventEntry` IN 
(@EVENT_ID+0, @EVENT_ID+1, @EVENT_ID+2, @EVENT_ID+3, @EVENT_ID+4, @EVENT_ID+5, @EVENT_ID+6, @EVENT_ID+7, @EVENT_ID+8) AND `holiday` IN 
(666, 663, 664, 703, 665, 662, 667, 668, 702);
INSERT INTO `game_event` (`eventEntry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `description`, `world_event`) VALUES 
(@EVENT_ID+0, '2017-07-25 07:31:00', '2035-07-05 15:30:00', 181440, 10080, 666, 'PvP Brawl: Arathi Blizzard', 0),
(@EVENT_ID+1, '2017-08-08 07:31:00', '2035-07-05 15:30:00', 181440, 10080, 663, 'PvP Brawl: Gravity Lapse', 0),
(@EVENT_ID+2, '2017-08-22 07:31:00', '2035-07-05 15:30:00', 181440, 10080, 664, 'PvP Brawl: Warsong Scramble', 0),
(@EVENT_ID+3, '2017-09-05 07:31:00', '2035-07-05 15:30:00', 181440, 10080, 703, 'PvP Brawl: Shado-Pan Showdown', 0),
(@EVENT_ID+4, '2017-09-19 07:31:00', '2035-07-05 15:30:00', 181440, 10080, 665, 'PvP Brawl: Deepwind Dunk', 0),
(@EVENT_ID+5, '2017-10-03 07:31:00', '2035-07-05 15:30:00', 181440, 10080, 662, 'PvP Brawl: Southshore vs. Tarren Mill', 0),
(@EVENT_ID+6, '2017-10-17 07:31:00', '2035-07-05 15:30:00', 181440, 10080, 667, 'PvP Brawl: Packed House', 0),
(@EVENT_ID+7, '2017-10-31 07:31:00', '2035-07-05 15:30:00', 181440, 10080, 668, 'PvP Brawl: Temple of Hotmogu', 0),
(@EVENT_ID+8, '2017-11-14 07:31:00', '2035-07-05 15:30:00', 181440, 10080, 702, 'PvP Brawl: Deep Six', 0);

Лучший рыболов Азерота

Probelych®

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