aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2024-12-19 12:01:04 +0100
committerShauren <shauren.trinity@gmail.com>2024-12-19 12:01:04 +0100
commit39c42e2a437fad49954d7552baddea83a86f0d67 (patch)
tree2c4082cc55ed4bb8f22b10b3dd84dd2de7d8b79d /sql/updates
parent99c9b4c24062a7f0b6e1481a1d740b558eb52e86 (diff)
Core: Updated allowed build to 4.4.1.58158
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/cata_classic/2024_12_19_00_auth.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/auth/cata_classic/2024_12_19_00_auth.sql b/sql/updates/auth/cata_classic/2024_12_19_00_auth.sql
new file mode 100644
index 00000000000..39858500c50
--- /dev/null
+++ b/sql/updates/auth/cata_classic/2024_12_19_00_auth.sql
@@ -0,0 +1,17 @@
+DELETE FROM `build_info` WHERE `build` IN (58158);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(58158,4,4,1,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=58158 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=58158 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=58158 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=58158 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(58158,'Mac','A64','WoW',0x10EBC722A3FDD740E42B45C7FDD20EF0),
+(58158,'Mac','x64','WoW',0xD7450A6103A5DEB74D818F0C2F4C9085),
+(58158,'Win','A64','WoW',0x31ACD1E756B86D16D8EB5E7A47BB2DBF),
+(58158,'Win','x64','WoW',0x071CE2ACCDCC49D66F160B4218F01915);
+
+UPDATE `realmlist` SET `gamebuild`=58158 WHERE `gamebuild`=57916;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58158';