#include "LSCDB.h"

Inheritance diagram for LSCDB:

Collaboration diagram for LSCDB:

Public Member Functions
uint32	StoreMail (uint32 senderID, uint32 recipID, const char subject, const char message, int64 sentTime)

PyObject *	GetMailHeaders (uint32 recID)

PyRep *	GetMailDetails (uint32 messageID, uint32 readerID)

bool	MarkMessageRead (uint32 messageID)

bool	DeleteMessage (uint32 messageID, uint32 readerID)

void	GetChannelNames (uint32 charID, std::vector< std::string > &names)

int32	GetNextAvailableChannelID ()

bool	IsChannelNameAvailable (std::string name)

bool	IsChannelIDAvailable (int32 channel_ID)

bool	IsChannelSubscribedByThisChar (uint32 char_ID, int32 channel_ID)

std::string	GetRegionName (uint32 id)

std::string	GetConstellationName (uint32 id)

std::string	GetSolarSystemName (uint32 id)

std::string	GetCorporationName (uint32 id)

std::string	GetAllianceName (uint32 id)

std::string	GetCharacterName (uint32 id)

int32	GetChannelID (std::string &name)

void	GetChannelInformation (int32 channelID, std::string &name, std::string &motd, uint32 &ownerid, std::string &compkey, bool &memberless, std::string &password, bool &maillist, uint32 &cspa)

void	GetChannelSubscriptions (uint32 charID, std::vector< long > &ids, std::vector< std::string > &names, std::vector< std::string > &MOTDs, std::vector< unsigned long > &ownerids, std::vector< std::string > &compkeys, std::vector< int > &memberless, std::vector< std::string > &passwords, std::vector< int > &maillists, std::vector< int > &cspas, int &channelCount)

bool	GetChannelInfo (int32 channelID, std::string &name, std::string &motd)

int32	GetChannelIDFromComparisonKey (std::string compkey)

void	UpdateChannelInfo (LSCChannel *channel)

void	UpdateSubscription (int32 channelID, Client *pClient)

void	DeleteChannel (int32 channelID)

void	DeleteSubscription (int32 channelID, uint32 charID)

Public Member Functions inherited from ServiceDB
uint32	GetStationOwner (uint32 stationID)

Protected Member Functions
std::string	GetChannelName (uint32 id, const char table, const char column, const char *key)

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)

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)

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 36 of file LSCDB.h.

Member Function Documentation

void LSCDB::DeleteChannel ( int32 channelID )

Definition at line 130 of file LSCDB.cpp.

References sDatabase.

 {
     DBerror err;
     sDatabase.RunQuery(err, "DELETE FROM channels WHERE channelID=%i", channelID);
 }

bool LSCDB::DeleteMessage	(	uint32	messageID,
		uint32	readerID
	)

Definition at line 522 of file LSCDB.cpp.

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

                                                            {
     DBerror err;
     bool ret = true;
 
     if (!sDatabase.RunQuery(err,
         " DELETE FROM eveMail "
         " WHERE messageID=%u AND channelID=%u", messageID, readerID
     ))
     {
         _log(DATABASE__ERROR, "Error in query: %s", err.c_str());
         ret = false;
     }
     if (!sDatabase.RunQuery(err,
         " DELETE FROM eveMailDetails "
         " WHERE messageID=%u", messageID
     ))
     {
         _log(DATABASE__ERROR, "Error in query: %s", err.c_str());
         ret = false;
     }
 
     return ret;
 
 }

Here is the call graph for this function:

void LSCDB::DeleteSubscription	(	int32	channelID,
		uint32	charID
	)

Definition at line 136 of file LSCDB.cpp.

References sDatabase.

 {
     DBerror err;
     sDatabase.RunQuery(err, "DELETE FROM channelChars WHERE channelID=%i AND charID=%u", channelID, charID );
 }

std::string LSCDB::GetAllianceName ( uint32 id )

inline

Definition at line 56 of file LSCDB.h.

References GetChannelName().

Referenced by LSCService::CreateSystemChannel().

56 { return GetChannelName(id, "alnAlliance", "shortName", "allianceID"); }

LSCDB::GetChannelName

std::string GetChannelName(uint32 id, const char *table, const char *column, const char *key)

Definition: LSCDB.cpp:382

Here is the call graph for this function:

Here is the caller graph for this function:

int32 LSCDB::GetChannelID ( std::string & name )

Definition at line 222 of file LSCDB.cpp.

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

                                          {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res, "SELECT channelID FROM channels WHERE displayName RLIKE '%s'", name.c_str())) {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return 0;
     }
 
     DBResultRow row;
     if (!res.GetRow(row)) {
         _log(SERVICE__ERROR, "Channel named '%s' isn't present in the database", name.c_str() );
         return 0;
     }
 
     return row.GetInt(0);
 }

Here is the call graph for this function:

int32 LSCDB::GetChannelIDFromComparisonKey ( std::string compkey )

Definition at line 365 of file LSCDB.cpp.

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

 {
     DBQueryResult res;
     if(!sDatabase.RunQuery(res, "SELECT channelID FROM channels WHERE comparisonKey RLIKE '%s'", compkey.c_str())) {
         _log(DATABASE__ERROR, "Error in GetChannelIDFromComparisonKey query: %s", res.error.c_str());
         return 0;
     }
 
     DBResultRow row;
     if (!res.GetRow(row)) {
         _log(SERVICE__ERROR, "Couldn't find %s in table channels", compkey.c_str());
         return 0;
     }
 
     return row.GetInt(0);
 }

Here is the call graph for this function:

bool LSCDB::GetChannelInfo	(	int32	channelID,
		std::string &	name,
		std::string &	motd
	)

Definition at line 344 of file LSCDB.cpp.

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

 {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res, "SELECT displayName, motd FROM channels WHERE channelID = %i ", channelID)) {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return false;
     }
 
     DBResultRow row;
     if (!res.GetRow(row)) {
         // _log(SERVICE__ERROR, "Couldn't find %u in table channels", channelID);
         return false;
     }
 
     name = row.GetText(0);
     motd = row.GetText(1);
 
     return true;
 }

Here is the call graph for this function:

void LSCDB::GetChannelInformation	(	int32	channelID,
		std::string &	name,
		std::string &	motd,
		uint32 &	ownerid,
		std::string &	compkey,
		bool &	memberless,
		std::string &	password,
		bool &	maillist,
		uint32 &	cspa
	)

Definition at line 240 of file LSCDB.cpp.

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

 {
     DBQueryResult res;
 
     if (!sDatabase.RunQuery(res,
         "SELECT"
         "   channelID, "
         "   displayName, "
         "   motd, "
         "   ownerID, "
         "   comparisonKey, "
         "   memberless, "
         "   password, "
         "   mailingList, "
         "   cspa "
         " FROM channels "
         " WHERE channelID = %i", channelID))
     {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return;
     }
 
     DBResultRow row;
 
     if (!(res.GetRow(row)))
     {
             _log(SERVICE__ERROR, "Channel %i isn't present in the database", channelID );
             return;
     }
 
     name = (row.IsNull(1) ? "" : row.GetText(1));    // empty displayName field in channels table row returns NULL, so fill this string with "" in that case
     motd = (row.IsNull(2) ? "" : row.GetText(2));    // empty motd field in channels table row returns NULL, so fill this string with "" in that case
     ownerid = row.GetUInt(3);
     compkey = (row.IsNull(4) ? "" : row.GetText(4)); // empty comparisonKey field in channels table row returns NULL, so fill this string with "" in that case
     memberless = row.GetBool(5);
     password = (row.IsNull(6) ? "" : row.GetText(6));// empty password field in channels table row returns NULL, so fill this string with "" in that case
     maillist = row.GetBool(7);
     cspa = row.GetUInt(8);
 }

Here is the call graph for this function:

std::string LSCDB::GetChannelName	(	uint32	id,
		const char *	table,
		const char *	column,
		const char *	key
	)

protected

Definition at line 382 of file LSCDB.cpp.

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

Referenced by GetAllianceName(), GetCharacterName(), GetConstellationName(), GetCorporationName(), GetRegionName(), and GetSolarSystemName().

                                                                                                     {
     DBQueryResult res;
     if (!sDatabase.RunQuery(res,"SELECT %s FROM %s WHERE %s = %u ", column, table, key, id)) {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return "";
     }
 
     DBResultRow row;
     if (!res.GetRow(row)) {
         _log(SERVICE__ERROR, "Couldn't find %s %u in table %s", key, id, table);
         return "";
     }
 
     return row.GetText(0);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void LSCDB::GetChannelNames	(	uint32	charID,
		std::vector< std::string > &	names
	)

Todo:: this entire file needs review

Definition at line 33 of file LSCDB.cpp.

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

                                                                        {
     DBQueryResult res;
 
     if (!sDatabase.RunQuery(res,
         "SELECT"
         "    ch.characterName, "
         "    cr.corporationName "
         " FROM chrCharacters AS ch"
         "  LEFT JOIN crpCorporation AS cr USING (corporationID) "
         " WHERE ch.characterID = %u ", charID))
     {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return;
     }
 
     DBResultRow row;
     if (!res.GetRow(row)) {
         _log(SERVICE__ERROR, "CharID %u isn't present in the database", charID);
         return;
     }
 
     names.push_back(row.GetText(0));    // charName
     names.push_back(row.GetText(1));    // corpName
 }

Here is the call graph for this function:

void LSCDB::GetChannelSubscriptions	(	uint32	charID,
		std::vector< long > &	ids,
		std::vector< std::string > &	names,
		std::vector< std::string > &	MOTDs,
		std::vector< unsigned long > &	ownerids,
		std::vector< std::string > &	compkeys,
		std::vector< int > &	memberless,
		std::vector< std::string > &	passwords,
		std::vector< int > &	maillists,
		std::vector< int > &	cspas,
		int &	channelCount
	)

Definition at line 285 of file LSCDB.cpp.

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

 {
     DBQueryResult res;
 
     // Cross-reference "channelchars" table with "channels" table using the charID
     // The result is a two column multi-row structure where each row is a channel
     // that the character (charID) is subscribed to where the channel ID is presented
     // in the first column and the display name of that channel in the second column
     if (!sDatabase.RunQuery(res,
         "SELECT"
         "   channelID, "
         "   displayName, "
         "   motd, "
         "   ownerID, "
         "   comparisonKey, "
         "   memberless, "
         "   password, "
         "   mailingList, "
         "   cspa "
         " FROM channels "
         " WHERE channelID = ANY ("
         "   SELECT channelID FROM channelChars WHERE charID = %u )", charID))
     {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return;
     }
 
     DBResultRow row;
     int rowCount = 0;
 
     // Traverse through all rows in the query result and copy the IDs and displayNames to the
     // "ids" and "names" vectors for return to the calling function:
     while(res.GetRow(row))
     {
         ++rowCount;
 
         ids.push_back(row.GetInt(0));
         names.push_back((row.GetText(1) == NULL ? "" : row.GetText(1)));    // empty displayName field in channels table row returns NULL, so fill this string with "" in that case
         MOTDs.push_back((row.GetText(2) == NULL ? "" : row.GetText(2)));    // empty motd field in channels table row returns NULL, so fill this string with "" in that case
         ownerids.push_back(row.GetUInt(3));
         compkeys.push_back((row.GetText(4) == NULL ? "" : row.GetText(4)));    // empty comparisonKey field in channels table row returns NULL, so fill this string with "" in that case
         memberless.push_back(row.GetUInt(5));
         passwords.push_back((row.GetText(6) == NULL ? "" : row.GetText(6)));    // empty password field in channels table row returns NULL, so fill this string with "" in that case
         maillists.push_back(row.GetUInt(7));
         cspas.push_back(row.GetUInt(8));
     }
 
     if (rowCount == 0) {
         //_log(SERVICE__ERROR, "CharID %u isn't present in the database", charID);
         return;
     }
 
     channelCount = rowCount;
 }

Here is the call graph for this function:

std::string LSCDB::GetCharacterName ( uint32 id )

inline

Definition at line 57 of file LSCDB.h.

References GetChannelName().

57 { return GetChannelName(id, "chrCharacters", "characterName", "charID"); }

LSCDB::GetChannelName

std::string GetChannelName(uint32 id, const char *table, const char *column, const char *key)

Definition: LSCDB.cpp:382

Here is the call graph for this function:

std::string LSCDB::GetConstellationName ( uint32 id )

inline

Definition at line 53 of file LSCDB.h.

References GetChannelName().

Referenced by LSCService::CreateSystemChannel().

53 { return GetChannelName(id, "mapConstellations", "constellationName", "constellationID"); }

LSCDB::GetChannelName

std::string GetChannelName(uint32 id, const char *table, const char *column, const char *key)

Definition: LSCDB.cpp:382

Here is the call graph for this function:

Here is the caller graph for this function:

std::string LSCDB::GetCorporationName ( uint32 id )

inline

Definition at line 55 of file LSCDB.h.

References GetChannelName().

Referenced by LSCService::CreateSystemChannel().

55 { return GetChannelName(id, "crpCorporation", "corporationName", "corporationID"); }

LSCDB::GetChannelName

std::string GetChannelName(uint32 id, const char *table, const char *column, const char *key)

Definition: LSCDB.cpp:382

Here is the call graph for this function:

Here is the caller graph for this function:

PyRep * LSCDB::GetMailDetails	(	uint32	messageID,
		uint32	readerID
	)

Definition at line 462 of file LSCDB.cpp.

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

                                                               {
     DBQueryResult result;
     DBResultRow row;
 
     //we need to query out the primary message here... not sure how to properly
     //grab the "main message" though... the text/plain clause is pretty hackish.
     if (!sDatabase.RunQuery(result,
         " SELECT eveMail.messageID, eveMail.senderID, eveMail.subject, " // need messageID as char*
         "   eveMailDetails.attachment, eveMailDetails.mimeTypeID, "
         "   eveMailMimeType.mimeType, eveMailMimeType.`binary`, "
         "   eveMail.created, eveMail.channelID "
         " FROM eveMail "
         " LEFT JOIN eveMailDetails ON eveMailDetails.messageID = eveMail.messageID "
         " LEFT JOIN eveMailMimeType ON eveMailMimeType.mimeTypeID = eveMailDetails.mimeTypeID "
         " WHERE eveMail.messageID=%u AND channelID=%u",
         messageID, readerID
     ))
     {
         _log(DATABASE__ERROR, "Error in query: %s", result.error.c_str());
         return nullptr;
     }
 
     if (!result.GetRow(row)) {
         codelog(SERVICE__MESSAGE, "No message with messageID %u", messageID);
         return nullptr;
     }
 
     Rsp_GetEVEMailDetails details;
     details.messageID = row.GetUInt(0);
     details.senderID = row.GetUInt(1);
     details.subject = row.GetText(2);
     details.body = row.GetText(3);
     details.created = row.GetInt64(7);
     details.channelID = row.GetUInt(8);
     details.deleted = 0; // If a message's details are sent, then it isn't deleted. If it's deleted, details cannot be sent
     details.mimeTypeID = row.GetInt(4);
     details.mimeType = row.GetText(5);
     details.binary = row.GetInt(6);
 
     return details.Encode();
 }

Here is the call graph for this function:

PyObject * LSCDB::GetMailHeaders ( uint32 recID )

Definition at line 446 of file LSCDB.cpp.

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

                                             {
     DBQueryResult res;
 
     if(!sDatabase.RunQuery(res,
         "SELECT channelID, messageID, senderID, subject, created, `read` "
         " FROM eveMail "
         " WHERE channelID=%u", recID))
     {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return nullptr;
     }
 
     return DBResultToRowset(res);
 }

Here is the call graph for this function:

int32 LSCDB::GetNextAvailableChannelID ( )

Todo:: fix this shit

Definition at line 58 of file LSCDB.cpp.

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

 {
     DBQueryResult res;
     if( !sDatabase.RunQuery( res,
         "SELECT"
         "    channelID "
         " FROM channels "
         " WHERE channelID >= %i ", LSCService::BASE_CHANNEL_ID ))
     {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return 0;
     }
 
     int32 currentChannelID = LSCService::BASE_CHANNEL_ID;
 
     DBResultRow row;
     while( res.GetRow(row) )
     {
         if ( ++currentChannelID < row.GetInt( 0 ) )
             return currentChannelID;
     }
 
         // Check to make sure that the next available channelID is not equal to the Maximum channel ID value
     if( currentChannelID <= LSCService::MAX_CHANNEL_ID )
         return currentChannelID;
 
     return 0;    // No free channel IDs found (this should never happen as there are way too many IDs to exhaust)
 }

Here is the call graph for this function:

std::string LSCDB::GetRegionName ( uint32 id )

inline

Definition at line 52 of file LSCDB.h.

References GetChannelName().

Referenced by LSCService::CreateSystemChannel().

52 { return GetChannelName(id, "mapRegions", "regionName", "regionID"); }

LSCDB::GetChannelName

std::string GetChannelName(uint32 id, const char *table, const char *column, const char *key)

Definition: LSCDB.cpp:382

Here is the call graph for this function:

Here is the caller graph for this function:

std::string LSCDB::GetSolarSystemName ( uint32 id )

inline

Definition at line 54 of file LSCDB.h.

References GetChannelName().

Referenced by LSCService::CreateSystemChannel().

54 { return GetChannelName(id, "mapSolarSystems", "solarSystemName", "solarSystemID"); }

LSCDB::GetChannelName

std::string GetChannelName(uint32 id, const char *table, const char *column, const char *key)

Definition: LSCDB.cpp:382

Here is the call graph for this function:

Here is the caller graph for this function:

bool LSCDB::IsChannelIDAvailable ( int32 channel_ID )

Definition at line 172 of file LSCDB.cpp.

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

 {
     DBQueryResult res;
 
     if (!sDatabase.RunQuery(res,
         "SELECT"
         "    channelID "
         " FROM channels "
         " WHERE channelID = %i", channelID ))
     {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return false;
     }
 
     DBResultRow row;
 
     // Return true (this channelID not in use) if there are no rows returned by the query:
     if (!(res.GetRow(row)))
         return true;
 
     return false;
 }

Here is the call graph for this function:

bool LSCDB::IsChannelNameAvailable ( std::string name )

Definition at line 145 of file LSCDB.cpp.

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

 {
     DBQueryResult res;
 
     // MySQL query channels table for any channel whose displayName matches "name":
     if (!sDatabase.RunQuery(res,
         "SELECT"
         "    displayName "
         " FROM channels "
         " WHERE displayName = upper('%s')", name.c_str()))
     {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return false;
     }
 
     DBResultRow row;
 
     // Return true (this 'displayName' not in use) if there are no rows returned by the query:
     if (!res.GetRow(row))
         return true;
 
     return false;
 }

Here is the call graph for this function:

bool LSCDB::IsChannelSubscribedByThisChar	(	uint32	char_ID,
		int32	channel_ID
	)

Definition at line 198 of file LSCDB.cpp.

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

 {
     DBQueryResult res;
 
     if (!sDatabase.RunQuery(res,
         "SELECT"
         "   channelID, "
         "   charID "
         " FROM channelChars "
         " WHERE channelID = %i AND charID = %u", channelID, charID ))
     {
         _log(DATABASE__ERROR, "Error in query: %s", res.error.c_str());
         return false;
     }
 
     DBResultRow row;
 
     // Return false (no subscription exists) if there are no rows returned by the query:
     if (!(res.GetRow(row)))
         return false;
 
     return true;
 }

Here is the call graph for this function:

bool LSCDB::MarkMessageRead ( uint32 messageID )

Definition at line 505 of file LSCDB.cpp.

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

                                             {
     DBerror err;
 
     if (!sDatabase.RunQuery(err,
         " UPDATE eveMail "
         " SET `read` = 1 "
         " WHERE messageID=%u", messageID
     ))
     {
         _log(DATABASE__ERROR, "Error in query: %s", err.c_str());
         return false;
     }
 
     return true;
 }

Here is the call graph for this function:

uint32 LSCDB::StoreMail	(	uint32	senderID,
		uint32	recipID,
		const char *	subject,
		const char *	message,
		int64	sentTime
	)

Definition at line 399 of file LSCDB.cpp.

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

Referenced by LSCService::SendMail().

                                                                                                                    {
     DBQueryResult res;
     DBerror err;
     DBResultRow row;
 
     std::string escaped;
     // Escape message header
     sDatabase.DoEscapeString(escaped, subject);
 
     // Store message header
     uint32 messageID;
     if (!sDatabase.RunQueryLID(err, messageID,
         " INSERT INTO eveMail "
         " (channelID, senderID, subject, created) "
         " VALUES (%u, %u, '%s', %li) ",
                                recipID, senderID, escaped.c_str(), sentTime ))
     {
         _log(DATABASE__ERROR, "Error in query, message header couldn't be saved: %s", err.c_str());
         return (0);
     }
 
     _log(SERVICE__MESSAGE, "New messageID: %u", messageID);
 
     // Escape message content
     sDatabase.DoEscapeString(escaped, message);
 
     // Store message content
     if (!sDatabase.RunQuery(err,
         " INSERT INTO eveMailDetails "
         " (messageID, mimeTypeID, attachment) VALUES (%u, 1, '%s') ",
                             messageID, escaped.c_str()
     ))
     {
         _log(DATABASE__ERROR, "Error in query, message content couldn't be saved: %s", err.c_str());
         // Delete message header
         if (!sDatabase.RunQuery(err, "DELETE FROM `eveMail` WHERE `messageID` = %u;", messageID))
         {
             _log(DATABASE__ERROR, "Failed to remove invalid header data for messgae id %u: %s", messageID, err.c_str());
         }
         return (0);
     }
 
 
     return (messageID);
 }

Here is the call graph for this function:

Here is the caller graph for this function:

void LSCDB::UpdateChannelInfo ( LSCChannel * channel )

Definition at line 88 of file LSCDB.cpp.

References _log, DBerror::c_str(), LSCChannel::GetChannelID(), LSCChannel::GetComparisonKey(), LSCChannel::GetCSPA(), LSCChannel::GetDisplayName(), LSCChannel::GetMailingList(), LSCChannel::GetMemberless(), LSCChannel::GetMOTD(), LSCChannel::GetOwnerID(), LSCChannel::GetPassword(), and sDatabase.

                                                  {
     std::string new_password = "NULL";
     if (channel->GetPassword() != "")
         new_password = "'" + channel->GetPassword() + "'";
 
     DBerror err;
     if (!sDatabase.RunQuery(err,
         " INSERT INTO channels"
         "   (channelID, ownerID, displayName, motd, comparisonKey, memberless, password, mailingList, cspa)"
         " VALUES (%i, %u, '%s', '%s', '%s', %u, '%s', %u, %u)"
         " ON DUPLICATE KEY UPDATE"
         "  ownerID=VALUES(ownerID),"
         "  displayName=VALUES(displayName),"
         "  motd=VALUES(motd),"
         "  comparisonKey=VALUES(comparisonKey),"
         "  memberless=VALUES(memberless),"
         "  password=VALUES(password),"
         "  mailingList=VALUES(mailingList),"
         "  cspa=VALUES(cspa)",
         channel->GetChannelID(),
         channel->GetOwnerID(),
         channel->GetDisplayName().c_str(),
         channel->GetMOTD().c_str(),
         channel->GetComparisonKey().c_str(),
         (channel->GetMemberless() ? 1 : 0),
         new_password.c_str(),
         (channel->GetMailingList() ? 1 : 0),
         channel->GetCSPA()))
     {
         _log(DATABASE__ERROR, "Error in query: %s", err.c_str());
     }
 }

Here is the call graph for this function:

void LSCDB::UpdateSubscription	(	int32	channelID,
		Client *	pClient
	)

Definition at line 121 of file LSCDB.cpp.

References Client::GetAccountRole(), Client::GetAllianceID(), Client::GetCharacterID(), Client::GetCorporationID(), and sDatabase.

                                                                {
     DBerror err;
     sDatabase.RunQuery(err,
         " INSERT INTO channelChars "
         " (channelID, corpID, charID, allianceID, role, extra) "
         " VALUES (%i, %i, %i, %i, %li, 0) ",
         channelID, pClient->GetCorporationID(),  pClient->GetCharacterID(), pClient->GetAllianceID(), pClient->GetAccountRole());
 }

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/chat/LSCDB.h
/backups/local/src/eve/EvEmu_Crucible/src/eve-server/chat/LSCDB.cpp

Public Member Functions

Protected Member Functions

Additional Inherited Members

Detailed Description

Member Function Documentation