aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2025-05-14 10:26:06 +0200
committerShauren <shauren.trinity@gmail.com>2025-05-14 10:26:06 +0200
commit1d36eeaa280d0148aa571bee4a14e076666a522b (patch)
tree42766520439e06604fb3f5bdd0bbdd6817581f67
parentc7a75276861c691d55c1c583e93d4b5b3fced3b5 (diff)
Core: Updated allowed build to 11.1.5.60822
-rw-r--r--sql/base/auth_database.sql19
-rw-r--r--sql/updates/auth/master/2025_05_14_00_auth.sql23
2 files changed, 37 insertions, 5 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index d1253955544..e4d2f5ce028 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1084,7 +1084,14 @@ INSERT INTO `build_auth_key` VALUES
(60568,'Mac','x64','WoWC',0x215E50B6E560D093731B8D2EA7A9125B),
(60568,'Win','A64','WoW',0x788B2E434F8F94C2F30912640E1C28E6),
(60568,'Win','x64','WoW',0x2EA108C13157170527F2CDF2581216A2),
-(60568,'Win','x64','WoWC',0x2D180D7E0F83BBAE38177A02273AC016);
+(60568,'Win','x64','WoWC',0x2D180D7E0F83BBAE38177A02273AC016),
+(60822,'Mac','A64','WoW',0xAFC18687E2318BB620E4972B5A3D69BF),
+(60822,'Mac','A64','WoWC',0x9F6E6D114F14EED0D0FB202842572E2E),
+(60822,'Mac','x64','WoW',0xDE216E4A7FA5861A9526E4914CFD867A),
+(60822,'Mac','x64','WoWC',0xC07CBC1D65C06EDCC6D90914A59D76DA),
+(60822,'Win','A64','WoW',0x5696DD4936320D7F8781688A0730950A),
+(60822,'Win','x64','WoW',0x3AAC5F8EB768DFC9161C1506903E19AB),
+(60822,'Win','x64','WoWC',0x0B5F6A7B210ED77012F4341DEF9445F7);
/*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1469,7 +1476,8 @@ INSERT INTO `build_info` VALUES
(60392,11,1,5,NULL),
(60428,11,1,5,NULL),
(60490,11,1,5,NULL),
-(60568,11,1,5,NULL);
+(60568,11,1,5,NULL),
+(60822,11,1,5,NULL);
/*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3081,7 +3089,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 '60568',
+ `gamebuild` int unsigned NOT NULL DEFAULT '60822',
`Region` tinyint unsigned NOT NULL DEFAULT '1',
`Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
@@ -3096,7 +3104,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,60568,1,1);
+(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,60822,1,1);
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3593,7 +3601,8 @@ INSERT INTO `updates` VALUES
('2025_04_10_00_auth.sql','93EBDB49570AFD980449CE6858AFA588ED763FAB','RELEASED','2025-04-10 20:45:44',0),
('2025_04_12_00_auth.sql','A33D1A1E50EA4B6E93DD6BAB5AD624EDAEC39BDF','RELEASED','2025-04-12 00:54:47',0),
('2025_04_25_00_auth.sql','CD64B1560DE7A3715B561FC4E712C5E61C126A1D','RELEASED','2025-04-25 19:43:41',0),
-('2025_04_30_00_auth.sql','B8708581D23575920082C18665E828C629F07DED','RELEASED','2025-04-30 13:15:42',0);
+('2025_04_30_00_auth.sql','B8708581D23575920082C18665E828C629F07DED','RELEASED','2025-04-30 13:15:42',0),
+('2025_05_14_00_auth.sql','E4C40DFB18415ADB60223BA7518A2F0FCD491712','RELEASED','2025-05-14 10:24:56',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/updates/auth/master/2025_05_14_00_auth.sql b/sql/updates/auth/master/2025_05_14_00_auth.sql
new file mode 100644
index 00000000000..927dd2c9636
--- /dev/null
+++ b/sql/updates/auth/master/2025_05_14_00_auth.sql
@@ -0,0 +1,23 @@
+DELETE FROM `build_info` WHERE `build` IN (60822);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(60822,11,1,5,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=60822 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=60822 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=60822 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=60822 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=60822 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=60822 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=60822 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(60822,'Mac','A64','WoW',0xAFC18687E2318BB620E4972B5A3D69BF),
+(60822,'Mac','A64','WoWC',0x9F6E6D114F14EED0D0FB202842572E2E),
+(60822,'Mac','x64','WoW',0xDE216E4A7FA5861A9526E4914CFD867A),
+(60822,'Mac','x64','WoWC',0xC07CBC1D65C06EDCC6D90914A59D76DA),
+(60822,'Win','A64','WoW',0x5696DD4936320D7F8781688A0730950A),
+(60822,'Win','x64','WoW',0x3AAC5F8EB768DFC9161C1506903E19AB),
+(60822,'Win','x64','WoWC',0x0B5F6A7B210ED77012F4341DEF9445F7);
+
+UPDATE `realmlist` SET `gamebuild`=60822 WHERE `gamebuild`=60568;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '60822';