SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 27/03/2020, 11:43 AM   #1
brianrestup
Little Clucker
 
Join Date: Sep 2019
Location: Indonesia
Posts: 18
Reputation: 0
Default Help For Top Player Mysql R41+

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


Thanks Before.
brianrestup is offline   Reply With Quote
Old 27/03/2020, 12:37 PM   #2
Symon
Gangsta
 
Symon's Avatar
 
Join Date: Apr 2019
Location: Italy
Posts: 862
Reputation: 69
Default Re: Help For Top Player Mysql R41+

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

Join The Server (play.symonscnr.com) | Discord | Website/Forum
Choose up from 5 different skills, Con Artist, Drug Dealer, Firefighter, Hitman and Terrorist.
Play as a Civilian or a LEO, bomb buildings/vehicles, rob shops or bank and many many more. Join us!
Symon is offline   Reply With Quote
Old 27/03/2020, 10:51 PM   #3
brianrestup
Little Clucker
 
Join Date: Sep 2019
Location: Indonesia
Posts: 18
Reputation: 0
Default Re: Help For Top Player Mysql R41+

I using mysql R1-4 sir, can u help me?
brianrestup is offline   Reply With Quote
Old 28/03/2020, 05:35 AM   #4
SiaReyes
Gangsta
 
Join Date: Mar 2019
Location: Coordinates X,Y,Z
Posts: 622
Reputation: 57
Default Re: Help For Top Player Mysql R41+

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.
SiaReyes is offline   Reply With Quote
Old 28/03/2020, 12:47 PM   #5
brianrestup
Little Clucker
 
Join Date: Sep 2019
Location: Indonesia
Posts: 18
Reputation: 0
Default Re: Help For Top Player Mysql R41+

Quote:
Originally Posted by SiaReyes View Post
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?
brianrestup is offline   Reply With Quote
Old 28/03/2020, 05:10 PM   #6
ChuckyBabe
Huge Clucker
 
ChuckyBabe's Avatar
 
Join Date: Aug 2013
Location: C:\Program Files\Rockstar Games\GTA San Andreas
Posts: 463
Reputation: 11
Default Re: Help For Top Player Mysql R41+

it should be like somehow like this.

"SELECT playername, money FROM accounts ......"
__________________
ChuckyBabe is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[MYSQL]-HARDCODING - Loading , Saving The player name from mysql PURG3D Scripting Help 8 06/09/2016 08:12 AM
[HELP]Mysql : Getting the top player. MrViolence101 Scripting Help 6 10/12/2014 12:43 AM
[HELP] Please help mysql id player Luca12 Scripting Help 3 26/02/2014 09:43 AM
[HELP] mysql player name Luca12 Scripting Help 8 17/02/2014 11:30 AM
MySQL player bug +REP Inn0cent Scripting Help 5 19/09/2013 09:43 AM


All times are GMT. The time now is 10:40 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.