TDB 1102.24092 - 2024/09/23TDB1102.24092

6 files changed, 1 insertions, 100 deletions

diff --git a/sql/updates/auth/master/2024_09_05_00_auth.sql b/sql/updates/auth/master/2024_09_05_00_auth.sql
deleted file mode 100644
index 5008d467ab1..00000000000
--- a/sql/updates/auth/master/2024_09_05_00_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(56421,'Mac','A64','WoWC',0x629666D6D9EFFE4B73C1EDD74638DEAA),
-(56421,'Mac','x64','WoWC',0x4B61E4F4F3B220FF5B48A6988F0FFB42),
-(56421,'Mac','x64','WoW',0x4F0FCD1113F783C484BF45C98327DE62),
-(56421,'Win','A64','WoW',0x178888C71560707CC9C1C1D6B45B4838);
diff --git a/sql/updates/auth/master/2024_09_05_01_auth.sql b/sql/updates/auth/master/2024_09_05_01_auth.sql
deleted file mode 100644
index d8db68e7325..00000000000
--- a/sql/updates/auth/master/2024_09_05_01_auth.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (56461);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(56461,11,0,2,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(56461,'Mac','A64','WoW',0xE51FE6EAE45322991916F619481DB0B1),
-(56461,'Mac','A64','WoWC',0x85447CD695C2DC2F618B23996B4A503C),
-(56461,'Mac','x64','WoW',0xE26878DF3437782F6E93E833B4CD843A),
-(56461,'Mac','x64','WoWC',0x8B60B0DDD55907673FD1C11EDAE58859),
-(56461,'Win','A64','WoW',0x2F862AB724092B99C8A1F6A7B53F6A9D),
-(56461,'Win','x64','WoW',0x153CD89E30C4D5C3DBE603EECB470FB4),
-(56461,'Win','x64','WoWC',0x79BD4C88012F0DA42605D76A153722CC);
-
-UPDATE `realmlist` SET `gamebuild`=56461 WHERE `gamebuild`=56421;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56461';
diff --git a/sql/updates/auth/master/2024_09_11_00_auth.sql b/sql/updates/auth/master/2024_09_11_00_auth.sql
deleted file mode 100644
index c69af833d34..00000000000
--- a/sql/updates/auth/master/2024_09_11_00_auth.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (56513);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(56513,11,0,2,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(56513,'Mac','A64','WoW',0xC7E757E0DE67619251F942B6C98A53B7),
-(56513,'Mac','A64','WoWC',0x3CC0640E46D557C4D9A6250AA8D5B387),
-(56513,'Mac','x64','WoW',0xD1443824E37B73CB1FD993CE2DFAA098),
-(56513,'Mac','x64','WoWC',0xEAD9A0B761C4C9C812FAD54CE0D96B46),
-(56513,'Win','A64','WoW',0x753468F753E8D3841B5D6B061E300501),
-(56513,'Win','x64','WoW',0x9BD8D105049CC6459FE32EC7099AB60E),
-(56513,'Win','x64','WoWC',0xBB5A35C2EB6E2026FFE01202FDEBD6E9);
-
-UPDATE `realmlist` SET `gamebuild`=56513 WHERE `gamebuild`=56461;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56513';
diff --git a/sql/updates/auth/master/2024_09_18_00_auth.sql b/sql/updates/auth/master/2024_09_18_00_auth.sql
deleted file mode 100644
index 951d4b5ccc1..00000000000
--- a/sql/updates/auth/master/2024_09_18_00_auth.sql
+++ /dev/null
@@ -1,23 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (56625);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(56625,11,0,2,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(56625,'Mac','A64','WoW',0xC7AD97B9970260D0BDE7AA03EEF87E2D),
-(56625,'Mac','A64','WoWC',0xDEBDB4589756730F5EF60B337226E515),
-(56625,'Mac','x64','WoW',0xEB5665FDC81E3538944BA82E435A53E6),
-(56625,'Mac','x64','WoWC',0xAA5B3910A3D13C89F3D9467058080836),
-(56625,'Win','A64','WoW',0x684153873E5023671685B270DA879668),
-(56625,'Win','x64','WoW',0x80859C23C3E7F827829D47A08A1B8C92),
-(56625,'Win','x64','WoWC',0x606914ED212277FDDBBAE49BE6E8CCAF);
-
-UPDATE `realmlist` SET `gamebuild`=56625 WHERE `gamebuild`=56513;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56625';
diff --git a/sql/updates/auth/master/2024_09_18_01_auth.sql b/sql/updates/auth/master/2024_09_18_01_auth.sql
deleted file mode 100644
index 4df91310654..00000000000
--- a/sql/updates/auth/master/2024_09_18_01_auth.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (56647);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(56647,11,0,2,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
-DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(56647,'Mac','A64','WoW',0x1911B50FA20E5DEF8C1E5D3C7479E4E2),
-(56647,'Mac','A64','WoWC',0xF0F2BEC3DE590AE7A59CCFDB42201D5F),
-(56647,'Mac','x64','WoW',0x022A06825C7CF55528A5ED03E87D6AE4),
-(56647,'Win','A64','WoW',0x0F36C48D68E358598318F0B30FDFCB61),
-(56647,'Win','x64','WoW',0x2E9C456B66C0D5CAD601E8FD7A2FEA7A),
-(56647,'Win','x64','WoWC',0x543A69AB802D0873D84AB08DEC4D8CAC);
-
-UPDATE `realmlist` SET `gamebuild`=56647 WHERE `gamebuild`=56625;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56647';
diff --git a/sql/updates/auth/master/2024_09_03_00_auth.sql b/sql/updates/auth/master/2024_09_23_00_auth.sql
index f953e7436c4..c4d4e867cdd 100644
--- a/sql/updates/auth/master/2024_09_03_00_auth.sql
+++ b/sql/updates/auth/master/2024_09_23_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 1102.24091 auth
+-- TDB 1102.24092 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/auth', 'ARCHIVED');