src/game/AuctionHouse.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 "WorldPacket.h"
  20 #include "WorldSession.h"
  21 #include "Opcodes.h"
  22 #include "Log.h"
  23 #include "World.h"
  24 #include "ObjectMgr.h"
  25 #include "Player.h"
  26 #include "UpdateMask.h"
  27 #include "AuctionHouseObject.h"
  28 #include "Util.h"
  29
  30 //please DO NOT use iterator++, because it is slower than ++iterator!!!
  31 //post-incrementation is always slower than pre-incrementation !
  32
  33 //void called when player click on auctioneer npc
  34 void WorldSession::HandleAuctionHelloOpcode( WorldPacket & recv_data )
  35 {
  36     CHECK_PACKET_SIZE(recv_data,8);
  37
  38     uint64 guid;                                            //NPC guid
  39     recv_data >> guid;
  40
  41     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid,UNIT_NPC_FLAG_AUCTIONEER);
  42     if (!unit)
  43     {
  44         sLog.outDebug( "WORLD: HandleAuctionHelloOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
  45         return;
  46     }
  47
  48     // remove fake death
  49     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
  50         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
  51
  52     SendAuctionHello(guid, unit);
  53 }
  54
  55 static uint8 AuctioneerFactionToLocation(uint32 faction)
  56 {
  57     if(sWorld.getConfig(CONFIG_ALLOW_TWO_SIDE_INTERACTION_AUCTION))
  58         return 7;                                           // neutral
  59
  60     FactionTemplateEntry const* u_entry = sFactionTemplateStore.LookupEntry(faction);
  61     if(!u_entry)
  62         return 7;                                           // neutral
  63
  64     if(u_entry->ourMask & FACTION_MASK_ALLIANCE)
  65         return 2;
  66     else if(u_entry->ourMask & FACTION_MASK_HORDE)
  67         return 6;
  68     else
  69         return 7;
  70 }
  71
  72 //this void causes that auction window is opened
  73 void WorldSession::SendAuctionHello( uint64 guid, Creature* unit )
  74 {
  75     WorldPacket data( MSG_AUCTION_HELLO, 12 );
  76     data << (uint64) guid;
  77     data << (uint32) AuctioneerFactionToLocation(unit->getFaction());
  78     SendPacket( &data );
  79 }
  80
  81 //this function inserts to WorldPacket auction's data
  82 bool WorldSession::SendAuctionInfo(WorldPacket & data, AuctionEntry* auction)
  83 {
  84     Item *pItem = objmgr.GetAItem(auction->item_guidlow);
  85     if (!pItem)
  86     {
  87         sLog.outError("auction to item, that doesn't exist !!!!");
  88         return false;
  89     }
  90     data << (uint32) auction->Id;
  91     data << (uint32) pItem->GetEntry();
  92
  93     for (uint8 i = 0; i < MAX_INSPECTED_ENCHANTMENT_SLOT; i++)
  94     {
  95         data << (uint32) pItem->GetEnchantmentId(EnchantmentSlot(i));
  96         data << (uint32) pItem->GetEnchantmentDuration(EnchantmentSlot(i));
  97         data << (uint32) pItem->GetEnchantmentCharges(EnchantmentSlot(i));
  98     }
  99
 100     data << (uint32) pItem->GetItemRandomPropertyId();      //random item property id
 101     data << (uint32) pItem->GetItemSuffixFactor();          //SuffixFactor
 102     data << (uint32) pItem->GetCount();                     //item->count
 103     data << (uint32) pItem->GetSpellCharges();              //item->charge FFFFFFF
 104     data << (uint32) 0;                                     //Unknown
 105     data << (uint64) auction->owner;                        //Auction->owner
 106     data << (uint32) auction->startbid;                     //Auction->startbid (not sure if useful)
 107     data << (uint32) ((auction->bid)? objmgr.GetAuctionOutBid(auction->bid) : 0);
 108                                                             //minimal outbid
 109     data << (uint32) auction->buyout;                       //auction->buyout
 110     data << (uint32) (auction->time - time(NULL)) * 1000;   //time left
 111     data << (uint64) auction->bidder;                       //auction->bidder current
 112     data << (uint32) auction->bid;                          //current bid
 113     return true;
 114 }
 115
 116 //call this method when player bids, creates, or deletes auction
 117 void WorldSession::SendAuctionCommandResult(uint32 auctionId, uint32 Action, uint32 ErrorCode, uint32 bidError )
 118 {
 119     WorldPacket data( SMSG_AUCTION_COMMAND_RESULT, 16 );
 120     data << auctionId;
 121     data << Action;
 122     data << ErrorCode;
 123     if ( !ErrorCode && Action )
 124         data << bidError;                                   //when bid, then send 0, once...
 125     SendPacket(&data);
 126 }
 127
 128 //this function sends notification, if bidder is online
 129 void WorldSession::SendAuctionBidderNotification( uint32 location, uint32 auctionId, uint64 bidder, uint32 bidSum, uint32 diff, uint32 item_template)
 130 {
 131     WorldPacket data(SMSG_AUCTION_BIDDER_NOTIFICATION, (8*4));
 132     data << location;
 133     data << auctionId;
 134     data << (uint64) bidder;
 135     data << bidSum;
 136     data << (uint32) diff;
 137     data << item_template;
 138     data << (uint32) 0;
 139     SendPacket(&data);
 140 }
 141
 142 //this void causes on client to display: "Your auction sold"
 143 void WorldSession::SendAuctionOwnerNotification( AuctionEntry* auction)
 144 {
 145     WorldPacket data(SMSG_AUCTION_OWNER_NOTIFICATION, (7*4));
 146     data << auction->Id;
 147     data << auction->bid;
 148     data << (uint32) 0;                                     //unk
 149     data << (uint32) 0;                                     //unk
 150     data << (uint32) 0;                                     //unk
 151     data << auction->item_template;
 152     data << (uint32) 0;                                     //unk
 153     SendPacket(&data);
 154 }
 155
 156 //this function sends mail to old bidder
 157 void WorldSession::SendAuctionOutbiddedMail(AuctionEntry *auction, uint32 newPrice)
 158 {
 159     uint64 oldBidder_guid = MAKE_NEW_GUID(auction->bidder,0, HIGHGUID_PLAYER);
 160     Player *oldBidder = objmgr.GetPlayer(oldBidder_guid);
 161
 162     uint32 oldBidder_accId = 0;
 163     if(!oldBidder)
 164         oldBidder_accId = objmgr.GetPlayerAccountIdByGUID(oldBidder_guid);
 165
 166     // old bidder exist
 167     if(oldBidder || oldBidder_accId)
 168     {
 169         std::ostringstream msgAuctionOutbiddedSubject;
 170         msgAuctionOutbiddedSubject << auction->item_template << ":0:" << AUCTION_OUTBIDDED;
 171
 172         if (oldBidder)
 173             oldBidder->GetSession()->SendAuctionBidderNotification( auction->location, auction->Id, _player->GetGUID(), newPrice, objmgr.GetAuctionOutBid(auction->bid), auction->item_template);
 174
 175         WorldSession::SendMailTo(oldBidder, MAIL_AUCTION, MAIL_STATIONERY_AUCTION, auction->location, auction->bidder, msgAuctionOutbiddedSubject.str(), 0, NULL, auction->bid, 0, MAIL_CHECK_MASK_NONE);
 176     }
 177 }
 178
 179 //this function sends mail, when auction is cancelled to old bidder
 180 void WorldSession::SendAuctionCancelledToBidderMail( AuctionEntry* auction )
 181 {
 182     uint64 bidder_guid = MAKE_NEW_GUID(auction->bidder, 0, HIGHGUID_PLAYER);
 183     Player *bidder = objmgr.GetPlayer(bidder_guid);
 184
 185     uint32 bidder_accId = 0;
 186     if(!bidder)
 187         bidder_accId = objmgr.GetPlayerAccountIdByGUID(bidder_guid);
 188
 189     // bidder exist
 190     if(bidder || bidder_accId)
 191     {
 192         std::ostringstream msgAuctionCancelledSubject;
 193         msgAuctionCancelledSubject << auction->item_template << ":0:" << AUCTION_CANCELLED_TO_BIDDER;
 194
 195         WorldSession::SendMailTo(bidder, MAIL_AUCTION, MAIL_STATIONERY_AUCTION, auction->location, auction->bidder, msgAuctionCancelledSubject.str(), 0, NULL, auction->bid, 0, MAIL_CHECK_MASK_NONE);
 196     }
 197 }
 198
 199 //this void creates new auction and adds auction to some auctionhouse
 200 void WorldSession::HandleAuctionSellItem( WorldPacket & recv_data )
 201 {
 202     CHECK_PACKET_SIZE(recv_data,8+8+4+4+4);
 203
 204     uint64 auctioneer, item;
 205     uint32 etime, bid, buyout;
 206     recv_data >> auctioneer >> item;
 207     recv_data >> bid >> buyout >> etime;
 208     Player *pl = GetPlayer();
 209
 210     if (!item || !bid || !etime)
 211         return;                                             //check for cheaters
 212
 213     Creature *pCreature = ObjectAccessor::GetNPCIfCanInteractWith(*_player, auctioneer,UNIT_NPC_FLAG_AUCTIONEER);
 214     if (!pCreature)
 215     {
 216         sLog.outDebug( "WORLD: HandleAuctionSellItem - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(auctioneer)) );
 217         return;
 218     }
 219
 220     // client send time in minutes, convert to common used sec time
 221     etime *= MINUTE;
 222
 223     // client understand only 3 auction time
 224     switch(etime)
 225     {
 226         case 1*MIN_AUCTION_TIME:
 227         case 2*MIN_AUCTION_TIME:
 228         case 4*MIN_AUCTION_TIME:
 229             break;
 230         default:
 231             return;
 232     }
 233
 234     // remove fake death
 235     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 236         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 237
 238     Item *it = pl->GetItemByGuid( item );
 239     //do not allow to sell already auctioned items
 240     if(objmgr.GetAItem(GUID_LOPART(item)))
 241     {
 242         sLog.outError("AuctionError, player %s is sending item id: %u, but item is already in another auction", pl->GetName(), GUID_LOPART(item));
 243         SendAuctionCommandResult(0, AUCTION_SELL_ITEM, AUCTION_INTERNAL_ERROR);
 244         return;
 245     }
 246     // prevent sending bag with items (cheat: can be placed in bag after adding equiped empty bag to auction)
 247     if(!it)
 248     {
 249         SendAuctionCommandResult(0, AUCTION_SELL_ITEM, AUCTION_ITEM_NOT_FOUND);
 250         return;
 251     }
 252
 253     if(!it->CanBeTraded())
 254     {
 255         SendAuctionCommandResult(0, AUCTION_SELL_ITEM, AUCTION_INTERNAL_ERROR);
 256         return;
 257     }
 258
 259     if (it->HasFlag(ITEM_FIELD_FLAGS, ITEM_FLAGS_CONJURED) || it->GetUInt32Value(ITEM_FIELD_DURATION))
 260     {
 261         SendAuctionCommandResult(0, AUCTION_SELL_ITEM, AUCTION_INTERNAL_ERROR);
 262         return;
 263     }
 264
 265     uint32 location = AuctioneerFactionToLocation(pCreature->getFaction());
 266     AuctionHouseObject * mAuctions;
 267     mAuctions = objmgr.GetAuctionsMap( location );
 268
 269     //we have to take deposit :
 270     uint32 deposit = objmgr.GetAuctionDeposit( location, etime, it );
 271     if ( pl->GetMoney() < deposit )
 272     {
 273         SendAuctionCommandResult(0, AUCTION_SELL_ITEM, AUCTION_NOT_ENOUGHT_MONEY);
 274         return;
 275     }
 276
 277     if( GetSecurity() > SEC_PLAYER && sWorld.getConfig(CONFIG_GM_LOG_TRADE) )
 278     {
 279         sLog.outCommand(GetAccountId(),"GM %s (Account: %u) create auction: %s (Entry: %u Count: %u)",
 280             GetPlayerName(),GetAccountId(),it->GetProto()->Name1,it->GetEntry(),it->GetCount());
 281     }
 282
 283     pl->ModifyMoney( -int32(deposit) );
 284
 285     uint32 auction_time = uint32(etime * sWorld.getRate(RATE_AUCTION_TIME));
 286
 287     AuctionEntry *AH = new AuctionEntry;
 288     AH->Id = objmgr.GenerateAuctionID();
 289     AH->auctioneer = GUID_LOPART(auctioneer);
 290     AH->item_guidlow = GUID_LOPART(item);
 291     AH->item_template = it->GetEntry();
 292     AH->owner = pl->GetGUIDLow();
 293     AH->startbid = bid;
 294     AH->bidder = 0;
 295     AH->bid = 0;
 296     AH->buyout = buyout;
 297     AH->time = time(NULL) + auction_time;
 298     AH->deposit = deposit;
 299     AH->location = location;
 300
 301     sLog.outDetail("selling item %u to auctioneer %u with initial bid %u with buyout %u and with time %u (in sec) in location: %u", GUID_LOPART(item), GUID_LOPART(auctioneer), bid, buyout, auction_time, location);
 302     mAuctions->AddAuction(AH);
 303
 304     objmgr.AddAItem(it);
 305     pl->MoveItemFromInventory( it->GetBagSlot(), it->GetSlot(), true);
 306
 307     CharacterDatabase.BeginTransaction();
 308     it->DeleteFromInventoryDB();
 309     it->SaveToDB();                                         // recursive and not have transaction guard into self, not in inventiory and can be save standalone
 310     CharacterDatabase.PExecute("INSERT INTO auctionhouse (id,auctioneerguid,itemguid,item_template,itemowner,buyoutprice,time,buyguid,lastbid,startbid,deposit,location) "
 311         "VALUES ('%u', '%u', '%u', '%u', '%u', '%u', '" I64FMTD "', '%u', '%u', '%u', '%u', '%u')",
 312         AH->Id, AH->auctioneer, AH->item_guidlow, AH->item_template, AH->owner, AH->buyout, (uint64)AH->time, AH->bidder, AH->bid, AH->startbid, AH->deposit, AH->location);
 313     pl->SaveInventoryAndGoldToDB();
 314     CharacterDatabase.CommitTransaction();
 315
 316     SendAuctionCommandResult(AH->Id, AUCTION_SELL_ITEM, AUCTION_OK);
 317 }
 318
 319 //this function is called when client bids or buys out auction
 320 void WorldSession::HandleAuctionPlaceBid( WorldPacket & recv_data )
 321 {
 322     CHECK_PACKET_SIZE(recv_data,8+4+4);
 323
 324     uint64 auctioneer;
 325     uint32 auctionId;
 326     uint32 price;
 327     recv_data >> auctioneer;
 328     recv_data >> auctionId >> price;
 329
 330     if (!auctionId || !price)
 331         return;                                             //check for cheaters
 332
 333     Creature *pCreature = ObjectAccessor::GetNPCIfCanInteractWith(*_player, auctioneer,UNIT_NPC_FLAG_AUCTIONEER);
 334     if (!pCreature)
 335     {
 336         sLog.outDebug( "WORLD: HandleAuctionPlaceBid - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(auctioneer)) );
 337         return;
 338     }
 339
 340     // remove fake death
 341     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 342         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 343
 344     uint32 location = AuctioneerFactionToLocation(pCreature->getFaction());
 345
 346     AuctionHouseObject * mAuctions;
 347     mAuctions = objmgr.GetAuctionsMap( location );
 348
 349     AuctionEntry *auction = mAuctions->GetAuction(auctionId);
 350     Player *pl = GetPlayer();
 351
 352     if( !auction || auction->owner == pl->GetGUIDLow() )
 353     {
 354         //you cannot bid your own auction:
 355         SendAuctionCommandResult( 0, AUCTION_PLACE_BID, CANNOT_BID_YOUR_AUCTION_ERROR );
 356         return;
 357     }
 358
 359     // impossible have online own another character (use this for speedup check in case online owner)
 360     Player* auction_owner = objmgr.GetPlayer(MAKE_NEW_GUID(auction->owner, 0, HIGHGUID_PLAYER));
 361     if( !auction_owner && objmgr.GetPlayerAccountIdByGUID(MAKE_NEW_GUID(auction->owner, 0, HIGHGUID_PLAYER)) == pl->GetSession()->GetAccountId())
 362     {
 363         //you cannot bid your another character auction:
 364         SendAuctionCommandResult( 0, AUCTION_PLACE_BID, CANNOT_BID_YOUR_AUCTION_ERROR );
 365         return;
 366     }
 367
 368     // cheating
 369     if(price <= auction->bid)
 370         return;
 371
 372     // price too low for next bid if not buyout
 373     if ((price < auction->buyout || auction->buyout == 0) &&
 374         price < auction->bid + objmgr.GetAuctionOutBid(auction->bid))
 375     {
 376         //auction has already higher bid, client tests it!
 377         return;
 378     }
 379
 380     if (price > pl->GetMoney())
 381     {
 382         //you don't have enought money!, client tests!
 383         //SendAuctionCommandResult(auction->auctionId, AUCTION_PLACE_BID, ???);
 384         return;
 385     }
 386
 387     if ((price < auction->buyout) || (auction->buyout == 0))
 388     {
 389         if (auction->bidder > 0)
 390         {
 391             if ( auction->bidder == pl->GetGUIDLow() )
 392             {
 393                 pl->ModifyMoney( -int32(price - auction->bid));
 394             }
 395             else
 396             {
 397                 // mail to last bidder and return money
 398                 SendAuctionOutbiddedMail( auction , price );
 399                 pl->ModifyMoney( -int32(price) );
 400             }
 401         }
 402         else
 403         {
 404             pl->ModifyMoney( -int32(price) );
 405         }
 406         auction->bidder = pl->GetGUIDLow();
 407         auction->bid = price;
 408
 409         // after this update we should save player's money ...
 410         CharacterDatabase.PExecute("UPDATE auctionhouse SET buyguid = '%u',lastbid = '%u' WHERE id = '%u'", auction->bidder, auction->bid, auction->Id);
 411
 412         SendAuctionCommandResult(auction->Id, AUCTION_PLACE_BID, AUCTION_OK, 0 );
 413     }
 414     else
 415     {
 416         //buyout:
 417         if (pl->GetGUIDLow() == auction->bidder )
 418         {
 419             pl->ModifyMoney(-int32(auction->buyout - auction->bid));
 420         }
 421         else
 422         {
 423             pl->ModifyMoney(-int32(auction->buyout));
 424             if ( auction->bidder )                          //buyout for bidded auction ..
 425             {
 426                 SendAuctionOutbiddedMail( auction, auction->buyout );
 427             }
 428         }
 429         auction->bidder = pl->GetGUIDLow();
 430         auction->bid = auction->buyout;
 431
 432         objmgr.SendAuctionSalePendingMail( auction );
 433         objmgr.SendAuctionSuccessfulMail( auction );
 434         objmgr.SendAuctionWonMail( auction );
 435
 436         SendAuctionCommandResult(auction->Id, AUCTION_PLACE_BID, AUCTION_OK);
 437
 438         objmgr.RemoveAItem(auction->item_guidlow);
 439         mAuctions->RemoveAuction(auction->Id);
 440         CharacterDatabase.PExecute("DELETE FROM auctionhouse WHERE id = '%u'",auction->Id);
 441
 442         delete auction;
 443     }
 444     CharacterDatabase.BeginTransaction();
 445     pl->SaveInventoryAndGoldToDB();
 446     CharacterDatabase.CommitTransaction();
 447 }
 448
 449 //this void is called when auction_owner cancels his auction
 450 void WorldSession::HandleAuctionRemoveItem( WorldPacket & recv_data )
 451 {
 452     CHECK_PACKET_SIZE(recv_data,8+4);
 453
 454     uint64 auctioneer;
 455     uint32 auctionId;
 456     recv_data >> auctioneer;
 457     recv_data >> auctionId;
 458     //sLog.outDebug( "Cancel AUCTION AuctionID: %u", auctionId);
 459
 460     Creature *pCreature = ObjectAccessor::GetNPCIfCanInteractWith(*_player, auctioneer,UNIT_NPC_FLAG_AUCTIONEER);
 461     if (!pCreature)
 462     {
 463         sLog.outDebug( "WORLD: HandleAuctionRemoveItem - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(auctioneer)) );
 464         return;
 465     }
 466
 467     // remove fake death
 468     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 469         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 470
 471     uint32 location = AuctioneerFactionToLocation(pCreature->getFaction());
 472
 473     AuctionHouseObject * mAuctions;
 474     mAuctions = objmgr.GetAuctionsMap( location );
 475
 476     AuctionEntry *auction = mAuctions->GetAuction(auctionId);
 477     Player *pl = GetPlayer();
 478
 479     if (auction && auction->owner == pl->GetGUIDLow())
 480     {
 481         Item *pItem = objmgr.GetAItem(auction->item_guidlow);
 482         if (pItem)
 483         {
 484             if (auction->bidder > 0)                        // If we have a bidder, we have to send him the money he paid
 485             {
 486                 uint32 auctionCut = objmgr.GetAuctionCut( auction->location, auction->bid);
 487                 if ( pl->GetMoney() < auctionCut )          //player doesn't have enough money, maybe message needed
 488                     return;
 489                 //some auctionBidderNotification would be needed, but don't know that parts..
 490                 SendAuctionCancelledToBidderMail( auction );
 491                 pl->ModifyMoney( -int32(auctionCut) );
 492             }
 493             // Return the item by mail
 494             std::ostringstream msgAuctionCanceledOwner;
 495             msgAuctionCanceledOwner << auction->item_template << ":0:" << AUCTION_CANCELED;
 496
 497             MailItemsInfo mi;
 498             mi.AddItem(auction->item_guidlow, auction->item_template, pItem);
 499
 500             // item will deleted or added to received mail list
 501             WorldSession::SendMailTo(pl, MAIL_AUCTION, MAIL_STATIONERY_AUCTION, auction->location, pl->GetGUIDLow(), msgAuctionCanceledOwner.str(), 0, &mi, 0, 0, MAIL_CHECK_MASK_NONE);
 502         }
 503         else
 504         {
 505             sLog.outError("Auction id: %u has non-existed item (item guid : %u)!!!", auction->Id, auction->item_guidlow);
 506             SendAuctionCommandResult( 0, AUCTION_CANCEL, AUCTION_INTERNAL_ERROR );
 507             return;
 508         }
 509     }
 510     else
 511     {
 512         SendAuctionCommandResult( 0, AUCTION_CANCEL, AUCTION_INTERNAL_ERROR );
 513         //this code isn't possible ... maybe there should be assert
 514         sLog.outError("CHEATER : %u, he tried to cancel auction (id: %u) of another player, or auction is NULL", pl->GetGUIDLow(), auctionId );
 515         return;
 516     }
 517
 518     //inform player, that auction is removed
 519     SendAuctionCommandResult( auction->Id, AUCTION_CANCEL, AUCTION_OK );
 520     // Now remove the auction
 521     CharacterDatabase.BeginTransaction();
 522     CharacterDatabase.PExecute("DELETE FROM auctionhouse WHERE id = '%u'",auction->Id);
 523     pl->SaveInventoryAndGoldToDB();
 524     CharacterDatabase.CommitTransaction();
 525     objmgr.RemoveAItem( auction->item_guidlow );
 526     mAuctions->RemoveAuction( auction->Id );
 527     delete auction;
 528 }
 529
 530 //called when player lists his bids
 531 void WorldSession::HandleAuctionListBidderItems( WorldPacket & recv_data )
 532 {
 533     CHECK_PACKET_SIZE(recv_data,8+4+4);
 534
 535     uint64 guid;                                            //NPC guid
 536     uint32 listfrom;                                        //page of auctions
 537     uint32 outbiddedCount;                                  //count of outbidded auctions
 538
 539     recv_data >> guid;
 540     recv_data >> listfrom;                                  // not used in fact (this list not have page control in client)
 541     recv_data >> outbiddedCount;
 542     if (recv_data.size() != (16 + outbiddedCount * 4 ))
 543     {
 544         sLog.outError("Client sent bad opcode!!! with count: %u and size : %d (mustbe: %d", outbiddedCount, recv_data.size(),(16 + outbiddedCount * 4 ));
 545         outbiddedCount = 0;
 546     }
 547
 548     Creature *pCreature = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid,UNIT_NPC_FLAG_AUCTIONEER);
 549     if (!pCreature)
 550     {
 551         sLog.outDebug( "WORLD: HandleAuctionListBidderItems - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 552         return;
 553     }
 554
 555     // remove fake death
 556     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 557         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 558
 559     uint32 location = AuctioneerFactionToLocation(pCreature->getFaction());
 560     AuctionHouseObject* mAuctions = objmgr.GetAuctionsMap( location );
 561
 562     WorldPacket data( SMSG_AUCTION_BIDDER_LIST_RESULT, (4+4+4) );
 563     Player *pl = GetPlayer();
 564     data << (uint32) 0;                                     //add 0 as count
 565     uint32 count = 0;
 566     uint32 totalcount = 0;
 567     while ( outbiddedCount > 0)                             //add all data, which client requires
 568     {
 569         --outbiddedCount;
 570         uint32 outbiddedAuctionId;
 571         recv_data >> outbiddedAuctionId;
 572         AuctionEntry * auction = mAuctions->GetAuction( outbiddedAuctionId );
 573         if ( auction && SendAuctionInfo(data, auction))
 574         {
 575             ++totalcount;
 576             ++count;
 577         }
 578     }
 579     for (AuctionHouseObject::AuctionEntryMap::iterator itr = mAuctions->GetAuctionsBegin();itr != mAuctions->GetAuctionsEnd();++itr)
 580     {
 581         AuctionEntry *Aentry = itr->second;
 582         if( Aentry && Aentry->bidder == pl->GetGUIDLow() )
 583         {
 584             if (SendAuctionInfo(data, itr->second))
 585                 ++count;
 586             ++totalcount;
 587         }
 588     }
 589     data.put<uint32>( 0, count );                           // add count to placeholder
 590     data << totalcount;
 591     data << (uint32)300;                                    //unk 2.3.0
 592     SendPacket(&data);
 593 }
 594
 595 //this void sends player info about his auctions
 596 void WorldSession::HandleAuctionListOwnerItems( WorldPacket & recv_data )
 597 {
 598     CHECK_PACKET_SIZE(recv_data,8+4);
 599
 600     uint32 listfrom;
 601     uint64 guid;
 602
 603     recv_data >> guid;
 604     recv_data >> listfrom;                                  // not used in fact (this list not have page control in client)
 605
 606     Creature *pCreature = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid,UNIT_NPC_FLAG_AUCTIONEER);
 607     if (!pCreature)
 608     {
 609         sLog.outDebug( "WORLD: HandleAuctionListOwnerItems - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 610         return;
 611     }
 612
 613     // remove fake death
 614     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 615         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 616
 617     uint32 location = AuctioneerFactionToLocation(pCreature->getFaction());
 618
 619     AuctionHouseObject* mAuctions = objmgr.GetAuctionsMap( location );
 620
 621     WorldPacket data( SMSG_AUCTION_OWNER_LIST_RESULT, (4+4+4) );
 622     data << (uint32) 0;                                     // amount place holder
 623
 624     uint32 count = 0;
 625     uint32 totalcount = 0;
 626     for (AuctionHouseObject::AuctionEntryMap::iterator itr = mAuctions->GetAuctionsBegin();itr != mAuctions->GetAuctionsEnd();++itr)
 627     {
 628         AuctionEntry *Aentry = itr->second;
 629         if( Aentry && Aentry->owner == _player->GetGUIDLow() )
 630         {
 631             if(SendAuctionInfo(data, itr->second))
 632                 ++count;
 633             ++totalcount;
 634         }
 635     }
 636     data.put<uint32>(0, count);
 637     data << (uint32) totalcount;
 638     data << (uint32) 0;
 639     SendPacket(&data);
 640 }
 641
 642 //this void is called when player clicks on search button
 643 void WorldSession::HandleAuctionListItems( WorldPacket & recv_data )
 644 {
 645     CHECK_PACKET_SIZE(recv_data,8+4+1+1+1+4+4+4+4+1);
 646
 647     std::string searchedname, name;
 648     uint8 levelmin, levelmax, usable, location;
 649     uint32 count, totalcount, listfrom, auctionSlotID, auctionMainCategory, auctionSubCategory, quality;
 650     uint64 guid;
 651
 652     recv_data >> guid;
 653     recv_data >> listfrom;                                  // start, used for page control listing by 50 elements
 654     recv_data >> searchedname;
 655
 656     // recheck with known string size
 657     CHECK_PACKET_SIZE(recv_data,8+4+(searchedname.size()+1)+1+1+4+4+4+4+1);
 658
 659     recv_data >> levelmin >> levelmax;
 660     recv_data >> auctionSlotID >> auctionMainCategory >> auctionSubCategory;
 661     recv_data >> quality >> usable;
 662
 663     Creature *pCreature = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid,UNIT_NPC_FLAG_AUCTIONEER);
 664     if (!pCreature)
 665     {
 666         sLog.outDebug( "WORLD: HandleAuctionListItems - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 667         return;
 668     }
 669
 670     // remove fake death
 671     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 672         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 673
 674     location = AuctioneerFactionToLocation(pCreature->getFaction());
 675     AuctionHouseObject * mAuctions;
 676     mAuctions = objmgr.GetAuctionsMap( location );
 677
 678     //sLog.outDebug("Auctionhouse search guid: " I64FMTD ", list from: %u, searchedname: %s, levelmin: %u, levelmax: %u, auctionSlotID: %u, auctionMainCategory: %u, auctionSubCategory: %u, quality: %u, usable: %u", guid, listfrom, searchedname.c_str(), levelmin, levelmax, auctionSlotID, auctionMainCategory, auctionSubCategory, quality, usable);
 679
 680     WorldPacket data( SMSG_AUCTION_LIST_RESULT, (4+4+4) );
 681     count = 0;
 682     totalcount = 0;
 683     data << (uint32) 0;
 684
 685     // converting string that we try to find to lower case
 686     std::wstring wsearchedname;
 687     if(!Utf8toWStr(searchedname,wsearchedname))
 688         return;
 689
 690     wstrToLower(wsearchedname);
 691
 692     for (AuctionHouseObject::AuctionEntryMap::iterator itr = mAuctions->GetAuctionsBegin();itr != mAuctions->GetAuctionsEnd();++itr)
 693     {
 694         AuctionEntry *Aentry = itr->second;
 695         Item *item = objmgr.GetAItem(Aentry->item_guidlow);
 696         if( item )
 697         {
 698             ItemPrototype const *proto = item->GetProto();
 699             if( proto )
 700             {
 701                 if( auctionMainCategory == (0xffffffff) || proto->Class == auctionMainCategory )
 702                 {
 703                     if( auctionSubCategory == (0xffffffff) || proto->SubClass == auctionSubCategory )
 704                     {
 705                         if( auctionSlotID == (0xffffffff) || proto->InventoryType == auctionSlotID )
 706                         {
 707                             if( quality == (0xffffffff) || proto->Quality == quality )
 708                             {
 709                                 if( usable == (0x00) || _player->CanUseItem( item ) == EQUIP_ERR_OK )
 710                                 {
 711                                     if( ( levelmin == (0x00) || proto->RequiredLevel >= levelmin ) && ( levelmax == (0x00) || proto->RequiredLevel <= levelmax ) )
 712                                     {
 713                                         name = proto->Name1;
 714
 715                                         // local name
 716                                         int loc_idx = GetSessionDbLocaleIndex();
 717                                         if ( loc_idx >= 0 )
 718                                         {
 719                                             ItemLocale const *il = objmgr.GetItemLocale(proto->ItemId);
 720                                             if (il)
 721                                             {
 722                                                 if (il->Name.size() > size_t(loc_idx) && !il->Name[loc_idx].empty())
 723                                                     name = il->Name[loc_idx];
 724                                             }
 725                                         }
 726
 727                                         if(name.empty())
 728                                             continue;
 729
 730                                         if( wsearchedname.empty() || Utf8FitTo(name, wsearchedname) )
 731                                         {
 732                                             if ((count < 50) && (totalcount >= listfrom))
 733                                             {
 734                                                 ++count;
 735                                                 SendAuctionInfo( data, Aentry);
 736                                             }
 737                                             ++totalcount;
 738                                         }
 739                                     }
 740                                 }
 741                             }
 742                         }
 743                     }
 744                 }
 745             }
 746         }
 747     }
 748     data.put<uint32>(0, count);
 749     data << (uint32) totalcount;
 750     data << (uint32) 300;                                   // unk 2.3.0 const?
 751     SendPacket(&data);
 752 }
 753
 754 void WorldSession::HandleAuctionListPendingSales( WorldPacket & recv_data )
 755 {
 756     sLog.outDebug("CMSG_AUCTION_LIST_PENDING_SALES");
 757     recv_data.hexlike();
 758
 759     uint32 count = 0;
 760
 761     WorldPacket data(SMSG_AUCTION_LIST_PENDING_SALES, 4);
 762     data << uint32(count);                                  // count
 763     /*for(uint32 i = 0; i < count; ++i)
 764     {
 765         data << "";                                         // string
 766         data << "";                                         // string
 767         data << uint32(0);
 768         data << uint32(0);
 769         data << float(0);
 770     }*/
 771     SendPacket(&data);
 772 }