aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2023-07-22 14:25:53 +0200
committerShauren <shauren.trinity@gmail.com>2023-07-22 14:25:53 +0200
commit2605a66396464c81317bf91cd85ee63a32a99e1f (patch)
treea7afcc4979077904cb3fa36967aaab4aa44a511d
parent970a274be131e694b2fdf6f2b4d572dfc7151b56 (diff)
Core: Update allowed build to 10.1.5.50585
-rw-r--r--sql/base/auth_database.sql8
-rw-r--r--sql/updates/auth/master/2023_07_22_00_auth.sql7
2 files changed, 12 insertions, 3 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index dcd1fbe7ba1..0c0e80fede7 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -723,7 +723,8 @@ INSERT INTO `build_info` VALUES
(50438,10,1,5,NULL,NULL,'0B5F68F06B129CB4C57702F6D30F260B',NULL,NULL,NULL),
(50467,10,1,5,NULL,NULL,'5E996B1CDCEE68432D6340138E68D1EB',NULL,NULL,NULL),
(50469,10,1,5,NULL,NULL,'1768CCB6589E16AB3BEFA9D608A393A2',NULL,NULL,NULL),
-(50504,10,1,5,NULL,NULL,'7D5FD20C0B32C9AF5DD65433B391D49C',NULL,NULL,NULL);
+(50504,10,1,5,NULL,NULL,'7D5FD20C0B32C9AF5DD65433B391D49C',NULL,NULL,NULL),
+(50585,10,1,5,NULL,NULL,'C4F7CC38A3B84935A485F7EDAD3E764B',NULL,NULL,NULL);
/*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2331,7 +2332,7 @@ CREATE TABLE `realmlist` (
`timezone` tinyint unsigned NOT NULL DEFAULT '0',
`allowedSecurityLevel` tinyint unsigned NOT NULL DEFAULT '0',
`population` float unsigned NOT NULL DEFAULT '0',
- `gamebuild` int unsigned NOT NULL DEFAULT '50504',
+ `gamebuild` int unsigned NOT NULL DEFAULT '50585',
`Region` tinyint unsigned NOT NULL DEFAULT '1',
`Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
@@ -2717,7 +2718,8 @@ INSERT INTO `updates` VALUES
('2023_07_14_00_auth.sql','B66CDB7EE7E554992BB2A9DAB3C16122411C81DF','ARCHIVED','2023-07-14 08:24:44',0),
('2023_07_14_01_auth.sql','8037C5101A08824DA6FE6B16E0004704DFC5B8FA','RELEASED','2023-07-14 19:35:41',0),
('2023_07_15_00_auth.sql','89D51F3E0EAAA957A7C0E4A4A7812505F61F12E6','RELEASED','2023-07-15 00:15:31',0),
-('2023_07_19_00_auth.sql','8FE0EAB6C8DA5B060E95A9715F3D374340E361DD','RELEASED','2023-07-19 19:31:35',0);
+('2023_07_19_00_auth.sql','8FE0EAB6C8DA5B060E95A9715F3D374340E361DD','RELEASED','2023-07-19 19:31:35',0),
+('2023_07_22_00_auth.sql','38BDC8DE5697366E26588552830E34E420861008','RELEASED','2023-07-22 13:57:13',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/updates/auth/master/2023_07_22_00_auth.sql b/sql/updates/auth/master/2023_07_22_00_auth.sql
new file mode 100644
index 00000000000..cd88b6e3f2a
--- /dev/null
+++ b/sql/updates/auth/master/2023_07_22_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=50585;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(50585,10,1,5,NULL,NULL,'C4F7CC38A3B84935A485F7EDAD3E764B',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=50585 WHERE `gamebuild`=50504;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50585';