[Mriss]

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

My ConnectionHandle:

MysqlCon

[MCZOFT]

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 num, top[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

[Mriss]

thx vry much

[Mriss]

Код:

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

[Mriss]

So noone has one?

[VishvaJeet]

Код:

SELECT row_name FROM table_name ORDER BY row_name DESC LIMIT 5

[Dubya]

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]);
}