aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-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
3 files changed, 120 insertions, 0 deletions
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;