/**
* Clone MailDraft from another MailDraft.
*
* @param draft Point to source for draft cloning.
*/
void MailDraft::CloneFrom(MailDraft const& draft)
{
m_mailTemplateId = draft.GetMailTemplateId();
m_mailTemplateItemsNeed = draft.m_mailTemplateItemsNeed;
m_subject = draft.GetSubject();
m_body = draft.GetBody();
m_money = draft.GetMoney();
m_COD = draft.GetCOD();
for(MailItemMap::const_iterator mailItemIter = draft.m_items.begin(); mailItemIter != draft.m_items.end(); ++mailItemIter)
{
Item* item = mailItemIter->second;
if(Item* newitem = item->CloneItem(item->GetCount()))
{
newitem->SaveToDB();
AddItem(newitem);
}
}
}
void WorldSession::SendExternalMails()
{
sLog.outDebug("External Mail - Send Mails from Queue...");
QueryResult* result = CharacterDatabase.Query("SELECT id,receiver,subject,message,money,item,item_count FROM mail_external");
if (!result)
{
sLog.outDebug("External Mail - No Mails in Queue...");
return;
}
else
{
do
{
Field *fields = result->Fetch();
uint32 id = fields[0].GetUInt32();
Player *pReceiver = sObjectMgr.GetPlayer(fields[1].GetUInt64());
std::string subject = fields[2].GetString();
std::string message = fields[3].GetString();
uint32 money = fields[4].GetUInt32();
uint32 ItemID = fields[5].GetUInt32();
uint32 ItemCount = fields[6].GetUInt32();
if (pReceiver)
{
MailDraft draft;
draft.SetSubjectAndBody(subject, message);
MailSender sender(MAIL_NORMAL, pReceiver ? pReceiver->GetObjectGuid().GetCounter() : 0, MAIL_STATIONERY_GM);
MailReceiver reciever(pReceiver, pReceiver->GetObjectGuid());
sLog.outDebug("External Mail - Sending mail to %u, Item:%u", pReceiver->GetObjectGuid().GetCounter(), ItemID);
uint32 itemTextId = !message.empty() ? sObjectMgr.CreateItemText(message) : 0;
if (ItemID != 0)
{
Item* ToMailItem = Item::CreateItem(ItemID, ItemCount, pReceiver);
if (ToMailItem)
{
ToMailItem->SaveToDB();
draft.AddItem(ToMailItem);
}
draft.SetMoney(money);
}
else
draft.SetMoney(money);
draft.SendMailTo(reciever,sender,MAIL_CHECK_MASK_RETURNED);
CharacterDatabase.PExecute("DELETE FROM mail_external WHERE id=%u", id);
}
else
sLog.outDebug("External Mail - Mail with unknown player GUID %u in mail_external",fields[1].GetUInt32());
}
while(result->NextRow());
}
sLog.outDebug("External Mail - All Mails Sent...");
}
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...");
}
void WorldSession::SendExternalMails()
{
TC_LOG_DEBUG("entities.player.character", "External Mail> Sending mails in queue...");
PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_GET_EXTERNAL_MAIL);
PreparedQueryResult result = CharacterDatabase.Query(stmt);
if (!result)
{
TC_LOG_DEBUG("entities.player.character", "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();
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();
ObjectGuid receiverGuid(HIGHGUID_PLAYER, receiver_guid);
Player *receiver = ObjectAccessor::FindPlayer(receiverGuid);
mail = new MailDraft(subject, body);
if (money)
{
TC_LOG_DEBUG("entities.player.character", "External Mail> Adding money");
mail->AddMoney(money);
}
if (itemId)
{
TC_LOG_DEBUG("entities.player.character", "External Mail> Adding %u of item with id %u", itemCount, itemId);
if(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);
TC_LOG_DEBUG("entities.player.character", "External Mail> Mail sent");
} while (result->NextRow());
CharacterDatabase.CommitTransaction(trans);
TC_LOG_DEBUG("entities.player.character", "External Mail> All Mails Sent...");
}
