StandingDB Class Reference

#include "StandingDB.h"

Inheritance diagram for StandingDB:

Collaboration diagram for StandingDB:

Public Member Functions
PyRep *	GetCorpStandings (Client *pClient)
PyRep *	GetCharStandings (Client *pClient)
PyRep *	PrimeCharStandings (uint32 charID)
PyRep *	GetCharNPCStandings (uint32 charID)
PyRep *	GetStandingTransactions (Call_GetStandingTransactions &args)
PyRep *	GetStandingCompositions (uint32 fromID, uint32 toID)
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

Static Public Member Functions
static PyObjectEx *	GetFactionStandings ()
static float	GetStanding (uint32 fromID, uint32 toID)
static void	SetStanding (uint32 fromID, uint32 toID, float standing)
static void	UpdateStanding (uint32 fromID, uint32 toID, float standing)
static void	SaveStandingChanges (uint32 fromID, uint32 toID, uint16 eventType, float amount, std::string msg)
static PyRep *	GetMyStandings (uint32 charID)
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)

Additional Inherited Members
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 37 of file StandingDB.h.

Member Function Documentation

PyRep * StandingDB::GetCharNPCStandings

(

uint32

charID

)

Definition at line 86 of file StandingDB.cpp.

References DBResultToCRowset(), and sDatabase.

{
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT fromID, toID, standing FROM chrNPCStandings WHERE toID = %u", charID);
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * StandingDB::GetCharStandings

(

Client *

pClient

)

Definition at line 71 of file StandingDB.cpp.

References DBResultToCRowset(), Client::GetCharacterID(), and sDatabase.

{
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT fromID, toID, standing FROM repStandings WHERE toID = %u OR fromID = %u",
                       pClient->GetCharacterID(), pClient->GetCharacterID());
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * StandingDB::GetCorpStandings

(

Client *

pClient

)

Definition at line 79 of file StandingDB.cpp.

References DBResultToCRowset(), Client::GetCorporationID(), and sDatabase.

{
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT fromID, toID, standing FROM repStandings WHERE toID = %u OR fromID = %u", pClient->GetCorporationID(), pClient->GetCorporationID());
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyObjectEx * StandingDB::GetFactionStandings ( )

static

Definition at line 56 of file StandingDB.cpp.

References DBResultToCRowset(), and sDatabase.

Referenced by StandingMgr::Populate().

{
    // repFactions table is ONLY faction standings
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT fromID,toID,standing FROM repFactions");
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyRep * StandingDB::GetMyStandings ( uint32  charID )

static

Definition at line 64 of file StandingDB.cpp.

References DBResultToCRowset(), and sDatabase.

{
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT fromID, standing AS rank FROM repStandings WHERE toID = %u", charID);
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

float StandingDB::GetStanding ( uint32  fromID, uint32  toID  )

static

Definition at line 142 of file StandingDB.cpp.

References DBResultRow::GetFloat(), DBQueryResult::GetRow(), and sDatabase.

Referenced by Agent::CanUseAgent(), FactoryDB::GetAssemblyLineProperties(), Character::GetNPCCorpStanding(), ReprocessingServiceBound::GetStanding(), Character::GetStandingModified(), RamMethods::LinePermissionCheck(), and Agent::UpdateStandings().

{
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT standing FROM repStandings WHERE fromID=%u AND toID=%u", fromID, toID);
    DBResultRow row;
    if (res.GetRow(row))
    {
        return row.GetFloat(0);
    }
    else
    {
        return 0.0f;
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyRep * StandingDB::GetStandingCompositions	(	uint32	fromID,
		uint32	toID
	)

Definition at line 184 of file StandingDB.cpp.

References PyStatic.

{
    // ownerID, standing ...

    return PyStatic.NewNone();
}

PyRep * StandingDB::GetStandingTransactions

(

Call_GetStandingTransactions &

args

)

Todo:

update this for direction

Definition at line 112 of file StandingDB.cpp.

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

{
    //GetStandingTransactions(fromID, toID, direction, eventID, eventType, eventDateTime)
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
                            "SELECT"
                            "  eventID,"
                            "  eventTypeID,"
                            "  eventDateTime,"
                            "  fromID,"
                            "  toID,"
                            "  modification,"
                            "  originalFromID,"
                            "  originalToID,"
                            "  int_1,"
                            "  int_2,"
                            "  int_3,"
                            "  msg"
                            " FROM repStandingChanges"
                            " WHERE toID = %u AND fromID = %u",
                            args.toID, args.fromID))
    {
        codelog(SERVICE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * StandingDB::PrimeCharStandings

(

uint32

charID

)

Todo:

not sure about this yet.... wip ....not used?

Definition at line 94 of file StandingDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
                            "SELECT "
                            " itemID AS ownerID,"
                            " itemName AS ownerName,"
                            " typeID"
                            " FROM entity"
                            " WHERE itemID < 0"))
    {
        _log(DATABASE__ERROR, "Error in PrimeCharStandings query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

void StandingDB::SaveStandingChanges ( uint32  fromID, uint32  toID, uint16  eventType, float  amount, std::string  msg  )

static

Todo:

implement repStandingChanges after standing system is working

Definition at line 174 of file StandingDB.cpp.

References GetFileTimeNow(), and sDatabase.

Referenced by StandingMgr::UpdateStandings().

{
    /* eventTypeID,eventDateTime,fromID,toID,modification,originalFromID,originalToID,int_1,int_2,int_3,msg */
    DBerror err;
    sDatabase.RunQuery(err,
                       "INSERT INTO repStandingChanges (eventTypeID, eventDateTime, fromID, toID, modification, msg)"
                       " VALUES (%u, %f, %u, %u, %f, '%s' )",
                       eventType, GetFileTimeNow(), fromID, toID, amount, msg.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void StandingDB::SetStanding ( uint32  fromID, uint32  toID, float  standing  )

static

Definition at line 157 of file StandingDB.cpp.

References sDatabase.

Referenced by Character::SetStanding().

{
    DBerror err;
    sDatabase.RunQuery(err, "INSERT INTO repStandings (fromID, toID, standing) VALUES (%u,%u,%f)", fromID, toID, standing);
}

Here is the caller graph for this function:

void StandingDB::UpdateStanding ( uint32  fromID, uint32  toID, float  standing  )

static

Definition at line 163 of file StandingDB.cpp.

References sDatabase.

Referenced by StandingMgr::UpdateStandings().

{
    DBerror err;
    sDatabase.RunQuery(err,
                       "INSERT INTO repStandings (fromID, toID, standing)"
                       " VALUES (%u,%u,%f)"
                       " ON DUPLICATE KEY UPDATE standing = standing + %f",
                       fromID, toID, standing, standing);
}

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