summaryrefslogtreecommitdiff
path: root/src/common/Database/Implementation/CharacterDatabase.cpp
diff options
context:
space:
mode:
authorIntelligentQuantum <IntelligentQuantum@ProtonMail.Com>2019-12-19 10:18:26 +0330
committerStoabrogga <38475780+Stoabrogga@users.noreply.github.com>2019-12-19 07:48:26 +0100
commitae810491e7f7e7e5925ad94f40d7fc711568338a (patch)
tree4764cc906ed3b407397d0ce24e29f3b7fc65a7aa /src/common/Database/Implementation/CharacterDatabase.cpp
parentf1f553b5094594beb090ff934eba7bdd1bafd97a (diff)
fix(Core/ItemHandler): crash buy back item (#2511)
Diffstat (limited to 'src/common/Database/Implementation/CharacterDatabase.cpp')
-rw-r--r--src/common/Database/Implementation/CharacterDatabase.cpp2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/common/Database/Implementation/CharacterDatabase.cpp b/src/common/Database/Implementation/CharacterDatabase.cpp
index 002d2044c0..09a664a5fe 100644
--- a/src/common/Database/Implementation/CharacterDatabase.cpp
+++ b/src/common/Database/Implementation/CharacterDatabase.cpp
@@ -569,5 +569,5 @@ void CharacterDatabaseConnection::DoPrepareStatements()
// Recovery Item
PrepareStatement(CHAR_INS_RECOVERY_ITEM, "INSERT INTO recovery_item (Guid, ItemEntry, Count) VALUES (?, ?, ?)", CONNECTION_SYNCH);
- PrepareStatement(CHAR_DEL_RECOVERY_ITEM, "DELETE FROM recovery_item WHERE Guid = ? AND ItemEntry = ? ORDER BY Id DESC LIMIT 1", CONNECTION_ASYNC);
+ PrepareStatement(CHAR_DEL_RECOVERY_ITEM, "DELETE FROM recovery_item WHERE Guid = ? AND ItemEntry = ? AND Count = ? ORDER BY Id DESC LIMIT 1", CONNECTION_ASYNC);
}