Raised This Month: $51 Target: $400
 12% 

Rank calculation / sql


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
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
 



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

Forum Jump


All times are GMT -4. The time now is 01:08.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode