diff options
| author | TDB Release <tdb-release@build.bot> | 2025-05-11 10:44:50 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2025-05-11 10:44:50 +0000 |
| commit | aeb1cf905731fca78b462e10a10cdfaadfc85533 (patch) | |
| tree | 5ab1874737092afe016e4ad31989b9b8d0f96a34 /sql/updates/auth | |
| parent | 8e0be127399e82a5082a9e740054b7e9fda259bc (diff) | |
TDB 442.25051 - 2025/05/11TDB442.25051
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/cata_classic/2025_02_19_01_auth.sql | 17 | ||||
| -rw-r--r-- | sql/updates/auth/cata_classic/2025_02_20_00_auth.sql | 19 | ||||
| -rw-r--r-- | sql/updates/auth/cata_classic/2025_04_05_00_auth.sql | 29 | ||||
| -rw-r--r-- | sql/updates/auth/cata_classic/2025_04_06_00_auth.sql | 3 | ||||
| -rw-r--r-- | sql/updates/auth/cata_classic/2025_04_09_01_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/cata_classic/2025_05_11_00_auth.sql (renamed from sql/updates/auth/cata_classic/2025_02_13_00_auth.sql) | 2 |
6 files changed, 1 insertions, 92 deletions
diff --git a/sql/updates/auth/cata_classic/2025_02_19_01_auth.sql b/sql/updates/auth/cata_classic/2025_02_19_01_auth.sql deleted file mode 100644 index 07931000574..00000000000 --- a/sql/updates/auth/cata_classic/2025_02_19_01_auth.sql +++ /dev/null @@ -1,17 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (59185); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(59185,4,4,2,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=59185 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59185 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59185 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59185 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59185 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59185 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(59185,'Mac','A64','WoW',0x6CFE66A02B1B3BFC3244E545B6441A3C), -(59185,'Mac','A64','WoWC',0x457EF06E5D847ABAA1301BF46FEC8821), -(59185,'Mac','x64','WoWC',0x059271AD396A89DCB4D6C717003799F0), -(59185,'Win','A64','WoW',0x57E3FCEAE73BFAAEB3FCCE9E3F7653BA), -(59185,'Win','x64','WoW',0x60F053E069B404839B6F7DEE88F40C97), -(59185,'Win','x64','WoWC',0x291C3548C275691818AB78FB047A2F7D); diff --git a/sql/updates/auth/cata_classic/2025_02_20_00_auth.sql b/sql/updates/auth/cata_classic/2025_02_20_00_auth.sql deleted file mode 100644 index 7f9a968fa17..00000000000 --- a/sql/updates/auth/cata_classic/2025_02_20_00_auth.sql +++ /dev/null @@ -1,19 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (59297); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(59297,4,4,2,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=59297 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59297 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59297 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59297 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59297 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59297 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59297 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(59297,'Mac','A64','WoW',0xFE7894BCAFA58F624BC354291683E0F1), -(59297,'Mac','A64','WoWC',0x2D4A7F3417689BB8633DA25B426EC93A), -(59297,'Mac','x64','WoW',0xA8F1B170342E673FBD4F8EB5013E36E2), -(59297,'Mac','x64','WoWC',0xCC0FF87C541C2456F7FB7E1A8DA25855), -(59297,'Win','A64','WoW',0xA3C147112D0D20D267FDCED3F23B428E), -(59297,'Win','x64','WoW',0xA6BC4433D709D113DAC4643BC5B708D9), -(59297,'Win','x64','WoWC',0xC3BD68A0D95B54AD42A81F2612C7EA85); diff --git a/sql/updates/auth/cata_classic/2025_04_05_00_auth.sql b/sql/updates/auth/cata_classic/2025_04_05_00_auth.sql deleted file mode 100644 index bcc41ed03e0..00000000000 --- a/sql/updates/auth/cata_classic/2025_04_05_00_auth.sql +++ /dev/null @@ -1,29 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (59734,59962,60142); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(59734,4,4,2,NULL), -(59962,4,4,2,NULL), -(60142,4,4,2,NULL); - -DELETE FROM `build_auth_key` WHERE `build` IN (59734,59962,60142); -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(59734,'Mac','A64','WoW',0xF8901F0DC07E9F86245286DEEE31651B), -(59734,'Mac','A64','WoWC',0x7B3021F41A7E1DD250BD18C1B4E4D6D4), -(59734,'Mac','x64','WoW',0x5F4D1113B49A02EAF679D531FEB8D257), -(59734,'Mac','x64','WoWC',0x1E12109DB4203C7536B56CEEDEC08ABC), -(59734,'Win','A64','WoW',0xF5CA50B3A9DE84DE196710F90FE98D7E), -(59734,'Win','x64','WoW',0xCB0C97D34528D30595DE815C079E0077), -(59734,'Win','x64','WoWC',0x072944A1D6CC42B88F687E84D555CA90), -(59962,'Mac','A64','WoW',0x3CB2AC0DFDFA182176D4196755D2CFD3), -(59962,'Mac','A64','WoWC',0x5FF126190FCD2F391A06BF3C542CF6F4), -(59962,'Mac','x64','WoW',0x7ABDF5110102EE5B793F6667537B0BC7), -(59962,'Mac','x64','WoWC',0x5CD66B0981CD527E67470928A7712D2E), -(59962,'Win','A64','WoW',0x4EEBCB9671EE6F485FDEE47D28513233), -(59962,'Win','x64','WoW',0xC11C128E975164EBEE727A78ABDC17F9), -(59962,'Win','x64','WoWC',0x53DA9BCB02FEFC73AD96D6D16C64E4B4), -(60142,'Mac','A64','WoW',0x6D74A98252846F4E11179232F14958F0), -(60142,'Mac','A64','WoWC',0x8EA62AF2C93B2E25FDCD23A1FE0C57C2), -(60142,'Mac','x64','WoW',0xC6C7DFEB73EE8E859FC9DFA14890AFCC), -(60142,'Mac','x64','WoWC',0xDE356C2C40DB9DD6AF92A2F5E6F29F28), -(60142,'Win','A64','WoW',0x95F8B992F4D5E395B72437355B38410D), -(60142,'Win','x64','WoW',0x0CE9E3662F4758138EBF587F10554A35), -(60142,'Win','x64','WoWC',0x9EBB43722392643B85C1551CE747EF20); diff --git a/sql/updates/auth/cata_classic/2025_04_06_00_auth.sql b/sql/updates/auth/cata_classic/2025_04_06_00_auth.sql deleted file mode 100644 index a317fba72b4..00000000000 --- a/sql/updates/auth/cata_classic/2025_04_06_00_auth.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `realmlist` SET `gamebuild`=60142 WHERE `gamebuild`=59069; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '60142'; diff --git a/sql/updates/auth/cata_classic/2025_04_09_01_auth.sql b/sql/updates/auth/cata_classic/2025_04_09_01_auth.sql deleted file mode 100644 index 78e39395658..00000000000 --- a/sql/updates/auth/cata_classic/2025_04_09_01_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (60192); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(60192,4,4,2,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=60192 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=60192 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=60192 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=60192 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=60192 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=60192 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=60192 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(60192,'Mac','A64','WoW',0x5909246906AB38CBDAB76B805B32684F), -(60192,'Mac','A64','WoWC',0xCB12A6091F8811F63A63E751D9F91B60), -(60192,'Mac','x64','WoW',0x5AD4530C21977C9CF132353CA248367C), -(60192,'Mac','x64','WoWC',0xBD3205EC191FE1DE0E7A207EF459DE97), -(60192,'Win','A64','WoW',0xA6F329ED8EBC1B43E59997AFD82BD5C1), -(60192,'Win','x64','WoW',0x6987F36EEE27CBF05AF1D7841E77EE73), -(60192,'Win','x64','WoWC',0xDC9D44DF6087F92CFE81F3CF3DAF8615); - -UPDATE `realmlist` SET `gamebuild`=60192 WHERE `gamebuild`=60142; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '60192'; diff --git a/sql/updates/auth/cata_classic/2025_02_13_00_auth.sql b/sql/updates/auth/cata_classic/2025_05_11_00_auth.sql index c4b0c0180ac..cb4f95af0d5 100644 --- a/sql/updates/auth/cata_classic/2025_02_13_00_auth.sql +++ b/sql/updates/auth/cata_classic/2025_05_11_00_auth.sql @@ -1,3 +1,3 @@ --- TDB 441.25021 auth +-- TDB 442.25051 auth UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/4.4.x/auth', 'ARCHIVED'); |
