src/game/Mail.cpp

   1 /*
   2  * Copyright (C) 2005-2009 MaNGOS <http://getmangos.com/>
   3  *
   4  * This program is free software; you can redistribute it and/or modify
   5  * it under the terms of the GNU General Public License as published by
   6  * the Free Software Foundation; either version 2 of the License, or
   7  * (at your option) any later version.
   8  *
   9  * This program is distributed in the hope that it will be useful,
  10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  * GNU General Public License for more details.
  13  *
  14  * You should have received a copy of the GNU General Public License
  15  * along with this program; if not, write to the Free Software
  16  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  17  */
  18
  19 #include "Mail.h"
  20 #include "WorldPacket.h"
  21 #include "WorldSession.h"
  22 #include "Opcodes.h"
  23 #include "Log.h"
  24 #include "World.h"
  25 #include "ObjectMgr.h"
  26 #include "Player.h"
  27 #include "UpdateMask.h"
  28 #include "Unit.h"
  29 #include "Language.h"
  30 #include "Database/DBCStores.h"
  31
  32 void MailItem::deleteItem( bool inDB )
  33 {
  34     if(item)
  35     {
  36         if(inDB)
  37             CharacterDatabase.PExecute("DELETE FROM item_instance WHERE guid='%u'", item->GetGUIDLow());
  38
  39         delete item;
  40         item=NULL;
  41     }
  42 }
  43
  44 void WorldSession::HandleSendMail(WorldPacket & recv_data )
  45 {
  46     CHECK_PACKET_SIZE(recv_data,8+1+1+1+4+4+1+4+4+8+1);
  47
  48     uint64 mailbox, unk3;
  49     std::string receiver, subject, body;
  50     uint32 unk1, unk2, money, COD;
  51     uint8 unk4;
  52     recv_data >> mailbox;
  53     recv_data >> receiver;
  54
  55     // recheck
  56     CHECK_PACKET_SIZE(recv_data, 8+(receiver.size()+1)+1+1+4+4+1+4+4+8+1);
  57
  58     recv_data >> subject;
  59
  60     // recheck
  61     CHECK_PACKET_SIZE(recv_data, 8+(receiver.size()+1)+(subject.size()+1)+1+4+4+1+4+4+8+1);
  62
  63     recv_data >> body;
  64
  65     // recheck
  66     CHECK_PACKET_SIZE(recv_data, 8+(receiver.size()+1)+(subject.size()+1)+(body.size()+1)+4+4+1+4+4+8+1);
  67
  68     recv_data >> unk1;                                      // stationery?
  69     recv_data >> unk2;                                      // 0x00000000
  70
  71     MailItemsInfo mi;
  72
  73     uint8 items_count;
  74     recv_data >> items_count;                               // attached items count
  75
  76     if(items_count > 12)                                    // client limit
  77         return;
  78
  79     // recheck
  80     CHECK_PACKET_SIZE(recv_data, 8+(receiver.size()+1)+(subject.size()+1)+(body.size()+1)+4+4+1+items_count*(1+8)+4+4+8+1);
  81
  82     if(items_count)
  83     {
  84         for(uint8 i = 0; i < items_count; ++i)
  85         {
  86             uint8  item_slot;
  87             uint64 item_guid;
  88             recv_data >> item_slot;
  89             recv_data >> item_guid;
  90             mi.AddItem(GUID_LOPART(item_guid), item_slot);
  91         }
  92     }
  93
  94     recv_data >> money >> COD;                              // money and cod
  95     recv_data >> unk3;                                      // const 0
  96     recv_data >> unk4;                                      // const 0
  97
  98     items_count = mi.size();                                // this is the real size after the duplicates have been removed
  99
 100     if (receiver.empty())
 101         return;
 102
 103     Player* pl = _player;
 104
 105     uint64 rc = 0;
 106     if(normalizePlayerName(receiver))
 107         rc = objmgr.GetPlayerGUIDByName(receiver);
 108
 109     if (!rc)
 110     {
 111         sLog.outDetail("Player %u is sending mail to %s (GUID: not existed!) with subject %s and body %s includes %u items, %u copper and %u COD copper with unk1 = %u, unk2 = %u",
 112             pl->GetGUIDLow(), receiver.c_str(), subject.c_str(), body.c_str(), items_count, money, COD, unk1, unk2);
 113         pl->SendMailResult(0, 0, MAIL_ERR_RECIPIENT_NOT_FOUND);
 114         return;
 115     }
 116
 117     sLog.outDetail("Player %u is sending mail to %s (GUID: %u) with subject %s and body %s includes %u items, %u copper and %u COD copper with unk1 = %u, unk2 = %u", pl->GetGUIDLow(), receiver.c_str(), GUID_LOPART(rc), subject.c_str(), body.c_str(), items_count, money, COD, unk1, unk2);
 118
 119     if(pl->GetGUID() == rc)
 120     {
 121         pl->SendMailResult(0, 0, MAIL_ERR_CANNOT_SEND_TO_SELF);
 122         return;
 123     }
 124
 125     uint32 reqmoney = money + 30;
 126     if (items_count)
 127         reqmoney = money + (30 * items_count);
 128
 129     if (pl->GetMoney() < reqmoney)
 130     {
 131         pl->SendMailResult(0, 0, MAIL_ERR_NOT_ENOUGH_MONEY);
 132         return;
 133     }
 134
 135     Player *receive = objmgr.GetPlayer(rc);
 136
 137     uint32 rc_team = 0;
 138     uint8 mails_count = 0;                                  //do not allow to send to one player more than 100 mails
 139
 140     if(receive)
 141     {
 142         rc_team = receive->GetTeam();
 143         mails_count = receive->GetMailSize();
 144     }
 145     else
 146     {
 147         rc_team = objmgr.GetPlayerTeamByGUID(rc);
 148         QueryResult* result = CharacterDatabase.PQuery("SELECT COUNT(*) FROM mail WHERE receiver = '%u'", GUID_LOPART(rc));
 149         if(result)
 150         {
 151             Field *fields = result->Fetch();
 152             mails_count = fields[0].GetUInt32();
 153             delete result;
 154         }
 155     }
 156     //do not allow to have more than 100 mails in mailbox.. mails count is in opcode uint8!!! - so max can be 255..
 157     if (mails_count > 100)
 158     {
 159         pl->SendMailResult(0, 0, MAIL_ERR_INTERNAL_ERROR);
 160         return;
 161     }
 162     // test the receiver's Faction...
 163     if (!sWorld.getConfig(CONFIG_ALLOW_TWO_SIDE_INTERACTION_MAIL) && pl->GetTeam() != rc_team && GetSecurity() == SEC_PLAYER)
 164     {
 165         pl->SendMailResult(0, 0, MAIL_ERR_NOT_YOUR_TEAM);
 166         return;
 167     }
 168
 169     if (items_count)
 170     {
 171         for(MailItemMap::iterator mailItemIter = mi.begin(); mailItemIter != mi.end(); ++mailItemIter)
 172         {
 173             MailItem& mailItem = mailItemIter->second;
 174
 175             if(!mailItem.item_guidlow)
 176             {
 177                 pl->SendMailResult(0, 0, MAIL_ERR_INTERNAL_ERROR);
 178                 return;
 179             }
 180
 181             mailItem.item = pl->GetItemByGuid(MAKE_NEW_GUID(mailItem.item_guidlow, 0, HIGHGUID_ITEM));
 182             // prevent sending bag with items (cheat: can be placed in bag after adding equipped empty bag to mail)
 183             if(!mailItem.item || !mailItem.item->CanBeTraded())
 184             {
 185                 pl->SendMailResult(0, 0, MAIL_ERR_INTERNAL_ERROR);
 186                 return;
 187             }
 188             if (mailItem.item->HasFlag(ITEM_FIELD_FLAGS, ITEM_FLAGS_CONJURED) || mailItem.item->GetUInt32Value(ITEM_FIELD_DURATION))
 189             {
 190                 pl->SendMailResult(0, 0, MAIL_ERR_INTERNAL_ERROR);
 191                 return;
 192             }
 193
 194             if(COD && mailItem.item->HasFlag(ITEM_FIELD_FLAGS, ITEM_FLAGS_WRAPPED))
 195             {
 196                 pl->SendMailResult(0, 0, MAIL_ERR_CANT_SEND_WRAPPED_COD);
 197                 return;
 198             }
 199         }
 200     }
 201     pl->SendMailResult(0, 0, MAIL_OK);
 202
 203     uint32 itemTextId = 0;
 204     if (!body.empty())
 205     {
 206         itemTextId = objmgr.CreateItemText( body );
 207     }
 208
 209     pl->ModifyMoney( -int32(reqmoney) );
 210
 211     bool needItemDelay = false;
 212
 213     if(items_count > 0 || money > 0)
 214     {
 215         uint32 rc_account = 0;
 216         if(receive)
 217             rc_account = receive->GetSession()->GetAccountId();
 218         else
 219             rc_account = objmgr.GetPlayerAccountIdByGUID(rc);
 220
 221         if (items_count > 0)
 222         {
 223             for(MailItemMap::iterator mailItemIter = mi.begin(); mailItemIter != mi.end(); ++mailItemIter)
 224             {
 225                 MailItem& mailItem = mailItemIter->second;
 226                 if(!mailItem.item)
 227                     continue;
 228
 229                 mailItem.item_template = mailItem.item ? mailItem.item->GetEntry() : 0;
 230
 231                 if( GetSecurity() > SEC_PLAYER && sWorld.getConfig(CONFIG_GM_LOG_TRADE) )
 232                 {
 233                     sLog.outCommand(GetAccountId(), "GM %s (Account: %u) mail item: %s (Entry: %u Count: %u) to player: %s (Account: %u)",
 234                         GetPlayerName(), GetAccountId(), mailItem.item->GetProto()->Name1, mailItem.item->GetEntry(), mailItem.item->GetCount(), receiver.c_str(), rc_account);
 235                 }
 236
 237                 pl->MoveItemFromInventory(mailItem.item->GetBagSlot(), mailItem.item->GetSlot(), true);
 238                 CharacterDatabase.BeginTransaction();
 239                 mailItem.item->DeleteFromInventoryDB();     //deletes item from character's inventory
 240                 mailItem.item->SaveToDB();                  // recursive and not have transaction guard into self, item not in inventory and can be save standalone
 241                 // owner in data will set at mail receive and item extracting
 242                 CharacterDatabase.PExecute("UPDATE item_instance SET owner_guid = '%u' WHERE guid='%u'", GUID_LOPART(rc), mailItem.item->GetGUIDLow());
 243                 CharacterDatabase.CommitTransaction();
 244             }
 245
 246             // if item send to character at another account, then apply item delivery delay
 247             needItemDelay = pl->GetSession()->GetAccountId() != rc_account;
 248         }
 249
 250         if(money > 0 &&  GetSecurity() > SEC_PLAYER && sWorld.getConfig(CONFIG_GM_LOG_TRADE))
 251         {
 252             sLog.outCommand(GetAccountId(),"GM %s (Account: %u) mail money: %u to player: %s (Account: %u)",
 253                 GetPlayerName(), GetAccountId(), money, receiver.c_str(), rc_account);
 254         }
 255     }
 256
 257     // If theres is an item, there is a one hour delivery delay if sent to another account's character.
 258     uint32 deliver_delay = needItemDelay ? sWorld.getConfig(CONFIG_MAIL_DELIVERY_DELAY) : 0;
 259
 260     // will delete item or place to receiver mail list
 261     WorldSession::SendMailTo(receive, MAIL_NORMAL, MAIL_STATIONERY_NORMAL, pl->GetGUIDLow(), GUID_LOPART(rc), subject, itemTextId, &mi, money, COD, MAIL_CHECK_MASK_NONE, deliver_delay);
 262
 263     CharacterDatabase.BeginTransaction();
 264     pl->SaveInventoryAndGoldToDB();
 265     CharacterDatabase.CommitTransaction();
 266 }
 267
 268 //called when mail is read
 269 void WorldSession::HandleMarkAsRead(WorldPacket & recv_data )
 270 {
 271     CHECK_PACKET_SIZE(recv_data,8+4);
 272
 273     uint64 mailbox;
 274     uint32 mailId;
 275     recv_data >> mailbox;
 276     recv_data >> mailId;
 277     Player *pl = _player;
 278     Mail *m = pl->GetMail(mailId);
 279     if (m)
 280     {
 281         if (pl->unReadMails)
 282             --pl->unReadMails;
 283         m->checked = m->checked | MAIL_CHECK_MASK_READ;
 284         // m->expire_time = time(NULL) + (30 * DAY);  // Expire time do not change at reading mail
 285         pl->m_mailsUpdated = true;
 286         m->state = MAIL_STATE_CHANGED;
 287     }
 288 }
 289
 290 //called when client deletes mail
 291 void WorldSession::HandleMailDelete(WorldPacket & recv_data )
 292 {
 293     CHECK_PACKET_SIZE(recv_data,8+4);
 294
 295     uint64 mailbox;
 296     uint32 mailId;
 297     recv_data >> mailbox;
 298     recv_data >> mailId;
 299     Player* pl = _player;
 300     pl->m_mailsUpdated = true;
 301     Mail *m = pl->GetMail(mailId);
 302     if(m)
 303         m->state = MAIL_STATE_DELETED;
 304     pl->SendMailResult(mailId, MAIL_DELETED, 0);
 305 }
 306
 307 void WorldSession::HandleReturnToSender(WorldPacket & recv_data )
 308 {
 309     CHECK_PACKET_SIZE(recv_data,8+4);
 310
 311     uint64 mailbox;
 312     uint32 mailId;
 313     recv_data >> mailbox;
 314     recv_data >> mailId;
 315     Player *pl = _player;
 316     Mail *m = pl->GetMail(mailId);
 317     if(!m || m->state == MAIL_STATE_DELETED || m->deliver_time > time(NULL))
 318     {
 319         pl->SendMailResult(mailId, MAIL_RETURNED_TO_SENDER, MAIL_ERR_INTERNAL_ERROR);
 320         return;
 321     }
 322     //we can return mail now
 323     //so firstly delete the old one
 324     CharacterDatabase.BeginTransaction();
 325     CharacterDatabase.PExecute("DELETE FROM mail WHERE id = '%u'", mailId);
 326                                                             // needed?
 327     CharacterDatabase.PExecute("DELETE FROM mail_items WHERE mail_id = '%u'", mailId);
 328     CharacterDatabase.CommitTransaction();
 329     pl->RemoveMail(mailId);
 330
 331     MailItemsInfo mi;
 332
 333     if(m->HasItems())
 334     {
 335         for(std::vector<MailItemInfo>::iterator itr2 = m->items.begin(); itr2 != m->items.end(); ++itr2)
 336         {
 337             Item *item = pl->GetMItem(itr2->item_guid);
 338             if(item)
 339                 mi.AddItem(item->GetGUIDLow(), item->GetEntry(), item);
 340             else
 341             {
 342                 //WTF?
 343             }
 344
 345             pl->RemoveMItem(itr2->item_guid);
 346         }
 347     }
 348
 349     SendReturnToSender(MAIL_NORMAL, GetAccountId(), m->receiver, m->sender, m->subject, m->itemTextId, &mi, m->money, m->mailTemplateId);
 350
 351     delete m;                                               //we can deallocate old mail
 352     pl->SendMailResult(mailId, MAIL_RETURNED_TO_SENDER, 0);
 353 }
 354
 355 void WorldSession::SendReturnToSender(uint8 messageType, uint32 sender_acc, uint32 sender_guid, uint32 receiver_guid, const std::string& subject, uint32 itemTextId, MailItemsInfo *mi, uint32 money, uint16 mailTemplateId )
 356 {
 357     if(messageType != MAIL_NORMAL)                          // return only to players
 358     {
 359         mi->deleteIncludedItems(true);
 360         return;
 361     }
 362
 363     Player *receiver = objmgr.GetPlayer(MAKE_NEW_GUID(receiver_guid, 0, HIGHGUID_PLAYER));
 364
 365     uint32 rc_account = 0;
 366     if(!receiver)
 367         rc_account = objmgr.GetPlayerAccountIdByGUID(MAKE_NEW_GUID(receiver_guid, 0, HIGHGUID_PLAYER));
 368
 369     if(!receiver && !rc_account)                            // sender not exist
 370     {
 371         mi->deleteIncludedItems(true);
 372         return;
 373     }
 374
 375     // prepare mail and send in other case
 376     bool needItemDelay = false;
 377
 378     if(mi && !mi->empty())
 379     {
 380         // if item send to character at another account, then apply item delivery delay
 381         needItemDelay = sender_acc != rc_account;
 382
 383         // set owner to new receiver (to prevent delete item with sender char deleting)
 384         CharacterDatabase.BeginTransaction();
 385         for(MailItemMap::iterator mailItemIter = mi->begin(); mailItemIter != mi->end(); ++mailItemIter)
 386         {
 387             MailItem& mailItem = mailItemIter->second;
 388             mailItem.item->SaveToDB();                  // item not in inventory and can be save standalone
 389             // owner in data will set at mail receive and item extracting
 390             CharacterDatabase.PExecute("UPDATE item_instance SET owner_guid = '%u' WHERE guid='%u'", receiver_guid, mailItem.item->GetGUIDLow());
 391         }
 392         CharacterDatabase.CommitTransaction();
 393     }
 394
 395     // If theres is an item, there is a one hour delivery delay.
 396     uint32 deliver_delay = needItemDelay ? sWorld.getConfig(CONFIG_MAIL_DELIVERY_DELAY) : 0;
 397
 398     // will delete item or place to receiver mail list
 399     WorldSession::SendMailTo(receiver, MAIL_NORMAL, MAIL_STATIONERY_NORMAL, sender_guid, receiver_guid, subject, itemTextId, mi, money, 0, MAIL_CHECK_MASK_RETURNED,deliver_delay,mailTemplateId);
 400 }
 401
 402 //called when player takes item attached in mail
 403 void WorldSession::HandleTakeItem(WorldPacket & recv_data )
 404 {
 405     CHECK_PACKET_SIZE(recv_data,8+4+4);
 406
 407     uint64 mailbox;
 408     uint32 mailId;
 409     uint32 itemId;
 410     recv_data >> mailbox;
 411     recv_data >> mailId;
 412     recv_data >> itemId;                                    // item guid low?
 413     Player* pl = _player;
 414
 415     Mail* m = pl->GetMail(mailId);
 416     if(!m || m->state == MAIL_STATE_DELETED || m->deliver_time > time(NULL))
 417     {
 418         pl->SendMailResult(mailId, MAIL_ITEM_TAKEN, MAIL_ERR_INTERNAL_ERROR);
 419         return;
 420     }
 421
 422     // prevent cheating with skip client money check
 423     if(pl->GetMoney() < m->COD)
 424     {
 425         pl->SendMailResult(mailId, MAIL_ITEM_TAKEN, MAIL_ERR_NOT_ENOUGH_MONEY);
 426         return;
 427     }
 428
 429     Item *it = pl->GetMItem(itemId);
 430
 431     ItemPosCountVec dest;
 432     uint8 msg = _player->CanStoreItem( NULL_BAG, NULL_SLOT, dest, it, false );
 433     if( msg == EQUIP_ERR_OK )
 434     {
 435         m->RemoveItem(itemId);
 436         m->removedItems.push_back(itemId);
 437
 438         if (m->COD > 0)                                     //if there is COD, take COD money from player and send them to sender by mail
 439         {
 440             uint64 sender_guid = MAKE_NEW_GUID(m->sender, 0, HIGHGUID_PLAYER);
 441             Player *receive = objmgr.GetPlayer(sender_guid);
 442
 443             uint32 sender_accId = 0;
 444
 445             if( GetSecurity() > SEC_PLAYER && sWorld.getConfig(CONFIG_GM_LOG_TRADE) )
 446             {
 447                 std::string sender_name;
 448                 if(receive)
 449                 {
 450                     sender_accId = receive->GetSession()->GetAccountId();
 451                     sender_name = receive->GetName();
 452                 }
 453                 else
 454                 {
 455                     // can be calculated early
 456                     sender_accId = objmgr.GetPlayerAccountIdByGUID(sender_guid);
 457
 458                     if(!objmgr.GetPlayerNameByGUID(sender_guid,sender_name))
 459                         sender_name = objmgr.GetMangosStringForDBCLocale(LANG_UNKNOWN);
 460                 }
 461                 sLog.outCommand(GetAccountId(),"GM %s (Account: %u) receive mail item: %s (Entry: %u Count: %u) and send COD money: %u to player: %s (Account: %u)",
 462                     GetPlayerName(),GetAccountId(),it->GetProto()->Name1,it->GetEntry(),it->GetCount(),m->COD,sender_name.c_str(),sender_accId);
 463             }
 464             else if(!receive)
 465                 sender_accId = objmgr.GetPlayerAccountIdByGUID(sender_guid);
 466
 467             // check player existence
 468             if(receive || sender_accId)
 469             {
 470                 WorldSession::SendMailTo(receive, MAIL_NORMAL, MAIL_STATIONERY_NORMAL, m->receiver, m->sender, m->subject, 0, NULL, m->COD, 0, MAIL_CHECK_MASK_COD_PAYMENT);
 471             }
 472
 473             pl->ModifyMoney( -int32(m->COD) );
 474         }
 475         m->COD = 0;
 476         m->state = MAIL_STATE_CHANGED;
 477         pl->m_mailsUpdated = true;
 478         pl->RemoveMItem(it->GetGUIDLow());
 479
 480         uint32 count = it->GetCount();                      // save counts before store and possible merge with deleting
 481         pl->MoveItemToInventory(dest,it,true);
 482
 483         CharacterDatabase.BeginTransaction();
 484         pl->SaveInventoryAndGoldToDB();
 485         pl->_SaveMail();
 486         CharacterDatabase.CommitTransaction();
 487
 488         pl->SendMailResult(mailId, MAIL_ITEM_TAKEN, MAIL_OK, 0, itemId, count);
 489     }
 490     else
 491         pl->SendMailResult(mailId, MAIL_ITEM_TAKEN, MAIL_ERR_BAG_FULL, msg);
 492 }
 493
 494 void WorldSession::HandleTakeMoney(WorldPacket & recv_data )
 495 {
 496     CHECK_PACKET_SIZE(recv_data,8+4);
 497
 498     uint64 mailbox;
 499     uint32 mailId;
 500     recv_data >> mailbox;
 501     recv_data >> mailId;
 502     Player *pl = _player;
 503
 504     Mail* m = pl->GetMail(mailId);
 505     if(!m || m->state == MAIL_STATE_DELETED || m->deliver_time > time(NULL))
 506     {
 507         pl->SendMailResult(mailId, MAIL_MONEY_TAKEN, MAIL_ERR_INTERNAL_ERROR);
 508         return;
 509     }
 510
 511     pl->SendMailResult(mailId, MAIL_MONEY_TAKEN, 0);
 512
 513     pl->ModifyMoney(m->money);
 514     m->money = 0;
 515     m->state = MAIL_STATE_CHANGED;
 516     pl->m_mailsUpdated = true;
 517
 518     // save money and mail to prevent cheating
 519     CharacterDatabase.BeginTransaction();
 520     pl->SaveDataFieldToDB();                                // contains money
 521     pl->_SaveMail();
 522     CharacterDatabase.CommitTransaction();
 523 }
 524
 525 //called when player lists his received mails
 526 void WorldSession::HandleGetMail(WorldPacket & recv_data )
 527 {
 528     CHECK_PACKET_SIZE(recv_data,8);
 529
 530     uint64 mailbox;
 531     recv_data >> mailbox;
 532
 533     //GameObject* obj = ObjectAccessor::GetGameObject(_player, mailbox);
 534     //if(!obj || !obj->IsMailBox())
 535     //    return;
 536
 537     Player* pl = _player;
 538
 539     //load players mails, and mailed items
 540     if(!pl->m_mailsLoaded)
 541         pl ->_LoadMail();
 542
 543     // client can't work with packets > max int16 value
 544     const uint32 maxPacketSize = 32767;
 545
 546     uint32 mails_count = 0;                                 // real send to client mails amount
 547
 548     WorldPacket data(SMSG_MAIL_LIST_RESULT, (200));         // guess size
 549     data << uint8(0);                                       // mail's count
 550     time_t cur_time = time(NULL);
 551
 552     for(PlayerMails::iterator itr = pl->GetmailBegin(); itr != pl->GetmailEnd(); ++itr)
 553     {
 554         // skip deleted or not delivered (deliver delay not expired) mails
 555         if ((*itr)->state == MAIL_STATE_DELETED || cur_time < (*itr)->deliver_time)
 556             continue;
 557
 558         uint8 item_count = (*itr)->items.size();            // max count is MAX_MAIL_ITEMS (12)
 559
 560         size_t next_mail_size = 2+4+1+8+4*8+((*itr)->subject.size()+1)+1+item_count*(1+4+4+6*3*4+4+4+1+4+4+4);
 561
 562         if(data.wpos()+next_mail_size > maxPacketSize)
 563             break;
 564
 565         data << (uint16) 0x0040;                            // unknown 2.3.0, different values
 566         data << (uint32) (*itr)->messageID;                 // Message ID
 567         data << (uint8) (*itr)->messageType;                // Message Type
 568
 569         switch((*itr)->messageType)
 570         {
 571             case MAIL_NORMAL:                               // sender guid
 572                 data << uint64(MAKE_NEW_GUID((*itr)->sender, 0, HIGHGUID_PLAYER));
 573                 break;
 574             case MAIL_CREATURE:
 575             case MAIL_GAMEOBJECT:
 576             case MAIL_AUCTION:
 577                 data << (uint32) (*itr)->sender;            // creature/gameobject entry, auction id
 578                 break;
 579             case MAIL_ITEM:                                 // item entry (?) sender = "Unknown", NYI
 580                 break;
 581         }
 582
 583         data << (uint32) (*itr)->COD;                       // COD
 584         data << (uint32) (*itr)->itemTextId;                // sure about this
 585         data << (uint32) 0;                                 // unknown
 586         data << (uint32) (*itr)->stationery;                // stationery (Stationery.dbc)
 587         data << (uint32) (*itr)->money;                     // Gold
 588         data << (uint32) 0x04;                              // unknown, 0x4 - auction, 0x10 - normal
 589                                                             // Time
 590         data << (float)  ((*itr)->expire_time-time(NULL))/DAY;
 591         data << (uint32) (*itr)->mailTemplateId;            // mail template (MailTemplate.dbc)
 592         data << (*itr)->subject;                            // Subject string - once 00, when mail type = 3
 593
 594         data << (uint8) item_count;                         // client limit is 0x10
 595
 596         for(uint8 i = 0; i < item_count; ++i)
 597         {
 598             Item *item = pl->GetMItem((*itr)->items[i].item_guid);
 599             // item index (0-6?)
 600             data << (uint8)  i;
 601             // item guid low?
 602             data << (uint32) (item ? item->GetGUIDLow() : 0);
 603             // entry
 604             data << (uint32) (item ? item->GetEntry() : 0);
 605             for(uint8 j = 0; j < MAX_INSPECTED_ENCHANTMENT_SLOT; ++j)
 606             {
 607                 // unsure
 608                 data << (uint32) (item ? item->GetEnchantmentCharges((EnchantmentSlot)j) : 0);
 609                 // unsure
 610                 data << (uint32) (item ? item->GetEnchantmentDuration((EnchantmentSlot)j) : 0);
 611                 // unsure
 612                 data << (uint32) (item ? item->GetEnchantmentId((EnchantmentSlot)j) : 0);
 613             }
 614             // can be negative
 615             data << (uint32) (item ? item->GetItemRandomPropertyId() : 0);
 616             // unk
 617             data << (uint32) (item ? item->GetItemSuffixFactor() : 0);
 618             // stack count
 619             data << (uint32) (item ? item->GetCount() : 0);
 620             // charges
 621             data << (uint32) (item ? item->GetSpellCharges() : 0);
 622             // durability
 623             data << (uint32) (item ? item->GetUInt32Value(ITEM_FIELD_MAXDURABILITY) : 0);
 624             // durability
 625             data << (uint32) (item ? item->GetUInt32Value(ITEM_FIELD_DURABILITY) : 0);
 626             // unknown wotlk
 627             data << (uint8)  0;
 628         }
 629
 630         mails_count += 1;
 631     }
 632
 633     data.put<uint8>(0, mails_count);                        // set real send mails to client
 634     SendPacket(&data);
 635
 636     // recalculate m_nextMailDelivereTime and unReadMails
 637     _player->UpdateNextMailTimeAndUnreads();
 638 }
 639
 640 ///this function is called when client needs mail message body, or when player clicks on item which has ITEM_FIELD_ITEM_TEXT_ID > 0
 641 void WorldSession::HandleItemTextQuery(WorldPacket & recv_data )
 642 {
 643     CHECK_PACKET_SIZE(recv_data,4+4+4);
 644
 645     uint32 itemTextId;
 646     uint32 mailId;                                          //this value can be item id in bag, but it is also mail id
 647     uint32 unk;                                             //maybe something like state - 0x70000000
 648
 649     recv_data >> itemTextId >> mailId >> unk;
 650
 651     //some check needed, if player has item with guid mailId, or has mail with id mailId
 652
 653     sLog.outDebug("CMSG_ITEM_TEXT_QUERY itemguid: %u, mailId: %u, unk: %u", itemTextId, mailId, unk);
 654
 655     WorldPacket data(SMSG_ITEM_TEXT_QUERY_RESPONSE, (4+10));// guess size
 656     data << itemTextId;
 657     data << objmgr.GetItemText( itemTextId );
 658     SendPacket(&data);
 659 }
 660
 661 //used when player copies mail body to his inventory
 662 void WorldSession::HandleMailCreateTextItem(WorldPacket & recv_data )
 663 {
 664     CHECK_PACKET_SIZE(recv_data,8+4);
 665
 666     uint64 mailbox;
 667     uint32 mailId;
 668
 669     recv_data >> mailbox >> mailId;
 670
 671     Player *pl = _player;
 672
 673     Mail* m = pl->GetMail(mailId);
 674     if(!m || !m->itemTextId || m->state == MAIL_STATE_DELETED || m->deliver_time > time(NULL))
 675     {
 676         pl->SendMailResult(mailId, MAIL_MADE_PERMANENT, MAIL_ERR_INTERNAL_ERROR);
 677         return;
 678     }
 679
 680     Item *bodyItem = new Item;                              // This is not bag and then can be used new Item.
 681     if(!bodyItem->Create(objmgr.GenerateLowGuid(HIGHGUID_ITEM), MAIL_BODY_ITEM_TEMPLATE, pl))
 682     {
 683         delete bodyItem;
 684         return;
 685     }
 686
 687     bodyItem->SetUInt32Value( ITEM_FIELD_ITEM_TEXT_ID , m->itemTextId );
 688     bodyItem->SetUInt32Value( ITEM_FIELD_CREATOR, m->sender);
 689
 690     sLog.outDetail("HandleMailCreateTextItem mailid=%u",mailId);
 691
 692     ItemPosCountVec dest;
 693     uint8 msg = _player->CanStoreItem( NULL_BAG, NULL_SLOT, dest, bodyItem, false );
 694     if( msg == EQUIP_ERR_OK )
 695     {
 696         m->itemTextId = 0;
 697         m->state = MAIL_STATE_CHANGED;
 698         pl->m_mailsUpdated = true;
 699
 700         pl->StoreItem(dest, bodyItem, true);
 701         //bodyItem->SetState(ITEM_NEW, pl); is set automatically
 702         pl->SendMailResult(mailId, MAIL_MADE_PERMANENT, 0);
 703     }
 704     else
 705     {
 706         pl->SendMailResult(mailId, MAIL_MADE_PERMANENT, MAIL_ERR_BAG_FULL, msg);
 707         delete bodyItem;
 708     }
 709 }
 710
 711 //TODO Fix me! ... this void has probably bad condition, but good data are sent
 712 void WorldSession::HandleMsgQueryNextMailtime(WorldPacket & /*recv_data*/ )
 713 {
 714     WorldPacket data(MSG_QUERY_NEXT_MAIL_TIME, 8);
 715
 716     if(!_player->m_mailsLoaded)
 717         _player->_LoadMail();
 718
 719     if( _player->unReadMails > 0 )
 720     {
 721         data << (uint32) 0;                                 // float
 722         data << (uint32) 0;                                 // count
 723         uint32 count = 0;
 724         for(PlayerMails::iterator itr = _player->GetmailBegin(); itr != _player->GetmailEnd(); ++itr)
 725         {
 726             Mail *m = (*itr);
 727             // not checked yet, already must be delivered
 728             if((m->checked & MAIL_CHECK_MASK_READ)==0 && (m->deliver_time <= time(NULL)))
 729             {
 730                 ++count;
 731
 732                 if(count > 2)
 733                 {
 734                     count = 2;
 735                     break;
 736                 }
 737
 738                 data << (uint64) m->sender;                 // sender guid
 739
 740                 switch(m->messageType)
 741                 {
 742                     case MAIL_AUCTION:
 743                         data << (uint32) 2;
 744                         data << (uint32) 2;
 745                         data << (uint32) m->stationery;
 746                         break;
 747                     default:
 748                         data << (uint32) 0;
 749                         data << (uint32) 0;
 750                         data << (uint32) m->stationery;
 751                         break;
 752                 }
 753                 data << (uint32) 0xC6000000;                // float unk, time or something
 754             }
 755         }
 756         data.put<uint32>(4, count);
 757     }
 758     else
 759     {
 760         data << (uint32) 0xC7A8C000;
 761         data << (uint32) 0x00000000;
 762     }
 763     SendPacket(&data);
 764 }
 765
 766 void WorldSession::SendMailTo(Player* receiver, uint8 messageType, uint8 stationery, uint32 sender_guidlow_or_entry, uint32 receiver_guidlow, std::string subject, uint32 itemTextId, MailItemsInfo* mi, uint32 money, uint32 COD, uint32 checked, uint32 deliver_delay, uint16 mailTemplateId)
 767 {
 768     uint32 mailId = objmgr.GenerateMailID();
 769
 770     time_t deliver_time = time(NULL) + deliver_delay;
 771
 772     //expire time if COD 3 days, if no COD 30 days, if auction sale pending 1 hour
 773     uint32 expire_delay;
 774     if(messageType == MAIL_AUCTION && !mi && !money)        // auction mail without any items and money
 775         expire_delay = HOUR;
 776     else
 777         expire_delay = (COD > 0) ? 3*DAY : 30*DAY;
 778
 779     time_t expire_time = deliver_time + expire_delay;
 780
 781     if(mailTemplateId && !sMailTemplateStore.LookupEntry(mailTemplateId))
 782     {
 783         sLog.outError( "WorldSession::SendMailTo - Mail have not existed MailTemplateId (%u), remove at send", mailTemplateId);
 784         mailTemplateId = 0;
 785     }
 786
 787     if(receiver)
 788     {
 789         receiver->AddNewMailDeliverTime(deliver_time);
 790
 791         if ( receiver->IsMailsLoaded() )
 792         {
 793             Mail * m = new Mail;
 794             m->messageID = mailId;
 795             m->messageType = messageType;
 796             m->stationery = stationery;
 797             m->mailTemplateId = mailTemplateId;
 798             m->sender = sender_guidlow_or_entry;
 799             m->receiver = receiver->GetGUIDLow();
 800             m->subject = subject;
 801             m->itemTextId = itemTextId;
 802
 803             if(mi)
 804                 m->AddAllItems(*mi);
 805
 806             m->expire_time = expire_time;
 807             m->deliver_time = deliver_time;
 808             m->money = money;
 809             m->COD = COD;
 810             m->checked = checked;
 811             m->state = MAIL_STATE_UNCHANGED;
 812
 813             receiver->AddMail(m);                           //to insert new mail to beginning of maillist
 814
 815             if(mi)
 816             {
 817                 for(MailItemMap::iterator mailItemIter = mi->begin(); mailItemIter != mi->end(); ++mailItemIter)
 818                 {
 819                     MailItem& mailItem = mailItemIter->second;
 820                     if(mailItem.item)
 821                         receiver->AddMItem(mailItem.item);
 822                 }
 823             }
 824         }
 825         else if(mi)
 826             mi->deleteIncludedItems();
 827     }
 828     else if(mi)
 829         mi->deleteIncludedItems();
 830
 831     CharacterDatabase.BeginTransaction();
 832     CharacterDatabase.escape_string(subject);
 833     CharacterDatabase.PExecute("INSERT INTO mail (id,messageType,stationery,mailTemplateId,sender,receiver,subject,itemTextId,has_items,expire_time,deliver_time,money,cod,checked) "
 834         "VALUES ('%u', '%u', '%u', '%u', '%u', '%u', '%s', '%u', '%u', '" I64FMTD "','" I64FMTD "', '%u', '%u', '%d')",
 835         mailId, messageType, stationery, mailTemplateId, sender_guidlow_or_entry, receiver_guidlow, subject.c_str(), itemTextId, (mi && !mi->empty() ? 1 : 0), (uint64)expire_time, (uint64)deliver_time, money, COD, checked);
 836
 837     if(mi)
 838     {
 839         for(MailItemMap::const_iterator mailItemIter = mi->begin(); mailItemIter != mi->end(); ++mailItemIter)
 840         {
 841             MailItem const& mailItem = mailItemIter->second;
 842             CharacterDatabase.PExecute("INSERT INTO mail_items (mail_id,item_guid,item_template,receiver) VALUES ('%u', '%u', '%u','%u')", mailId, mailItem.item_guidlow, mailItem.item_template,receiver_guidlow);
 843         }
 844     }
 845     CharacterDatabase.CommitTransaction();
 846 }