[Bondage]

Got a problem regarding this command, this is use to view the total number of vip level 1 but this is just showing one single name, ain't showing further list of people who are vip level 1.

pawn Код:

CMD:viplevel1(playerid, params[])
{
    new query[80];
    new
        ID,
        output[800];
    mysql_format(mysql, query, sizeof(query), "SELECT user FROM players WHERE level = 1");
    new Cache:result = mysql_query(mysql, query);

    new rows, fields;
    cache_get_data(rows, fields, mysql);
    if(rows)
    {
        new
            username[24];
        ID ++;
        cache_get_field_content(0, "user",username, mysql, 24);

        format(output, sizeof(output), "%s"ccwhite"%d. %s\n", output, ID, username);
        ShowPlayerDialog(playerid, 212, DIALOG_STYLE_MSGBOX, "Level 1 Admins", output, "OK", "Cancel");}
    else {
        ShowPlayerDialog(playerid, 212, DIALOG_STYLE_MSGBOX, "Level 1 Admins", "No vip of this level.", "OK", "Cancel");}
    cache_delete(result);
    return 1;
}