mysql sort by Money,score,etc. problem

mysql sort by Money,score,etc. problem - 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: mysql sort by Money,score,etc. problem (/showthread.php?tid=586002)

mysql descending problem - PowerF - 18.08.2015

I try to make this command,but the result is not right..

Код:

COMMAND:topmoney(playerid, params[])
{
	new p_top[24],money,string[600],row[600];

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

	while( mysql_fetch_row(row) ) {
		sscanf(row, "p<|>s[600]d",p_top,money);
		format(string, sizeof string, "%s {FFFFFF}Nickname: %s {FF0000}|| {00D5FF}Money: %d\n", string, p_top,money);
	}

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