Code:
void CDbManager::LoadMemberGuildOnline(CQuery *qry, LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus)
{
OutputDebugString("CDbManager::LoadMemberGuildOnline - IN");
CAr arRead(lpDbOverlappedPlus->lpBuf, lpDbOverlappedPlus->uBufSize);
char szQuery[QUERY_SIZE] = { 0, };
DWORD m_nGuildID;
arRead >> m_nGuildID;
sprintf(szQuery, "GUILD_MEMBER_COUNT '%06d'", m_nGuildID);
if (qry->Exec(szQuery) == FALSE)
{
WriteLog("LoadMemberGuildOnline %s, %d\t%s", __FILE__, __LINE__, szQuery);
FreeRequest(lpDbOverlappedPlus);
return;
}
while (qry->Fetch())
{
GUILD_MEMBER_COUNT Count;
Count.nCount = qry->GetInt("fText");
}
CDPTrans::GetInstance()->SendMemberOnline();
FreeRequest(lpDbOverlappedPlus);
OutputDebugString("CDbManager::LoadMemberGuildOnline - OUT");
}
Did some changes. I don't understand the purpose of GUILD_MEMBER_COUNT structure, you set the value but you don't save anywhere. Now the function CDPTrans::SendMemberOnline() should send the value to worldserver but it won't because is nowhere.
Also the count(*) on stored procedure is really bad.
If you want to know online players from guild you can do it easier.
Code:
CGuild* pGuild = g_pPlayer->GetGuild();
USHORT count = 0;
if(pGuild)
{
for(auto member : pGuild->m_mapPMember)
{
PlayerData* pPlayerData = CPlayerDataCenter::GetInstance()->GetPlayerData( member.second->m_idPlayer );
if(pPlayerData->data.uLogin > 0)
count++;
}
}
All guild data is available at player client. You can loop the map container and check if player is online or not.