29.10.2014, 01:48
See if this helps any. You don't really need strval for moneyvariable:
pawn Код:
CMD:richlist(playerid, params[])
{
#pragma unused params
mysql_query("SELECT `username`, `money` FROM `data` WHERE `PlayerBanned` = 0 ORDER BY `money` DESC LIMIT 10");
mysql_store_result();
new ID = 0, output[800];
while(mysql_retrieve_row())
{
ID++;
new username[MAX_PLAYER_NAME], moneyvariable[80];
mysql_fetch_field_row(username, "user");
mysql_fetch_field_row(moneyvariable, "money");
format(output, sizeof(output), "%s %d. %s with %s dollars\n", output, ID, username, moneyvariable);
}
mysql_free_result();
return ShowPlayerDialog(playerid, 25, DIALOG_STYLE_MSGBOX, "Top 10 Players", output, "OK", "");
}

