APIAccountDB Class Reference

#include "APIAccountDB.h"

Public Member Functions
	APIAccountDB ()
bool	GetCharactersList (uint32 accountID, std::vector< std::string > &charIDList, std::vector< std::string > &charNameList, std::vector< std::string > &charCorpIDList, std::vector< std::string > &charCorpNameList)
	? More...
bool	GetAccountInfo (uint32 accountID, std::vector< std::string > &accountInfoList)
	? More...

Detailed Description

Definition at line 31 of file APIAccountDB.h.

Constructor & Destructor Documentation

APIAccountDB::APIAccountDB

(

)

Definition at line 30 of file APIAccountDB.cpp.

{
}

Member Function Documentation

bool APIAccountDB::GetAccountInfo	(	uint32	accountID,
		std::vector< std::string > &	accountInfoList
	)

?

?

Parameters

[in]	?
[in]	?

Return values

?

Definition at line 69 of file APIAccountDB.cpp.

References DBQueryResult::GetRow(), DBResultRow::GetText(), sDatabase, and sLog.

Referenced by APIAccountManager::_AccountStatus().

{
    DBQueryResult res;

    // Get account table info using the accountID:
    if( !sDatabase.RunQuery(res,
        " SELECT "
        "   online, "
        "   banned, "
        "   logonCount, "
        "   lastLogin "
        " FROM account "
        " WHERE `accountID` = %u ", accountID ))
    {
        sLog.Error( "APIAccountDB::GetAccountInfo()", "Cannot find accountID %u", accountID );
        return false;
    }

    DBResultRow row;
    if( !res.GetRow(row) )
    {
        sLog.Error( "APIServiceDB::GetAccountInfo()", "res.GetRow(row) failed for unknown reason." );
        return false;
    }

    accountInfoList.push_back( std::string(row.GetText(0)) );
    accountInfoList.push_back( std::string(row.GetText(1)) );
    accountInfoList.push_back( std::string(row.GetText(2)) );
    accountInfoList.push_back( std::string(row.GetText(3)) );

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool APIAccountDB::GetCharactersList	(	uint32	accountID,
		std::vector< std::string > &	charIDList,
		std::vector< std::string > &	charNameList,
		std::vector< std::string > &	charCorpIDList,
		std::vector< std::string > &	charCorpNameList
	)

?

?

Parameters

[in]	?
[in]	?

Return values

?

Definition at line 34 of file APIAccountDB.cpp.

References DBQueryResult::GetRow(), DBResultRow::GetText(), sDatabase, and sLog.

Referenced by APIAccountManager::_Characters().

{
    DBQueryResult res;

    // Get list of characters and their corporation info from the accountID:
    if( !sDatabase.RunQuery(res,
        " SELECT "
        "   character_.characterID, "
        "   character_.corporationID, "
        "   corporation.corporationName, "
        "   entity.itemName AS name "
        " FROM `character_` "
        "   LEFT JOIN corporation ON corporation.corporationID = character_.corporationID "
        "   LEFT JOIN entity ON entity.itemID = character_.characterID "
        " WHERE `accountID` = %u ", accountID ))
    {
        sLog.Error( "APIAccountDB::GetCharactersList()", "Cannot find accountID %u", accountID );
        return false;
    }

    DBResultRow row;
    std::map<std::string, std::string> charInfo;
    while( res.GetRow( row ) )
    {
        charIDList.push_back( std::string(row.GetText(0)) );
        charCorpIDList.push_back( std::string(row.GetText(1)) );
        charCorpNameList.push_back( std::string(row.GetText(2)) );
        charNameList.push_back( std::string(row.GetText(3)) );
    }

    return true;
}

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/apiserver/APIAccountDB.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/apiserver/APIAccountDB.cpp