diff options
Diffstat (limited to 'sql/old/11.x/auth')
5 files changed, 125 insertions, 0 deletions
diff --git a/sql/old/11.x/auth/24111_2024_12_22/2024_11_16_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_11_16_00_auth.sql new file mode 100644 index 00000000000..7f039313880 --- /dev/null +++ b/sql/old/11.x/auth/24111_2024_12_22/2024_11_16_00_auth.sql @@ -0,0 +1,3 @@ +-- TDB 1105.24111 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/24111_2024_12_22/2024_11_20_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_11_20_00_auth.sql new file mode 100644 index 00000000000..886c8a7313a --- /dev/null +++ b/sql/old/11.x/auth/24111_2024_12_22/2024_11_20_00_auth.sql @@ -0,0 +1,38 @@ +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/old/11.x/auth/24111_2024_12_22/2024_12_18_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_12_18_00_auth.sql new file mode 100644 index 00000000000..510444839aa --- /dev/null +++ b/sql/old/11.x/auth/24111_2024_12_22/2024_12_18_00_auth.sql @@ -0,0 +1,38 @@ +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/old/11.x/auth/24111_2024_12_22/2024_12_19_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_12_19_00_auth.sql new file mode 100644 index 00000000000..baace5a1f1c --- /dev/null +++ b/sql/old/11.x/auth/24111_2024_12_22/2024_12_19_00_auth.sql @@ -0,0 +1,23 @@ +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/old/11.x/auth/24111_2024_12_22/2024_12_21_00_auth.sql b/sql/old/11.x/auth/24111_2024_12_22/2024_12_21_00_auth.sql new file mode 100644 index 00000000000..cf04c9bc407 --- /dev/null +++ b/sql/old/11.x/auth/24111_2024_12_22/2024_12_21_00_auth.sql @@ -0,0 +1,23 @@ +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'; |