src/game/ObjectMgr.cpp

   1 /*
   2  * Copyright (C) 2005,2006 MaNGOS <http://www.mangosproject.org/>
   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 "Database/DatabaseEnv.h"
  21 #include "Database/SQLStorage.h"
  22
  23 #include "Log.h"
  24 #include "ObjectMgr.h"
  25 #include "UpdateMask.h"
  26 #include "World.h"
  27 #include "WorldSession.h"
  28 #include "Group.h"
  29 #include "Guild.h"
  30 #include "ProgressBar.cpp"
  31 #include "Policies/SingletonImp.h"
  32
  33 INSTANTIATE_SINGLETON_1(ObjectMgr);
  34
  35 extern SQLStorage sItemStorage;
  36 extern SQLStorage sGOStorage;
  37 extern SQLStorage sCreatureStorage;
  38
  39 ObjectMgr::ObjectMgr()
  40 {
  41     m_hiCharGuid = 1;
  42     m_hiCreatureGuid = 1;
  43     m_hiItemGuid = 1;
  44     m_hiGoGuid = 1;
  45     m_hiDoGuid = 1;
  46         m_hiCorpseGuid=1;
  47 }
  48
  49
  50 ObjectMgr::~ObjectMgr()
  51 {
  52
  53
  54
  55     for( QuestMap::iterator i = mQuests.begin( ); i != mQuests.end( ); ++ i )
  56     {
  57         delete i->second;
  58     }
  59     mQuests.clear( );
  60
  61
  62     for( GossipTextMap::iterator i = mGossipText.begin( ); i != mGossipText.end( ); ++ i )
  63     {
  64         delete i->second;
  65     }
  66     mGossipText.clear( );
  67
  68     for( AreaTriggerMap::iterator i = mAreaTriggerMap.begin( ); i != mAreaTriggerMap.end( ); ++ i )
  69     {
  70         delete i->second;
  71     }
  72     mAreaTriggerMap.clear( );
  73
  74
  75
  76 }
  77
  78
  79
  80
  81
  82
  83 Group * ObjectMgr::GetGroupByLeader(const uint64 &guid) const
  84 {
  85     GroupSet::const_iterator itr;
  86     for (itr = mGroupSet.begin(); itr != mGroupSet.end(); itr++)
  87     {
  88         if ((*itr)->GetLeaderGUID() == guid)
  89         {
  90             return *itr;
  91         }
  92     }
  93
  94     return NULL;
  95 }
  96
  97
  98
  99
 100 Guild * ObjectMgr::GetGuildById(const uint32 GuildId) const
 101 {
 102     GuildSet::const_iterator itr;
 103     for (itr = mGuildSet.begin(); itr != mGuildSet.end(); itr++)
 104     {
 105         if ((*itr)->GetId() == GuildId)
 106         {
 107             return *itr;
 108         }
 109     }
 110
 111     return NULL;
 112 }
 113
 114
 115
 116
 117 CreatureInfo *ObjectMgr::GetCreatureTemplate(uint32 id)
 118 {
 119         return (sCreatureStorage.iNumRecords<=id)?NULL:(CreatureInfo*)sCreatureStorage.pIndex[id];
 120 }
 121
 122
 123
 124
 125
 126
 127 void ObjectMgr::LoadCreatureTemplates()
 128 {
 129
 130         sCreatureStorage.Load();
 131
 132   sLog.outString( "" );
 133 //      sLog.outString( ">> Loaded %d creature definitions", count );
 134 //      sLog.outString( "" );
 135 }
 136
 137 PlayerCreateInfo* ObjectMgr::GetPlayerCreateInfo(uint32 race, uint32 class_)
 138 {
 139     uint32 createId;
 140
 141     Field *player_fields, *items_fields, *spells_fields, *skills_fields, *actions_fields;
 142     PlayerCreateInfo *pPlayerCreateInfo;
 143
 144     QueryResult *player_result = sDatabase.PQuery("SELECT * FROM playercreateinfo WHERE race = '%u' AND class = '%u';", race, class_);
 145
 146     if( !player_result )
 147         return NULL;
 148
 149     pPlayerCreateInfo = new PlayerCreateInfo;
 150
 151     player_fields = player_result->Fetch();
 152
 153     pPlayerCreateInfo->createId = player_fields[0].GetUInt8();
 154     createId = (uint32)pPlayerCreateInfo->createId;
 155     pPlayerCreateInfo->race = player_fields[1].GetUInt8();
 156     pPlayerCreateInfo->class_ = player_fields[2].GetUInt8();
 157     pPlayerCreateInfo->mapId = player_fields[3].GetUInt32();
 158     pPlayerCreateInfo->zoneId = player_fields[4].GetUInt32();
 159     pPlayerCreateInfo->positionX = player_fields[5].GetFloat();
 160     pPlayerCreateInfo->positionY = player_fields[6].GetFloat();
 161     pPlayerCreateInfo->positionZ = player_fields[7].GetFloat();
 162     pPlayerCreateInfo->displayId = player_fields[8].GetUInt16();
 163     pPlayerCreateInfo->strength = player_fields[9].GetUInt8();
 164     pPlayerCreateInfo->ability = player_fields[10].GetUInt8();
 165     pPlayerCreateInfo->stamina = player_fields[11].GetUInt8();
 166     pPlayerCreateInfo->intellect = player_fields[12].GetUInt8();
 167     pPlayerCreateInfo->spirit = player_fields[13].GetUInt8();
 168     pPlayerCreateInfo->basearmor = player_fields[14].GetUInt32();
 169     pPlayerCreateInfo->health = player_fields[15].GetUInt32();
 170     pPlayerCreateInfo->mana = player_fields[16].GetUInt32();
 171     pPlayerCreateInfo->rage = player_fields[17].GetUInt32();
 172     pPlayerCreateInfo->focus = player_fields[18].GetUInt32();
 173     pPlayerCreateInfo->energy = player_fields[19].GetUInt32();
 174     pPlayerCreateInfo->attackpower = player_fields[20].GetUInt32();
 175     pPlayerCreateInfo->mindmg = player_fields[21].GetFloat();
 176     pPlayerCreateInfo->maxdmg = player_fields[22].GetFloat();
 177     pPlayerCreateInfo->ranmindmg = player_fields[23].GetFloat();
 178     pPlayerCreateInfo->ranmaxdmg = player_fields[24].GetFloat();
 179
 180     delete player_result;
 181
 182     QueryResult *items_result = sDatabase.PQuery("SELECT * FROM playercreateinfo_items WHERE createId = '0' OR createId = '%u';", createId);
 183
 184     do {
 185                  if(!items_result) break;
 186                  items_fields = items_result->Fetch();
 187                  pPlayerCreateInfo->item_id.push_back(items_fields[1].GetUInt32());
 188                  pPlayerCreateInfo->item_bagIndex.push_back(items_fields[2].GetUInt32());
 189                  pPlayerCreateInfo->item_slot.push_back(items_fields[3].GetUInt8());
 190                  pPlayerCreateInfo->item_amount.push_back(items_fields[4].GetUInt32());
 191          } while (items_result->NextRow());
 192
 193     delete items_result;
 194
 195     QueryResult *spells_result = sDatabase.PQuery("SELECT * FROM playercreateinfo_spells WHERE createId = '0' OR createId = '%u';", createId);
 196
 197     do
 198     {
 199         if(!spells_result) break;
 200         spells_fields = spells_result->Fetch();
 201         pPlayerCreateInfo->spell.push_back(spells_fields[1].GetUInt16());
 202
 203     } while( spells_result->NextRow() );
 204
 205     delete spells_result;
 206
 207     QueryResult *skills_result = sDatabase.PQuery("SELECT * FROM playercreateinfo_skills WHERE createId = '0' OR createId = '%u';", createId);
 208
 209     do
 210     {
 211         if(!skills_result) break;
 212         skills_fields = skills_result->Fetch();
 213         pPlayerCreateInfo->skill[0].push_back(skills_fields[1].GetUInt16());
 214         pPlayerCreateInfo->skill[1].push_back(skills_fields[2].GetUInt16());
 215         pPlayerCreateInfo->skill[2].push_back(skills_fields[3].GetUInt16());
 216
 217     } while( skills_result->NextRow() );
 218
 219     delete skills_result;
 220
 221     QueryResult *actions_result = sDatabase.PQuery("SELECT * FROM playercreateinfo_actions WHERE createId = '0' OR createId = '%u';", createId);
 222
 223     do
 224     {
 225         if(!actions_result) break;
 226         actions_fields = actions_result->Fetch();
 227         pPlayerCreateInfo->action[0].push_back(actions_fields[1].GetUInt16());
 228         pPlayerCreateInfo->action[1].push_back(actions_fields[2].GetUInt16());
 229         pPlayerCreateInfo->action[2].push_back(actions_fields[3].GetUInt16());
 230         pPlayerCreateInfo->action[3].push_back(actions_fields[4].GetUInt16());
 231
 232     } while( actions_result->NextRow() );
 233
 234     delete actions_result;
 235
 236     return pPlayerCreateInfo;
 237 }
 238
 239 uint64 ObjectMgr::GetPlayerGUIDByName(const char *name) const
 240 {
 241
 242     uint64 guid = 0;
 243
 244     QueryResult *result = sDatabase.PQuery("SELECT guid FROM characters WHERE name = '%s';", name);
 245
 246     if(result)
 247     {
 248         guid = (*result)[0].GetUInt32();
 249
 250         delete result;
 251     }
 252
 253     return guid;
 254 }
 255
 256
 257 bool ObjectMgr::GetPlayerNameByGUID(const uint64 &guid, std::string &name) const
 258 {
 259
 260     QueryResult *result = sDatabase.PQuery("SELECT name FROM characters WHERE guid = '%d';", GUID_LOPART(guid));
 261
 262     if(result)
 263     {
 264         name = (*result)[0].GetString();
 265         delete result;
 266         return true;
 267     }
 268
 269     return false;
 270 }
 271
 272
 273 void ObjectMgr::LoadAuctions()
 274 {
 275     QueryResult *result = sDatabase.PQuery( "SELECT * FROM auctionhouse;" );
 276
 277     if( !result )
 278         return;
 279
 280     AuctionEntry *aItem;
 281
 282     do
 283     {
 284         Field *fields = result->Fetch();
 285
 286         aItem = new AuctionEntry;
 287         aItem->auctioneer = fields[0].GetUInt32();
 288         aItem->item = fields[1].GetUInt32();
 289         aItem->owner = fields[2].GetUInt32();
 290         aItem->buyout = fields[3].GetUInt32();
 291         aItem->time = fields[4].GetUInt32();
 292         aItem->bidder = fields[5].GetUInt32();
 293         aItem->bid = fields[6].GetUInt32();
 294         aItem->Id = fields[7].GetUInt32();
 295         AddAuction(aItem);
 296     } while (result->NextRow());
 297     delete result;
 298
 299 }
 300
 301
 302
 303 void ObjectMgr::LoadItemPrototypes()
 304 {
 305         sItemStorage.Load ();
 306         sLog.outString( ">> Loaded %u item prototypes", sItemStorage.iNumRecords);
 307 }
 308
 309 void ObjectMgr::LoadAuctionItems()
 310 {
 311     QueryResult *result = sDatabase.PQuery( "SELECT * FROM auctioned_items;" );
 312
 313     if( !result )
 314         return;
 315     Field *fields;
 316     do
 317     {
 318         fields = result->Fetch();
 319         Item* item = new Item;
 320         item->LoadFromDB(fields[0].GetUInt32(), 2);
 321         AddAItem(item);
 322     }
 323     while( result->NextRow() );
 324
 325     delete result;
 326 }
 327
 328
 329 void ObjectMgr::LoadMailedItems()
 330 {
 331     QueryResult *result = sDatabase.PQuery( "SELECT * FROM mailed_items;" );
 332
 333     if( !result )
 334         return;
 335     Field *fields;
 336     do
 337     {
 338         fields = result->Fetch();
 339         Item* item = new Item;
 340         item->LoadFromDB(fields[0].GetUInt32(), 3);
 341         AddMItem(item);
 342     }
 343     while( result->NextRow() );
 344
 345     delete result;
 346 }
 347
 348 void ObjectMgr::LoadGuilds()
 349 {
 350         Guild *newguild;
 351         QueryResult *result = sDatabase.PQuery( "SELECT guildId FROM guilds;" );
 352         uint32 count = 0;
 353
 354         if( !result )
 355         {
 356
 357                 barGoLink bar( 1 );
 358
 359                 bar.step();
 360
 361                 sLog.outString( "" );
 362                 sLog.outString( ">> Loaded %d guild definitions", count );
 363                 return;
 364         }
 365
 366
 367         barGoLink bar( result->GetRowCount() );
 368
 369         do
 370         {
 371                 Field *fields = result->Fetch();
 372
 373
 374                 bar.step();
 375                 count++;
 376
 377                 newguild = new Guild;
 378                 newguild->LoadGuildFromDB(fields[0].GetUInt32());
 379                 AddGuild(newguild);
 380
 381         }while( result->NextRow() );
 382
 383         sLog.outString( "" );
 384         sLog.outString( ">> Loaded %d guild definitions", count );
 385 }
 386
 387 void ObjectMgr::LoadQuests()
 388 {
 389         QueryResult *result = sDatabase.PQuery( "SELECT * FROM quests;" );
 390
 391     if( !result ) return;
 392
 393
 394         barGoLink bar( result->GetRowCount() );
 395
 396     Quest *pQuest;
 397         uint32 count = 0;
 398         int iCalc;
 399         int CiC;
 400
 401     do {
 402         Field *fields = result->Fetch();
 403
 404
 405                 bar.step();
 406
 407         pQuest = new Quest;
 408                 iCalc = 0;
 409
 410                 pQuest->m_qId        = fields[ iCalc++ ].GetUInt32();
 411                 pQuest->m_qCategory  = fields[ iCalc++ ].GetUInt32();
 412                 pQuest->m_qFlags     = fields[ iCalc++ ].GetUInt32();
 413
 414                 pQuest->m_qTitle         = fields[ iCalc++ ].GetString();
 415         pQuest->m_qDetails       = fields[ iCalc++ ].GetString();
 416         pQuest->m_qObjectives    = fields[ iCalc++ ].GetString();
 417
 418                 pQuest->m_qCompletionInfo  = fields[ iCalc++ ].GetString();
 419                 pQuest->m_qIncompleteInfo  = fields[ iCalc++ ].GetString();
 420                 pQuest->m_qEndInfo         = fields[ iCalc++ ].GetString();
 421
 422                 for (CiC = 0; CiC < QUEST_OBJECTIVES_COUNT; CiC++)
 423                         pQuest->m_qObjectiveInfo[CiC]    = fields[ iCalc++ ].GetString();
 424
 425                 pQuest->m_qPlayerLevel      = fields[ iCalc++ ].GetUInt32();
 426                 pQuest->m_qComplexityLevel  = fields[ iCalc++ ].GetUInt32();
 427
 428                 pQuest->m_qRequiredQuestsCount = fields[ iCalc++ ].GetUInt32();
 429                 for ( CiC = 0; CiC < QUEST_DEPLINK_COUNT; CiC++)
 430                 { pQuest->m_qRequiredQuests[CiC] = fields[ iCalc++ ].GetUInt32(); }
 431
 432         pQuest->m_qRequiredAbsQuestsCount = fields[ iCalc++ ].GetUInt32();
 433                 for ( CiC = 0; CiC < QUEST_DEPLINK_COUNT; CiC++)
 434                 { pQuest->m_qRequiredAbsQuests[CiC] = fields[ iCalc++ ].GetUInt32(); }
 435
 436                 pQuest->m_qLockerQuestsCount = fields[ iCalc++ ].GetUInt32();
 437                 for ( CiC = 0; CiC < QUEST_DEPLINK_COUNT; CiC++)
 438                 { pQuest->m_qLockerQuests[CiC] = fields[ iCalc++ ].GetUInt32(); }
 439
 440                 for (CiC = 0; CiC < QUEST_OBJECTIVES_COUNT; CiC++)
 441                         pQuest->m_qObjItemId[CiC]    = fields[ iCalc++ ].GetUInt32();
 442
 443                 for (CiC = 0; CiC < QUEST_OBJECTIVES_COUNT; CiC++)
 444                         pQuest->m_qObjItemCount[CiC]    = fields[ iCalc++ ].GetUInt32();
 445
 446                 for (CiC = 0; CiC < QUEST_OBJECTIVES_COUNT; CiC++)
 447                         pQuest->m_qObjMobId[CiC]    = fields[ iCalc++ ].GetUInt32();
 448
 449                 for (CiC = 0; CiC < QUEST_OBJECTIVES_COUNT; CiC++)
 450                         pQuest->m_qObjMobCount[CiC]    = fields[ iCalc++ ].GetUInt32();
 451
 452
 453                 pQuest->m_qRewChoicesCount = fields[ iCalc++ ].GetUInt32();
 454                 for ( CiC = 0; CiC < QUEST_REWARD_CHOICES_COUNT; CiC++)
 455                 { pQuest->m_qRewChoicesItemId[CiC] = fields[ iCalc++ ].GetUInt32(); }
 456
 457                 for ( CiC = 0; CiC < QUEST_REWARD_CHOICES_COUNT; CiC++)
 458                 { pQuest->m_qRewChoicesItemCount[CiC] = fields[ iCalc++ ].GetUInt32(); }
 459
 460                 pQuest->m_qRewCount = fields[ iCalc++ ].GetUInt32();
 461                 for ( CiC = 0; CiC < QUEST_REWARDS_COUNT; CiC++)
 462                 { pQuest->m_qRewItemId[CiC] = fields[ iCalc++ ].GetUInt32(); }
 463
 464                 for ( CiC = 0; CiC < QUEST_REWARDS_COUNT; CiC++)
 465                 { pQuest->m_qRewItemCount[CiC] = fields[ iCalc++ ].GetUInt32(); }
 466
 467
 468                 pQuest->m_qRewMoney         = fields[ iCalc++ ].GetUInt32();
 469                 pQuest->m_qObjRepFaction_1  = fields[ iCalc++ ].GetUInt32();
 470         pQuest->m_qObjRepFaction_2  = fields[ iCalc++ ].GetUInt32();
 471                 pQuest->m_qObjRepValue_1    = fields[ iCalc++ ].GetUInt32();
 472         pQuest->m_qObjRepValue_2    = fields[ iCalc++ ].GetUInt32();
 473
 474                 pQuest->m_qQuestItem     = fields[ iCalc++ ].GetUInt32();
 475                 pQuest->m_qNextQuestId   = fields[ iCalc++ ].GetUInt32();
 476                 pQuest->m_qRewSpell      = fields[ iCalc++ ].GetUInt32();
 477                 pQuest->m_qObjTime       = fields[ iCalc++ ].GetUInt32();
 478
 479                 pQuest->m_qType          = fields[ iCalc++ ].GetUInt32();
 480                 pQuest->m_qRequiredRaces = fields[ iCalc++ ].GetUInt32();
 481                 pQuest->m_qRequiredClass = fields[ iCalc++ ].GetUInt32();
 482                 pQuest->m_qRequiredTradeskill   = fields[ iCalc++ ].GetUInt32();
 483                 pQuest->m_qSpecialFlags  = fields[ iCalc++ ].GetUInt32();
 484
 485                 pQuest->m_qPointId               = fields[ iCalc++ ].GetUInt32();
 486                 pQuest->m_qPointX        = fields[ iCalc++ ].GetFloat();
 487                 pQuest->m_qPointY                = fields[ iCalc++ ].GetFloat();
 488                 pQuest->m_qPointOpt              = fields[ iCalc++ ].GetUInt32();
 489
 490                 count++;
 491         AddQuest(pQuest);
 492     }
 493     while( result->NextRow() );
 494
 495     delete result;
 496
 497         // points all quests for their next quest
 498         for( QuestMap::iterator i = mQuests.begin( ); i != mQuests.end( ); i++ )
 499     {
 500         i->second->m_qNextQuest = objmgr.GetQuest( i->second->m_qNextQuestId );
 501     }
 502
 503
 504         sLog.outString( "" );
 505         sLog.outString( ">> Loaded %d quest definitions", count );
 506 }
 507
 508
 509
 510 void ObjectMgr::AddGossipText(GossipText *pGText)
 511 {
 512         ASSERT( pGText->Text_ID );
 513     ASSERT( mGossipText.find(pGText->Text_ID) == mGossipText.end() );
 514     mGossipText[pGText->Text_ID] = pGText;
 515 }
 516
 517
 518 GossipText *ObjectMgr::GetGossipText(uint32 Text_ID)
 519 {
 520     GossipTextMap::const_iterator itr;
 521     for (itr = mGossipText.begin(); itr != mGossipText.end(); itr++)
 522     {
 523         if(itr->second->Text_ID == Text_ID)
 524             return itr->second;
 525     }
 526     return NULL;
 527 }
 528
 529
 530 void ObjectMgr::LoadGossipText()
 531 {
 532         GossipText *pGText;
 533         QueryResult *result = sDatabase.PQuery( "SELECT * FROM npc_text;" );
 534
 535         int count = 0;
 536         if( !result ) return;
 537         int cic;
 538
 539
 540         barGoLink bar( result->GetRowCount() );
 541
 542         do {
 543                 count++;
 544                 cic = 0;
 545
 546                 Field *fields = result->Fetch();
 547
 548
 549                 bar.step();
 550
 551                 pGText = new GossipText;
 552                 pGText->Text_ID    = fields[cic++].GetUInt32();
 553
 554                 for (int i=0; i< 8; i++)
 555                 {
 556                         pGText->Options[i].Text_0           = fields[cic++].GetString();
 557                         pGText->Options[i].Text_1           = fields[cic++].GetString();
 558
 559                         pGText->Options[i].Language         = fields[cic++].GetUInt32();
 560                         pGText->Options[i].Probability      = fields[cic++].GetFloat();
 561
 562                         pGText->Options[i].Emotes[0]._Delay  = fields[cic++].GetUInt32();
 563                         pGText->Options[i].Emotes[0]._Emote  = fields[cic++].GetUInt32();
 564
 565                         pGText->Options[i].Emotes[1]._Delay  = fields[cic++].GetUInt32();
 566                         pGText->Options[i].Emotes[1]._Emote  = fields[cic++].GetUInt32();
 567
 568                         pGText->Options[i].Emotes[2]._Delay  = fields[cic++].GetUInt32();
 569                         pGText->Options[i].Emotes[2]._Emote  = fields[cic++].GetUInt32();
 570                 }
 571
 572                 if ( !pGText->Text_ID ) continue;
 573                 AddGossipText( pGText );
 574
 575         } while( result->NextRow() );
 576
 577         sLog.outString( "" );
 578         sLog.outString( ">> Loaded %d npc texts", count );
 579         delete result;
 580 }
 581
 582
 583 ItemPage *ObjectMgr::RetreiveItemPageText(uint32 Page_ID)
 584 {
 585         ItemPage *pIText;
 586         QueryResult *result = sDatabase.PQuery("SELECT * FROM item_pages WHERE ID = '%d';", Page_ID);
 587
 588         if( !result ) return NULL;
 589         int cic, count = 0;
 590         pIText = new ItemPage;
 591
 592         do {
 593                 count++;
 594                 cic = 0;
 595
 596                 Field *fields = result->Fetch();
 597
 598
 599                 pIText->Page_ID    = fields[cic++].GetUInt32();
 600
 601                 pIText->PageText   = fields[cic++].GetString();
 602                 pIText->Next_Page  = fields[cic++].GetUInt32();
 603
 604                 if ( !pIText->Page_ID ) break;
 605         } while( result->NextRow() );
 606
 607         delete result;
 608         return pIText;
 609 }
 610
 611
 612 void ObjectMgr::AddAreaTriggerPoint(AreaTriggerPoint *pArea)
 613 {
 614         ASSERT( pArea->Trigger_ID );
 615         ASSERT( mAreaTriggerMap.find(pArea->Trigger_ID) == mAreaTriggerMap.end() );
 616
 617         mAreaTriggerMap[pArea->Trigger_ID] = pArea;
 618 }
 619
 620
 621 AreaTriggerPoint *ObjectMgr::GetAreaTriggerQuestPoint(uint32 Trigger_ID)
 622 {
 623     AreaTriggerMap::const_iterator itr;
 624     for (itr = mAreaTriggerMap.begin(); itr != mAreaTriggerMap.end(); itr++)
 625     {
 626         if(itr->second->Trigger_ID == Trigger_ID)
 627             return itr->second;
 628     }
 629     return NULL;
 630 }
 631
 632
 633 void ObjectMgr::LoadAreaTriggerPoints()
 634 {
 635         int count = 0;
 636         QueryResult *result = sDatabase.PQuery( "SELECT * FROM triggerquestrelation;" );
 637         AreaTriggerPoint *pArea;
 638
 639         if( !result ) return;
 640
 641
 642         barGoLink bar( result->GetRowCount() );
 643
 644         do {
 645                 count++;
 646
 647
 648                 bar.step();
 649
 650                 pArea = new AreaTriggerPoint;
 651
 652                 Field *fields = result->Fetch();
 653
 654
 655
 656                 pArea->Trigger_ID      = fields[0].GetUInt32();
 657                 pArea->Quest_ID        = fields[1].GetUInt32();
 658                 pArea->Creature_ID     = fields[2].GetUInt32();
 659
 660                 AddAreaTriggerPoint( pArea );
 661
 662         } while( result->NextRow() );
 663
 664         sLog.outString( "" );
 665         sLog.outString( ">> Loaded %d quest trigger points", count );
 666         delete result;
 667 }
 668
 669
 670
 671 bool ObjectMgr::GetGlobalTaxiNodeMask( uint32 curloc, uint32 *Mask )
 672 {
 673
 674     QueryResult *result = sDatabase.PQuery("SELECT taxipath.destination FROM taxipath WHERE taxipath.source = '%d' ORDER BY destination LIMIT 1;", curloc);
 675
 676     if( ! result )
 677     {
 678         return 1;
 679     }
 680     Field *fields = result->Fetch();
 681     uint8 destination = fields[0].GetUInt8();
 682     uint8 field = (uint8)((destination - 1) / 32);
 683     Mask[field] |= 1 << ( (destination - 1 ) % 32 );
 684
 685     return 1;
 686 }
 687
 688
 689 uint32 ObjectMgr::GetNearestTaxiNode( float x, float y, float z, uint32 mapid )
 690 {
 691
 692     QueryResult *result = sDatabase.PQuery("SELECT taxinodes.ID, SQRT(pow(taxinodes.x-'%f',2)+pow(taxinodes.y-'%f',2)+pow(taxinodes.z-'%f',2)) as distance FROM taxinodes WHERE taxinodes.continent = '%u' ORDER BY distance LIMIT 1;", x, y, z, mapid);
 693
 694     if( ! result  )
 695     {
 696         return 0;
 697     }
 698     Field *fields = result->Fetch();
 699     return fields[0].GetUInt8();
 700
 701
 702 }
 703
 704
 705 void ObjectMgr::GetTaxiPath( uint32 source, uint32 destination, uint32 &path, uint32 &cost)
 706 {
 707
 708     QueryResult *result = sDatabase.PQuery("SELECT taxipath.price, taxipath.ID FROM taxipath WHERE taxipath.source = '%u' AND taxipath.destination = '%u';", source, destination);
 709
 710     if( ! result )
 711     {
 712         path = 0;
 713         cost = 0;
 714         return;
 715     }
 716     Field *fields = result->Fetch();
 717     cost = fields[0].GetUInt32();
 718     path = fields[1].GetUInt16();
 719 }
 720
 721
 722 uint16 ObjectMgr::GetTaxiMount( uint32 id )
 723 {
 724
 725     QueryResult *result = sDatabase.PQuery("SELECT taxinodes.mount FROM taxinodes WHERE taxinodes.ID = '%u';", id);
 726
 727     if( ! result )
 728     {
 729         return 0;
 730     }
 731
 732     Field *fields = result->Fetch();
 733     return fields[0].GetUInt16();
 734
 735
 736 }
 737
 738
 739 void ObjectMgr::GetTaxiPathNodes( uint32 path, Path &pathnodes )
 740 {
 741
 742     QueryResult *result = sDatabase.PQuery("SELECT taxipathnodes.X, taxipathnodes.Y, taxipathnodes.Z FROM taxipathnodes WHERE taxipathnodes.path = '%u';", path);
 743
 744     if( ! result )
 745         return;
 746
 747     uint16 count = result->GetRowCount();
 748     sLog.outDebug(" ROW COUNT %u ",count);
 749     pathnodes.Resize( count );
 750     unsigned int i = 0;
 751
 752     do
 753     {
 754         Field *fields = result->Fetch();
 755         pathnodes[ i ].x = fields[0].GetFloat();
 756         pathnodes[ i ].y = fields[1].GetFloat();
 757         pathnodes[ i ].z = fields[2].GetFloat();
 758         i++;
 759     } while( result->NextRow() );
 760 }
 761
 762
 763 GraveyardTeleport *ObjectMgr::GetClosestGraveYard(float x, float y, float z, uint32 MapId)
 764 {
 765
 766     QueryResult *result = sDatabase.PQuery("SELECT SQRT(POW('%f'-X,2)+POW('%f'-Y,2)+POW('%f'-Z,2)) as distance,X,Y,Z,mapId from graveyards where mapId = '%d' ORDER BY distance ASC LIMIT 1;", x, y, z, MapId);
 767
 768     if( ! result )
 769         return NULL;
 770
 771     Field *fields = result->Fetch();
 772     GraveyardTeleport *pgrave = new GraveyardTeleport;
 773
 774     pgrave->X = fields[1].GetFloat();
 775     pgrave->Y = fields[2].GetFloat();
 776     pgrave->Z = fields[3].GetFloat();
 777     pgrave->MapId = fields[4].GetUInt32();
 778
 779     return pgrave;
 780 }
 781
 782 AreaTrigger *ObjectMgr::GetAreaTrigger(uint32 Trigger_ID)
 783 {
 784
 785     QueryResult *result = sDatabase.PQuery("SELECT triggerID FROM areatrigger WHERE triggerID = '%d';", Trigger_ID);
 786
 787     if ( result )
 788     {
 789         Field *fields = result->Fetch();
 790         uint32 totrigger = fields[0].GetUInt32();
 791         if( totrigger != 0)
 792         {
 793
 794             QueryResult *result1 = sDatabase.PQuery("SELECT TargetMapID,TargetPosX,TargetPosY,TargetPosZ FROM areatrigger WHERE triggerID = '%d';", totrigger);
 795             if ( result1 )
 796             {
 797                 Field *fields1 = result1->Fetch();
 798                 AreaTrigger *at = new AreaTrigger;
 799
 800                 at->mapId = fields1[0].GetUInt32();
 801
 802                 at->X = fields1[1].GetFloat();
 803                 at->Y = fields1[2].GetFloat();
 804                 at->Z = fields1[3].GetFloat();
 805
 806                 return at;
 807             }
 808         }
 809     }
 810     return NULL;
 811 }
 812
 813 void ObjectMgr::LoadTeleportCoords()
 814 {
 815
 816     QueryResult *result = sDatabase.PQuery( "SELECT * FROM areatrigger;" );
 817
 818     if( !result )
 819         return;
 820
 821         uint32 count = 0;
 822
 823     TeleportCoords *pTC;
 824
 825
 826     barGoLink bar( result->GetRowCount() );
 827
 828     do
 829     {
 830         Field *fields = result->Fetch();
 831
 832         bar.step();
 833
 834                 count++;
 835
 836         pTC = new TeleportCoords;
 837         pTC->id = fields[0].GetUInt32();
 838                 //pTC->Name = fields[6].GetString();
 839         pTC->mapId = fields[5].GetUInt32();
 840         pTC->x = fields[1].GetFloat();
 841         pTC->y = fields[2].GetFloat();
 842         pTC->z = fields[3].GetFloat();
 843
 844         AddTeleportCoords(pTC);
 845
 846     } while( result->NextRow() );
 847
 848     delete result;
 849
 850         sLog.outString( "" );
 851         sLog.outString( ">> Loaded %d teleport definitions", count );
 852 }
 853
 854
 855 void ObjectMgr::SetHighestGuids()
 856 {
 857
 858     QueryResult *result = sDatabase.Query( "SELECT MAX(guid) FROM characters;" );
 859     if( result )
 860     {
 861         m_hiCharGuid = (*result)[0].GetUInt32()+1;
 862
 863         delete result;
 864     }
 865
 866     result = sDatabase.Query( "SELECT MAX(guid) FROM creatures;" );
 867     if( result )
 868     {
 869         m_hiCreatureGuid = (*result)[0].GetUInt32()+1;
 870
 871         delete result;
 872     }
 873
 874     result = sDatabase.Query( "SELECT MAX(guid) FROM item_instances;" );
 875     if( result )
 876     {
 877         m_hiItemGuid = (*result)[0].GetUInt32()+1;
 878
 879         delete result;
 880     }
 881
 882
 883
 884     result = sDatabase.Query("SELECT MAX(guid) FROM gameobjects;" );
 885     if( result )
 886     {
 887         m_hiGoGuid = (*result)[0].GetUInt32()+1;
 888
 889         delete result;
 890     }
 891
 892     result = sDatabase.Query("SELECT MAX(id) FROM auctionhouse;" );
 893     if( result )
 894     {
 895         m_auctionid = (*result)[0].GetUInt32()+1;
 896
 897         delete result;
 898     }
 899     else
 900     {
 901         m_auctionid = 0;
 902     }
 903     result = sDatabase.PQuery( "SELECT MAX(mailid) FROM mail;" );
 904     if( result )
 905     {
 906         m_mailid = (*result)[0].GetUInt32()+1;
 907
 908         delete result;
 909     }
 910     else
 911     {
 912         m_mailid = 0;
 913     }
 914
 915     result = sDatabase.PQuery( "SELECT MAX(guid) FROM corpses;" );
 916     if( result )
 917     {
 918         m_hiCorpseGuid = (*result)[0].GetUInt32()+1;
 919
 920         delete result;
 921     }
 922
 923 }
 924
 925
 926 uint32 ObjectMgr::GenerateAuctionID()
 927 {
 928
 929     return ++m_auctionid;
 930 }
 931
 932
 933 uint32 ObjectMgr::GenerateMailID()
 934 {
 935     return ++m_mailid;
 936 }
 937
 938
 939 uint32 ObjectMgr::GenerateLowGuid(uint32 guidhigh)
 940 {
 941
 942
 943     switch(guidhigh)
 944     {
 945         case HIGHGUID_ITEM          : return ++m_hiItemGuid;
 946                 case HIGHGUID_UNIT          : return ++m_hiCreatureGuid;
 947         case HIGHGUID_PLAYER        : return ++m_hiCharGuid;
 948         case HIGHGUID_GAMEOBJECT    : return ++m_hiGoGuid;
 949         case HIGHGUID_CORPSE        : return ++m_hiCorpseGuid;
 950         case HIGHGUID_DYNAMICOBJECT : return ++m_hiDoGuid;
 951         default                     : ASSERT(0);
 952     }
 953
 954         return 0;
 955 }
 956
 957
 958
 959
 960
 961 GameObjectInfo *ObjectMgr::GetGameObjectInfo(uint32 id)
 962 {
 963         //debug
 964         if(sGOStorage.iNumRecords<=id)
 965         {
 966                 sLog.outString("ERROR: There is no GO with proto %u id the DB",id);
 967                 return NULL;
 968         }
 969
 970         return (sGOStorage.iNumRecords<=id)?NULL:(GameObjectInfo *)sGOStorage.pIndex[id];
 971
 972 }
 973
 974 void ObjectMgr::LoadGameobjectInfo()
 975 {
 976         sGOStorage.Load();
 977
 978         sLog.outString( ">> Loaded %d game object templates", sGOStorage.iNumRecords );
 979
 980 }
 981
 982
 983
 984 ItemPrototype* ObjectMgr::GetItemPrototype(uint32 id)
 985 {
 986         return (sItemStorage.iNumRecords<=id)?NULL:(ItemPrototype*)sItemStorage.pIndex[id];
 987 }