// *************************************************************** // Function: LoadPlayerInfo.cpp // *************************************************************** #include "Main.h" #include int AddPlayerToInstance(QUERY_RESULT *result, PLAYER_DATA* lir); //Sorts items by storage location bool sortMyItems(Item start, Item end) { return start.GetItemStorageLocation() < end.GetItemStorageLocation(); } //************************************ // Name: ProcessAccountInfo // // Processes the results from the account info query. // // Parameters: // pResult - Database query result // pLir - Player's data // // Return: // 0 - no errors // -1 - errors //************************************ int ProcessAccountInfo(QUERY_RESULT* pResult, PLAYER_DATA* pLir) { if (pResult->pResult==NULL) { gpGameServer->Kick(pLir->networkId); return -1; } if (mysql_num_rows(pResult->pResult)>0) { MYSQL_ROW row=mysql_fetch_row(pResult->pResult); if (row[0]==NULL || row[0][0]==0) { pLir->flags.set(LD_NOPASSWORD, true); } } char query[300]; sprintf(query, "SELECT Name, HeightSex, HairSkinColor, ProfessionHairStyle, CampaignFace, SecondProfession, CharacterType, Level, GroupID FROM characters WHERE ID='%u'", pLir->characterId); pLir->queryId=gDatabase.Query(query, strlen(query)); pLir->QueryProcess=AddPlayerToInstance; return 0; } //************************************ // Name: ProcessItemsFromDb // // Processes the item load query when loading a character. // // Parameters: // pResult - Database query result // pLir - Player's data // // Return: // 0 - no errors // -1 - errors //************************************ int ProcessItemsFromDb(QUERY_RESULT* pResult, PLAYER_DATA* pLir) { if (pResult->pResult==NULL) { gpGameServer->Kick(pLir->networkId); return -1; } unsigned long num_items=0; Item *pItems=Item::ConvertResultSet(pResult->pResult, (long*)&num_items); for (unsigned long i=0; imyItems.push_back(pItems[i]); } delete [] pItems; //Sort the items in ascending order std::sort(pLir->myItems.begin(), pLir->myItems.end(), sortMyItems); gCoreLog.notice("Loaded %d player items.", pLir->myItems.size()); char query[300]; sprintf(query, "SELECT Password FROM accounts WHERE AccountID=%u", pLir->accountId); pLir->queryId=gDatabase.Query(query, strlen(query)); pLir->QueryProcess=ProcessAccountInfo; return 0; } //************************************ // Name: LoadItemFromDb // // Executes query to load all items for specified character. // // Parameters: // pLir - Player's data // characterId - Character's id // accountId - Account id // // Return: // - true //************************************ bool LoadItemFromDb(PLAYER_DATA* pLir, long characterId, long accountId) { pLir->queryId=Item::Load(accountId, characterId); pLir->QueryProcess=ProcessItemsFromDb; pLir->characterId=characterId; return true; }