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 extern SQLStorage sQuestsStorage;
  39
  40 ObjectMgr::ObjectMgr()
  41 {
  42     m_hiCharGuid = 1;
  43     m_hiCreatureGuid = 1;
  44     m_hiItemGuid = 1;
  45     m_hiGoGuid = 1;
  46     m_hiDoGuid = 1;
  47     m_hiCorpseGuid=1;
  48 }
  49
  50 ObjectMgr::~ObjectMgr()
  51 {
  52
  53     for( QuestMap::iterator i = mQuests.begin( ); i != mQuests.end( ); ++ i )
  54     {
  55         delete i->second;
  56     }
  57     mQuests.clear( );
  58
  59     for( GossipTextMap::iterator i = mGossipText.begin( ); i != mGossipText.end( ); ++ i )
  60     {
  61         delete i->second;
  62     }
  63     mGossipText.clear( );
  64
  65     for( AreaTriggerMap::iterator i = mAreaTriggerMap.begin( ); i != mAreaTriggerMap.end( ); ++ i )
  66     {
  67         delete i->second;
  68     }
  69     mAreaTriggerMap.clear( );
  70
  71 }
  72
  73 Group * ObjectMgr::GetGroupByLeader(const uint64 &guid) const
  74 {
  75     GroupSet::const_iterator itr;
  76     for (itr = mGroupSet.begin(); itr != mGroupSet.end(); itr++)
  77     {
  78         if ((*itr)->GetLeaderGUID() == guid)
  79         {
  80             return *itr;
  81         }
  82     }
  83
  84     return NULL;
  85 }
  86
  87 Guild * ObjectMgr::GetGuildById(const uint32 GuildId) const
  88 {
  89     GuildSet::const_iterator itr;
  90     for (itr = mGuildSet.begin(); itr != mGuildSet.end(); itr++)
  91     {
  92         if ((*itr)->GetId() == GuildId)
  93         {
  94             return *itr;
  95         }
  96     }
  97
  98     return NULL;
  99 }
 100
 101 CreatureInfo *ObjectMgr::GetCreatureTemplate(uint32 id)
 102 {
 103     return (sCreatureStorage.MaxEntry<=id)?NULL:(CreatureInfo*)sCreatureStorage.pIndex[id];
 104 }
 105
 106 void ObjectMgr::LoadCreatureTemplates()
 107 {
 108
 109     sCreatureStorage.Load();
 110
 111     sLog.outString( ">> Loaded %d creature definitions", sCreatureStorage.RecordCount );
 112     sLog.outString( "" );
 113 }
 114
 115 PlayerCreateInfo* ObjectMgr::GetPlayerCreateInfo(uint32 race, uint32 class_)
 116 {
 117     uint32 createId;
 118
 119     Field *player_fields, *items_fields, *spells_fields, *skills_fields, *actions_fields;
 120     PlayerCreateInfo *pPlayerCreateInfo;
 121
 122     QueryResult *player_result = sDatabase.PQuery("SELECT * FROM `playercreateinfo` WHERE `race` = '%u' AND `class` = '%u';", race, class_);
 123
 124     if(!player_result)
 125     {
 126         sLog.outError("Warning: Can't get info for player creating with race %d and class %d (table 'playercreateinfo' is empty?)", race, class_);
 127         return NULL;
 128     }
 129
 130     pPlayerCreateInfo = new PlayerCreateInfo;
 131
 132     player_fields = player_result->Fetch();
 133
 134     pPlayerCreateInfo->createId = player_fields[0].GetUInt8();
 135     createId = (uint32)pPlayerCreateInfo->createId;
 136     pPlayerCreateInfo->race = player_fields[1].GetUInt8();
 137     pPlayerCreateInfo->class_ = player_fields[2].GetUInt8();
 138     pPlayerCreateInfo->mapId = player_fields[3].GetUInt32();
 139     pPlayerCreateInfo->zoneId = player_fields[4].GetUInt32();
 140     pPlayerCreateInfo->positionX = player_fields[5].GetFloat();
 141     pPlayerCreateInfo->positionY = player_fields[6].GetFloat();
 142     pPlayerCreateInfo->positionZ = player_fields[7].GetFloat();
 143     pPlayerCreateInfo->displayId = player_fields[8].GetUInt16();
 144     pPlayerCreateInfo->strength = player_fields[9].GetUInt8();
 145     pPlayerCreateInfo->ability = player_fields[10].GetUInt8();
 146     pPlayerCreateInfo->stamina = player_fields[11].GetUInt8();
 147     pPlayerCreateInfo->intellect = player_fields[12].GetUInt8();
 148     pPlayerCreateInfo->spirit = player_fields[13].GetUInt8();
 149     pPlayerCreateInfo->basearmor = player_fields[14].GetUInt32();
 150     pPlayerCreateInfo->health = player_fields[15].GetUInt32();
 151     pPlayerCreateInfo->mana = player_fields[16].GetUInt32();
 152     pPlayerCreateInfo->rage = player_fields[17].GetUInt32();
 153     pPlayerCreateInfo->focus = player_fields[18].GetUInt32();
 154     pPlayerCreateInfo->energy = player_fields[19].GetUInt32();
 155     pPlayerCreateInfo->attackpower = player_fields[20].GetUInt32();
 156     pPlayerCreateInfo->mindmg = player_fields[21].GetFloat();
 157     pPlayerCreateInfo->maxdmg = player_fields[22].GetFloat();
 158     pPlayerCreateInfo->ranmindmg = player_fields[23].GetFloat();
 159     pPlayerCreateInfo->ranmaxdmg = player_fields[24].GetFloat();
 160
 161     delete player_result;
 162
 163     QueryResult *items_result = sDatabase.PQuery("SELECT * FROM `playercreateinfo_item` WHERE `createid` = '0' OR `createid` = '%u';", createId);
 164
 165     do
 166     {
 167         if(!items_result) break;
 168         items_fields = items_result->Fetch();
 169         pPlayerCreateInfo->item_id.push_back(items_fields[1].GetUInt32());
 170         pPlayerCreateInfo->item_bagIndex.push_back(items_fields[2].GetUInt32());
 171         pPlayerCreateInfo->item_slot.push_back(items_fields[3].GetUInt8());
 172         pPlayerCreateInfo->item_amount.push_back(items_fields[4].GetUInt32());
 173     } while (items_result->NextRow());
 174
 175     delete items_result;
 176
 177     QueryResult *spells_result = sDatabase.PQuery("SELECT * FROM `playercreateinfo_spell` WHERE `createid` = '0' OR `createid` = '%u';", createId);
 178
 179     do
 180     {
 181         if(!spells_result) break;
 182         spells_fields = spells_result->Fetch();
 183         pPlayerCreateInfo->spell.push_back(spells_fields[1].GetUInt16());
 184
 185     } while( spells_result->NextRow() );
 186
 187     delete spells_result;
 188
 189     QueryResult *skills_result = sDatabase.PQuery("SELECT * FROM `playercreateinfo_skill` WHERE `createid` = '0' OR `createid` = '%u';", createId);
 190
 191     do
 192     {
 193         if(!skills_result) break;
 194         skills_fields = skills_result->Fetch();
 195         pPlayerCreateInfo->skill[0].push_back(skills_fields[1].GetUInt16());
 196         pPlayerCreateInfo->skill[1].push_back(skills_fields[2].GetUInt16());
 197         pPlayerCreateInfo->skill[2].push_back(skills_fields[3].GetUInt16());
 198
 199     } while( skills_result->NextRow() );
 200
 201     delete skills_result;
 202
 203     QueryResult *actions_result = sDatabase.PQuery("SELECT * FROM `playercreateinfo_action` WHERE `createid` = '0' OR `createid` = '%u';", createId);
 204
 205     do
 206     {
 207         if(!actions_result) break;
 208         actions_fields = actions_result->Fetch();
 209         pPlayerCreateInfo->action[0].push_back(actions_fields[1].GetUInt16());
 210         pPlayerCreateInfo->action[1].push_back(actions_fields[2].GetUInt16());
 211         pPlayerCreateInfo->action[2].push_back(actions_fields[3].GetUInt16());
 212         pPlayerCreateInfo->action[3].push_back(actions_fields[4].GetUInt16());
 213
 214     } while( actions_result->NextRow() );
 215
 216     delete actions_result;
 217
 218     return pPlayerCreateInfo;
 219 }
 220
 221 uint64 ObjectMgr::GetPlayerGUIDByName(const char *name) const
 222 {
 223
 224     uint64 guid = 0;
 225
 226     QueryResult *result = sDatabase.PQuery("SELECT `guid` FROM `character` WHERE `name` = '%s';", name);
 227
 228     if(result)
 229     {
 230         guid = (*result)[0].GetUInt32();
 231
 232         delete result;
 233     }
 234
 235     return guid;
 236 }
 237
 238 bool ObjectMgr::GetPlayerNameByGUID(const uint64 &guid, std::string &name) const
 239 {
 240
 241     QueryResult *result = sDatabase.PQuery("SELECT `name` FROM `character` WHERE `guid` = '%d';", GUID_LOPART(guid));
 242
 243     if(result)
 244     {
 245         name = (*result)[0].GetString();
 246         delete result;
 247         return true;
 248     }
 249
 250     return false;
 251 }
 252
 253 void ObjectMgr::LoadAuctions()
 254 {
 255     QueryResult *result = sDatabase.PQuery( "SELECT * FROM `auctionhouse`;" );
 256
 257     if( !result )
 258         return;
 259
 260     AuctionEntry *aItem;
 261
 262     do
 263     {
 264         Field *fields = result->Fetch();
 265
 266         aItem = new AuctionEntry;
 267         aItem->auctioneer = fields[0].GetUInt32();
 268         aItem->item = fields[1].GetUInt32();
 269         aItem->owner = fields[2].GetUInt32();
 270         aItem->buyout = fields[3].GetUInt32();
 271         aItem->time = fields[4].GetUInt32();
 272         aItem->bidder = fields[5].GetUInt32();
 273         aItem->bid = fields[6].GetUInt32();
 274         aItem->Id = fields[7].GetUInt32();
 275         AddAuction(aItem);
 276     } while (result->NextRow());
 277     delete result;
 278
 279 }
 280
 281 void ObjectMgr::LoadItemPrototypes()
 282 {
 283     sItemStorage.Load ();
 284     sLog.outString( ">> Loaded %u item prototypes", sItemStorage.RecordCount);
 285     sLog.outString("");
 286 }
 287
 288 void ObjectMgr::LoadAuctionItems()
 289 {
 290     QueryResult *result = sDatabase.PQuery( "SELECT * `FROM auctioned_item`;" );
 291
 292     if( !result )
 293         return;
 294     Field *fields;
 295     do
 296     {
 297         fields = result->Fetch();
 298         Item* item = new Item;
 299         item->LoadFromDB(fields[0].GetUInt32(), 2);
 300         AddAItem(item);
 301     }
 302     while( result->NextRow() );
 303
 304     delete result;
 305 }
 306
 307 void ObjectMgr::LoadMailedItems()
 308 {
 309     QueryResult *result = sDatabase.PQuery( "SELECT * FROM `mail_item`;" );
 310
 311     if( !result )
 312         return;
 313     Field *fields;
 314     do
 315     {
 316         fields = result->Fetch();
 317         Item* item = new Item;
 318         item->LoadFromDB(fields[0].GetUInt32(), 3);
 319         AddMItem(item);
 320     }
 321     while( result->NextRow() );
 322
 323     delete result;
 324 }
 325
 326 void ObjectMgr::LoadGuilds()
 327 {
 328     Guild *newguild;
 329     QueryResult *result = sDatabase.PQuery( "SELECT `guildid` FROM `guild`;" );
 330     uint32 count = 0;
 331
 332     if( !result )
 333     {
 334
 335         barGoLink bar( 1 );
 336
 337         bar.step();
 338
 339         sLog.outString( "" );
 340         sLog.outString( ">> Loaded %d guild definitions", count );
 341         return;
 342     }
 343
 344     barGoLink bar( result->GetRowCount() );
 345
 346     do
 347     {
 348         Field *fields = result->Fetch();
 349
 350         bar.step();
 351         count++;
 352
 353         newguild = new Guild;
 354         newguild->LoadGuildFromDB(fields[0].GetUInt32());
 355         AddGuild(newguild);
 356
 357     }while( result->NextRow() );
 358
 359     sLog.outString( "" );
 360     sLog.outString( ">> Loaded %d guild definitions", count );
 361 }
 362
 363 void ObjectMgr::LoadQuests()
 364 {
 365     sQuestsStorage.Load ();
 366     sLog.outString( ">> Loaded %d quests definitions", sQuestsStorage.RecordCount );
 367     sLog.outString( "" );
 368 }
 369
 370 void ObjectMgr::AddGossipText(GossipText *pGText)
 371 {
 372     ASSERT( pGText->Text_ID );
 373     ASSERT( mGossipText.find(pGText->Text_ID) == mGossipText.end() );
 374     mGossipText[pGText->Text_ID] = pGText;
 375 }
 376
 377 GossipText *ObjectMgr::GetGossipText(uint32 Text_ID)
 378 {
 379     GossipTextMap::const_iterator itr;
 380     for (itr = mGossipText.begin(); itr != mGossipText.end(); itr++)
 381     {
 382         if(itr->second->Text_ID == Text_ID)
 383             return itr->second;
 384     }
 385     return NULL;
 386 }
 387
 388 void ObjectMgr::LoadGossipText()
 389 {
 390     GossipText *pGText;
 391     QueryResult *result = sDatabase.PQuery( "SELECT * FROM `npc_text`;" );
 392
 393     int count = 0;
 394     if( !result ) return;
 395     int cic;
 396
 397     barGoLink bar( result->GetRowCount() );
 398
 399     do
 400     {
 401         count++;
 402         cic = 0;
 403
 404         Field *fields = result->Fetch();
 405
 406         bar.step();
 407
 408         pGText = new GossipText;
 409         pGText->Text_ID    = fields[cic++].GetUInt32();
 410
 411         for (int i=0; i< 8; i++)
 412         {
 413             pGText->Options[i].Text_0           = fields[cic++].GetString();
 414             pGText->Options[i].Text_1           = fields[cic++].GetString();
 415
 416             pGText->Options[i].Language         = fields[cic++].GetUInt32();
 417             pGText->Options[i].Probability      = fields[cic++].GetFloat();
 418
 419             pGText->Options[i].Emotes[0]._Delay  = fields[cic++].GetUInt32();
 420             pGText->Options[i].Emotes[0]._Emote  = fields[cic++].GetUInt32();
 421
 422             pGText->Options[i].Emotes[1]._Delay  = fields[cic++].GetUInt32();
 423             pGText->Options[i].Emotes[1]._Emote  = fields[cic++].GetUInt32();
 424
 425             pGText->Options[i].Emotes[2]._Delay  = fields[cic++].GetUInt32();
 426             pGText->Options[i].Emotes[2]._Emote  = fields[cic++].GetUInt32();
 427         }
 428
 429         if ( !pGText->Text_ID ) continue;
 430         AddGossipText( pGText );
 431
 432     } while( result->NextRow() );
 433
 434     sLog.outString( "" );
 435     sLog.outString( ">> Loaded %d npc texts", count );
 436     delete result;
 437 }
 438
 439 ItemPage *ObjectMgr::RetreiveItemPageText(uint32 Page_ID)
 440 {
 441     ItemPage *pIText;
 442     QueryResult *result = sDatabase.PQuery("SELECT * FROM `item_page` WHERE `id` = '%d';", Page_ID);
 443
 444     if( !result ) return NULL;
 445     int cic, count = 0;
 446     pIText = new ItemPage;
 447
 448     do
 449     {
 450         count++;
 451         cic = 0;
 452
 453         Field *fields = result->Fetch();
 454
 455         pIText->Page_ID    = fields[cic++].GetUInt32();
 456
 457         pIText->PageText   = fields[cic++].GetString();
 458         pIText->Next_Page  = fields[cic++].GetUInt32();
 459
 460         if ( !pIText->Page_ID ) break;
 461     } while( result->NextRow() );
 462
 463     delete result;
 464     return pIText;
 465 }
 466
 467 void ObjectMgr::AddAreaTriggerPoint(AreaTriggerPoint *pArea)
 468 {
 469     ASSERT( pArea->Trigger_ID );
 470     ASSERT( mAreaTriggerMap.find(pArea->Trigger_ID) == mAreaTriggerMap.end() );
 471
 472     mAreaTriggerMap[pArea->Trigger_ID] = pArea;
 473 }
 474
 475 AreaTriggerPoint *ObjectMgr::GetAreaTriggerQuestPoint(uint32 Trigger_ID)
 476 {
 477     AreaTriggerMap::const_iterator itr;
 478     for (itr = mAreaTriggerMap.begin(); itr != mAreaTriggerMap.end(); itr++)
 479     {
 480         if(itr->second->Trigger_ID == Trigger_ID)
 481             return itr->second;
 482     }
 483     return NULL;
 484 }
 485
 486 void ObjectMgr::LoadAreaTriggerPoints()
 487 {
 488     int count = 0;
 489     QueryResult *result = sDatabase.PQuery( "SELECT * FROM `areatrigger_involvedrelation`;" );
 490     AreaTriggerPoint *pArea;
 491
 492     if( !result ) return;
 493
 494     barGoLink bar( result->GetRowCount() );
 495
 496     do
 497     {
 498         count++;
 499
 500         bar.step();
 501
 502         pArea = new AreaTriggerPoint;
 503
 504         Field *fields = result->Fetch();
 505
 506         pArea->Trigger_ID      = fields[0].GetUInt32();
 507         pArea->Quest_ID        = fields[1].GetUInt32();
 508         pArea->Creature_ID     = fields[2].GetUInt32();
 509
 510         AddAreaTriggerPoint( pArea );
 511
 512     } while( result->NextRow() );
 513
 514     sLog.outString( "" );
 515     sLog.outString( ">> Loaded %d quest trigger points", count );
 516     delete result;
 517 }
 518
 519 bool ObjectMgr::GetGlobalTaxiNodeMask( uint32 curloc, uint32 *Mask )
 520 {
 521
 522     QueryResult *result = sDatabase.PQuery("SELECT `taxipath.destination` FROM `taxipath` WHERE `taxipath.source` = '%d' ORDER BY `destination` LIMIT 1;", curloc);
 523
 524     if( ! result )
 525     {
 526         return 1;
 527     }
 528     Field *fields = result->Fetch();
 529     uint8 destination = fields[0].GetUInt8();
 530     uint8 field = (uint8)((destination - 1) / 32);
 531     Mask[field] |= 1 << ( (destination - 1 ) % 32 );
 532
 533     return 1;
 534 }
 535
 536 uint32 ObjectMgr::GetNearestTaxiNode( float x, float y, float z, uint32 mapid )
 537 {
 538
 539     QueryResult *result = sDatabase.PQuery("SELECT `taxinode.id`, SQRT(pow(`taxinode.position_x`-'%f',2)+pow(`taxinode.position_y`-'%f',2)+pow(`taxinode.position_z`-'%f',2)) AS `distance` FROM `taxinode` WHERE `taxinode.continent` = '%u' ORDER BY `distance` LIMIT 1;", x, y, z, mapid);
 540
 541     if( ! result  )
 542     {
 543         return 0;
 544     }
 545     Field *fields = result->Fetch();
 546     return fields[0].GetUInt8();
 547
 548 }
 549
 550 void ObjectMgr::GetTaxiPath( uint32 source, uint32 destination, uint32 &path, uint32 &cost)
 551 {
 552
 553     QueryResult *result = sDatabase.PQuery("SELECT `taxipath.price`, `taxipath.id` FROM `taxipath` WHERE `taxipath.source` = '%u' AND `taxipath.destination` = '%u';", source, destination);
 554
 555     if( ! result )
 556     {
 557         path = 0;
 558         cost = 0;
 559         return;
 560     }
 561     Field *fields = result->Fetch();
 562     cost = fields[0].GetUInt32();
 563     path = fields[1].GetUInt16();
 564 }
 565
 566 uint16 ObjectMgr::GetTaxiMount( uint32 id )
 567 {
 568
 569     QueryResult *result = sDatabase.PQuery("SELECT `taxinode.mount` FROM `taxinode WHERE `taxinode.id` = '%u';", id);
 570
 571     if( ! result )
 572     {
 573         return 0;
 574     }
 575
 576     Field *fields = result->Fetch();
 577     return fields[0].GetUInt16();
 578
 579 }
 580
 581 void ObjectMgr::GetTaxiPathNodes( uint32 path, Path &pathnodes )
 582 {
 583
 584     QueryResult *result = sDatabase.PQuery("SELECT `taxipathnode.position_x`,`taxipathnode.position_y`,`taxipathnode.position_z` FROM `taxipathnode` WHERE `taxipathnode.path` = '%u';", path);
 585
 586     if( ! result )
 587         return;
 588
 589     uint16 count = result->GetRowCount();
 590     sLog.outDebug(" ROW COUNT %u ",count);
 591     pathnodes.Resize( count );
 592     unsigned int i = 0;
 593
 594     do
 595     {
 596         Field *fields = result->Fetch();
 597         pathnodes[ i ].x = fields[0].GetFloat();
 598         pathnodes[ i ].y = fields[1].GetFloat();
 599         pathnodes[ i ].z = fields[2].GetFloat();
 600         i++;
 601     } while( result->NextRow() );
 602 }
 603
 604 GraveyardTeleport *ObjectMgr::GetClosestGraveYard(float x, float y, float z, uint32 MapId)
 605 {
 606
 607     QueryResult *result = sDatabase.PQuery("SELECT SQRT(POW('%f'-`position_x`,2)+POW('%f'-`position_y`,2)+POW('%f'-`position_z`,2)) AS `distance`,`position_x`,`position_y`,`position_z`,`map` FROM `graveyard` WHERE `map` = '%d' ORDER BY `distance` ASC LIMIT 1;", x, y, z, MapId);
 608
 609     if( ! result )
 610         return NULL;
 611
 612     Field *fields = result->Fetch();
 613     GraveyardTeleport *pgrave = new GraveyardTeleport;
 614
 615     pgrave->X = fields[1].GetFloat();
 616     pgrave->Y = fields[2].GetFloat();
 617     pgrave->Z = fields[3].GetFloat();
 618     pgrave->MapId = fields[4].GetUInt32();
 619
 620     return pgrave;
 621 }
 622
 623 AreaTrigger *ObjectMgr::GetAreaTrigger(uint32 Trigger_ID)
 624 {
 625
 626     QueryResult *result = sDatabase.PQuery("SELECT `id` FROM `areatrigger_template` WHERE `id` = '%d';", Trigger_ID);
 627
 628     if ( result )
 629     {
 630         Field *fields = result->Fetch();
 631         uint32 totrigger = fields[0].GetUInt32();
 632         if( totrigger != 0)
 633         {
 634
 635             QueryResult *result1 = sDatabase.PQuery("SELECT `target_map`,`target_position_x`,`target_position_y`,`target_position_z` FROM `areatrigger_template` WHERE `id` = '%d';", totrigger);
 636             if ( result1 )
 637             {
 638                 Field *fields1 = result1->Fetch();
 639                 AreaTrigger *at = new AreaTrigger;
 640
 641                 at->mapId = fields1[0].GetUInt32();
 642
 643                 at->X = fields1[1].GetFloat();
 644                 at->Y = fields1[2].GetFloat();
 645                 at->Z = fields1[3].GetFloat();
 646
 647                 return at;
 648             }
 649         }
 650     }
 651     return NULL;
 652 }
 653
 654 void ObjectMgr::LoadTeleportCoords()
 655 {
 656
 657     QueryResult *result = sDatabase.PQuery( "SELECT * FROM `areatrigger_template`;" );
 658
 659     if( !result )
 660         return;
 661
 662     uint32 count = 0;
 663
 664     TeleportCoords *pTC;
 665
 666     barGoLink bar( result->GetRowCount() );
 667
 668     do
 669     {
 670         Field *fields = result->Fetch();
 671
 672         bar.step();
 673
 674         count++;
 675
 676         pTC = new TeleportCoords;
 677         pTC->id = fields[0].GetUInt32();
 678         //pTC->Name = fields[6].GetString();
 679         pTC->mapId = fields[5].GetUInt32();
 680         pTC->x = fields[1].GetFloat();
 681         pTC->y = fields[2].GetFloat();
 682         pTC->z = fields[3].GetFloat();
 683
 684         AddTeleportCoords(pTC);
 685
 686     } while( result->NextRow() );
 687
 688     delete result;
 689
 690     sLog.outString( "" );
 691     sLog.outString( ">> Loaded %d teleport definitions", count );
 692 }
 693
 694 void ObjectMgr::SetHighestGuids()
 695 {
 696
 697     QueryResult *result = sDatabase.Query( "SELECT MAX(`guid`) FROM `character`;" );
 698     if( result )
 699     {
 700         m_hiCharGuid = (*result)[0].GetUInt32()+1;
 701
 702         delete result;
 703     }
 704
 705     result = sDatabase.Query( "SELECT MAX(`guid`) FROM `creature`;" );
 706     if( result )
 707     {
 708         m_hiCreatureGuid = (*result)[0].GetUInt32()+1;
 709
 710         delete result;
 711     }
 712
 713     result = sDatabase.Query( "SELECT MAX(`guid`) FROM `item_instance`;" );
 714     if( result )
 715     {
 716         m_hiItemGuid = (*result)[0].GetUInt32()+1;
 717
 718         delete result;
 719     }
 720
 721     result = sDatabase.Query("SELECT MAX(`guid`) FROM `gameobject`;" );
 722     if( result )
 723     {
 724         m_hiGoGuid = (*result)[0].GetUInt32()+1;
 725
 726         delete result;
 727     }
 728
 729     result = sDatabase.Query("SELECT MAX(`id`) FROM `auctionhouse`;" );
 730     if( result )
 731     {
 732         m_auctionid = (*result)[0].GetUInt32()+1;
 733
 734         delete result;
 735     }
 736     else
 737     {
 738         m_auctionid = 0;
 739     }
 740     result = sDatabase.PQuery( "SELECT MAX(`id`) FROM `mail`;" );
 741     if( result )
 742     {
 743         m_mailid = (*result)[0].GetUInt32()+1;
 744
 745         delete result;
 746     }
 747     else
 748     {
 749         m_mailid = 0;
 750     }
 751
 752     result = sDatabase.PQuery( "SELECT MAX(`guid`) FROM `corpse`;" );
 753     if( result )
 754     {
 755         m_hiCorpseGuid = (*result)[0].GetUInt32()+1;
 756
 757         delete result;
 758     }
 759
 760 }
 761
 762 uint32 ObjectMgr::GenerateAuctionID()
 763 {
 764
 765     return ++m_auctionid;
 766 }
 767
 768 uint32 ObjectMgr::GenerateMailID()
 769 {
 770     return ++m_mailid;
 771 }
 772
 773 uint32 ObjectMgr::GenerateLowGuid(uint32 guidhigh)
 774 {
 775
 776     switch(guidhigh)
 777     {
 778         case HIGHGUID_ITEM          : return ++m_hiItemGuid;
 779         case HIGHGUID_UNIT          : return ++m_hiCreatureGuid;
 780         case HIGHGUID_PLAYER        : return ++m_hiCharGuid;
 781         case HIGHGUID_GAMEOBJECT    : return ++m_hiGoGuid;
 782         case HIGHGUID_CORPSE        : return ++m_hiCorpseGuid;
 783         case HIGHGUID_DYNAMICOBJECT : return ++m_hiDoGuid;
 784         default                     : ASSERT(0);
 785     }
 786
 787     return 0;
 788 }
 789
 790 GameObjectInfo *ObjectMgr::GetGameObjectInfo(uint32 id)
 791 {
 792     //debug
 793     if(sGOStorage.MaxEntry<=id)
 794     {
 795         sLog.outString("ERROR: There is no GO with proto %u id the DB",id);
 796         return NULL;
 797     }
 798
 799     return (sGOStorage.MaxEntry<=id)?NULL:(GameObjectInfo *)sGOStorage.pIndex[id];
 800
 801 }
 802
 803 void ObjectMgr::LoadGameobjectInfo()
 804 {
 805     sGOStorage.Load();
 806
 807     sLog.outString( ">> Loaded %d game object templates", sGOStorage.RecordCount );
 808
 809 }
 810
 811 ItemPrototype* ObjectMgr::GetItemPrototype(uint32 id)
 812 {
 813     return (sItemStorage.MaxEntry<=id)?NULL:(ItemPrototype*)sItemStorage.pIndex[id];
 814 }