src/game/NPCHandler.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 "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, const 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(TrainerSpellMap::const_iterator itr = trainer_spells->spellList.begin(); itr != trainer_spells->spellList.end(); ++itr)
 164     {
 165         TrainerSpell const* tSpell = &itr->second;
 166
 167         if(!_player->IsSpellFitByClassAndRace(tSpell->learnedSpell))
 168             continue;
 169
 170         ++count;
 171
 172         bool primary_prof_first_rank = spellmgr.IsPrimaryProfessionFirstRankSpell(tSpell->learnedSpell);
 173
 174         SpellChainNode const* chain_node = spellmgr.GetSpellChainNode(tSpell->learnedSpell);
 175
 176         data << uint32(tSpell->spell);                      // learned spell (or cast-spell in profession case)
 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     _player->ModifyMoney( -int32(nSpellCost) );
 242
 243     WorldPacket data(SMSG_PLAY_SPELL_VISUAL, 12);           // visual effect on trainer
 244     data << uint64(guid) << uint32(0xB3);
 245     SendPacket(&data);
 246
 247     data.Initialize(SMSG_PLAY_SPELL_IMPACT, 12);            // visual effect on player
 248     data << uint64(_player->GetGUID()) << uint32(0x016A);
 249     SendPacket(&data);
 250
 251     // learn explicitly or cast explicitly
 252     if(trainer_spell->IsCastable ())
 253         //FIXME: prof. spell entry in trainer list not marked gray until list re-open.
 254         _player->CastSpell(_player,trainer_spell->spell,true);
 255     else
 256         _player->learnSpell(spellId,false);
 257
 258     data.Initialize(SMSG_TRAINER_BUY_SUCCEEDED, 12);
 259     data << uint64(guid) << uint32(trainer_spell->spell);
 260     SendPacket(&data);
 261 }
 262
 263 void WorldSession::HandleGossipHelloOpcode( WorldPacket & recv_data )
 264 {
 265     CHECK_PACKET_SIZE(recv_data,8);
 266
 267     sLog.outDebug(  "WORLD: Received CMSG_GOSSIP_HELLO" );
 268
 269     uint64 guid;
 270     recv_data >> guid;
 271
 272     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid, UNIT_NPC_FLAG_NONE);
 273     if (!unit)
 274     {
 275         sLog.outDebug( "WORLD: HandleGossipHelloOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 276         return;
 277     }
 278
 279     // remove fake death
 280     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 281         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 282
 283     if( unit->isArmorer() || unit->isCivilian() || unit->isQuestGiver() || unit->isServiceProvider())
 284     {
 285         unit->StopMoving();
 286     }
 287
 288     // If spiritguide, no need for gossip menu, just put player into resurrect queue
 289     if (unit->isSpiritGuide())
 290     {
 291         BattleGround *bg = _player->GetBattleGround();
 292         if(bg)
 293         {
 294             bg->AddPlayerToResurrectQueue(unit->GetGUID(), _player->GetGUID());
 295             sBattleGroundMgr.SendAreaSpiritHealerQueryOpcode(_player, bg, unit->GetGUID());
 296             return;
 297         }
 298     }
 299
 300     if(!Script->GossipHello( _player, unit ))
 301     {
 302         _player->TalkedToCreature(unit->GetEntry(),unit->GetGUID());
 303         unit->prepareGossipMenu(_player);
 304         unit->sendPreparedGossip(_player);
 305     }
 306 }
 307
 308 void WorldSession::HandleGossipSelectOptionOpcode( WorldPacket & recv_data )
 309 {
 310     CHECK_PACKET_SIZE(recv_data,8+4+4);
 311
 312     sLog.outDebug("WORLD: CMSG_GOSSIP_SELECT_OPTION");
 313
 314     uint32 option;
 315     uint32 unk;
 316     uint64 guid;
 317     std::string code = "";
 318
 319     recv_data >> guid >> unk >> option;
 320
 321     if(_player->PlayerTalkClass->GossipOptionCoded( option ))
 322     {
 323         // recheck
 324         CHECK_PACKET_SIZE(recv_data,8+4+1);
 325         sLog.outBasic("reading string");
 326         recv_data >> code;
 327         sLog.outBasic("string read: %s", code.c_str());
 328     }
 329
 330     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid, UNIT_NPC_FLAG_NONE);
 331     if (!unit)
 332     {
 333         sLog.outDebug( "WORLD: HandleGossipSelectOptionOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 334         return;
 335     }
 336
 337     // remove fake death
 338     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 339         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 340
 341     if(!code.empty())
 342     {
 343         if (!Script->GossipSelectWithCode(_player, unit, _player->PlayerTalkClass->GossipOptionSender (option), _player->PlayerTalkClass->GossipOptionAction( option ), code.c_str()))
 344             unit->OnGossipSelect (_player, option);
 345     }
 346     else
 347     {
 348         if (!Script->GossipSelect (_player, unit, _player->PlayerTalkClass->GossipOptionSender (option), _player->PlayerTalkClass->GossipOptionAction (option)))
 349            unit->OnGossipSelect (_player, option);
 350     }
 351 }
 352
 353 void WorldSession::HandleSpiritHealerActivateOpcode( WorldPacket & recv_data )
 354 {
 355     CHECK_PACKET_SIZE(recv_data,8);
 356
 357     sLog.outDebug("WORLD: CMSG_SPIRIT_HEALER_ACTIVATE");
 358
 359     uint64 guid;
 360
 361     recv_data >> guid;
 362
 363     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, guid, UNIT_NPC_FLAG_SPIRITHEALER);
 364     if (!unit)
 365     {
 366         sLog.outDebug( "WORLD: HandleSpiritHealerActivateOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(guid)) );
 367         return;
 368     }
 369
 370     // remove fake death
 371     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 372         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 373
 374     SendSpiritResurrect();
 375 }
 376
 377 void WorldSession::SendSpiritResurrect()
 378 {
 379     _player->ResurrectPlayer(0.5f, true);
 380
 381     _player->DurabilityLossAll(0.25f,true);
 382
 383     // get corpse nearest graveyard
 384     WorldSafeLocsEntry const *corpseGrave = NULL;
 385     Corpse *corpse = _player->GetCorpse();
 386     if(corpse)
 387         corpseGrave = objmgr.GetClosestGraveYard(
 388             corpse->GetPositionX(), corpse->GetPositionY(), corpse->GetPositionZ(), corpse->GetMapId(), _player->GetTeam() );
 389
 390     // now can spawn bones
 391     _player->SpawnCorpseBones();
 392
 393     // teleport to nearest from corpse graveyard, if different from nearest to player ghost
 394     if(corpseGrave)
 395     {
 396         WorldSafeLocsEntry const *ghostGrave = objmgr.GetClosestGraveYard(
 397             _player->GetPositionX(), _player->GetPositionY(), _player->GetPositionZ(), _player->GetMapId(), _player->GetTeam() );
 398
 399         if(corpseGrave != ghostGrave)
 400             _player->TeleportTo(corpseGrave->map_id, corpseGrave->x, corpseGrave->y, corpseGrave->z, _player->GetOrientation());
 401         // or update at original position
 402         else
 403             ObjectAccessor::UpdateVisibilityForPlayer(_player);
 404     }
 405     // or update at original position
 406     else
 407         ObjectAccessor::UpdateVisibilityForPlayer(_player);
 408
 409     _player->SaveToDB();
 410 }
 411
 412 void WorldSession::HandleBinderActivateOpcode( WorldPacket & recv_data )
 413 {
 414     CHECK_PACKET_SIZE(recv_data,8);
 415
 416     uint64 npcGUID;
 417     recv_data >> npcGUID;
 418
 419     if(!GetPlayer()->isAlive())
 420         return;
 421
 422     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID,UNIT_NPC_FLAG_INNKEEPER);
 423     if (!unit)
 424     {
 425         sLog.outDebug( "WORLD: HandleBinderActivateOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 426         return;
 427     }
 428
 429     // remove fake death
 430     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 431         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 432
 433     SendBindPoint(unit);
 434 }
 435
 436 void WorldSession::SendBindPoint(Creature *npc)
 437 {
 438     uint32 bindspell = 3286;
 439
 440     // update sql homebind
 441     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());
 442     _player->m_homebindMapId = _player->GetMapId();
 443     _player->m_homebindZoneId = _player->GetZoneId();
 444     _player->m_homebindX = _player->GetPositionX();
 445     _player->m_homebindY = _player->GetPositionY();
 446     _player->m_homebindZ = _player->GetPositionZ();
 447
 448     // send spell for bind 3286 bind magic
 449     npc->CastSpell(_player, bindspell, true);
 450
 451     WorldPacket data( SMSG_TRAINER_BUY_SUCCEEDED, (8+4));
 452     data << npc->GetGUID();
 453     data << bindspell;
 454     SendPacket( &data );
 455
 456     // binding
 457     data.Initialize( SMSG_BINDPOINTUPDATE, (4+4+4+4+4) );
 458     data << float(_player->GetPositionX());
 459     data << float(_player->GetPositionY());
 460     data << float(_player->GetPositionZ());
 461     data << uint32(_player->GetMapId());
 462     data << uint32(_player->GetZoneId());
 463     SendPacket( &data );
 464
 465     DEBUG_LOG("New Home Position X is %f",_player->GetPositionX());
 466     DEBUG_LOG("New Home Position Y is %f",_player->GetPositionY());
 467     DEBUG_LOG("New Home Position Z is %f",_player->GetPositionZ());
 468     DEBUG_LOG("New Home MapId is %u",_player->GetMapId());
 469     DEBUG_LOG("New Home ZoneId is %u",_player->GetZoneId());
 470
 471     // zone update
 472     data.Initialize( SMSG_PLAYERBOUND, 8+4 );
 473     data << uint64(_player->GetGUID());
 474     data << uint32(_player->GetZoneId());
 475     SendPacket( &data );
 476
 477     _player->PlayerTalkClass->CloseGossip();
 478 }
 479
 480 //Need fix
 481 void WorldSession::HandleListStabledPetsOpcode( WorldPacket & recv_data )
 482 {
 483     CHECK_PACKET_SIZE(recv_data,8);
 484
 485     sLog.outDebug("WORLD: Recv MSG_LIST_STABLED_PETS");
 486     uint64 npcGUID;
 487
 488     recv_data >> npcGUID;
 489
 490     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_STABLEMASTER);
 491     if (!unit)
 492     {
 493         sLog.outDebug( "WORLD: HandleListStabledPetsOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 494         return;
 495     }
 496
 497     // remove fake death
 498     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 499         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 500
 501     SendStablePet(npcGUID);
 502 }
 503
 504 void WorldSession::SendStablePet(uint64 guid )
 505 {
 506     sLog.outDebug("WORLD: Recv MSG_LIST_STABLED_PETS Send.");
 507
 508     WorldPacket data(MSG_LIST_STABLED_PETS, 200);           // guess size
 509     data << uint64 ( guid );
 510
 511     Pet *pet = _player->GetPet();
 512
 513     data << uint8(0);                                       // place holder for slot show number
 514     data << uint8(GetPlayer()->m_stableSlots);
 515
 516     uint8 num = 0;                                          // counter for place holder
 517
 518     // not let move dead pet in slot
 519     if(pet && pet->isAlive() && pet->getPetType()==HUNTER_PET)
 520     {
 521         data << uint32(pet->GetCharmInfo()->GetPetNumber());
 522         data << uint32(pet->GetEntry());
 523         data << uint32(pet->getLevel());
 524         data << pet->GetName();                             // petname
 525         data << uint8(0x01);                                // flags?, client slot 1 == current pet (0)
 526         ++num;
 527     }
 528
 529     //                                                     0      1     2   3      4      5
 530     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());
 531
 532     if(result)
 533     {
 534         do
 535         {
 536             Field *fields = result->Fetch();
 537
 538             data << uint32(fields[2].GetUInt32());          // petnumber
 539             data << uint32(fields[3].GetUInt32());          // creature entry
 540             data << uint32(fields[4].GetUInt32());          // level
 541             data << fields[5].GetString();                  // name
 542             data << uint8(fields[1].GetUInt32()+1);         // slot
 543
 544             ++num;
 545         }while( result->NextRow() );
 546
 547         delete result;
 548     }
 549
 550     data.put<uint8>(8, num);                                // set real data to placeholder
 551     SendPacket(&data);
 552 }
 553
 554 void WorldSession::HandleStablePet( WorldPacket & recv_data )
 555 {
 556     CHECK_PACKET_SIZE(recv_data, 8);
 557
 558     sLog.outDebug("WORLD: Recv CMSG_STABLE_PET");
 559     uint64 npcGUID;
 560
 561     recv_data >> npcGUID;
 562
 563     if(!GetPlayer()->isAlive())
 564         return;
 565
 566     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_STABLEMASTER);
 567     if (!unit)
 568     {
 569         sLog.outDebug( "WORLD: HandleStablePet - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 570         return;
 571     }
 572
 573     // remove fake death
 574     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 575         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 576
 577     Pet *pet = _player->GetPet();
 578
 579     WorldPacket data(SMSG_STABLE_RESULT, 200);              // guess size
 580
 581     // can't place in stable dead pet
 582     if(!pet||!pet->isAlive()||pet->getPetType()!=HUNTER_PET)
 583     {
 584         data << uint8(0x06);
 585         SendPacket(&data);
 586         return;
 587     }
 588
 589     uint32 free_slot = 1;
 590
 591     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());
 592     if(result)
 593     {
 594         do
 595         {
 596             Field *fields = result->Fetch();
 597
 598             uint32 slot = fields[1].GetUInt32();
 599
 600             if(slot==free_slot)                             // this slot not free
 601                 ++free_slot;
 602         }while( result->NextRow() );
 603     }
 604     delete result;
 605
 606     if( free_slot > 0 && free_slot <= GetPlayer()->m_stableSlots)
 607     {
 608         _player->RemovePet(pet,PetSaveMode(free_slot));
 609         data << uint8(0x08);
 610     }
 611     else
 612         data << uint8(0x06);
 613
 614     SendPacket(&data);
 615 }
 616
 617 void WorldSession::HandleUnstablePet( WorldPacket & recv_data )
 618 {
 619     CHECK_PACKET_SIZE(recv_data, 8+4);
 620
 621     sLog.outDebug("WORLD: Recv CMSG_UNSTABLE_PET.");
 622     uint64 npcGUID;
 623     uint32 petnumber;
 624
 625     recv_data >> npcGUID >> petnumber;
 626
 627     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_STABLEMASTER);
 628     if (!unit)
 629     {
 630         sLog.outDebug( "WORLD: HandleUnstablePet - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 631         return;
 632     }
 633
 634     // remove fake death
 635     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 636         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 637
 638     WorldPacket data(SMSG_STABLE_RESULT, 200);              // guess size
 639
 640     Pet* pet = _player->GetPet();
 641     if(pet && pet->isAlive())
 642     {
 643         uint8 i = 0x06;
 644         data << uint8(i);
 645         SendPacket(&data);
 646         return;
 647     }
 648
 649     // delete dead pet
 650     if(pet)
 651         _player->RemovePet(pet,PET_SAVE_AS_DELETED);
 652
 653     Pet *newpet = NULL;
 654
 655     QueryResult *result = CharacterDatabase.PQuery("SELECT entry FROM character_pet WHERE owner = '%u' AND id = '%u' AND slot > 0 AND slot < 5",_player->GetGUIDLow(),petnumber);
 656     if(result)
 657     {
 658         Field *fields = result->Fetch();
 659         uint32 petentry = fields[0].GetUInt32();
 660
 661         newpet = new Pet(HUNTER_PET);
 662         if(!newpet->LoadPetFromDB(_player,petentry,petnumber))
 663         {
 664             delete newpet;
 665             newpet = NULL;
 666         }
 667         delete result;
 668     }
 669
 670     if(newpet)
 671         data << uint8(0x09);
 672     else
 673         data << uint8(0x06);
 674     SendPacket(&data);
 675 }
 676
 677 void WorldSession::HandleBuyStableSlot( WorldPacket & recv_data )
 678 {
 679     CHECK_PACKET_SIZE(recv_data, 8);
 680
 681     sLog.outDebug("WORLD: Recv CMSG_BUY_STABLE_SLOT.");
 682     uint64 npcGUID;
 683
 684     recv_data >> npcGUID;
 685
 686     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_STABLEMASTER);
 687     if (!unit)
 688     {
 689         sLog.outDebug( "WORLD: HandleBuyStableSlot - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 690         return;
 691     }
 692
 693     // remove fake death
 694     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 695         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 696
 697     WorldPacket data(SMSG_STABLE_RESULT, 200);
 698
 699     if(GetPlayer()->m_stableSlots < 4)                      // max slots amount = 4
 700     {
 701         StableSlotPricesEntry const *SlotPrice = sStableSlotPricesStore.LookupEntry(GetPlayer()->m_stableSlots+1);
 702         if(_player->GetMoney() >= SlotPrice->Price)
 703         {
 704             ++GetPlayer()->m_stableSlots;
 705             _player->ModifyMoney(-int32(SlotPrice->Price));
 706             data << uint8(0x0A);                            // success buy
 707         }
 708         else
 709             data << uint8(0x06);
 710     }
 711     else
 712         data << uint8(0x06);
 713
 714     SendPacket(&data);
 715 }
 716
 717 void WorldSession::HandleStableRevivePet( WorldPacket &/* recv_data */)
 718 {
 719     sLog.outDebug("HandleStableRevivePet: Not implemented");
 720 }
 721
 722 void WorldSession::HandleStableSwapPet( WorldPacket & recv_data )
 723 {
 724     CHECK_PACKET_SIZE(recv_data, 8+4);
 725
 726     sLog.outDebug("WORLD: Recv CMSG_STABLE_SWAP_PET.");
 727     uint64 npcGUID;
 728     uint32 pet_number;
 729
 730     recv_data >> npcGUID >> pet_number;
 731
 732     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_STABLEMASTER);
 733     if (!unit)
 734     {
 735         sLog.outDebug( "WORLD: HandleStableSwapPet - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 736         return;
 737     }
 738
 739     // remove fake death
 740     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 741         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 742
 743     WorldPacket data(SMSG_STABLE_RESULT, 200);              // guess size
 744
 745     Pet* pet = _player->GetPet();
 746
 747     if(!pet || pet->getPetType()!=HUNTER_PET)
 748         return;
 749
 750     // find swapped pet slot in stable
 751     QueryResult *result = CharacterDatabase.PQuery("SELECT slot,entry FROM character_pet WHERE owner = '%u' AND id = '%u'",_player->GetGUIDLow(),pet_number);
 752     if(!result)
 753         return;
 754
 755     Field *fields = result->Fetch();
 756
 757     uint32 slot     = fields[0].GetUInt32();
 758     uint32 petentry = fields[1].GetUInt32();
 759     delete result;
 760
 761     // move alive pet to slot or delele dead pet
 762     _player->RemovePet(pet,pet->isAlive() ? PetSaveMode(slot) : PET_SAVE_AS_DELETED);
 763
 764     // summon unstabled pet
 765     Pet *newpet = new Pet;
 766     if(!newpet->LoadPetFromDB(_player,petentry,pet_number))
 767     {
 768         delete newpet;
 769         data << uint8(0x06);
 770     }
 771     else
 772         data << uint8(0x09);
 773
 774     SendPacket(&data);
 775 }
 776
 777 void WorldSession::HandleRepairItemOpcode( WorldPacket & recv_data )
 778 {
 779     CHECK_PACKET_SIZE(recv_data, 8+8+1);
 780
 781     sLog.outDebug("WORLD: CMSG_REPAIR_ITEM");
 782
 783     uint64 npcGUID, itemGUID;
 784     uint8 guildBank;                                        // new in 2.3.2, bool that means from guild bank money
 785
 786     recv_data >> npcGUID >> itemGUID >> guildBank;
 787
 788     Creature *unit = ObjectAccessor::GetNPCIfCanInteractWith(*_player, npcGUID, UNIT_NPC_FLAG_REPAIR);
 789     if (!unit)
 790     {
 791         sLog.outDebug( "WORLD: HandleRepairItemOpcode - Unit (GUID: %u) not found or you can't interact with him.", uint32(GUID_LOPART(npcGUID)) );
 792         return;
 793     }
 794
 795     // remove fake death
 796     if(GetPlayer()->hasUnitState(UNIT_STAT_DIED))
 797         GetPlayer()->RemoveSpellsCausingAura(SPELL_AURA_FEIGN_DEATH);
 798
 799     // reputation discount
 800     float discountMod = _player->GetReputationPriceDiscount(unit);
 801
 802     uint32 TotalCost = 0;
 803     if (itemGUID)
 804     {
 805         sLog.outDebug("ITEM: Repair item, itemGUID = %u, npcGUID = %u", GUID_LOPART(itemGUID), GUID_LOPART(npcGUID));
 806
 807         Item* item = _player->GetItemByGuid(itemGUID);
 808
 809         if(item)
 810             TotalCost= _player->DurabilityRepair(item->GetPos(),true,discountMod,guildBank>0?true:false);
 811     }
 812     else
 813     {
 814         sLog.outDebug("ITEM: Repair all items, npcGUID = %u", GUID_LOPART(npcGUID));
 815
 816         TotalCost = _player->DurabilityRepairAll(true,discountMod,guildBank>0?true:false);
 817     }
 818     if (guildBank)
 819     {
 820         uint32 GuildId = _player->GetGuildId();
 821         if (!GuildId)
 822             return;
 823         Guild *pGuild = objmgr.GetGuildById(GuildId);
 824         if (!pGuild)
 825             return;
 826         pGuild->LogBankEvent(GUILD_BANK_LOG_REPAIR_MONEY, 0, _player->GetGUIDLow(), TotalCost);
 827         pGuild->SendMoneyInfo(this, _player->GetGUIDLow());
 828     }
 829 }