Core: Updated to 11.2.7HEADmaster

4 files changed, 78 insertions, 5 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 51904bee814..ec826ba5218 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1355,7 +1355,14 @@ INSERT INTO `build_auth_key` VALUES
 (64502,'Mac','x64','WoWC',0x6DCE3BA9C0ACF638AE599680200483AE),
 (64502,'Win','A64','WoW',0x51DF09ABE30D38142EB5942ED774301B),
 (64502,'Win','x64','WoW',0x54D307CF2BC84E50E94C2D3A95CD6D7B),
-(64502,'Win','x64','WoWC',0xA968CFA8B0558F433B3E483E844FBFC3);
+(64502,'Win','x64','WoWC',0xA968CFA8B0558F433B3E483E844FBFC3),
+(64877,'Mac','A64','WoW',0xB903471C43EBDC5BABF6FB604A3A5E69),
+(64877,'Mac','A64','WoWC',0x3DFEDC25E9BDF2C8C30E0E3F0F6EB6D4),
+(64877,'Mac','x64','WoW',0x98464DDFFC9A5786DA1F053EA520BA32),
+(64877,'Mac','x64','WoWC',0x01003F46907A168B2BDF036575802098),
+(64877,'Win','A64','WoW',0x026ED07009997B857BB37DCBB5B11477),
+(64877,'Win','x64','WoW',0x6AB7C89863A9D6CDA9C0FAE710FEB126),
+(64877,'Win','x64','WoWC',0xBD52F0D3F7C92642185E963CEA424BD3);
 /*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -1772,7 +1779,8 @@ INSERT INTO `build_info` VALUES
 (64270,11,2,5,NULL),
 (64395,11,2,5,NULL),
 (64484,11,2,5,NULL),
-(64502,11,2,5,NULL);
+(64502,11,2,5,NULL),
+(64877,11,2,7,NULL);
 /*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3385,7 +3393,7 @@ CREATE TABLE `realmlist` (
   `timezone` tinyint unsigned NOT NULL DEFAULT '0',
   `allowedSecurityLevel` tinyint unsigned NOT NULL DEFAULT '0',
   `population` float NOT NULL DEFAULT '0',
-  `gamebuild` int unsigned NOT NULL DEFAULT '64502',
+  `gamebuild` int unsigned NOT NULL DEFAULT '64877',
   `Region` tinyint unsigned NOT NULL DEFAULT '1',
   `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
   PRIMARY KEY (`id`),
@@ -3400,7 +3408,7 @@ CREATE TABLE `realmlist` (
 LOCK TABLES `realmlist` WRITE;
 /*!40000 ALTER TABLE `realmlist` DISABLE KEYS */;
 INSERT INTO `realmlist` VALUES
-(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,64502,1,1);
+(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,64877,1,1);
 /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3930,7 +3938,8 @@ INSERT INTO `updates` VALUES
 ('2025_11_07_00_auth.sql','496BAF87666950FDBA459CC72472AAB4CBD71D40','RELEASED','2025-11-07 09:46:17',0),
 ('2025_11_15_00_auth.sql','744E145E7EFBADDAF0BAC00F6FC84A1FE79EDFCA','RELEASED','2025-11-15 12:09:00',0),
 ('2025_11_18_00_auth.sql','AAE3FEB4363A16253C7ADF8CF5973E3694C5BC52','RELEASED','2025-11-18 20:09:47',0),
-('2025_11_19_00_auth.sql','2E89C66714539C9713B9ADD3F7697730A426C795','RELEASED','2025-11-19 08:20:00',0);
+('2025_11_19_00_auth.sql','2E89C66714539C9713B9ADD3F7697730A426C795','RELEASED','2025-11-19 08:20:00',0),
+('2025_12_15_00_auth.sql','CA8ADF39030282B3D2627C15E751CC1D81618BAE','RELEASED','2025-12-15 15:39:58',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/auth/master/2025_12_15_00_auth.sql b/sql/updates/auth/master/2025_12_15_00_auth.sql
new file mode 100644
index 00000000000..4493eac6680
--- /dev/null
+++ b/sql/updates/auth/master/2025_12_15_00_auth.sql
@@ -0,0 +1,23 @@
+DELETE FROM `build_info` WHERE `build` IN (64877);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(64877,11,2,7,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=64877 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64877 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=64877 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64877 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=64877 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64877 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=64877 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(64877,'Mac','A64','WoW',0xB903471C43EBDC5BABF6FB604A3A5E69),
+(64877,'Mac','A64','WoWC',0x3DFEDC25E9BDF2C8C30E0E3F0F6EB6D4),
+(64877,'Mac','x64','WoW',0x98464DDFFC9A5786DA1F053EA520BA32),
+(64877,'Mac','x64','WoWC',0x01003F46907A168B2BDF036575802098),
+(64877,'Win','A64','WoW',0x026ED07009997B857BB37DCBB5B11477),
+(64877,'Win','x64','WoW',0x6AB7C89863A9D6CDA9C0FAE710FEB126),
+(64877,'Win','x64','WoWC',0xBD52F0D3F7C92642185E963CEA424BD3);
+
+UPDATE `realmlist` SET `gamebuild`=64877 WHERE `gamebuild`=64502;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '64877';
diff --git a/sql/updates/hotfixes/master/2025_12_15_00_hotfixes.sql b/sql/updates/hotfixes/master/2025_12_15_00_hotfixes.sql
new file mode 100644
index 00000000000..d91f871303f
--- /dev/null
+++ b/sql/updates/hotfixes/master/2025_12_15_00_hotfixes.sql
@@ -0,0 +1,17 @@
+ALTER TABLE `conditional_content_tuning` ADD COLUMN `RedirectEnum` int NOT NULL DEFAULT 0 AFTER `RedirectFlag`;
+
+ALTER TABLE `gossip_npc_option` ADD COLUMN `NeighborhoodMapID` int NOT NULL DEFAULT 0 AFTER `Unknown_1002_14`;
+
+ALTER TABLE `item` ADD COLUMN `Unknown1127` int NOT NULL DEFAULT 0 AFTER `CraftingQualityID`;
+
+ALTER TABLE `item_effect` ADD COLUMN `PlayerConditionID` int NOT NULL DEFAULT 0 AFTER `ChrSpecializationID`;
+
+ALTER TABLE `item_scaling_config` ADD COLUMN `Flags` int NOT NULL DEFAULT 0 AFTER `Unknown1125`;
+
+ALTER TABLE `item_sparse` ADD COLUMN `Unknown1127` int NOT NULL DEFAULT 0 AFTER `ItemLevelOffsetItemLevel`;
+
+ALTER TABLE `map_challenge_mode` ADD COLUMN `MaxMedals` int NOT NULL DEFAULT 0 AFTER `Flags`;
+ALTER TABLE `map_challenge_mode` ADD COLUMN `CriteriaCount4` smallint NOT NULL DEFAULT 0 AFTER `CriteriaCount3`;
+ALTER TABLE `map_challenge_mode` ADD COLUMN `CriteriaCount5` smallint NOT NULL DEFAULT 0 AFTER `CriteriaCount4`;
+
+ALTER TABLE `spell_visual` ADD COLUMN `StateKit` int NOT NULL DEFAULT 0 AFTER `MissileImpactOffset3`;
diff --git a/sql/updates/world/master/2025_12_15_00_world.sql b/sql/updates/world/master/2025_12_15_00_world.sql
new file mode 100644
index 00000000000..ffb348fc854
--- /dev/null
+++ b/sql/updates/world/master/2025_12_15_00_world.sql
@@ -0,0 +1,24 @@
+ALTER TABLE `gameobject_template` ADD `RequiredLevel` int NOT NULL DEFAULT 0 AFTER `ContentTuningId`;
+
+ALTER TABLE `quest_objectives`
+  ADD `SecondaryAmount` int NOT NULL DEFAULT 0 AFTER `Amount`,
+  ADD `ParentObjectiveID` int NOT NULL DEFAULT 0 AFTER `ProgressBarWeight`,
+  ADD `Visible` tinyint(1) unsigned NOT NULL DEFAULT 1 AFTER `ParentObjectiveID`;
+
+DROP TABLE IF EXISTS `quest_reward_house_room`;
+CREATE TABLE `quest_reward_house_room` (
+  `QuestID` int unsigned NOT NULL,
+  `OrderIndex` int NOT NULL,
+  `HouseRoomID` int NOT NULL,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestID`,`OrderIndex`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+DROP TABLE IF EXISTS `quest_reward_house_decor`;
+CREATE TABLE `quest_reward_house_decor` (
+  `QuestID` int unsigned NOT NULL,
+  `OrderIndex` int NOT NULL,
+  `HouseDecorID` int NOT NULL,
+  `VerifiedBuild` int NOT NULL DEFAULT '0',
+  PRIMARY KEY (`QuestID`,`OrderIndex`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;