[Sanady]

Quote:

Originally Posted by R0 Seems like you didnt make it as an iterator, you can make it an iterator or you can just use foreach for all of the players and check their squad id, if it matches do whatever you want there.

I get that, but still same bug, only one name is displeyed, but in squad there are two members.

pawn Код:

CMD:squadronmembers(playerid, params[])
{
    if(pInfo[playerid][pSquadID] == 0) return SendError(playerid, "You are not in a squadron!");
    new LongString[1024], ShortString[180], Count = 0;
    
    foreach(Player, i)
    {
        format(StringSquad,sizeof(StringSquad),"SELECT `UserName` FROM `users` WHERE `SquadID` = %d", pInfo[i][pSquadID]);
        mysql_query(StringSquad);
        mysql_store_result();

        new MemberName[MAX_PLAYER_NAME];
        while(mysql_retrieve_row())
        {
            mysql_get_field("UserName", MemberName);
        }

        Count++;
        format(ShortString, sizeof(ShortString), embed_orange"%s\n", MemberName);
        strcat(LongString,ShortString);

        mysql_free_result();
    }

    if(Count == 0) return Dialog_Show(playerid, SquadDialog, DIALOG_STYLE_MSGBOX, "{BCF562}Squadron Members", embed_red"There is no members", "Ok", "");
    else return Dialog_Show(playerid, SquadDialog, DIALOG_STYLE_MSGBOX ,"{BCF562}Squadron Members", LongString, "Ok", "");
}