From 85f9d08932255e4c013c046a10efca2bbde54878 Mon Sep 17 00:00:00 2001 From: Shauren Date: Wed, 21 May 2025 10:14:52 +0200 Subject: Core: Updated allowed build to 4.4.2.60895 --- sql/base/auth_database.sql | 19 +++++++++++++----- .../auth/cata_classic/2025_05_21_00_auth.sql | 23 ++++++++++++++++++++++ 2 files changed, 37 insertions(+), 5 deletions(-) create mode 100644 sql/updates/auth/cata_classic/2025_05_21_00_auth.sql diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 76015286092..4c845014a4a 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -823,7 +823,14 @@ INSERT INTO `build_auth_key` VALUES (60192,'Mac','x64','WoWC',0xBD3205EC191FE1DE0E7A207EF459DE97), (60192,'Win','A64','WoW',0xA6F329ED8EBC1B43E59997AFD82BD5C1), (60192,'Win','x64','WoW',0x6987F36EEE27CBF05AF1D7841E77EE73), -(60192,'Win','x64','WoWC',0xDC9D44DF6087F92CFE81F3CF3DAF8615); +(60192,'Win','x64','WoWC',0xDC9D44DF6087F92CFE81F3CF3DAF8615), +(60895,'Mac','A64','WoW',0x3EB8484A7F8BD3C993891E10396E182F), +(60895,'Mac','A64','WoWC',0xC1F12AD6FB05A5F92B9152D3505DC025), +(60895,'Mac','x64','WoW',0x324477347CCC88C66C12835377288474), +(60895,'Mac','x64','WoWC',0x35192970DDC99E61776C2C65AA479222), +(60895,'Win','A64','WoW',0x078E2CC82A4F3C342A4CE340341567AE), +(60895,'Win','x64','WoW',0x5885E3019AE3F51D0227F92C365BABD3), +(60895,'Win','x64','WoWC',0x0CAE464F32D03F1EEF0F14B2529907D2); /*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */; UNLOCK TABLES; @@ -1155,7 +1162,8 @@ INSERT INTO `build_info` VALUES (59734,4,4,2,NULL), (59962,4,4,2,NULL), (60142,4,4,2,NULL), -(60192,4,4,2,NULL); +(60192,4,4,2,NULL), +(60895,4,4,2,NULL); /*!40000 ALTER TABLE `build_info` ENABLE KEYS */; UNLOCK TABLES; @@ -2767,7 +2775,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 '60192', + `gamebuild` int unsigned NOT NULL DEFAULT '60895', `Region` tinyint unsigned NOT NULL DEFAULT '1', `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), @@ -2782,7 +2790,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,60192,1,1); +(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,60895,1,1); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -3238,7 +3246,8 @@ INSERT INTO `updates` VALUES ('2025_04_05_00_auth.sql','2523EEC30D3456441CF4EA8ED5E529506CED238B','ARCHIVED','2025-04-05 15:16:45',0), ('2025_04_06_00_auth.sql','D65E53E402A789FC413131E1720830B43FEAD967','ARCHIVED','2025-04-06 19:08:23',0), ('2025_04_09_01_auth.sql','07470857CD49E55C61714A9BB855EF49D645266B','ARCHIVED','2025-04-09 10:07:46',0), -('2025_05_11_00_auth.sql','5024DAF97BDADC8ABAD06A893F920BACD45A59EC','ARCHIVED','2025-05-11 10:42:32',0); +('2025_05_11_00_auth.sql','5024DAF97BDADC8ABAD06A893F920BACD45A59EC','ARCHIVED','2025-05-11 10:42:32',0), +('2025_05_21_00_auth.sql','A2DB1127BDA3C3EA274D99771F7D753A33FBB15D','RELEASED','2025-05-21 10:14:15',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/cata_classic/2025_05_21_00_auth.sql b/sql/updates/auth/cata_classic/2025_05_21_00_auth.sql new file mode 100644 index 00000000000..d092ad085ee --- /dev/null +++ b/sql/updates/auth/cata_classic/2025_05_21_00_auth.sql @@ -0,0 +1,23 @@ +DELETE FROM `build_info` WHERE `build` IN (60895); +INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES +(60895,4,4,2,NULL); + +DELETE FROM `build_auth_key` WHERE `build`=60895 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=60895 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=60895 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=60895 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=60895 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=60895 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=60895 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; +INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES +(60895,'Mac','A64','WoW',0x3EB8484A7F8BD3C993891E10396E182F), +(60895,'Mac','A64','WoWC',0xC1F12AD6FB05A5F92B9152D3505DC025), +(60895,'Mac','x64','WoW',0x324477347CCC88C66C12835377288474), +(60895,'Mac','x64','WoWC',0x35192970DDC99E61776C2C65AA479222), +(60895,'Win','A64','WoW',0x078E2CC82A4F3C342A4CE340341567AE), +(60895,'Win','x64','WoW',0x5885E3019AE3F51D0227F92C365BABD3), +(60895,'Win','x64','WoWC',0x0CAE464F32D03F1EEF0F14B2529907D2); + +UPDATE `realmlist` SET `gamebuild`=60895 WHERE `gamebuild`=60192; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '60895'; -- cgit v1.2.3