hello,
i have a problem too it doesn't display the dialog for clan members,
code:
case 1: {
new szDialog2[1024], Members, name[180], cwarn[180], cdays[180], szRank1[180];
format(query, sizeof(query), "SELECT * FROM `users` WHERE `users`.`Clan` = '%d' ORDER BY `users`.`ClanRank` DESC LIMIT 50", PlayerInfo[playerid][pClan]);
new Cache: result = mysql_query(SQL, query);
strcat(szDialog2, "#. Name\tRank\tClan Warns\tClan Days\n");
for(new i, j = cache_get_row_count (); i != j; ++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);
format(Selected[playerid][Members], MAX_PLAYER_NAME, 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");
}