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