diff options
| author | Meji <alvaro.megias@outlook.com> | 2023-01-29 17:42:23 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-01-29 17:42:23 +0100 |
| commit | 03918978c166c9fb191117a0cae9ba1285bf0e37 (patch) | |
| tree | 4eb31986b057483a11d39c826b3deb9dc0f4f35b /sql | |
| parent | b6cd49c34d4d02b41ced58b87103123a1532b56c (diff) | |
Core/Players: Several currency fixes and improvements (#28676)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/master/2023_01_29_00_characters.sql | 3 | ||||
| -rw-r--r-- | sql/updates/world/master/2023_01_29_00_world.sql | 7 |
3 files changed, 14 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index cffd7d63a96..2c14b47c119 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -720,6 +720,8 @@ CREATE TABLE `character_currency` ( `Quantity` int unsigned NOT NULL, `WeeklyQuantity` int unsigned NOT NULL, `TrackedQuantity` int unsigned NOT NULL, + `IncreasedCapQuantity` INT UNSIGNED NOT NULL DEFAULT '0', + `EarnedQuantity` INT UNSIGNED NOT NULL DEFAULT '0', `Flags` tinyint unsigned NOT NULL, PRIMARY KEY (`CharacterGuid`,`Currency`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3692,7 +3694,8 @@ INSERT INTO `updates` VALUES ('2022_12_17_00_characters.sql','3E005BD6B9C60653749B0B3C19CBC497092B9CCB','ARCHIVED','2022-12-17 18:26:43',0), ('2022_12_20_00_characters.sql','75A37A085AF1B953926E4352E439C7916B290924','ARCHIVED','2022-12-20 03:10:07',0), ('2022_12_30_00_characters.sql','5F90C2BFFBB8F6CE0A3327A2CAABCD5CA3C2BA60','RELEASED','2022-12-30 22:50:16',0), -('2023_01_28_00_characters.sql','0280F79FD6EC93FFB3CC67B6499CEDA49D582BFC','RELEASED','2023-01-28 00:11:03',0); +('2023_01_28_00_characters.sql','0280F79FD6EC93FFB3CC67B6499CEDA49D582BFC','RELEASED','2023-01-28 00:11:03',0), +('2023_01_29_00_characters.sql','24FA9E0F616BF77AC588A25A8A8699903A19A5FE','RELEASED','2023-01-29 16:31:12',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2023_01_29_00_characters.sql b/sql/updates/characters/master/2023_01_29_00_characters.sql new file mode 100644 index 00000000000..89522507989 --- /dev/null +++ b/sql/updates/characters/master/2023_01_29_00_characters.sql @@ -0,0 +1,3 @@ +ALTER TABLE `character_currency` +ADD `IncreasedCapQuantity` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `TrackedQuantity`, +ADD `EarnedQuantity` INT UNSIGNED NOT NULL DEFAULT 0 AFTER `IncreasedCapQuantity`; diff --git a/sql/updates/world/master/2023_01_29_00_world.sql b/sql/updates/world/master/2023_01_29_00_world.sql new file mode 100644 index 00000000000..b0142da530d --- /dev/null +++ b/sql/updates/world/master/2023_01_29_00_world.sql @@ -0,0 +1,7 @@ +DELETE FROM `world_state` WHERE `ID` IN (19735, 20084, 20838, 22869, 22980); +INSERT INTO `world_state` (`ID`, `DefaultValue`, `MapIDs`, `AreaIDs`, `ScriptName`, `Comment`) VALUES +(19735, 79, -1, NULL, '', 'Covenant Renown (Currency) - Max quantity'), +(20084, 0, -1, NULL, '', 'Shadowlands PvP Weekly Reward Progress (Currency) - Max quantity'), +(20838, 3510, -1, NULL, '', 'Tower Knowledge (Currency) - Max quantity'), +(22869, 245000, -1, NULL, '', 'Conquest (Currency) - Max quantity'), +(22980, 3000, -1, NULL, '', 'Valor (Currency) - Max quantity'); |