22.08.2016, 20:10
This section isn't for requesting scripts(shame on the people who flat out gave a script), it's for getting help with scripting. Take a look at:
Asking Good Questions
On Topic: You don't need to loop through all rows to get the account with the highest amount. You can limit and ORDER By to get the richest account in the first row.
Assuming you're using BlueGs MySQL plugin, use mysql_tquery to send the query. In the query callback, you can use cache_* functions to get data from the first row(ex: cache_get_field_content_int(0, "Cash").
Asking Good Questions
On Topic: You don't need to loop through all rows to get the account with the highest amount. You can limit and ORDER By to get the richest account in the first row.
pawn Код:
SELECT Cash, Username FROM accounts ORDER BY Cash DESC LIMIT 1