diff options
| -rw-r--r-- | sql/base/auth_database.sql | 19 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_02_21_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 7b09e297196..ae3af315ffd 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -946,7 +946,14 @@ INSERT INTO `build_auth_key` VALUES (59207,'Mac','x64','WoWC',0x5FB60ADC82C68D1E50B70956BFBC77BC), (59207,'Win','A64','WoW',0x41AF3D9F83318D4FC4406BF5C23B20AB), (59207,'Win','x64','WoW',0x170FB48807771D186547DF96C59E5306), -(59207,'Win','x64','WoWC',0xA9038B171DE62AF741304A4C0F273814); +(59207,'Win','x64','WoWC',0xA9038B171DE62AF741304A4C0F273814), +(59302,'Mac','A64','WoW',0x70A6BE00213BB70AB96C51280D72D186), +(59302,'Mac','A64','WoWC',0x6A5CFE0D3A4BDEC7D16D33E9ACA7D71D), +(59302,'Mac','x64','WoW',0x9FD959000AFAA2E5F10A4ABE33AC62BE), +(59302,'Mac','x64','WoWC',0xD39B478EFD342D568DCBC2E85FCA574D), +(59302,'Win','A64','WoW',0x60B1757CA707789C9ACD6F1FB69E28D5), +(59302,'Win','x64','WoW',0x330E4E7EF1E07DA8382C813650D7E7B5), +(59302,'Win','x64','WoWC',0xB5A0C54F6B334515E68260F6334E7593); /*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */; UNLOCK TABLES; @@ -1315,7 +1322,8 @@ INSERT INTO `build_info` VALUES (58773,11,0,7,NULL), (58867,11,0,7,NULL), (58911,11,0,7,NULL), -(59207,11,0,7,NULL); +(59207,11,0,7,NULL), +(59302,11,0,7,NULL); /*!40000 ALTER TABLE `build_info` ENABLE KEYS */; UNLOCK TABLES; @@ -2927,7 +2935,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 '59207', + `gamebuild` int unsigned NOT NULL DEFAULT '59302', `Region` tinyint unsigned NOT NULL DEFAULT '1', `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), @@ -2942,7 +2950,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,59207,1,1); +(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,59302,1,1); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -3425,7 +3433,8 @@ INSERT INTO `updates` VALUES ('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), ('2025_02_03_00_auth.sql','87033116EF72051499AF23FE14545D828F5A9B59','RELEASED','2025-02-03 22:51:31',0), -('2025_02_19_00_auth.sql','6D0EBB3E2DD1B26682A424EDDC090F515BCA5B32','RELEASED','2025-02-19 00:16:52',0); +('2025_02_19_00_auth.sql','6D0EBB3E2DD1B26682A424EDDC090F515BCA5B32','RELEASED','2025-02-19 00:16:52',0), +('2025_02_21_00_auth.sql','E9EA49CEB396561D641A7C82251DCBF9DF3E9983','RELEASED','2025-02-21 00:53:17',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2025_02_21_00_auth.sql b/sql/updates/auth/master/2025_02_21_00_auth.sql new file mode 100644 index 00000000000..7b62ffdee9b --- /dev/null +++ b/sql/updates/auth/master/2025_02_21_00_auth.sql @@ -0,0 +1,23 @@ +DELETE FROM `build_info` WHERE `build` IN (59302); +INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES +(59302,11,0,7,NULL); + +DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; +INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES +(59302,'Mac','A64','WoW',0x70A6BE00213BB70AB96C51280D72D186), +(59302,'Mac','A64','WoWC',0x6A5CFE0D3A4BDEC7D16D33E9ACA7D71D), +(59302,'Mac','x64','WoW',0x9FD959000AFAA2E5F10A4ABE33AC62BE), +(59302,'Mac','x64','WoWC',0xD39B478EFD342D568DCBC2E85FCA574D), +(59302,'Win','A64','WoW',0x60B1757CA707789C9ACD6F1FB69E28D5), +(59302,'Win','x64','WoW',0x330E4E7EF1E07DA8382C813650D7E7B5), +(59302,'Win','x64','WoWC',0xB5A0C54F6B334515E68260F6334E7593); + +UPDATE `realmlist` SET `gamebuild`=59302 WHERE `gamebuild`=59207; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '59302'; |