Changeset 79 for trunk/src/game/ObjectMgr.cpp
- Timestamp:
- 11/19/08 13:32:21 (17 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/src/game/ObjectMgr.cpp
r78 r79 40 40 #include "Spell.h" 41 41 #include "Chat.h" 42 #include "AccountMgr.h" 42 43 #include "InstanceSaveMgr.h" 43 44 #include "SpellAuras.h" … … 321 322 bidder_accId = GetPlayerAccountIdByGUID(bidder_guid); 322 323 bidder_security = GetSecurityByAccount(bidder_accId); 324 bidder_security = accmgr.GetSecurity(bidder_accId); 323 325 324 326 if(bidder_security > SEC_PLAYER ) // not do redundant DB requests … … 505 507 void ObjectMgr::LoadCreatureLocales() 506 508 { 509 mCreatureLocaleMap.clear(); 510 507 511 QueryResult *result = WorldDatabase.Query("SELECT entry,name_loc1,subname_loc1,name_loc2,subname_loc2,name_loc3,subname_loc3,name_loc4,subname_loc4,name_loc5,subname_loc5,name_loc6,subname_loc6,name_loc7,subname_loc7,name_loc8,subname_loc8 FROM locales_creature"); 508 512 … … 1298 1302 } 1299 1303 1300 uint32 ObjectMgr::GetSecurityByAccount(uint32 acc_id) const1301 {1302 QueryResult *result = loginDatabase.PQuery("SELECT gmlevel FROM account WHERE id = '%u'", acc_id);1303 if(result)1304 {1305 uint32 sec = (*result)[0].GetUInt32();1306 delete result;1307 return sec;1308 }1309 1310 return 0;1311 }1312 1313 bool ObjectMgr::GetAccountNameByAccount(uint32 acc_id, std::string &name) const1314 {1315 QueryResult *result = loginDatabase.PQuery("SELECT username FROM account WHERE id = '%u'", acc_id);1316 if(result)1317 {1318 name = (*result)[0].GetCppString();1319 delete result;1320 return true;1321 }1322 1323 return false;1324 }1325 1326 uint32 ObjectMgr::GetAccountByAccountName(std::string name) const1327 {1328 loginDatabase.escape_string(name);1329 QueryResult *result = loginDatabase.PQuery("SELECT id FROM account WHERE username = '%s'", name.c_str());1330 if(result)1331 {1332 uint32 id = (*result)[0].GetUInt32();1333 delete result;1334 return id;1335 }1336 1337 return 0;1338 }1339 1340 1304 void ObjectMgr::LoadAuctions() 1341 1305 { … … 1399 1363 void ObjectMgr::LoadItemLocales() 1400 1364 { 1365 mItemLocaleMap.clear(); 1366 1401 1367 QueryResult *result = WorldDatabase.Query("SELECT entry,name_loc1,description_loc1,name_loc2,description_loc2,name_loc3,description_loc3,name_loc4,description_loc4,name_loc5,description_loc5,name_loc6,description_loc6,name_loc7,description_loc7,name_loc8,description_loc8 FROM locales_item"); 1402 1368 … … 3420 3386 void ObjectMgr::LoadQuestLocales() 3421 3387 { 3388 mQuestLocaleMap.clear(); 3389 3422 3390 QueryResult *result = WorldDatabase.Query("SELECT entry," 3423 3391 "Title_loc1,Details_loc1,Objectives_loc1,OfferRewardText_loc1,RequestItemsText_loc1,EndText_loc1,ObjectiveText1_loc1,ObjectiveText2_loc1,ObjectiveText3_loc1,ObjectiveText4_loc1," … … 4015 3983 void ObjectMgr::LoadPageTextLocales() 4016 3984 { 3985 mPageTextLocaleMap.clear(); 3986 4017 3987 QueryResult *result = WorldDatabase.PQuery("SELECT entry,text_loc1,text_loc2,text_loc3,text_loc4,text_loc5,text_loc6,text_loc7,text_loc8 FROM locales_page_text"); 4018 3988 … … 4181 4151 void ObjectMgr::LoadNpcTextLocales() 4182 4152 { 4153 mNpcTextLocaleMap.clear(); 4154 4183 4155 QueryResult *result = WorldDatabase.Query("SELECT entry," 4184 4156 "Text0_0_loc1,Text0_1_loc1,Text1_0_loc1,Text1_1_loc1,Text2_0_loc1,Text2_1_loc1,Text3_0_loc1,Text3_1_loc1,Text4_0_loc1,Text4_1_loc1,Text5_0_loc1,Text5_1_loc1,Text6_0_loc1,Text6_1_loc1,Text7_0_loc1,Text7_1_loc1," … … 5204 5176 void ObjectMgr::LoadGameObjectLocales() 5205 5177 { 5178 mGameObjectLocaleMap.clear(); 5179 5206 5180 QueryResult *result = WorldDatabase.Query("SELECT entry," 5207 5181 "name_loc1,name_loc2,name_loc3,name_loc4,name_loc5,name_loc6,name_loc7,name_loc8,"