Radio Streaming - 50% Lifetime Discount with purchase of any Joomla Web Radio Addon. Discount Code: STR15-Z
See Radio Streaming Plans

Results 1 to 8 of 8

Thread: Change calculation by rating

  1. #1
    Junior Member
    Join Date
    May 2017
    Posts
    7

    Change calculation by rating

    Is it possible to change the ranking calculation by average?
    Instead (10 + 1) / nº mathcs
    for
    (2 + 1) / nm?

    Thanks

  2. #2
    Administrator
    Join Date
    Jul 2015
    Posts
    65
    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

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

    Code:
    $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

    Code:
    $query="SELECT u.username,t.user_id,((t.correct_score*s.correct_score)+(t.correct_result*s.correct_result)+(t.incorrect_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

    Code:
    $query="SELECT u.username,t.user_id,((t.correct_score*s.correct_score)+(t.correct_result*s.correct_result)+(t.incorrect_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
    Code:
    $query="SELECT u.username,t.user_id,((t.correct_score*s.correct_score)+(t.correct_result*s.correct_result)+(t.incorrect_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
    Code:
    $query="SELECT u.username,t.user_id,((t.correct_score*s.correct_score)+(t.correct_result*s.correct_result)+(t.incorrect_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 ".

  3. #3
    Junior Member
    Join Date
    May 2017
    Posts
    7
    Thank you so much.

  4. #4
    Junior Member
    Join Date
    May 2017
    Posts
    7
    Did not work. I edited on the main site as in the test of core test result * 10.

  5. #5
    Administrator
    Join Date
    Jul 2015
    Posts
    65
    Hello,

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

  6. #6
    Junior Member
    Join Date
    May 2017
    Posts
    7
    On the topratingplayer page, change the average calculation.
    See.
    http://bembolao.com/files.zip
    These have been changed and placed in folders.

  7. #7
    Administrator
    Join Date
    Jul 2015
    Posts
    65
    Hello, for the rating page you will have to change the file

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

    Code:
    $query="SELECT u.username,t.user_id,((t.correct_score*t.correct_score)+(t.correct_result*t.correct_result)+(t.incorrect_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

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

  8. #8
    Junior Member
    Join Date
    May 2017
    Posts
    7
    Thank you, it worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •