diff options
| author | Shauren <shauren.trinity@gmail.com> | 2015-08-30 00:17:08 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2015-08-30 00:17:08 +0200 |
| commit | b564c10b13effed63c7b7dae25117e2e0a2c64e4 (patch) | |
| tree | ea79cf0c9b254aac517f1024602b39615eedb010 /src/server/database/Database/Implementation | |
| parent | b0107802064a19d69ce06f7bcf8b8394695e6faf (diff) | |
Core/Players: Implemented serverside validation of reserved/profane names
Closes #15357
New library dependency: Boost.Regex
Diffstat (limited to 'src/server/database/Database/Implementation')
| -rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.cpp | 9 | ||||
| -rw-r--r-- | src/server/database/Database/Implementation/HotfixDatabase.h | 6 |
2 files changed, 15 insertions, 0 deletions
diff --git a/src/server/database/Database/Implementation/HotfixDatabase.cpp b/src/server/database/Database/Implementation/HotfixDatabase.cpp index ff3f8e906c7..927e7f623d8 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.cpp +++ b/src/server/database/Database/Implementation/HotfixDatabase.cpp @@ -291,6 +291,15 @@ void HotfixDatabaseConnection::DoPrepareStatements() PrepareStatement(HOTFIX_SEL_NAME_GEN, "SELECT ID, Name, Race, Sex FROM name_gen ORDER BY ID DESC", CONNECTION_SYNCH); PREPARE_LOCALE_STMT(HOTFIX_SEL_NAME_GEN, "SELECT ID, Name_lang FROM name_gen_locale WHERE locale = ?", CONNECTION_SYNCH); + // NamesProfanity.db2 + PrepareStatement(HOTFIX_SEL_NAMES_PROFANITY, "SELECT ID, Name, Language FROM names_profanity ORDER BY ID DESC", CONNECTION_SYNCH); + + // NamesReserved.db2 + PrepareStatement(HOTFIX_SEL_NAMES_RESERVED, "SELECT ID, Name FROM names_reserved ORDER BY ID DESC", CONNECTION_SYNCH); + + // NamesReservedLocale.db2 + PrepareStatement(HOTFIX_SEL_NAMES_RESERVED_LOCALE, "SELECT ID, Name, LocaleMask FROM names_reserved_locale ORDER BY ID DESC", CONNECTION_SYNCH); + // OverrideSpellData.db2 PrepareStatement(HOTFIX_SEL_OVERRIDE_SPELL_DATA, "SELECT ID, SpellID1, SpellID2, SpellID3, SpellID4, SpellID5, SpellID6, SpellID7, SpellID8, " "SpellID9, SpellID10, Flags, PlayerActionbarFileDataID FROM override_spell_data ORDER BY ID DESC", CONNECTION_SYNCH); diff --git a/src/server/database/Database/Implementation/HotfixDatabase.h b/src/server/database/Database/Implementation/HotfixDatabase.h index abc584a8b20..c181ef9e9e6 100644 --- a/src/server/database/Database/Implementation/HotfixDatabase.h +++ b/src/server/database/Database/Implementation/HotfixDatabase.h @@ -168,6 +168,12 @@ enum HotfixDatabaseStatements HOTFIX_SEL_NAME_GEN, HOTFIX_SEL_NAME_GEN_LOCALE, + HOTFIX_SEL_NAMES_PROFANITY, + + HOTFIX_SEL_NAMES_RESERVED, + + HOTFIX_SEL_NAMES_RESERVED_LOCALE, + HOTFIX_SEL_OVERRIDE_SPELL_DATA, HOTFIX_SEL_PHASE_X_PHASE_GROUP, |