aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2024-11-01 13:28:26 +0100
committerShauren <shauren.trinity@gmail.com>2024-11-01 13:28:26 +0100
commit315369e87db9e220da309fe79cf01e2c3a24feb4 (patch)
treef52f1ee187e0f3a1c5baff7c0c947c646ac011d6 /sql/updates/auth
parent0d4a9e48deb527b70cc73689d1071969d9e38f01 (diff)
Core: Updated allowed build to 11.0.5.57388
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/master/2024_11_01_00_auth.sql23
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2024_11_01_00_auth.sql b/sql/updates/auth/master/2024_11_01_00_auth.sql
new file mode 100644
index 00000000000..8785a0705d3
--- /dev/null
+++ b/sql/updates/auth/master/2024_11_01_00_auth.sql
@@ -0,0 +1,23 @@
+DELETE FROM `build_info` WHERE `build` IN (57388);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(57388,11,0,5,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=57388 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=57388 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=57388 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=57388 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=57388 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=57388 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=57388 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(57388,'Mac','A64','WoW',0xFA9D6F044063948AB74FB3FDE335C0D5),
+(57388,'Mac','A64','WoWC',0x3962974506F57EF33BBBD4C904A82157),
+(57388,'Mac','x64','WoW',0xE7E3432357BC634EBD7B76BA40D51FD2),
+(57388,'Mac','x64','WoWC',0xBFFDD44D892A2143B61BB59E448E348C),
+(57388,'Win','A64','WoW',0x92129DE92D2BA5F67581C5DE642B1289),
+(57388,'Win','x64','WoW',0x16F9CB724C662E3E8029A442443C6305),
+(57388,'Win','x64','WoWC',0xDFD9BFFD00FBEFECBF0AEF0FFC9E8F2D);
+
+UPDATE `realmlist` SET `gamebuild`=57388 WHERE `gamebuild`=57292;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '57388';