diff options
author | Shauren <shauren.trinity@gmail.com> | 2025-05-14 11:22:58 +0200 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2025-05-14 11:22:58 +0200 |
commit | b2335abdeebdcf77273c2feb6fee09026d485c59 (patch) | |
tree | d14ad5085937c27b0c4d9742b9e3702cdaa7f520 | |
parent | 7cbcf936463cb415609668c0526da9edb89e0878 (diff) |
Core: Updated allowed build to 3.4.4.60430
-rw-r--r-- | sql/base/auth_database.sql | 19 | ||||
-rw-r--r-- | sql/updates/auth/wotlk_classic/2025_05_14_01_auth.sql | 21 |
2 files changed, 35 insertions, 5 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 76015286092..e28f8cbec51 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), +(60430,'Mac','A64','WoW',0x609EC45C91EDB8321661544F86B9A096), +(60430,'Mac','A64','WoWC',0x3B6ED9376281DB0E6339A625BB9743F0), +(60430,'Mac','x64','WoW',0xA34871650A57BDD5D2BE82D70C58B5E3), +(60430,'Mac','x64','WoWC',0xBB2A13A903B977D07C309E4DACBB71EB), +(60430,'Win','A64','WoW',0x97F797102416865C120CD4B3EC417262), +(60430,'Win','x64','WoW',0xD3F12533E7E9078A55A81965C446E06E), +(60430,'Win','x64','WoWC',0xEAF61FBF3CA18961A86B62A54191D000); /*!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), +(60430,3,4,4,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 '60430', `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,60430,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_14_01_auth.sql','F1394E981E968DB81333205608092340DB78559C','RELEASED','2025-05-14 11:16:12',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/wotlk_classic/2025_05_14_01_auth.sql b/sql/updates/auth/wotlk_classic/2025_05_14_01_auth.sql new file mode 100644 index 00000000000..1cdf677db66 --- /dev/null +++ b/sql/updates/auth/wotlk_classic/2025_05_14_01_auth.sql @@ -0,0 +1,21 @@ +DELETE FROM `build_info` WHERE `build` IN (60430); +INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES +(60430,3,4,4,NULL); + +DELETE FROM `build_auth_key` WHERE `build`=60430 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=60430 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=60430 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=60430 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=60430 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=60430 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=60430 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; +INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES +(60430,'Mac','A64','WoW',0x609EC45C91EDB8321661544F86B9A096), +(60430,'Mac','A64','WoWC',0x3B6ED9376281DB0E6339A625BB9743F0), +(60430,'Mac','x64','WoW',0xA34871650A57BDD5D2BE82D70C58B5E3), +(60430,'Mac','x64','WoWC',0xBB2A13A903B977D07C309E4DACBB71EB), +(60430,'Win','A64','WoW',0x97F797102416865C120CD4B3EC417262), +(60430,'Win','x64','WoW',0xD3F12533E7E9078A55A81965C446E06E), +(60430,'Win','x64','WoWC',0xEAF61FBF3CA18961A86B62A54191D000); + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '60430'; |