diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/master/2024_12_18_00_auth.sql | 38 | ||||
| -rw-r--r-- | sql/updates/hotfixes/master/2024_12_18_00_hotfixes.sql | 16 |
2 files changed, 54 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2024_12_18_00_auth.sql b/sql/updates/auth/master/2024_12_18_00_auth.sql new file mode 100644 index 00000000000..510444839aa --- /dev/null +++ b/sql/updates/auth/master/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/updates/hotfixes/master/2024_12_18_00_hotfixes.sql b/sql/updates/hotfixes/master/2024_12_18_00_hotfixes.sql new file mode 100644 index 00000000000..5a18de9e7b1 --- /dev/null +++ b/sql/updates/hotfixes/master/2024_12_18_00_hotfixes.sql @@ -0,0 +1,16 @@ +ALTER TABLE `broadcast_text` MODIFY `Flags` smallint UNSIGNED NOT NULL DEFAULT 0 AFTER `EmotesID`; + +ALTER TABLE `lfg_dungeons` + ADD `MaxPremadeCountTank` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `MinCountDamage`, + ADD `MaxPremadeCountHealer` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `MaxPremadeCountTank`, + ADD `MaxPremadeCountDamage` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `MaxPremadeCountHealer`; + +ALTER TABLE `map_difficulty` MODIFY `ID` int UNSIGNED NOT NULL DEFAULT 0 AFTER `Message`; + +ALTER TABLE `player_condition` + ADD `MinLevel` smallint UNSIGNED NOT NULL DEFAULT 0 AFTER `FailureDescription`, + ADD `MaxLevel` smallint UNSIGNED NOT NULL DEFAULT 0 AFTER `MinLevel`; + +ALTER TABLE `vignette` + ADD `UiMapPinInfoID` int NOT NULL DEFAULT 0 AFTER `UiWidgetSetID`, + ADD `ObjectiveType` tinyint NOT NULL DEFAULT 0 AFTER `UiMapPinInfoID`; |