SA-MP Forums Archive
MySQL Top Killer - 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 Top Killer (/showthread.php?tid=343712)


MySQL Top Killer - SanAndreasVille - 18.05.2012

Hello I have a question how can i make a command to list the best killers of the server? with /topkiller
I have a MySQL system and must load from the database accounts -> Kills

Re: MySQL Top Killer - Mandrakke - 18.05.2012

Код:
SELECT * FROM Users ORDER BY Kills DESC LIMIT 0,10
will load the 10 best players.

AW: MySQL Top Killer - SanAndreasVille - 18.05.2012

thanks, and how can i show this in a Dialog?

Re: MySQL Top Killer - Mandrakke - 18.05.2012

just retrieving the rows and concatenating the players info into an string, then show the dialog with this string to the player.

PS: If are you expecting me to do it, give up and wait for other person respond your topic.

Re: MySQL Top Killer - milanosie - 18.05.2012

Hate how people don't think.
Write it down step by step:


  1. Create String.
  2. Get Info
  3. Create Dialog
  4. format the string with the info,
  5. Show the string in dialog....
Basic scripting