From e59059e1bd2f67691e2da0105771b0cb55b123a4 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 22 Jun 2025 21:56:58 +0200 Subject: 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 --- sql/updates/world/master/2025_06_22_00_world.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/master/2025_06_22_00_world.sql (limited to 'sql/updates') 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`; -- cgit v1.2.3