diff options
| -rw-r--r-- | src/account-server/storage.cpp | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/src/account-server/storage.cpp b/src/account-server/storage.cpp index 25e75182..656dfad9 100644 --- a/src/account-server/storage.cpp +++ b/src/account-server/storage.cpp @@ -988,8 +988,7 @@ void Storage::flush(Account *account) << " (user_id, name, gender, hair_style, hair_color," << " char_pts, correct_pts," << " x, y, map_id, slot) values (" - << account->getID() << ", \"" - << character->getName() << "\", " + << account->getID() << ", ?, " << character->getGender() << ", " << (int)character->getHairStyle() << ", " << (int)character->getHairColor() << ", " @@ -1001,7 +1000,9 @@ void Storage::flush(Account *account) << character->getCharacterSlot() << ");"; - mDb->execSql(sqlInsertCharactersTable.str()); + mDb->prepareSql(sqlInsertCharactersTable.str()); + mDb->bindValue(1, character->getName()); + mDb->processSql(); // Update the character ID. character->setDatabaseID(mDb->getLastId()); |