diff options
| -rw-r--r-- | sql/base/auth_database.sql | 13 | ||||
| -rw-r--r-- | sql/updates/auth/master/2024_08_30_01_auth.sql | 14 |
2 files changed, 24 insertions, 3 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index eed251f0f1e..66b25fe46a8 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -769,7 +769,11 @@ INSERT INTO `build_auth_key` VALUES (56311,'Mac','A64','WoW',0x412D3200715AAFDC0522DF031A941F0E), (56311,'Win','x64','WoW',0xAC6415575AEE4D32735FFAD0C57226B2), (56313,'Mac','A64','WoW',0xA83ED19EE659BC95CC322D1E49BDEDBB), -(56313,'Win','x64','WoW',0xEAF769009A9AD3B1AA0414E1C344074B); +(56313,'Win','x64','WoW',0xEAF769009A9AD3B1AA0414E1C344074B), +(56380,'Win','x64','WoW',0xD081784493233E2869933FCC01F1A3C1), +(56380,'Win','x64','WoWC',0x4FB3D72D89F5FF01DD7F4E028494A4E6), +(56382,'Win','x64','WoW',0x67C36A3EF655534C58AD50942192BFDA), +(56382,'Win','x64','WoWC',0xA5BD7A1C33039F58CD45CD5C7EBDF122); /*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */; UNLOCK TABLES; @@ -1111,7 +1115,9 @@ INSERT INTO `build_info` VALUES (56263,11,0,2,NULL), (56288,11,0,2,NULL), (56311,11,0,2,NULL), -(56313,11,0,2,NULL); +(56313,11,0,2,NULL), +(56380,11,0,2,NULL), +(56382,11,0,2,NULL); /*!40000 ALTER TABLE `build_info` ENABLE KEYS */; UNLOCK TABLES; @@ -3186,7 +3192,8 @@ INSERT INTO `updates` VALUES ('2024_08_24_00_auth.sql','6D2CE419F8E8512051B63D0F68B30BAA769F9D4A','RELEASED','2024-08-24 10:23:33',0), ('2024_08_28_00_auth.sql','F39CA1C18CAC207418C3D3703DA0F038471D308A','RELEASED','2024-08-28 10:50:31',0), ('2024_08_28_01_auth.sql','BC5D74553AF2D92606F55C1C462D2700FE73BD34','RELEASED','2024-08-28 14:55:05',0), -('2024_08_30_00_auth.sql','BD76942F1C29AAA2450E051E7CA552672B5E331B','RELEASED','2024-08-30 19:24:30',0); +('2024_08_30_00_auth.sql','BD76942F1C29AAA2450E051E7CA552672B5E331B','RELEASED','2024-08-30 19:24:30',0), +('2024_08_30_01_auth.sql','0AAC95A9216114177AF0A3A7DE664D061FED21EA','RELEASED','2024-08-30 22:23:08',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2024_08_30_01_auth.sql b/sql/updates/auth/master/2024_08_30_01_auth.sql new file mode 100644 index 00000000000..59e78161528 --- /dev/null +++ b/sql/updates/auth/master/2024_08_30_01_auth.sql @@ -0,0 +1,14 @@ +DELETE FROM `build_info` WHERE `build` IN (56380,56382); +INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES +(56380,11,0,2,NULL), +(56382,11,0,2,NULL); + +DELETE FROM `build_auth_key` WHERE `build`=56380 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=56380 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; +DELETE FROM `build_auth_key` WHERE `build`=56382 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; +DELETE FROM `build_auth_key` WHERE `build`=56382 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; +INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES +(56380,'Win','x64','WoW',0xD081784493233E2869933FCC01F1A3C1), +(56380,'Win','x64','WoWC',0x4FB3D72D89F5FF01DD7F4E028494A4E6), +(56382,'Win','x64','WoW',0x67C36A3EF655534C58AD50942192BFDA), +(56382,'Win','x64','WoWC',0xA5BD7A1C33039F58CD45CD5C7EBDF122); |