diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 19 | ||||
| -rw-r--r-- | sql/updates/auth/master/2024_11_14_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 66955e08680..af17b05c335 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -842,7 +842,14 @@ INSERT INTO `build_auth_key` VALUES (57388,'Mac','x64','WoWC',0xBFFDD44D892A2143B61BB59E448E348C), (57388,'Win','A64','WoW',0x92129DE92D2BA5F67581C5DE642B1289), (57388,'Win','x64','WoW',0x16F9CB724C662E3E8029A442443C6305), -(57388,'Win','x64','WoWC',0xDFD9BFFD00FBEFECBF0AEF0FFC9E8F2D); +(57388,'Win','x64','WoWC',0xDFD9BFFD00FBEFECBF0AEF0FFC9E8F2D), +(57534,'Mac','A64','WoW',0x073B823E8991A0DF012AE33D661A6060), +(57534,'Mac','A64','WoWC',0xC8824559DC24858EA7E3BD0971F98A15), +(57534,'Mac','x64','WoW',0x0C7C67AAAD4011AA9D81AB838B255CDF), +(57534,'Mac','x64','WoWC',0xCE9CD9A02B04F0C3B126F3C7E1BF7228), +(57534,'Win','A64','WoW',0xCC612F1485F158C8B2730B7DFD926563), +(57534,'Win','x64','WoW',0x948857BF76A28FD24C5A06D18B4F2FCF), +(57534,'Win','x64','WoWC',0x62B0812A4518C21360685D4422C2A312); /*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */; UNLOCK TABLES; @@ -1196,7 +1203,8 @@ INSERT INTO `build_info` VALUES (57171,11,0,5,NULL), (57212,11,0,5,NULL), (57292,11,0,5,NULL), -(57388,11,0,5,NULL); +(57388,11,0,5,NULL), +(57534,11,0,5,NULL); /*!40000 ALTER TABLE `build_info` ENABLE KEYS */; UNLOCK TABLES; @@ -2808,7 +2816,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 '57388', + `gamebuild` int unsigned NOT NULL DEFAULT '57534', `Region` tinyint unsigned NOT NULL DEFAULT '1', `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), @@ -2823,7 +2831,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,57388,1,1); +(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,57534,1,1); /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */; UNLOCK TABLES; @@ -3291,7 +3299,8 @@ INSERT INTO `updates` VALUES ('2024_10_30_00_auth.sql','B4C930B0CE499704CEBF208A71871061DC27008C','RELEASED','2024-10-30 13:04:40',0), ('2024_11_01_00_auth.sql','62EF7FC9CD2DCD8D24CE1BCED3BF9E2917B6674B','RELEASED','2024-11-01 13:26:56',0), ('2024_11_11_00_auth.sql','F47CDFB857DB4105306739AF4FBBB3C92CA43363','RELEASED','2024-11-11 13:34:09',0), -('2024_11_12_00_auth.sql','5A236A557291758C0F2C46FDEC02692E7C53F751','RELEASED','2024-11-12 11:42:13',0); +('2024_11_12_00_auth.sql','5A236A557291758C0F2C46FDEC02692E7C53F751','RELEASED','2024-11-12 11:42:13',0), +('2024_11_14_00_auth.sql','646A438FAD5A83D80DCDDEDC71BB6CF21A1FE490','RELEASED','2024-11-14 10:29:52',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2024_11_14_00_auth.sql b/sql/updates/auth/master/2024_11_14_00_auth.sql new file mode 100644 index 00000000000..a32fafed936 --- /dev/null +++ b/sql/updates/auth/master/2024_11_14_00_auth.sql @@ -0,0 +1,23 @@ +DELETE FROM `build_info` WHERE `build` IN (57534); +INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES +(57534,11,0,5,NULL); + +DELETE FROM `build_auth_key` WHERE `build`=57534 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=57534 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=57534 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=57534 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=57534 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=57534 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=57534 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; +INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES +(57534,'Mac','A64','WoW',0x073B823E8991A0DF012AE33D661A6060), +(57534,'Mac','A64','WoWC',0xC8824559DC24858EA7E3BD0971F98A15), +(57534,'Mac','x64','WoW',0x0C7C67AAAD4011AA9D81AB838B255CDF), +(57534,'Mac','x64','WoWC',0xCE9CD9A02B04F0C3B126F3C7E1BF7228), +(57534,'Win','A64','WoW',0xCC612F1485F158C8B2730B7DFD926563), +(57534,'Win','x64','WoW',0x948857BF76A28FD24C5A06D18B4F2FCF), +(57534,'Win','x64','WoWC',0x62B0812A4518C21360685D4422C2A312); + +UPDATE `realmlist` SET `gamebuild`=57534 WHERE `gamebuild`=57388; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '57534'; |