[BrianFaria]

http://imgur.com/a/tiR7c
Por que eu me pareзo com isso? sondar milhares de maneiras e nгo, nгo andar, obrigado.

Код:

CMD:topc(playerid,params[])
{
    new string[1000], query[256], str[700];
    new string2[500];
    new DBResult:result;
    new DBResult:result2;
    format(query,sizeof(query),"SELECT `NAME` FROM `USERS` ORDER BY (`SCORE` * 1) DESC limit 25");
    result = db_query(ULFDB,query);
    for(new a;a<db_num_rows(result);a++)
    {
    db_get_field(result,0,string,128);
    format(query,sizeof(query),"SELECT `SCORE` FROM `USERS` WHERE `NAME` = '%s'",string);
    result2 = db_query(ULFDB,query);
    db_get_field(result2,0,string2,128);
    format(string,sizeof(string),"{FFFFFF}ID\tNick\tScore\n%d\t%s\t%s\n",a+1,string,string2);
    format(str,sizeof(str),"%s%s\n",str,string);
    db_next_row(result);
    db_free_result(result2);
    }
    ShowPlayerDialog(playerid,UNUSED, DIALOG_STYLE_TABLIST_HEADERS,"{FFFFFF}TOP SCORE - {0077FF}ULF",str,"Aceptar","");
    db_free_result(result);
    return 1;
}

[RedMF]

Код:

CMD:topc(playerid,params[])
{
    new string[1000], query[256], str[700];
    new string2[500];
    new DBResult:result;
    new DBResult:result2;
    format(query,sizeof(query),"SELECT `NAME` FROM `USERS` ORDER BY (`SCORE` * 1) DESC limit 25");
    result = db_query(ULFDB,query);
    for(new a;a<db_num_rows(result);a++)
    {
    db_get_field(result,0,string,128);
    format(query,sizeof(query),"SELECT `SCORE` FROM `USERS` WHERE `NAME` = '%s'",string);
    result2 = db_query(ULFDB,query);
    db_get_field(result2,0,string2,128);
    format(string,sizeof(string),"{FFFFFF}%d\t%s\t%s\n",a+1,string,string2);
    format(str,sizeof(str),"%s%s\n",str,string);
    db_next_row(result);
    db_free_result(result2);
    }
    ShowPlayerDialog(playerid,UNUSED, DIALOG_STYLE_TABLIST_HEADERS,"{FFFFFF}TOP SCORE - {0077FF}ULF",str,"Aceptar","");
    db_free_result(result);
    return 1;
}

[BrianFaria]