SA-MP Forums Archive
Whats Wrong with this - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Whats Wrong with this (/showthread.php?tid=504925)



Whats Wrong with this - Mriss - 06.04.2014

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


Re: Whats Wrong with this - ikey07 - 06.04.2014

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


Re: Whats Wrong with this - Mriss - 06.04.2014

Код:
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