TDB 1107.24121 - 2024/12/22TDB1107.24121

5 files changed, 1 insertions, 123 deletions

diff --git a/sql/updates/auth/master/2024_11_20_00_auth.sql b/sql/updates/auth/master/2024_11_20_00_auth.sql
deleted file mode 100644
index 886c8a7313a..00000000000
--- a/sql/updates/auth/master/2024_11_20_00_auth.sql
+++ /dev/null
@@ -1,38 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (57637,57689);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(57637,11,0,5,NULL),
-(57689,11,0,5,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=57637 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57637 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=57637 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57637 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=57637 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57637 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57637 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=57689 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57689 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=57689 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57689 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=57689 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57689 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57689 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(57637,'Mac','A64','WoW',0x25DB682BB3B56D01B3780C446811956E),
-(57637,'Mac','A64','WoWC',0x722FCA435AE1E916A4D96EDF8DDCFB3B),
-(57637,'Mac','x64','WoW',0xCBB255E59E1031F8CBEB098D26B8E2FA),
-(57637,'Mac','x64','WoWC',0x8DA67ECB7268B7FE759CE94F13165B32),
-(57637,'Win','A64','WoW',0x4B39C74A7035B6A1C799F0F4FC6735D2),
-(57637,'Win','x64','WoW',0x6C4185E973C9CB8382D3721AF1060C66),
-(57637,'Win','x64','WoWC',0x71B57F027872393C902BDCBBDDC43A26),
-(57689,'Mac','A64','WoW',0x5D064F1364C285F07FF804DCE98A6CC5),
-(57689,'Mac','A64','WoWC',0xAB3DF8B79F5BAE839764988EE6530101),
-(57689,'Mac','x64','WoW',0x988459790B4B38301350BE4286F979A2),
-(57689,'Mac','x64','WoWC',0xCA7AD91741F8E2063CE227D475247212),
-(57689,'Win','A64','WoW',0x4910E2142A21616934CD4D714691748C),
-(57689,'Win','x64','WoW',0x93B4E50E651A28D8CC4E7CE7447901F6),
-(57689,'Win','x64','WoWC',0x6AEDD8258D4E9701F737CBA852728A74);
-
-UPDATE `realmlist` SET `gamebuild`=57689 WHERE `gamebuild` IN (57534,57637);
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '57689';
diff --git a/sql/updates/auth/master/2024_12_18_00_auth.sql b/sql/updates/auth/master/2024_12_18_00_auth.sql
deleted file mode 100644
index 510444839aa..00000000000
--- a/sql/updates/auth/master/2024_12_18_00_auth.sql
+++ /dev/null
@@ -1,38 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (58123,58162);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(58123,11,0,7,NULL),
-(58162,11,0,7,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=58123 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58123 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=58123 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58123 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=58123 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58123 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58123 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=58162 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58162 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=58162 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58162 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=58162 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58162 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58162 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(58123,'Mac','A64','WoW',0x7C63CE8A068940D4D019C7CF999E3DC7),
-(58123,'Mac','A64','WoWC',0xCF2625300DA905CC9B6D10379C58B590),
-(58123,'Mac','x64','WoW',0x1B68981860A6EB24BEAA070FD022B3B9),
-(58123,'Mac','x64','WoWC',0x3037FB1C6A73F7468DD11180000BB133),
-(58123,'Win','A64','WoW',0x84B75C8F0FF380C3B3970EB63AFB4962),
-(58123,'Win','x64','WoW',0x29050AA0D62EF99634CCB7B5F9F6AC1E),
-(58123,'Win','x64','WoWC',0x2D5EEEAB57AFFE31856D0DEAC73944DA),
-(58162,'Mac','A64','WoW',0x086BB93AF9122791E6CDA58A5F20AAC1),
-(58162,'Mac','A64','WoWC',0x280BD3A4F223E1D8F3CF893BBFAEFBC5),
-(58162,'Mac','x64','WoW',0x47586B32BD556FA08C966D7F4FC9FF24),
-(58162,'Mac','x64','WoWC',0xE861315673972C1B986650C1242196FE),
-(58162,'Win','A64','WoW',0x5B1F97D43762F0F1BEC75E99CDD18D35),
-(58162,'Win','x64','WoW',0xDA3B48B9A60F4486F27BA9D8858D5688),
-(58162,'Win','x64','WoWC',0x25146ED771DC629F2B8CF58126BA562C);
-
-UPDATE `realmlist` SET `gamebuild`=58162 WHERE `gamebuild` IN (57689,58123);
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58162';
diff --git a/sql/updates/auth/master/2024_12_19_00_auth.sql b/sql/updates/auth/master/2024_12_19_00_auth.sql
deleted file mode 100644
index baace5a1f1c..00000000000
--- a/sql/updates/auth/master/2024_12_19_00_auth.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (58187);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(58187,11,0,7,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=58187 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58187 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=58187 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58187 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=58187 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58187 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=58187 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(58187,'Mac','A64','WoW',0x88D993926D777DC12059988E009A73D6),
-(58187,'Mac','A64','WoWC',0x9E794FD5CD76EFF400837338876BA64F),
-(58187,'Mac','x64','WoW',0xDE1377202943C1155607090CF884FF66),
-(58187,'Mac','x64','WoWC',0xE7777DCE18DB45B7ED3E7ADF23BCB1CB),
-(58187,'Win','A64','WoW',0xFFEAC8B1B547FD10EFCA8BCF30DF9F51),
-(58187,'Win','x64','WoW',0xD92C35D6904B0945992B0801E53822E7),
-(58187,'Win','x64','WoWC',0x8AC21CC640359F276C2F6153FAA28638);
-
-UPDATE `realmlist` SET `gamebuild`=58187 WHERE `gamebuild`=58162;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58187';
diff --git a/sql/updates/auth/master/2024_12_21_00_auth.sql b/sql/updates/auth/master/2024_12_21_00_auth.sql
deleted file mode 100644
index cf04c9bc407..00000000000
--- a/sql/updates/auth/master/2024_12_21_00_auth.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-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';
diff --git a/sql/updates/auth/master/2024_11_16_00_auth.sql b/sql/updates/auth/master/2024_12_22_00_auth.sql
index 7f039313880..a43db5fca0b 100644
--- a/sql/updates/auth/master/2024_11_16_00_auth.sql
+++ b/sql/updates/auth/master/2024_12_22_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 1105.24111 auth
+-- TDB 1107.24121 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/auth', 'ARCHIVED');