diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-07-03 23:44:48 +0200 |
|---|---|---|
| committer | Ergar <ergar@gmx.net> | 2025-07-20 17:59:45 +0200 |
| commit | cbabaa0f3a605ed8ca0742c1b4a2eb4f741a01a9 (patch) | |
| tree | 7de24d88cea3fab709f011c654d17fe97729f3d4 /sql/updates | |
| parent | 97b16e2eb8c7d28bd954560cede812234932a457 (diff) | |
Core/Quests: Reset seasonal quests based on saved completion time and intended holiday start time
(cherry picked from commit 49ad0d2d495a9f817ad2820f8e616f3a6564b480)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/3.3.5/2025_07_20_00_characters_2022_07_03_00_characters.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/characters/3.3.5/2025_07_20_00_characters_2022_07_03_00_characters.sql b/sql/updates/characters/3.3.5/2025_07_20_00_characters_2022_07_03_00_characters.sql new file mode 100644 index 00000000000..11ed0f7e42c --- /dev/null +++ b/sql/updates/characters/3.3.5/2025_07_20_00_characters_2022_07_03_00_characters.sql @@ -0,0 +1,5 @@ +ALTER TABLE `character_queststatus_seasonal` ADD `completedTime` bigint NOT NULL DEFAULT '0' AFTER `event`; + +UPDATE `character_queststatus_seasonal` SET `completedTime` = UNIX_TIMESTAMP(); + +DELETE FROM `worldstates` WHERE `entry` BETWEEN 1 AND 85; |