29.08.2015, 19:39
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", "");
}