diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-07-03 23:44:48 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-07-03 23:44:48 +0200 |
| commit | 49ad0d2d495a9f817ad2820f8e616f3a6564b480 (patch) | |
| tree | 93d6744a952dd4dabba7ef9cfe7f8c3421d2f76a /sql/updates/characters | |
| parent | 306022054bec6010a63e80407c8d2f8d672b935b (diff) | |
Core/Quests: Reset seasonal quests based on saved completion time and intended holiday start time
Diffstat (limited to 'sql/updates/characters')
| -rw-r--r-- | sql/updates/characters/master/2022_07_03_00_characters.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2022_07_03_00_characters.sql b/sql/updates/characters/master/2022_07_03_00_characters.sql new file mode 100644 index 00000000000..11ed0f7e42c --- /dev/null +++ b/sql/updates/characters/master/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; |