src/game/NPCHandler.cpp

   1 /*
   2  * Copyright (C) 2005-2008 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 "Common.h"
  20 #include "Language.h"
  21 #include "Database/DatabaseEnv.h"
  22 #include "WorldPacket.h"
  23 #include "WorldSession.h"
  24 #include "Opcodes.h"
  25 #include "Log.h"
  26 #include "World.h"
  27 #include "ObjectMgr.h"
  28 #include "SpellMgr.h"
  29 #include "Player.h"
  30 #include "GossipDef.h"
  31 #include "SpellAuras.h"
  32 #include "UpdateMask.h"
  33 #include "ScriptCalls.h"
  34 #include "ObjectAccessor.h"
  35 #include "Creature.h"
  36 #include "MapManager.h"
  37 #include "Pet.h"
  38 #include "BattleGroundMgr.h"
  39 #include "BattleGround.h"
  40 #include "Guild.h"
  41
  42 void WorldSession::HandleTabardVendorActivateOpcode( WorldPacket & recv_data )
  43 {
  44     CHECK_PACKET_SIZE(recv_data,8);
  45
  46     uint64 guid;
  47     recv_data >> guid;
  48
  49     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid,UNIT_NPC_FLAG_TABARDDESIGNER);
  50     if (!unit)
  51     {
  52         sLog.outDebug( "WORLD: HandleTabardVendorActivateOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
  53         return;
  54     }
  55
  56     // remove fake death
  57     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
  58         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
  59
  60     SendTabardVendorActivate(guid);
  61 }
  62
  63 void WorldSession::SendTabardVendorActivate( uint64 guid )
  64 {
  65     WorldPacket data( MSG_TABARDVENDOR_ACTIVATE, 8 );
  66     data << guid;
  67     SendPacket( &data );
  68 }
  69
  70 void WorldSession::HandleBankerActivateOpcode( WorldPacket & recv_data )
  71 {
  72     CHECK_PACKET_SIZE(recv_data,8);
  73
  74     uint64 guid;
  75
  76     sLog.outDebug(  "WORLD: Received CMSG_BANKER_ACTIVATE" );
  77
  78     recv_data >> guid;
  79
  80     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid,UNIT_NPC_FLAG_BANKER);
  81     if (!unit)
  82     {
  83         sLog.outDebug( "WORLD: HandleBankerActivateOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
  84         return;
  85     }
  86
  87     // remove fake death
  88     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
  89         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
  90
  91     SendShowBank(guid);
  92 }
  93
  94 void WorldSession::SendShowBank( uint64 guid )
  95 {
  96     WorldPacket data( SMSG_SHOW_BANK, 8 );
  97     data << guid;
  98     SendPacket( &data );
  99 }
 100
 101 void WorldSession::HandleTrainerListOpcode( WorldPacket & recv_data )
 102 {
 103     CHECK_PACKET_SIZE(recv_data,8);
 104
 105     uint64 guid;
 106
 107     recv_data >> guid;
 108     SendTrainerList( guid );
 109 }
 110
 111 void WorldSession::SendTrainerList( uint64 guid )
 112 {
 113     std::string str = GetMangosString(LANG_NPC_TAINER_HELLO);
 114     SendTrainerList( guid, str );
 115 }
 116
 117 void WorldSession::SendTrainerList( uint64 guid,std::string strTitle )
 118 {
 119     sLog.outDebug( "WORLD: SendTrainerList" );
 120
 121     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid,UNIT_NPC_FLAG_TRAINER);
 122     if (!unit)
 123     {
 124         sLog.outDebug( "WORLD: SendTrainerList - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 125         return;
 126     }
 127
 128     // remove fake death
 129     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 130         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 131
 132     // trainer list loaded at check;
 133     if(!unit->isCanTrainingOf(_player,true))
 134         return;
 135
 136     CreatureInfo const *ci = unit->GetCreatureInfo();
 137
 138     if (!ci)
 139     {
 140         sLog.outDebug( "WORLD: SendTrainerList - (GUID: %u) NO CREATUREINFO!",GUID_LOPART(guid) );
 141         return;
 142     }
 143
 144     TrainerSpellData const* trainer_spells = unit->GetTrainerSpells();
 145     if(!trainer_spells)
 146     {
 147         sLog.outDebug( "WORLD: SendTrainerList - Training spells not found for creature (GUID: %u Entry: %u)",
 148             GUID_LOPART(guid), unit->GetEntry());
 149         return;
 150     }
 151
 152     WorldPacket data( SMSG_TRAINER_LIST, 8+4+4+trainer_spells->spellList.size()*38 + strTitle.size()+1);
 153     data << guid;
 154     data << uint32(trainer_spells->trainerType);
 155
 156     size_t count_pos = data.wpos();
 157     data << uint32(trainer_spells->spellList.size());
 158
 159     // reputation discount
 160     float fDiscountMod = _player->GetReputationPriceDiscount(unit);
 161
 162     uint32 count = 0;
 163     for(TrainerSpellList::const_iterator itr = trainer_spells->spellList.begin(); itr != trainer_spells->spellList.end(); ++itr)
 164     {
 165         TrainerSpell const* tSpell = *itr;
 166
 167         if(!_player->IsSpellFitByClassAndRace(tSpell->spell))
 168             continue;
 169
 170         ++count;
 171
 172         bool primary_prof_first_rank = spellmgr.IsPrimaryProfessionFirstRankSpell(tSpell->spell);
 173
 174         SpellChainNode const* chain_node = spellmgr.GetSpellChainNode(tSpell->spell);
 175
 176         data << uint32(tSpell->spell);
 177         data << uint8(_player->GetTrainerSpellState(tSpell));
 178         data << uint32(floor(tSpell->spellcost * fDiscountMod));
 179
 180         data << uint32(primary_prof_first_rank ? 1 : 0);    // primary prof. learn confirmation dialog
 181         data << uint32(primary_prof_first_rank ? 1 : 0);    // must be equal prev. field to have learn button in enabled state
 182         data << uint8(tSpell->reqlevel);
 183         data << uint32(tSpell->reqskill);
 184         data << uint32(tSpell->reqskillvalue);
 185         data << uint32(chain_node ? (chain_node->prev ? chain_node->prev : chain_node->req) : 0);
 186         data << uint32(chain_node && chain_node->prev ? chain_node->req : 0);
 187         data << uint32(0);
 188     }
 189
 190     data << strTitle;
 191
 192     data.put<uint32>(count_pos,count);
 193     SendPacket( &data );
 194 }
 195
 196 void WorldSession::HandleTrainerBuySpellOpcode( WorldPacket & recv_data )
 197 {
 198     CHECK_PACKET_SIZE(recv_data,8+4);
 199
 200     uint64 guid;
 201     uint32 spellId = 0;
 202
 203     recv_data >> guid >> spellId;
 204     sLog.outDebug( "WORLD: Received CMSG_TRAINER_BUY_SPELL NpcGUID=%u, learn spell id is: %u",uint32(GUID_LOPART(guid)), spellId );
 205
 206     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid, UNIT_NPC_FLAG_TRAINER);
 207     if (!unit)
 208     {
 209         sLog.outDebug( "WORLD: HandleTrainerBuySpellOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 210         return;
 211     }
 212
 213     // remove fake death
 214     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 215         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 216
 217     if(!unit->isCanTrainingOf(_player,true))
 218         return;
 219
 220     // check present spell in trainer spell list
 221     TrainerSpellData const* trainer_spells = unit->GetTrainerSpells();
 222     if(!trainer_spells)
 223         return;
 224
 225     // not found, cheat?
 226     TrainerSpell const* trainer_spell = trainer_spells->Find(spellId);
 227     if(!trainer_spell)
 228         return;
 229
 230     // can't be learn, cheat? Or double learn with lags...
 231     if(_player->GetTrainerSpellState(trainer_spell) != TRAINER_SPELL_GREEN)
 232         return;
 233
 234     // apply reputation discount
 235     uint32 nSpellCost = uint32(floor(trainer_spell->spellcost * _player->GetReputationPriceDiscount(unit)));
 236
 237     // check money requirement
 238     if(_player->GetMoney() < nSpellCost )
 239         return;
 240
 241     WorldPacket data(SMSG_PLAY_SPELL_VISUAL, 12);           // visual effect on trainer
 242     data << uint64(guid) << uint32(0xB3);
 243     SendPacket(&data);
 244
 245     data.Initialize(SMSG_PLAY_SPELL_IMPACT, 12);            // visual effect on player
 246     data << uint64(_player->GetGUID()) << uint32(0x016A);
 247     SendPacket(&data);
 248
 249     _player->ModifyMoney( -int32(nSpellCost) );
 250
 251     // learn explicitly to prevent lost money at lags, learning spell will be only show spell animation
 252     _player->learnSpell(trainer_spell->spell);
 253
 254     data.Initialize(SMSG_TRAINER_BUY_SUCCEEDED, 12);
 255     data << uint64(guid) << uint32(spellId);
 256     SendPacket(&data);
 257 }
 258
 259 void WorldSession::HandleGossipHelloOpcode( WorldPacket & recv_data )
 260 {
 261     CHECK_PACKET_SIZE(recv_data,8);
 262
 263     sLog.outDebug(  "WORLD: Received CMSG_GOSSIP_HELLO" );
 264
 265     uint64 guid;
 266     recv_data >> guid;
 267
 268     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid, UNIT_NPC_FLAG_NONE);
 269     if (!unit)
 270     {
 271         sLog.outDebug( "WORLD: HandleGossipHelloOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 272         return;
 273     }
 274
 275     // remove fake death
 276     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 277         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 278
 279     if( unit->isArmorer() || unit->isCivilian() || unit->isQuestGiver() || unit->isServiceProvider())
 280     {
 281         unit->StopMoving();
 282     }
 283
 284     // If spiritguide, no need for gossip menu, just put player into resurrect queue
 285     if (unit->isSpiritGuide())
 286     {
 287         BattleGround *bg = _player->GetBattleGround();
 288         if(bg)
 289         {
 290             bg->AddPlayerToResurrectQueue(unit->GetGUID(), _player->GetGUID());
 291             sBattleGroundMgr.SendAreaSpiritHealerQueryOpcode(_player, bg, unit->GetGUID());
 292             return;
 293         }
 294     }
 295
 296     if(!Script->GossipHello( _player, unit ))
 297     {
 298         _player->TalkedToCreature(unit->GetEntry(),unit->GetGUID());
 299         unit->prepareGossipMenu(_player);
 300         unit->sendPreparedGossip(_player);
 301     }
 302 }
 303
 304 void WorldSession::HandleGossipSelectOptionOpcode( WorldPacket & recv_data )
 305 {
 306     CHECK_PACKET_SIZE(recv_data,8+4+4);
 307
 308     sLog.outDebug("WORLD: CMSG_GOSSIP_SELECT_OPTION");
 309
 310     uint32 option;
 311     uint32 unk;
 312     uint64 guid;
 313     std::string code = "";
 314
 315     recv_data >> guid >> unk >> option;
 316
 317     if(_player->PlayerTalkClass->GossipOptionCoded( option ))
 318     {
 319         // recheck
 320         CHECK_PACKET_SIZE(recv_data,8+4+1);
 321         sLog.outBasic("reading string");
 322         recv_data >> code;
 323         sLog.outBasic("string read: %s", code.c_str());
 324     }
 325
 326     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid, UNIT_NPC_FLAG_NONE);
 327     if (!unit)
 328     {
 329         sLog.outDebug( "WORLD: HandleGossipSelectOptionOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 330         return;
 331     }
 332
 333     // remove fake death
 334     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 335         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 336
 337     if(!code.empty())
 338     {
 339         if (!Script->GossipSelectWithCode(_player, unit, _player->PlayerTalkClass->GossipOptionSender (option), _player->PlayerTalkClass->GossipOptionAction( option ), code.c_str()))
 340             unit->OnGossipSelect (_player, option);
 341     }
 342     else
 343     {
 344         if (!Script->GossipSelect (_player, unit, _player->PlayerTalkClass->GossipOptionSender (option), _player->PlayerTalkClass->GossipOptionAction (option)))
 345            unit->OnGossipSelect (_player, option);
 346     }
 347 }
 348
 349 void WorldSession::HandleSpiritHealerActivateOpcode( WorldPacket & recv_data )
 350 {
 351     CHECK_PACKET_SIZE(recv_data,8);
 352
 353     sLog.outDebug("WORLD: CMSG_SPIRIT_HEALER_ACTIVATE");
 354
 355     uint64 guid;
 356
 357     recv_data >> guid;
 358
 359     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid, UNIT_NPC_FLAG_SPIRITHEALER);
 360     if (!unit)
 361     {
 362         sLog.outDebug( "WORLD: HandleSpiritHealerActivateOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 363         return;
 364     }
 365
 366     // remove fake death
 367     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 368         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 369
 370     SendSpiritResurrect();
 371 }
 372
 373 void WorldSession::SendSpiritResurrect()
 374 {
 375     _player->ResurrectPlayer(0.5f, true);
 376
 377     _player->DurabilityLossAll(0.25f,true);
 378
 379     // get corpse nearest graveyard
 380     WorldSafeLocsEntry const *corpseGrave = NULL;
 381     Corpse *corpse = _player->GetCorpse();
 382     if(corpse)
 383         corpseGrave = objmgr.GetClosestGraveYard(
 384             corpse->GetPositionX(), corpse->GetPositionY(), corpse->GetPositionZ(), corpse->GetMapId(), _player->GetTeam() );
 385
 386     // now can spawn bones
 387     _player->SpawnCorpseBones();
 388
 389     // teleport to nearest from corpse graveyard, if different from nearest to player ghost
 390     if(corpseGrave)
 391     {
 392         WorldSafeLocsEntry const *ghostGrave = objmgr.GetClosestGraveYard(
 393             _player->GetPositionX(), _player->GetPositionY(), _player->GetPositionZ(), _player->GetMapId(), _player->GetTeam() );
 394
 395         if(corpseGrave != ghostGrave)
 396             _player->TeleportTo(corpseGrave->map_id, corpseGrave->x, corpseGrave->y, corpseGrave->z, _player->GetOrientation());
 397         // or update at original position
 398         else
 399             ObjectAccessor::UpdateVisibilityForPlayer(_player);
 400     }
 401     // or update at original position
 402     else
 403         ObjectAccessor::UpdateVisibilityForPlayer(_player);
 404
 405     _player->SaveToDB();
 406 }
 407
 408 void WorldSession::HandleBinderActivateOpcode( WorldPacket & recv_data )
 409 {
 410     CHECK_PACKET_SIZE(recv_data,8);
 411
 412     uint64 npcGUID;
 413     recv_data >> npcGUID;
 414
 415     if(!GetPlayer()->isAlive())
 416         return;
 417
 418     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID,UNIT_NPC_FLAG_INNKEEPER);
 419     if (!unit)
 420     {
 421         sLog.outDebug( "WORLD: HandleBinderActivateOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 422         return;
 423     }
 424
 425     // remove fake death
 426     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 427         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 428
 429     SendBindPoint(unit);
 430 }
 431
 432 void WorldSession::SendBindPoint(Creature *npc)
 433 {
 434     uint32 bindspell = 3286;
 435
 436     // update sql homebind
 437     CharacterDatabase.PExecute("UPDATE character_homebind SET map = '%u', zone = '%u', position_x = '%f', position_y = '%f', position_z = '%f' WHERE guid = '%u'", _player->GetMapId(), _player->GetZoneId(), _player->GetPositionX(), _player->GetPositionY(), _player->GetPositionZ(), _player->GetGUIDLow());
 438     _player->m_homebindMapId = _player->GetMapId();
 439     _player->m_homebindZoneId = _player->GetZoneId();
 440     _player->m_homebindX = _player->GetPositionX();
 441     _player->m_homebindY = _player->GetPositionY();
 442     _player->m_homebindZ = _player->GetPositionZ();
 443
 444     // send spell for bind 3286 bind magic
 445     npc->CastSpell(_player, bindspell, true);
 446
 447     WorldPacket data( SMSG_TRAINER_BUY_SUCCEEDED, (8+4));
 448     data << npc->GetGUID();
 449     data << bindspell;
 450     SendPacket( &data );
 451
 452     // binding
 453     data.Initialize( SMSG_BINDPOINTUPDATE, (4+4+4+4+4) );
 454     data << float(_player->GetPositionX());
 455     data << float(_player->GetPositionY());
 456     data << float(_player->GetPositionZ());
 457     data << uint32(_player->GetMapId());
 458     data << uint32(_player->GetZoneId());
 459     SendPacket( &data );
 460
 461     DEBUG_LOG("New Home Position X is %f",_player->GetPositionX());
 462     DEBUG_LOG("New Home Position Y is %f",_player->GetPositionY());
 463     DEBUG_LOG("New Home Position Z is %f",_player->GetPositionZ());
 464     DEBUG_LOG("New Home MapId is %u",_player->GetMapId());
 465     DEBUG_LOG("New Home ZoneId is %u",_player->GetZoneId());
 466
 467     // zone update
 468     data.Initialize( SMSG_PLAYERBOUND, 8+4 );
 469     data << uint64(_player->GetGUID());
 470     data << uint32(_player->GetZoneId());
 471     SendPacket( &data );
 472
 473     _player->PlayerTalkClass->CloseGossip();
 474 }
 475
 476 //Need fix
 477 void WorldSession::HandleListStabledPetsOpcode( WorldPacket & recv_data )
 478 {
 479     CHECK_PACKET_SIZE(recv_data,8);
 480
 481     sLog.outDebug("WORLD: Recv MSG_LIST_STABLED_PETS");
 482     uint64 npcGUID;
 483
 484     recv_data >> npcGUID;
 485
 486     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_STABLEMASTER);
 487     if (!unit)
 488     {
 489         sLog.outDebug( "WORLD: HandleListStabledPetsOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 490         return;
 491     }
 492
 493     // remove fake death
 494     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 495         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 496
 497     SendStablePet(npcGUID);
 498 }
 499
 500 void WorldSession::SendStablePet(uint64 guid )
 501 {
 502     sLog.outDebug("WORLD: Recv MSG_LIST_STABLED_PETS Send.");
 503
 504     WorldPacket data(MSG_LIST_STABLED_PETS, 200);           // guess size
 505     data << uint64 ( guid );
 506
 507     Pet *pet = _player->GetPet();
 508
 509     data << uint8(0);                                       // place holder for slot show number
 510     data << uint8(GetPlayer()->m_stableSlots);
 511
 512     uint8 num = 0;                                          // counter for place holder
 513
 514     // not let move dead pet in slot
 515     if(pet && pet->isAlive() && pet->getPetType()==HUNTER_PET)
 516     {
 517         data << uint32(pet->GetCharmInfo()->GetPetNumber());
 518         data << uint32(pet->GetEntry());
 519         data << uint32(pet->getLevel());
 520         data << pet->GetName();                             // petname
 521         data << uint8(0x01);                                // flags?, client slot 1 == current pet (0)
 522         ++num;
 523     }
 524
 525     //                                                     0      1     2   3      4      5
 526     QueryResult* result = CharacterDatabase.PQuery("SELECT owner, slot, id, entry, level, name FROM character_pet WHERE owner = '%u' AND slot > 0 AND slot < 5",_player->GetGUIDLow());
 527
 528     if(result)
 529     {
 530         do
 531         {
 532             Field *fields = result->Fetch();
 533
 534             data << uint32(fields[2].GetUInt32());          // petnumber
 535             data << uint32(fields[3].GetUInt32());          // creature entry
 536             data << uint32(fields[4].GetUInt32());          // level
 537             data << fields[5].GetString();                  // name
 538             data << uint8(fields[1].GetUInt32()+1);         // slot
 539
 540             ++num;
 541         }while( result->NextRow() );
 542
 543         delete result;
 544     }
 545
 546     data.put<uint8>(8, num);                                // set real data to placeholder
 547     SendPacket(&data);
 548 }
 549
 550 void WorldSession::HandleStablePet( WorldPacket & recv_data )
 551 {
 552     CHECK_PACKET_SIZE(recv_data, 8);
 553
 554     sLog.outDebug("WORLD: Recv CMSG_STABLE_PET");
 555     uint64 npcGUID;
 556
 557     recv_data >> npcGUID;
 558
 559     if(!GetPlayer()->isAlive())
 560         return;
 561
 562     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_STABLEMASTER);
 563     if (!unit)
 564     {
 565         sLog.outDebug( "WORLD: HandleStablePet - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 566         return;
 567     }
 568
 569     // remove fake death
 570     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 571         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 572
 573     Pet *pet = _player->GetPet();
 574
 575     WorldPacket data(SMSG_STABLE_RESULT, 200);              // guess size
 576
 577     // can't place in stable dead pet
 578     if(!pet||!pet->isAlive()||pet->getPetType()!=HUNTER_PET)
 579     {
 580         data << uint8(0x06);
 581         SendPacket(&data);
 582         return;
 583     }
 584
 585     uint32 free_slot = 1;
 586
 587     QueryResult *result = CharacterDatabase.PQuery("SELECT owner,slot,id FROM character_pet WHERE owner = '%u'  AND slot > 0 AND slot < 5 ORDER BY slot ",_player->GetGUIDLow());
 588     if(result)
 589     {
 590         do
 591         {
 592             Field *fields = result->Fetch();
 593
 594             uint32 slot = fields[1].GetUInt32();
 595
 596             if(slot==free_slot)                             // this slot not free
 597                 ++free_slot;
 598         }while( result->NextRow() );
 599     }
 600     delete result;
 601
 602     if( free_slot > 0 && free_slot <= GetPlayer()->m_stableSlots)
 603     {
 604         _player->RemovePet(pet,PetSaveMode(free_slot));
 605         data << uint8(0x08);
 606     }
 607     else
 608         data << uint8(0x06);
 609
 610     SendPacket(&data);
 611 }
 612
 613 void WorldSession::HandleUnstablePet( WorldPacket & recv_data )
 614 {
 615     CHECK_PACKET_SIZE(recv_data, 8+4);
 616
 617     sLog.outDebug("WORLD: Recv CMSG_UNSTABLE_PET.");
 618     uint64 npcGUID;
 619     uint32 petnumber;
 620
 621     recv_data >> npcGUID >> petnumber;
 622
 623     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_STABLEMASTER);
 624     if (!unit)
 625     {
 626         sLog.outDebug( "WORLD: HandleUnstablePet - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 627         return;
 628     }
 629
 630     // remove fake death
 631     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 632         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 633
 634     WorldPacket data(SMSG_STABLE_RESULT, 200);              // guess size
 635
 636     Pet* pet = _player->GetPet();
 637     if(pet && pet->isAlive())
 638     {
 639         uint8 i = 0x06;
 640         data << uint8(i);
 641         SendPacket(&data);
 642         return;
 643     }
 644
 645     // delete dead pet
 646     if(pet)
 647         _player->RemovePet(pet,PET_SAVE_AS_DELETED);
 648
 649     Pet *newpet = NULL;
 650
 651     QueryResult *result = CharacterDatabase.PQuery("SELECT entry FROM character_pet WHERE owner = '%u' AND id = '%u' AND slot > 0 AND slot < 5",_player->GetGUIDLow(),petnumber);
 652     if(result)
 653     {
 654         Field *fields = result->Fetch();
 655         uint32 petentry = fields[0].GetUInt32();
 656
 657         newpet = new Pet(HUNTER_PET);
 658         if(!newpet->LoadPetFromDB(_player,petentry,petnumber))
 659         {
 660             delete newpet;
 661             newpet = NULL;
 662         }
 663         delete result;
 664     }
 665
 666     if(newpet)
 667         data << uint8(0x09);
 668     else
 669         data << uint8(0x06);
 670     SendPacket(&data);
 671 }
 672
 673 void WorldSession::HandleBuyStableSlot( WorldPacket & recv_data )
 674 {
 675     CHECK_PACKET_SIZE(recv_data, 8);
 676
 677     sLog.outDebug("WORLD: Recv CMSG_BUY_STABLE_SLOT.");
 678     uint64 npcGUID;
 679
 680     recv_data >> npcGUID;
 681
 682     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_STABLEMASTER);
 683     if (!unit)
 684     {
 685         sLog.outDebug( "WORLD: HandleBuyStableSlot - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 686         return;
 687     }
 688
 689     // remove fake death
 690     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 691         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 692
 693     WorldPacket data(SMSG_STABLE_RESULT, 200);
 694
 695     if(GetPlayer()->m_stableSlots < 4)                      // max slots amount = 4
 696     {
 697         StableSlotPricesEntry const *SlotPrice = sStableSlotPricesStore.LookupEntry(GetPlayer()->m_stableSlots+1);
 698         if(_player->GetMoney() >= SlotPrice->Price)
 699         {
 700             ++GetPlayer()->m_stableSlots;
 701             _player->ModifyMoney(-int32(SlotPrice->Price));
 702             data << uint8(0x0A);                            // success buy
 703         }
 704         else
 705             data << uint8(0x06);
 706     }
 707     else
 708         data << uint8(0x06);
 709
 710     SendPacket(&data);
 711 }
 712
 713 void WorldSession::HandleStableRevivePet( WorldPacket &/* recv_data */)
 714 {
 715     sLog.outDebug("HandleStableRevivePet: Not implemented");
 716 }
 717
 718 void WorldSession::HandleStableSwapPet( WorldPacket & recv_data )
 719 {
 720     CHECK_PACKET_SIZE(recv_data, 8+4);
 721
 722     sLog.outDebug("WORLD: Recv CMSG_STABLE_SWAP_PET.");
 723     uint64 npcGUID;
 724     uint32 pet_number;
 725
 726     recv_data >> npcGUID >> pet_number;
 727
 728     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_STABLEMASTER);
 729     if (!unit)
 730     {
 731         sLog.outDebug( "WORLD: HandleStableSwapPet - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 732         return;
 733     }
 734
 735     // remove fake death
 736     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 737         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 738
 739     WorldPacket data(SMSG_STABLE_RESULT, 200);              // guess size
 740
 741     Pet* pet = _player->GetPet();
 742
 743     if(!pet || pet->getPetType()!=HUNTER_PET)
 744         return;
 745
 746     // find swapped pet slot in stable
 747     QueryResult *result = CharacterDatabase.PQuery("SELECT slot,entry FROM character_pet WHERE owner = '%u' AND id = '%u'",_player->GetGUIDLow(),pet_number);
 748     if(!result)
 749         return;
 750
 751     Field *fields = result->Fetch();
 752
 753     uint32 slot     = fields[0].GetUInt32();
 754     uint32 petentry = fields[1].GetUInt32();
 755     delete result;
 756
 757     // move alive pet to slot or delele dead pet
 758     _player->RemovePet(pet,pet->isAlive() ? PetSaveMode(slot) : PET_SAVE_AS_DELETED);
 759
 760     // summon unstabled pet
 761     Pet *newpet = new Pet;
 762     if(!newpet->LoadPetFromDB(_player,petentry,pet_number))
 763     {
 764         delete newpet;
 765         data << uint8(0x06);
 766     }
 767     else
 768         data << uint8(0x09);
 769
 770     SendPacket(&data);
 771 }
 772
 773 void WorldSession::HandleRepairItemOpcode( WorldPacket & recv_data )
 774 {
 775     CHECK_PACKET_SIZE(recv_data, 8+8+1);
 776
 777     sLog.outDebug("WORLD: CMSG_REPAIR_ITEM");
 778
 779     uint64 npcGUID, itemGUID;
 780     uint8 guildBank;                                        // new in 2.3.2, bool that means from guild bank money
 781
 782     recv_data >> npcGUID >> itemGUID >> guildBank;
 783
 784     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_REPAIR);
 785     if (!unit)
 786     {
 787         sLog.outDebug( "WORLD: HandleRepairItemOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 788         return;
 789     }
 790
 791     // remove fake death
 792     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 793         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 794
 795     // reputation discount
 796     float discountMod = _player->GetReputationPriceDiscount(unit);
 797
 798     uint32 TotalCost = 0;
 799     if (itemGUID)
 800     {
 801         sLog.outDebug("ITEM: Repair item, itemGUID = %u, npcGUID = %u", GUID_LOPART(itemGUID), GUID_LOPART(npcGUID));
 802
 803         Item* item = _player->GetItemByGuid(itemGUID);
 804
 805         if(item)
 806             TotalCost= _player->DurabilityRepair(item->GetPos(),true,discountMod,guildBank>0?true:false);
 807     }
 808     else
 809     {
 810         sLog.outDebug("ITEM: Repair all items, npcGUID = %u", GUID_LOPART(npcGUID));
 811
 812         TotalCost = _player->DurabilityRepairAll(true,discountMod,guildBank>0?true:false);
 813     }
 814     if (guildBank)
 815     {
 816         uint32 GuildId = _player->GetGuildId();
 817         if (!GuildId)
 818             return;
 819         Guild *pGuild = objmgr.GetGuildById(GuildId);
 820         if (!pGuild)
 821             return;
 822         pGuild->LogBankEvent(GUILD_BANK_LOG_REPAIR_MONEY, 0, _player->GetGUIDLow(), TotalCost);
 823         pGuild->SendMoneyInfo(this, _player->GetGUIDLow());
 824     }
 825 }