rendered paste bodybool __cdecl F9_2_4_GetPledgeMemberInfo(CQuerySocket *pQuerySocket, const unsigned char* packet)
{
DBConn *pDBConn = new DBConn;
DWORD dUserObjID, dPledgeID, dRank;
wchar_t wszMemberName[14];
wchar_t wszTitle[28];
Cached::Disassemble(packet, "ddS", &dUserObjID, &dPledgeID, sizeof(wszMemberName),&wszMemberName);
pDBConn->Bind(&dRank);
pDBConn->BindS(&wszTitle, 28);
if(pDBConn->Execute(L"SELECT [Rank], [nickname] FROM [lin2world].[dbo].[user_data] WHERE [char_name] = '%ls' AND [pledge_id]= %d", wszMemberName, dPledgeID))
{
pDBConn->Fetch();
pQuerySocket->Send("chddSSdd", 0xD8, 0x03, 0x02, dUserObjID, wszMemberName, wszTitle, dPledgeID, dRank);
}else CLog::In()->Add(CLog::ErrorConsoleRed, L"[PacketHandler] Error in executing- GetPledgeMemberRank() Member[%ls] PledgeID[%d] Rank[%d]", wszMemberName, dPledgeID, dRank);
delete pDBConn;
return false;
};