Help For Top Player Mysql R41+

Help For Top Player Mysql R41+ - 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: Help For Top Player Mysql R41+ (/showthread.php?tid=673454)

Help For Top Player Mysql R41+ - brianrestup - 27.03.2020

How to create top player like, money,score with dialog.

Thanks Before.

Re: Help For Top Player Mysql R41+ - Symon - 27.03.2020

Which saving system are you using? Give us more info.

Re: Help For Top Player Mysql R41+ - brianrestup - 27.03.2020

I using mysql R1-4 sir, can u help me?

Re: Help For Top Player Mysql R41+ - SiaReyes - 28.03.2020

Code:

 "SELECT money FROM accounts ORDERBY money DESC LIMIT 30;"

This is the query, you can set limit like how many players you want to display. 30 would be enough.

Re: Help For Top Player Mysql R41+ - brianrestup - 28.03.2020

Quote:

Originally Posted by SiaReyes

Code:

 "SELECT money FROM accounts ORDERBY money DESC LIMIT 30;"

This is the query, you can set limit like how many players you want to display. 30 would be enough.

And how to add, PlayerName [ValueMoney] in dialog?

Re: Help For Top Player Mysql R41+ - ChuckyBabe - 28.03.2020

it should be like somehow like this.

"SELECT playername, money FROM accounts ......"