CharacterDB Class Reference

#include "CharacterDB.h"

Inheritance diagram for CharacterDB:

Collaboration diagram for CharacterDB:

Public Member Functions
void	DeleteCharacter (uint32 charID)
PyRep *	GetCharacterList (uint32 accountID)
PyRep *	GetCharSelectInfo (uint32 charID)
void	SetAvatar (uint32 charID, PyRep *hairDarkness)
void	SetAvatarColors (uint32 charID, uint32 colorID, uint32 colorNameA, uint32 colorNameBC, double weight, double gloss)
void	SetAvatarModifiers (uint32 charID, PyRep *modifierLocationID, PyRep *paperdollResourceID, PyRep *paperdollResourceVariation)
void	SetAvatarSculpts (uint32 charID, PyRep *sculptLocationID, PyRep *weightUpDown, PyRep *weightLeftRight, PyRep *weightForwardBack)
void	SetPortraitInfo (uint32 charID, PortraitInfo &data)
PyRep *	GetCharPublicInfo (uint32 charID)
PyRep *	GetCharPublicInfo3 (uint32 charID)
PyRep *	GetCharPrivateInfo (uint32 charID)
PyRep *	GetOwnerNoteLabels (uint32 charID)
PyRep *	GetOwnerNote (uint32 charID, uint32 noteID)
uint32	PickAlternateShip (uint32 charID, uint32 locationID)
void	SetCurrentShip (uint32 charID, uint32 shipID)
void	SetCurrentPod (uint32 charID, uint32 podID)
bool	ChangeCloneType (uint32 charID, uint32 typeID)
bool	GetCharClones (uint32 charID, std::vector< uint32 > &into)
bool	GetActiveCloneType (uint32 charID, uint32 &typeID)
std::string	GetCharName (uint32 charID)
PyRep *	GetContacts (uint32 charID, bool blocked)
void	AddContact (uint32 ownerID, uint32 charID, int32 standing, bool inWatchlist)
void	UpdateContact (int32 standing, uint32 charID, uint32 ownerID)
void	RemoveContact (uint32 charID, uint32 ownerID)
void	SetBlockContact (uint32 charID, uint32 ownerID, bool blocked)
bool	GetCharItems (uint32 charID, std::vector< uint32 > &into)
bool	GetCareerBySchool (uint32 schoolID, uint8 &raceID, uint32 &careerID)
bool	GetCorporationBySchool (uint32 schoolID, uint32 &corporationID)
bool	GetLocationCorporationByCareer (CharacterData &cdata, uint32 &corporationID)
bool	DoesCorporationExist (uint32 corpID)
bool	GetAttributesFromAncestry (uint32 ancestryID, uint8 &intelligence, uint8 &charisma, uint8 &perception, uint8 &memory, uint8 &willpower)
bool	GetBaseSkills (std::map< uint32, uint8 > &into)
bool	GetSkillsByRace (uint32 raceID, std::map< uint32, uint8 > &into)
bool	GetSkillsByCareer (uint32 careerID, std::map< uint32, uint8 > &into)
PyString *	GetNote (uint32 ownerID, uint32 itemID)
bool	SetNote (uint32 ownerID, uint32 itemID, const char *str)
uint32	AddOwnerNote (uint32 charID, const std::string &label, const std::string &content)
bool	EditOwnerNote (uint32 charID, uint32 noteID, const std::string &label, const std::string &content)
int64	PrepareCharacterForDelete (uint32 accountID, uint32 charID)
void	CancelCharacterDeletePrepare (uint32 accountID, uint32 charID)
bool	ReportRespec (uint32 characterId)
PyRep *	GetRespecInfo (uint32 characterId)
bool	LoadSkillQueue (uint32 charID, SkillQueue &into)
bool	LoadPausedSkillQueue (uint32 charID, SkillQueue &into)
bool	SaveSkillQueue (uint32 charID, SkillQueue &queue)
bool	SavePausedSkillQueue (uint32 charID, SkillQueue &queue)
void	SaveSkillHistory (uint16 eventID, double logDate, uint32 characterID, uint32 skillTypeID, uint8 skillLevel, uint32 absolutePoints)
PyRep *	GetSkillHistory (uint32 charID)
void	UpdateSkillQueueEndTime (int64 endtime, uint32 charID)
void	SetLogInTime (uint32 charID)
void	SetLogOffTime (uint32 charID)
void	addOwnerCache (uint32 ownerID, std::string ownerName, uint32 typeID)
PyRep *	GetBounty (uint32 charID, uint32 ownerID)
PyRep *	GetTopBounties ()
void	AddBounty (uint32 charID, uint32 ownerID, uint32 amount)
PyRep *	GetKillOrLoss (uint32 charID)
PyRep *	GetLabels (uint32 charID)
void	SetLabel (uint32 charID, uint32 color, std::string name)
void	EditLabel (uint32 charID, uint32 labelID, uint32 color, std::string name)
void	DeleteLabel (uint32 charID, uint32 labelID)
void	VisitSystem (uint32 solarSystemID, uint32 charID)
void	ValidateCharName (std::string name)
PyRep *	ValidateCharNameRep (std::string name)
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

Static Public Member Functions
static uint32	NewCharacter (const CharacterData &data, const CorpData &corpData)
static bool	SaveCharacter (uint32 charID, const CharacterData &data)
static bool	SaveCorpData (uint32 charID, const CorpData &data)
static void	AddEmployment (uint32 charID, uint32 corpID, uint32 oldCorpID=0)
static void	GetCharacterData (uint32 charID, std::map< std::string, int64 > &characterDataMap)
static bool	GetCharHomeStation (uint32 charID, uint32 &stationID)
static bool	GetActiveCloneID (uint32 charID, uint32 &itemID)
static PyRep *	GetInfoWindowDataForChar (uint32 charID)
static uint32	GetStartingStationByCareer (uint32 careerID)
static PyRep *	List (uint32 ownerID)
static PyRep *	ListStations (uint32 ownerID, std::ostringstream &flagIDs, bool forCorp=false, bool bpOnly=false)
static PyRep *	ListStationItems (uint32 ownerID, uint32 stationID)
static PyRep *	ListStationBlueprintItems (uint32 ownerID, uint32 stationID, bool forCorp=false)
static bool	ChangeCloneLocation (uint32 charID, uint32 locationID)
static void	SetCorpRole (uint32 charID, int64 role)
static int64	GetCorpRole (uint32 charID)
static uint32	GetCorpID (uint32 charID)
static float	GetCorpTaxRate (uint32 charID)
static PyRep *	GetMyCorpMates (uint32 corpID)
static uint8	GetSkillLevel (uint32 charID, uint16 skillTypeID)
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 92 of file CharacterDB.h.

Member Function Documentation

void CharacterDB::AddBounty	(	uint32	charID,
		uint32	ownerID,
		uint32	amount
	)

Definition at line 1542 of file CharacterDB.cpp.

References sDatabase.

                                                                        {
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE chrCharacters SET bounty = bounty + %u WHERE characterID = %u", amount, charID);
    sDatabase.RunQuery(err,
        "INSERT INTO webBounties(characterID, ownerID, bounty, timePlaced)"
        " VALUES (%u, %u, %u, UNIX_TIMESTAMP(CURRENT_TIMESTAMP) )",
        charID, ownerID, amount );
}

void CharacterDB::AddContact	(	uint32	ownerID,
		uint32	charID,
		int32	standing,
		bool	inWatchlist
	)

Definition at line 682 of file CharacterDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err,
        "INSERT INTO chrContacts (ownerID, contactID, relationshipID, "
        " inWatchlist, labelMask, blocked) VALUES "
        " (%u, %u, %i, %i, 0, 0) ",
        ownerID, charID, standing, inWatchlist);
}

void CharacterDB::AddEmployment ( uint32  charID, uint32  corpID, uint32  oldCorpID = 0  )

static

Definition at line 373 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, GetFileTimeNow(), IsCorp, and sDatabase.

Referenced by Character::JoinCorporation(), and NewCharacter().

                                                                               {
    // Add new employment history record and update character's corp and start date   -allan  25Mar14
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "INSERT INTO chrEmployment"
        "  (characterID, corporationID, startDate, deleted)"
        " VALUES (%u, %u, %f, 0)", charID, corpID, GetFileTimeNow()))
    {
        codelog(DATABASE__ERROR, "Error in employment insert query: %s", err.c_str());
    }

    if (!sDatabase.RunQuery(err, "UPDATE chrCharacters SET startDateTime = %f, corporationID = %u WHERE characterID = %u", GetFileTimeNow(), corpID, charID))
        codelog(DATABASE__ERROR, "Error in character insert query: %s", err.c_str());

    // Decrease previous corp's member count
    if (IsCorp(oldCorpID))
        if (!sDatabase.RunQuery(err, "UPDATE crpCorporation SET memberCount = memberCount-1 WHERE corporationID = %u", oldCorpID))
            codelog(CORP__DB_ERROR, "Error in prev corp member decrease query: %s", err.c_str());

    // Increase new corp's member number...
    if (!sDatabase.RunQuery(err, "UPDATE crpCorporation SET memberCount = memberCount+1 WHERE corporationID = %u", corpID))
        codelog(CORP__DB_ERROR, "Error in new corp member increase query: %s", err.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::addOwnerCache	(	uint32	ownerID,
		std::string	ownerName,
		uint32	typeID
	)

Definition at line 1516 of file CharacterDB.cpp.

References DBerror::c_str(), sDatabase, and InventoryItem::typeID().

                                                                                  {
    DBerror err;
    sDatabase.RunQuery(err,
        "INSERT INTO cacheOwners(ownerID, ownerName, typeID)"
        " VALUES (%u, '%s', %u)",
        ownerID, ownerName.c_str(), typeID);
}

Here is the call graph for this function:

uint32 CharacterDB::AddOwnerNote	(	uint32	charID,
		const std::string &	label,
		const std::string &	content
	)

Definition at line 1243 of file CharacterDB.cpp.

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

                                                                                                  {
    DBerror err;
    uint32 id;
    std::string lblS;
    sDatabase.DoEscapeString(lblS, label);

    std::string contS;
    sDatabase.DoEscapeString(contS, content);

    if (!sDatabase.RunQueryLID(err, id,
        "INSERT INTO chrOwnerNote (ownerID, label, note) VALUES (%u, '%s', '%s');",
        charID, lblS.c_str(), contS.c_str()))
    {
        codelog(DATABASE__ERROR, "Error on query: %s", err.c_str());
        return 0;
    }

    return id;
}

Here is the call graph for this function:

void CharacterDB::CancelCharacterDeletePrepare	(	uint32	accountID,
		uint32	charID
	)

Definition at line 212 of file CharacterDB.cpp.

References _log, and sDatabase.

{
    DBerror error;
    uint32 affectedRows;
    sDatabase.RunQuery(error, affectedRows, "UPDATE chrCharacters SET deletePrepareDateTime = 0 WHERE accountID = %u AND characterID = %u", accountID, charID);
    if (affectedRows != 1)
        _log(CLIENT__ERROR, "Failed to cancel character deletion, affected rows: %u", affectedRows);
}

bool CharacterDB::ChangeCloneLocation ( uint32  charID, uint32  locationID  )

static

Definition at line 903 of file CharacterDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res.error, "UPDATE entity SET locationID=%u WHERE ownerID=%u AND flag=400", locationID, characterID)) {
        _log(DATABASE__ERROR, "Failed to change location of clone %u: %s.", characterID, res.error.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

bool CharacterDB::ChangeCloneType	(	uint32	charID,
		uint32	typeID
	)

Definition at line 863 of file CharacterDB.cpp.

References _log, DBerror::c_str(), DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetText(), sDatabase, and sLog.

Referenced by Character::ResetClone().

{
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT "
        " typeName "
        "FROM invTypes "
        "WHERE typeID = %u",
        typeID))
    {
        _log(DATABASE__ERROR, "Failed to change clone type of char %u: %s.", characterID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row))
    {
        sLog.Error( "CharacterDB::ChangeCloneType()", "Could not find Clone typeID = %u in invTypes table.", typeID );
        return false;
    }
    std::string typeNameString = row.GetText(0);

    if (!sDatabase.RunQuery(res.error,
        "UPDATE "
        "entity "
        "SET typeID=%u, itemName='%s' "
        "WHERE ownerID=%u "
        "AND flag=400",
        typeID,
        typeNameString.c_str(),
                           characterID))
    {
        _log(DATABASE__ERROR, "Failed to change clone type of char %u: %s.", characterID, res.error.c_str());
        return false;
    }
    sLog.Debug( "CharacterDB", "Clone upgrade successful" );
    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::DeleteCharacter

(

uint32

charID

)

0 matches in bounties 4 matches in channelChars 0 matches in chrOwnerNote 0 matches in ramJobs

Definition at line 129 of file CharacterDB.cpp.

References sDatabase.

Referenced by Character::Delete().

                                                    {
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM eveMailDetails"
                            " USING eveMail, eveMailDetails"
                            " WHERE eveMail.messageID = eveMailDetails.messageID"
                            " AND (senderID = %u OR channelID = %u)", characterID, characterID);
    sDatabase.RunQuery(err, "DELETE FROM eveMail WHERE (senderID = %u OR channelID = %u)", characterID, characterID);
    sDatabase.RunQuery(err, "DELETE FROM bookmarks WHERE ownerID = %u",  characterID);
    sDatabase.RunQuery(err, "DELETE FROM bookmarkFolders WHERE ownerID = %u",  characterID);
    //sDatabase.RunQuery(err, "DELETE FROM bookmarkVouchers WHERE ownerID = %u",  characterID);
    sDatabase.RunQuery(err, "DELETE FROM mktOrders WHERE ownerID = %u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM mktTransactions WHERE clientID = %u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM repStandings WHERE (fromID = %u OR toID = %u)", characterID, characterID);
    sDatabase.RunQuery(err, "DELETE FROM repStandingChanges WHERE (fromID = %u OR toID = %u)", characterID, characterID);
    sDatabase.RunQuery(err, "DELETE FROM chrCertificates WHERE characterID=%u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM chrCharacters WHERE characterID=%u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM chrEmployment WHERE characterID=%u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM jnlCharacters WHERE ownerID=%u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM crpShares WHERE shareholderID=%u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM chrSkillHistory WHERE characterID=%u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM chrSkillQueue WHERE characterID=%u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM crpApplications WHERE characterID=%u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM chrCharacterAttributes WHERE charID = %u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM chrPausedSkillQueue WHERE characterID = %u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM entity_attributes"
                            " WHERE itemID IN (SELECT itemID FROM entity WHERE ownerID = %u)", characterID);
    sDatabase.RunQuery(err, "DELETE FROM entity WHERE ownerID = %u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM avatar_colors WHERE charID = %u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM avatar_modifiers WHERE charID = %u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM avatar_sculpts WHERE charID = %u", characterID);
    sDatabase.RunQuery(err, "DELETE FROM avatars WHERE charID = %u", characterID);
}

Here is the caller graph for this function:

void CharacterDB::DeleteLabel	(	uint32	charID,
		uint32	labelID
	)

Definition at line 1359 of file CharacterDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err,"DELETE FROM chrLabels WHERE ownerID = %u AND labelID = %u", charID, labelID);
}

bool CharacterDB::DoesCorporationExist

(

uint32

corpID

)

Definition at line 1040 of file CharacterDB.cpp.

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

                                                    {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
     "SELECT "
     "  corporationID"
     " FROM crpCorporation"
     " WHERE corporationID = %u", corpID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    return (res.GetRowCount() != 0);
}

Here is the call graph for this function:

void CharacterDB::EditLabel	(	uint32	charID,
		uint32	labelID,
		uint32	color,
		std::string	name
	)

Definition at line 1330 of file CharacterDB.cpp.

References sDatabase.

{
    std::string eName;
    sDatabase.DoEscapeString(eName, name);

    DBQueryResult res;
    sDatabase.RunQuery(res, "UPDATE chrLabels SET color = %u, name = '%s' WHERE ownerID = %u AND labelID = %u", color, eName.c_str(), charID, labelID);
}

bool CharacterDB::EditOwnerNote	(	uint32	charID,
		uint32	noteID,
		const std::string &	label,
		const std::string &	content
	)

Definition at line 1263 of file CharacterDB.cpp.

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

                                                                                                                {
    DBerror err;
    std::string contS;
    sDatabase.DoEscapeString(contS, content);

    if (!sDatabase.RunQuery(err,
        "UPDATE chrOwnerNote SET note = '%s' WHERE ownerID = %u AND noteID = %u;",
        contS.c_str(), charID, noteID))
    {
        codelog(DATABASE__ERROR, "Error on query: %s", err.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

bool CharacterDB::GetActiveCloneID ( uint32  charID, uint32 &  itemID  )

static

Definition at line 792 of file CharacterDB.cpp.

References _log, DBerror::c_str(), DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

                                                                     {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT itemID"
        " FROM entity"
        " WHERE ownerID = %u"
        "  AND flag=400",
        characterID))
    {
        _log(DATABASE__ERROR, "Failed to query active clone of char %u: %s.", characterID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (res.GetRow(row)) {
        itemID=row.GetUInt(0);
    } else {
        return false;
    }
    return true;
}

Here is the call graph for this function:

bool CharacterDB::GetActiveCloneType	(	uint32	charID,
		uint32 &	typeID
	)

Definition at line 818 of file CharacterDB.cpp.

References _log, DBerror::c_str(), DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

                                                                       {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT typeID"
        " FROM entity"
        " WHERE ownerID = %u"
        "  AND flag=400",
        characterID))
    {
        _log(DATABASE__ERROR, "Failed to query active clone of char %u: %s.", characterID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (res.GetRow(row)) {
        typeID=row.GetUInt(0);
        return true;
    }

    typeID = 0;
    return false;
}

Here is the call graph for this function:

bool CharacterDB::GetAttributesFromAncestry	(	uint32	ancestryID,
		uint8 &	intelligence,
		uint8 &	charisma,
		uint8 &	perception,
		uint8 &	memory,
		uint8 &	willpower
	)

Obtains attribute bonuses for given ancestry.

Parameters

[in]	ancestryID	ID of ancestry.
[out]	intelligence	Bonus to intelligence.
[out]	charisma	Bonus to charisma.
[out]	perception	Bonus to perception.
[out]	memory	Bonus to memory.
[out]	willpower	Bonus to willpower.

Returns

True if operation succeeded, false if failed.

Definition at line 914 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

                                                                                                                                                       {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        " SELECT "
        "  intelligence, charisma, perception, memory, willpower "
        " FROM chrAncestries "
        " WHERE ancestryID = %u ", ancestryID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return (false);
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(DATABASE__ERROR, "Failed to find ancestry information for ancestry %u", ancestryID);
        return false;
    }

    intelligence += row.GetUInt(0);
    charisma += row.GetUInt(1);
    perception += row.GetUInt(2);
    memory += row.GetUInt(3);
    willpower += row.GetUInt(4);

    return (true);
}

Here is the call graph for this function:

bool CharacterDB::GetBaseSkills

(

std::map< uint32, uint8 > &

into

)

Definition at line 1135 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

                                                           {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT skillTypeID, level FROM sklBaseSkills"))  {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    DBResultRow row;
    while (res.GetRow(row))
        into[row.GetUInt(0)] = row.GetUInt(1);

    return true;
}

Here is the call graph for this function:

PyRep * CharacterDB::GetBounty	(	uint32	charID,
		uint32	ownerID
	)

Definition at line 1524 of file CharacterDB.cpp.

References DBResultToRowset(), and sDatabase.

                                                           {
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT characterID, bounty FROM webBounties WHERE characterID = %u OR ownerID = %u", charID, ownerID);
    return DBResultToRowset(res);
}

Here is the call graph for this function:

bool CharacterDB::GetCareerBySchool	(	uint32	schoolID,
		uint8 &	raceID,
		uint32 &	careerID
	)

Definition at line 942 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBResultRow::GetInt(), DBQueryResult::GetRow(), and sDatabase.

                                                                                    {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
     "SELECT raceID, careerID FROM careers WHERE schoolID = %u", schoolID))  {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(DATABASE__ERROR, "Failed to find matching career for school %u", schoolID);
        return false;
    }
    raceID = row.GetInt(0);
    careerID = row.GetInt(1);
    return true;
}

Here is the call graph for this function:

void CharacterDB::GetCharacterData ( uint32  charID, std::map< std::string, int64 > &  characterDataMap  )

static

Definition at line 508 of file CharacterDB.cpp.

References DBerror::c_str(), ItemData::customInfo, DBQueryResult::error, flagClone, GetCharHomeStation(), DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), itemCloneAlpha, sDatabase, sItemFactory, and sLog.

Referenced by CharUnboundMgrService::GetCharacterData(), and Client::InitSession().

                                                                                            {

    DBQueryResult res;
    DBResultRow row;

    if (!sDatabase.RunQuery(res,
        "SELECT "       // fixed DB Query   -allan 11Jan14      UD: 04Dec17
        "  ch.corporationID, "
        "  ch.stationID, "
        "  ch.solarSystemID, "
        "  ch.constellationID, "
        "  ch.regionID, "
        "  co.stationID, "  //5
        "  ch.corpRole, "
        "  ch.corpAccountKey, "
        "  ch.rolesAtAll, "
        "  ch.rolesAtBase, "
        "  ch.rolesAtHQ, "  //10
        "  ch.rolesAtOther, "
        "  ch.shipID, "
        "  ch.gender, "
        "  ch.bloodlineID, "
        "  ch.raceID, "     //15
        "  ch.locationID, "
        "  ch.baseID,"
        "  co.allianceID,"
        "  co.warFactionID,"
        "  ch.characterName"         //20
        " FROM chrCharacters AS ch"
        "    LEFT JOIN crpCorporation AS co USING (corporationID) "
        " WHERE characterID = %u", charID))
    {
        sLog.Error("CharacterDB::GetCharacterData()", "Failed to query HQ of character's %u corporation: %s.", charID, res.error.c_str());
    }

    if (!res.GetRow(row))
    {
        sLog.Error("CharacterDB::GetCharacterData()", "No valid rows were returned by the database query.");
        return;
    }

    characterDataMap["corporationID"] = row.GetUInt(0);
    characterDataMap["stationID"] = row.GetUInt(1);
    characterDataMap["solarSystemID"] = row.GetUInt(2);
    characterDataMap["constellationID"] = row.GetUInt(3);
    characterDataMap["regionID"] = row.GetUInt(4);
    characterDataMap["corporationHQ"] = row.GetUInt(5);
    characterDataMap["corpRole"] = row.GetInt64(6);
    characterDataMap["corpAccountKey"] = row.GetInt(7);
    characterDataMap["rolesAtAll"] = row.GetInt64(8);
    characterDataMap["rolesAtBase"] = row.GetInt64(9);
    characterDataMap["rolesAtHQ"] = row.GetInt64(10);
    characterDataMap["rolesAtOther"] = row.GetInt64(11);
    characterDataMap["shipID"] = row.GetUInt(12);
    characterDataMap["gender"] = row.GetInt(13);
    characterDataMap["bloodlineID"] = row.GetUInt(14);
    characterDataMap["raceID"] = row.GetUInt(15);
    characterDataMap["locationID"] = row.GetUInt(16);
    characterDataMap["baseID"] = row.GetInt(17);
    characterDataMap["allianceID"] = row.GetInt(18);
    characterDataMap["warFactionID"] = row.GetInt(19);

    uint32 stationID = row.GetInt(17);
    if (!CharacterDB::GetCharHomeStation(charID, stationID)) {
        ItemData iData( itemCloneAlpha, charID, stationID, flagClone, 1 );
        iData.customInfo="Active: ";
        iData.customInfo += row.GetText(20);
        iData.customInfo += "(";
        iData.customInfo += std::to_string(charID);
        iData.customInfo += ") {ud}";
        sItemFactory.SpawnItem( iData )->SaveItem();
    }
    characterDataMap["cloneStationID"] = stationID;
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyRep * CharacterDB::GetCharacterList

(

uint32

accountID

)

Definition at line 221 of file CharacterDB.cpp.

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

                                                     {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  characterID,"
        "  characterName,"
        "  deletePrepareDateTime,"
        "  gender,"
        "  typeID"
        " FROM chrCharacters"
        " WHERE accountID=%u", accountID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

bool CharacterDB::GetCharClones	(	uint32	charID,
		std::vector< uint32 > &	into
	)

Definition at line 777 of file CharacterDB.cpp.

References _log, DBerror::c_str(), DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

                                                                           {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT itemID FROM entity WHERE ownerID = %u AND flag='400'", characterID)) {
        _log(DATABASE__ERROR, "Failed to query clones of char %u: %s.", characterID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    while(res.GetRow(row))
        into.push_back(row.GetUInt(0));

    return true;
}

Here is the call graph for this function:

bool CharacterDB::GetCharHomeStation ( uint32  charID, uint32 &  stationID  )

static

Definition at line 843 of file CharacterDB.cpp.

References _log, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

Referenced by GetCharacterData().

                                                                          {
    DBQueryResult res;
    if ( !sDatabase.RunQuery(res,
        "SELECT locationID "
        " FROM entity"
        " WHERE ownerID = %u"
        "  AND flag=400",
        characterID ))
    {
        _log(CHARACTER__ERROR, "Could't get clone location for char %u", characterID );
        return false;
    }

    DBResultRow row;
    if (res.GetRow(row))
        stationID = row.GetUInt(0);
    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CharacterDB::GetCharItems	(	uint32	charID,
		std::vector< uint32 > &	into
	)

Definition at line 720 of file CharacterDB.cpp.

References _log, DBerror::c_str(), DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

                                                                          {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  itemID"
        " FROM entity"
        " WHERE ownerID = %u",
        characterID))
    {
        _log(DATABASE__ERROR, "Failed to query items of char %u: %s.", characterID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    while(res.GetRow(row))
        into.push_back(row.GetUInt(0));

    return true;
}

Here is the call graph for this function:

std::string CharacterDB::GetCharName

(

uint32

charID

)

Definition at line 650 of file CharacterDB.cpp.

References _log, DBerror::c_str(), codelog, DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetText(), and sDatabase.

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT characterName FROM chrCharacters WHERE characterID=%u", characterID)) {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return "";
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(DATABASE__MESSAGE, "Name not found for CharacterID %u.", characterID);
        return "";
    }

    return row.GetText(0);

}

Here is the call graph for this function:

PyRep * CharacterDB::GetCharPrivateInfo

(

uint32

charID

)

Definition at line 603 of file CharacterDB.cpp.

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

                                                    {
    // characterID, gender, raceID, bloodlineID, createDateTime
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  gender,"
        "  createDateTime,"
        "  raceID,"
        "  bloodlineID"
        " FROM chrCharacters "
        " WHERE characterID=%u", charID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    DBResultRow row;
    if (!res.GetRow(row))
        return nullptr;
    return DBRowToPackedRow(row);
}

Here is the call graph for this function:

PyRep * CharacterDB::GetCharPublicInfo

(

uint32

charID

)

Definition at line 466 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBRowToKeyVal(), DBQueryResult::error, DBQueryResult::GetRow(), IsAgent, sDatabase, and sLog.

                                                        {
    if (IsAgent(characterID)) {
        sLog.Error("CharacterDB::GetCharPublicInfo()", "Character %u is NPC.", characterID);
        return nullptr;
    }
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT "       // fixed DB Query   -allan 11Jan14   -update 20April16
        "  ch.typeID,"
        "  ch.characterName,"
        "  ch.corporationID,"
        "  ch.raceID,"
        "  ch.bloodlineID,"
        "  ch.ancestryID,"
        "  ch.careerID,"
        "  ch.schoolID,"
        "  cs.schoolNameID, "
        "  ch.careerSpecialityID,"
        "  ch.age,"
        "  ch.createDateTime,"
        "  ch.gender,"
        "  ch.characterID,"
        "  ch.description,"
        "  ch.startDateTime"
        " FROM chrCharacters AS ch"
        "  LEFT JOIN chrSchools AS cs USING (schoolID) "
        " WHERE ch.characterID=%u", characterID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(DATABASE__ERROR, "Error in GetCharPublicInfo query: no data for char %d", characterID);
        return nullptr;
    }

    return(DBRowToKeyVal(row));
}

Here is the call graph for this function:

PyRep * CharacterDB::GetCharPublicInfo3

(

uint32

charID

)

Definition at line 583 of file CharacterDB.cpp.

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

                                                    {
    // bounty, title, startDateTime, description, corporationID
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT "
        "  bounty,"
        "  title,"
        "  startDateTime,"
        "  description,"
        "  corporationID"
        " FROM chrCharacters "
        " WHERE characterID=%u", charID))
    {
        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 * CharacterDB::GetCharSelectInfo

(

uint32

charID

)

Todo:

need to make proper error here.

Todo:

not sure how to implement these yet...

Todo:

(allan) reset this once alliances are implemented (already in corpDB)

Todo:

(allan) this is alliance tickerName. reset this once alliances are implemented

Definition at line 397 of file CharacterDB.cpp.

References _log, DBerror::c_str(), codelog, DBResultToCRowset(), DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), PyStatic, and sDatabase.

                                                        {
    //  this shows char on select screen....fixed/updated  -allan 20Jan15
    std::string shipName = "My Ship";
    uint32 shipTypeID = 606;  //arbitrary default.

    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT itemName, typeID FROM entity WHERE itemID = (SELECT shipID FROM chrCharacters WHERE characterID = %u)", characterID)) {
        _log(CHARACTER__WARNING, "Unable to get current ship: %s", res.error.c_str());
    } else {
        DBResultRow row;
        // this causes blanks on char sel screen if there is no ship, or shipID is wrong.
        if (!res.GetRow(row))
            return PyStatic.NewNone();

        sDatabase.DoEscapeString(shipName, row.GetText(0));
        shipTypeID = row.GetUInt(1);
    }

    // these show on char portrait at top left on sel screen
    uint32 unreadMailCount = 0;
    uint32 upcomingEventCount = 0;
    uint32 unprocessedNotifications = 0;

    //res.Reset();
    if (!sDatabase.RunQuery(res,
        "SELECT " // fixed DB query per client code -allan 18Jan15
        "  %u AS unreadMailCount,"
        "  %u AS upcomingEventCount, "
        "  %u AS unprocessedNotifications, "
        "  characterID,"
        "  petitionMessage, "
        "  gender, "
        "  bloodlineID, "
        "  createDateTime, "    //this is char create date
        "  startDateTime, "     //this is char joined corp date
        "  corporationID, "
        "  0 AS worldSpaceID, " /* this gives "walking around in [station xxxx]" msgs on login screen when !=0 */
        "  stationID, "
        "  solarSystemID, "
        "  constellationID, "
        "  regionID, "
        "  0 AS allianceID, "       
        "  0 AS allianceMemberStartDate,"
        "  'none' AS shortName, "   
        "  bounty, "
        "  skillQueueEndTime, "
        "  skillPoints, "
        "  %u AS shipTypeID, "
        "  '%s' AS shipName, "
        "  securityRating, "
        "  title, "
        "  balance, "
        "  aurBalance, "
        "  15 AS daysLeft, "    /* this calls a subscription renewal warning on char select screen (see pic in gallery) when <= 10 */
        "  30 AS userType,"     /* 23 is trial acct.  30 is normal */
        "  paperDollState"      // used for re-customization.  see paperDollState:: in packet_types.h
        " FROM chrCharacters"
        " WHERE characterID=%u",
        unreadMailCount, upcomingEventCount, unprocessedNotifications,
        shipTypeID, shipName.c_str(), characterID))
    {
        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 * CharacterDB::GetContacts	(	uint32	charID,
		bool	blocked
	)

Definition at line 668 of file CharacterDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery( res,
        "SELECT contactID, inWatchlist, relationshipID, labelMask"
        " FROM chrContacts WHERE ownerID = %u and blocked = %u", charID, blocked))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToIndexRowset(res, "contactID");
}

Here is the call graph for this function:

uint32 CharacterDB::GetCorpID ( uint32  charID )

static

Definition at line 1619 of file CharacterDB.cpp.

References DBerror::c_str(), DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), sDatabase, and sLog.

Referenced by CorporationDB::MoveShares(), and AccountService::TranserFunds().

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT corporationID FROM chrCharacters WHERE characterID = %u", charID)) {
        sLog.Error("CharacterDB::GetCorpID()", "Failed to query corpID of character %u: %s.", charID, res.error.c_str());
        return 0;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        sLog.Error("CharacterDB::GetCorpID()", "No valid rows were returned by the database query.");
        return 0;
    }

    return row.GetUInt(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CharacterDB::GetCorporationBySchool	(	uint32	schoolID,
		uint32 &	corporationID
	)

Definition at line 960 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBResultRow::GetInt(), DBQueryResult::GetRow(), and sDatabase.

                                                                               {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res, "SELECT corporationID FROM chrSchools WHERE schoolID = %u", schoolID)) {
        codelog(DATABASE__ERROR, "Error in query: %S", res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(DATABASE__ERROR, "Failed to find matching corporation for school %u", schoolID);
        return false;
    }
    corporationID = row.GetInt(0);
    return true;
}

Here is the call graph for this function:

int64 CharacterDB::GetCorpRole ( uint32  charID )

static

Definition at line 1602 of file CharacterDB.cpp.

References DBerror::c_str(), DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), sDatabase, and sLog.

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT corpRole FROM chrCharacters WHERE characterID = %u", charID)) {
        sLog.Error("CharacterDB::GetCorpRole()", "Failed to query role of character %u: %s.", charID, res.error.c_str());
        return 0;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        sLog.Error("CharacterDB::GetCorpRole()", "No valid rows were returned by the database query.");
        return 0;
    }

    return row.GetUInt(0);
}

Here is the call graph for this function:

float CharacterDB::GetCorpTaxRate ( uint32  charID )

static

Definition at line 1636 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBResultRow::GetFloat(), DBQueryResult::GetRow(), and sDatabase.

Referenced by AccountService::TranserFunds().

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT taxRate FROM crpCorporation WHERE corporationID = (SELECT corporationID FROM chrCharacters WHERE characterID = %u)", charID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row))
        return 0.0f;

    return row.GetFloat(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyRep * CharacterDB::GetInfoWindowDataForChar ( uint32  charID )

static

Definition at line 625 of file CharacterDB.cpp.

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

                                                               {
    //corpID, allianceID, title
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT "
        "  ch.corporationID AS corpID,"
        "  co.allianceID,"
        "  ch.title"
        " FROM chrCharacters AS ch"
        "    LEFT JOIN crpCorporation AS co USING (corporationID)"
        " WHERE characterID=%u", characterID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(DATABASE__ERROR, "Expected at least one row when getting character corp info\n");
        return nullptr;
    }

    return DBRowToKeyVal(row);
}

Here is the call graph for this function:

PyRep * CharacterDB::GetKillOrLoss

(

uint32

charID

)

Definition at line 1551 of file CharacterDB.cpp.

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

                                               {
    /*
     *    def GetKillsRecentKills(self, num, startIndex):
     *        shipKills = sm.RemoteSvc('charMgr').GetRecentShipKillsAndLosses(num, startIndex)
     *        return [ k for k in shipKills if k.finalCharacterID == eve.session.charid ]
     *
     *    def GetKillsRecentLosses(self, num, startIndex):
     *        shipKills = sm.RemoteSvc('charMgr').GetRecentShipKillsAndLosses(num, startIndex)
     *        return [ k for k in shipKills if k.victimCharacterID == eve.session.charid ]
     */
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  killID,"
        "  solarSystemID,"
        "  victimCharacterID,"
        "  victimCorporationID,"
        "  victimAllianceID,"
        "  victimFactionID,"
        "  victimShipTypeID,"
        "  finalCharacterID,"
        "  finalCorporationID,"
        "  finalAllianceID,"
        "  finalFactionID,"
        "  finalShipTypeID,"
        "  finalWeaponTypeID,"
        "  killBlob,"
        "  killTime,"
        "  victimDamageTaken,"
        "  finalSecurityStatus,"
        "  finalDamageDone,"
        "  moonID"
        " FROM chrKillTable"
        " WHERE ((victimCharacterID = %u) OR (finalCharacterID = %u))", charID, charID))
        /* should we limit this? */
    {
        codelog(DATABASE__ERROR, "Error on query: %s", res.error.c_str());
        return nullptr;
    }

    _log(DATABASE__RESULTS, "GetKillOrLoss for %u returned %u items", charID, res.GetRowCount());

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CharacterDB::GetLabels

(

uint32

charID

)

Definition at line 1339 of file CharacterDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT labelID, color, name FROM chrLabels WHERE ownerID = %u", charID)) {
        codelog(DATABASE__ERROR, "Error on query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCIndexedRowset(res, "labelID");
}

Here is the call graph for this function:

bool CharacterDB::GetLocationCorporationByCareer	(	CharacterData &	cdata,
		uint32 &	corporationID
	)

Todo:

Here should come a call to Corp??::CharacterJoinToCorp or what the heck... for now we only put it there

Definition at line 980 of file CharacterDB.cpp.

References DBerror::c_str(), CharacterData::careerID, codelog, CharacterData::constellationID, DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), CharacterData::regionID, CharacterData::schoolID, sDatabase, CharacterData::solarSystemID, and CharacterData::stationID.

                                                                                            {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
     "SELECT "      // fixed DB Query   -allan 01/02/14  -UD 9Jul19
     "  cs.corporationID, "
     "  cs.schoolID, "
     "  co.stationID, "
     "  st.solarSystemID, "
     "  st.constellationID, "
     "  st.regionID "
     " FROM careers AS c"
     "    LEFT JOIN chrSchools AS cs USING (schoolID)"
     "    LEFT JOIN crpCorporation AS co ON cs.corporationID = co.corporationID"
     "    LEFT JOIN staStations AS st USING (stationID)"
     " WHERE c.careerID = %u", cdata.careerID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(DATABASE__ERROR, "Failed to find career %u", cdata.careerID);
        return false;
    }

    corporationID = row.GetUInt(0);
    cdata.schoolID = row.GetUInt(1);
    cdata.stationID = row.GetUInt(2);
    cdata.solarSystemID = row.GetUInt(3);
    cdata.constellationID = row.GetUInt(4);
    cdata.regionID = row.GetUInt(5);

    return true;
}

Here is the call graph for this function:

PyRep * CharacterDB::GetMyCorpMates ( uint32  corpID )

static

Definition at line 1653 of file CharacterDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT solarSystemID AS locationID, characterID FROM chrCharacters WHERE corporationID = %u", corpID)) {
        sLog.Error("CharacterDB::GetMyCorpMates()", "Failed to query corpMates for corpID %u: %s.", corpID, res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyString * CharacterDB::GetNote	(	uint32	ownerID,
		uint32	itemID
	)

Retrieves the character note from the database as a PyString pointer.

Author

LSMoura

Definition at line 1198 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetText(), and sDatabase.

                                                            {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT note FROM chrNotes WHERE ownerID = %u AND itemID = %u",  ownerID, itemID))  {
        codelog(DATABASE__ERROR, "Error on query: %s", res.error.c_str());
        return nullptr;
    }
    DBResultRow row;
    if (!res.GetRow(row))
        return nullptr;

    return (new PyString(row.GetText(0)));
}

Here is the call graph for this function:

PyRep * CharacterDB::GetOwnerNote	(	uint32	charID,
		uint32	noteID
	)

Definition at line 1290 of file CharacterDB.cpp.

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

                                                             {
    /*
                    [PyTuple 6 items]
                      [PyTuple 2 items]
                        [PyString "noteDate"]
                        [PyInt 64]
                      [PyTuple 2 items]
                        [PyString "typeID"]
                        [PyInt 2]
                      [PyTuple 2 items]
                        [PyString "referenceID"]
                        [PyInt 3]
                      [PyTuple 2 items]
                        [PyString "note"]
                        [PyInt 130]
                      [PyTuple 2 items]
                        [PyString "userID"]
                        [PyInt 3]
                      [PyTuple 2 items]
                        [PyString "label"]
                        [PyInt 130]
          [PyPackedRow 19 bytes]
            ["noteDate" => <129041092800000000> [FileTime]]
            ["typeID" => <1> [I2]]
            ["referenceID" => <1661059544> [I4]]
            ["note" => <1::F::0::Main|> [WStr]]
            ["userID" => <0> [I4]]
            ["label" => <S:Folders> [WStr]]
            */
    DBQueryResult res;

    if (!sDatabase.RunQuery(res, "SELECT note FROM chrOwnerNote WHERE ownerID = %u AND noteID = %u", charID, noteID))
    {
        codelog(DATABASE__ERROR, "Error on query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CharacterDB::GetOwnerNoteLabels

(

uint32

charID

)

Definition at line 1279 of file CharacterDB.cpp.

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

                                                    {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT noteID, label FROM chrOwnerNote WHERE ownerID = %u", charID))
    {
        codelog(DATABASE__ERROR, "Error on query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CharacterDB::GetRespecInfo

(

uint32

characterId

)

Definition at line 178 of file CharacterDB.cpp.

References DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), sDatabase, and PyDict::SetItemString().

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT freeRespecs, lastRespecDateTime, nextRespecDateTime FROM chrCharacters WHERE characterID = %u", characterId))
        return nullptr;
    DBResultRow row;
    if (!res.GetRow(row))
        return nullptr;

    PyDict* result = new PyDict();
    result->SetItemString( "freeRespecs", new PyInt( row.GetInt(0) ) );
    result->SetItemString( "lastRespecDate", new PyLong( row.GetInt64(1) ) );
    result->SetItemString( "nextTimedRespec", new PyLong( row.GetInt64(2) ) );

    return result;
}

Here is the call graph for this function:

PyRep * CharacterDB::GetSkillHistory

(

uint32

charID

)

Definition at line 1483 of file CharacterDB.cpp.

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

Referenced by Character::GetSkillHistory().

                                                      {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT logDate, eventTypeID, skillTypeID, absolutePoints"
        " FROM chrSkillHistory"
        " WHERE characterID = %u"
        " ORDER BY logDate DESC"
        " LIMIT 50",
        characterID )) {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

Here is the caller graph for this function:

uint8 CharacterDB::GetSkillLevel ( uint32  charID, uint16  skillTypeID  )

static

Definition at line 1877 of file CharacterDB.cpp.

References AttrSkillLevel, DBerror::c_str(), codelog, DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

Referenced by MarketMgr::ExecuteSellOrder().

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT valueInt FROM entity_attributes WHERE attributeID= %u AND itemID= "
        "(SELECT itemID FROM entity WHERE locationID = %u AND typeID = %u)",
        AttrSkillLevel, charID, skillTypeID))
    {
        codelog(SERVICE__ERROR, "Error in query: %s", res.error.c_str());
        return 0;
    }

    DBResultRow row;
    if (res.GetRow(row))
        return row.GetUInt(0);
    return 0;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CharacterDB::GetSkillsByCareer	(	uint32	careerID,
		std::map< uint32, uint8 > &	into
	)

Definition at line 1171 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

                                                                                {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT "
        "  skillTypeID, level"
        " FROM sklCareerSkills"
        " WHERE careerID = %u", careerID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    DBResultRow row;
    while (res.GetRow(row)) {
        if (into.find(row.GetUInt(0)) == into.end()) {
            into[row.GetUInt(0)] = row.GetUInt(1);
        } else {
            into[row.GetUInt(0)] += row.GetUInt(1);
        }
        //check to avoid more than 5 levels of a skill
        if (into[row.GetUInt(0)] > 5)
            into[row.GetUInt(0)] = 5;
    }

    return true;
}

Here is the call graph for this function:

bool CharacterDB::GetSkillsByRace	(	uint32	raceID,
		std::map< uint32, uint8 > &	into
	)

Definition at line 1149 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

                                                                            {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT skillTypeID, level FROM sklRaceSkills WHERE raceID = %u ", raceID)) {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    DBResultRow row;
    while (res.GetRow(row)) {
        if (into.find(row.GetUInt(0)) == into.end()) {
            into[row.GetUInt(0)] = row.GetUInt(1);
        } else {
            into[row.GetUInt(0)] += row.GetUInt(1);
        }
        //check to avoid more than 5 levels of a skill
        if (into[row.GetUInt(0)] > 5)
            into[row.GetUInt(0)] = 5;
    }

    return true;
}

Here is the call graph for this function:

uint32 CharacterDB::GetStartingStationByCareer ( uint32  careerID )

static

Definition at line 1016 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), and sDatabase.

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
                "SELECT "
                "  co.stationID"
                " FROM careers AS c"
                "    LEFT JOIN chrSchools AS cs USING (schoolID)"
                "    LEFT JOIN crpCorporation AS co ON cs.corporationID = co.corporationID"
                " WHERE c.careerID = %u", careerID))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
        return 0;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(DATABASE__ERROR, "Failed to find station for career %u", careerID);
        return 0;
    }

    return row.GetUInt(0);
}

Here is the call graph for this function:

PyRep * CharacterDB::GetTopBounties

(

)

Todo:

config variable?

Definition at line 1530 of file CharacterDB.cpp.

References DBResultToRowset(), and sDatabase.

                                   {
    DBQueryResult res;
    sDatabase.RunQuery(res,
                       "SELECT c.characterID, c.bounty, c.online, o.characterName AS ownerName"
                       " FROM webBounties AS b"
                       " LEFT JOIN chrCharacters AS c ON c.characterID = b.characterID"
                       " LEFT JOIN chrCharacters AS o ON o.characterID = b.ownerID"
                       " ORDER BY c.bounty DESC"
                       " LIMIT 10");    
    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * CharacterDB::List ( uint32  ownerID )

static

Definition at line 1674 of file CharacterDB.cpp.

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

{

    // maybe get all items owned by calling character?

    DBQueryResult res;
    if(!sDatabase.RunQuery(res,
        "SELECT "
        "  e.itemID, "
        "  e.itemName, "
        "  e.typeID, "
        "  e.ownerID, "
        "  e.locationID, "
        "  e.flag AS flagID, "
        "  e.quantity AS stacksize, "
        "  e.customInfo, "
        "  e.singleton, "
        "  g.categoryID, "
        "  g.groupID "
        "FROM entity AS e"
        "  LEFT JOIN invTypes USING (typeID)"
        "  LEFT JOIN invGroups AS g USING (groupID)"
        "WHERE e.ownerID=%u AND e.locationID < %u", ownerID, maxStation))
    {
        codelog(SERVICE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CharacterDB::ListStationBlueprintItems ( uint32  ownerID, uint32  stationID, bool  forCorp = false  )

static

Todo:

check into this to see if we're querying POS modules also(uk)

Definition at line 1806 of file CharacterDB.cpp.

References EVEDB::invCategories::Blueprint, DBerror::c_str(), codelog, DBResultToCRowset(), PyRep::Dump(), DBQueryResult::error, is_log_enabled, and sDatabase.

{
    DBQueryResult res;
    if (forCorp) {
        // do crazy shit here to get actual stationID/locationID of bp items in corp hangar
        if(!sDatabase.RunQuery(res,
            "SELECT "
            "  e.itemID, "
            "  e.itemName, "
            "  e.typeID, "
            "  e.ownerID, "
            "  o.stationID AS locationID, "
            "  e.flag AS flagID, "
            "  e.quantity AS stacksize, "
            //"  e.customInfo, "
            "  e.singleton, "
            //"  g.groupID, "
            //"  g.categoryID, "
            "  b.pLevel AS productivityLevel,"
            "  b.mLevel AS materialLevel,"
            "  b.copy,"
            "  b.runs AS licensedProductionRunsRemaining"
            " FROM entity AS e"
            "  LEFT JOIN invTypes USING (typeID)"
            "  LEFT JOIN invGroups AS g USING (groupID)"
            "  LEFT JOIN invBlueprints AS b USING (itemID)"
            "  LEFT JOIN staOffices as o ON e.locationID = o.itemID"
            " WHERE e.ownerID=%u AND o.stationID=%u AND g.categoryID = %u",
            ownerID, stationID, EVEDB::invCategories::Blueprint))
        {
            codelog(SERVICE__ERROR, "Error in query: %s", res.error.c_str());
            return nullptr;
        }
    } else {
        if(!sDatabase.RunQuery(res,
            "SELECT"
            "  e.itemID,"
            "  e.itemName,"
            "  e.typeID,"
            "  e.ownerID,"
            "  e.locationID,"
            "  e.flag AS flagID,"
            "  e.quantity AS stacksize,"
            "  e.customInfo,"
            "  e.singleton,"
            "  g.groupID,"
            "  g.categoryID,"
            "  b.pLevel AS productivityLevel,"
            "  b.mLevel AS materialLevel,"
            "  b.copy,"
            "  b.runs AS licensedProductionRunsRemaining"
            " FROM entity AS e"
            "  LEFT JOIN invTypes USING (typeID)"
            "  LEFT JOIN invGroups AS g USING (groupID)"
            "  LEFT JOIN invBlueprints AS b USING (itemID)"
            " WHERE e.ownerID=%u AND e.locationID=%u AND e.flag=4 AND g.categoryID = %u",
            ownerID, stationID, EVEDB::invCategories::Blueprint))
        {
            codelog(SERVICE__ERROR, "Error in query: %s", res.error.c_str());
            return nullptr;
        }

    }
    PyRep* rsp = DBResultToCRowset(res);
    if (is_log_enabled(CLIENT__RSP_DUMP))
        rsp->Dump(CLIENT__RSP_DUMP, "    ");
    return rsp;

}

Here is the call graph for this function:

PyRep * CharacterDB::ListStationItems ( uint32  ownerID, uint32  stationID  )

static

Todo:

check into this to see if we're querying POS modules also

Definition at line 1773 of file CharacterDB.cpp.

References DBerror::c_str(), codelog, DBResultToCRowset(), PyRep::Dump(), DBQueryResult::error, is_log_enabled, and sDatabase.

{
    // some code shows 'copy' field here (for corp bp)
    DBQueryResult res;
    if(!sDatabase.RunQuery(res,
        "SELECT "
        "  e.itemID, "
        "  e.itemName, "
        "  e.typeID, "
        "  e.ownerID, "
        "  e.locationID, "
        "  e.flag AS flagID, "
        "  e.quantity AS stacksize, "
        "  e.customInfo, "
        "  e.singleton, "
        "  g.categoryID, "
        "  g.groupID "
        "FROM entity AS e"
        "  LEFT JOIN invTypes USING (typeID)"
        "  LEFT JOIN invGroups AS g USING (groupID)"
        "WHERE e.ownerID=%u AND e.locationID=%u AND e.flag=4",
        ownerID, stationID))
    {
        codelog(SERVICE__ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    PyRep* rsp = DBResultToCRowset(res);
    if (is_log_enabled(CLIENT__RSP_DUMP))
        rsp->Dump(CLIENT__RSP_DUMP, "    ");
    return rsp;
}

Here is the call graph for this function:

PyRep * CharacterDB::ListStations ( uint32  ownerID, std::ostringstream &  flagIDs, bool  forCorp = false, bool  bpOnly = false  )

static

Todo:

check into this to see if we're querying POS modules(uk) also. if so, we'll need to revise location checks and somehow fix it so customs offices (and anything else using flagHangar) doesnt show up, which leads to elusive "AttributeError: 'NoneType' object has no attribute 'solarSystemID'" in client when locationID is NOT station

Todo:

these queries are wrong.... (location and maybe owner)

Definition at line 1705 of file CharacterDB.cpp.

References EVEDB::invCategories::Blueprint, DBerror::c_str(), codelog, DBResultToCRowset(), PyRep::Dump(), DBQueryResult::error, is_log_enabled, maxOffice, maxStation, minOffice, and sDatabase.

{

    DBQueryResult res;
    if (bpOnly) {
        if (forCorp) {
            // this is some funky shit to get correct stationID for corp bps in hangar, as their location is officeID, but we need stationID for this call
            if (!sDatabase.RunQuery(res,
                "SELECT o.stationID, COUNT(e.itemID) as blueprintCount"
                " FROM entity AS e"
                "  LEFT JOIN invTypes USING (typeID)"
                "  LEFT JOIN invGroups AS g USING (groupID)"
                "  LEFT JOIN staOffices as o ON o.itemID = e.locationID"
                " WHERE e.ownerID=%u AND e.flag IN (%s) AND g.categoryID = %u AND (e.locationID >= %u AND e.locationID <= %u)"
                " GROUP BY locationID", ownerID, flagIDs.str().c_str(), EVEDB::invCategories::Blueprint, minOffice, maxOffice))
            {
                codelog(SERVICE__ERROR, "Error in ListStations query: %s", res.error.c_str());
                return nullptr;
            }
        } else {
            if (!sDatabase.RunQuery(res,
                "SELECT e.locationID AS stationID, COUNT(e.itemID) as blueprintCount"
                " FROM entity AS e"
                "  LEFT JOIN invTypes USING (typeID)"
                "  LEFT JOIN invGroups AS g USING (groupID)"
                " WHERE e.ownerID=%u AND e.flag IN (%s) AND g.categoryID = %u AND e.locationID <= %u"
                " GROUP BY locationID", ownerID, flagIDs.str().c_str(), EVEDB::invCategories::Blueprint, maxStation))
            {
                codelog(SERVICE__ERROR, "Error in ListStations query: %s", res.error.c_str());
                return nullptr;
            }
        }
    } else {
        if (forCorp) {
            // this is some funky shit to get correct stationID for corp bps in hangar, as their location is officeID, but we need stationID for this call
            if (!sDatabase.RunQuery(res,
                "SELECT o.stationID, COUNT(e.itemID) as itemCount"
                " FROM entity AS e"
                "  LEFT JOIN staOffices as o ON o.itemID = e.locationID"
                " WHERE e.ownerID=%u AND e.flag IN (%s) AND (e.locationID >= %u AND e.locationID <= %u)"
                " GROUP BY locationID", ownerID, flagIDs.str().c_str(), minOffice, maxOffice))
            {
                codelog(SERVICE__ERROR, "Error in ListStations query: %s", res.error.c_str());
                return nullptr;
            }
        } else {
            if (!sDatabase.RunQuery(res,
                "SELECT locationID AS stationID, COUNT(itemID) as itemCount"
                " FROM entity WHERE ownerID=%u AND flag IN (%s) AND locationID <= %u"
                " GROUP BY locationID", ownerID, flagIDs.str().c_str(), maxStation))
            {
                codelog(SERVICE__ERROR, "Error in ListStations query: %s", res.error.c_str());
                return nullptr;
            }
        }
    }
    PyRep* rsp = DBResultToCRowset(res);
    if (is_log_enabled(CLIENT__RSP_DUMP))
        rsp->Dump(CLIENT__RSP_DUMP, "    ");
    return rsp;
}

Here is the call graph for this function:

bool CharacterDB::LoadPausedSkillQueue	(	uint32	charID,
		SkillQueue &	into
	)

Definition at line 1385 of file CharacterDB.cpp.

References _log, DBerror::c_str(), DBQueryResult::error, DBQueryResult::GetRow(), DBResultRow::GetUInt(), QueuedSkill::level, sDatabase, and QueuedSkill::typeID.

Referenced by Character::LoadPausedSkillQueue().

                                                                           {
    DBQueryResult res;
    if (!sDatabase.RunQuery( res, "SELECT typeID, level FROM chrPausedSkillQueue WHERE characterID = %u ORDER BY orderIndex ASC", characterID)) {
        _log(DATABASE__ERROR, "Failed to query paused skill queue of character %u: %s.", characterID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    while (res.GetRow(row)) {
        QueuedSkill qs = QueuedSkill();
            qs.typeID = row.GetUInt( 0 );
            qs.level = row.GetUInt( 1 );
        into.push_back( qs );
    }

    // delete paused queue, as subsequent presses of 'apply' button will add paused queue again, and again, etc...
    DBerror err;
    if (!sDatabase.RunQuery(err,"DELETE FROM chrPausedSkillQueue WHERE characterID = %u", characterID)) {
        _log(DATABASE__ERROR, "Failed to delete skill queue of character %u: %s.", characterID, err.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CharacterDB::LoadSkillQueue	(	uint32	charID,
		SkillQueue &	into
	)

Loads skill queue.

Parameters

[in]	charID	ID of character whose queue should be loaded.
[in]	into	SkillQueue into which loaded data should be stored.

Returns

True if load succeeds, false if fails.

Definition at line 1365 of file CharacterDB.cpp.

References _log, DBerror::c_str(), QueuedSkill::endTime, DBQueryResult::error, DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetUInt(), QueuedSkill::level, sDatabase, QueuedSkill::startTime, and QueuedSkill::typeID.

Referenced by Character::_Load().

                                                                     {
    DBQueryResult res;
    if (!sDatabase.RunQuery( res, "SELECT typeID, level, startTime, endTime FROM chrSkillQueue WHERE characterID = %u ORDER BY orderIndex ASC", characterID)) {
        _log(DATABASE__ERROR, "Failed to query skill queue of character %u: %s.", characterID, res.error.c_str());
        return false;
    }

    DBResultRow row;
    while (res.GetRow(row)) {
        QueuedSkill qs = QueuedSkill();
            qs.typeID = row.GetUInt(0);
            qs.level = row.GetUInt(1);
            qs.startTime = row.GetInt64(2);
            qs.endTime = row.GetInt64(3);
        into.push_back( qs );
    }

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

uint32 CharacterDB::NewCharacter ( const CharacterData &  data, const CorpData &  corpData  )

static

Definition at line 33 of file CharacterDB.cpp.

References CharacterData::accountID, AddEmployment(), CharacterData::ancestryID, CharacterData::aurBalance, CharacterData::balance, CorpData::baseID, CharacterData::bloodlineID, DBerror::c_str(), CharacterData::careerID, CharacterData::careerSpecialityID, codelog, CharacterData::constellationID, CorpData::corpAccountKey, CorpData::corporationID, CharacterData::description, CharacterData::gender, GetFileTimeNow(), CharacterData::locationID, CharacterData::name, CharacterData::raceID, CharacterData::regionID, CharacterData::schoolID, sDatabase, CharacterData::solarSystemID, CharacterData::stationID, CharacterData::title, and CharacterData::typeID.

Referenced by Character::Spawn().

                                                                                    {
    DBerror err;
    std::string nameEsc, titleEsc, descriptionEsc;
    sDatabase.DoEscapeString(nameEsc, data.name);
    sDatabase.DoEscapeString(titleEsc, data.title);
    sDatabase.DoEscapeString(descriptionEsc, data.description);

    uint32 charID = 0;
    if (!sDatabase.RunQueryLID(err, charID,
        "INSERT INTO chrCharacters"
        "  (accountID, characterName, typeID, locationID, description, balance, aurBalance,"
        "   logonDateTime, baseID, corpAccountKey, createDateTime, title,"
        "   ancestryID, bloodlineID, raceID, careerID, schoolID, careerSpecialityID, gender,"
        "   stationID, solarSystemID, constellationID, regionID, freeRespecs)"
        " VALUES"
        "  (%u,'%s', %u, %u, '%s', %f, %f,"
        "   %f, %u, %u, %f, '%s',"
        "   %u, %u, %u, %u, %u, %u, %u,"
        "   %u, %u, %u, %u, 2)",
        data.accountID, nameEsc.c_str(), data.typeID, data.locationID, descriptionEsc.c_str(), data.balance, data.aurBalance,
        GetFileTimeNow(), corpData.baseID, corpData.corpAccountKey, GetFileTimeNow(), titleEsc.c_str(),
        data.ancestryID, data.bloodlineID, data.raceID, data.careerID, data.schoolID, data.careerSpecialityID, data.gender,
        data.stationID, data.solarSystemID, data.constellationID, data.regionID))
    {
        codelog(DATABASE__ERROR, "Failed to insert character %s.", err.c_str());
        return 0;
    }

    AddEmployment(charID, corpData.corporationID);

    return charID;
}

Here is the call graph for this function:

Here is the caller graph for this function:

uint32 CharacterDB::PickAlternateShip	(	uint32	charID,
		uint32	locationID
	)

Definition at line 741 of file CharacterDB.cpp.

References DBQueryResult::GetRow(), DBResultRow::GetUInt(), sDatabase, and EVEDB::invCategories::Ship.

Referenced by Character::PickAlternateShip().

{   // this picks first ship that db finds belonging to charID in locationID
    DBQueryResult res;
    sDatabase.RunQuery(res,
        "SELECT e.itemID"
        " FROM entity AS e"
        "  LEFT JOIN invTypes USING (typeID)"
        "  LEFT JOIN invGroups USING (groupID)"
        " WHERE e.ownerID = %u"
        "  AND locationID = %u"
        "  AND categoryID = %u"
        "  LIMIT 1", charID, locationID, EVEDB::invCategories::Ship);

    DBResultRow row;
    if (res.GetRow(row)) {
        return row.GetUInt(0);
    } else {
        return 0;
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

int64 CharacterDB::PrepareCharacterForDelete	(	uint32	accountID,
		uint32	charID
	)

Definition at line 195 of file CharacterDB.cpp.

References GetFileTimeNow(), sConfig, sDatabase, and EvE::Time::Second.

{
    // calculate the point in time from which this character may be deleted
    int64 deleteTime = GetFileTimeNow() + (EvE::Time::Second * sConfig.character.terminationDelay);

    // note: the queries relating to character deletion have been specifically designed to avoid wreaking havoc when used by a malicious client
    // the client can't lie to us about accountID, only charID

    DBerror error;
    uint32 affectedRows;
    sDatabase.RunQuery(error, affectedRows, "UPDATE chrCharacters SET deletePrepareDateTime = %li WHERE accountID = %u AND characterID = %u", deleteTime, accountID, charID);
    if (affectedRows != 1)
        return 0;

    return deleteTime;
}

Here is the call graph for this function:

void CharacterDB::RemoveContact	(	uint32	charID,
		uint32	ownerID
	)

Definition at line 710 of file CharacterDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err,
        "DELETE from chrContacts "
        " WHERE contactID=%u AND ownerID=%u ",
         charID, ownerID);
}

bool CharacterDB::ReportRespec

(

uint32

characterId

)

Definition at line 169 of file CharacterDB.cpp.

References GetFileTimeNow(), EvE::Time::Month, and sDatabase.

{
    DBerror error;
    if (!sDatabase.RunQuery(error, "UPDATE chrCharacters SET freeRespecs = freeRespecs - 1, lastRespecDateTime = %f, nextRespecDateTime = %li WHERE characterId = %u",
        GetFileTimeNow(), (GetFileTimeNow() + EvE::Time::Month *3), characterId))
        return false;
    return true;
}

Here is the call graph for this function:

bool CharacterDB::SaveCharacter ( uint32  charID, const CharacterData &  data  )

static

Definition at line 66 of file CharacterDB.cpp.

References CharacterData::aurBalance, CharacterData::balance, CharacterData::bounty, DBerror::c_str(), codelog, CharacterData::constellationID, CharacterData::description, CharacterData::locationID, CharacterData::logonMinutes, CharacterData::regionID, sDatabase, CharacterData::securityRating, CharacterData::skillPoints, CharacterData::solarSystemID, CharacterData::stationID, and CharacterData::title.

Referenced by Character::SaveCharacter().

                                                                             {
    DBerror err;

    std::string titleEsc, descriptionEsc;
    sDatabase.DoEscapeString(titleEsc, data.title);
    sDatabase.DoEscapeString(descriptionEsc, data.description);

    if (!sDatabase.RunQuery(err,
        "UPDATE chrCharacters"
        " SET"
        "  title = '%s',"
        "  description = '%s',"
        "  bounty = %f,"
        "  balance = %f,"
        "  aurBalance = %f,"
        "  securityRating = %f,"
        "  logonMinutes = %u,"
        "  skillPoints = %u,"
        "  locationID = %u,"
        "  stationID = %u,"
        "  solarSystemID = %u,"
        "  constellationID = %u,"
        "  regionID = %u"
        " WHERE characterID = %u",
            titleEsc.c_str(), descriptionEsc.c_str(), data.bounty, data.balance, data.aurBalance, data.securityRating, data.logonMinutes,
            data.skillPoints, data.locationID, data.stationID, data.solarSystemID, data.constellationID, data.regionID, characterID))
    {
        codelog(DATABASE__ERROR, "Failed to save character %u: %s.", characterID, err.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CharacterDB::SaveCorpData ( uint32  charID, const CorpData &  data  )

static

Definition at line 100 of file CharacterDB.cpp.

References CorpData::baseID, DBerror::c_str(), codelog, CorpData::corpAccountKey, CorpData::corporationID, CorpData::corpRole, CorpData::grantableRoles, CorpData::grantableRolesAtBase, CorpData::grantableRolesAtHQ, CorpData::grantableRolesAtOther, PRIi64, CorpData::rolesAtAll, CorpData::rolesAtBase, CorpData::rolesAtHQ, CorpData::rolesAtOther, and sDatabase.

Referenced by Character::JoinCorporation(), Character::SaveFullCharacter(), Character::SetAccountKey(), and Character::SetBaseID().

                                                                       {
    DBerror err;

    if (!sDatabase.RunQuery(err,
        "UPDATE chrCharacters"
        " SET"
        "  corporationID = %u, "
        "  baseID = %u,"
        "  corpRole = %li,"
        "  corpAccountKey = %i,"
        "  rolesAtAll = %li,"
        "  rolesAtBase = %li,"
        "  rolesAtHQ = %li,"
        "  rolesAtOther = %li,"
        "  grantableRoles = %li,"
        "  grantableRolesAtBase = %li,"
        "  grantableRolesAtHQ = %li,"
        "  grantableRolesAtOther = %" PRIi64
        " WHERE characterID = %u",
        data.corporationID, data.baseID, data.corpRole, data.corpAccountKey, data.rolesAtAll, data.rolesAtBase, data.rolesAtHQ, data.rolesAtOther,
        data.grantableRoles, data.grantableRolesAtBase, data.grantableRolesAtHQ, data.grantableRolesAtOther, characterID))
    {
        codelog(DATABASE__ERROR, "Failed to update corp member info of character %u: %s.", characterID, err.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CharacterDB::SavePausedSkillQueue	(	uint32	charID,
		SkillQueue &	queue
	)

Definition at line 1442 of file CharacterDB.cpp.

References _log, DBerror::c_str(), QueuedSkill::level, sDatabase, snprintf, and QueuedSkill::typeID.

Referenced by Character::PauseSkillQueue().

                                                                           {
    DBerror err;
    if (!sDatabase.RunQuery(err, "DELETE FROM chrPausedSkillQueue WHERE characterID = %u", characterID)) {
        _log(DATABASE__ERROR, "Failed to delete paused skill queue of character %u: %s.", characterID, err.c_str());
        return false;
    }

    if (data.empty())
        return true;

    std::string query;

    for (uint8 i = 0; i < data.size(); i++) {
        const QueuedSkill &qs = data[ i ];
        char buf[ 30 ];
        snprintf( buf, sizeof(buf), "(%u, %u, %u, %u)", characterID, i, qs.typeID, qs.level );

        if (i > 0)
            query += ',';
        query += buf;
    }

    if ( !sDatabase.RunQuery( err,
        "INSERT INTO chrPausedSkillQueue (characterID, orderIndex, typeID, level)"
        " VALUES %s",query.c_str()))
    {
        _log(DATABASE__ERROR, "SavePausedSkillQueue - unable to save data - %s", err.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::SaveSkillHistory	(	uint16	eventID,
		double	logDate,
		uint32	characterID,
		uint32	skillTypeID,
		uint8	skillLevel,
		uint32	absolutePoints
	)

Definition at line 1475 of file CharacterDB.cpp.

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

Referenced by Character::SaveSkillHistory().

                                                                                                                                                  {
    DBerror err;
    if ( !sDatabase.RunQuery( err,
        "INSERT INTO chrSkillHistory (eventTypeID, logDate, characterID, skillTypeID, skillLevel, absolutePoints)"
        " VALUES (%u, %f, %u, %u, %u, %u)", eventID, logDate, characterID, skillTypeID, skillLevel, absolutePoints ))
            _log(DATABASE__ERROR, "Failed to set chrSkillHistory for character %u: %s", characterID, err.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CharacterDB::SaveSkillQueue	(	uint32	charID,
		SkillQueue &	queue
	)

Saves skill queue.

Parameters

[in]	charID	ID of character whose skill queue is saved.
[in]	queue	Queue to save.

Returns

True if save succeeds, false if fails.

Definition at line 1410 of file CharacterDB.cpp.

References _log, DBerror::c_str(), QueuedSkill::endTime, QueuedSkill::level, sDatabase, snprintf, QueuedSkill::startTime, and QueuedSkill::typeID.

Referenced by Character::SaveSkillQueue().

                                                                     {
    DBerror err;
    if (!sDatabase.RunQuery(err, "DELETE FROM chrSkillQueue WHERE characterID = %u", characterID)) {
        _log(DATABASE__ERROR, "Failed to delete skill queue of character %u: %s.", characterID, err.c_str());
        return false;
    }

    if (data.empty())
        return true;

    std::string query;

    for (uint8 i = 0; i < data.size(); i++) {
        const QueuedSkill &qs = data[ i ];
        char buf[ 80 ];
        snprintf( buf, sizeof(buf), "(%u, %u, %u, %u, %li, %li)", characterID, i, qs.typeID, qs.level, qs.startTime, qs.endTime );

        if (i > 0)
            query += ',';
        query += buf;
    }

    if ( !sDatabase.RunQuery( err,
        "INSERT INTO chrSkillQueue (characterID, orderIndex, typeID, level, startTime, endTime)"
        " VALUES %s",query.c_str()))
    {
        _log(DATABASE__ERROR, "SaveSkillQueue - unable to save data - %s", err.c_str());
        return false;
    }
    return true;
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::SetAvatar	(	uint32	charID,
		PyRep *	hairDarkness
	)

Definition at line 1055 of file CharacterDB.cpp.

References PyRep::AsFloat(), DBerror::c_str(), codelog, sDatabase, and PyFloat::value().

Referenced by CharacterAppearance::Build().

                                                              {
    //populate the DB with avatar information
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "INSERT INTO avatars (charID, hairDarkness)"
        " VALUES (%u, %f)",
        charID, hairDarkness->AsFloat()->value()))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::SetAvatarColors	(	uint32	charID,
		uint32	colorID,
		uint32	colorNameA,
		uint32	colorNameBC,
		double	weight,
		double	gloss
	)

Definition at line 1067 of file CharacterDB.cpp.

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

Referenced by CharacterAppearance::Build().

                                                                                                                                   {
    //add avatar colors to the DB
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "INSERT INTO avatar_colors (charID, colorID, colorNameA, colorNameBC, weight, gloss)"
        " VALUES (%u, %u, %u, %u, %f, %f)",
        charID, colorID, colorNameA, colorNameBC, weight, gloss))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::SetAvatarModifiers	(	uint32	charID,
		PyRep *	modifierLocationID,
		PyRep *	paperdollResourceID,
		PyRep *	paperdollResourceVariation
	)

Definition at line 1079 of file CharacterDB.cpp.

References PyRep::AsInt(), DBerror::c_str(), codelog, PyRep::IsInt(), sDatabase, and PyInt::value().

Referenced by CharacterAppearance::Build().

                                                                                                                                             {
    //add avatar modifiers to the DB
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "INSERT INTO avatar_modifiers (charID, modifierLocationID, paperdollResourceID, paperdollResourceVariation)"
        " VALUES (%u, %u, %u, %u)",
        charID,
        modifierLocationID->AsInt()->value(),
        paperdollResourceID->AsInt()->value(),
        paperdollResourceVariation->IsInt() ? paperdollResourceVariation->AsInt()->value() : 0 ))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::SetAvatarSculpts	(	uint32	charID,
		PyRep *	sculptLocationID,
		PyRep *	weightUpDown,
		PyRep *	weightLeftRight,
		PyRep *	weightForwardBack
	)

Definition at line 1094 of file CharacterDB.cpp.

References PyRep::AsFloat(), PyRep::AsInt(), DBerror::c_str(), codelog, PyRep::IsFloat(), sDatabase, PyInt::value(), and PyFloat::value().

Referenced by CharacterAppearance::Build().

                                                                                                                                                {
    //add avatar sculpts to the DB
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "INSERT INTO avatar_sculpts (charID, sculptLocationID, weightUpDown, weightLeftRight, weightForwardBack)"
        " VALUES (%u, %u, %f, %f, %f)",
        charID,
        sculptLocationID->AsInt()->value(),
        weightUpDown->IsFloat() ? weightUpDown->AsFloat()->value() : 0.0,
        weightLeftRight->IsFloat() ? weightLeftRight->AsFloat()->value() : 0.0,
        weightForwardBack->IsFloat() ? weightForwardBack->AsFloat()->value() : 0.0))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::SetBlockContact	(	uint32	charID,
		uint32	ownerID,
		bool	blocked
	)

Definition at line 701 of file CharacterDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err,
        "UPDATE chrContacts SET blocked=%u "
        " WHERE contactID=%u AND ownerID=%u ",
        blocked, charID, ownerID);
}

void CharacterDB::SetCorpRole ( uint32  charID, int64  role  )

static

Definition at line 1596 of file CharacterDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE chrCharacters SET corpRole = %li WHERE characterID = %u", role, charID);
}

void CharacterDB::SetCurrentPod	(	uint32	charID,
		uint32	podID
	)

Definition at line 769 of file CharacterDB.cpp.

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

Referenced by Character::SetActivePod().

{
    DBerror err;
    if (!sDatabase.RunQuery(err, "UPDATE chrCharacters SET capsuleID = %u WHERE characterID = %u", podID, charID))
        _log(DATABASE__ERROR, "Failed to save pod %u for character %u: %s.", podID, charID, err.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::SetCurrentShip	(	uint32	charID,
		uint32	shipID
	)

Definition at line 762 of file CharacterDB.cpp.

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

Referenced by Character::SetActiveShip().

{
    DBerror err;
    if (!sDatabase.RunQuery(err, "UPDATE chrCharacters SET shipID = %u WHERE characterID = %u", shipID, charID))
        _log(DATABASE__ERROR, "Failed to save ship %u for character %u: %s.", shipID, charID, err.c_str());
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::SetLabel	(	uint32	charID,
		uint32	color,
		std::string	name
	)

Definition at line 1350 of file CharacterDB.cpp.

References sDatabase.

{
    std::string eName;
    sDatabase.DoEscapeString(eName, name);

    DBQueryResult res;
    sDatabase.RunQuery(res, "INSERT INTO chrLabels (color, name, ownerID) VALUES (%u, '%s', %u)", color, eName.c_str(), charID);
}

void CharacterDB::SetLogInTime

(

uint32

charID

)

Definition at line 1504 of file CharacterDB.cpp.

References GetFileTimeNow(), and sDatabase.

Referenced by Character::SetLoginTime().

{
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE chrCharacters SET logonDateTime = %f WHERE characterID = %u", GetFileTimeNow(), charID );
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::SetLogOffTime

(

uint32

charID

)

Definition at line 1510 of file CharacterDB.cpp.

References GetFileTimeNow(), and sDatabase.

Referenced by Character::LogOut().

{
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE chrCharacters SET logoffDateTime = %f WHERE characterID = %u", GetFileTimeNow(), charID );
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CharacterDB::SetNote	(	uint32	ownerID,
		uint32	itemID,
		const char *	str
	)

Stores the character note on the database, given the ownerID and itemID and the string itself.

If the String is null or size zero, the entry is removed from the database.

Returns

boolean true if success.

Author

LSMoura

Definition at line 1211 of file CharacterDB.cpp.

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

                                                                        {
    DBerror err;
    if (str[0] == '\0') {
        // str is empty
        if (!sDatabase.RunQuery(err,
            "DELETE FROM chrNotes "
            " WHERE itemID = %u AND ownerID = %u LIMIT 1",
             itemID, ownerID)
            )
        {
            codelog(DATABASE__ERROR, "Error on query: %s", err.c_str());
            return false;
        }
    } else {
        // escape it before insertion
        std::string escaped;
        sDatabase.DoEscapeString(escaped, str);

        if (!sDatabase.RunQuery(err,
            "REPLACE INTO chrNotes ( ownerID, itemID, note)"
            " VALUES (%u, %u, '%s')",
            ownerID, itemID, escaped.c_str())
            )
        {
            codelog(DATABASE__ERROR, "Error on query: %s", err.c_str());
            return false;
        }
    }

    return true;
}

Here is the call graph for this function:

void CharacterDB::SetPortraitInfo	(	uint32	charID,
		PortraitInfo &	data
	)

Definition at line 1110 of file CharacterDB.cpp.

References PortraitInfo::backgroundID, PortraitInfo::browLeftCurl, PortraitInfo::browLeftTighten, PortraitInfo::browLeftUpDown, PortraitInfo::browRightCurl, PortraitInfo::browRightTighten, PortraitInfo::browRightUpDown, DBerror::c_str(), PortraitInfo::cameraFieldOfView, PortraitInfo::cameraPoiX, PortraitInfo::cameraPoiY, PortraitInfo::cameraPoiZ, PortraitInfo::cameraX, PortraitInfo::cameraY, PortraitInfo::cameraZ, codelog, PortraitInfo::eyeClose, PortraitInfo::eyesLookHorizontal, PortraitInfo::eyesLookVertical, PortraitInfo::frownLeft, PortraitInfo::frownRight, PortraitInfo::headLookTargetX, PortraitInfo::headLookTargetY, PortraitInfo::headLookTargetZ, PortraitInfo::headTilt, PortraitInfo::jawSideways, PortraitInfo::jawUp, PortraitInfo::lightColorID, PortraitInfo::lightID, PortraitInfo::lightIntensity, PortraitInfo::orientChar, PortraitInfo::portraitPoseNumber, PortraitInfo::puckerLips, sDatabase, PortraitInfo::smileLeft, PortraitInfo::smileRight, PortraitInfo::squintLeft, and PortraitInfo::squintRight.

Referenced by CharacterPortrait::Build().

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
        "INSERT INTO chrPortraitData "
        " (charID, backgroundID, lightID, lightColorID, cameraX, cameraY, cameraZ, cameraPoiX, cameraPoiY, cameraPoiZ,"
        " headLookTargetX, headLookTargetY, headLookTargetZ, lightIntensity, headTilt, orientChar, browLeftCurl, browLeftTighten,"
        " browLeftUpDown, browRightCurl, browRightTighten, browRightUpDown, eyeClose, eyesLookVertical, eyesLookHorizontal,"
        " squintLeft, squintRight, jawSideways, jawUp, puckerLips, frownLeft, frownRight, smileLeft, smileRight, "
        " cameraFieldOfView, portraitPoseNumber) VALUES"
        " (%u,%u,%u,%u,%f,%f,%f,%f,%f,%f,"
        " %f,%f,%f,%f,%f,%f,%f,%f,"
        " %f,%f,%f,%f,%f,%f,%f,"
        " %f,%f,%f,%f,%f,%f,%f,%f,%f,"
        " %f,%f)",
        charID, data.backgroundID, data.lightID, data.lightColorID, data.cameraX, data.cameraY, data.cameraZ, data.cameraPoiX, data.cameraPoiY, data.cameraPoiZ,
        data.headLookTargetX, data.headLookTargetY, data.headLookTargetZ, data.lightIntensity, data.headTilt, data.orientChar, data.browLeftCurl, data.browLeftTighten,
        data.browLeftUpDown, data.browRightCurl, data.browRightTighten, data.browRightUpDown, data.eyeClose, data.eyesLookVertical, data.eyesLookHorizontal,
        data.squintLeft, data.squintRight, data.jawSideways, data.jawUp, data.puckerLips, data.frownLeft, data.frownRight, data.smileLeft, data.smileRight,
        data.cameraFieldOfView, data.portraitPoseNumber))
    {
        codelog(DATABASE__ERROR, "Error in query: %s", err.c_str());
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void CharacterDB::UpdateContact	(	int32	standing,
		uint32	charID,
		uint32	ownerID
	)

Definition at line 692 of file CharacterDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err,
        "UPDATE chrContacts SET relationshipID=%i "
        " WHERE contactID=%u AND ownerID=%u ",
         standing, charID, ownerID);
}

void CharacterDB::UpdateSkillQueueEndTime	(	int64	endtime,
		uint32	charID
	)

Definition at line 1499 of file CharacterDB.cpp.

References sDatabase.

Referenced by Character::UpdateSkillQueueEndTime().

                                                                      {
    DBerror err;
    sDatabase.RunQuery( err, "UPDATE chrCharacters SET skillQueueEndTime = %li WHERE characterID = %u ", endtime, charID );
}

Here is the caller graph for this function:

void CharacterDB::ValidateCharName

(

std::string

name

)

Todo:

this should throw on error

Definition at line 295 of file CharacterDB.cpp.

References badChars, badWords, DBQueryResult::GetRowCount(), EvE::icontains(), and sDatabase.

{
    /* {'messageKey': 'CharNameInvalid', 'dataID': 17885077, 'suppressable': False, 'bodyID': 260107, 'messageType': 'notify', 'urlAudio': '', 'urlIcon': '', 'titleID': None, 'messageID': 471}
     * {'messageKey': 'CharNameInvalidBannedWord', 'dataID': 17884963, 'suppressable': False, 'bodyID': 260067, 'messageType': 'notify', 'urlAudio': '', 'urlIcon': '', 'titleID': None, 'messageID': 472}
     * {'messageKey': 'CharNameInvalidFirstChar', 'dataID': 17884966, 'suppressable': False, 'bodyID': 260068, 'messageType': 'notify', 'urlAudio': '', 'urlIcon': '', 'titleID': None, 'messageID': 473}
     * {'messageKey': 'CharNameInvalidLastChar', 'dataID': 17884969, 'suppressable': False, 'bodyID': 260069, 'messageType': 'notify', 'urlAudio': '', 'urlIcon': '', 'titleID': None, 'messageID': 474}
     * {'messageKey': 'CharNameInvalidMaxLength', 'dataID': 17885083, 'suppressable': False, 'bodyID': 260109, 'messageType': 'notify', 'urlAudio': '', 'urlIcon': '', 'titleID': None, 'messageID': 475}
     * {'messageKey': 'CharNameInvalidMaxSpaces', 'dataID': 17884972, 'suppressable': False, 'bodyID': 260070, 'messageType': 'notify', 'urlAudio': '', 'urlIcon': '', 'titleID': None, 'messageID': 476}
     * {'messageKey': 'CharNameInvalidMinLength', 'dataID': 17884975, 'suppressable': False, 'bodyID': 260071, 'messageType': 'notify', 'urlAudio': '', 'urlIcon': '', 'titleID': None, 'messageID': 477}
     * {'messageKey': 'CharNameInvalidSomeChar', 'dataID': 17884978, 'suppressable': False, 'bodyID': 260072, 'messageType': 'notify', 'urlAudio': '', 'urlIcon': '', 'titleID': None, 'messageID': 478}
     * {'messageKey': 'CharNameInvalidTaken', 'dataID': 17884981, 'suppressable': False, 'bodyID': 260073, 'messageType': 'notify', 'urlAudio': '', 'urlIcon': '', 'titleID': None, 'messageID': 479}
     * {'messageKey': 'CharNameTooShort', 'dataID': 17884986, 'suppressable': False, 'bodyID': 260075, 'messageType': 'info', 'urlAudio': '', 'urlIcon': '', 'titleID': 260074, 'messageID': 482}
     */
    /* {'FullPath': u'UI/Messages', 'messageID': 260067, 'label': u'CharNameInvalidBannedWordBody'}(u'Character name contains a banned word.', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 260068, 'label': u'CharNameInvalidFirstCharBody'}(u'First character in character name is illegal.', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 260069, 'label': u'CharNameInvalidLastCharBody'}(u'Last character in character name is illegal.', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 260070, 'label': u'CharNameInvalidMaxSpacesBody'}(u'Character name can only include 1 space.', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 260071, 'label': u'CharNameInvalidMinLengthBody'}(u'Minimum length for a character name is 4 characters.', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 260072, 'label': u'CharNameInvalidSomeCharBody'}(u'Character name contains an illegal character.', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 260073, 'label': u'CharNameInvalidTakenBody'}(u'Character name is already taken.', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 260074, 'label': u'CharNameTooShortTitle'}(u'Name Too Short', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 260075, 'label': u'CharNameTooShortBody'}(u'The name must be at least 3 characters long.', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 260107, 'label': u'CharNameInvalidBody'}(u'The name you have selected for your character is not valid', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 260109, 'label': u'CharNameInvalidMaxLengthBody'}(u'Maximum length for a character name is 37 characters. The first and second name must be less than 24 character combined, and the third name must be less than 12 characters.', None, None)
     * {'FullPath': u'UI/CharacterCreation/InvalidName', 'messageID': 233748, 'label': u'IllegalCharacter'}(u'Name contains illegal characters.', None, None)
     * {'FullPath': u'UI/CharacterCreation/InvalidName', 'messageID': 233749, 'label': u'TooShort'}(u'Name is too short.', None, None)
     * {'FullPath': u'UI/CharacterCreation/InvalidName', 'messageID': 233750, 'label': u'Unavailable'}(u'Name is unavailable.', None, None)
     *
     * {'FullPath': u'UI/Messages', 'messageID': 258506, 'label': u'CharCreationNameError1Title'}(u'Information', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 258507, 'label': u'CharCreationNameError1Body'}(u'You have to type some name to be able to proceed.', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 258508, 'label': u'CharCreationNameError3Title'}(u'Information', None, None)
     * {'FullPath': u'UI/Messages', 'messageID': 258509, 'label': u'CharCreationNameError3Body'}(u'The name contains either illegal characters, is already taken or is not allowed.', None, None)
     *
     */

    // *name  is sent from client WITHOUT leading space, if there is one, and will not allow more than one space.

    if (name.empty())
        throw UserError ("CharNameInvalid");
    if (name.length() < 3)
        throw UserError ("CharNameTooShort");
    //if (name.length() < 4)
    //    throw UserError ("CharNameInvalidMinLength");
    if (name.length() > 37)    //client caps at 24
        throw UserError ("CharNameInvalidMaxLength");

    //if (!sDatabase.IsSafeString(name.c_str()))
    //    throw UserError ("CharNameInvalidSomeChar");

    //if (name.at(0) == "+")
    //    throw UserError ("CharNameInvalidFirstChar");

    // check for banned words in char name
    for (const auto cur : badWords)
        if (EvE::icontains(name, cur))
            throw UserError ("CharNameInvalidBannedWord");
    for (const auto cur : badChars)
        if (EvE::icontains(name, cur))
            throw UserError ("CharNameInvalidSomeChar");

    // check for multiple spaces
    int found = name.find(" ");
    if (found != name.npos) {
        found = name.find(" ", found + 1, 1);
        if (found != name.npos)
            throw UserError ("CharNameInvalidMaxSpaces");
    }

    std::string eName;
    sDatabase.DoEscapeString(eName, name.c_str());
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT characterID FROM chrCharacters WHERE characterName LIKE '%s' ", eName.c_str() );
    if (res.GetRowCount() > 0)  // name exists
        throw UserError ("CharNameInvalidTaken");

    /* if we got here, the name is good */
}

Here is the call graph for this function:

PyRep * CharacterDB::ValidateCharNameRep

(

std::string

name

)

Todo:

validStates = {-1: localization.GetByLabel('UI/CharacterCreation/InvalidName/TooShort'), -2: localization.GetByLabel('UI/CharacterCreation/InvalidName/TooLong'), -5: localization.GetByLabel('UI/CharacterCreation/InvalidName/IllegalCharacter'), -6: localization.GetByLabel('UI/CharacterCreation/InvalidName/TooManySpaces'), -7: localization.GetByLabel('UI/CharacterCreation/InvalidName/ConsecutiveSpaces'), -101: localization.GetByLabel('UI/CharacterCreation/InvalidName/Unavailable'), -102: localization.GetByLabel('UI/CharacterCreation/InvalidName/Unavailable')}

Definition at line 240 of file CharacterDB.cpp.

References badChars, badWords, DBQueryResult::GetRowCount(), EvE::icontains(), PyStatic, and sDatabase.

{
    // *name  is sent from client WITHOUT leading space, if there is one, and will not allow more than one space.

    if (name.empty())
        return new PyInt(-1);
    if (name.length() < 3)
        return new PyInt(-1);
    if (name.length() > 37)    //client caps at 24
        return new PyInt(-2);

    if (!sDatabase.IsSafeString(name.c_str()))
        return new PyInt(-5);

    for (const auto cur : badWords)
        if (EvE::icontains(name, cur))
            return new PyInt(-5);

    for (const auto cur : badChars)
        if (EvE::icontains(name, cur))
            return new PyInt(-5);

    // check for consecutive spaces
    if (EvE::icontains(name, "  "))
        return new PyInt(-7);

    // check for multiple spaces
    int found = name.find(" ");
    if (found != name.npos) {
        found = name.find(" ", found + 1, 1);
        if (found != name.npos)
            return new PyInt(-6);
    }

    std::string eName;
    sDatabase.DoEscapeString(eName, name.c_str());
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT characterID FROM chrCharacters WHERE characterName LIKE '%s' ", eName.c_str() );
    if (res.GetRowCount() > 0)  // name exists
        return new PyInt(-101);

    /* if we got here the name is "new" */
    return PyStatic.NewOne();
}

Here is the call graph for this function:

void CharacterDB::VisitSystem	(	uint32	solarSystemID,
		uint32	charID
	)

Definition at line 1664 of file CharacterDB.cpp.

References GetFileTimeNow(), and sDatabase.

Referenced by Character::VisitSystem().

                                                                 {
    DBerror err;
    sDatabase.RunQuery(err,
            "INSERT INTO chrVisitedSystems (characterID, solarSystemID, visits, lastDateTime)"
            "VALUES (%u, %u, 1, %f)"
            " ON DUPLICATE KEY UPDATE"
            " visits = visits +1,"
            " lastDateTime = %f", charID, solarSystemID, GetFileTimeNow(), GetFileTimeNow());
}

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