aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2025-05-11 10:44:50 +0000
committerTDB Release <tdb-release@build.bot>2025-05-11 10:44:50 +0000
commitaeb1cf905731fca78b462e10a10cdfaadfc85533 (patch)
tree5ab1874737092afe016e4ad31989b9b8d0f96a34 /sql/updates/auth
parent8e0be127399e82a5082a9e740054b7e9fda259bc (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.sql17
-rw-r--r--sql/updates/auth/cata_classic/2025_02_20_00_auth.sql19
-rw-r--r--sql/updates/auth/cata_classic/2025_04_05_00_auth.sql29
-rw-r--r--sql/updates/auth/cata_classic/2025_04_06_00_auth.sql3
-rw-r--r--sql/updates/auth/cata_classic/2025_04_09_01_auth.sql23
-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');