From ea1ffd68940c9354e00a1bd8c748a1a09b4d360c Mon Sep 17 00:00:00 2001
From: Skjalf <47818697+Nyeriah@users.noreply.github.com>
Date: Mon, 20 Dec 2021 16:11:45 -0300
Subject: feat(Scripts/Commands): Implement item refund command (#9811)

---
 src/server/database/Database/Implementation/CharacterDatabase.cpp | 3 +++
 src/server/database/Database/Implementation/CharacterDatabase.h   | 3 +++
 2 files changed, 6 insertions(+)

(limited to 'src/server/database/Database/Implementation')

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
-- 
cgit v1.2.3