DB: Update new holiday dates for Darkmoon Faire

closes #29040 by CraftedRO

1 files changed, 83 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2023_06_11_00_world.sql b/sql/updates/world/3.3.5/2023_06_11_00_world.sql
new file mode 100644
index 00000000000..58b5b980d22
--- /dev/null
+++ b/sql/updates/world/3.3.5/2023_06_11_00_world.sql
@@ -0,0 +1,83 @@
+-- Darkmoon Faire (Elwyn Forest)
+UPDATE `holiday_dates` SET `date_value`=391135232 WHERE `id`=374 AND `date_id`=0; -- 2023-06-02
+UPDATE `holiday_dates` SET `date_value`=394264576 WHERE `id`=374 AND `date_id`=1; -- 2023-09-01
+UPDATE `holiday_dates` SET `date_value`=397410304 WHERE `id`=374 AND `date_id`=2; -- 2023-12-01
+UPDATE `holiday_dates` SET `date_value`=404750336 WHERE `id`=374 AND `date_id`=3; -- 2024-03-01
+UPDATE `holiday_dates` SET `date_value`=407339008 WHERE `id`=374 AND `date_id`=4; -- 2024-05-31
+UPDATE `holiday_dates` SET `date_value`=410468352 WHERE `id`=374 AND `date_id`=5; -- 2024-08-30
+UPDATE `holiday_dates` SET `date_value`=413597696 WHERE `id`=374 AND `date_id`=6; -- 2024-11-29
+UPDATE `holiday_dates` SET `date_value`=420921344 WHERE `id`=374 AND `date_id`=7; -- 2025-02-28
+UPDATE `holiday_dates` SET `date_value`=424099840 WHERE `id`=374 AND `date_id`=8; -- 2025-05-30
+UPDATE `holiday_dates` SET `date_value`=427229184 WHERE `id`=374 AND `date_id`=9; -- 2025-08-29
+UPDATE `holiday_dates` SET `date_value`=430358528 WHERE `id`=374 AND `date_id`=10; -- 2025-11-28
+UPDATE `holiday_dates` SET `date_value`=437682176 WHERE `id`=374 AND `date_id`=11; -- 2026-02-27
+UPDATE `holiday_dates` SET `date_value`=440860672 WHERE `id`=374 AND `date_id`=12; -- 2026-05-29
+UPDATE `holiday_dates` SET `date_value`=443990016 WHERE `id`=374 AND `date_id`=13; -- 2026-08-28
+UPDATE `holiday_dates` SET `date_value`=447119360 WHERE `id`=374 AND `date_id`=14; -- 2026-11-27
+UPDATE `holiday_dates` SET `date_value`=454443008 WHERE `id`=374 AND `date_id`=15; -- 2027-02-26
+UPDATE `holiday_dates` SET `date_value`=457621504 WHERE `id`=374 AND `date_id`=16; -- 2027-05-28
+UPDATE `holiday_dates` SET `date_value`=460750848 WHERE `id`=374 AND `date_id`=17; -- 2027-08-27
+UPDATE `holiday_dates` SET `date_value`=463880192 WHERE `id`=374 AND `date_id`=18; -- 2027-11-26
+UPDATE `holiday_dates` SET `date_value`=471203840 WHERE `id`=374 AND `date_id`=19; -- 2028-02-25
+UPDATE `holiday_dates` SET `date_value`=474365952 WHERE `id`=374 AND `date_id`=20; -- 2028-05-26
+UPDATE `holiday_dates` SET `date_value`=477495296 WHERE `id`=374 AND `date_id`=21; -- 2028-08-25
+UPDATE `holiday_dates` SET `date_value`=480624640 WHERE `id`=374 AND `date_id`=22; -- 2028-11-24
+UPDATE `holiday_dates` SET `date_value`=487948288 WHERE `id`=374 AND `date_id`=23; -- 2029-02-23
+UPDATE `holiday_dates` SET `date_value`=491126784 WHERE `id`=374 AND `date_id`=24; -- 2029-05-25
+UPDATE `holiday_dates` SET `date_value`=494256128 WHERE `id`=374 AND `date_id`=25; -- 2029-08-24
+
+-- Darkmoon Faire (Mulgore)
+UPDATE `holiday_dates` SET `date_value`=391593984 WHERE `id`=375 AND `date_id`=0; -- 2023-06-30
+UPDATE `holiday_dates` SET `date_value`=394723328 WHERE `id`=375 AND `date_id`=1; -- 2023-09-29
+UPDATE `holiday_dates` SET `date_value`=397869056 WHERE `id`=375 AND `date_id`=2; -- 2023-12-29
+UPDATE `holiday_dates` SET `date_value`=405209088 WHERE `id`=375 AND `date_id`=3; -- 2024-03-29
+UPDATE `holiday_dates` SET `date_value`=408338432 WHERE `id`=375 AND `date_id`=4; -- 2024-06-28
+UPDATE `holiday_dates` SET `date_value`=411467776 WHERE `id`=375 AND `date_id`=5; -- 2024-09-27
+UPDATE `holiday_dates` SET `date_value`=414613504 WHERE `id`=375 AND `date_id`=6; -- 2024-12-27
+UPDATE `holiday_dates` SET `date_value`=421969920 WHERE `id`=375 AND `date_id`=7; -- 2025-03-28
+UPDATE `holiday_dates` SET `date_value`=425099264 WHERE `id`=375 AND `date_id`=8; -- 2025-06-27
+UPDATE `holiday_dates` SET `date_value`=428228608 WHERE `id`=375 AND `date_id`=9; -- 2025-09-26
+UPDATE `holiday_dates` SET `date_value`=431374336 WHERE `id`=375 AND `date_id`=10; -- 2025-12-26
+UPDATE `holiday_dates` SET `date_value`=438730752 WHERE `id`=375 AND `date_id`=11; -- 2026-03-27
+UPDATE `holiday_dates` SET `date_value`=441860096 WHERE `id`=375 AND `date_id`=12; -- 2026-06-26
+UPDATE `holiday_dates` SET `date_value`=444989440 WHERE `id`=375 AND `date_id`=13; -- 2026-09-25
+UPDATE `holiday_dates` SET `date_value`=448135168 WHERE `id`=375 AND `date_id`=14; -- 2026-12-25
+UPDATE `holiday_dates` SET `date_value`=455491584 WHERE `id`=375 AND `date_id`=15; -- 2027-03-26
+UPDATE `holiday_dates` SET `date_value`=458620928 WHERE `id`=375 AND `date_id`=16; -- 2027-06-25
+UPDATE `holiday_dates` SET `date_value`=461750272 WHERE `id`=375 AND `date_id`=17; -- 2027-09-24
+UPDATE `holiday_dates` SET `date_value`=464896000 WHERE `id`=375 AND `date_id`=18; -- 2027-12-24
+UPDATE `holiday_dates` SET `date_value`=472236032 WHERE `id`=375 AND `date_id`=19; -- 2028-03-24
+UPDATE `holiday_dates` SET `date_value`=475365376 WHERE `id`=375 AND `date_id`=20; -- 2028-06-23
+UPDATE `holiday_dates` SET `date_value`=478494720 WHERE `id`=375 AND `date_id`=21; -- 2028-09-22
+UPDATE `holiday_dates` SET `date_value`=481640448 WHERE `id`=375 AND `date_id`=22; -- 2028-12-22
+UPDATE `holiday_dates` SET `date_value`=488996864 WHERE `id`=375 AND `date_id`=23; -- 2029-03-23
+UPDATE `holiday_dates` SET `date_value`=492126208 WHERE `id`=375 AND `date_id`=24; -- 2029-06-22
+UPDATE `holiday_dates` SET `date_value`=495255552 WHERE `id`=375 AND `date_id`=25; -- 2029-09-21
+
+-- Darkmoon Faire (Terokkar Forest)
+UPDATE `holiday_dates` SET `date_value`=393265152 WHERE `id`=376 AND `date_id`=0; -- 2023-08-04
+UPDATE `holiday_dates` SET `date_value`=396394496 WHERE `id`=376 AND `date_id`=1; -- 2023-11-03
+UPDATE `holiday_dates` SET `date_value`=403718144 WHERE `id`=376 AND `date_id`=2; -- 2024-02-02
+UPDATE `holiday_dates` SET `date_value`=406880256 WHERE `id`=376 AND `date_id`=3; -- 2024-05-03
+UPDATE `holiday_dates` SET `date_value`=410009600 WHERE `id`=376 AND `date_id`=4; -- 2024-08-02
+UPDATE `holiday_dates` SET `date_value`=413138944 WHERE `id`=376 AND `date_id`=5; -- 2024-11-01
+UPDATE `holiday_dates` SET `date_value`=419921920 WHERE `id`=376 AND `date_id`=6; -- 2025-01-31
+UPDATE `holiday_dates` SET `date_value`=423641088 WHERE `id`=376 AND `date_id`=7; -- 2025-05-02
+UPDATE `holiday_dates` SET `date_value`=426770432 WHERE `id`=376 AND `date_id`=8; -- 2025-08-01
+UPDATE `holiday_dates` SET `date_value`=429359104 WHERE `id`=376 AND `date_id`=9; -- 2025-10-31
+UPDATE `holiday_dates` SET `date_value`=436682752 WHERE `id`=376 AND `date_id`=10; -- 2026-01-30
+UPDATE `holiday_dates` SET `date_value`=440401920 WHERE `id`=376 AND `date_id`=11; -- 2026-05-01
+UPDATE `holiday_dates` SET `date_value`=442990592 WHERE `id`=376 AND `date_id`=12; -- 2026-07-31
+UPDATE `holiday_dates` SET `date_value`=446119936 WHERE `id`=376 AND `date_id`=13; -- 2026-10-30
+UPDATE `holiday_dates` SET `date_value`=453443584 WHERE `id`=376 AND `date_id`=14; -- 2027-01-29
+UPDATE `holiday_dates` SET `date_value`=456605696 WHERE `id`=376 AND `date_id`=15; -- 2027-04-30
+UPDATE `holiday_dates` SET `date_value`=459751424 WHERE `id`=376 AND `date_id`=16; -- 2027-07-30
+UPDATE `holiday_dates` SET `date_value`=462880768 WHERE `id`=376 AND `date_id`=17; -- 2027-10-29
+UPDATE `holiday_dates` SET `date_value`=470204416 WHERE `id`=376 AND `date_id`=18; -- 2028-01-28
+UPDATE `holiday_dates` SET `date_value`=473350144 WHERE `id`=376 AND `date_id`=19; -- 2028-04-28
+UPDATE `holiday_dates` SET `date_value`=476495872 WHERE `id`=376 AND `date_id`=20; -- 2028-07-28
+UPDATE `holiday_dates` SET `date_value`=479625216 WHERE `id`=376 AND `date_id`=21; -- 2028-10-27
+UPDATE `holiday_dates` SET `date_value`=486948864 WHERE `id`=376 AND `date_id`=22; -- 2029-01-26
+UPDATE `holiday_dates` SET `date_value`=490110976 WHERE `id`=376 AND `date_id`=23; -- 2029-04-27
+UPDATE `holiday_dates` SET `date_value`=493256704 WHERE `id`=376 AND `date_id`=24; -- 2029-07-27
+UPDATE `holiday_dates` SET `date_value`=496386048 WHERE `id`=376 AND `date_id`=25; -- 2029-10-26