diff options
| author | Ovahlord <dreadkiller@gmx.de> | 2024-06-18 19:41:09 +0200 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2024-06-18 19:41:09 +0200 |
| commit | 8a58c75b674e4cbc7c257f3c500c0ffadbadabfb (patch) | |
| tree | 6cd03ba38aa8ac241ccdefafd57d5a9f57654ade | |
| parent | 23135b198c21dc010489a2aa18f9ab1b604be49a (diff) | |
Core/DataStores: named new columns in ChrCustomizationOption which have been added in 11.x
| -rw-r--r-- | sql/updates/hotfixes/cata_classic/2024_06_18_01_hotfixes.sql | 3 | ||||
| -rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.cpp | 2 | ||||
| -rw-r--r-- | src/server/game/DataStores/DB2LoadInfo.h | 4 |
3 files changed, 6 insertions, 3 deletions
diff --git a/sql/updates/hotfixes/cata_classic/2024_06_18_01_hotfixes.sql b/sql/updates/hotfixes/cata_classic/2024_06_18_01_hotfixes.sql new file mode 100644 index 00000000000..3dd60f2c2b0 --- /dev/null +++ b/sql/updates/hotfixes/cata_classic/2024_06_18_01_hotfixes.sql @@ -0,0 +1,3 @@ +ALTER TABLE `chr_customization_option` + CHANGE `Field110055087004` `ChrRacesID` INT UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `Field110055087005` `Sex` INT DEFAULT 0 NOT NULL; diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp index 0c2fb283780..0df38ec73a6 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.cpp +++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp @@ -352,7 +352,7 @@ void HotfixDatabaseConnection::DoPrepareStatements() PREPARE_MAX_ID_STMT(HOTFIX_SEL_CHR_CUSTOMIZATION_ELEMENT, "SELECT MAX(ID) + 1 FROM chr_customization_element", CONNECTION_SYNCH); // ChrCustomizationOption.db2 - PrepareStatement(HOTFIX_SEL_CHR_CUSTOMIZATION_OPTION, "SELECT Name, ID, SecondaryID, Flags, Field110055087004, Field110055087005, ChrModelID, " + PrepareStatement(HOTFIX_SEL_CHR_CUSTOMIZATION_OPTION, "SELECT Name, ID, SecondaryID, Flags, ChrRacesID, Sex, ChrModelID, " "SortIndex, ChrCustomizationCategoryID, OptionType, BarberShopCostModifier, ChrCustomizationID, ChrCustomizationReqID, UiOrderIndex" " FROM chr_customization_option WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH); PREPARE_MAX_ID_STMT(HOTFIX_SEL_CHR_CUSTOMIZATION_OPTION, "SELECT MAX(ID) + 1 FROM chr_customization_option", CONNECTION_SYNCH); diff --git a/src/server/game/DataStores/DB2LoadInfo.h b/src/server/game/DataStores/DB2LoadInfo.h index 966a27c8b7d..e9f8d79dec3 100644 --- a/src/server/game/DataStores/DB2LoadInfo.h +++ b/src/server/game/DataStores/DB2LoadInfo.h @@ -975,8 +975,8 @@ struct ChrCustomizationOptionLoadInfo { false, FT_INT, "ID" }, { false, FT_SHORT, "SecondaryID" }, { true, FT_INT, "Flags" }, - { false, FT_INT, "Field110055087004" }, - { true, FT_INT, "Field110055087005" }, + { false, FT_INT, "ChrRacesID" }, + { true, FT_INT, "Sex" }, { true, FT_INT, "ChrModelID" }, { true, FT_INT, "SortIndex" }, { true, FT_INT, "ChrCustomizationCategoryID" }, |