MailDB Class Reference

#include "MailDB.h"

Inheritance diagram for MailDB:

Collaboration diagram for MailDB:

Public Member Functions
PyRep *	GetLabels (int characterID) const
PyString *	GetMailBody (int id) const
void	SetMailUnread (int id)
void	SetMailRead (int id)
void	SetMailsUnread (std::vector< int32 > ids)
void	SetMailsRead (std::vector< int32 > ids)
void	MarkAllAsRead (uint32 characterID)
void	MarkAllAsUnread (uint32 characterID)
bool	CreateLabel (int characterID, Call_CreateLabel &args, uint32 &newID) const
void	DeleteLabel (int characterID, int labelID) const
void	EditLabel (int characterID, Call_EditLabel &args) const
void	ApplyLabel (int32 messageID, int labelID)
void	ApplyLabels (std::vector< int32 > messageIDs, int labelID)
void	MarkAllAsReadByLabel (uint32 characterID, int labelID)
void	MarkAllAsUnreadByLabel (uint32 characterID, int labelID)
void	RemoveLabels (std::vector< int32 > messageIDs, int labelID)
void	DeleteMail (int32 messageID)
void	EmptyTrash (uint32 characterID)
void	MoveAllFromTrash (uint32 characterID)
void	MoveAllToTrash (uint32 characterID)
void	MoveFromTrash (int32 messageID)
void	MoveToTrash (int32 messageID)
void	MoveToTrashByLabel (int32 characterID, int32 labelID)
PyDict *	GetJoinedMailingLists (uint32 characterID)
uint32	CreateMailingList (uint32 creator, std::string name, int32 defaultAccess, int32 defaultMemberAccess, int32 cost)
void	JoinMailingList (uint32 characterID, std::string name)
void	LeaveMailingList (uint32 characterID, int32 listID)
void	DeleteMailingList (uint32 characterID, int32 listID)
PyDict *	GetMailingListMembers (int32 listID)
void	MailingListSetEntityAccess (int32 entity, int32 access, int32 listID)
void	MailingListClearEntityAccess (int32 entity, int32 listID)
void	SetMailingListDefaultAccess (int32 listID, int32 defaultAccess, int32 defaultMemberAccess, int32 cost)
PyObject *	MailingListGetSettings (int32 listID)
void	ApplyStatusMasks (std::vector< int32 > messageIDs, int mask)
void	RemoveStatusMasks (std::vector< int32 > messageIDs, int mask)
void	ApplyStatusMask (int32 messageID, int mask)
void	RemoveStatusMask (int32 messageID, int mask)
void	ApplyLabelMask (int32 messageID, int mask)
void	ApplyLabelMasks (std::vector< int32 > messageIDs, int mask)
void	RemoveLabelMask (int32 messageID, int mask)
void	RemoveLabelMasks (std::vector< int32 > messageIDs, int mask)
int	SendMail (int sender, std::vector< int > &toCharacterIDs, int toListID, int toCorpOrAllianceID, std::string &title, std::string &body, int isReplyTo, int isForwardedFrom)
PyRep *	GetNewMail (int charId)
PyRep *	GetMailStatus (int charId)
Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

Static Protected Member Functions
static int	BitFromLabelID (int id)
Static Protected Member Functions inherited from ServiceDB
static uint32	CreateNewAccount (const char *login, const char *pass, const char *passHash, int64 role)

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

Detailed Description

Definition at line 36 of file MailDB.h.

Member Function Documentation

void MailDB::ApplyLabel	(	int32	messageID,
		int	labelID
	)

Definition at line 368 of file MailDB.cpp.

References ApplyLabelMask(), and BitFromLabelID().

{
    int bit = BitFromLabelID(labelID);
    ApplyLabelMask(messageID, (1 << bit));
}

Here is the call graph for this function:

void MailDB::ApplyLabelMask	(	int32	messageID,
		int	mask
	)

Definition at line 514 of file MailDB.cpp.

References codelog, and sDatabase.

Referenced by ApplyLabel().

{

    DBerror err;
    if (!sDatabase.RunQuery(err,
                            " UPDATE mailStatus "
                            " SET labelMask = (labelMask | %u) "
                            " WHERE messageID = %u;" , mask, messageID))
    {
        codelog(DATABASE__ERROR, " Failed to apply label mask to message" );
    }

}

Here is the caller graph for this function:

void MailDB::ApplyLabelMasks	(	std::vector< int32 >	messageIDs,
		int	mask
	)

Definition at line 540 of file MailDB.cpp.

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

Referenced by ApplyLabels().

{
    DBerror err;

    if (messageIDs.size() == 0) {
        return;
    }

    std::ostringstream query;
    query << " UPDATE mailStatus SET labelMask = labelMask | "  << mask << "  " ;

    query << " WHERE messageID = "  << messageIDs[0];

    for (int i = 1; i < messageIDs.size(); i++) {
        query << "  OR messageID = "  << messageIDs[i];
    }

    _log(DATABASE__ERROR, query.str().c_str());


    if (!sDatabase.RunQuery(err, query.str().c_str()))
    {
        codelog(DATABASE__ERROR, " Failed to apply labels" );
        return;
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

void MailDB::ApplyLabels	(	std::vector< int32 >	messageIDs,
		int	labelID
	)

Definition at line 276 of file MailDB.cpp.

References ApplyLabelMasks(), and BitFromLabelID().

{
    int bit = BitFromLabelID(labelID);
    ApplyLabelMasks(messageIDs, (1 << bit));
}

Here is the call graph for this function:

void MailDB::ApplyStatusMask	(	int32	messageID,
		int	mask
	)

Definition at line 490 of file MailDB.cpp.

References codelog, and sDatabase.

Referenced by SetMailRead().

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            " UPDATE mailStatus "
                            " SET statusMask = statusMask | %u "
                            " WHERE messageID = %u" , mask, messageID)) {
        codelog(DATABASE__ERROR, " Failed to apply status mask" );
    }
}

Here is the caller graph for this function:

void MailDB::ApplyStatusMasks	(	std::vector< int32 >	messageIDs,
		int	mask
	)

Definition at line 448 of file MailDB.cpp.

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

Referenced by SetMailsRead().

{
    if (messageIDs.size() == 0) {
        return;
    }

    std::ostringstream query;

    query << " UPDATE mailStatus SET statusMask = statusMask | "  << mask << "  WHERE " ;
    query << " messageID = "  << messageIDs[0];
    for (int i = 1; i < messageIDs.size(); i++) {
        query << "  OR messageID = "  << messageIDs[i];
    }

    DBerror err;

    if (!sDatabase.RunQuery(err, query.str().c_str())) {
        codelog(DATABASE__ERROR, " Failed apply status mask" );
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

int MailDB::BitFromLabelID ( int  id )

staticprotected

Definition at line 595 of file MailDB.cpp.

References sLog.

Referenced by ApplyLabel(), ApplyLabels(), DeleteLabel(), EditLabel(), MarkAllAsReadByLabel(), MarkAllAsUnreadByLabel(), MoveToTrashByLabel(), and RemoveLabels().

{
    // lets hope the compiler can do this better; I guess it still beats a floating point log, though
    for (int i = 0; i < (sizeof(int)*8); i++)
        if ((id & (1 << i)) > 0)
            return i;

    // This just gets rid of a warning, code execution should never reach here.
    sLog.Error(" MailDB::BitFromLabelID" , " ERROR: Could not get bit." );
    return 0;
}

Here is the caller graph for this function:

bool MailDB::CreateLabel	(	int	characterID,
		Call_CreateLabel &	args,
		uint32 &	newID
	)		const

Definition at line 304 of file MailDB.cpp.

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

{
    // we need to get the next free bit index; can't avoid a SELECT
    DBQueryResult res;
    sDatabase.RunQuery(res, " SELECT bit FROM mailLabel WHERE ownerID = %u ORDER BY bit DESC LIMIT 1" , characterID);

    // 6 is a guessed default; there are some hardcoded labels that we don't have the details on yet
    int bit = 6;

    if (res.GetRowCount() > 0)
    {
        DBResultRow row;
        res.GetRow(row);
        // we want the next one, not the current one, so +1
        bit = row.GetInt(0) + 1;
    }

    DBerror error;
    if (!sDatabase.RunQuery(error, " INSERT INTO mailLabel (bit, name, color, ownerID) VALUES (%u, '%s', %u, %u)" , bit, args.name.c_str(), args.color, characterID))
    {
        codelog(DATABASE__ERROR, " Failed to insert new mail label into database" );
        // since this is an out parameter, make sure we assign this even in case of an error
        newID = 0;
        return false;
    }

    // the client wants the power of 2, not the bitset index
    newID = (uint32)pow((float)2, bit);
    return true;
}

Here is the call graph for this function:

uint32 MailDB::CreateMailingList	(	uint32	creator,
		std::string	name,
		int32	defaultAccess,
		int32	defaultMemberAccess,
		int32	cost
	)

Definition at line 659 of file MailDB.cpp.

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

{
    DBerror err;
    uint32 id = 0;
    uint32& idr = id;

    if (!sDatabase.RunQueryLID(err, idr,
                            " INSERT INTO mailList "
                            " (displayName, defaultAccess, defaultMemberAccess, cost) "
                            " VALUES( '%s', %u, %u, %u) " , name.c_str(), defaultAccess,
                               defaultMemberAccess, cost))
    {
        codelog(DATABASE__ERROR, " Failed to create mailing list" );
        return -1;
    }

    if (!sDatabase.RunQuery(err,
                            " INSERT INTO mailListUsers "
                            " (listID, characterID, role, access) "
                            " VALUES(%u, %u, %u, %u)" , id, creator, mailingListMemberOwner,
                            mailingListAllowed))
    {
        codelog(DATABASE__ERROR, " Failed to insert owner of mailing list" );
        return -1;
    }

    return id;
}

Here is the call graph for this function:

void MailDB::DeleteLabel	(	int	characterID,
		int	labelID
	)		const

Definition at line 335 of file MailDB.cpp.

References BitFromLabelID(), codelog, and sDatabase.

{
    int bit = BitFromLabelID(labelID);
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            " UPDATE mailMessage "
                            " SET labelMask = labelMask & ~(1 << ~%u) "
                            " WHERE (labelMask & (1 << %u)) > 0 "
                            " AND toCharacterIDs LIKE '%%%u%%';" , bit, bit, characterID))
    {
        codelog(DATABASE__ERROR, " Failed to delete label" );
        return;
    }

    sDatabase.RunQuery(err,
                       " DELETE FROM mailLabel "
                       " WHERE ownerID = %u AND bit = %u;" , characterID, bit);
}

Here is the call graph for this function:

void MailDB::DeleteMail

(

int32

messageID

)

Definition at line 374 of file MailDB.cpp.

References codelog, and sDatabase.

{
    DBerror err;

    if (!sDatabase.RunQuery(err,
                            " DELETE FROM mailStatus "
                            " WHERE messageID = %u;" , messageID)) {

        codelog(DATABASE__ERROR, " Failed to delete mail" );
    }
}

void MailDB::DeleteMailingList	(	uint32	characterID,
		int32	listID
	)

Definition at line 773 of file MailDB.cpp.

{

}

void MailDB::EditLabel	(	int	characterID,
		Call_EditLabel &	args
	)		const

Definition at line 354 of file MailDB.cpp.

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

{
    int bit = BitFromLabelID(args.labelId);

    DBerror error;
    if (args.name.length() == 0) {
        sDatabase.RunQuery(error, " UPDATE mailLabel SET color = %u WHERE bit = %u AND ownerID = %u" , args.color, bit, characterID);
    } else if (args.color == -1) {
        sDatabase.RunQuery(error, " UPDATE mailLabel SET name = '%s' WHERE bit = %u AND ownerID = %u" , args.name.c_str(), bit, characterID);
    } else {
        sDatabase.RunQuery(error, " UPDATE mailLabel SET name = '%s', color = %u WHERE bit = %u AND ownerID = %u" , args.name.c_str(), args.color, bit, characterID);
    }
}

Here is the call graph for this function:

void MailDB::EmptyTrash

(

uint32

characterID

)

Definition at line 386 of file MailDB.cpp.

References codelog, mailStatusMaskTrashed, and sDatabase.

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            " DELETE FROM mailMessage "
                            " WHERE senderID = %u "
                            " AND (statusMask & %u) > 0;" , characterID, mailStatusMaskTrashed)) {
        codelog(DATABASE__ERROR, " Failed to deleted trash mails" );
    }
}

PyDict * MailDB::GetJoinedMailingLists

(

uint32

characterID

)

Definition at line 607 of file MailDB.cpp.

References codelog, DBResultRow::GetInt(), DBQueryResult::GetRow(), DBResultRow::GetText(), mailingListMemberMuted, mailingListMemberOperator, mailingListMemberOwner, sDatabase, PyDict::SetItem(), and PyDict::SetItemString().

{

    // @NOTE: May have to util.keyval this??j?
    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
                " SELECT l.id, l.displayName, l.defaultAccess, l.defaultMemberAccess, l.cost,"
                "   u.listID, u.characterID, u.role, u.access"
                "  FROM mailListUsers AS u "
                "   LEFT JOIN mailList AS l ON l.id = u.listID "
                "   WHERE u.characterID = %u" , characterID))
    {
        codelog(DATABASE__ERROR, " Failed to get joined mailing lists" );
        return nullptr;
    }

    DBResultRow row;
    PyDict *ret = new PyDict();
    while (res.GetRow(row))
    {
        PyDict *dict = new PyDict();

        dict->SetItemString(" displayName" , new PyString(row.GetText(1)));

        int32 role = row.GetInt(7);
        switch (role)
        {
        case mailingListMemberMuted: {
            dict->SetItemString(" isMuted" , new PyBool(true));
            dict->SetItemString(" isOwner" , new PyBool(false));
            dict->SetItemString(" isOperator" , new PyBool(false));
        } break;
        case mailingListMemberOperator: {
            dict->SetItemString(" isMuted" , new PyBool(false));
            dict->SetItemString(" isOwner" , new PyBool(false));
            dict->SetItemString(" isOperator" , new PyBool(true));
        } break;
        case mailingListMemberOwner: {
            dict->SetItemString(" isMuted" , new PyBool(false));
            dict->SetItemString(" isOwner" , new PyBool(true));
            dict->SetItemString(" isOperator" , new PyBool(false));
        } break;
        }

        ret->SetItem(new PyInt(row.GetInt(0)), new PyObject(" util.KeyVal" , dict));
    }

    return ret;
}

Here is the call graph for this function:

PyRep * MailDB::GetLabels

(

int

characterID

)

const

Definition at line 282 of file MailDB.cpp.

References DBResultRow::GetInt(), DBQueryResult::GetRow(), DBResultRow::GetText(), sDatabase, and PyDict::SetItem().

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, " SELECT bit, name, color FROM mailLabel WHERE ownerID = %u" , characterID))
        return nullptr;

    PyDict* ret = new PyDict();

    DBResultRow row;
    while (res.GetRow(row))
    {
        MailLabel label;
        label.id = (int)pow((float)2, row.GetInt(0));
        label.name = row.GetText(1);
        label.color = row.GetInt(2);

        ret->SetItem(new PyInt(label.id), label.Encode());
    }

    return ret;
}

Here is the call graph for this function:

PyString * MailDB::GetMailBody

(

int

id

)

const

Definition at line 151 of file MailDB.cpp.

References DBResultRow::ColumnLength(), DBQueryResult::GetRow(), DBQueryResult::GetRowCount(), DBResultRow::GetText(), DBResultRow::IsNull(), and sDatabase.

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res, " SELECT body FROM mailMessage WHERE messageID = %u" , id))
        return nullptr;
    if (res.GetRowCount() <= 0)
        return nullptr;

    DBResultRow row;
    if (!res.GetRow(row) || row.IsNull(0))
        return nullptr;

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

Here is the call graph for this function:

PyDict * MailDB::GetMailingListMembers

(

int32

listID

)

Definition at line 688 of file MailDB.cpp.

References codelog, DBResultRow::GetInt(), DBQueryResult::GetRow(), sDatabase, and PyDict::SetItem().

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
        " SELECT listID, characterID, role, access FROM mailListUsers "
                            " WHERE listID = %u" , listID))
    {
        codelog(DATABASE__ERROR, " Failed to get mailing list members" );
        return nullptr;
    }

    DBResultRow row;
    PyDict *dict = new PyDict();

    while (res.GetRow(row))
    {
        dict->SetItem(new PyInt(row.GetInt(1)), new PyInt(row.GetInt(2)));
    }
    return dict;
}

Here is the call graph for this function:

PyRep * MailDB::GetMailStatus

(

int

charId

)

Definition at line 34 of file MailDB.cpp.

References codelog, DBResultToCRowset(), and sDatabase.

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
                            " SELECT messageID, statusMask, labelMask "
                            " FROM mailStatus"
                            " WHERE characterID = %u" , charId)) {
        codelog(DATABASE__ERROR, " Failed to get mail status" );
        return nullptr;
    }
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

PyRep * MailDB::GetNewMail

(

int

charId

)

Definition at line 47 of file MailDB.cpp.

References DBResultToCRowset(), and sDatabase.

{
    DBQueryResult res;
    if (!sDatabase.RunQuery(res,
                            " SELECT m.messageID, m.senderID, m.toCharacterIDs, m.toListID, "
                            "   m.toCorpOrAllianceID, m.title, m.sentDate FROM mailStatus AS s"
                            "  LEFT JOIN mailMessage AS m USING (messageID) "
                            "  WHERE s.characterID = %u" , charId))
        return nullptr;
    return DBResultToCRowset(res);
}

Here is the call graph for this function:

void MailDB::JoinMailingList	(	uint32	characterID,
		std::string	name
	)

Definition at line 777 of file MailDB.cpp.

{

}

void MailDB::LeaveMailingList	(	uint32	characterID,
		int32	listID
	)

Definition at line 781 of file MailDB.cpp.

{

}

void MailDB::MailingListClearEntityAccess	(	int32	entity,
		int32	listID
	)

Definition at line 785 of file MailDB.cpp.

{

}

PyObject * MailDB::MailingListGetSettings

(

int32

listID

)

Definition at line 710 of file MailDB.cpp.

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

{
    PyDict *ret = new PyDict();

    // TODO(groove): Make this a join if possible

    DBQueryResult res;

    if (!sDatabase.RunQuery(res,
        " SELECT id, displayName, defaultAccess, defaultMemberAccess, cost FROM mailList "
                            "  WHERE id = %u" , listID))
    {
        codelog(DATABASE__ERROR, " Failed to get mailing list settings" );
        return nullptr;
    }
    DBResultRow row;

    if (!res.GetRow(row)) {
        codelog(DATABASE__ERROR, " mailList didn't give us a row" );
        return nullptr;
    }


    ret->SetItemString(" defaultAccess" , new PyInt(row.GetInt(2)));
    ret->SetItemString(" defaultMemberAccess" , new PyInt(row.GetInt(3)));

    DBQueryResult res2;

    if (!sDatabase.RunQuery(res,
        " SELECT listID, characterID, role, access FROM mailListUsers "
                            " WHERE listID = %u" , listID))
    {
        codelog(DATABASE__ERROR, " Failed to get mailing list settings" );
        return nullptr;
    }

    PyDict *dict = new PyDict();

    ret->SetItemString(" access" , dict);


    while (res.GetRow(row)) {
        dict->SetItem(new PyInt(row.GetInt(1)), new PyInt(row.GetInt(3)));
    }

    return new PyObject(" util.KeyVal" , ret);
}

Here is the call graph for this function:

void MailDB::MailingListSetEntityAccess	(	int32	entity,
		int32	access,
		int32	listID
	)

Definition at line 789 of file MailDB.cpp.

{

}

void MailDB::MarkAllAsRead

(

uint32

characterID

)

Definition at line 200 of file MailDB.cpp.

References codelog, mailStatusMaskRead, and sDatabase.

{
    DBerror err;

    if (!sDatabase.RunQuery(err,
                            " UPDATE mailMessage "
                            " SET statusMask = statusMask | %u "
                            " WHERE toCharacterIDs LIKE '%%%u%%'" , mailStatusMaskRead, characterID)) {
        codelog(DATABASE__ERROR, " Failed to mark all as read" );
        return;
    }
}

void MailDB::MarkAllAsReadByLabel	(	uint32	characterID,
		int	labelID
	)

Definition at line 230 of file MailDB.cpp.

References BitFromLabelID(), codelog, and sDatabase.

{
    int bit = BitFromLabelID(labelID);
    DBerror err;

    if (!sDatabase.RunQuery(err,
                            " UPDATE mailMessage "
                            " SET statusMask = statusMask | %u "
                            " WHERE toCharacterIDs LIKE '%%%u%%' "
                            " AND (labelMask & (1 << %u)) > 0" , characterID, bit))
    {
        codelog(DATABASE__ERROR, " Failed to mark all as read by label" );
        return;
    }
}

Here is the call graph for this function:

void MailDB::MarkAllAsUnread

(

uint32

characterID

)

Definition at line 186 of file MailDB.cpp.

References codelog, mailStatusMaskRead, and sDatabase.

{
    DBerror err;

    if (!sDatabase.RunQuery(err,
                            " UPDATE mailMessage "
                            " SET statusMask = statusMask & ~%u "
                            " WHERE toCharacterIDs LIKE '%%%u%%'" , mailStatusMaskRead, characterID)) {
        codelog(DATABASE__ERROR, " Failed to mark all as read" );
        return;
    }
}

void MailDB::MarkAllAsUnreadByLabel	(	uint32	characterID,
		int	labelID
	)

Definition at line 213 of file MailDB.cpp.

References BitFromLabelID(), codelog, and sDatabase.

{
    int bit = BitFromLabelID(labelID);
    DBerror err;

    if (!sDatabase.RunQuery(err,
                            " UPDATE mailMessage SET "
                            " statusMask = statusMask & ~%u "
                            " WHERE toCharacterIDs LIKE '%%%u%%' "
                            " AND (labelMask & (1 << %u)) > 0" , characterID, bit))
    {
        codelog(DATABASE__ERROR, " Failed to mark all as read by label" );
        return;
    }
}

Here is the call graph for this function:

void MailDB::MoveAllFromTrash

(

uint32

characterID

)

Definition at line 397 of file MailDB.cpp.

References codelog, mailStatusMaskTrashed, and sDatabase.

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            " UPDATE mailMessage "
                            " WHERE senderID = %u "
                            " SET statusMask = statusMask | %u" , characterID, mailStatusMaskTrashed)) {
        codelog(DATABASE__ERROR, " Failed to move all from trash" );
    }
}

void MailDB::MoveAllToTrash

(

uint32

characterID

)

Definition at line 408 of file MailDB.cpp.

References codelog, mailStatusMaskTrashed, and sDatabase.

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            " UPDATE mailMessage "
                            " WHERE characterID LIKE  '%%%u%%' "
                            " SET statusMask = statusMask & ~%u" , characterID, mailStatusMaskTrashed)) {
        codelog(DATABASE__ERROR, " Failed to move message to trash" );
    }
}

void MailDB::MoveFromTrash

(

int32

messageID

)

Definition at line 793 of file MailDB.cpp.

{

}

void MailDB::MoveToTrash

(

int32

messageID

)

Definition at line 419 of file MailDB.cpp.

References codelog, mailStatusMaskTrashed, and sDatabase.

{
    DBerror err;

    if (!sDatabase.RunQuery(err,
                            " UPDATE mailMessage "
                            " WHERE messageID = %u "
                            " SET statusMask = statusMask | %u" , messageID, mailStatusMaskTrashed)) {
        codelog(DATABASE__ERROR, " Failed to move message to trash" );
    }

}

void MailDB::MoveToTrashByLabel	(	int32	characterID,
		int32	labelID
	)

Definition at line 432 of file MailDB.cpp.

References BitFromLabelID(), codelog, and sDatabase.

{
    int bit = BitFromLabelID(labelID);

    DBerror err;

    if (!sDatabase.RunQuery(err,
                            " UPDATE mailMessage "
                            " SET labelMask = -1 "
                            " WHERE toCharacterIDs LIKE '%%%u%%' "
                            " AND (labelMask & (1 << %u)) > 0" , characterID, bit))
    {
        codelog(DATABASE__ERROR, " Failed to move message to trash by label" );
    }
}

Here is the call graph for this function:

void MailDB::RemoveLabelMask	(	int32	messageID,
		int	mask
	)

Definition at line 528 of file MailDB.cpp.

References codelog, and sDatabase.

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            " UPDATE mailStatus "
                            " SET labelMask = (labelMask & ~%u) "
                            " WHERE messageID = %u;" , mask, messageID))
    {
        codelog(DATABASE__ERROR, " Failed to apply label mask to message" );
    }
}

void MailDB::RemoveLabelMasks	(	std::vector< int32 >	messageIDs,
		int	mask
	)

Definition at line 567 of file MailDB.cpp.

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

{
    DBerror err;

    if (messageIDs.size() == 0) {
        return;
    }

    std::ostringstream query;
    query << " UPDATE mailStatus SET labelMask = labelMask & ~"  << mask << "  " ;

    query << " WHERE messageID = "  << messageIDs[0];

    for (int i = 1; i < messageIDs.size(); i++) {
        query << "  OR messageID = "  << messageIDs[i];
    }

    _log(DATABASE__ERROR, query.str().c_str());


    if (!sDatabase.RunQuery(err, query.str().c_str()))
    {
        codelog(DATABASE__ERROR, " Failed to apply labels" );
        return;
    }
}

Here is the call graph for this function:

void MailDB::RemoveLabels	(	std::vector< int32 >	messageIDs,
		int	labelID
	)

Definition at line 246 of file MailDB.cpp.

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

{
    DBerror err;

    if (messageIDs.size() == 0) {
        return;
    }

    int bit = BitFromLabelID(labelID);
    std::ostringstream query;
    query << " UPDATE mailMessage SET labelMask = labelMask & ~(1 << "  << bit << " ) " ;

    query << " WHERE (labelMask & (1 << "  << bit << " )) > 0 AND (" ;
    query << " messageID = "  << messageIDs[0];

    for (int i = 1; i < messageIDs.size(); i++) {
        query << "  OR messageID = "  << messageIDs[i];
    }

    query << " )" ;
    _log(DATABASE__ERROR, query.str().c_str());


    if (!sDatabase.RunQuery(err, query.str().c_str()))
    {
        codelog(DATABASE__ERROR, " Failed to delete labels" );
        return;
    }
}

Here is the call graph for this function:

void MailDB::RemoveStatusMask	(	int32	messageID,
		int	mask
	)

Definition at line 502 of file MailDB.cpp.

References codelog, and sDatabase.

Referenced by SetMailUnread().

{
    DBerror err;
    if (!sDatabase.RunQuery(err,
                            " UPDATE mailStatus "
                            " SET statusMask = statusMask & ~%u "
                            " WHERE messageID = %u" , mask, messageID)) {
        codelog(DATABASE__ERROR, " Failed to remove status mask" );
    }
}

Here is the caller graph for this function:

void MailDB::RemoveStatusMasks	(	std::vector< int32 >	messageIDs,
		int	mask
	)

Definition at line 469 of file MailDB.cpp.

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

Referenced by SetMailsUnread().

{
    if (messageIDs.size() == 0) {
        return;
    }

    std::ostringstream query;

    query << " UPDATE mailStatus SET statusMask = statusMask & ~"  << mask << "  WHERE " ;
    query << " messageID = "  << messageIDs[0];
    for (int i = 1; i < messageIDs.size(); i++) {
        query << "  OR messageID = "  << messageIDs[i];
    }

    DBerror err;

    if (!sDatabase.RunQuery(err, query.str().c_str())) {
        codelog(DATABASE__ERROR, " Failed to remove status mask" );
    }
}

Here is the call graph for this function:

Here is the caller graph for this function:

int MailDB::SendMail	(	int	sender,
		std::vector< int > &	toCharacterIDs,
		int	toListID,
		int	toCorpOrAllianceID,
		std::string &	title,
		std::string &	body,
		int	isReplyTo,
		int	isForwardedFrom
	)

Definition at line 59 of file MailDB.cpp.

References Buffer::begin(), codelog, DeflateData(), Buffer::end(), DBResultRow::GetInt(), DBQueryResult::GetRow(), mailLabelInbox, PRIu64, sDatabase, and Win32TimeNow().

{
    // build a string with ',' seperated char ids
    std::string toStr;
    for (size_t i = 0; i < toCharacterIDs.size(); i++)
    {
        toStr += std::to_string(toCharacterIDs[i]);
        // only add ',' when this isn't the last ID
        if (i != (toCharacterIDs.size() - 1))
            toStr += " ," ;
    }

    // sanitize these ids
    if (toListID == -1)
        toListID = 0;
    if (toCorpOrAllianceID == -1)
        toCorpOrAllianceID = 0;

    // compress the body
    Buffer bodyCompressed;
    Buffer bodyInput(body.begin(), body.end());
    DeflateData(bodyInput, bodyCompressed);

    // ugh - buffer doesn't give us the actual buffer.. what the?
    std::string bodyCompressedStr(bodyCompressed.begin<char>(), bodyCompressed.end<char>());

    // escape it to not break the query with special characters
    std::string bodyEscaped;
    sDatabase.DoEscapeString(bodyEscaped, bodyCompressedStr);

    // default label is 1 = Inbox
    const int defaultLabel = 1;

    // TODO(groove): Maybe do checks to see if we're allowed to send mails to
    // whereever it's going
    DBerror err;
    uint32 messageID;

    if (!sDatabase.RunQueryLID(err, messageID,
                               " INSERT INTO mailMessage "
                               " (senderID, toCharacterIDs, toListID, toCorpOrAllianceID, "
                               " title, body, sentDate) "
                               " VALUES (%u, '%s', %d, %d, '%s', '%s', %"  PRIu64 " )" ,
                               sender, toStr.c_str(), toListID, toCorpOrAllianceID, title.c_str(),
                               bodyEscaped.c_str(), Win32TimeNow()));
    {
        codelog(DATABASE__ERROR, " Failed to insert mailMessage" );
        // TODO: Why returning false always?
    }

    if (toCharacterIDs.size() > 0) {
        for (int i = 0; i < toCharacterIDs.size(); i++) {
            uint32 id = toCharacterIDs[i];
            if (!sDatabase.RunQuery(err,
                                    " INSERT INTO mailStatus "
                                    " (messageID, characterID, statusMask, labelMask)"
                                    " VALUES (%u, %u, %u, %u)" , messageID, id, 0, mailLabelInbox))
            {
                codelog(DATABASE__ERROR, " Failed to insert mailStatus for character ids" );
                return 0;
            }
        }
    }

    if (toListID > 0) {
        DBQueryResult res;
        if (!sDatabase.RunQuery(res,
                                " SELECT characterID FROM mailListUsers "
                                " WHERE listID = %u" , toListID))
        {
            codelog(DATABASE__ERROR, " Failed to get mailing list members" );
            return 0;
        }
        DBResultRow row;
        while (res.GetRow(row))
        {
            uint32 id = row.GetInt(0);
            if (!sDatabase.RunQuery(err,
                                    " INSERT INTO mailStatus "
                                    " (messageID, characterID, statusMask, labelMask)"
                                    " VALUES (%u, %u, %u, %u)" , messageID, id, 0, mailLabelInbox))
            {
                codelog(DATABASE__ERROR, " Failed to insert mailStatus for character ids" );
                return 0;
            }
        }
    }
    // TODO(groove) corp/alliance mails

    return messageID;
}

Here is the call graph for this function:

void MailDB::SetMailingListDefaultAccess	(	int32	listID,
		int32	defaultAccess,
		int32	defaultMemberAccess,
		int32	cost
	)

Definition at line 759 of file MailDB.cpp.

References codelog, and sDatabase.

{
    DBerror err;

    if (!sDatabase.RunQuery(err,
                   " UPDATE mailList "
                   " SET defaultAccess = %u, defaultMemberAccess = %u, cost = %u "
                   " WHERE id = %u" , defaultAccess, defaultMemberAccess, cost, listID))
    {
        codelog(DATABASE__ERROR, " Failed to update mailing list defaults" );
        return;
    }
}

void MailDB::SetMailRead

(

int

id

)

Definition at line 171 of file MailDB.cpp.

References ApplyStatusMask(), and mailStatusMaskRead.

{
    ApplyStatusMask(id, mailStatusMaskRead);
}

Here is the call graph for this function:

void MailDB::SetMailsRead

(

std::vector< int32 >

ids

)

Definition at line 181 of file MailDB.cpp.

References ApplyStatusMasks(), and mailStatusMaskRead.

{
    ApplyStatusMasks(ids, mailStatusMaskRead);
}

Here is the call graph for this function:

void MailDB::SetMailsUnread

(

std::vector< int32 >

ids

)

Definition at line 176 of file MailDB.cpp.

References mailStatusMaskRead, and RemoveStatusMasks().

{
    RemoveStatusMasks(ids, mailStatusMaskRead);
}

Here is the call graph for this function:

void MailDB::SetMailUnread

(

int

id

)

Definition at line 166 of file MailDB.cpp.

References mailStatusMaskRead, and RemoveStatusMask().

{
    RemoveStatusMask(id, mailStatusMaskRead);
}

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