aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql35
-rw-r--r--sql/updates/auth/master/2025_03_02_00_auth.sql33
-rw-r--r--sql/updates/hotfixes/master/2025_03_02_00_hotfixes.sql83
-rw-r--r--sql/updates/world/master/2025_03_02_00_world.sql4
4 files changed, 150 insertions, 5 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index ae3af315ffd..c5ed2317da0 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -953,7 +953,28 @@ INSERT INTO `build_auth_key` VALUES
(59302,'Mac','x64','WoWC',0xD39B478EFD342D568DCBC2E85FCA574D),
(59302,'Win','A64','WoW',0x60B1757CA707789C9ACD6F1FB69E28D5),
(59302,'Win','x64','WoW',0x330E4E7EF1E07DA8382C813650D7E7B5),
-(59302,'Win','x64','WoWC',0xB5A0C54F6B334515E68260F6334E7593);
+(59302,'Win','x64','WoWC',0xB5A0C54F6B334515E68260F6334E7593),
+(59347,'Mac','A64','WoW',0xC7B81BB6F9207DA0CCEBFAC3186FC073),
+(59347,'Mac','A64','WoWC',0xBAB986A50C7FDB89467AA5613A6BA345),
+(59347,'Mac','x64','WoW',0x1A11343133BF1ABDBF0FF6B287B37C23),
+(59347,'Mac','x64','WoWC',0x3A624C37EE150CC9B71CA3AD1F4532CF),
+(59347,'Win','A64','WoW',0x80CAC49F6EA99AC68CA9B834466CA5DC),
+(59347,'Win','x64','WoW',0x63228339538F9552D16855976C64848B),
+(59347,'Win','x64','WoWC',0xBB45FAC562EB7CF3FC4C137C1AE93AF6),
+(59425,'Mac','A64','WoW',0x14A01BEF9E9DB7C5A40438CE87E99B85),
+(59425,'Mac','A64','WoWC',0x38B98DA1F8765C927C724CFE4E1D92C2),
+(59425,'Mac','x64','WoW',0x9D230A7C010BA2E5B385CB4E24A59529),
+(59425,'Mac','x64','WoWC',0xB0BF826891290E30173DCA5CF2B39F50),
+(59425,'Win','A64','WoW',0xF40FED2615A2454E31B044B1AD564B7D),
+(59425,'Win','x64','WoW',0x5FE3E3980A15A1D4ED64240BC0C6932D),
+(59425,'Win','x64','WoWC',0xECA5DA344AF973B0D25AC1103FB694B8),
+(59466,'Mac','A64','WoW',0xF6CB8EB7AB66F8909ADCA85052BFAE40),
+(59466,'Mac','A64','WoWC',0x213104EC1BEF7656FC3930DCE4176184),
+(59466,'Mac','x64','WoW',0x99075D27FF98A87368A08E87A3F105C3),
+(59466,'Mac','x64','WoWC',0x516115232E1A8B3F1E3CA709F20EA84D),
+(59466,'Win','A64','WoW',0x04F0986C0EAD648F8C7B27736A30088A),
+(59466,'Win','x64','WoW',0x118FFD674F5B51C277F5C8505E9479D3),
+(59466,'Win','x64','WoWC',0xC299CB416E332E4BBE5AA1AAE905A437);
/*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1323,7 +1344,10 @@ INSERT INTO `build_info` VALUES
(58867,11,0,7,NULL),
(58911,11,0,7,NULL),
(59207,11,0,7,NULL),
-(59302,11,0,7,NULL);
+(59302,11,0,7,NULL),
+(59347,11,1,0,NULL),
+(59425,11,1,0,NULL),
+(59466,11,1,0,NULL);
/*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2935,7 +2959,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 '59302',
+ `gamebuild` int unsigned NOT NULL DEFAULT '59466',
`Region` tinyint unsigned NOT NULL DEFAULT '1',
`Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
@@ -2950,7 +2974,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,59302,1,1);
+(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,59466,1,1);
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3434,7 +3458,8 @@ INSERT INTO `updates` VALUES
('2025_01_31_00_auth.sql','DF2640D25C15E41358C1ED46B4F86043583FC8FB','RELEASED','2025-01-31 11:51:23',0),
('2025_02_03_00_auth.sql','87033116EF72051499AF23FE14545D828F5A9B59','RELEASED','2025-02-03 22:51:31',0),
('2025_02_19_00_auth.sql','6D0EBB3E2DD1B26682A424EDDC090F515BCA5B32','RELEASED','2025-02-19 00:16:52',0),
-('2025_02_21_00_auth.sql','E9EA49CEB396561D641A7C82251DCBF9DF3E9983','RELEASED','2025-02-21 00:53:17',0);
+('2025_02_21_00_auth.sql','E9EA49CEB396561D641A7C82251DCBF9DF3E9983','RELEASED','2025-02-21 00:53:17',0),
+('2025_03_02_00_auth.sql','1CEAB7B308823D5FAA51360A1B2A7CA0E89A6081','RELEASED','2025-03-02 14:50:10',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/updates/auth/master/2025_03_02_00_auth.sql b/sql/updates/auth/master/2025_03_02_00_auth.sql
new file mode 100644
index 00000000000..0ebf84c7a8f
--- /dev/null
+++ b/sql/updates/auth/master/2025_03_02_00_auth.sql
@@ -0,0 +1,33 @@
+DELETE FROM `build_info` WHERE `build` IN (59347,59425,59466);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(59347,11,1,0,NULL),
+(59425,11,1,0,NULL),
+(59466,11,1,0,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build` IN (59347,59425,59466);
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(59347,'Mac','A64','WoW',0xC7B81BB6F9207DA0CCEBFAC3186FC073),
+(59347,'Mac','A64','WoWC',0xBAB986A50C7FDB89467AA5613A6BA345),
+(59347,'Mac','x64','WoW',0x1A11343133BF1ABDBF0FF6B287B37C23),
+(59347,'Mac','x64','WoWC',0x3A624C37EE150CC9B71CA3AD1F4532CF),
+(59347,'Win','A64','WoW',0x80CAC49F6EA99AC68CA9B834466CA5DC),
+(59347,'Win','x64','WoW',0x63228339538F9552D16855976C64848B),
+(59347,'Win','x64','WoWC',0xBB45FAC562EB7CF3FC4C137C1AE93AF6),
+(59425,'Mac','A64','WoW',0x14A01BEF9E9DB7C5A40438CE87E99B85),
+(59425,'Mac','A64','WoWC',0x38B98DA1F8765C927C724CFE4E1D92C2),
+(59425,'Mac','x64','WoW',0x9D230A7C010BA2E5B385CB4E24A59529),
+(59425,'Mac','x64','WoWC',0xB0BF826891290E30173DCA5CF2B39F50),
+(59425,'Win','A64','WoW',0xF40FED2615A2454E31B044B1AD564B7D),
+(59425,'Win','x64','WoW',0x5FE3E3980A15A1D4ED64240BC0C6932D),
+(59425,'Win','x64','WoWC',0xECA5DA344AF973B0D25AC1103FB694B8),
+(59466,'Mac','A64','WoW',0xF6CB8EB7AB66F8909ADCA85052BFAE40),
+(59466,'Mac','A64','WoWC',0x213104EC1BEF7656FC3930DCE4176184),
+(59466,'Mac','x64','WoW',0x99075D27FF98A87368A08E87A3F105C3),
+(59466,'Mac','x64','WoWC',0x516115232E1A8B3F1E3CA709F20EA84D),
+(59466,'Win','A64','WoW',0x04F0986C0EAD648F8C7B27736A30088A),
+(59466,'Win','x64','WoW',0x118FFD674F5B51C277F5C8505E9479D3),
+(59466,'Win','x64','WoWC',0xC299CB416E332E4BBE5AA1AAE905A437);
+
+UPDATE `realmlist` SET `gamebuild`=59466 WHERE `gamebuild` IN (59302,59347,59425);
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '59466';
diff --git a/sql/updates/hotfixes/master/2025_03_02_00_hotfixes.sql b/sql/updates/hotfixes/master/2025_03_02_00_hotfixes.sql
new file mode 100644
index 00000000000..e4accafe631
--- /dev/null
+++ b/sql/updates/hotfixes/master/2025_03_02_00_hotfixes.sql
@@ -0,0 +1,83 @@
+ALTER TABLE `azerite_power_set_member` MODIFY `Class` tinyint NOT NULL DEFAULT 0 AFTER `AzeritePowerID`;
+
+ALTER TABLE `barber_shop_style`
+ MODIFY `Race` tinyint NOT NULL DEFAULT 0 AFTER `CostModifier`,
+ MODIFY `Sex` tinyint NOT NULL DEFAULT 0 AFTER `Race`;
+
+ALTER TABLE `challenge_mode_item_bonus_override` ADD `RequiredTimeEventNotPassed` int NOT NULL DEFAULT 0 AFTER `RequiredTimeEventPassed`;
+
+ALTER TABLE `char_base_info` MODIFY `OtherFactionRaceID` tinyint NOT NULL DEFAULT 0 AFTER `ClassID`;
+
+ALTER TABLE `chat_channels` MODIFY `FactionGroup` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `Flags`;
+
+ALTER TABLE `chr_class_ui_display` MODIFY `ChrClassesID` tinyint NOT NULL DEFAULT 0 AFTER `ID`;
+
+ALTER TABLE `chr_classes` MODIFY `ID` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `DefaultSpec`;
+
+ALTER TABLE `chr_customization_req` ADD `RegionGroupMask` int NOT NULL DEFAULT 0 AFTER `ClassMask`;
+
+ALTER TABLE `chr_race_x_chr_model`
+ MODIFY `ChrRacesID` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `ID`,
+ MODIFY `Sex` tinyint NOT NULL DEFAULT 0 AFTER `ChrModelID`;
+
+ALTER TABLE `chr_races`
+ MODIFY `BaseLanguage` tinyint NOT NULL DEFAULT 0 AFTER `Unknown910_23`,
+ MODIFY `CreatureType` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `BaseLanguage`,
+ MODIFY `Alliance` tinyint NOT NULL DEFAULT 0 AFTER `CreatureType`,
+ MODIFY `RaceRelated` tinyint NOT NULL DEFAULT 0 AFTER `Alliance`,
+ MODIFY `UnalteredVisualRaceID` tinyint NOT NULL DEFAULT 0 AFTER `RaceRelated`,
+ MODIFY `DefaultClassID` tinyint NOT NULL DEFAULT 0 AFTER `UnalteredVisualRaceID`,
+ MODIFY `NeutralRaceID` tinyint NOT NULL DEFAULT 0 AFTER `DefaultClassID`,
+ MODIFY `MaleModelFallbackRaceID` tinyint NOT NULL DEFAULT 0 AFTER `NeutralRaceID`,
+ MODIFY `FemaleModelFallbackRaceID` tinyint NOT NULL DEFAULT 0 AFTER `MaleModelFallbackSex`,
+ MODIFY `FemaleModelFallbackSex` tinyint NOT NULL DEFAULT 0 AFTER `FemaleModelFallbackRaceID`,
+ MODIFY `MaleTextureFallbackRaceID` tinyint NOT NULL DEFAULT 0 AFTER `FemaleModelFallbackSex`,
+ MODIFY `FemaleTextureFallbackRaceID` tinyint NOT NULL DEFAULT 0 AFTER `MaleTextureFallbackSex`,
+ MODIFY `FemaleTextureFallbackSex` tinyint NOT NULL DEFAULT 0 AFTER `FemaleTextureFallbackRaceID`,
+ MODIFY `HelmetAnimScalingRaceID` tinyint NOT NULL DEFAULT 0 AFTER `FemaleTextureFallbackSex`,
+ MODIFY `UnalteredVisualCustomizationRaceID` tinyint NOT NULL DEFAULT 0 AFTER `HelmetAnimScalingRaceID`,
+ DROP `Unknown1000`;
+
+ALTER TABLE `creature_display_info_extra` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `DisplayClassID`;
+
+ALTER TABLE `creature_type` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `Name`;
+
+ALTER TABLE `currency_types` ADD `OrderIndex` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `AccountTransferPercentage`;
+
+ALTER TABLE `emotes_text_sound`
+ MODIFY `RaceID` tinyint NOT NULL DEFAULT 0 AFTER `ID`,
+ MODIFY `ClassID` tinyint NOT NULL DEFAULT 0 AFTER `RaceID`,
+ MODIFY `SexID` tinyint NOT NULL DEFAULT 0 AFTER `ClassID`;
+
+ALTER TABLE `garr_follower` MODIFY `Gender` tinyint NOT NULL DEFAULT 0 AFTER `Flags`;
+
+ALTER TABLE `gossip_npc_option` ADD `SkillLineID` int NOT NULL DEFAULT 0 AFTER `Unknown_1002_14`;
+
+ALTER TABLE `item_sparse` MODIFY `RequiredPVPRank` tinyint NOT NULL DEFAULT 0 AFTER `RequiredPVPMedal`;
+
+ALTER TABLE `journal_instance` ADD `CovenantID` smallint UNSIGNED NOT NULL DEFAULT 0 AFTER `AreaID`;
+
+ALTER TABLE `liquid_type` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `Texture6`;
+
+ALTER TABLE `mount_capability` ADD `DriveCapabilityID` int NOT NULL DEFAULT 0 AFTER `FlightCapabilityID`;
+
+ALTER TABLE `name_gen`
+ MODIFY `RaceID` tinyint NOT NULL DEFAULT 0 AFTER `Name`,
+ MODIFY `Sex` tinyint NOT NULL DEFAULT 0 AFTER `RaceID`;
+
+ALTER TABLE `path` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `Alpha`;
+
+ALTER TABLE `player_condition`
+ MODIFY `LifetimeMaxPVPRank` tinyint NOT NULL DEFAULT 0 AFTER `PartyStatus`,
+ MODIFY `MinPVPRank` tinyint NOT NULL DEFAULT 0 AFTER `MinExpansionTier`,
+ MODIFY `MaxPVPRank` tinyint NOT NULL DEFAULT 0 AFTER `MinPVPRank`;
+
+ALTER TABLE `quest_line_x_quest` ADD `Unknown1110` int NOT NULL DEFAULT 0 AFTER `Flags`;
+
+ALTER TABLE `spell_shapeshift_form` MODIFY `CreatureType` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `CreatureDisplayID`;
+
+ALTER TABLE `talent` MODIFY `ClassID` tinyint NOT NULL DEFAULT 0 AFTER `ColumnIndex`;
+
+ALTER TABLE `world_effect` MODIFY `WhenToDisplay` int NOT NULL DEFAULT 0 AFTER `QuestFeedbackEffectID`;
+
+ALTER TABLE `world_map_overlay` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `PlayerConditionID`;
diff --git a/sql/updates/world/master/2025_03_02_00_world.sql b/sql/updates/world/master/2025_03_02_00_world.sql
new file mode 100644
index 00000000000..a23e9c65832
--- /dev/null
+++ b/sql/updates/world/master/2025_03_02_00_world.sql
@@ -0,0 +1,4 @@
+ALTER TABLE `gossip_menu_option` MODIFY `BoxMoney` bigint unsigned NOT NULL DEFAULT 0;
+
+UPDATE `gameobject_template` SET `data4`=0x43,`VerifiedBuild`=-ABS(`VerifiedBuild`) WHERE `type`=32 AND `data4`=0;
+UPDATE `gameobject_template` SET `data4`=0x10,`VerifiedBuild`=-ABS(`VerifiedBuild`) WHERE `type`=32 AND `data4`=1;