AccountDB Class Reference

#include "AccountDB.h"

Public Member Functions
PyRep *	GetWalletDivisionsInfo (uint32 corpID)
PyRep *	GetJournal (uint32 ownerID, int8 entryTypeID, uint16 accountKey, int64 fromDate, bool reverse=false)

Static Public Member Functions
static double	OfflineFundXfer (uint32 charID, double amount, uint8 type=Account::CreditType::ISK)
static double	GetCorpBalance (uint32 corpID, uint16 accountKey)
static void	UpdateCorpBalance (uint32 corpID, uint16 accountKey, double amount)
static void	AddJournalEntry (uint32 ownerID, int8 entryTypeID, uint32 ownerFromID, uint32 ownerToID, int8 currency, uint16 accountKey, double amount, double newBalance, std::string description, uint32 referenceID=0)

Detailed Description

Definition at line 32 of file AccountDB.h.

Member Function Documentation

void AccountDB::AddJournalEntry ( uint32  ownerID, int8  entryTypeID, uint32  ownerFromID, uint32  ownerToID, int8  currency, uint16  accountKey, double  amount, double  newBalance, std::string  description, uint32  referenceID = 0  )

static

Definition at line 166 of file AccountDB.cpp.

References DBerror::c_str(), Account::KeyType::Cash, GetFileTimeNow(), IsCorp, sDatabase, and Journal::EntryType::SkipLog.

Referenced by AccountService::HandleCorpTransaction(), and AccountService::TranserFunds().

{
    if (entryTypeID == Journal::EntryType::SkipLog)
        return;
    // account key 0 is usually sent by the client, it should be the main cash account
    if (accountKey == 0)
        accountKey = Account::KeyType::Cash;

    std::string eDesc;
    sDatabase.DoEscapeString(eDesc, description);

    std::string tblName = "jnlCharacters";
    if (IsCorp(ownerID))
        tblName = "jnlCorporations";

    // dont care if this fails...
    DBerror err;
    sDatabase.RunQuery(err,
        "INSERT INTO %s (ownerID, entryTypeID, accountKey, transactionDate, ownerID1, ownerID2, referenceID, currency, amount, balance, description)"
        " VALUES (%u,%u,%u,%f,%u,%u,%u,%i,%.2f,%.2f,'%s')",
        tblName.c_str(), ownerID, entryTypeID, accountKey, GetFileTimeNow(), ownerFromID, ownerToID, referenceID, currency, amount, newBalance, eDesc.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

double AccountDB::GetCorpBalance ( uint32  corpID, uint16  accountKey  )

static

Definition at line 69 of file AccountDB.cpp.

References DBerror::c_str(), Account::KeyType::Cash, Account::KeyType::Cash2, Account::KeyType::Cash3, Account::KeyType::Cash4, Account::KeyType::Cash5, Account::KeyType::Cash6, Account::KeyType::Cash7, codelog, DBQueryResult::error, DBResultRow::GetDouble(), DBQueryResult::GetRow(), and sDatabase.

Referenced by AccountService::HandleCorpTransaction().

{
    std::string acctKey = "";
    switch (accountKey) {
        case Account::KeyType::Cash:    acctKey = "balance1"; break;
        case Account::KeyType::Cash2:   acctKey = "balance2"; break;
        case Account::KeyType::Cash3:   acctKey = "balance3"; break;
        case Account::KeyType::Cash4:   acctKey = "balance4"; break;
        case Account::KeyType::Cash5:   acctKey = "balance5"; break;
        case Account::KeyType::Cash6:   acctKey = "balance6"; break;
        case Account::KeyType::Cash7:   acctKey = "balance7"; break;
    }
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT %s FROM crpWalletDivisons WHERE corporationID = %u ", acctKey.c_str(), corpID)) {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return 0;
    }
    DBResultRow row;
    if (!res.GetRow(row))
        return 0;
    return row.GetDouble(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyRep * AccountDB::GetJournal	(	uint32	ownerID,
		int8	entryTypeID,
		uint16	accountKey,
		int64	fromDate,
		bool	reverse = false
	)

Definition at line 135 of file AccountDB.cpp.

References DBerror::c_str(), codelog, DBResultToCRowset(), DBQueryResult::error, IsCorp, and sDatabase.

{
    std::string tblName = "jnlCharacters";
    if (IsCorp(ownerID))
        tblName = "jnlCorporations";

    std::string entryType = "";
    if (entryTypeID) {
        entryType = " AND entryTypeID = ";
        entryType += std::to_string(entryTypeID);
    }

    std::string sort = "";
    if (reverse)
        sort = "";

    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT transactionID, transactionDate, referenceID, entryTypeID, ownerID1, ownerID2, accountKey, amount,"
        " balance, description, currency, 1 AS sortValue"
        " FROM %s"
        " WHERE transactionDate > %li AND accountKey = %u %s AND ownerID = %u %s",
        tblName.c_str(), fromDate, accountKey, entryType.c_str(), ownerID, sort.c_str()))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * AccountDB::GetWalletDivisionsInfo

(

uint32

corpID

)

Definition at line 109 of file AccountDB.cpp.

References PyList::AddItem(), DBerror::c_str(), codelog, PyRep::Dump(), DBQueryResult::error, DBResultRow::GetDouble(), DBQueryResult::GetRow(), is_log_enabled, sDatabase, and PyDict::SetItemString().

                                                      {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT balance1, balance2, balance3, balance4, balance5, balance6,  balance7"
        " FROM crpWalletDivisons"
        " WHERE corporationID = %u", corpID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    DBResultRow row;
    PyList *list = new PyList();
    if (res.GetRow(row))
        for (int8 i = 0; i < 7; ++i) {
            PyDict *dict = new PyDict();
            dict->SetItemString("key", new PyInt(1000 + i));
            dict->SetItemString("balance", new PyFloat(row.GetDouble(i)));
            list->AddItem(new PyObject("util.KeyVal", dict));
        }

    if (is_log_enabled(ACCOUNT__RSP_DUMP))
        list->Dump(ACCOUNT__RSP_DUMP, "    ");
    return list;
}

Here is the call graph for this function:

double AccountDB::OfflineFundXfer ( uint32  charID, double  amount, uint8  type = Account::CreditType::ISK  )

static

Definition at line 46 of file AccountDB.cpp.

References Account::CreditType::AURUM, DBerror::c_str(), DBResultRow::GetDouble(), DBQueryResult::GetRow(), Account::CreditType::ISK, Account::CreditType::MPLEX, and sDatabase.

Referenced by AccountService::TranserFunds().

{
    std::string from = "";
    switch (type) {
        case Account::CreditType::ISK:      from = "balance";    break;
        case Account::CreditType::AURUM:    from = "aurBalance"; break;
        case Account::CreditType::MPLEX:    return 0; //make error..this isnt used yet
    }

    double balance = 0;
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT %s FROM chrCharacters WHERE characterID = %u", from.c_str(), charID);
    DBResultRow row;
    if (res.GetRow(row))
        balance = row.GetDouble(0);

    balance += amount;
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE chrCharacters SET %s = %f WHERE characterID = %u", from.c_str(), balance, charID);
    return balance;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void AccountDB::UpdateCorpBalance ( uint32  corpID, uint16  accountKey, double  amount  )

static

Definition at line 92 of file AccountDB.cpp.

References DBerror::c_str(), Account::KeyType::Cash, Account::KeyType::Cash2, Account::KeyType::Cash3, Account::KeyType::Cash4, Account::KeyType::Cash5, Account::KeyType::Cash6, Account::KeyType::Cash7, and sDatabase.

Referenced by AccountService::HandleCorpTransaction().

{
    std::string acctKey = "";
    switch (accountKey) {
        case Account::KeyType::Cash:    acctKey = "balance1"; break;
        case Account::KeyType::Cash2:   acctKey = "balance2"; break;
        case Account::KeyType::Cash3:   acctKey = "balance3"; break;
        case Account::KeyType::Cash4:   acctKey = "balance4"; break;
        case Account::KeyType::Cash5:   acctKey = "balance5"; break;
        case Account::KeyType::Cash6:   acctKey = "balance6"; break;
        case Account::KeyType::Cash7:   acctKey = "balance7"; break;
    }
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE crpWalletDivisons SET %s = %.2f WHERE corporationID = %u ", acctKey.c_str(), amount, corpID);
}

Here is the call graph for this function:

Here is the caller graph for this function:

---

The documentation for this class was generated from the following files:

• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/account/AccountDB.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/account/AccountDB.cpp