aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2024-10-02 00:04:40 +0200
committerShauren <shauren.trinity@gmail.com>2024-10-02 00:04:40 +0200
commita26eed241219484904171b5c124dd16ed36aec80 (patch)
treea7c58ed3a3b0e1cc99d1e105365c1e923e45502c /sql/updates
parentb13b5142f1009a71ff06786ac8c8db92891f566a (diff)
Core: Updated allowed build to 11.0.2.56819
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/master/2024_10_01_00_auth.sql23
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2024_10_01_00_auth.sql b/sql/updates/auth/master/2024_10_01_00_auth.sql
new file mode 100644
index 00000000000..5853468e2c7
--- /dev/null
+++ b/sql/updates/auth/master/2024_10_01_00_auth.sql
@@ -0,0 +1,23 @@
+DELETE FROM `build_info` WHERE `build` IN (56819);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(56819,11,0,2,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=56819 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=56819 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=56819 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=56819 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=56819 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=56819 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=56819 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(56819,'Mac','A64','WoW',0x1553CD215A62E2DC92CD61C4FB5DF9C3),
+(56819,'Mac','A64','WoWC',0x1B7EF05D342064F931E53264031E3497),
+(56819,'Mac','x64','WoW',0x9D5B7E1B5E59E54A3B96E5CCBA6EF465),
+(56819,'Mac','x64','WoWC',0x2BDCD952BAA47E6CBD71C780BC8CCD47),
+(56819,'Win','A64','WoW',0x7DC752479B560884B8289BC5B5C85F3F),
+(56819,'Win','x64','WoW',0x4373F45E9D617636332569671ED5D5E9),
+(56819,'Win','x64','WoWC',0xB9E422DF76DA635E193B75BD54ADD8DE);
+
+UPDATE `realmlist` SET `gamebuild`=56819 WHERE `gamebuild`=56647;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56819';