View Single Post
Author Message
JocAnis
Veteran Member
Join Date: Jun 2010
Old 10-20-2018 , 04:43   Rank calculation / sql
Reply With Quote #1

how to calculate the best rank in the plugin, if i want 3 parameters to be included?
here is the table, for example:



wins column, should be priority in calculation, but im thinking of adding 'players' to rank cuz i would like to award players who participated in cups where the amount of players were bigger, so it means there was less chance to everyone of winning

with just first two columns in calculation, it would be:

SELECT * FROM table_name ORDER BY MIN( wins/cups ) ASC LIMIT 15
if the syntax is even allright

thanks in advance..ps maybe it could be posted in offtopic thread dunno

and ofc any other but better math is welcomed
__________________
KZ Public Autocup - PrimeKZ

My blog: http://primekz.xyz (in progress...) - not active (dec 2022)

Last edited by JocAnis; 10-20-2018 at 05:05.
JocAnis is offline