aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2025-01-14 09:51:09 +0100
committerShauren <shauren.trinity@gmail.com>2025-01-14 09:51:09 +0100
commitd49a8d4a3e0613be0c2fc1e6e823b5a5cd1f9fca (patch)
treea749651d658035bb9404a117720473c4a6e5a4f7 /sql/updates/auth
parentf02d30be65459540b0d07f6e774bf2e02e18c42c (diff)
Core: Updated allowed build to 4.4.1.58558
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/cata_classic/2025_01_14_00_auth.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/auth/cata_classic/2025_01_14_00_auth.sql b/sql/updates/auth/cata_classic/2025_01_14_00_auth.sql
new file mode 100644
index 00000000000..6b442d06db8
--- /dev/null
+++ b/sql/updates/auth/cata_classic/2025_01_14_00_auth.sql
@@ -0,0 +1,17 @@
+DELETE FROM `build_info` WHERE `build` IN (58558);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(58558,4,4,1,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=58558 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=58558 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=58558 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=58558 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(58558,'Mac','A64','WoW',0x7FD54AE255B9757285A661630FA707B8),
+(58558,'Mac','x64','WoW',0x2D8D31D0DD1BF85E89292619CCF4317F),
+(58558,'Win','A64','WoW',0x498916D48F0C962F162FF425A443FA52),
+(58558,'Win','x64','WoW',0x80FEC2B5AC7846BAFB99FCF9C963DEF1);
+
+UPDATE `realmlist` SET `gamebuild`=58558 WHERE `gamebuild`=58158;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58558';