bool __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; };