PDA

View Full Version : Whats Wrong with this


Mriss
06/04/2014, 09:33 AM
Btw Im Using MySQL R 38

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
06/04/2014, 09:38 AM
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
06/04/2014, 09:38 AM
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