CorporationDB Class Reference

#include "CorporationDB.h"

Inheritance diagram for CorporationDB:

Collaboration diagram for CorporationDB:

Public Member Functions
PyRep *	GetCorpRoles ()
PyRep *	GetCorpRoleGroups ()
PyRep *	GetTitles (uint32 corpID)
bool	UpdateTitle (uint32 corpID, Call_UpdateTitleData &args, PyDict *updates)
void	DeleteTitle (uint32 corpID, uint16 titleID)
void	CreateTitleData (uint32 corpID)
PyRep *	GetMember (uint32 charID)
uint16	GetMemberCount (uint32 corpID)
void	GetMembers (uint32 corpID, DBQueryResult &res)
void	GetMembersForQuery (std::ostringstream &query, std::vector< uint32 > &result)
void	GetMembersPaged (uint32 corpID, uint8 page, DBQueryResult &res)
PyRep *	GetMemberTrackingInfo (uint32 corpID)
PyRep *	GetMemberTrackingInfoSimple (uint32 corpID)
PyRep *	GetCorporations (uint32 corpID)
PyObject *	GetCorporation (uint32 corpID)
PyObject *	GetStations (uint32 corpID)
PyObject *	GetEveOwners (uint32 corpID)
PyRep *	GetBulletins (uint32 corpID)
void	DeleteBulletin (uint32 bulletinID)
void	AddBulletin (uint32 corpID, uint32 ownerID, uint32 cCharID, std::string &title, std::string &body)
void	EditBulletin (uint32 bulletinID, uint32 eCharID, int64 eDataTime, std::string &title, std::string &body)
PyRep *	GetMyApplications (uint32 charID)
PyRep *	GetApplications (uint32 corpID)
void	MoveShares (uint32 ownerID, uint32 corpID, Call_MoveShares &args)
PyRep *	GetShares (uint32 corpID)
PyRep *	GetMyShares (uint32 ownerID)
bool	HasShares (uint32 charID, uint32 corpID)
PyRep *	PyHasShares (uint32 charID, uint32 corpID)
PyRep *	GetSharesForCorp (uint32 corpID)
PyObject *	GetEmploymentRecord (uint32 charID)
void	GetCorpStations (uint32 corpID, std::vector< uint32 > &stVec)
void	AddItemEvent (uint32 corpID, uint32 charID, uint16 eTypeID)
void	AddRoleHistory (uint32 corpID, uint32 charID, uint32 issuerID, int64 oldRoles, int64 newRoles, bool grantable)
PyRep *	GetItemEvents (uint32 corpID, uint32 charID, int64 fromDate, int64 toDate, uint8 rowsPerPage)
PyRep *	GetRoleHistroy (uint32 corpID, uint32 charID, int64 fromDate, int64 toDate, uint8 rowsPerPage)
void	CastVote (uint32 corpID, uint32 charID, uint32 voteCaseID, uint8 optionID)
void	AddVoteCase (uint32 corpID, uint32 charID, Call_InsertVoteCase &args)
PyRep *	GetVotes (uint32 voteCaseID)
PyRep *	GetVoteItems (uint32 corpID, uint8 status=0, uint8 maxLen=20)
PyRep *	GetVoteOptions (uint32 voteCaseID)
PyRep *	GetSanctionedItems (uint32 corpID, uint8 status=0)
void	GetAutoPay (uint32 corpID, DBQueryResult &res)
void	SetAutoPay ()
PyObject *	ListStationCorps (uint32 station_id)
PyObject *	ListStationOwners (uint32 station_id)
PyRep *	GetCorpInfo (uint32 corpID)
PyRep *	GetContacts (uint32 corpID)
void	AddContact (uint32 ownerID, Call_CorporateContactData corpData)
void	UpdateContact (int32 relationshipID, uint32 contactID, uint32 ownerID)
void	RemoveContact (uint32 contactID, uint32 ownerID)
PyRep *	GetLabels (uint32 corpID)
void	SetLabel (uint32 corpID, uint32 color, std::string name)
void	EditLabel (uint32 corpID, uint32 labelID, uint32 color, std::string name)
void	DeleteLabel (uint32 corpID, uint32 labelID)
bool	IsTickerTaken (std::string ticker)
bool	AddCorporation (Call_AddCorporation &corpInfo, Client *pClient, uint32 &corpID)
bool	CreateCorporationChangePacket (OnCorporationChanged &cc, uint32 oldCorpID, uint32 newCorpID)
bool	CreateCorporationCreatePacket (OnCorporationChanged &cc, uint32 oldCorpID, uint32 newCorpID)
PyRep *	Fetch (uint32 corpID, uint32 from, uint32 count)
PyObject *	GetCorporationBills (uint32 corpID, bool payable)
int32	GetCorpIDforChar (int32 charID)
uint32	GetStationOwner (uint32 stationID)
uint32	GetStationCorporationCEO (uint32 stationID)
uint16	GetCorpMemberCount (uint32 corpID)
uint16	GetCorpMemberLimit (uint32 corpID)
double	GetCloneTypeCostByID (uint32 cloneTypeID)
PyRep *	GetMedalsReceived (int32 charID)
PyRep *	GetAllCorpMedals (uint32 corpID)
PyRep *	GetCorpMedalData (uint32 corpID)
PyRep *	GetMedalsReceivedDetails (int32 charID)
PyRep *	GetRecipientsOfMedal (int32 medalID)
PyRep *	GetMedalStatuses ()
PyObjectEx *	GetMedalDetails (int32 medalID)
void	GiveMedalToCharacters (uint32 issuerID, uint32 corpID, int32 medalID, std::vector< uint32 > &charVec, std::string &reason)
uint16	CreateMedal (uint32 ownerID, uint32 creatorID, std::string &title, std::string &description)
void	SaveMedalData (int64 medalID, std::vector< Corp::MedalData > &dataList)
void	SetMedalStatus (uint32 charID, uint16 medalID, uint8 status)
PyRep *	GetAdTypeData ()
PyRep *	GetAdGroupData ()
PyRep *	GetAdRegistryData (int64 typeMask=0, bool inAlliance=false, int16 minMembers=0, uint16 maxMembers=12602)
PyRep *	GetAdvert (uint16 adID)
void	DeleteAdvert (uint16 adID)
uint32	CreateAdvert (Client *pClient, uint32 corpID, int64 typeMask, int8 days, uint16 members, std::string description, uint32 channelID, std::string title)
void	UpdateAdvert (uint16 adID, uint32 corpID, int64 typeMask, int8 days, uint16 members, std::string description, uint32 channelID, std::string title)
int64	GetAdvertTime (uint16 adID, uint32 corpID)
void	AddRecruiters (uint16 adID, int32 corpID, std::vector< int32 > &charVec)
PyRep *	GetRecruiters (int32 corpID, uint16 adID)
bool	InsertApplication (Corp::ApplicationInfo &aInfo)
bool	UpdateApplication (const Corp::ApplicationInfo &aInfo)
bool	DeleteApplication (const Corp::ApplicationInfo &aInfo)
bool	GetCurrentApplicationInfo (Corp::ApplicationInfo &aInfo)
bool	CreateMemberAttributeUpdate (uint32 newCorpID, uint32 charID, MemberAttributeUpdate &attrib)
bool	UpdateDivisionNames (uint32 corpID, const Call_UpdateDivisionNames &divs, PyDict *notif)
bool	UpdateCorporation (uint32 corpID, const Call_UpdateCorporation &upd, PyDict *notif)
bool	UpdateLogo (uint32 corpID, const Call_UpdateLogo &upd, PyDict *notif)
PyRep *	GetAssetInventory (uint32 corpID, EVEItemFlags locFlag, const char *flags)
PyRep *	GetAssetInventoryForLocation (uint32 corpID, uint32 locationID, const char *flags)
PyRep *	GetKillsAndLosses (uint32 corpID, uint32 number, uint32 offset)
PyRep *	GetMktInfo (uint32 corpID)
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

Static Public Member Functions
static uint32	GetCorporationCEO (uint32 corpID)
static std::string	GetCorpName (uint32 corpID)
static std::string	GetDivisionName (uint32 corpID, uint16 acctKey)
static void	GetCorpData (CorpData &data)
static void	UpdateCorpHQ (uint32 corpID, uint32 stationID)
static void	GetMemberIDs (uint32 corpID, std::vector< uint32 > &ids, bool online=true)
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 41 of file CorporationDB.h.

Member Function Documentation

void CorporationDB::AddBulletin	(	uint32	corpID,
		uint32	ownerID,
		uint32	cCharID,
		std::string &	title,
		std::string &	body
	)

Definition at line 1208 of file CorporationDB.cpp.

References GetFileTimeNow(), and sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err,
        "INSERT INTO crpBulletins (corporationID, ownerID, createCharacterID, createDateTime, editCharacterID, editDateTime, title, body)"
        " VALUES (%u, %u, %u, %f, %u, %f, '%s', '%s')", corpID, ownerID, cCharID, GetFileTimeNow(), cCharID, GetFileTimeNow(), title.c_str(), body.c_str());
}

Here is the call graph for this function:

void CorporationDB::AddContact	(	uint32	ownerID,
		Call_CorporateContactData	corpData
	)

Definition at line 1078 of file CorporationDB.cpp.

References sDatabase.

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

bool CorporationDB::AddCorporation	(	Call_AddCorporation &	corpInfo,
		Client *	pClient,
		uint32 &	corpID
	)

Todo:

allowedMemberRaceIDs will need to be bitwise...it is a flag. also called 'raceMask' and isnt implemented yet.

Definition at line 447 of file CorporationDB.cpp.

References _IoN(), DBerror::c_str(), codelog, EvESkill::CorporationManagement, EvESkill::EmpireControl, RefPtr< X >::get(), Client::GetChar(), Client::GetCharacterID(), Character::GetSkillLevel(), Client::GetStationID(), EvESkill::MegacorpManagement, Character::race(), sDatabase, and EvESkill::Sovereignty.

                                                                                                   {
    std::string cName, cDesc, cTick, cURL;
    sDatabase.DoEscapeString(cName, corpInfo.corpName);
    sDatabase.DoEscapeString(cDesc, corpInfo.description);
    sDatabase.DoEscapeString(cTick, corpInfo.corpTicker);
    sDatabase.DoEscapeString(cURL, corpInfo.url);

    Character* pChar = pClient->GetChar().get();
    uint32 charID = pClient->GetCharacterID();
    uint8 raceID = (uint8)pChar->race();

    // set member limit based on creator's skills
    uint16 mLimit = (pChar->GetSkillLevel(EvESkill::CorporationManagement) * 20);//101
    mLimit += (pChar->GetSkillLevel(EvESkill::MegacorpManagement) * 100);        //601
    mLimit += (pChar->GetSkillLevel(EvESkill::EmpireControl) * 400);             //2601
    mLimit += (pChar->GetSkillLevel(EvESkill::Sovereignty) * 2000);              //12601

    DBerror err;
    if (!sDatabase.RunQueryLID(err, corpID,
        " INSERT INTO crpCorporation ( "
        "   corporationName, description, tickerName, url, taxRate, corporationType, hasPlayerPersonnelManager, "
        "   creatorID, ceoID, stationID, raceID, shares, memberLimit, allowedMemberRaceIDs,"
        "   graphicID, color1, color2, color3, shape1, shape2, shape3, "
        "   isRecruiting, allianceMemberStartDate ) "
        " VALUES "
        "   ('%s', '%s', '%s', '%s', %f, 2, 1, "
        "    %u, %u, %u, %u, 1000, %u, %u,"
        "    0, %s, %s, %s, %s, %s, %s, "
        "    %u, 0) ",
        cName.c_str(), cDesc.c_str(), cTick.c_str(), cURL.c_str(), corpInfo.taxRate,
        charID, charID, pClient->GetStationID(), raceID, mLimit, raceID,
    _IoN(corpInfo.color1).c_str(),
    _IoN(corpInfo.color2).c_str(),
    _IoN(corpInfo.color3).c_str(),
    _IoN(corpInfo.shape1).c_str(),
    _IoN(corpInfo.shape2).c_str(),
    _IoN(corpInfo.shape3).c_str(),
    corpInfo.applicationEnabled))
    {
        codelog(CORP__DB_ERROR, "Error in AddCorporation query: %s", err.c_str());
        return false;
    }

    // dont care if these fail....
    // create default wallet info
    sDatabase.RunQuery(err, "INSERT INTO crpWalletDivisons (corporationID) VALUES (%u)", corpID);

    // create default bill auto-pay
    sDatabase.RunQuery(err, "INSERT INTO crpAutoPay (corporationID) VALUES (%u)", corpID);

    // create corp-owned shares
    sDatabase.RunQuery(err, "INSERT INTO crpShares (corporationID, shareholderID, shares, shareholderCorporationID)"
                            " VALUES (%u, %u, 1000, %u)", corpID, corpID, corpID);

    // It has to go into the eveStaticOwners too
    sDatabase.RunQuery(err, " INSERT INTO eveStaticOwners (ownerID,ownerName,typeID) VALUES (%u, '%s', 2)", corpID, cName.c_str());

    return true;
}

Here is the call graph for this function:

void CorporationDB::AddItemEvent	(	uint32	corpID,
		uint32	charID,
		uint16	eTypeID
	)

Definition at line 1903 of file CorporationDB.cpp.

References GetFileTimeNow(), and sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err,
        "INSERT INTO crpItemEvent (corporationID, characterID, eventTypeID, eventDateTime)"
        " VALUES (%u, %u, %u, %f)", corpID, charID, eTypeID, GetFileTimeNow());
}

Here is the call graph for this function:

void CorporationDB::AddRecruiters	(	uint16	adID,
		int32	corpID,
		std::vector< int32 > &	charVec
	)

Definition at line 1238 of file CorporationDB.cpp.

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

{
    std::ostringstream str;
    str << "INSERT INTO crpRecruiters (adID, corpID, charID) VALUES ";

    bool first = true;
    for (auto cur : charVec) {
        if (!IsCharacterID(cur))
            continue;
        if (first) {
            first = false;
        } else {
            str << ",";
        }
        str << "(" << adID << "," << corpID << "," << cur << ")";
    }

    if (!first ) {
        DBerror err;
        sDatabase.RunQuery(err, "DELETE FROM crpRecruiters WHERE corpID = %u AND adID = %u", corpID, adID);
        sDatabase.RunQuery(err, str.str().c_str());
    }
}

Here is the call graph for this function:

void CorporationDB::AddRoleHistory	(	uint32	corpID,
		uint32	charID,
		uint32	issuerID,
		int64	oldRoles,
		int64	newRoles,
		bool	grantable
	)

Definition at line 1952 of file CorporationDB.cpp.

References GetFileTimeNow(), and sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err,
        "INSERT INTO crpRoleHistroy (corporationID, characterID, issuerID, changeTime, oldRoles, newRoles, grantable)"
        " VALUES (%u, %u, %u, %f, %li, %li, %i)", corpID, charID, issuerID, GetFileTimeNow(), oldRoles, newRoles, (grantable ? 1 : 0));
}

Here is the call graph for this function:

void CorporationDB::AddVoteCase	(	uint32	corpID,
		uint32	charID,
		Call_InsertVoteCase &	args
	)

Definition at line 2005 of file CorporationDB.cpp.

References _log, PyRep::AsDict(), PyRep::AsList(), PyList::begin(), DBerror::c_str(), Corp::VoteType::CEO, codelog, PyRep::Dump(), PyList::end(), Corp::VoteType::General, PyList::GetItem(), PyDict::GetItemString(), PyRep::IntegerValue(), PyRep::IsList(), Corp::VoteType::ItemLock, Corp::VoteType::ItemUnlock, Corp::VoteType::KickMember, Corp::VoteCaseOptions::optionID, Corp::VoteCaseOptions::optionText, Corp::VoteCaseOptions::parameter, Corp::VoteCaseOptions::parameter1, Corp::VoteCaseOptions::parameter2, sDatabase, Corp::VoteType::Shares, PyRep::StringContent(), PyRep::TypeString(), and Corp::VoteType::War.

{   // working
    PyDict* dict = args.voteCaseOptions->arguments()->AsDict();
    dict->Dump(CORP__TRACE, "    ");

    PyRep* rep = dict->GetItemString("lines");
    if (!rep->IsList()) {
        codelog(CORP__ERROR, "'lines' item is not PyList: %s", rep->TypeString());
        return;
    }

    std::vector<Corp::VoteCaseOptions> data;
    PyList* list = rep->AsList();
    for (PyList::const_iterator itr = list->begin(); itr != list->end(); ++itr) {
        if (!(*itr)->IsList()) {
            _log(CORP__ERROR, "itr item is not PyList: %s", rep->TypeString());
            continue;
        }
        PyList* list2 = (*itr)->AsList();
        Corp::VoteCaseOptions args2 = Corp::VoteCaseOptions();
        //vote decision option
        args2.optionText = PyRep::StringContent(list2->GetItem(0));
        args2.optionID = PyRep::IntegerValue(list2->GetItem(1));
        //for kick, ceo this is charID.  for war, this is corpID.  for lock/unlock, this is itemID  for shares/general, this is boolean
        args2.parameter = PyRep::IntegerValue(list2->GetItem(1));
        switch (args.voteType) {
            case Corp::VoteType::Shares:
            case Corp::VoteType::General: {
                // nothing
            } break;
            case Corp::VoteType::CEO:
            case Corp::VoteType::War:
            case Corp::VoteType::KickMember: {
                // nothing
            } break;
            case Corp::VoteType::ItemLock:
            case Corp::VoteType::ItemUnlock: {
                //for lock/unlock, this is items typeID.  for shares/general, this is 0
                args2.parameter1 = PyRep::IntegerValue(list2->GetItem(2));
                //for lock/unlock, this is items locationID.  for others, this is none
                args2.parameter2 = PyRep::IntegerValue(list2->GetItem(3));
            } break;
        }
        data.push_back(args2);
    }

    uint32 voteCaseID = 0;
    DBerror err;
    sDatabase.RunQueryLID(err, voteCaseID,
        " INSERT INTO crpVoteItems( "
        " corporationID, voteType, voteCaseText, description, startDateTime, endDateTime)"
        " VALUES (%u, %u, '%s', '%s', %li, %li)",
        args.corporationID, args.voteType, args.voteCaseText.c_str(), args.description.c_str(), args.startDateTime, args.endDateTime);

    std::stringstream str;
    str << "INSERT INTO crpVoteOptions (voteCaseID, optionID, optionText, parameter, parameter1, parameter2) VALUES ";

    bool set = false;
    for (auto cur : data) {
        if (!set) {
            set = true;
        } else {
            str << ",";
        }
        str << "(" << std::to_string((int64)voteCaseID) << "," << std::to_string(cur.optionID) << ",\"" << cur.optionText << "\"," << std::to_string(cur.parameter) << ",";
        str << std::to_string(cur.parameter1) << "," << std::to_string(cur.parameter2) << ")";
    }

    if (set)
        sDatabase.RunQuery(err, str.str().c_str());
}

Here is the call graph for this function:

void CorporationDB::CastVote	(	uint32	corpID,
		uint32	charID,
		uint32	voteCaseID,
		uint8	optionID
	)

Definition at line 2150 of file CorporationDB.cpp.

References sDatabase.

{   // working
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE crpVoteItems SET votesMade=votesMade + 1 WHERE voteCaseID = %u", voteCaseID);
    sDatabase.RunQuery(err, "UPDATE crpVoteOptions SET votesFor=votesFor + 1 WHERE voteCaseID = %u AND optionID = %u", voteCaseID, optionID);
    sDatabase.RunQuery(err,
            "INSERT INTO crpVotes (charID,corpID,voteCaseID,optionID)"
            " VALUES (%u,%u,%u,%u)", charID, corpID, voteCaseID, optionID);
}

uint32 CorporationDB::CreateAdvert	(	Client *	pClient,
		uint32	corpID,
		int64	typeMask,
		int8	days,
		uint16	members,
		std::string	description,
		uint32	channelID,
		std::string	title
	)

Definition at line 1345 of file CorporationDB.cpp.

References EvE::Time::Day, Client::GetAllianceID(), GetFileTimeNow(), Client::GetRegionID(), Client::GetStationID(), and sDatabase.

{
    uint32 adID = 0;
    DBerror err;
    sDatabase.RunQueryLID(err, adID, "INSERT INTO crpAdRegistry"
    " (corporationID, allianceID, stationID, regionID, raceMask, typeMask,"
    "  createDateTime, expiryDateTime, description, title, memberCount, channelID)"
    " VALUES (%u,%u,%u,%u,%u,%li,%f,%f,'%s','%s',%u,%u)",
        corpID, pClient->GetAllianceID(), pClient->GetStationID(), pClient->GetRegionID(), 15, typeMask, // raceMask isnt implemented yet
        GetFileTimeNow(), GetFileTimeNow() + (EvE::Time::Day * days), description.c_str(), title.c_str(), members, channelID);

    return adID;
}

Here is the call graph for this function:

bool CorporationDB::CreateCorporationChangePacket	(	OnCorporationChanged &	cc,
		uint32	oldCorpID,
		uint32	newCorpID
	)

Definition at line 513 of file CorporationDB.cpp.

References _NI, _NS, codelog, DBResultRow::GetDouble(), DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), IsNPCCorp, IsPlayerCorp, and sDatabase.

                                                                                                               {
    std::string table = "crpWalletDivisons";
    if (IsNPCCorp(newCorpID))
        table = "crpNPCWalletDivisons";
    DBQueryResult res;
    DBResultRow row;
    if (!sDatabase.RunQuery(res,
        " SELECT "
        "  c.corporationID, c.corporationName, c.description, c.tickerName, c.allianceID, c.warFactionID, c.url, c.taxRate,"
        "  c.minimumJoinStanding, c.corporationType, c.hasPlayerPersonnelManager, c.sendCharTerminationMessage, c.creatorID, c.ceoID, c.stationID, c.raceID, "
        "  c.shares, c.memberCount, c.memberLimit, c.allowedMemberRaceIDs, c.shape1, c.shape2, c.shape3, c.color1, c.color2, c.color3,"
        "  c.typeface, w.division1, w.division2, w.division3, w.division4, w.division5, w.division6, w.division7, w.walletDivision1, w.walletDivision2,"
        "  w.walletDivision3, w.walletDivision4, w.walletDivision5, w.walletDivision6, w.walletDivision7, c.deleted, c.isRecruiting "
        " FROM crpCorporation AS c"
        "  LEFT JOIN %s AS w USING (corporationID)"
        " WHERE corporationID = %u ",table.c_str(), newCorpID
        ))
    {
        codelog(CORP__DB_ERROR, "Error in retrieving new corporation's data (%u)", newCorpID);
        return false;
    }

    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Unable to find new corporation's data (%u)", newCorpID);
        return false;
    }

    cc.corporationIDNew = row.GetUInt(0);
    cc.corporationNameNew = row.GetText(1);
    cc.descriptionNew = row.GetText(2);
    cc.tickerNameNew = row.GetText(3);
    _NI(allianceIDNew, 4);
    _NI(warFactionIDNew, 5);
    cc.urlNew = row.GetText(6);
    cc.taxRateNew = row.GetDouble(7);
    cc.minimumJoinStandingNew = row.GetDouble(8);
    cc.corporationTypeNew = row.GetUInt(9);
    cc.hasPlayerPersonnelManagerNew = row.GetUInt(10);
    cc.sendCharTerminationMessageNew = row.GetUInt(11);
    cc.creatorIDNew = row.GetUInt(12);
    cc.ceoIDNew = row.GetUInt(13);
    cc.stationIDNew = row.GetUInt(14);
    _NI(raceIDNew, 15);
    cc.sharesNew = row.GetInt64(16);
    cc.memberCountNew = row.GetUInt(17);
    cc.memberLimitNew = row.GetUInt(18);
    cc.allowedMemberRaceIDsNew = row.GetUInt(19);
    _NI(shape1New, 20);
    _NI(shape2New, 21);
    _NI(shape3New, 22);
    _NI(color1New, 23);
    _NI(color2New, 24);
    _NI(color3New, 25);
    _NI(typefaceNew, 26);
    _NS(division1New, 27);
    _NS(division2New, 28);
    _NS(division3New, 29);
    _NS(division4New, 30);
    _NS(division5New, 31);
    _NS(division6New, 32);
    _NS(division7New, 33);
    _NS(walletDivision1New, 34);
    _NS(walletDivision2New, 35);
    _NS(walletDivision3New, 36);
    _NS(walletDivision4New, 37);
    _NS(walletDivision5New, 38);
    _NS(walletDivision6New, 39);
    _NS(walletDivision7New, 40);
    cc.deletedNew = row.GetUInt(41);
    cc.isRecruitingNew = row.GetUInt(42);

    if (IsPlayerCorp(oldCorpID))
        table = "crpWalletDivisons";
    if (IsNPCCorp(oldCorpID))
        table = "crpNPCWalletDivisons";

    if (!sDatabase.RunQuery(res,
        " SELECT "
        "  c.corporationID, c.corporationName, c.description, c.tickerName, c.allianceID, c.warFactionID, c.url, c.taxRate,"
        "  c.minimumJoinStanding, c.corporationType, c.hasPlayerPersonnelManager, c.sendCharTerminationMessage, c.creatorID, c.ceoID, c.stationID, c.raceID, "
        "  c.shares, c.memberCount, c.memberLimit, c.allowedMemberRaceIDs, c.shape1, c.shape2, c.shape3, c.color1, c.color2, c.color3,"
        "  c.typeface, w.division1, w.division2, w.division3, w.division4, w.division5, w.division6, w.division7, w.walletDivision1, w.walletDivision2,"
        "  w.walletDivision3, w.walletDivision4, w.walletDivision5, w.walletDivision6, w.walletDivision7, c.deleted, c.isRecruiting "
        " FROM crpCorporation AS c"
        "  LEFT JOIN %s AS w USING (corporationID)"
        " WHERE corporationID = %u ", table.c_str(), oldCorpID
        ))
    {
        codelog(CORP__DB_ERROR, "Error in retrieving old corporation's data (%u)", oldCorpID);
        return false;
    }

    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Unable to find old corporation's data (%u)", oldCorpID);
        return false;
    }

    cc.corporationIDOld = new PyInt(row.GetInt(0));
    cc.corporationNameOld = new PyString(row.GetText(1));
    cc.descriptionOld = new PyString(row.GetText(2));
    cc.tickerNameOld = new PyString(row.GetText(3));
    _NI(allianceIDOld, 4);
    _NI(warFactionIDOld, 5);
    cc.urlOld = new PyString(row.GetText(6));
    cc.taxRateOld = new PyFloat(row.GetDouble(7));
    cc.minimumJoinStandingOld = new PyFloat(row.GetDouble(8));
    cc.corporationTypeOld = new PyInt(row.GetInt(9));
    cc.hasPlayerPersonnelManagerOld = new PyInt(row.GetInt(10));
    cc.sendCharTerminationMessageOld = new PyInt(row.GetInt(11));
    cc.creatorIDOld = new PyInt(row.GetInt(12));
    cc.ceoIDOld = new PyInt(row.GetInt(13));
    cc.stationIDOld = new PyInt(row.GetInt(14));
    _NI(raceIDOld, 15);
    cc.sharesOld = new PyLong(row.GetInt64(16));
    cc.memberCountOld = new PyInt(row.GetInt(17));
    cc.memberLimitOld = new PyInt(row.GetInt(18));
    cc.allowedMemberRaceIDsOld = new PyInt(row.GetInt(19));
    _NI(shape1Old, 20);
    _NI(shape2Old, 21);
    _NI(shape3Old, 22);
    _NI(color1Old, 23);
    _NI(color2Old, 24);
    _NI(color3Old, 25);
    _NI(typefaceOld, 26);
    _NS(division1Old, 27);
    _NS(division2Old, 28);
    _NS(division3Old, 29);
    _NS(division4Old, 30);
    _NS(division5Old, 31);
    _NS(division6Old, 32);
    _NS(division7Old, 33);
    _NS(walletDivision1Old, 34);
    _NS(walletDivision2Old, 35);
    _NS(walletDivision3Old, 36);
    _NS(walletDivision4Old, 37);
    _NS(walletDivision5Old, 38);
    _NS(walletDivision6Old, 39);
    _NS(walletDivision7Old, 40);
    cc.deletedOld = new PyInt(row.GetUInt(41));
    cc.isRecruitingOld = new PyInt(row.GetUInt(42));

    return true;
}

Here is the call graph for this function:

bool CorporationDB::CreateCorporationCreatePacket	(	OnCorporationChanged &	cc,
		uint32	oldCorpID,
		uint32	newCorpID
	)

Todo:

these need to be updated

Definition at line 657 of file CorporationDB.cpp.

References _NI, _NS, codelog, DBResultRow::GetDouble(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), PyStatic, and sDatabase.

                                                                                                               {
    DBQueryResult res;
    DBResultRow row;
    if (!sDatabase.RunQuery(res,
        " SELECT "
        "  c.corporationID, c.corporationName, c.description, c.tickerName, c.allianceID, c.warFactionID, c.url, c.taxRate,"
        "  c.minimumJoinStanding, c.corporationType, c.hasPlayerPersonnelManager, c.sendCharTerminationMessage, c.creatorID, c.ceoID, c.stationID, c.raceID, "
        "  c.shares, c.memberCount, c.memberLimit, c.allowedMemberRaceIDs, c.shape1, c.shape2, c.shape3, c.color1, c.color2,c. color3,"
        "  c.typeface, w.division1, w.division2, w.division3, w.division4, w.division5, w.division6, w.division7, w.walletDivision1, w.walletDivision2,"
        "  w.walletDivision3, w.walletDivision4, w.walletDivision5, w.walletDivision6, w.walletDivision7, c.deleted, c.isRecruiting "
        " FROM crpCorporation AS c"
        "  LEFT JOIN crpWalletDivisons AS w USING (corporationID)"
        " WHERE corporationID = %u ", newCorpID
        ))
    {
        codelog(CORP__DB_ERROR, "Error in retrieving new corporation's data (%u)", newCorpID);
        return false;
    }

    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Unable to find corporation's data (%u)", newCorpID);
        return false;
    }

    cc.corporationIDNew = row.GetUInt(0);
    cc.corporationNameNew = row.GetText(1);
    cc.descriptionNew = row.GetText(2);
    cc.tickerNameNew = row.GetText(3);
    _NI(allianceIDNew, 4);
    _NI(warFactionIDNew, 5);
    cc.urlNew = row.GetText(6);
    cc.taxRateNew = row.GetDouble(7);
    cc.minimumJoinStandingNew = row.GetDouble(8);
    cc.corporationTypeNew = row.GetUInt(9);
    cc.hasPlayerPersonnelManagerNew = row.GetUInt(10);
    cc.sendCharTerminationMessageNew = row.GetUInt(11);
    cc.creatorIDNew = row.GetUInt(12);
    cc.ceoIDNew = row.GetUInt(13);
    cc.stationIDNew = row.GetUInt(14);
    _NI(raceIDNew, 15);
    cc.sharesNew = row.GetInt64(16);
    cc.memberCountNew = row.GetUInt(17);
    cc.memberLimitNew = row.GetUInt(18);
    cc.allowedMemberRaceIDsNew = row.GetUInt(19);
    _NI(shape1New, 20);
    _NI(shape2New, 21);
    _NI(shape3New, 22);
    _NI(color1New, 23);
    _NI(color2New, 24);
    _NI(color3New, 25);
    _NI(typefaceNew, 26);
    _NS(division1New, 27);
    _NS(division2New, 28);
    _NS(division3New, 29);
    _NS(division4New, 30);
    _NS(division5New, 31);
    _NS(division6New, 32);
    _NS(division7New, 33);
    _NS(walletDivision1New, 34);
    _NS(walletDivision2New, 35);
    _NS(walletDivision3New, 36);
    _NS(walletDivision4New, 37);
    _NS(walletDivision5New, 38);
    _NS(walletDivision6New, 39);
    _NS(walletDivision7New, 40);
    cc.deletedNew = row.GetUInt(41);
    cc.isRecruitingNew = row.GetUInt(42);

    cc.allianceIDOld = PyStatic.NewNone();
    cc.warFactionIDOld = PyStatic.NewNone();
    cc.allowedMemberRaceIDsOld = PyStatic.NewNone();
    cc.ceoIDOld = PyStatic.NewNone();
    cc.color1Old = PyStatic.NewNone();
    cc.color2Old = PyStatic.NewNone();
    cc.color3Old = PyStatic.NewNone();
    cc.corporationIDOld = PyStatic.NewNone();
    cc.corporationNameOld = PyStatic.NewNone();
    cc.corporationTypeOld = PyStatic.NewNone();
    cc.creatorIDOld = PyStatic.NewNone();
    cc.deletedOld = PyStatic.NewNone();
    cc.descriptionOld = PyStatic.NewNone();
    cc.division1Old = PyStatic.NewNone();
    cc.division2Old = PyStatic.NewNone();
    cc.division3Old = PyStatic.NewNone();
    cc.division4Old = PyStatic.NewNone();
    cc.division5Old = PyStatic.NewNone();
    cc.division6Old = PyStatic.NewNone();
    cc.division7Old = PyStatic.NewNone();
    cc.walletDivision1Old = PyStatic.NewNone();
    cc.walletDivision2Old = PyStatic.NewNone();
    cc.walletDivision3Old = PyStatic.NewNone();
    cc.walletDivision4Old = PyStatic.NewNone();
    cc.walletDivision5Old = PyStatic.NewNone();
    cc.walletDivision6Old = PyStatic.NewNone();
    cc.walletDivision7Old = PyStatic.NewNone();
    cc.hasPlayerPersonnelManagerOld = PyStatic.NewNone();
    cc.memberCountOld = PyStatic.NewNone();
    cc.memberLimitOld = PyStatic.NewNone();
    cc.minimumJoinStandingOld = PyStatic.NewNone();
    cc.raceIDOld = PyStatic.NewNone();
    cc.sendCharTerminationMessageOld = PyStatic.NewNone();
    cc.shape1Old = PyStatic.NewNone();
    cc.shape2Old = PyStatic.NewNone();
    cc.shape3Old = PyStatic.NewNone();
    cc.sharesOld = PyStatic.NewNone();
    cc.stationIDOld = PyStatic.NewNone();
    cc.taxRateOld = PyStatic.NewNone();
    cc.tickerNameOld = PyStatic.NewNone();
    cc.typefaceOld = PyStatic.NewNone();
    cc.urlOld = PyStatic.NewNone();
    cc.isRecruitingOld = PyStatic.NewNone();

    return true;
}

Here is the call graph for this function:

uint16 CorporationDB::CreateMedal	(	uint32	ownerID,
		uint32	creatorID,
		std::string &	title,
		std::string &	description
	)

Definition at line 264 of file CorporationDB.cpp.

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

{
    std::string cTitle, cDesc;
    sDatabase.DoEscapeString(cTitle, title);
    sDatabase.DoEscapeString(cDesc, description);
    uint32 medalID = 0;
    DBerror err;
    sDatabase.RunQueryLID(err, medalID,
        " INSERT INTO crpMedals (ownerID, creatorID, title, description, date)"
        " VALUES (%u, %u, '%s', '%s', %li)", ownerID, creatorID, cTitle.c_str(), cDesc.c_str(), GetFileTimeNow());

    return medalID;
}

Here is the call graph for this function:

bool CorporationDB::CreateMemberAttributeUpdate	(	uint32	newCorpID,
		uint32	charID,
		MemberAttributeUpdate &	attrib
	)

Definition at line 1602 of file CorporationDB.cpp.

References baseID, DBerror::c_str(), codelog, DBQueryResult::error, F, GetFileTimeNow(), DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetUInt(), grantableRoles, grantableRolesAtBase, grantableRolesAtHQ, grantableRolesAtOther, PRI, PRL, PRN, sDatabase, and titleMask.

                                                                                                              {
    // What are we doing here exactly?
    // Corporation gets a new member
    // it's new to it

    DBQueryResult res;
    DBResultRow row;
    if (!sDatabase.RunQuery(res,
        " SELECT "
        "   title, startDateTime, corporationID, "
        "   corpRole, rolesAtAll, rolesAtBase, "
        "   rolesAtHQ, rolesAtOther, titleMask, baseID "
        " FROM chrCharacters "
        " WHERE characterID = %u ", charID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Cannot find character in database");
        return false;
    }

    // this could be stored in the db
#define PRN PyStatic.NewNone()
#define PRI(i) new PyInt(i)
#define PRL(i) new PyLong(i)
#define PRS(s) new PyString(s)
#define PRNI(i) (row.IsNull(i) ? PRU(0) : PRU(row.GetInt64(i)))
#define F(name, o, n) \
    attrib.name##Old = o; \
    attrib.name##New = n

    //element                   Old Value               New Value
    F(accountKey,               PRN,                    PRN);
    F(baseID,                   PRI(row.GetInt(9)),     PRI(0));
    F(characterID,              PRN,                    PRI(charID));
    F(corporationID,            PRI(row.GetUInt(2)),    PRI(newCorpID));
    F(divisionID,               PRN,                    PRN);
    F(roles,                    PRL(row.GetInt64(3)),   PRI(0));
    F(grantableRoles,           PRL(row.GetInt64(4)),   PRI(0));
    F(grantableRolesAtBase,     PRL(row.GetInt64(5)),   PRI(0));
    F(grantableRolesAtHQ,       PRL(row.GetInt64(6)),   PRI(0));
    F(grantableRolesAtOther,    PRL(row.GetInt64(7)),   PRI(0));
    F(squadronID,               PRN,                    PRN);
    F(startDateTime,            PRL(row.GetInt64(1)),   PRL(GetFileTimeNow()));
    F(titleMask,                PRL(row.GetInt64(8)),   PRI(0));

#undef F
#undef PRN
#undef PRI
#undef PRS
#undef PRL
#undef PRNI

    return true;
}

Here is the call graph for this function:

void CorporationDB::CreateTitleData

(

uint32

corpID

)

Definition at line 1044 of file CorporationDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err,
        "INSERT INTO crpRoleTitles (corporationID, titleID, titleName) VALUES"
        "(%u,1,'Untitled 1'),(%u,2,'Untitled 2'),(%u,4,'Untitled 3'),(%u,8,'Untitled 4'),(%u,16,'Untitled 5'),(%u,32,'Untitled 6'),"
        "(%u,64,'Untitled 7'),(%u,128,'Untitled 8'),(%u,256,'Untitled 9'),(%u,512,'Untitled 10'),(%u,1024,'Untitled 11'),(%u,2048,'Untitled 12'),"
        "(%u,4096,'Untitled 13'),(%u,8192,'Untitled 14'),(%u,16384,'Untitled 15'),(%u,32768,'Untitled 16')",
        corpID,corpID,corpID,corpID,corpID,corpID,corpID,corpID,corpID,corpID,corpID,corpID,corpID,corpID,corpID,corpID);
}

void CorporationDB::DeleteAdvert

(

uint16

adID

)

Definition at line 1339 of file CorporationDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM crpAdRegistry WHERE adID=%u ", adID);
}

bool CorporationDB::DeleteApplication

(

const Corp::ApplicationInfo &

aInfo

)

Definition at line 1496 of file CorporationDB.cpp.

References Corp::ApplicationInfo::appID, DBerror::c_str(), codelog, and sDatabase.

                                                                      {
    DBerror err;
    if (!sDatabase.RunQuery(err,
        " UPDATE crpApplications"
        " SET status = 3, deleted = 1"
        " WHERE applicationID = %u", aInfo.appID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", err.c_str());
        return false;
    }
    return true;
}

Here is the call graph for this function:

void CorporationDB::DeleteBulletin

(

uint32

bulletinID

)

Definition at line 1202 of file CorporationDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM crpBulletins WHERE bulletinID = %u", bulletinID);
}

void CorporationDB::DeleteLabel	(	uint32	corpID,
		uint32	labelID
	)

Definition at line 2531 of file CorporationDB.cpp.

{
    // not used yet
}

void CorporationDB::DeleteTitle	(	uint32	corpID,
		uint16	titleID
	)

Definition at line 946 of file CorporationDB.cpp.

References DBerror::c_str(), and sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err, "DELETE FROM crpRoleTitles WHERE corpID = %u AND titleID = %u", corpID, titleID);
    std::string title = "Untitled ";
    title += std::to_string(log2(titleID) + 1);
    sDatabase.RunQuery(err, "INSERT INTO crpRoleTitles (corporationID, titleID, titleName) VALUES (%u,%u,'%s')", corpID, titleID, title.c_str());
}

Here is the call graph for this function:

void CorporationDB::EditBulletin	(	uint32	bulletinID,
		uint32	eCharID,
		int64	eDataTime,
		std::string &	title,
		std::string &	body
	)

Definition at line 1216 of file CorporationDB.cpp.

References DBerror::c_str(), and sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err,
        "UPDATE crpBulletins SET editCharacterID = %u, editDateTime = %li, title = '%s', body = '%s'"
        " WHERE bulletinID = %u", eCharID, eDataTime, title.c_str(), body.c_str(), bulletinID);
}

Here is the call graph for this function:

void CorporationDB::EditLabel	(	uint32	corpID,
		uint32	labelID,
		uint32	color,
		std::string	name
	)

Definition at line 2502 of file CorporationDB.cpp.

References sDatabase.

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

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

PyRep * CorporationDB::Fetch	(	uint32	corpID,
		uint32	from,
		uint32	count
	)

Definition at line 1150 of file CorporationDB.cpp.

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

                                                                    {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        "SELECT stationID, stationTypeID, itemID, officeFolderID"
        " FROM staOffices "
        " WHERE corporationID = %u "
        " LIMIT %u, %u ", corpID, from, count
        ))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    // manually build the return.  easier this way...
    PyList* list = new PyList();

    DBResultRow row;
    while (res.GetRow(row)) {
        PyList* innerList = new PyList();
            innerList->AddItem(new PyInt(row.GetInt(0)));
            innerList->AddItem(new PyInt(row.GetInt(1)));   // this wants stationTypeID
            innerList->AddItem(new PyInt(row.GetInt(2)));
            innerList->AddItem(new PyInt(row.GetInt(3)));
        PyTuple* tuple = new PyTuple(2);
            tuple->SetItem(0, new PyInt(row.GetInt(0)));
            tuple->SetItem(1, innerList);
        list->AddItem(tuple);
    }
    return list;
}

Here is the call graph for this function:

PyRep * CorporationDB::GetAdGroupData

(

)

Definition at line 1289 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT groupID, groupName, groupNameID, description, descriptionID FROM crpAdGroupData")) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetAdRegistryData	(	int64	typeMask = 0,
		bool	inAlliance = false,
		int16	minMembers = 0,
		uint16	maxMembers = 12602
	)

Definition at line 1299 of file CorporationDB.cpp.

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

{
    // make sure this isnt 0
    if (maxMembers < 1)
        maxMembers = 12602;

    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  adID, corporationID, allianceID, stationID, regionID, raceMask, typeMask,"
        "  createDateTime, expiryDateTime, title, description, memberCount, channelID"
        " FROM crpAdRegistry"
        "  WHERE allianceID %s 0"
        "   AND (memberCount >= %u AND memberCount < %u)",
        (inAlliance ? ">" : "="), minMembers, maxMembers))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetAdTypeData

(

)

Definition at line 1279 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT typeMask, typeName, typeNameID, groupID, description, descriptionID FROM crpAdTypeData")) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetAdvert

(

uint16

adID

)

Definition at line 1322 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  adID, corporationID, allianceID, stationID, regionID, raceMask, typeMask,"
        "  createDateTime, expiryDateTime, title, description, memberCount, channelID"
        " FROM crpAdRegistry"
        "  WHERE adID = %u", adID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

int64 CorporationDB::GetAdvertTime	(	uint16	adID,
		uint32	corpID
	)

Definition at line 1369 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT expiryDateTime FROM crpAdRegistry WHERE adID=%u AND corporationID=%u", adID, corpID);
    DBResultRow row;
    if (res.GetRow(row))
        return row.GetInt64(0);

    return 0;
}

Here is the call graph for this function:

PyRep * CorporationDB::GetAllCorpMedals

(

uint32

corpID

)

Definition at line 319 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT medalID, creatorID, noRecepients, date, title, description FROM crpMedals WHERE ownerID = %u", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetApplications

(

uint32

corpID

)

Definition at line 1400 of file CorporationDB.cpp.

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

                                                   {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT"
        " applicationID, characterID, corporationID, applicationText, status,"
        " applicationDateTime, lastCorpUpdaterID"
        " FROM crpApplications"
        " WHERE corporationID = %u AND deleted = 0",
        corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    PyObjectEx* obj = DBResultToCIndexedRowset(res, "characterID");
    if (is_log_enabled(CORP__RSP_DUMP))
        obj->Dump(CORP__RSP_DUMP, "");

    return obj;
}

Here is the call graph for this function:

PyRep * CorporationDB::GetAssetInventory	(	uint32	corpID,
		EVEItemFlags	locFlag,
		const char *	flags
	)

Todo:

this can be done better revisit after everything is working and sorted

Definition at line 2315 of file CorporationDB.cpp.

References _log, DBerror::c_str(), codelog, DBResultToCRowset(), DBQueryResult::error, flagCorpMarket, flagImpounded, flagOffice, flagProperty, maxOffice, maxPlayerItem, minOffice, minPlayerItem, PyStatic, and sDatabase.

{
    /* this may need more code/thought to change implementation
     * currently, "property" will show all corp items located in dynamic containers that are or have corp hangars
     * this will include items located in station hangars that have corp hangars, or anything with flagHangar(4) located in an item of itemID => playerItem
     *  at this time, im not sure if this is desired action
     *
     * this will need to return unique locationIDs for all corp items (dupes cause problems)
     */
    DBQueryResult res;
    switch (locFlag) {
        case flagOffice:        // in stations, using officeIDs (100m)
        case flagImpounded:
        case flagCorpMarket: {
            if (!sDatabase.RunQuery(res,
                " SELECT DISTINCT s.stationID AS locationID FROM entity AS e"
                " LEFT JOIN staOffices AS s ON (s.itemID = e.locationID)"
                " WHERE e.ownerID = %u AND e.flag IN %s"
                " AND e.locationID >= %u AND e.locationID <= %u", corpID, flags, minOffice, maxOffice))
            {
                codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
                return (PyRep*)PyStatic.NewNone();    // cannot return nullptr cause we may deref it on the return.
            }
        } break;
        case flagProperty: {  // in space...this will show items in containers, ships, POS, CO, etc.
            if (!sDatabase.RunQuery(res,
                " SELECT DISTINCT locationID FROM entity WHERE ownerID = %u AND flag IN %s"
                " AND locationID >= %u AND locationID <= %u", corpID, flags, minPlayerItem, maxPlayerItem))
            {
                codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
                return (PyRep*)PyStatic.NewNone();    // cannot return nullptr cause we may deref it on the return.
            }

            // current thought is this option will need more work, to avoid showing corp hangars in ships in stations
            // or do we want to show all possible locations that are NOT corp offices?
        } break;
        default: {
            _log(CORP__DB_WARNING, "CorporationDB::GetAssetInventory(): unhandled locFlag sent: %u", locFlag);
            return (PyRep*)PyStatic.NewNone();    // cannot return nullptr cause we may deref it on the return.
        } break;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetAssetInventoryForLocation	(	uint32	corpID,
		uint32	locationID,
		const char *	flags
	)

Definition at line 2361 of file CorporationDB.cpp.

References _log, DBerror::c_str(), codelog, DBResultToCRowset(), DBQueryResult::error, IsOfficeID, IsPlayerItem, sDatabase, and sDataMgr.

{
    // this will need to get full item data...locationID sent from GetAssetInventory()
    DBQueryResult res;
    if (sDataMgr.IsStation(locationID)) {    // transpose stationID to officeID for item location...should never hit
        if (!sDatabase.RunQuery(res,
            " SELECT e.itemID, e.itemName, e.typeID, e.ownerID, e.locationID, e.flag AS flagID, e.singleton,"
            " e.quantity AS stacksize, t.groupID, g.categoryID FROM entity AS e"
            " LEFT JOIN invTypes AS t USING (typeID)"
            " LEFT JOIN invGroups AS g USING (groupID)"
            " WHERE e.ownerID = %u AND e.flag IN %s AND e.locationID = (SELECT itemID FROM staOffices WHERE stationID = %u AND corporationID = %u)",
            corpID, flags, locationID, corpID)) // quantity, contraband, x, y, z, customInfo
        {
            codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
            return nullptr;
        }
    } else if (IsOfficeID(locationID)) {  // transpose officeID to stationID for item location...most oft used (corp hangars in station)
        if (!sDatabase.RunQuery(res,
            " SELECT e.itemID, e.itemName, e.typeID, e.ownerID, e.locationID, e.flag AS flagID, e.singleton,"
            " e.quantity AS stacksize, t.groupID, g.categoryID FROM entity AS e"
            " LEFT JOIN invTypes AS t USING (typeID)"
            " LEFT JOIN invGroups AS g USING (groupID)"
            " WHERE e.ownerID = %u AND e.flag IN %s AND e.locationID = (SELECT stationID FROM staOffices WHERE itemID = %u)",
            corpID, flags, locationID))
        {
            codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
            return nullptr;
        }
    } else if (IsPlayerItem(locationID)) {  // location is item with corp hangar (ship, pos, etc)
        if (!sDatabase.RunQuery(res,
            " SELECT e.itemID, e.itemName, e.typeID, e.ownerID, e.locationID, e.flag AS flagID, e.singleton,"
            " e.quantity AS stacksize, t.groupID, g.categoryID FROM entity AS e"
            " LEFT JOIN invTypes AS t USING (typeID)"
            " LEFT JOIN invGroups AS g USING (groupID)"
            " WHERE e.ownerID = %u AND e.flag IN %s AND e.locationID = %u", corpID, flags, locationID))
        {
            codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
            return nullptr;
        }
    } else {
        _log(CORP__DB_WARNING, "CorporationDB::GetAssetInventoryForLocation(): unhandled locationID sent:  %u", locationID);
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

void CorporationDB::GetAutoPay	(	uint32	corpID,
		DBQueryResult &	res
	)

Definition at line 1893 of file CorporationDB.cpp.

References sDatabase.

{
    sDatabase.RunQuery(res, "SELECT market, rental, broker, war, alliance, sov FROM crpAutoPay WHERE corporationID = %u", corpID);
}

PyRep * CorporationDB::GetBulletins

(

uint32

corpID

)

Definition at line 1224 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT corporationID, bulletinID, ownerID, createCharacterID, createDateTime, editCharacterID, editDateTime, title, body"
        " FROM crpBulletins"
        " WHERE corporationID = %u ", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

double CorporationDB::GetCloneTypeCostByID

(

uint32

cloneTypeID

)

Definition at line 1585 of file CorporationDB.cpp.

References codelog, DBResultRow::GetDouble(), DBQueryResult::GetRow(), and sDatabase.

                                                             {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT basePrice "
        " FROM invTypes "
        " WHERE typeID = %u ", cloneTypeID))
    {
        codelog(CORP__DB_ERROR, "Failed to retrieve basePrice of typeID = %u",cloneTypeID);
    }
    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "GetCloneTypeCostByID returned no results");
        return 0;
    }
    return row.GetDouble(0);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetContacts

(

uint32

corpID

)

Definition at line 1058 of file CorporationDB.cpp.

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

{
    _log(SOV__DEBUG, "CorporationDB::GetContacts() called...");

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

    PyObjectEx* obj = DBResultToCIndexedRowset(res, "contactID");
    if (is_log_enabled(CORP__RSP_DUMP))
        obj->Dump(CORP__RSP_DUMP, "");

    return obj;
}

Here is the call graph for this function:

void CorporationDB::GetCorpData ( CorpData &  data )

static

Todo:

do we want to put shares here?

Definition at line 2462 of file CorporationDB.cpp.

References _log, CorpData::allianceID, DBerror::c_str(), codelog, CorpData::corpHQ, CorpData::corporationID, DBQueryResult::error, DBResultRow::GetDouble(), DBQueryResult::GetRow(), DBResultRow::GetText(), DBResultRow::GetUInt(), DBResultRow::IsNull(), CorpData::name, sDatabase, CorpData::taxRate, CorpData::ticker, and CorpData::warFactionID.

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  taxRate,"
        "  stationID,"
        "  allianceID,"
        "  warFactionID,"
        "  corporationName,"
        "  tickerName"
        " FROM crpCorporation"
        " WHERE corporationID = %u", data.corporationID))
    {
        codelog(DATABASE__ERROR, "Failed to query data of corporation %u: %s.", data.corporationID, res.error.c_str());
        return;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(DATABASE__MESSAGE, "No data found for character's %u corporation.", data.corporationID);
        return;
    }

    data.taxRate = row.GetDouble(0);
    data.corpHQ = (row.IsNull(1) ? 0 : row.GetUInt(1));
    data.allianceID = (row.IsNull(2) ? 0 : row.GetUInt(2));
    data.warFactionID = (row.IsNull(3) ? 0 : row.GetUInt(3));
    data.name = row.GetText(4);
    data.ticker = row.GetText(5);
}

Here is the call graph for this function:

int32 CorporationDB::GetCorpIDforChar

(

int32

charID

)

Definition at line 2536 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT corporationID FROM chrCharacters WHERE characterID = %u", charID)) {
        codelog(DATABASE__ERROR, "Failed to query data of corporation for chararcterID %u: %s.", charID, res.error.c_str());
        return 0;
    }

    DBResultRow row;
    if (res.GetRow(row))
        return row.GetInt(0);

    _log(DATABASE__MESSAGE, "No data found for character's %u corporation.", charID);
    return 0;
}

Here is the call graph for this function:

PyRep * CorporationDB::GetCorpInfo

(

uint32

corpID

)

Definition at line 133 of file CorporationDB.cpp.

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

                                               {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT corporationID, corporationName, description, creatorID, tickerName,"
        " url, allianceID, deleted, stationID, ceoID, shares, memberCount, taxRate"
        " FROM crpCorporation WHERE corporationID = %u", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in retrieving corporation's data (%u)", corpID);
        return nullptr;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Unable to find corporation's data (%u)", corpID);
        return nullptr;
    }

    //return DBResultToRowset(res);
    return DBRowToKeyVal(row);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetCorpMedalData

(

uint32

corpID

)

Definition at line 332 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT medalID, part, graphic, color FROM crpMedalData"
        " WHERE medalID IN (SELECT medalID FROM crpMedals WHERE ownerID = %u)", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

uint16 CorporationDB::GetCorpMemberCount

(

uint32

corpID

)

Definition at line 1548 of file CorporationDB.cpp.

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

                                                      {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT memberCount"
        " FROM crpCorporation"
        " WHERE corporationID = %u ", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return 0;
    }
    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Cannot find memberCount for corpID %u", corpID);
        return 0;
    }
    return row.GetInt(0);
}

Here is the call graph for this function:

uint16 CorporationDB::GetCorpMemberLimit

(

uint32

corpID

)

Definition at line 1566 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT memberLimit"
        " FROM crpCorporation"
        " WHERE corporationID = %u ", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return 0;
    }
    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Cannot find memberLimit for corpID %u", corpID);
        return 0;
    }
    return row.GetInt(0);
}

Here is the call graph for this function:

std::string CorporationDB::GetCorpName ( uint32  corpID )

static

Definition at line 1724 of file CorporationDB.cpp.

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

Referenced by AllianceBound::FillOAMemberChange(), and AccountService::HandleCorpTransaction().

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

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(CORP__DB_WARNING, "Corporation %u - Corp name not found.", corpID);
        return "Unknown";
    }

    return row.GetText(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject * CorporationDB::GetCorporation

(

uint32

corpID

)

Definition at line 154 of file CorporationDB.cpp.

References codelog, DBRowToRow(), DBQueryResult::GetRow(), IsNPCCorp, and sDatabase.

                                                     {
    // called by corp member. different from GetCorporations() below
    //  not sure what the difference between them is/should be
    std::string table = "crpWalletDivisons";
    if (IsNPCCorp(corpID))
        table = "crpNPCWalletDivisons";
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT "
        "   c.corporationID,c.corporationName,c.description,c.tickerName,c.url,"
        "   c.taxRate,c.minimumJoinStanding,c.corporationType,c.hasPlayerPersonnelManager,"
        "   c.sendCharTerminationMessage,c.creatorID,c.ceoID,c.stationID,c.raceID,"
        "   c.allianceID,c.shares,c.memberCount,c.memberLimit,c.allowedMemberRaceIDs,"
        "   c.shape1,c.shape2,c.shape3,c.color1,c.color2,c.color3,c.typeface,c.deleted,c.isRecruiting,c.warFactionID,"
        "   w.division1,w.division2,w.division3,w.division4,w.division5,w.division6,"
        "   w.division7,w.walletDivision1,w.walletDivision2,w.walletDivision3,w.walletDivision4,"
        "   w.walletDivision5,w.walletDivision6,w.walletDivision7"
        " FROM crpCorporation AS c"
        "  LEFT JOIN %s AS w USING (corporationID)"
        " WHERE corporationID = %u", table.c_str(), corpID))
    {
        codelog(CORP__DB_ERROR, "Error in retrieving corporation's data (%u)", corpID);
        return nullptr;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Unable to find corporation's data (%u)", corpID);
        return nullptr;
    }

    return DBRowToRow(row);
    //return DBResultToRowset(res);
}

Here is the call graph for this function:

PyObject * CorporationDB::GetCorporationBills	(	uint32	corpID,
		bool	payable
	)

Definition at line 223 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (payable) {
        if (!sDatabase.RunQuery(res,
            "SELECT billID, billTypeID, debtorID, creditorID, amount, dueDateTime, interest,"
            "externalID, paid externalID2 FROM billsPayable WHERE debtorID = %u", corpID))
        {
            codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
            return nullptr;
        }
    } else {
        if (!sDatabase.RunQuery(res,
            "SELECT billID, billTypeID, debtorID, creditorID, amount, dueDateTime, interest,"
            "externalID, paid externalID2 FROM billsReceivable WHERE creditorID = %u", corpID))
        {
            codelog(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
            return nullptr;
        }
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

uint32 CorporationDB::GetCorporationCEO ( uint32  corpID )

static

Definition at line 1530 of file CorporationDB.cpp.

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

                                                     {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT ceoID "
        " FROM crpCorporation "
        " WHERE corporationID = %u ", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return 0;
    }
    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "There's either no such corp owner or the corporation has no ceo.");
        return 0;
    }
    return row.GetUInt(0);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetCorporations

(

uint32

corpID

)

Definition at line 189 of file CorporationDB.cpp.

References codelog, DBRowToPackedRow(), DBQueryResult::GetRow(), IsNPCCorp, and sDatabase.

                                                   {
    // called by non-member. different from GetCorporation() above
    //  not sure what the differece between them is/should be
    std::string table = "crpWalletDivisons";
    if (IsNPCCorp(corpID))
        table = "crpNPCWalletDivisons";
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "   c.corporationID,c.corporationName,c.description,c.tickerName,c.url,"
        "   c.taxRate,c.minimumJoinStanding,c.corporationType,c.hasPlayerPersonnelManager,"
        "   c.sendCharTerminationMessage,c.creatorID,c.ceoID,c.stationID,c.raceID,"
        "   c.allianceID,c.shares,c.memberCount,c.memberLimit,c.allowedMemberRaceIDs,"
        "   c.shape1,c.shape2,c.shape3,c.color1,c.color2,c.color3,c.typeface,c.deleted,c.isRecruiting,c.warFactionID,"
        "   w.division1,w.division2,w.division3,w.division4,w.division5,w.division6,"
        "   w.division7,w.walletDivision1,w.walletDivision2,w.walletDivision3,w.walletDivision4,"
        "   w.walletDivision5,w.walletDivision6,w.walletDivision7"
        " FROM crpCorporation AS c"
        "  LEFT JOIN %s AS w USING (corporationID)"
        " WHERE corporationID = %u", table.c_str(), corpID))
    {
        codelog(CORP__DB_ERROR, "Error in retrieving corporation's data (%u)", corpID);
        return nullptr;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Unable to find corporation's data (%u)", corpID);
        return nullptr;
    }

    return DBRowToPackedRow(row);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetCorpRoleGroups

(

)

Definition at line 932 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery( res,
        "SELECT roleGroupID, roleGroupName, roleGroupNameID, roleMask, appliesTo, appliesToGrantable, isLocational, isDivisional"
        " FROM crpRoleGroups"))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetCorpRoles

(

)

Definition at line 921 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery( res, "SELECT roleID, roleName, shortDescriptionID, descriptionID, roleIID FROM crpRoles")) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

void CorporationDB::GetCorpStations	(	uint32	corpID,
		std::vector< uint32 > &	stVec
	)

Definition at line 40 of file CorporationDB.cpp.

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

                                                                            {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT stationID FROM staStations WHERE corporationID=%u", corp_id)) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return;
    }

    DBResultRow row;
    while (res.GetRow(row))
        stVec.push_back(row.GetInt(0));

    return;
}

Here is the call graph for this function:

bool CorporationDB::GetCurrentApplicationInfo

(

Corp::ApplicationInfo &

aInfo

)

Definition at line 1420 of file CorporationDB.cpp.

References Corp::ApplicationInfo::appID, Corp::ApplicationInfo::appText, Corp::ApplicationInfo::appTime, DBerror::c_str(), Corp::ApplicationInfo::charID, codelog, Corp::ApplicationInfo::corpID, Corp::ApplicationInfo::deleted, DBQueryResult::error, DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetText(), Corp::ApplicationInfo::grantRole, Corp::ApplicationInfo::lastCID, Corp::ApplicationInfo::role, sDatabase, Corp::ApplicationInfo::status, and Corp::ApplicationInfo::valid.

                                                                        {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT"
        " applicationID, applicationText, roles, grantableRoles, status,"
        " applicationDateTime, lastCorpUpdaterID, deleted"
        " FROM crpApplications"
        " WHERE characterID = %u AND corporationID = %u AND applicationText = '%s'",
        aInfo.charID, aInfo.corpID, aInfo.appText.c_str()))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        aInfo.valid = false;
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "There's no application matching the sent data.");
        aInfo.valid = false;
        return false;
    }

    aInfo.appID = row.GetInt(0);
    aInfo.appText = row.GetText(1);
    aInfo.role = row.GetInt64(2);
    aInfo.grantRole = row.GetInt64(3);
    aInfo.status = row.GetInt(4);
    aInfo.appTime = row.GetInt64(5);
    aInfo.lastCID = row.GetInt(6);
    aInfo.deleted = row.GetInt(7);
    aInfo.valid = true;
    return true;
}

Here is the call graph for this function:

std::string CorporationDB::GetDivisionName ( uint32  corpID, uint16  acctKey  )

static

Definition at line 1741 of file CorporationDB.cpp.

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

Referenced by AccountService::HandleCorpTransaction().

{
    std::string acctKeyName = "";
    switch (acctKey) {
        case Account::KeyType::Cash:    acctKeyName = "division1"; break;
        case Account::KeyType::Cash2:   acctKeyName = "division2"; break;
        case Account::KeyType::Cash3:   acctKeyName = "division3"; break;
        case Account::KeyType::Cash4:   acctKeyName = "division4"; break;
        case Account::KeyType::Cash5:   acctKeyName = "division5"; break;
        case Account::KeyType::Cash6:   acctKeyName = "division6"; break;
        case Account::KeyType::Cash7:   acctKeyName = "division7"; break;
    }

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

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(CORP__DB_WARNING, "Corporation %u - division name for acctKey %u not found.", corpID, acctKey);
        return "Unknown";
    }

    return row.GetText(0);
}

Here is the call graph for this function:

Here is the caller graph for this function:

PyObject * CorporationDB::GetEmploymentRecord

(

uint32

charID

)

Definition at line 247 of file CorporationDB.cpp.

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

                                                          {
    DBQueryResult res;
    //do we really need this order by??
    if (!sDatabase.RunQuery(res,
        "SELECT startDate, corporationID, deleted "
        "   FROM chrEmployment "
        "   WHERE characterID = %u "
        "   ORDER BY startDate DESC", charID
        ))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyObject * CorporationDB::GetEveOwners

(

uint32

corpID

)

Definition at line 1107 of file CorporationDB.cpp.

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

                                                   {
    DBQueryResult res;
/*
            [PyPackedRow 9 bytes]
              ["ownerID" => <90046865> [I4]]
              ["ownerName" => <Septure> [WStr]]
              ["typeID" => <1375> [I4]]
              ["gender" => <1> [Bool]]
              */

    if (!sDatabase.RunQuery( res,
        "SELECT"
        " characterID AS ownerID,"
        " characterName AS ownerName,"
        " typeID,"
        " gender"
        " FROM chrCharacters"
        " WHERE corporationID = %u", corpID
        ))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetItemEvents	(	uint32	corpID,
		uint32	charID,
		int64	fromDate,
		int64	toDate,
		uint8	rowsPerPage
	)

Definition at line 1911 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT eventID, corporationID, characterID, eventTypeID, eventDateTime"
        " FROM crpItemEvent"
        " WHERE corporationID = %u AND characterID = %u AND eventDateTime > %li AND eventDateTime <= %li "
        " LIMIT %u", corpID, charID, fromDate, toDate, rowsPerPage))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
/*
    PyList* list = new PyList();
    if (res.GetRowCount() > 0) {
        DBResultRow row;
        while (res.GetRow(row)) {
            PyDict* dict = new PyDict();
                dict->SetItemString("eventID", new PyInt(row.GetInt(0)));
                dict->SetItemString("corporationID", new PyInt(row.GetInt(1)));
                dict->SetItemString("characterID", new PyInt(row.GetInt(2)));
                dict->SetItemString("eventTypeID", new PyInt(row.GetInt(3)));
                dict->SetItemString("eventDateTime", new PyLong(row.GetInt64(4)));
            list->AddItem(dict);
        }
    } else {
        PyDict* dict = new PyDict();
        dict->SetItemString("eventID", new PyInt(0));
        dict->SetItemString("corporationID", new PyInt(0));
        dict->SetItemString("characterID", new PyInt(0));
        dict->SetItemString("eventTypeID", new PyInt(0));
        dict->SetItemString("eventDateTime", new PyInt(0));
        list->AddItem(dict);
    }

    return new PyObject("util.KeyVal", list);
    */
}

Here is the call graph for this function:

PyRep * CorporationDB::GetKillsAndLosses	(	uint32	corpID,
		uint32	number,
		uint32	offset
	)

Definition at line 2408 of file CorporationDB.cpp.

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

{
    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 victimCorporationID = %u OR finalCorporationID = %u", corpID, corpID))
    {
        codelog(CORP__DB_ERROR, "Error on query: %s", res.error.c_str());
        return nullptr;
    }

    _log(DATABASE__RESULTS, "CorporationDB::GetKillsAndLosses for corpID: %u returned %u items", corpID, res.GetRowCount());

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetLabels

(

uint32

corpID

)

Definition at line 2511 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT labelID, color, name FROM crpLabels WHERE ownerID = %u", corpID)) {
        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:

PyObjectEx * CorporationDB::GetMedalDetails

(

int32

medalID

)

Definition at line 377 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT medalID, ownerID, creatorID, noRecepients AS numberOfRecipients, date, title, description FROM crpMedals"
        " WHERE medalID = %i", medalID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    //  SELECT medalID, ownerID, creatorID, noRecepients, date, title, description FROM crpMedals WHERE medalID

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetMedalsReceived

(

int32

charID

)

Definition at line 346 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT chr.medalID, crp.creatorID, crp.noRecepients, crp.date, crp.title, crp.description, chr.status"
        " FROM chrMedals AS chr"
        " LEFT JOIN crpMedals AS crp USING (medalID)"
        " WHERE chr.recepientID = %i", charID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetMedalsReceivedDetails

(

int32

charID

)

Definition at line 362 of file CorporationDB.cpp.

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

{
    // SELECT recepientID, medalID, corpID, dateTime FROM chrMedals WHERE recepientID = %u
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT medalID, part, graphic, color FROM crpMedalData"
        " WHERE medalID IN (SELECT medalID FROM chrMedals WHERE recepientID = %i)", charID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetMedalStatuses

(

)

Definition at line 393 of file CorporationDB.cpp.

References DBResultToRowset(), and sDatabase.

{
    // this is for viewing permissions on paperdoll
    DBQueryResult res;
    sDatabase.RunQuery(res, "SELECT statusID, statusName FROM crpMedalStatus");
    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetMember

(

uint32

charID

)

Definition at line 773 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT "
        "  characterID, "
        "  corporationID,"
        "  corpAccountKey AS divisionID,"
        "  0 AS squadronID,"
        "  title, "
        "  corpRole AS roles,"
        "  rolesAtAll, "
        "  grantableRoles, "
        "  startDateTime, "
        "  baseID,"
        "  rolesAtHQ, "
        "  grantableRolesAtHQ, "
        "  rolesAtBase, "
        "  grantableRolesAtBase,"
        "  rolesAtOther, "
        "  grantableRolesAtOther, "
        "  titleMask,"
        "  startDateTime AS rowDate,"
        "  blockRoles,"
        "  characterName"
        " FROM chrCharacters"
        " WHERE characterID = %u", charID))
    {
        codelog(CORP__DB_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:

uint16 CorporationDB::GetMemberCount

(

uint32

corpID

)

Definition at line 892 of file CorporationDB.cpp.

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

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

    DBResultRow row;
    if (res.GetRow(row))
        return (row.GetInt(0));

    return 0;
}

Here is the call graph for this function:

void CorporationDB::GetMemberIDs ( uint32  corpID, std::vector< uint32 > &  ids, bool  online = true  )

static

Definition at line 907 of file CorporationDB.cpp.

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

{
    ids.clear();
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT characterID FROM chrCharacters WHERE corporationID = %u AND online = %u", corpID, (online?1:0) )) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return;
    }

    DBResultRow row;
    while (res.GetRow(row))
        ids.push_back(row.GetInt(0));
}

Here is the call graph for this function:

void CorporationDB::GetMembers	(	uint32	corpID,
		DBQueryResult &	res
	)

Definition at line 811 of file CorporationDB.cpp.

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

{
    if (!sDatabase.RunQuery(res,
        " SELECT "
        "  characterID, "
        "  corporationID,"
        "  corpAccountKey AS divisionID,"
        //"  0 AS squadronID,"
        "  title, "
        "  rolesAtAll, "
        "  grantableRoles, "
        "  startDateTime, "
        "  baseID,"
        "  rolesAtHQ, "
        "  grantableRolesAtHQ, "
        "  rolesAtBase, "
        "  grantableRolesAtBase,"
        "  rolesAtOther, "
        "  grantableRolesAtOther, "
        "  titleMask,"
        "  corpAccountKey,"
        //"  %f AS rowDate,"
        "  blockRoles,"
        "  characterName"
        " FROM chrCharacters"
        " WHERE corporationID = %u", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
    }
}

Here is the call graph for this function:

void CorporationDB::GetMembersForQuery	(	std::ostringstream &	query,
		std::vector< uint32 > &	result
	)

Definition at line 842 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, query.str().c_str())) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return;
    }

    _log(DATABASE__RESULTS, "CorporationDB::GetMembersForQuery '%s' returned %u items", query.str().c_str(), res.GetRowCount());

    DBResultRow row;
    while (res.GetRow(row))
        result.push_back(row.GetInt(0));
}

Here is the call graph for this function:

void CorporationDB::GetMembersPaged	(	uint32	corpID,
		uint8	page,
		DBQueryResult &	res
	)

Definition at line 857 of file CorporationDB.cpp.

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

{
    if (!sDatabase.RunQuery(res,
        " SELECT "
        "  characterID, "
        "  corporationID,"
        //"  0 AS divisionID,"
        //"  0 AS squadronID,"
        "  title, "
        "  rolesAtAll, "
        "  grantableRoles, "
        "  startDateTime, "
        //"  clone.locationID,"
        "  rolesAtHQ, "
        "  grantableRolesAtHQ, "
        "  rolesAtBase, "
        "  grantableRolesAtBase,"
        "  rolesAtOther, "
        "  grantableRolesAtOther, "
        "  titleMask,"
        "  corpAccountKey, "
        "  baseID,"
        "  blockRoles,"
        "  characterName"
        " FROM chrCharacters"
        //"  LEFT JOIN entity AS clone ON clone.ownerID = characterID"
        " WHERE corporationID = %u"
        " LIMIT %u", corpID, page * 10))
        //"  AND clone.flag='400'"
        //"  AND clone.customInfo='active'"
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
    }
}

Here is the call graph for this function:

PyRep * CorporationDB::GetMemberTrackingInfo

(

uint32

corpID

)

Definition at line 1859 of file CorporationDB.cpp.

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

{
    //  lastOnline(hours) needs update based on char logoffDateTime using GetElapsedHours();
    // no idea how to do that short of pulling/updating column every (x time) interval....and uh, no.
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT c.characterID, c.corporationID, c.title, c.startDateTime, c.corpRole AS roles, c.baseID, c.grantableRoles, c.blockRoles,"
        " c.logonDateTime, c.logoffDateTime, c.locationID, IFNULL(e.typeID, 0) AS shipTypeID, -1 AS lastOnline"
        " FROM chrCharacters AS c"
        "  LEFT JOIN entity AS e ON e.itemID = c.shipID"
        " WHERE c.corporationID = %u", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetMemberTrackingInfoSimple

(

uint32

corpID

)

Definition at line 1877 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT c.characterID, c.corporationID, c.logoffDateTime, c.logonDateTime, c.title, c.startDateTime, c.corpRole AS roles,"
        " c.baseID, c.blockRoles, IFNULL(e.typeID, 0) AS shipTypeID"
        " FROM chrCharacters AS c"
        "  LEFT JOIN entity AS e ON e.itemID = c.shipID"
        " WHERE corporationID = %u", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetMktInfo

(

uint32

corpID

)

Definition at line 2444 of file CorporationDB.cpp.

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

{
    // bid = buy order
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT sell.typeID AS typeID, sell.price AS sellPrice, sell.volRemaining AS sellQuantity, sell.issued AS sellDate, sell.stationID AS sellStationID, "
        " buy.price AS buyPrice, buy.volRemaining AS buyQuantity, buy.issued AS buyDate, buy.stationID AS buyStationID"
        " FROM mktOrders AS sell, mktOrders AS buy"
        " WHERE sell.ownerID = %u AND buy.ownerID = %u AND sell.typeID = buy.typeID AND sell.bid=0 AND buy.bid=1", corpID, corpID))    // bid=buy order
    {
        codelog(CORP__DB_ERROR, "Error on query: %s", res.error.c_str());
    }

    _log(DATABASE__RESULTS, "CorporationDB::GetMktBuyInfo for corpID: %u returned %u items", corpID, res.GetRowCount());

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetMyApplications

(

uint32

charID

)

Definition at line 1380 of file CorporationDB.cpp.

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

                                                     {
    //    header = [applicationID, corporationID, characterID, applicationText, roles, grantableRoles, status, applicationDateTime, deleted, lastCorpUpdaterID]
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT applicationID, corporationID, characterID, applicationText, roles, grantableRoles,"
        " status, applicationDateTime, deleted, lastCorpUpdaterID"
        " FROM crpApplications"
        " WHERE characterID = %u ", charID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    PyObjectEx* obj = DBResultToCRowset(res);
    if (is_log_enabled(CORP__RSP_DUMP))
        obj->Dump(CORP__RSP_DUMP, "");

    return obj;
}

Here is the call graph for this function:

PyRep * CorporationDB::GetMyShares

(

uint32

ownerID

)

Definition at line 2257 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT corporationID, shareholderID, shares, shareholderCorporationID"
        " FROM crpShares"
        " WHERE shareholderID = %u ", ownerID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetRecipientsOfMedal

(

int32

medalID

)

Definition at line 303 of file CorporationDB.cpp.

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

{
    //  SELECT recepientID, medalID, corpID, date, status FROM chrMedals WHERE recepientID = %u
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT recepientID, issuerID, date, reason, status"
        " FROM chrMedals"
        " WHERE medalID = %i", medalID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetRecruiters	(	int32	corpID,
		uint16	adID
	)

Definition at line 1262 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT charID FROM crpRecruiters WHERE corpID = %u AND adID = %u", corpID, adID)) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    PyTuple* tuple = new PyTuple(res.GetRowCount());
    int8 i = 0;
    DBResultRow row;
    while (res.GetRow(row))
        tuple->SetItem(i++, new PyInt(row.GetInt(0)));

    return tuple;
}

Here is the call graph for this function:

PyRep * CorporationDB::GetRoleHistroy	(	uint32	corpID,
		uint32	charID,
		int64	fromDate,
		int64	toDate,
		uint8	rowsPerPage
	)

Definition at line 1960 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT corporationID, characterID, issuerID, changeTime, oldRoles, newRoles, grantable"
        " FROM crpRoleHistroy"
        " WHERE corporationID = %u and characterID = %u AND changeTime > %li AND changeTime <= %li "
        " LIMIT %u", corpID, charID, fromDate, toDate, rowsPerPage))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCRowset(res);
/*
    PyList* list = new PyList();
    if (res.GetRowCount() > 0) {
        DBResultRow row;
        while (res.GetRow(row)) {
        PyDict* dict = new PyDict();
            dict->SetItemString("corporationID", new PyInt(row.GetInt(0)));
            dict->SetItemString("charID", new PyInt(row.GetInt(1)));
            dict->SetItemString("issuerID", new PyInt(row.GetInt(2)));
            dict->SetItemString("changeTime", new PyLong(row.GetInt64(3)));
            dict->SetItemString("oldRoles", new PyLong(row.GetInt64(4)));
            dict->SetItemString("newRoles", new PyLong(row.GetInt64(5)));
            dict->SetItemString("grantable", new PyBool(row.GetBool(6)));
        list->AddItem(dict);
        }
    } else {
        PyDict* dict = new PyDict();
            dict->SetItemString("corporationID", new PyInt(0));
            dict->SetItemString("charID", new PyInt(0));
            dict->SetItemString("issuerID", new PyInt(0));
            dict->SetItemString("changeTime", new PyInt(0));
            dict->SetItemString("oldRoles", new PyInt(0));
            dict->SetItemString("newRoles", new PyInt(0));
            dict->SetItemString("grantable", new PyBool(false));
        list->AddItem(dict);
    }

    return new PyObject("util.KeyVal", list);
    */
}

Here is the call graph for this function:

PyRep * CorporationDB::GetSanctionedItems	(	uint32	corpID,
		uint8	status = 0
	)

Definition at line 2117 of file CorporationDB.cpp.

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

{   // working
    // status - 0:default, 1: open, 2: closed
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT voteCaseID, voteType, inEffect, actedUpon, timeActedUpon, timeRescended, endDateTime AS expires"
        " FROM crpVoteItems"
        " WHERE corporationID = %u ", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    //return DBResultToPackedRowDict(res, "voteCaseID");
    //return DBResultToCIndexedRowset(res, "voteCaseID");
    //return DBResultToIndexRowset(res, "voteCaseID");
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetShares

(

uint32

corpID

)

Definition at line 2243 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT corporationID, shareholderID, shares, shareholderCorporationID"
        " FROM crpShares"
        " WHERE corporationID = %u ", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    return DBResultToIndexRowset(res, "shareholderID");
}

Here is the call graph for this function:

PyRep * CorporationDB::GetSharesForCorp

(

uint32

corpID

)

Definition at line 2271 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT shareholderID FROM crpShares WHERE corporationID = %u AND shareholderID < 98000000", corpID)) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    DBResultRow row;
    PyList* list = new PyList();
    while (res.GetRow(row))
        list->AddItem(new PyInt(row.GetInt(1)));

    return list;
}

Here is the call graph for this function:

uint32 CorporationDB::GetStationCorporationCEO

(

uint32

stationID

)

Definition at line 1509 of file CorporationDB.cpp.

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

                                                               {
    if (!sDataMgr.IsStation(stationID))
        return 0;
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT c.ceoID "
        " FROM crpCorporation AS c"
        " LEFT JOIN staStations USING (corporationID) "
        " WHERE staStations.stationID = %u ", stationID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return 0;
    }
    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "There's either no such station or the station has no corp owner or the corporation has no ceo.");
        return 0;
    }
    return row.GetUInt(0);
}

Here is the call graph for this function:

uint32 CorporationDB::GetStationOwner

(

uint32

stationID

)

Definition at line 1183 of file CorporationDB.cpp.

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

                                                      {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT corporationID "
        " FROM staStations "
        " WHERE stationID = %u ", stationID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return 0;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Missing stationID: %u", stationID);
        return 0;
    }
    return row.GetUInt(0);
}

Here is the call graph for this function:

PyObject * CorporationDB::GetStations

(

uint32

corpID

)

Definition at line 1134 of file CorporationDB.cpp.

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

                                                  {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        " SELECT "
        " stationID, stationTypeID as typeID "
        " FROM staStations "
        " WHERE corporationID = %u ", corpID
        ))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyRep * CorporationDB::GetTitles

(

uint32

corpID

)

Definition at line 1014 of file CorporationDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBResultRow::GetInt(), DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetText(), sDatabase, PyDict::SetItem(), and PyDict::SetItemString().

{
    DBQueryResult res;
    if (!sDatabase.RunQuery( res,
        "SELECT corporationID, titleID, titleName, roles, grantableRoles, rolesAtHQ, grantableRolesAtHQ, rolesAtBase, grantableRolesAtBase, rolesAtOther, grantableRolesAtOther "
        " FROM crpRoleTitles WHERE corporationID = %u", corpID)) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    PyDict* dict = new PyDict();
    DBResultRow row;
    while (res.GetRow(row)) {
        PyDict* dict1 = new PyDict();
            dict1->SetItemString("corporationID", new PyInt(row.GetInt(0)));
            dict1->SetItemString("titleID", new PyInt(row.GetInt(1)));
            dict1->SetItemString("titleName", new PyString(row.GetText(2)));
            dict1->SetItemString("roles", new PyLong(row.GetInt64(3)));
            dict1->SetItemString("grantableRoles", new PyLong(row.GetInt64(4)));
            dict1->SetItemString("rolesAtHQ", new PyLong(row.GetInt64(5)));
            dict1->SetItemString("grantableRolesAtHQ", new PyLong(row.GetInt64(6)));
            dict1->SetItemString("rolesAtBase", new PyLong(row.GetInt64(7)));
            dict1->SetItemString("grantableRolesAtBase", new PyLong(row.GetInt64(8)));
            dict1->SetItemString("rolesAtOther", new PyLong(row.GetInt64(9)));
            dict1->SetItemString("grantableRolesAtOther", new PyLong(row.GetInt64(10)));
        dict->SetItem(new PyInt(row.GetInt(1)), new PyObject("util.KeyVal", dict1));
    }

    return dict;
}

Here is the call graph for this function:

PyRep * CorporationDB::GetVoteItems	(	uint32	corpID,
		uint8	status = 0,
		uint8	maxLen = 20
	)

Definition at line 2077 of file CorporationDB.cpp.

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

{   // working
    if (maxLen == 0)
        maxLen = 20;
    std::string statusTxt = "";
    if (status != 0) {
        statusTxt = "AND status = ";
        statusTxt += std::to_string(status);
    }

    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT voteCaseID, voteType, voteCaseText, description, inEffect, status, actedUpon, timeActedUpon,"
        " rescended, timeRescended, startDateTime, endDateTime"
        " FROM crpVoteItems"
        " WHERE corporationID = %u "
        " %s"
        " LIMIT 0,%u", corpID, statusTxt.c_str(), maxLen))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
    return DBResultToPackedRowDict(res, "voteCaseID");
}

Here is the call graph for this function:

PyRep * CorporationDB::GetVoteOptions

(

uint32

voteCaseID

)

Definition at line 2103 of file CorporationDB.cpp.

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

{   // working
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT voteCaseID, optionID, optionText, parameter, parameter1, parameter2, votesFor"
        " FROM crpVoteOptions WHERE voteCaseID = %u", voteCaseID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToIndexRowset(res, "optionID");
}

Here is the call graph for this function:

PyRep * CorporationDB::GetVotes

(

uint32

voteCaseID

)

Definition at line 2136 of file CorporationDB.cpp.

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

{   // working
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT charID, voteCaseID, optionID FROM crpVotes"
        " WHERE voteCaseID = %u", voteCaseID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToCIndexedRowset(res, "charID");
}

Here is the call graph for this function:

void CorporationDB::GiveMedalToCharacters	(	uint32	issuerID,
		uint32	corpID,
		int32	medalID,
		std::vector< uint32 > &	charVec,
		std::string &	reason
	)

Definition at line 401 of file CorporationDB.cpp.

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

{
    // INSERT INTO chrMedals(recepientID, medalID, corpID, issuerID, reason, date, status) VALUES ()

    // loop thru data and add to query
    std::ostringstream query;
    query << "INSERT INTO chrMedals(recepientID, medalID, corpID, issuerID, date, reason)";
    query << "VALUES ";

    bool first = true;
    for (auto cur : charVec) {
        if (first) {
            first = false;
        } else {
            query << ",";
        }
        query << "(" << std::to_string(cur) << "," << std::to_string(medalID) << "," << std::to_string(corpID) << "," << std::to_string(issuerID) << ",";
        query << std::to_string(GetFileTimeNow()) << ",'" << reason.c_str() << "')";
    }

    if (!first ) {
        DBerror err;
        sDatabase.RunQuery(err, query.str().c_str());
        sDatabase.RunQuery(err, "UPDATE crpMedals SET noRecepients=noRecepients + 1 WHERE medalID = %u", medalID );
    }
}

Here is the call graph for this function:

bool CorporationDB::HasShares	(	uint32	charID,
		uint32	corpID
	)

Definition at line 2287 of file CorporationDB.cpp.

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

Referenced by EntityList::CorpNotify().

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

    if (res.GetRowCount())
        return true;

    return false;
}

Here is the call graph for this function:

Here is the caller graph for this function:

bool CorporationDB::InsertApplication

(

Corp::ApplicationInfo &

aInfo

)

Definition at line 1454 of file CorporationDB.cpp.

References _log, Corp::ApplicationInfo::appID, Corp::ApplicationInfo::appText, Corp::ApplicationInfo::appTime, DBerror::c_str(), Corp::ApplicationInfo::charID, codelog, Corp::ApplicationInfo::corpID, sDatabase, and Corp::ApplicationInfo::valid.

                                                                {
    if (!aInfo.valid) {
        _log(CORP__DB_WARNING, "InsertApplication(): aInfo contains invalid data");
        return false;
    }

    std::string escaped;
    sDatabase.DoEscapeString(escaped, aInfo.appText);
    DBerror err;
    if (!sDatabase.RunQueryLID(err, aInfo.appID,
        " INSERT INTO crpApplications"
        " (corporationID, characterID, applicationText, applicationDateTime)"
        " VALUES (%u, %u, '%s', %li)",
        aInfo.corpID, aInfo.charID, escaped.c_str(), aInfo.appTime))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", err.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

bool CorporationDB::IsTickerTaken

(

std::string

ticker

)

Definition at line 434 of file CorporationDB.cpp.

References DBQueryResult::GetRowCount(), and sDatabase.

                                                  {
    DBQueryResult res;
    sDatabase.RunQuery(res, " SELECT corporationID FROM crpCorporation WHERE tickerName = '%s'", ticker.c_str());
    return (res.GetRowCount() != 0);
}

Here is the call graph for this function:

PyObject * CorporationDB::ListStationCorps

(

uint32

station_id

)

Definition at line 69 of file CorporationDB.cpp.

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

                                                           {
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT "
        "   corporationID,corporationName,description,shares,graphicID,"
        "   memberCount,ceoID,stationID,raceID,corporationType,creatorID,"
        "   hasPlayerPersonnelManager,tickerName,sendCharTerminationMessage,"
        "   shape1,shape2,shape3,color1,color2,color3,typeface,memberLimit,"
        "   allowedMemberRaceIDs,url,taxRate,minimumJoinStanding,division1,"
        "   division2,division3,division4,division5,division6,division7,"
        "   allianceID,deleted,isRecruiting"
        " FROM crpCorporation"
//no idea what the criteria should be here...
        " WHERE stationID=%u",
            station_id
    ))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

PyObject * CorporationDB::ListStationOwners

(

uint32

station_id

)

Todo:

this needs work....

Definition at line 93 of file CorporationDB.cpp.

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

                                                           {
    DBQueryResult res;
  if (sDataMgr.IsStation(stationID)) {
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  s.corporationID AS ownerID,"
        "  c.corporationName AS ownerName,"
        "  c.corporationType AS typeID,"
        //"  c.corporationID AS ownerNameID,"
        "  cs.gender"
        " FROM staStations AS s"
        "  LEFT JOIN crpCorporation AS c ON cs.corporationID = c.corporationID"
        "  LEFT JOIN chrNPCCharacters AS cs ON cs.characterID = c.ceoID"
        " WHERE s.stationID = %u", stationID ))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
  } else {
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  c.corporationID AS ownerID,"
        "  c.corporationName AS ownerName,"
        "  c.corporationType AS typeID,"
        //"  c.corporationID AS ownerNameID,"
        "  cs.gender"
        " FROM entity AS e"
        "  LEFT JOIN crpCorporation AS c USING ( corporationID )"
        "  LEFT JOIN chrCharacters AS cs ON cs.characterID = c.ceoID"
        " WHERE e.itemID = %u", stationID ))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return nullptr;
    }
  }

    return DBResultToRowset(res);
}

Here is the call graph for this function:

void CorporationDB::MoveShares	(	uint32	ownerID,
		uint32	corpID,
		Call_MoveShares &	args
	)

Todo:

update this to use CorpNotify()

Todo:

pClient may be null here....

Definition at line 2161 of file CorporationDB.cpp.

References MulticastTarget::characters, MulticastTarget::corporations, CharacterDB::GetCorpID(), Client::GetCorporationID(), DBResultRow::GetInt(), DBQueryResult::GetRow(), IsCharacterID, IsPlayerCorp, sDatabase, Client::SendNotification(), and sEntityList.

{   // working
    //MoveShares(corporationID, toShareholderID, numberOfShares)
    //  this will also send share update notifications as its' easier to do here..

    // get old owner data
    bool isCorp = false;
    if (IsPlayerCorp(ownerID))
        isCorp = true;
    DBQueryResult res;
    sDatabase.RunQuery(res,"SELECT shares FROM crpShares WHERE corporationID = %u AND shareholderID = %u ", corpID, ownerID);
    DBResultRow row;
    if (res.GetRow(row)) {
        // add to notification
        OnCorpShareChange corpUpdate;
            corpUpdate.corpID = corpID;
            corpUpdate.ownerID = ownerID;
            corpUpdate.oldShares = row.GetInt(0);
            corpUpdate.newShares = row.GetInt(0) - args.numberOfShares;
        MulticastTarget mct;
        if (isCorp) {
            mct.corporations.insert(corpID);
        } else {
            mct.characters.insert(ownerID);
        }
        PyTuple* tuple = corpUpdate.Encode();
        sEntityList.Multicast("OnShareChange", "*corpid&corprole", &tuple, mct);
    }

    DBerror err;
    // remove from old owner
    sDatabase.RunQuery(err,
        "UPDATE crpShares SET shares = shares - %i"
        " WHERE corporationID = %u AND shareholderID = %u ", args.numberOfShares, args.corporationID, ownerID);

    // get new owner data
    uint16 oldShares = 0;
    uint32 oldCorpID = 0;
    Client* pClient(nullptr);
    if (IsCharacterID(args.toShareholderID)) {
        pClient = sEntityList.FindClientByCharID(args.toShareholderID);
        if (pClient == nullptr) {
            oldCorpID = CharacterDB::GetCorpID(args.toShareholderID);
        } else {
            oldCorpID = pClient->GetCorporationID();
        }
    }
    OnCharShareChange charUpdate;
    charUpdate.ownerID = args.toShareholderID;
    charUpdate.corpID = corpID;
    charUpdate.newShares = args.numberOfShares; // plus existing shares this owner has of this corp
    //res.Reset();
    sDatabase.RunQuery(res,"SELECT shares, shareholderCorporationID FROM crpShares WHERE corporationID = %u AND shareholderID = %u ", corpID, args.toShareholderID);
    // this isnt completely right.   also throws error
    //  AttributeError: 'dict' object has no attribute 'header'
    if (res.GetRow(row)) {
        charUpdate.oldShares = (oldShares = row.GetInt(0));
        charUpdate.oldCorpID = row.GetInt(1);
        charUpdate.oldOwnerID = args.toShareholderID;
        charUpdate.newOwnerOldCorpID = (isCorp ? 0 : oldCorpID);
    } else {
        charUpdate.oldShares = 0;
        charUpdate.oldCorpID = 0;
        charUpdate.oldOwnerID = 0;
        charUpdate.newOwnerOldCorpID = 0;
    }

    charUpdate.newShares = (oldShares + args.numberOfShares);
    charUpdate.newCorpID = corpID;
    charUpdate.newOwnerID = args.toShareholderID;
    charUpdate.newOwnerNewCorpID = (isCorp ? 0 : oldCorpID);
    pClient->SendNotification("OnShareChange", "charid", charUpdate.Encode());

    // add to new owner
    sDatabase.RunQuery(err,
        "INSERT INTO crpShares (corporationID, shareholderID, shares, shareholderCorporationID)"
        " VALUES (%i, %i, %i, %u)"
        " ON DUPLICATE KEY UPDATE shares = shares + %i", args.corporationID, args.toShareholderID, args.numberOfShares, corpID, args.numberOfShares);
}

Here is the call graph for this function:

PyRep * CorporationDB::PyHasShares	(	uint32	charID,
		uint32	corpID
	)

Definition at line 2301 of file CorporationDB.cpp.

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

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, "SELECT shares FROM crpShares WHERE shareholderID = %u AND corporationID = %u", charID, corpID))  {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return PyStatic.NewFalse();
    }

    if (res.GetRowCount())
        return PyStatic.NewTrue();

    return PyStatic.NewFalse();
}

Here is the call graph for this function:

void CorporationDB::RemoveContact	(	uint32	contactID,
		uint32	ownerID
	)

Definition at line 1097 of file CorporationDB.cpp.

References sDatabase.

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

void CorporationDB::SaveMedalData	(	int64	medalID,
		std::vector< Corp::MedalData > &	dataList
	)

Definition at line 278 of file CorporationDB.cpp.

References DBerror::c_str(), and sDatabase.

{
    // loop thru data and add to query
    std::ostringstream query;
    query << "INSERT INTO crpMedalData(medalID, part, graphic, color)";
    query << "VALUES ";

    bool first = true;
    for (auto cur : dataList) {
        if (first) {
            first = false;
        } else {
            query << ",";
        }
        query << "(" << std::to_string(medalID) << "," << std::to_string(cur.part) << ",'" << cur.graphic << "'," << std::to_string(cur.color) << ")";
    }

    if (!first ) {
        DBerror err;
        sDatabase.RunQuery(err, query.str().c_str());
    }

    //SELECT id, part, graphic, color FROM crpMedalData
}

Here is the call graph for this function:

void CorporationDB::SetAutoPay

(

)

Definition at line 1898 of file CorporationDB.cpp.

{
    //UPDATE crpAutoPay SET corporationID=[value-1],market=[value-2],rental=[value-3],broker=[value-4],war=[value-5],alliance=[value-6],sov=[value-7] WHERE 1
}

void CorporationDB::SetLabel	(	uint32	corpID,
		uint32	color,
		std::string	name
	)

Definition at line 2522 of file CorporationDB.cpp.

References sDatabase.

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

    DBQueryResult res;
    sDatabase.RunQuery(res, "INSERT INTO crpLabels (color, name, ownerID) VALUES (%u, '%s', %u)", color, escaped.c_str(), corpID);
}

void CorporationDB::SetMedalStatus	(	uint32	charID,
		uint16	medalID,
		uint8	status
	)

Definition at line 428 of file CorporationDB.cpp.

References sDatabase.

{
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE chrMedals SET status = %u WHERE recepientID = %u AND medalID = %u", status, charID, medalID);
}

void CorporationDB::UpdateAdvert	(	uint16	adID,
		uint32	corpID,
		int64	typeMask,
		int8	days,
		uint16	members,
		std::string	description,
		uint32	channelID,
		std::string	title
	)

Definition at line 1359 of file CorporationDB.cpp.

References DBerror::c_str(), EvE::Time::Day, GetFileTimeNow(), and sDatabase.

{
    int64 time = GetFileTimeNow() + (EvE::Time::Day * days);
    DBerror err;
    sDatabase.RunQuery(err, "UPDATE crpAdRegistry"
        " SET typeMask=%li, expiryDateTime=%li, description='%s', title='%s', memberCount=%u, channelID=%u"
        " WHERE adID=%u ",
        typeMask, time, description.c_str(), title.c_str(), members, channelID, adID);
}

Here is the call graph for this function:

bool CorporationDB::UpdateApplication

(

const Corp::ApplicationInfo &

aInfo

)

Definition at line 1476 of file CorporationDB.cpp.

References _log, Corp::ApplicationInfo::appID, Corp::ApplicationInfo::appText, DBerror::c_str(), codelog, Corp::ApplicationInfo::lastCID, sDatabase, Corp::ApplicationInfo::status, and Corp::ApplicationInfo::valid.

                                                                      {
    if (!aInfo.valid) {
        _log(CORP__DB_WARNING, "UpdateApplication(): info contains invalid data");
        return false;
    }

    DBerror err;
    std::string escaped;
    sDatabase.DoEscapeString(escaped, aInfo.appText);
    if (!sDatabase.RunQuery(err,
        " UPDATE crpApplications"
        " SET status = %u, lastCorpUpdaterID = %u, applicationText = '%s'"
        " WHERE applicationID = %u", aInfo.status, aInfo.lastCID, escaped.c_str(), aInfo.appID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", err.c_str());
        return false;
    }
    return true;
}

Here is the call graph for this function:

void CorporationDB::UpdateContact	(	int32	relationshipID,
		uint32	contactID,
		uint32	ownerID
	)

Definition at line 1088 of file CorporationDB.cpp.

References sDatabase.

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

void CorporationDB::UpdateCorpHQ ( uint32  corpID, uint32  stationID  )

static

Definition at line 2495 of file CorporationDB.cpp.

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

{
    DBerror err;
    if (!sDatabase.RunQuery(err, "UPDATE crpCorporation SET stationID = %u WHERE corporationID = %u", stationID, corpID))
        codelog(CORP__DB_ERROR, "Error in UpdateCorpHQ query: %s", err.c_str());
}

Here is the call graph for this function:

bool CorporationDB::UpdateCorporation	(	uint32	corpID,
		const Call_UpdateCorporation &	upd,
		PyDict *	notif
	)

Definition at line 1770 of file CorporationDB.cpp.

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

                                                                                                       {
    DBQueryResult res;

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

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Corporation %u doesn't exists.", corpID);
        return false;
    }

    std::vector<std::string> dbQ;
    ProcessStringChange("description", row.GetText(0), upd.description, notif, dbQ);
    ProcessStringChange("url", row.GetText(1), upd.address, notif, dbQ);
    ProcessRealChange("taxRate", row.GetDouble(2), upd.tax, notif, dbQ);

    std::string query = " UPDATE crpCorporation SET ";

    int N = dbQ.size();
    for (int i = 0; i < N; i++) {
        query += dbQ[i];
        if (i < N - 1) query += ", ";
    }

    query += " WHERE corporationID = %u";

    // only update if there is anything to update
    if ((N > 0) && (!sDatabase.RunQuery(res.error, query.c_str(), corpID))) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

bool CorporationDB::UpdateDivisionNames	(	uint32	corpID,
		const Call_UpdateDivisionNames &	divs,
		PyDict *	notif
	)

Definition at line 1661 of file CorporationDB.cpp.

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

                                                                                                          {
    //  updated to update wallet names, too.   -allan 14Jan15
    if (IsNPCCorp(corpID))
        return false; // make error here for changing npc corp data?  nah, should NEVER hit
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        "SELECT"
        "  division1, division2, division3, division4, division5, division6, division7,"
        "  walletDivision2, walletDivision3, walletDivision4, walletDivision5, walletDivision6, walletDivision7"
        " FROM crpWalletDivisons"
        " WHERE corporationID = %u", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Corporation %u doesn't exist.", corpID);
        return false;
    }

    std::vector<std::string> dbQ;
    ProcessStringChange("division1", row.GetText(0), divs.div1, notif, dbQ);
    ProcessStringChange("division2", row.GetText(1), divs.div2, notif, dbQ);
    ProcessStringChange("division3", row.GetText(2), divs.div3, notif, dbQ);
    ProcessStringChange("division4", row.GetText(3), divs.div4, notif, dbQ);
    ProcessStringChange("division5", row.GetText(4), divs.div5, notif, dbQ);
    ProcessStringChange("division6", row.GetText(5), divs.div6, notif, dbQ);
    ProcessStringChange("division7", row.GetText(6), divs.div7, notif, dbQ);
    //ProcessStringChange("walletDivision1", row.GetText(7), divs.wallet1, notif, dbQ);  cannot change this one
    ProcessStringChange("walletDivision2", row.GetText(7), divs.wallet2, notif, dbQ);
    ProcessStringChange("walletDivision3", row.GetText(8), divs.wallet3, notif, dbQ);
    ProcessStringChange("walletDivision4", row.GetText(9), divs.wallet4, notif, dbQ);
    ProcessStringChange("walletDivision5", row.GetText(10), divs.wallet5, notif, dbQ);
    ProcessStringChange("walletDivision6", row.GetText(11), divs.wallet6, notif, dbQ);
    ProcessStringChange("walletDivision7", row.GetText(12), divs.wallet7, notif, dbQ);

    std::string query = "UPDATE crpWalletDivisons SET ";

    int N = dbQ.size();
    for (int i = 0; i < N; ++i) {
        query += dbQ[i];
        if (i < N - 1)
            query += ", ";
    }

    query += " WHERE corporationID = ";
    query += std::to_string(corpID);

    _log(CORP__DB_MESSAGE, "DB Query: %s", query.c_str());

    DBerror err;
    // We are here, so something must have changed...
    if (N > 0)
        if (!sDatabase.RunQuery(err, query.c_str())) {
            codelog(CORP__DB_ERROR, "Error in query: %s", err.c_str());
            return false;
        }

    return true;
}

Here is the call graph for this function:

bool CorporationDB::UpdateLogo	(	uint32	corpID,
		const Call_UpdateLogo &	upd,
		PyDict *	notif
	)

Todo:

update this

Definition at line 1813 of file CorporationDB.cpp.

References DBerror::c_str(), codelog, DBQueryResult::error, DBQueryResult::GetRow(), NI, ServiceDB::ProcessIntChange(), and sDatabase.

                                                                                         {
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        " SELECT shape1, shape2, shape3, color1, color2, color3, typeface "
        " FROM crpCorporation "
        " WHERE corporationID = %u ", corpID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        codelog(CORP__DB_WARNING, "Corporation %u doesn't exists.", corpID);
        return false;
    }

    std::vector<std::string> dbQ;
    ProcessIntChange("shape1", NI(0), upd.shape1, notif, dbQ);
    ProcessIntChange("shape2", NI(1), upd.shape2, notif, dbQ);
    ProcessIntChange("shape3", NI(2), upd.shape3, notif, dbQ);

    ProcessIntChange("color1", NI(3), upd.color1, notif, dbQ);
    ProcessIntChange("color2", NI(4), upd.color2, notif, dbQ);
    ProcessIntChange("color3", NI(5), upd.color3, notif, dbQ);

    std::string query = " UPDATE crpCorporation SET ";

    int N = dbQ.size();
    for (int i = 0; i < N; i++) {
        query += dbQ[i];
        if (i < N - 1) query += ", ";
    }

    query += " WHERE corporationID = %u ";
    if ((N > 0) && (!sDatabase.RunQuery(res.error, query.c_str(), corpID))) {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    return true;
}

Here is the call graph for this function:

bool CorporationDB::UpdateTitle	(	uint32	corpID,
		Call_UpdateTitleData &	args,
		PyDict *	updates
	)

Definition at line 955 of file CorporationDB.cpp.

References _log, DBerror::c_str(), codelog, DBQueryResult::error, DBResultRow::GetInt64(), DBQueryResult::GetRow(), DBResultRow::GetText(), IsNPCCorp, ServiceDB::ProcessLongChange(), ServiceDB::ProcessStringChange(), and sDatabase.

{
    if (IsNPCCorp(corpID))
        return false;

    DBQueryResult res;
    if (!sDatabase.RunQuery( res,
        "SELECT titleName, roles, grantableRoles, rolesAtHQ, grantableRolesAtHQ, rolesAtBase, grantableRolesAtBase, rolesAtOther, grantableRolesAtOther "
        " FROM crpRoleTitles WHERE corporationID = %u AND titleID = %u", corpID, args.titleID))
    {
        codelog(CORP__DB_ERROR, "Error in query: %s", res.error.c_str());
        return false;
    }

    DBResultRow row;
    if (!res.GetRow(row)) {
        _log(CORP__DB_WARNING, "No title data for titleID %u in corpID %u.", args.titleID, corpID);
        return false;
    }

    std::vector<std::string> dbQ;
    ProcessStringChange("titleName",            row.GetText(0), args.titleName,             updates,   dbQ);
    ProcessLongChange("roles",                 row.GetInt64(1), args.roles,                 updates,   dbQ);
    ProcessLongChange("grantableRoles",        row.GetInt64(2), args.grantableRoles,        updates,   dbQ);
    ProcessLongChange("rolesAtHQ",             row.GetInt64(3), args.rolesAtHQ,             updates,   dbQ);
    ProcessLongChange("grantableRolesAtHQ",    row.GetInt64(4), args.grantableRolesAtHQ,    updates,   dbQ);
    ProcessLongChange("rolesAtBase",           row.GetInt64(5), args.rolesAtBase,           updates,   dbQ);
    ProcessLongChange("grantableRolesAtBase",  row.GetInt64(6), args.grantableRolesAtBase,  updates,   dbQ);
    ProcessLongChange("rolesAtOther",          row.GetInt64(7), args.rolesAtOther,          updates,   dbQ);
    ProcessLongChange("grantableRolesAtOther", row.GetInt64(8), args.grantableRolesAtOther, updates,   dbQ);

    std::string query = "UPDATE crpRoleTitles SET ";

    int N = dbQ.size();
    for (int i = 0; i < N; ++i) {
        query += dbQ[i];
        if (i < N - 1)
            query += ", ";
    }

    query += " WHERE corporationID = ";
    query += std::to_string(corpID);
    query += " AND titleID = ";
    query += std::to_string(args.titleID);

    _log(CORP__DB_MESSAGE, "DB Query: %s", query.c_str());

    DBerror err;
    // We are here, so something must have changed...
    if (N < 1)
    return false;

    if (!sDatabase.RunQuery(err, query.c_str())) {
        codelog(CORP__DB_ERROR, "Error in query: %s", err.c_str());
        return false;
    }
    return true;
}

Here is the call graph for this function:

---

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

• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/corporation/CorporationDB.h
• /backups/local/src/eve/EvEmu_Crucible/src/eve-server/corporation/CorporationDB.cpp