From e487d78ba7b37c35ede36c554169d26afeac88b0 Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 14 Jul 2022 22:32:21 +0200 Subject: Core/WorldStates: Move custom worldstates to separate table and move saving worldstate values to WorldStateMgr --- .../characters/master/2022_07_14_00_characters.sql | 33 ++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 sql/updates/characters/master/2022_07_14_00_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/master/2022_07_14_00_characters.sql b/sql/updates/characters/master/2022_07_14_00_characters.sql new file mode 100644 index 00000000000..078ce489de8 --- /dev/null +++ b/sql/updates/characters/master/2022_07_14_00_characters.sql @@ -0,0 +1,33 @@ +-- +-- Table structure for table `world_state_value` +-- +DROP TABLE IF EXISTS `world_state_value`; +CREATE TABLE `world_state_value` ( + `Id` int NOT NULL, + `Value` int NOT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `world_state_value` +-- +DROP TABLE IF EXISTS `world_variable`; +CREATE TABLE `world_variable` ( + `ID` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Value` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +INSERT INTO `world_state_value` SELECT `entry`, `value` FROM `worldstates` WHERE `entry` NOT BETWEEN 20001 AND 20009 AND `entry` <> 20050; + +INSERT INTO `world_variable` SELECT 'NextCurrencyResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20001; +INSERT INTO `world_variable` SELECT 'NextWeeklyQuestResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20002; +INSERT INTO `world_variable` SELECT 'NextBGRandomDailyResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20003; +INSERT INTO `world_variable` SELECT 'PersistentCharacterCleanFlags', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20004; +INSERT INTO `world_variable` SELECT 'NextGuildDailyResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20006; +INSERT INTO `world_variable` SELECT 'NextMonthlyQuestResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20007; +INSERT INTO `world_variable` SELECT 'NextDailyQuestResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20008; +INSERT INTO `world_variable` SELECT 'NextOldCalendarEventDeletionTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20009; +INSERT INTO `world_variable` SELECT 'NextGuildWeeklyResetTime', ws.`value` FROM `worldstates` ws WHERE ws.entry = 20050; + +DROP TABLE `worldstates`; -- cgit v1.2.3