diff options
| author | Shauren <shauren.trinity@gmail.com> | 2025-06-22 21:56:58 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2025-06-22 21:56:58 +0200 |
| commit | e59059e1bd2f67691e2da0105771b0cb55b123a4 (patch) | |
| tree | 4f4864f8aae63eeafac29f440e0ce64a027c4108 /sql | |
| parent | 7ca6b226a7420ff38e3a4f17a3758393d68629e3 (diff) | |
Core/Players: PlayerChoice improvements
* Add missing choice properties to database (InfiniteRange, ShowChoicesAsList)
* Allow limiiting the number of responses sent at the same time
* Fixed duration sent in SMSG_DISPLAY_PLAYER_CHOICE
* Remove dynamically generated response identifiers from database
* Remove auto rewarding choice responses
* Change response scripts to be bound to scriptname
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2025_06_22_00_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_06_22_00_world.sql b/sql/updates/world/master/2025_06_22_00_world.sql new file mode 100644 index 00000000000..659c7c7773b --- /dev/null +++ b/sql/updates/world/master/2025_06_22_00_world.sql @@ -0,0 +1,11 @@ +ALTER TABLE `playerchoice` + MODIFY `Duration` bigint NULL DEFAULT 0 AFTER `CloseSoundKitId` + ADD `InfiniteRange` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `Question`, + MODIFY `HideWarboardHeader` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `Question`, + MODIFY `KeepOpenAfterChoice` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `HideWarboardHeader`, + ADD `ShowChoicesAsList` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `KeepOpenAfterChoice`, + ADD `ForceDontShowChoicesAsList` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `ShowChoicesAsList`, + ADD `MaxResponses` int unsigned DEFAULT NULL AFTER `ForceDontShowChoicesAsList`, + ADD `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL AFTER `MaxResponses`; + +ALTER TABLE `playerchoice_response` DROP `ResponseIdentifier`; |