[LetsOWN[PL]]

Quote:

Originally Posted by PowerF COMMAND:topxp(playerid, params[]) Код: { new p_top[24],score,string[600],row[600]; mysql_query("SELECT playerName, playerXP FROM playerdata ORDER BY playerXP DESC Limit 10"); mysql_store_result(); mysql_fetch_row(row); sscanf(row, "p<|>s[600]d",p_top,score); format(string, sizeof string, "Top Player: %s | XP: %d",p_top,score); mysql_free_result(); ShowPlayerDialog(playerid, 108, DIALOG_STYLE_MSGBOX,"Top Player", string, "Close", ""); return 1; } its just showing 1 player..

Try

pawn Код:

new p_top[24],score,string[600],row[600];

mysql_query("SELECT playerName, playerXP FROM playerdata ORDER BY playerXP DESC Limit 10");
mysql_store_result();

while( mysql_fetch_row(row) ) {
    sscanf(row, "p<|>s[600]d",p_top,score);
    format(string, sizeof string, "%sTop Player: %s | XP: %d", string, p_top,score);
}

mysql_free_result();
ShowPlayerDialog(playerid, 108, DIALOG_STYLE_MSGBOX,"Top Players", string, "Close", "");
return 1;