static bool HandlePartyInfoCommand(ChatHandler* handler, char const* args)
{
Player* target;
uint64 target_guid;
std::string target_name;
if (!handler->extractPlayerTarget((char*)args, &target, &target_guid, &target_name))
return false;

uint32 accId = 0;
std::string username = "";
std::string status = "";
uint32 security = 0;

// get additional information from Player object
if (target)
{
std::string nameLink = handler->playerLink(target_name);
if (Group* grp = target->GetGroup())
{
if (grp->isRaidGroup())
handler->SendSysMessage("----------------Raid Group----------------");
else if (grp->isBGGroup())
handler->SendSysMessage("----------------BG Group-----------------");
else if (grp->isLFGGroup())
handler->SendSysMessage("----------------LFG Group----------------");
else
handler->SendSysMessage("------------------Group------------------");

for (GroupReference* itr = grp->GetFirstMember(); itr != NULL; itr = itr->next())
{
Player* pl = itr->GetSource();

if (!pl || pl == handler->GetSession()->GetPlayer() || !pl->GetSession())
continue;

accId = pl->GetSession()->GetAccountId();
nameLink = handler->playerLink(pl->GetName());

QueryResult result = LoginDatabase.PQuery("SELECT aa.gmlevel, a.username "
"FROM account a "
"LEFT JOIN account_access aa "
"ON (a.id = aa.id) "
"WHERE a.id = '%u'",accId);
if (result)
{
Field* fields = result->Fetch();
security = fields[0].GetUInt32();
username = fields[1].GetString();
}

if (grp->IsLeader(pl->GetGUID()))
{
status = "[Leader]";
}
else if (grp->IsAssistant(pl->GetGUID()))
{
status = "[Assistant]";
}

handler->PSendSysMessage(LANG_PARTYINFO_PLAYER, (pl ? "" : handler->GetTrinityString(LANG_OFFLINE)), nameLink.c_str(), username.c_str(), accId, security, status.c_str());
}
handler->SendSysMessage("----------------------------------------");
}
else
{
handler->PSendSysMessage(LANG_NOT_IN_GROUP, nameLink.c_str());
handler->SetSentErrorMessage(true);
return false;
}
}

return true;
}

LANG_PARTYINFO_PLAYER = 11104,

INSERT INTO `command` VALUES
('partyinfo', '2', 'Syntax: .partyinfo [$player_name]\nOutput information for members of group that include selected player or player find by $player_name.');