SA-MP Forums Archive
[FilterScript] [FS] Top 10 Players MySQL - 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: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [FilterScript] [FS] Top 10 Players MySQL (/showthread.php?tid=121456)



[FS] Top 10 Players MySQL - lukitaxxx_samp - 17.01.2010

Hello everyone, first of all pardon my English, but I'm using a translator because I am from Argentina.
This is a simple filterscript, with queries to servers that use mysql.

Replace the data from "KILLS", "DEATHS", "name" Banner "by using its tables.

Код:
format(query, sizeof(query), "SELECT name, banned, kills, deaths FROM users WHERE kills>deaths ORDER BY kills-(deaths/2) DESC LIMIT 10");
samp_mysql_query(query);
Other Example:
Код:
format(query, sizeof(query), "SELECT nombre, ban, asesinatos, muertes FROM usuarios WHERE asesinatos>muertes ORDER BY asesinatos-(muertes/2) DESC LIMIT 10");
samp_mysql_query(query);
Bye



Re: [FS] Top 10 Players MySQL - s0nic - 17.01.2010

Ive made it possible with php but its the first time ive personally seen it ig.
Nice job!


Re: [FS] Top 10 Players MySQL - RenisiL - 17.01.2010

wow great


Re: [FS] Top 10 Players MySQL - lukitaxxx_samp - 21.01.2010

I have the version with PHP as my server I use runs with mysql web. I did this to post it here because it is my first post in the samp forum. and wanted to start a big .. I'm trying to make a top with dini, or dudb, almost finish it so any server may have top players ... jaja


Re: [FS] Top 10 Players MySQL - Karkanos - 16.02.2010

hay amigo no entiendo como funciona pero funciona para la web ?


Re: [FS] Top 10 Players MySQL - xenowort - 17.02.2010

no este es un idiota! lo conosco me pedia ayuda por todo no sirve si no le hacne el query es una sentencia vacia y sin sentido.


Re: [FS] Top 10 Players MySQL - [LNL]Remulis - 17.02.2010

nice mate. keep it up


Re: [FS] Top 10 Players MySQL - Guest4390857394857 - 16.03.2014

what abt the latest mysql r7 plugin please help
mysql_query format is changed,
can i get new version dude,,
i tried a lot scripting top!


Re: [FS] Top 10 Players MySQL - CuervO - 16.03.2014

Quote:
Originally Posted by xenowort
Посмотреть сообщение
no este es un idiota! lo conosco me pedia ayuda por todo no sirve si no le hacne el query es una sentencia vacia y sin sentido.
You're the only idiot here.


Re: [FS] Top 10 Players MySQL - TheFlyer - 16.03.2014

Quote:
Originally Posted by ShivRp
Посмотреть сообщение
what abt the latest mysql r7 plugin please help
mysql_query format is changed,
can i get new version dude,,
i tried a lot scripting top!
mysql_query change it to mysql_function_query