[Mriss]

Btw Im Using MySQL R 38

pawn Код:

CMD:top5(playerid, params[])
{
    mysql_tquery(MysqlCon, "SELECT user, Score FROM `players` ORDER BY `Score` DESC LIMIT 5", "OnTop5Show", "i", playerid);
    return 1;
}

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

Whats wrong with it

[ikey07]

Your query is wrong

SELECT user, Score FROM `players` ORDER BY `Score` DESC LIMIT 5


also you have 5 Ranks, but at top[] it goes to 6

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

[Mriss]

Код:

C:\Users\Bradley\Desktop\SA-MP\gamemodes\cnr.pwn(1597) : error 008: must be a constant expression; assumed zero
C:\Users\Bradley\Desktop\SA-MP\gamemodes\cnr.pwn(1597) : error 029: invalid expression, assumed zero
C:\Users\Bradley\Desktop\SA-MP\gamemodes\cnr.pwn(1597) : error 017: undefined symbol "score"
C:\Users\Bradley\Desktop\SA-MP\gamemodes\cnr.pwn(1597) : fatal error 107: too many error messages on one line