MySQL BlueGR38
#1

Could someone help me make a cmd that shows the top players? top 5
in MySQL BlueGR38

My ConnectionHandle:

MysqlCon
Reply
#2

Link it in a command ,
ex: cmd:top5
and link it
PHP код:
mysql_query("SELECT username, score FROM `table` ORDER BY `score` DESC LIMIT 5");
mysql_store_result(); 
new 
numtop[5][24], score[5][5];
while(
mysql_retrieve_row())
{
    
mysql_fetch_field_row(top[num], "username");
    
mysql_fetch_field_row(score[num], "score");
    
num++;
}
mysql_free_result();
printf("Rank 1: %s, Rank 2: %s, Rank 3: %s, Rank 4: %s, Rank 5: %s"top[0], top[1], top[2], top[3], top[4], top[5]); 
Good luck
Reply
#3

thx vry much
Reply
#4

Код:
C:\Users\Bradley\Desktop\SA-MP\gamemodes\cnr.pwn(3500) : error 017: undefined symbol "mysql_store_result"
C:\Users\Bradley\Desktop\SA-MP\gamemodes\cnr.pwn(3502) : error 017: undefined symbol "mysql_retrieve_row"
C:\Users\Bradley\Desktop\SA-MP\gamemodes\cnr.pwn(3504) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Bradley\Desktop\SA-MP\gamemodes\cnr.pwn(3505) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\Bradley\Desktop\SA-MP\gamemodes\cnr.pwn(3508) : error 017: undefined symbol "mysql_free_result"
C:\Users\Bradley\Desktop\SA-MP\gamemodes\cnr.pwn(3509) : error 032: array index out of bounds (variable "top")
...Its supposed to be MySQL BueG r38
Reply
#5

So noone has one?
Reply
#6

Код:
SELECT row_name FROM table_name ORDER BY row_name DESC LIMIT 5
Reply
#7

pawn Код:
mysql_tquery(conhandle, "SELECT username, score FROM `table` ORDER BY `score` DESC LIMIT 5", "OnTop5Show", "i", playerid);

public OnTop5Show(playerid) {
    new rows, fields;
    cache_get_data(rows, fields);
    new top[rows][24], score[rows][5]
    for(new i=0;i<rows;i++) {
        cache_get_row(i, 0, top[i]);
        cache_get_row(i, 1, score[i]);
    }
    printf("Rank 1: %s, Rank 2: %s, Rank 3: %s, Rank 4: %s, Rank 5: %s", top[0], top[1], top[2], top[3], top[4], top[5]);
}
Reply


Forum Jump:


Users browsing this thread: 6 Guest(s)