TDB 1102.24092 - 2024/09/23TDB1102.24092

6 files changed, 102 insertions, 0 deletions

diff --git a/sql/old/11.x/auth/24091_2024_09_23/2024_09_03_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_03_00_auth.sql
new file mode 100644
index 00000000000..f953e7436c4
--- /dev/null
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_03_00_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 1102.24091 auth
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/auth', 'ARCHIVED');
diff --git a/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_00_auth.sql
new file mode 100644
index 00000000000..5008d467ab1
--- /dev/null
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_00_auth.sql
@@ -0,0 +1,9 @@
+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/old/11.x/auth/24091_2024_09_23/2024_09_05_01_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_01_auth.sql
new file mode 100644
index 00000000000..d8db68e7325
--- /dev/null
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_05_01_auth.sql
@@ -0,0 +1,23 @@
+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/old/11.x/auth/24091_2024_09_23/2024_09_11_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_11_00_auth.sql
new file mode 100644
index 00000000000..c69af833d34
--- /dev/null
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_11_00_auth.sql
@@ -0,0 +1,23 @@
+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/old/11.x/auth/24091_2024_09_23/2024_09_18_00_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_00_auth.sql
new file mode 100644
index 00000000000..951d4b5ccc1
--- /dev/null
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_00_auth.sql
@@ -0,0 +1,23 @@
+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/old/11.x/auth/24091_2024_09_23/2024_09_18_01_auth.sql b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_01_auth.sql
new file mode 100644
index 00000000000..4df91310654
--- /dev/null
+++ b/sql/old/11.x/auth/24091_2024_09_23/2024_09_18_01_auth.sql
@@ -0,0 +1,21 @@
+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';