aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2024-12-21 01:03:58 +0100
committerShauren <shauren.trinity@gmail.com>2024-12-21 01:03:58 +0100
commitf8d20722cb4c0b573de11e8d11b71532f962f0b7 (patch)
tree5367ba85f60b8e5997d6b72c417d7bbdf7b28761 /sql/updates/auth
parent884662a75a901af6f61cab9efc171d052e8042f4 (diff)
Core: Updated allowed build to 11.0.7.58238
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/master/2024_12_21_00_auth.sql23
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2024_12_21_00_auth.sql b/sql/updates/auth/master/2024_12_21_00_auth.sql
new file mode 100644
index 00000000000..cf04c9bc407
--- /dev/null
+++ b/sql/updates/auth/master/2024_12_21_00_auth.sql
@@ -0,0 +1,23 @@
+DELETE FROM `build_info` WHERE `build` IN (58238);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(58238,11,0,7,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=58238 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=58238 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=58238 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=58238 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=58238 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=58238 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=58238 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(58238,'Mac','A64','WoW',0x87705176E4D29CD7DCA47A3DB8B20CE9),
+(58238,'Mac','A64','WoWC',0xEC7206B740D162429B4ACCC637132C3D),
+(58238,'Mac','x64','WoW',0x1A40852B2F5EEEE2EB80497B691C88AF),
+(58238,'Mac','x64','WoWC',0x48E25221E6F84CA49685B91B96E1345A),
+(58238,'Win','A64','WoW',0x6AA610F0820BE535EA7017E4C5BD857B),
+(58238,'Win','x64','WoW',0x9D91F6D23C62F0CB538D8D4E4BAA4FC1),
+(58238,'Win','x64','WoWC',0x7B4A168DADC9A598A40794D6165EA95C);
+
+UPDATE `realmlist` SET `gamebuild`=58238 WHERE `gamebuild`=58187;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58238';