diff options
| author | David Athay <ko2fan@gmail.com> | 2009-03-05 15:37:06 +0000 |
|---|---|---|
| committer | David Athay <ko2fan@gmail.com> | 2009-03-05 15:37:06 +0000 |
| commit | 7ae5cf4b6d17a85a010c1eb3262d340e94f44e77 (patch) | |
| tree | 8e4e27fa94359e34d5879a05a213d5f239908809 /src/account-server/dalstorage.cpp | |
| parent | be548ff54b8fa60a8a778714cd8fa5326722c0aa (diff) | |
| download | manaserv-7ae5cf4b6d17a85a010c1eb3262d340e94f44e77.tar.gz manaserv-7ae5cf4b6d17a85a010c1eb3262d340e94f44e77.tar.bz2 manaserv-7ae5cf4b6d17a85a010c1eb3262d340e94f44e77.tar.xz manaserv-7ae5cf4b6d17a85a010c1eb3262d340e94f44e77.zip | |
Added transactions for chat events.
Diffstat (limited to 'src/account-server/dalstorage.cpp')
| -rw-r--r-- | src/account-server/dalstorage.cpp | 14 |
1 files changed, 7 insertions, 7 deletions
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<Transaction> 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<Transaction> 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); } } |