void WorldSession::SendExternalMails()
{
sLog->outCommand(0, "EXTERNAL MAIL> Sending mails in queue...");
PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_GET_EXTERNAL_MAIL);
PreparedQueryResult result = CharacterDatabase.Query(stmt);
if (!result)
{
sLog->outCommand(0, "EXTERNAL MAIL> No mails in queue...");
return;
}
SQLTransaction trans = CharacterDatabase.BeginTransaction();
MailDraft* mail = NULL;
do
{
Field *fields = result->Fetch();
uint32 id = fields[0].GetUInt32();
uint32 receiver_guid = fields[1].GetUInt32();
ObjectGuid receiverGuid(HIGHGUID_PLAYER, receiver_guid);
std::string subject = fields[2].GetString();
std::string body = fields[3].GetString();
uint32 money = fields[4].GetUInt32();
uint32 itemId = fields[5].GetUInt32();
uint32 itemCount = fields[6].GetUInt32();
Player *receiver = ObjectAccessor::FindPlayer(receiverGuid);
mail = new MailDraft(subject, body);
if (money)
{
sLog->outCommand(0, "EXTERNAL MAIL> Adding money");
mail->AddMoney(money);
}
if (itemId)
{
sLog->outCommand(0, "EXTERNAL MAIL> Adding %u of item with id %u", itemCount, itemId);
Item* mailItem = Item::CreateItem(itemId, itemCount);
mailItem->SaveToDB(trans);
mail->AddItem(mailItem);
}
mail->SendMailTo(trans, receiver ? receiver : MailReceiver(receiver_guid), MailSender(MAIL_NORMAL, 0, MAIL_STATIONERY_GM), MAIL_CHECK_MASK_RETURNED);
delete mail;
stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_EXTERNAL_MAIL);
stmt->setUInt32(0, id);
trans->Append(stmt);
sLog->outCommand(0, "EXTERNAL MAIL> Mail sent");
}
while (result->NextRow());
CharacterDatabase.CommitTransaction(trans);
sLog->outCommand(0, "EXTERNAL MAIL> All Mails Sent...");
}
void WorldSession::SendExternalMails()
{
PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_GET_EXTERNAL_MAIL);
PreparedQueryResult result = CharacterDatabase.Query(stmt);
if (!result)
{
return;
}
SQLTransaction trans = CharacterDatabase.BeginTransaction();
MailDraft* mail = NULL;
do
{
Field *fields = result->Fetch();
uint32 id = fields[0].GetUInt32();
uint32 receiver_guid = fields[1].GetUInt32();
std::string subject = fields[2].GetString();
std::string body = fields[3].GetString();
uint32 money = fields[4].GetUInt32();
uint32 itemId = fields[5].GetUInt32();
uint32 itemCount = fields[6].GetUInt32();
Player *receiver = sObjectMgr->GetPlayerByLowGUID(receiver_guid);
mail = new MailDraft(subject, body);
if (money)
{
mail->AddMoney(money);
}
if (itemId)
{
Item* mailItem = Item::CreateItem(itemId, itemCount);
mailItem->SaveToDB(trans);
mail->AddItem(mailItem);
}
mail->SendMailTo(trans, receiver ? receiver : MailReceiver(receiver_guid), MailSender(MAIL_NORMAL, 0, MAIL_STATIONERY_GM), MAIL_CHECK_MASK_RETURNED);
delete mail;
stmt = CharacterDatabase.GetPreparedStatement(CHAR_DEL_EXTERNAL_MAIL);
stmt->setUInt32(0, id);
trans->Append(stmt);
}
while (result->NextRow());
CharacterDatabase.CommitTransaction(trans);
}
void SendExternalMails()
{
QueryResult result = CharacterDatabase.PQuery(CHAR_GET_EXTERNAL_MAIL);
if (!result)
return;
SQLTransaction trans = CharacterDatabase.BeginTransaction();
MailDraft* mail = NULL;
do
{
Field *fields = result->Fetch();
uint32 id = fields[0].GetUInt32();
uint32 receiver_guid = fields[1].GetUInt32();
std::string subject = fields[2].GetString();
std::string body = fields[3].GetString();
uint32 money = fields[4].GetUInt32();
uint32 itemId = fields[5].GetUInt32();
uint32 itemCount = fields[6].GetUInt32();
Player* receiver = ObjectAccessor::FindPlayer(receiver_guid);
mail = new MailDraft(subject, body);
if (money)
mail->AddMoney(money);
if (itemId)
{
ItemTemplate const* pProto = sObjectMgr->GetItemTemplate(itemId);
if (pProto)
{
Item* mailItem = Item::CreateItem(itemId, itemCount);
mailItem->SaveToDB(trans);
mail->AddItem(mailItem);
}
else
sLog->outError(LOG_FILTER_GENERAL, "EXTERNAL MAIL> Tried to add non-existing item with id %u, aborted", itemId);
}
mail->SendMailTo(trans, receiver ? receiver : MailReceiver(receiver_guid), MailSender(MAIL_NORMAL, 0, MAIL_STATIONERY_GM), MAIL_CHECK_MASK_RETURNED);
delete mail;
CharacterDatabase.PExecute(CHAR_DEL_EXTERNAL_MAIL, id);
}
while (result->NextRow());
CharacterDatabase.CommitTransaction(trans);
}
void WorldSession::SendExternalMails()
{
sLog->outString("EXTERNAL MAIL> Sending mails in queue...");
QueryResult result = CharacterDatabase.Query("SELECT id,receiver,subject,message,money,item,item_count FROM mail_external");
SQLTransaction trans = CharacterDatabase.BeginTransaction();
if(!result)
{
sLog->outString("EXTERNAL MAIL> No mails in queue...");
// delete result;
return;
}
else
{
uint32 last_id = 0;
MailDraft* mail = NULL;
uint32 last_receiver_guid;
do
{
Field *fields = result->Fetch();
uint32 id = fields[0].GetUInt32();
uint64 receiver_guid = fields[1].GetUInt64();
std::string subject = fields[2].GetString();
std::string body = fields[3].GetString();
uint32 money = fields[4].GetUInt32();
uint32 itemId = fields[5].GetUInt32();
uint32 itemCount = fields[6].GetUInt32();
Player *receiver = sObjectMgr->GetPlayer( receiver_guid );
if (id != last_id)
{
// send mail
if (last_id != 0)
{
sLog->outString("EXTERNAL MAIL> Sending mail to character with guid %d", last_receiver_guid);
mail->SendMailTo(trans,MailReceiver(last_receiver_guid), MailSender(MAIL_NORMAL, 0, MAIL_STATIONERY_GM), MAIL_CHECK_MASK_RETURNED);
delete mail;
CharacterDatabase.PExecute("DELETE FROM mail_external WHERE id=%u", last_id);
sLog->outString("EXTERNAL MAIL> Mail sent");
}
//Create the maildraft
mail = new MailDraft( subject, body );
if(money)
{
sLog->outString("EXTERNAL MAIL> Adding money");
mail->AddMoney(money);
}
}
if (itemId)
{
sLog->outString("EXTERNAL MAIL> Adding %u of item with id %u", itemCount, itemId);
Item* mailItem = Item::CreateItem( itemId, itemCount, receiver );
mailItem->SaveToDB(trans);
mail->AddItem(mailItem);
}
last_id = id;
last_receiver_guid = receiver_guid;
}
while( result->NextRow() );
// we only send a mail when mail_id!=last_mail_id, so we need to send the very last mail here:
if (last_id != 0)
{
// send last mail
sLog->outString("EXTERNAL MAIL> Sending mail to character with guid %d", last_receiver_guid);
mail->SendMailTo(trans,MailReceiver(last_receiver_guid), MailSender(MAIL_NORMAL, 0, MAIL_STATIONERY_GM), MAIL_CHECK_MASK_RETURNED);
delete mail;
CharacterDatabase.PExecute("DELETE FROM mail_external WHERE id=%u", last_id);
sLog->outString("EXTERNAL MAIL> Mail sent");
}
}
CharacterDatabase.CommitTransaction(trans);
sLog->outString("EXTERNAL MAIL> All Mails Sent...");
}
