diff options
| -rw-r--r-- | sql/base/auth_database.sql | 19 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_01_31_00_auth.sql | 23 |
2 files changed, 37 insertions, 5 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 2e15626b3b9..f7e92e3fa63 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -925,7 +925,14 @@ INSERT INTO `build_auth_key` VALUES (58773,'Mac','x64','WoWC',0x8431C2D85A026E13E3E114C7AE83F0DE), (58773,'Win','A64','WoW',0x9ADF3B9E70DF0176CEC196480BA407A3), (58773,'Win','x64','WoW',0x648474DEE9F16AF1C02BD63F7F3E9B01), -(58773,'Win','x64','WoWC',0x362C80C4498FFA1DE3CC0AF243E1337A); +(58773,'Win','x64','WoWC',0x362C80C4498FFA1DE3CC0AF243E1337A), +(58867,'Mac','A64','WoW',0x0BA2958770DFBFDB933851A4AADB4950), +(58867,'Mac','A64','WoWC',0x0D747A5931DF5B155B5CC4892D63E1D8), +(58867,'Mac','x64','WoW',0xA3696DF215AAB11F4F340C5C4393FB89), +(58867,'Mac','x64','WoWC',0xB7C65FC1DA519ED5304019262FEFEFA6), +(58867,'Win','A64','WoW',0xEF8C2258197FDBC6DA5C39699BDEB7A1), +(58867,'Win','x64','WoW',0x7C1627A7325C57FAD21A29D57BBF80A6), +(58867,'Win','x64','WoWC',0x3F8E07E581847B644D6F76489477540D); /*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */; UNLOCK TABLES; @@ -1291,7 +1298,8 @@ INSERT INTO `build_info` VALUES (58608,11,0,7,NULL), (58630,11,0,7,NULL), (58680,11,0,7,NULL), -(58773,11,0,7,NULL); +(58773,11,0,7,NULL), +(58867,11,0,7,NULL); /*!40000 ALTER TABLE `build_info` ENABLE KEYS */; UNLOCK TABLES; @@ -2903,7 +2911,7 @@ CREATE TABLE `realmlist` ( `timezone` tinyint unsigned NOT NULL DEFAULT '0', `allowedSecurityLevel` tinyint unsigned NOT NULL DEFAULT '0', `population` float NOT NULL DEFAULT '0', - `gamebuild` int unsigned NOT NULL DEFAULT '58773', + `gamebuild` int unsigned NOT NULL DEFAULT '58867', `Region` tinyint unsigned NOT NULL DEFAULT '1', `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), @@ -2918,7 +2926,7 @@ CREATE TABLE `realmlist` ( LOCK TABLES `realmlist` WRITE; /*!40000 ALTER TABLE `realmlist` DISABLE KEYS */; INSERT INTO `realmlist` VALUES -(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,58773,1,1); +(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,58867,1,1); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -3398,7 +3406,8 @@ INSERT INTO `updates` VALUES ('2025_01_15_00_auth.sql','8EA1C0A88F6F1EC3DA67DA01CDCF056A530DBB5F','RELEASED','2025-01-15 00:44:53',0), ('2025_01_15_01_auth.sql','885A553B190CCD7A22791AF4EC3BC15C43DDC2D2','RELEASED','2025-01-15 10:27:39',0), ('2025_01_22_00_auth.sql','E08C40B02DB391DC1A478B6C714FDDDDB144F24F','RELEASED','2025-01-22 20:58:45',0), -('2025_01_29_00_auth.sql','7334CFE779D5F79AFAC8EA269950FC07E625810F','RELEASED','2025-01-29 12:57:32',0); +('2025_01_29_00_auth.sql','7334CFE779D5F79AFAC8EA269950FC07E625810F','RELEASED','2025-01-29 12:57:32',0), +('2025_01_31_00_auth.sql','DF2640D25C15E41358C1ED46B4F86043583FC8FB','RELEASED','2025-01-31 11:51:23',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2025_01_31_00_auth.sql b/sql/updates/auth/master/2025_01_31_00_auth.sql new file mode 100644 index 00000000000..d47b413c86c --- /dev/null +++ b/sql/updates/auth/master/2025_01_31_00_auth.sql @@ -0,0 +1,23 @@ +DELETE FROM `build_info` WHERE `build` IN (58867); +INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES +(58867,11,0,7,NULL); + +DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; +INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES +(58867,'Mac','A64','WoW',0x0BA2958770DFBFDB933851A4AADB4950), +(58867,'Mac','A64','WoWC',0x0D747A5931DF5B155B5CC4892D63E1D8), +(58867,'Mac','x64','WoW',0xA3696DF215AAB11F4F340C5C4393FB89), +(58867,'Mac','x64','WoWC',0xB7C65FC1DA519ED5304019262FEFEFA6), +(58867,'Win','A64','WoW',0xEF8C2258197FDBC6DA5C39699BDEB7A1), +(58867,'Win','x64','WoW',0x7C1627A7325C57FAD21A29D57BBF80A6), +(58867,'Win','x64','WoWC',0x3F8E07E581847B644D6F76489477540D); + +UPDATE `realmlist` SET `gamebuild`=58867 WHERE `gamebuild`=58773; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58867'; |