From 7ae5cf4b6d17a85a010c1eb3262d340e94f44e77 Mon Sep 17 00:00:00 2001 From: David Athay Date: Thu, 5 Mar 2009 15:37:06 +0000 Subject: Added transactions for chat events. --- src/account-server/dalstorage.cpp | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) (limited to 'src/account-server/dalstorage.cpp') diff --git a/src/account-server/dalstorage.cpp b/src/account-server/dalstorage.cpp index a524fc35..eac9f409 100644 --- a/src/account-server/dalstorage.cpp +++ b/src/account-server/dalstorage.cpp @@ -1635,7 +1635,7 @@ void DALStorage::addTransaction(const Transaction &trans) { std::stringstream sql; sql << "INSERT INTO " << TRANSACTION_TBL_NAME - << " VALUES (" << trans.mCharacterId << ", " << trans.mAction + << " VALUES (NULL, " << trans.mCharacterId << ", " << trans.mAction << ", '" << trans.mMessage << "', " << time(NULL) << ")"; mDb->execSql(sql.str()); } @@ -1662,9 +1662,9 @@ std::vector DALStorage::getTransactions(unsigned int num) for (int i = start; i < size; ++i) { Transaction trans; - trans.mCharacterId = toUint(rec(i, 0)); - trans.mAction = toUint(rec(i, 1)); - trans.mMessage = rec(i, 2); + trans.mCharacterId = toUint(rec(i, 1)); + trans.mAction = toUint(rec(i, 2)); + trans.mMessage = rec(i, 3); transactions.push_back(trans); } } @@ -1691,9 +1691,9 @@ std::vector DALStorage::getTransactions(time_t date) for (int i = 0; i < rec.rows(); ++i) { Transaction trans; - trans.mCharacterId = toUint(rec(i, 0)); - trans.mAction = toUint(rec(i, 1)); - trans.mMessage = rec(i, 2); + trans.mCharacterId = toUint(rec(i, 1)); + trans.mAction = toUint(rec(i, 2)); + trans.mMessage = rec(i, 3); transactions.push_back(trans); } } -- cgit v1.2.3-70-g09d2