CertificateMgrDB Class Reference

#include "CertificateMgrDB.h"

Inheritance diagram for CertificateMgrDB:

Collaboration diagram for CertificateMgrDB:

Public Member Functions
PyRep *	GetMyCertificates (uint32 characterID)
PyRep *	GetCertificateCategories ()
PyRep *	GetAllShipCertificateRecommendations ()
PyRep *	GetCertificateClasses ()
bool	LoadCertificates (uint32 characterID, CertMap &into)
bool	SaveCertificates (uint32 characterID, const CertMap &from)
void	AddCertificate (uint32 charID, CharCerts cert)
void	UpdateCertificate (uint32 charID, uint32 certificateID, bool pub=false)
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

Additional Inherited Members
Static Public Member Functions inherited from ServiceDB
static bool	GetAccountInformation (CryptoChallengePacket &ccp, AccountData &aData, std::string &failMsg)
static bool	UpdateAccountHash (const char *username, std::string &hash)
static bool	IncrementLoginCount (uint32 accountID)
static void	UpdatePassword (uint32 accountID, const char *pass)
static void	SaveKillOrLoss (CharKillData &data)
static bool	GetConstant (const char *name, uint32 &into)
static void	SetServerOnlineStatus (bool online=false)
static void	SetCharacterOnlineStatus (uint32 char_id, bool online=false)
static void	SetAccountOnlineStatus (uint32 accountID, bool online=false)
static void	SetAccountBanStatus (uint32 accountID, bool banned=false)
static void	SaveServerStats (double threads, float rss, float vm, float user, float kernel, uint32 items, uint32 bubbles)
static uint32	SetClientSeed ()
static PyRep *	LookupChars (const char *match, bool exact=false)
static PyRep *	LookupOwners (const char *match, bool exact=false)
static PyRep *	LookupCorporations (const std::string &)
static PyRep *	LookupFactions (const std::string &)
static PyRep *	LookupCorporationTickers (const std::string &)
static PyRep *	LookupStations (const std::string &)
static PyRep *	LookupKnownLocationsByGroup (const std::string &, uint32)
static PyRep *	PrimeOwners (std::vector< int32 > &itemIDs)
static bool	ValidateAccountName (CryptoChallengePacket &ccp, std::string &failMsg)
static void	GetCorpHangarNames (uint32 corpID, std::map< uint8, std::string > &hangarNames)
Protected Member Functions inherited from ServiceDB
void	ProcessStringChange (const char *key, const std::string &oldValue, std::string newValue, PyDict *notif, std::vector< std::string > &dbQ)
void	ProcessRealChange (const char *key, double oldValue, double newValue, PyDict *notif, std::vector< std::string > &dbQ)
void	ProcessIntChange (const char *key, uint32 oldValue, uint32 newValue, PyDict *notif, std::vector< std::string > &dbQ)
void	ProcessLongChange (const char *key, int64 oldValue, int64 newValue, PyDict *notif, std::vector< std::string > &dbQ)
Static Protected Member Functions inherited from ServiceDB
static uint32	CreateNewAccount (const char *login, const char *pass, const char *passHash, int64 role)

Detailed Description

Definition at line 33 of file CertificateMgrDB.h.

Member Function Documentation

void CertificateMgrDB::AddCertificate	(	uint32	charID,
		CharCerts	cert
	)

Definition at line 74 of file CertificateMgrDB.cpp.

References _log, DBerror::c_str(), CharCerts::certificateID, CharCerts::grantDate, sDatabase, and CharCerts::visibilityFlags.

Referenced by Character::GrantCertificate().

                                                                   {
    DBerror err;
    if (!sDatabase.RunQuery( err,
        "INSERT INTO chrCertificates (characterID, certificateID, grantDate, visibilityFlags)"
        " VALUES (%u, %u, %li, %u)", charID, cert.certificateID, cert.grantDate, cert.visibilityFlags))  {
        _log(DATABASE__ERROR, "Failed to insert certificates of character %u: %s", charID, err.c_str() );
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyRep * CertificateMgrDB::GetAllShipCertificateRecommendations

(

)

Definition at line 53 of file CertificateMgrDB.cpp.

References DBerror::c_str(), codelog, DBResultToRowset(), DBQueryResult::error, PyStatic, and sDatabase.

                                                              {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT shipTypeID, certificateID, recommendationLevel, recommendationID FROM crtRecommendations")) {
        codelog(DATABASE__ERROR, "Failed to query certificate categories: %s.", res.error.c_str());
        return PyStatic.NewNone();
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * CertificateMgrDB::GetCertificateCategories

(

)

Definition at line 43 of file CertificateMgrDB.cpp.

References DBerror::c_str(), codelog, DBResultToIndexRowset(), DBQueryResult::error, PyStatic, and sDatabase.

                                                  {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT categoryID, categoryName, description, dataID, categoryNameID FROM crtCategories")) {
        codelog(DATABASE__ERROR, "Failed to query certificate categories: %s.", res.error.c_str());
        return PyStatic.NewNone();
    }

    return(DBResultToIndexRowset(res, "categoryID"));
}

Here is the call graph for this function:

PyRep * CertificateMgrDB::GetCertificateClasses

(

)

Definition at line 63 of file CertificateMgrDB.cpp.

References DBerror::c_str(), codelog, DBResultToIntRowDict(), DBQueryResult::error, PyStatic, and sDatabase.

                                               {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT classID, className, classNameID, description, dataID FROM crtClasses")) {
        codelog(DATABASE__ERROR, "Failed to query certificate classes: %s.", res.error.c_str());
        return PyStatic.NewNone();
    }

    return DBResultToIntRowDict(res, 0);
}

Here is the call graph for this function:

PyRep* CertificateMgrDB::GetMyCertificates

(

uint32

characterID

)

bool CertificateMgrDB::LoadCertificates	(	uint32	characterID,
		CertMap &	into
	)

Definition at line 92 of file CertificateMgrDB.cpp.

References _log, DBerror::c_str(), CharCerts::certificateID, DBQueryResult::error, DBResultRow::GetBool(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetUInt(), CharCerts::grantDate, sDatabase, and CharCerts::visibilityFlags.

Referenced by Character::_Load().

{
    DBQueryResult res;
    if ( !sDatabase.RunQuery( res, "SELECT certificateID, grantDate, visibilityFlags FROM chrCertificates WHERE characterID=%u", characterID)) {
        _log(DATABASE__ERROR, "Failed to query certificates of character %u: %s", characterID, res.error.c_str() );
        return false;
    }

    DBResultRow row;
    while (res.GetRow(row)) {
        CharCerts cert = CharCerts();
        cert.certificateID     = row.GetUInt( 0 );
        cert.grantDate         = row.GetInt64( 1 );
        cert.visibilityFlags   = row.GetBool( 2 );
        into.emplace(row.GetUInt( 0 ), cert );
    }

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CertificateMgrDB::SaveCertificates	(	uint32	characterID,
		const CertMap &	from
	)

Definition at line 112 of file CertificateMgrDB.cpp.

References _log, DBerror::c_str(), and sDatabase.

Referenced by Character::SaveCertificates().

{
    std::ostringstream Inserts;
    // start the insert into command.
    Inserts << "INSERT INTO chrCertificates";
    Inserts << " (characterID, certificateID, grantDate, visibilityFlags)";
    bool first = true;
    for (auto cur : data) {
        if (first) {
            Inserts << " VALUES ";
            first = false;
        } else {
            Inserts << ", ";
        }
        Inserts << "(" << characterID << ", " << cur.first << ", " << cur.second.grantDate << ", " << cur.second.visibilityFlags << ")";
    }

    if (!first) {
        Inserts << "ON DUPLICATE KEY UPDATE ";
        Inserts << "visibilityFlags=VALUES(visibilityFlags)";
        DBerror err;
        if (!sDatabase.RunQuery(err, Inserts.str().c_str()))
            _log(DATABASE__ERROR, "SaveCertificates - unable to save data - %s", err.c_str());
    }
    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CertificateMgrDB::UpdateCertificate	(	uint32	charID,
		uint32	certificateID,
		bool	pub = false
	)

Definition at line 83 of file CertificateMgrDB.cpp.

References _log, DBerror::c_str(), and sDatabase.

Referenced by Character::UpdateCertificate().

                                                                                         {
    DBerror err;
    if (!sDatabase.RunQuery( err,
        "UPDATE chrCertificates SET visibilityFlags = %u WHERE characterID = %u AND certificateID = %u", (pub ? 1 : 0), charID, certificateID)) {
        _log(DATABASE__ERROR, "Failed to insert certificates of character %u: %s", charID, err.c_str() );
    }
}

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