diff options
| author | Shauren <shauren.trinity@gmail.com> | 2024-08-18 18:59:58 +0200 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2024-08-18 20:39:21 +0200 |
| commit | 25ffdbc5ef0859aeaadfa132329a498e86827e68 (patch) | |
| tree | d7df51da8cdc3e3df7c50e5058803f9324715ee4 /sql | |
| parent | 0c98004896cb91ef2d22baa5569ff0e0d6cd15ee (diff) | |
Core/Realms: Realmlist refactors
* Removed global realm variable from World and use RealmList everywhere
* Match auth build key with client version
* Restored allowedSecurityLevel checks for realmlist packet building
* Restored updating population field, mysteriously removed 15 years ago in f20b25d1c90f608deab28c9957b3b376ab2a0d50
(cherry picked from commit c4b710446d62c95eb8124175203fa5f394912594)
# Conflicts:
# sql/base/auth_database.sql
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/auth/cata_classic/2024_08_18_00_auth_2024_08_18_00_auth.sql | 1 |
2 files changed, 4 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 8c8ee64c716..ef583a6930a 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -44,6 +44,7 @@ CREATE TABLE `account` ( `mutetime` bigint NOT NULL DEFAULT '0', `mutereason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `muteby` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `client_build` int unsigned NOT NULL DEFAULT '0', `locale` tinyint unsigned NOT NULL DEFAULT '0', `os` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `timezone_offset` smallint NOT NULL DEFAULT '0', @@ -2835,7 +2836,8 @@ INSERT INTO `updates` VALUES ('2024_07_09_00_auth.sql','A70A151A72308DC74B7AF0B7ACD1D87DE495538C','RELEASED','2024-07-09 21:19:18',0), ('2024_07_14_00_auth.sql','578817B8AAD12414DEAF24A35AF400B304179524','RELEASED','2024-07-14 19:04:54',0), ('2024_07_18_00_auth.sql','14FE2B8507519A7D7D21A6E3CFEDD6D40A9F689D','RELEASED','2024-07-18 22:44:20',0), -('2024_08_09_00_auth.sql','3088FE594C953A1845B5A95A6F104A8EEF946D8C','RELEASED','2024-08-09 12:15:53',0); +('2024_08_09_00_auth.sql','3088FE594C953A1845B5A95A6F104A8EEF946D8C','RELEASED','2024-08-09 12:15:53',0), +('2024_08_18_00_auth_2024_08_18_00_auth.sql','5C1D0A3FE0245F4030FE446288AE533556EC6C9E','RELEASED','2024-08-18 20:36:28',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/cata_classic/2024_08_18_00_auth_2024_08_18_00_auth.sql b/sql/updates/auth/cata_classic/2024_08_18_00_auth_2024_08_18_00_auth.sql new file mode 100644 index 00000000000..641e0d3d181 --- /dev/null +++ b/sql/updates/auth/cata_classic/2024_08_18_00_auth_2024_08_18_00_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `account` ADD `client_build` int unsigned NOT NULL DEFAULT '0' AFTER `muteby`; |