diff options
| -rw-r--r-- | sql/updates/hotfixes/master/2021_11_08_00_hotfixes.sql | 1 | ||||
| -rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.cpp | 6 |
2 files changed, 4 insertions, 3 deletions
diff --git a/sql/updates/hotfixes/master/2021_11_08_00_hotfixes.sql b/sql/updates/hotfixes/master/2021_11_08_00_hotfixes.sql new file mode 100644 index 00000000000..87a56be94ec --- /dev/null +++ b/sql/updates/hotfixes/master/2021_11_08_00_hotfixes.sql @@ -0,0 +1 @@ +ALTER TABLE `chr_races_locale` CHANGE COLUMN `NameS_lang` `LoreName_lang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `NameFemaleLowercase_lang`, CHANGE COLUMN `NameFemaleS_lang` `LoreNameFemale_lang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `LoreName_lang`, CHANGE COLUMN `NameLowercaseS_lang` `LoreNameLower_lang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `LoreNameFemale_lang`, CHANGE COLUMN `NameFemaleLowercaseS_lang` `LoreNameLowerFemale_lang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `LoreNameLower_lang`, CHANGE COLUMN `RaceFantasyDescription_lang` `LoreDescription_lang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `LoreNameLowerFemale_lang`, CHANGE COLUMN `NameL_lang` `ShortName_lang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `LoreDescription_lang`, CHANGE COLUMN `NameFemaleL_lang` `ShortNameFemale_lang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `ShortName_lang`, CHANGE COLUMN `NameLowercaseL_lang` `ShortNameLower_lang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `ShortNameFemale_lang`, CHANGE COLUMN `NameFemaleLowercaseL_lang` `ShortNameLowerFemale_lang` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `ShortNameLower_lang`; diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp index b7dbc75059c..5824357eb1a 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.cpp +++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp @@ -394,9 +394,9 @@ void HotfixDatabaseConnection::DoPrepareStatements() "Unknown910_22, Unknown910_23, BaseLanguage, CreatureType, MaleModelFallbackSex, FemaleModelFallbackSex, MaleTextureFallbackSex, " "FemaleTextureFallbackSex FROM chr_races WHERE (`VerifiedBuild` > 0) = ?", CONNECTION_SYNCH); PREPARE_MAX_ID_STMT(HOTFIX_SEL_CHR_RACES, "SELECT MAX(ID) + 1 FROM chr_races", CONNECTION_SYNCH); - PREPARE_LOCALE_STMT(HOTFIX_SEL_CHR_RACES, "SELECT ID, Name_lang, NameFemale_lang, NameLowercase_lang, NameFemaleLowercase_lang, NameS_lang, " - "NameFemaleS_lang, NameLowercaseS_lang, NameFemaleLowercaseS_lang, RaceFantasyDescription_lang, NameL_lang, NameFemaleL_lang, " - "NameLowercaseL_lang, NameFemaleLowercaseL_lang FROM chr_races_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?", CONNECTION_SYNCH); + PREPARE_LOCALE_STMT(HOTFIX_SEL_CHR_RACES, "SELECT ID, Name_lang, NameFemale_lang, NameLowercase_lang, NameFemaleLowercase_lang, LoreName_lang, " + "LoreNameFemale_lang, LoreNameLower_lang, LoreNameLowerFemale_lang, LoreDescription_lang, ShortName_lang, ShortNameFemale_lang, " + "ShortNameLower_lang, ShortNameLowerFemale_lang FROM chr_races_locale WHERE (`VerifiedBuild` > 0) = ? AND locale = ?", CONNECTION_SYNCH); // ChrSpecialization.db2 PrepareStatement(HOTFIX_SEL_CHR_SPECIALIZATION, "SELECT Name, FemaleName, Description, ID, ClassID, OrderIndex, PetTalentType, Role, Flags, " |