diff options
| author | Skjalf <47818697+Nyeriah@users.noreply.github.com> | 2021-12-20 16:11:45 -0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-12-20 16:11:45 -0300 |
| commit | ea1ffd68940c9354e00a1bd8c748a1a09b4d360c (patch) | |
| tree | 2194c7146804c0be9885429a538bb8ddc7e8cb7a /src/server/database/Database/Implementation | |
| parent | 267cd9a75af26cb78b595fd7d55ebad1d3c37277 (diff) | |
feat(Scripts/Commands): Implement item refund command (#9811)
Diffstat (limited to 'src/server/database/Database/Implementation')
| -rw-r--r-- | src/server/database/Database/Implementation/CharacterDatabase.cpp | 3 | ||||
| -rw-r--r-- | src/server/database/Database/Implementation/CharacterDatabase.h | 3 |
2 files changed, 6 insertions, 0 deletions
diff --git a/src/server/database/Database/Implementation/CharacterDatabase.cpp b/src/server/database/Database/Implementation/CharacterDatabase.cpp index c213443f00..f81862717f 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.cpp +++ b/src/server/database/Database/Implementation/CharacterDatabase.cpp @@ -598,6 +598,9 @@ void CharacterDatabaseConnection::DoPrepareStatements() PrepareStatement(CHAR_DEL_RECOVERY_ITEM, "DELETE FROM recovery_item WHERE Guid = ? AND ItemEntry = ? AND Count = ? ORDER BY Id DESC LIMIT 1", CONNECTION_ASYNC); PrepareStatement(CHAR_DEL_RECOVERY_ITEM_BY_RECOVERY_ID, "DELETE FROM recovery_item WHERE id = ?", CONNECTION_ASYNC); + PrepareStatement(CHAR_SEL_HONORPOINTS, "SELECT totalHonorPoints FROM characters WHERE guid = ?", CONNECTION_SYNCH); + PrepareStatement(CHAR_SEL_ARENAPOINTS, "SELECT arenaPoints FROM characters WHERE guid = ?", CONNECTION_SYNCH); + // Character names PrepareStatement(CHAR_INS_RESERVED_PLAYER_NAME, "INSERT IGNORE INTO reserved_name (name) VALUES (?)", CONNECTION_ASYNC); } diff --git a/src/server/database/Database/Implementation/CharacterDatabase.h b/src/server/database/Database/Implementation/CharacterDatabase.h index 2d675c6670..5149373fe0 100644 --- a/src/server/database/Database/Implementation/CharacterDatabase.h +++ b/src/server/database/Database/Implementation/CharacterDatabase.h @@ -514,6 +514,9 @@ enum CharacterDatabaseStatements : uint32 CHAR_DEL_RECOVERY_ITEM, CHAR_DEL_RECOVERY_ITEM_BY_RECOVERY_ID, + CHAR_SEL_HONORPOINTS, + CHAR_SEL_ARENAPOINTS, + CHAR_INS_RESERVED_PLAYER_NAME, MAX_CHARACTERDATABASE_STATEMENTS |