WordPress.org

Ready to get started?Download WordPress

Forums

World Cup Predictor
[resolved] Points Knockout Draw (5 posts)

  1. pdelosca
    Member
    Posted 2 months ago #

    On my site (v 1.9.1), points in the knockout stage as defined by panalties were miscalculating.

    I thought the points calculating again the problem could be fixed.
    I entered the result again. Now observe that all participants get 0 points :(

    Example
    Brazil - Chile
    Score: 1 (3) - 1 (2)
    Prediction: 1 (4) - 1 (3)
    Points: 0

    My points are configured this way:

    Exactly 10
    Draw: 5
    Win: 4
    Bonus goals: 1

    Thanks.
    Pablo

    https://wordpress.org/plugins/world-cup-predictor/

  2. landoweb
    Member
    Plugin Author

    Posted 2 months ago #

    First, go to your DB and run the command:

    ALTER TABLE wp_wcup_prediction CHANGE wwhen wwhen TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

    And the command:

    UPDATE wp_wcup_prediction p INNER JOIN wp_wcup_match m ON m.match_id = p.match_id SET p.wwhen = DATE_SUB(m.kickoff, INTERVAL 1 HOUR)

    Now, in WordPress panel, go to World Cup >> Predictions >> Score Matches, select the match and click on button Score Selected.

  3. pdelosca
    Member
    Posted 2 months ago #

    Thank you so much!

    Everything returned to normal except for a couple errors

    Match: Costa Rica Greece

    Correct Score: 1 (5) - 1 (3)
    User Prediction 1: 2 (4) - 2 (2) Points: 10
    The right is 4 points What can be happening?

    Then my point scale goes something logical, but "unfair"

    User Preduction 2: 1 (3) - 1 (4) Points: 7
    User Prediction 3: 1 (4) - 1 (2) Points: 6
    User Prediction 4: 2 (3) - 2 (4) Points: 5

    My points are configured this way:

    Exactly 10
    Draw: 5
    Win: 4
    Bonus goals: 1

  4. landoweb
    Member
    Plugin Author

    Posted 2 months ago #

    The exactly consider the score of regular time plus score of penalties. In this case, 6x4. But the user don't receive the bonus points for number of goals (this consider only the regular time).

  5. pdelosca
    Member
    Posted 2 months ago #

    Thanks!

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.