summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--src/account-server/storage.cpp8
1 files changed, 7 insertions, 1 deletions
diff --git a/src/account-server/storage.cpp b/src/account-server/storage.cpp
index 5cf4c081..766864ba 100644
--- a/src/account-server/storage.cpp
+++ b/src/account-server/storage.cpp
@@ -770,9 +770,15 @@ bool Storage::updateCharacter(Character *character)
}
// Character's inventory
- // Delete the old inventory first
+ // Delete the old inventory and equipment table first
try
{
+ std::ostringstream sqlDeleteCharacterEquipment;
+ sqlDeleteCharacterEquipment
+ << "delete from " << CHAR_EQUIPS_TBL_NAME
+ << " where owner_id = '" << character->getDatabaseID() << "';";
+ mDb->execSql(sqlDeleteCharacterEquipment.str());
+
std::ostringstream sqlDeleteCharacterInventory;
sqlDeleteCharacterInventory
<< "delete from " << INVENTORIES_TBL_NAME