case 1:
{
new szDialog2[4096], szDialog[256];
new Members = 0;
new name[24], cwarn[8], cdays[8], szRank1[8];
format(query, sizeof(query),
"SELECT Username, ClanRank, ClanWarns, ClanDays \
FROM users WHERE Clan = %d \
ORDER BY ClanRank DESC LIMIT 50",
PlayerInfo[playerid][pClan]);
new Cache:result = mysql_query(SQL, query);
strcat(szDialog2, "#. Name\tRank\tClan Warns\tClan Days\n");
new rows = cache_get_row_count();
for(new i = 0; i < rows; i++)
{
cache_get_field_content(i, "Username", name);
cache_get_field_content(i, "ClanRank", szRank1);
cache_get_field_content(i, "ClanWarns", cwarn);
cache_get_field_content(i, "ClanDays", cdays);
strcpy(Selected[playerid][Members], name);
format(szDialog, sizeof szDialog,
"%d. %s\t%d\t%s/3\t%s\n",
Members + 1,
name,
strval(szRank1),
cwarn,
cdays
);
strcat(szDialog2, szDialog);
Members++;
}
cache_delete(result);
ShowPlayerDialog(playerid,
DIALOG_CLAN_MEMBERS,
DIALOG_STYLE_TABLIST_HEADERS,
"Clan members",
szDialog2,
"Ok",
"Back"
);
}