[BrianFaria]

Hello, I have a question, as I can do so that every top name out of different colors?

PHP Code:

format(query,sizeof(query),"SELECT `NAME` FROM `USERS` ORDER BY (`SCORE` * 1) DESC limit 25");
    result = db_query(ULFDB,query);
    strcat(str, "{FFFFFF}ID\tNick\tScore\n");
    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(str2,sizeof(str2),"%d\t%s\t%s\n",a+1,string,string2);
    strcat(str, str2);
    db_next_row(result);
    db_free_result(result2);
    }
    ShowPlayerDialog(playerid,UNUSED, DIALOG_STYLE_TABLIST_HEADERS,"TOP SCORE - ULF",str,"Aceptar",""); 


[Konstantinos]

You can select multiply columns in one query. Free the result only once (at the end).

It picks a random color to display the name of a player, if you want to show the entire row (line) then move it at the beginning and remove {FFFFFF} before score. Also make sure "str" is big enough to hold data of 25 players.
Static local would also be better.

PHP Code:

result = db_query(ULFDB, "SELECT NAME,SCORE FROM USERS ORDER BY SCORE DESC LIMIT 25");
str = "{FFFFFF}Position\tNick\tScore\n";
new p_name[MAX_PLAYER_NAME], color;
for (new a, rows = db_num_rows(result); a < b; a++)
{
    db_get_field(result, 0, p_name, sizeof p_name);
    color = (random(256) * 16777216) + (random(256) * 65536) + (random(256) * 256) + 255;
    format(str2, sizeof(str2), "%d\t{%06x}%s\t{FFFFFF}%d\n", a + 1, color >>> 8, p_name, db_get_field_int(result, 1));
    strcat(str, str2);
  
    db_next_row(result);
}
db_free_result(result2);
ShowPlayerDialog(playerid, UNUSED, DIALOG_STYLE_TABLIST_HEADERS, "TOP SCORE - ULF", str, "Aceptar", ""); 


[BrianFaria]

it does not work

PHP Code:

format(query,sizeof(query),"SELECT `NAME` FROM `USERS` ORDER BY (`SCORE` * 1) DESC limit 25");
    result = db_query(ULFDB,query);
    strcat(str, "{FFFFFF}ID\tNick\tScore\n");
    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);
    color = (random(256) * 16777216) + (random(256) * 65536) + (random(256) * 256) + 255;
    format(str2,sizeof(str2),"%d\t{%06x}%s\t{FFFFFF}%d\n",a+1,color >>> 8,string,string2);
    strcat(str, str2);
    db_next_row(result);
    db_free_result(result2); 


[BrianFaria]

And it worked, thanks bro +rep