Help SQLite
#1

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(strstr2);
    
db_next_row(result);
    
db_free_result(result2);
    }
    
ShowPlayerDialog(playerid,UNUSEDDIALOG_STYLE_TABLIST_HEADERS,"TOP SCORE - ULF",str,"Aceptar",""); 
Reply


Messages In This Thread
Help SQLite - by BrianFaria - 03.10.2016, 14:59
Re: Help SQLite - by Konstantinos - 03.10.2016, 16:03
Re: Help SQLite - by BrianFaria - 03.10.2016, 16:56
Re: Help SQLite - by BrianFaria - 03.10.2016, 17:08

Forum Jump:


Users browsing this thread: 1 Guest(s)