2 * Copyright (C) 2005-2008 MaNGOS <http://getmangos.com/>
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.
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.
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
20 #include "WorldPacket.h"
21 #include "WorldSession.h"
25 #include "ObjectMgr.h"
27 #include "UpdateMask.h"
30 #include "Database/DBCStores.h"
32 void MailItem::deleteItem( bool inDB
)
37 CharacterDatabase
.PExecute("DELETE FROM item_instance WHERE guid='%u'", item
->GetGUIDLow());
44 void WorldSession::HandleSendMail(WorldPacket
& recv_data
)
46 CHECK_PACKET_SIZE(recv_data
,8+1+1+1+4+4+1+4+4+8+1);
49 std::string receiver
, subject
, body
;
50 uint32 unk1
, unk2
, money
, COD
;
53 recv_data
>> receiver
;
56 CHECK_PACKET_SIZE(recv_data
, 8+(receiver
.size()+1)+1+1+4+4+1+4+4+8+1);
61 CHECK_PACKET_SIZE(recv_data
, 8+(receiver
.size()+1)+(subject
.size()+1)+1+4+4+1+4+4+8+1);
66 CHECK_PACKET_SIZE(recv_data
, 8+(receiver
.size()+1)+(subject
.size()+1)+(body
.size()+1)+4+4+1+4+4+8+1);
68 recv_data
>> unk1
; // stationery?
69 recv_data
>> unk2
; // 0x00000000
74 recv_data
>> items_count
; // attached items count
76 if(items_count
> 12) // client limit
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);
84 for(uint8 i
= 0; i
< items_count
; ++i
)
88 recv_data
>> item_slot
;
89 recv_data
>> item_guid
;
90 mi
.AddItem(GUID_LOPART(item_guid
), item_slot
);
94 recv_data
>> money
>> COD
; // money and cod
95 recv_data
>> unk3
; // const 0
96 recv_data
>> unk4
; // const 0
98 items_count
= mi
.size(); // this is the real size after the duplicates have been removed
100 if (receiver
.empty())
103 Player
* pl
= _player
;
106 if(normalizePlayerName(receiver
))
107 rc
= objmgr
.GetPlayerGUIDByName(receiver
);
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
);
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
);
119 if(pl
->GetGUID() == rc
)
121 pl
->SendMailResult(0, 0, MAIL_ERR_CANNOT_SEND_TO_SELF
);
125 uint32 reqmoney
= money
+ 30;
127 reqmoney
= money
+ (30 * items_count
);
129 if (pl
->GetMoney() < reqmoney
)
131 pl
->SendMailResult(0, 0, MAIL_ERR_NOT_ENOUGH_MONEY
);
135 Player
*receive
= objmgr
.GetPlayer(rc
);
138 uint8 mails_count
= 0; //do not allow to send to one player more than 100 mails
142 rc_team
= receive
->GetTeam();
143 mails_count
= receive
->GetMailSize();
147 rc_team
= objmgr
.GetPlayerTeamByGUID(rc
);
148 QueryResult
* result
= CharacterDatabase
.PQuery("SELECT COUNT(*) FROM mail WHERE receiver = '%u'", GUID_LOPART(rc
));
151 Field
*fields
= result
->Fetch();
152 mails_count
= fields
[0].GetUInt32();
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)
159 pl
->SendMailResult(0, 0, MAIL_ERR_INTERNAL_ERROR
);
162 // test the receiver's Faction...
163 if (!sWorld
.getConfig(CONFIG_ALLOW_TWO_SIDE_INTERACTION_MAIL
) && pl
->GetTeam() != rc_team
&& GetSecurity() == SEC_PLAYER
)
165 pl
->SendMailResult(0, 0, MAIL_ERR_NOT_YOUR_TEAM
);
171 for(MailItemMap::iterator mailItemIter
= mi
.begin(); mailItemIter
!= mi
.end(); ++mailItemIter
)
173 MailItem
& mailItem
= mailItemIter
->second
;
175 if(!mailItem
.item_guidlow
)
177 pl
->SendMailResult(0, 0, MAIL_ERR_INTERNAL_ERROR
);
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())
185 pl
->SendMailResult(0, 0, MAIL_ERR_INTERNAL_ERROR
);
188 if (mailItem
.item
->HasFlag(ITEM_FIELD_FLAGS
, ITEM_FLAGS_CONJURED
) || mailItem
.item
->GetUInt32Value(ITEM_FIELD_DURATION
))
190 pl
->SendMailResult(0, 0, MAIL_ERR_INTERNAL_ERROR
);
195 pl
->SendMailResult(0, 0, MAIL_OK
);
197 uint32 itemTextId
= 0;
200 itemTextId
= objmgr
.CreateItemText( body
);
203 pl
->ModifyMoney( -int32(reqmoney
) );
205 bool needItemDelay
= false;
207 if(items_count
> 0 || money
> 0)
209 uint32 rc_account
= 0;
211 rc_account
= receive
->GetSession()->GetAccountId();
213 rc_account
= objmgr
.GetPlayerAccountIdByGUID(rc
);
217 for(MailItemMap::iterator mailItemIter
= mi
.begin(); mailItemIter
!= mi
.end(); ++mailItemIter
)
219 MailItem
& mailItem
= mailItemIter
->second
;
223 mailItem
.item_template
= mailItem
.item
? mailItem
.item
->GetEntry() : 0;
225 if( GetSecurity() > SEC_PLAYER
&& sWorld
.getConfig(CONFIG_GM_LOG_TRADE
) )
227 sLog
.outCommand("GM %s (Account: %u) mail item: %s (Entry: %u Count: %u) to player: %s (Account: %u)",
228 GetPlayerName(), GetAccountId(), mailItem
.item
->GetProto()->Name1
, mailItem
.item
->GetEntry(), mailItem
.item
->GetCount(), receiver
.c_str(), rc_account
);
231 pl
->MoveItemFromInventory(mailItem
.item
->GetBagSlot(), mailItem
.item
->GetSlot(), true);
232 CharacterDatabase
.BeginTransaction();
233 mailItem
.item
->DeleteFromInventoryDB(); //deletes item from character's inventory
234 mailItem
.item
->SaveToDB(); // recursive and not have transaction guard into self, item not in inventory and can be save standalone
235 // owner in data will set at mail receive and item extracting
236 CharacterDatabase
.PExecute("UPDATE item_instance SET owner_guid = '%u' WHERE guid='%u'", GUID_LOPART(rc
), mailItem
.item
->GetGUIDLow());
237 CharacterDatabase
.CommitTransaction();
240 // if item send to character at another account, then apply item delivery delay
241 needItemDelay
= pl
->GetSession()->GetAccountId() != rc_account
;
244 if(money
> 0 && GetSecurity() > SEC_PLAYER
&& sWorld
.getConfig(CONFIG_GM_LOG_TRADE
))
246 sLog
.outCommand("GM %s (Account: %u) mail money: %u to player: %s (Account: %u)",
247 GetPlayerName(), GetAccountId(), money
, receiver
.c_str(), rc_account
);
251 // If theres is an item, there is a one hour delivery delay if sent to another account's character.
252 uint32 deliver_delay
= needItemDelay
? sWorld
.getConfig(CONFIG_MAIL_DELIVERY_DELAY
) : 0;
254 // will delete item or place to receiver mail list
255 WorldSession::SendMailTo(receive
, MAIL_NORMAL
, MAIL_STATIONERY_NORMAL
, pl
->GetGUIDLow(), GUID_LOPART(rc
), subject
, itemTextId
, &mi
, money
, COD
, MAIL_CHECK_MASK_NONE
, deliver_delay
);
257 CharacterDatabase
.BeginTransaction();
258 pl
->SaveInventoryAndGoldToDB();
259 CharacterDatabase
.CommitTransaction();
262 //called when mail is read
263 void WorldSession::HandleMarkAsRead(WorldPacket
& recv_data
)
265 CHECK_PACKET_SIZE(recv_data
,8+4);
269 recv_data
>> mailbox
;
271 Player
*pl
= _player
;
272 Mail
*m
= pl
->GetMail(mailId
);
277 m
->checked
= m
->checked
| MAIL_CHECK_MASK_READ
;
278 // m->expire_time = time(NULL) + (30 * DAY); // Expire time do not change at reading mail
279 pl
->m_mailsUpdated
= true;
280 m
->state
= MAIL_STATE_CHANGED
;
284 //called when client deletes mail
285 void WorldSession::HandleMailDelete(WorldPacket
& recv_data
)
287 CHECK_PACKET_SIZE(recv_data
,8+4);
291 recv_data
>> mailbox
;
293 Player
* pl
= _player
;
294 pl
->m_mailsUpdated
= true;
295 Mail
*m
= pl
->GetMail(mailId
);
297 m
->state
= MAIL_STATE_DELETED
;
298 pl
->SendMailResult(mailId
, MAIL_DELETED
, 0);
301 void WorldSession::HandleReturnToSender(WorldPacket
& recv_data
)
303 CHECK_PACKET_SIZE(recv_data
,8+4);
307 recv_data
>> mailbox
;
309 Player
*pl
= _player
;
310 Mail
*m
= pl
->GetMail(mailId
);
311 if(!m
|| m
->state
== MAIL_STATE_DELETED
|| m
->deliver_time
> time(NULL
))
313 pl
->SendMailResult(mailId
, MAIL_RETURNED_TO_SENDER
, MAIL_ERR_INTERNAL_ERROR
);
316 //we can return mail now
317 //so firstly delete the old one
318 CharacterDatabase
.BeginTransaction();
319 CharacterDatabase
.PExecute("DELETE FROM mail WHERE id = '%u'", mailId
);
321 CharacterDatabase
.PExecute("DELETE FROM mail_items WHERE mail_id = '%u'", mailId
);
322 CharacterDatabase
.CommitTransaction();
323 pl
->RemoveMail(mailId
);
329 for(std::vector
<MailItemInfo
>::iterator itr2
= m
->items
.begin(); itr2
!= m
->items
.end(); ++itr2
)
331 Item
*item
= pl
->GetMItem(itr2
->item_guid
);
333 mi
.AddItem(item
->GetGUIDLow(), item
->GetEntry(), item
);
339 pl
->RemoveMItem(itr2
->item_guid
);
343 SendReturnToSender(MAIL_NORMAL
, GetAccountId(), m
->receiver
, m
->sender
, m
->subject
, m
->itemTextId
, &mi
, m
->money
, 0, m
->mailTemplateId
);
345 delete m
; //we can deallocate old mail
346 pl
->SendMailResult(mailId
, MAIL_RETURNED_TO_SENDER
, 0);
349 void WorldSession::SendReturnToSender(uint8 messageType
, uint32 sender_acc
, uint32 sender_guid
, uint32 receiver_guid
, std::string subject
, uint32 itemTextId
, MailItemsInfo
*mi
, uint32 money
, uint32 COD
, uint16 mailTemplateId
)
351 if(messageType
!= MAIL_NORMAL
) // return only to players
353 mi
->deleteIncludedItems(true);
357 Player
*receiver
= objmgr
.GetPlayer(MAKE_NEW_GUID(receiver_guid
, 0, HIGHGUID_PLAYER
));
359 uint32 rc_account
= 0;
361 rc_account
= objmgr
.GetPlayerAccountIdByGUID(MAKE_NEW_GUID(receiver_guid
, 0, HIGHGUID_PLAYER
));
363 if(!receiver
&& !rc_account
) // sender not exist
365 mi
->deleteIncludedItems(true);
369 // preper mail and send in other case
370 bool needItemDelay
= false;
372 if(mi
&& !mi
->empty())
374 // if item send to character at another account, then apply item delivery delay
375 needItemDelay
= sender_acc
!= rc_account
;
377 // set owner to new receiver (to prevent delete item with sender char deleting)
378 CharacterDatabase
.BeginTransaction();
379 for(MailItemMap::iterator mailItemIter
= mi
->begin(); mailItemIter
!= mi
->end(); ++mailItemIter
)
381 MailItem
& mailItem
= mailItemIter
->second
;
382 mailItem
.item
->SaveToDB(); // item not in inventory and can be save standalone
383 // owner in data will set at mail receive and item extracting
384 CharacterDatabase
.PExecute("UPDATE item_instance SET owner_guid = '%u' WHERE guid='%u'", receiver_guid
, mailItem
.item
->GetGUIDLow());
386 CharacterDatabase
.CommitTransaction();
389 // If theres is an item, there is a one hour delivery delay.
390 uint32 deliver_delay
= needItemDelay
? sWorld
.getConfig(CONFIG_MAIL_DELIVERY_DELAY
) : 0;
392 // will delete item or place to receiver mail list
393 WorldSession::SendMailTo(receiver
, MAIL_NORMAL
, MAIL_STATIONERY_NORMAL
, sender_guid
, receiver_guid
, subject
, itemTextId
, mi
, money
, 0, MAIL_CHECK_MASK_RETURNED
,deliver_delay
,mailTemplateId
);
396 //called when player takes item attached in mail
397 void WorldSession::HandleTakeItem(WorldPacket
& recv_data
)
399 CHECK_PACKET_SIZE(recv_data
,8+4+4);
404 recv_data
>> mailbox
;
406 recv_data
>> itemId
; // item guid low?
407 Player
* pl
= _player
;
409 Mail
* m
= pl
->GetMail(mailId
);
410 if(!m
|| m
->state
== MAIL_STATE_DELETED
|| m
->deliver_time
> time(NULL
))
412 pl
->SendMailResult(mailId
, MAIL_ITEM_TAKEN
, MAIL_ERR_INTERNAL_ERROR
);
416 // prevent cheating with skip client money check
417 if(pl
->GetMoney() < m
->COD
)
419 pl
->SendMailResult(mailId
, MAIL_ITEM_TAKEN
, MAIL_ERR_NOT_ENOUGH_MONEY
);
423 Item
*it
= pl
->GetMItem(itemId
);
425 ItemPosCountVec dest
;
426 uint8 msg
= _player
->CanStoreItem( NULL_BAG
, NULL_SLOT
, dest
, it
, false );
427 if( msg
== EQUIP_ERR_OK
)
429 m
->RemoveItem(itemId
);
430 m
->removedItems
.push_back(itemId
);
432 if (m
->COD
> 0) //if there is COD, take COD money from player and send them to sender by mail
434 uint64 sender_guid
= MAKE_NEW_GUID(m
->sender
, 0, HIGHGUID_PLAYER
);
435 Player
*receive
= objmgr
.GetPlayer(sender_guid
);
437 uint32 sender_accId
= 0;
439 if( GetSecurity() > SEC_PLAYER
&& sWorld
.getConfig(CONFIG_GM_LOG_TRADE
) )
441 std::string sender_name
;
444 sender_accId
= receive
->GetSession()->GetAccountId();
445 sender_name
= receive
->GetName();
449 // can be calculated early
450 sender_accId
= objmgr
.GetPlayerAccountIdByGUID(sender_guid
);
452 if(!objmgr
.GetPlayerNameByGUID(sender_guid
,sender_name
))
453 sender_name
= objmgr
.GetMangosStringForDBCLocale(LANG_UNKNOWN
);
455 sLog
.outCommand("GM %s (Account: %u) receive mail item: %s (Entry: %u Count: %u) and send COD money: %u to player: %s (Account: %u)",
456 GetPlayerName(),GetAccountId(),it
->GetProto()->Name1
,it
->GetEntry(),it
->GetCount(),m
->COD
,sender_name
.c_str(),sender_accId
);
459 sender_accId
= objmgr
.GetPlayerAccountIdByGUID(sender_guid
);
461 // check player existanse
462 if(receive
|| sender_accId
)
464 WorldSession::SendMailTo(receive
, MAIL_NORMAL
, MAIL_STATIONERY_NORMAL
, m
->receiver
, m
->sender
, m
->subject
, 0, NULL
, m
->COD
, 0, MAIL_CHECK_MASK_COD_PAYMENT
);
467 pl
->ModifyMoney( -int32(m
->COD
) );
470 m
->state
= MAIL_STATE_CHANGED
;
471 pl
->m_mailsUpdated
= true;
472 pl
->RemoveMItem(it
->GetGUIDLow());
474 uint32 count
= it
->GetCount(); // save counts before store and possible merge with deleting
475 pl
->MoveItemToInventory(dest
,it
,true);
477 CharacterDatabase
.BeginTransaction();
478 pl
->SaveInventoryAndGoldToDB();
480 CharacterDatabase
.CommitTransaction();
482 pl
->SendMailResult(mailId
, MAIL_ITEM_TAKEN
, MAIL_OK
, 0, itemId
, count
);
485 pl
->SendMailResult(mailId
, MAIL_ITEM_TAKEN
, MAIL_ERR_BAG_FULL
, msg
);
488 void WorldSession::HandleTakeMoney(WorldPacket
& recv_data
)
490 CHECK_PACKET_SIZE(recv_data
,8+4);
494 recv_data
>> mailbox
;
496 Player
*pl
= _player
;
498 Mail
* m
= pl
->GetMail(mailId
);
499 if(!m
|| m
->state
== MAIL_STATE_DELETED
|| m
->deliver_time
> time(NULL
))
501 pl
->SendMailResult(mailId
, MAIL_MONEY_TAKEN
, MAIL_ERR_INTERNAL_ERROR
);
505 pl
->SendMailResult(mailId
, MAIL_MONEY_TAKEN
, 0);
507 pl
->ModifyMoney(m
->money
);
509 m
->state
= MAIL_STATE_CHANGED
;
510 pl
->m_mailsUpdated
= true;
512 // save money and mail to prevent cheating
513 CharacterDatabase
.BeginTransaction();
514 pl
->SetUInt32ValueInDB(PLAYER_FIELD_COINAGE
,pl
->GetMoney(),pl
->GetGUID());
516 CharacterDatabase
.CommitTransaction();
519 //called when player lists his received mails
520 void WorldSession::HandleGetMail(WorldPacket
& recv_data
)
522 CHECK_PACKET_SIZE(recv_data
,8);
525 recv_data
>> mailbox
;
527 //GameObject* obj = ObjectAccessor::GetGameObject(_player, mailbox);
528 //if(!obj || !obj->IsMailBox())
531 Player
* pl
= _player
;
533 //load players mails, and mailed items
534 if(!pl
->m_mailsLoaded
)
537 // client can't work with packets > max int16 value
538 const uint32 maxPacketSize
= 32767;
540 uint32 mails_count
= 0; // real send to client mails amount
542 WorldPacket
data(SMSG_MAIL_LIST_RESULT
, (200)); // guess size
543 data
<< uint8(0); // mail's count
544 time_t cur_time
= time(NULL
);
546 for(PlayerMails::iterator itr
= pl
->GetmailBegin(); itr
!= pl
->GetmailEnd(); ++itr
)
548 // skip deleted or not delivered (deliver delay not expired) mails
549 if ((*itr
)->state
== MAIL_STATE_DELETED
|| cur_time
< (*itr
)->deliver_time
)
552 uint8 item_count
= (*itr
)->items
.size(); // max count is MAX_MAIL_ITEMS (12)
554 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);
556 if(data
.wpos()+next_mail_size
> maxPacketSize
)
559 data
<< (uint16
) 0x0040; // unknown 2.3.0, different values
560 data
<< (uint32
) (*itr
)->messageID
; // Message ID
561 data
<< (uint8
) (*itr
)->messageType
; // Message Type
563 switch((*itr
)->messageType
)
565 case MAIL_NORMAL
: // sender guid
566 data
<< uint64(MAKE_NEW_GUID((*itr
)->sender
, 0, HIGHGUID_PLAYER
));
569 case MAIL_GAMEOBJECT
:
571 data
<< (uint32
) (*itr
)->sender
; // creature/gameobject entry, auction id
573 case MAIL_ITEM
: // item entry (?) sender = "Unknown", NYI
577 data
<< (uint32
) (*itr
)->COD
; // COD
578 data
<< (uint32
) (*itr
)->itemTextId
; // sure about this
579 data
<< (uint32
) 0; // unknown
580 data
<< (uint32
) (*itr
)->stationery
; // stationery (Stationery.dbc)
581 data
<< (uint32
) (*itr
)->money
; // Gold
582 data
<< (uint32
) 0x04; // unknown, 0x4 - auction, 0x10 - normal
584 data
<< (float) ((*itr
)->expire_time
-time(NULL
))/DAY
;
585 data
<< (uint32
) (*itr
)->mailTemplateId
; // mail template (MailTemplate.dbc)
586 data
<< (*itr
)->subject
; // Subject string - once 00, when mail type = 3
588 data
<< (uint8
) item_count
;
590 for(uint8 i
= 0; i
< item_count
; ++i
)
592 Item
*item
= pl
->GetMItem((*itr
)->items
[i
].item_guid
);
596 data
<< (uint32
) (item
? item
->GetGUIDLow() : 0);
598 data
<< (uint32
) (item
? item
->GetEntry() : 0);
599 for(uint8 j
= 0; j
< 6; ++j
)
602 data
<< (uint32
) (item
? item
->GetEnchantmentCharges((EnchantmentSlot
)j
) : 0);
604 data
<< (uint32
) (item
? item
->GetEnchantmentDuration((EnchantmentSlot
)j
) : 0);
606 data
<< (uint32
) (item
? item
->GetEnchantmentId((EnchantmentSlot
)j
) : 0);
609 data
<< (uint32
) (item
? item
->GetItemRandomPropertyId() : 0);
611 data
<< (uint32
) (item
? item
->GetItemSuffixFactor() : 0);
613 data
<< (uint8
) (item
? item
->GetCount() : 0);
615 data
<< (uint32
) (item
? item
->GetSpellCharges() : 0);
617 data
<< (uint32
) (item
? item
->GetUInt32Value(ITEM_FIELD_MAXDURABILITY
) : 0);
619 data
<< (uint32
) (item
? item
->GetUInt32Value(ITEM_FIELD_DURABILITY
) : 0);
625 data
.put
<uint8
>(0, mails_count
); // set real send mails to client
628 // recalculate m_nextMailDelivereTime and unReadMails
629 _player
->UpdateNextMailTimeAndUnreads();
632 ///this function is called when client needs mail message body, or when player clicks on item which has ITEM_FIELD_ITEM_TEXT_ID > 0
633 void WorldSession::HandleItemTextQuery(WorldPacket
& recv_data
)
635 CHECK_PACKET_SIZE(recv_data
,4+4+4);
638 uint32 mailId
; //this value can be item id in bag, but it is also mail id
639 uint32 unk
; //maybe something like state - 0x70000000
641 recv_data
>> itemTextId
>> mailId
>> unk
;
643 //some check needed, if player has item with guid mailId, or has mail with id mailId
645 sLog
.outDebug("CMSG_ITEM_TEXT_QUERY itemguid: %u, mailId: %u, unk: %u", itemTextId
, mailId
, unk
);
647 WorldPacket
data(SMSG_ITEM_TEXT_QUERY_RESPONSE
, (4+10));// guess size
649 data
<< objmgr
.GetItemText( itemTextId
);
653 //used when player copies mail body to his inventory
654 void WorldSession::HandleMailCreateTextItem(WorldPacket
& recv_data
)
656 CHECK_PACKET_SIZE(recv_data
,8+4);
661 recv_data
>> mailbox
>> mailId
;
663 Player
*pl
= _player
;
665 Mail
* m
= pl
->GetMail(mailId
);
666 if(!m
|| !m
->itemTextId
|| m
->state
== MAIL_STATE_DELETED
|| m
->deliver_time
> time(NULL
))
668 pl
->SendMailResult(mailId
, MAIL_MADE_PERMANENT
, MAIL_ERR_INTERNAL_ERROR
);
672 Item
*bodyItem
= new Item
; // This is not bag and then can be used new Item.
673 if(!bodyItem
->Create(objmgr
.GenerateLowGuid(HIGHGUID_ITEM
), MAIL_BODY_ITEM_TEMPLATE
, pl
))
679 bodyItem
->SetUInt32Value( ITEM_FIELD_ITEM_TEXT_ID
, m
->itemTextId
);
680 bodyItem
->SetUInt32Value( ITEM_FIELD_CREATOR
, m
->sender
);
682 sLog
.outDetail("HandleMailCreateTextItem mailid=%u",mailId
);
684 ItemPosCountVec dest
;
685 uint8 msg
= _player
->CanStoreItem( NULL_BAG
, NULL_SLOT
, dest
, bodyItem
, false );
686 if( msg
== EQUIP_ERR_OK
)
689 m
->state
= MAIL_STATE_CHANGED
;
690 pl
->m_mailsUpdated
= true;
692 pl
->StoreItem(dest
, bodyItem
, true);
693 //bodyItem->SetState(ITEM_NEW, pl); is set automatically
694 pl
->SendMailResult(mailId
, MAIL_MADE_PERMANENT
, 0);
698 pl
->SendMailResult(mailId
, MAIL_MADE_PERMANENT
, MAIL_ERR_BAG_FULL
, msg
);
703 //TODO Fix me! ... this void has probably bad condition, but good data are sent
704 void WorldSession::HandleMsgQueryNextMailtime(WorldPacket
& /*recv_data*/ )
706 WorldPacket
data(MSG_QUERY_NEXT_MAIL_TIME
, 8);
708 if(!_player
->m_mailsLoaded
)
709 _player
->_LoadMail();
711 if( _player
->unReadMails
> 0 )
713 data
<< (uint32
) 0; // float
714 data
<< (uint32
) 0; // count
716 for(PlayerMails::iterator itr
= _player
->GetmailBegin(); itr
!= _player
->GetmailEnd(); ++itr
)
719 // not checked yet, already must be delivered
720 if((m
->checked
& MAIL_CHECK_MASK_READ
)==0 && (m
->deliver_time
<= time(NULL
)))
730 data
<< (uint64
) m
->sender
; // sender guid
732 switch(m
->messageType
)
737 data
<< (uint32
) m
->stationery
;
742 data
<< (uint32
) m
->stationery
;
745 data
<< (uint32
) 0xC6000000; // float unk, time or something
748 data
.put
<uint32
>(4, count
);
752 data
<< (uint32
) 0xC7A8C000;
753 data
<< (uint32
) 0x00000000;
758 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
)
760 uint32 mailId
= objmgr
.GenerateMailID();
762 time_t deliver_time
= time(NULL
) + deliver_delay
;
764 //expire time if COD 3 days, if no COD 30 days, if auction sale pending 1 hour
766 if(messageType
== MAIL_AUCTION
&& !mi
&& !money
) // auction mail without any items and money
769 expire_delay
= (COD
> 0) ? 3*DAY
: 30*DAY
;
771 time_t expire_time
= deliver_time
+ expire_delay
;
773 if(mailTemplateId
&& !sMailTemplateStore
.LookupEntry(mailTemplateId
))
775 sLog
.outError( "WorldSession::SendMailTo - Mail have not existed MailTemplateId (%u), remove at send", mailTemplateId
);
781 receiver
->AddNewMailDeliverTime(deliver_time
);
783 if ( receiver
->IsMailsLoaded() )
786 m
->messageID
= mailId
;
787 m
->messageType
= messageType
;
788 m
->stationery
= stationery
;
789 m
->mailTemplateId
= mailTemplateId
;
790 m
->sender
= sender_guidlow_or_entry
;
791 m
->receiver
= receiver
->GetGUIDLow();
792 m
->subject
= subject
;
793 m
->itemTextId
= itemTextId
;
798 m
->expire_time
= expire_time
;
799 m
->deliver_time
= deliver_time
;
802 m
->checked
= checked
;
803 m
->state
= MAIL_STATE_UNCHANGED
;
805 receiver
->AddMail(m
); //to insert new mail to beginning of maillist
809 for(MailItemMap::iterator mailItemIter
= mi
->begin(); mailItemIter
!= mi
->end(); ++mailItemIter
)
811 MailItem
& mailItem
= mailItemIter
->second
;
813 receiver
->AddMItem(mailItem
.item
);
818 mi
->deleteIncludedItems();
821 mi
->deleteIncludedItems();
823 CharacterDatabase
.BeginTransaction();
824 CharacterDatabase
.escape_string(subject
);
825 CharacterDatabase
.PExecute("INSERT INTO mail (id,messageType,stationery,mailTemplateId,sender,receiver,subject,itemTextId,has_items,expire_time,deliver_time,money,cod,checked) "
826 "VALUES ('%u', '%u', '%u', '%u', '%u', '%u', '%s', '%u', '%u', '" I64FMTD
"','" I64FMTD
"', '%u', '%u', '%d')",
827 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
);
831 for(MailItemMap::const_iterator mailItemIter
= mi
->begin(); mailItemIter
!= mi
->end(); ++mailItemIter
)
833 MailItem
const& mailItem
= mailItemIter
->second
;
834 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
);
837 CharacterDatabase
.CommitTransaction();