diff options
| author | Ovahlord <dreadkiller@gmx.de> | 2024-03-19 20:08:00 +0100 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2024-03-19 20:08:00 +0100 |
| commit | 88ff1e7cff39675b6433d156715cff772314a2d1 (patch) | |
| tree | 0f7bb866712f68981ab9e8681d1dc43cf07f42af /sql | |
| parent | cc6fb985954d54ecb95c64f3c174fa78a18dbe30 (diff) | |
Core/Packets: fixed CMSG_SET_ACTION_BUTTON packet structure and downgraded player actions for classic
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 9 | ||||
| -rw-r--r-- | sql/updates/characters/cata_classic/2024_03_19_00_characters.sql | 1 |
2 files changed, 6 insertions, 4 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 3c767dcf735..759f207e814 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -460,7 +460,7 @@ CREATE TABLE `character_action` ( `spec` tinyint unsigned NOT NULL DEFAULT '0', `traitConfigId` int NOT NULL DEFAULT '0', `button` tinyint unsigned NOT NULL DEFAULT '0', - `action` bigint unsigned NOT NULL DEFAULT '0', + `action` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spec`,`traitConfigId`,`button`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3473,9 +3473,10 @@ INSERT INTO `updates` VALUES ('2023_11_02_00_characters.sql','1A76A843F204901C8598DA5682029E815477E427','ARCHIVED','2023-11-02 18:59:41',0), ('2023_11_09_00_characters.sql','1A3D7CA6890353DA55793FE8D925CC8C54965A69','ARCHIVED','2023-11-09 00:56:31',0), ('2023_11_15_00_characters.sql','441E0F17DE3E3945307AC400DF86FCDF06C61653','ARCHIVED','2023-11-15 00:53:47',0), -('2024_02_08_00_characters.sql','743A11042AA17CDBD5F3D510D24509A10838DB5A','ARCHIVED','2024-02-08 00:56:26',0), -('2024_03_12_00_characters.sql','C91A51EA86C26F3AB60445FE147B0E4B220716A0','ARCHIVED','2024-03-13 17:10:46',0), -('2024_03_13_00_characters.sql','6360F50059E5DB1F248FA8A270CDC4788A03A0EC','ARCHIVED','2024-03-13 17:10:46',0); +('2024_02_08_00_characters.sql','743A11042AA17CDBD5F3D510D24509A10838DB5A','RELEASED','2024-02-08 00:56:26',0), +('2024_03_12_00_characters.sql','C91A51EA86C26F3AB60445FE147B0E4B220716A0','RELEASED','2024-03-13 17:10:46',0), +('2024_03_13_00_characters.sql','6360F50059E5DB1F248FA8A270CDC4788A03A0EC','RELEASED','2024-03-13 17:10:46',0), +('2024_03_19_00_characters.sql','1D200630578074A4E3A373F891323DB867D00B02','RELEASED','2024-03-19 19:59:26',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/cata_classic/2024_03_19_00_characters.sql b/sql/updates/characters/cata_classic/2024_03_19_00_characters.sql new file mode 100644 index 00000000000..f770c867236 --- /dev/null +++ b/sql/updates/characters/cata_classic/2024_03_19_00_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `character_action` MODIFY `action` int unsigned NOT NULL DEFAULT 0; |