Собственно вот данная команда делал сам.
Код
YCMD:offmembers(playerid, params[], help)
{
new Names[MAX_PLAYER_NAME];
new OffMembers;
new Rank;
if(PlayerInfo[playerid][pLogin] == 0) return
if(PlayerInfo[playerid][pLeader] == 0) return true;
SendClientMessage(playerid, 0x059BD3FF, "Члены организации Offline:");
SendClientMessage(playerid, 0x059BD3FF, " ");
format(YCMDstr, sizeof(YCMDstr), "SELECT * FROM `accounts` WHERE pMember = '%d'",PlayerInfo[playerid][pMember]);
mysql_query(YCMDstr);
mysql_store_result();
if(mysql_fetch_row_format(YCMDstr))
{
BaseGet("Name",Names);
BaseGetInt("pLogin",OffMembers);
BaseGetInt("pRank",Rank);
if(OffMembers == 0)
{
format(YCMDstr, sizeof(YCMDstr), "%s ранг: %d",Names, Rank);
SendClientMessage(playerid, 0x059BD3FF, YCMDstr);
}
while(mysql_next_row())
{
BaseGet("Name",Names);
BaseGetInt("pLogin",OffMembers);
BaseGetInt("pRank",Rank);
if(OffMembers == 0)
{
format(YCMDstr, sizeof(YCMDstr), "%s ранг: %d",Names, Rank);
SendClientMessage(playerid, 0x059BD3FF, YCMDstr);
}
}
}
else SendClientMessage(playerid, COLOR_GRAD1,"Не найдено совпадений");
mysql_free_result();
return true;
}