PDA

View Full Version : Change calculation by rating



ekosak
16-05-2017, 09:33 PM
Is it possible to change the ranking calculation by average?
Instead (10 + 1) / nº mathcs
for
(2 + 1) / nm?

Thanks

kostas
22-05-2017, 12:33 PM
Hello,

To change the calculation of the rating you will have to edit parts of code,

for the module that displays the top players by rating you will have to change the file

<joomla installation>/modules/mod_masterleague_topratingplayers/helper.php

~line 30



$query="SELECT u.username,t.user_id,((t.correct_score*10+t.correc t_result-t.correct_score)/(t.correct_result+t.incorrect_result)) as rating ".


to



$query="SELECT u.username,t.user_id,((t.correct_score*2+t.correct _result-t.correct_score)/(t.correct_result+t.incorrect_result)) as rating ".



the rating is also in case two players have the same points, so you will have to change that part of code too

file <joomla directory>/components/com_multileague/models/standings.php

~line 50



$query="SELECT u.username,t.user_id,((t.correct_score*s.correct_s core)+(t.correct_result*s.correct_result)+(t.incor rect_result*s.incorrect_result)) as points,(t.correct_result+t.incorrect_result) as matches,t.correct_score as win,t.correct_result as draw,t.incorrect_result as lose,((t.correct_score*10+t.correct_result)/(t.correct_result+t.incorrect_result)) as rating ".



to



$query="SELECT u.username,t.user_id,((t.correct_score*s.correct_s core)+(t.correct_result*s.correct_result)+(t.incor rect_result*s.incorrect_result)) as points,(t.correct_result+t.incorrect_result) as matches,t.correct_score as win,t.correct_result as draw,t.incorrect_result as lose,((t.correct_score*2+t.correct_result)/(t.correct_result+t.incorrect_result)) as rating ".


and

~line 100


$query="SELECT u.username,t.user_id,((t.correct_score*s.correct_s core)+(t.correct_result*s.correct_result)+(t.incor rect_result*s.incorrect_result)) as points,(t.correct_result+t.incorrect_result) as matches,t.correct_score as win,t.correct_result as draw,t.incorrect_result as lose,((t.correct_score*10+t.correct_result)/(t.correct_result+t.incorrect_result)) as rating ".


to


$query="SELECT u.username,t.user_id,((t.correct_score*s.correct_s core)+(t.correct_result*s.correct_result)+(t.incor rect_result*s.incorrect_result)) as points,(t.correct_result+t.incorrect_result) as matches,t.correct_score as win,t.correct_result as draw,t.incorrect_result as lose,((t.correct_score*2+t.correct_result)/(t.correct_result+t.incorrect_result)) as rating ".

ekosak
22-05-2017, 08:29 PM
Thank you so much.

ekosak
22-05-2017, 09:20 PM
Did not work. I edited on the main site as in the test of core test result * 10.

kostas
23-05-2017, 10:30 AM
Hello,

please let us understand better what you want to do, what page of the component you want to change?

ekosak
23-05-2017, 08:59 PM
On the topratingplayer page, change the average calculation.
See.
http://bembolao.com/files.zip
These have been changed and placed in folders.

kostas
25-05-2017, 10:36 AM
Hello, for the rating page you will have to change the file

<joomla directory>/components/com_multileague/models/rating.php ~line 40



$query="SELECT u.username,t.user_id,((t.correct_score*t.correct_s core)+(t.correct_result*t.correct_result)+(t.incor rect_result*t.incorrect_result)) as points,((t.correct_score*10+t.correct_result-t.correct_score)/(t.correct_result+t.incorrect_result)) as rating ".


to



$query="SELECT u.username,t.user_id,((t.correct_score*t.correct_s core)+(t.correct_result*t.correct_result)+(t.incor rect_result*t.incorrect_result)) as points,((t.correct_score*2+t.correct_result-t.correct_score)/(t.correct_result+t.incorrect_result)) as rating ".

ekosak
25-05-2017, 10:22 PM
Thank you, it worked.