Points error, prediction time changes with match result

  • Resolved tarmost

    (@tarmost)


    10 years, 8 months ago

    I have 2 problems with calculating points.
    1. I know what’s the problem, but i don’t know how to fix it. First I change the match – right score and mark as finished. Unfortunately with these changes also change user prediction time. Why? And because it’s after the game starts, no points for any user. So I have to change manually users prediction times (earlier) to calculate points.
    Prediction time is not changing on those predictions which are wrong, 0 points. ???

    2. No bonus points calculated.

    I have used that plugin before (euro and world cup) and worked perfectly, so i think i know how to use it. But never knows.
    Hope to get quick answers and plugin fix.

    https://www.ads-software.com/plugins/world-cup-predictor/

Viewing 9 replies - 1 through 9 (of 9 total)

  • Just and offer, haven’t tried it,
    but may-be you can remove the match score, and go to match settings for first match, update match time to be after the prediction time.
    Than, enter the match score again and mark it as finished.

    hope it helps …

    Plugin Author landoweb

    (@landoweb)

    Probably you should be passing the problem that had until version 1.7 of the plugin. You have access to your database? If so, I suggest you do the following:

    First, run the command:

    ALTER TABLE ‘{$wpdb->prefix}{$this->prefix}prediction’ CHANGE ‘wwhen’ ‘wwhen’ TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

    Replacing wpdb->prefix and this->prefix defined by prefixes on your site. In my case:

    ALTER TABLE ‘cup_wcup_prediction’ CHANGE ‘wwhen’ ‘wwhen’ TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

    Then run the command:

    UPDATE ‘cup_wcup_prediction’ SET wwhen = ‘2014-05-13 11:20:19’ WHERE match_id = 1

    Then go to Admin >> World Cup >> Predictions >> Matches Score, select the match Brazil vs. Croatia and click the Score Selected button.

    Note: the backticks in the names of tables and columns have been replaced by single quotes here because the formatting of the forum.

    This is being discussed in https://www.ads-software.com/support/topic/scores-are-not-updated?replies=38

    Thread Starter tarmost

    (@tarmost)

    ok,that’s complicated, have no idea what to do.
    I had last version (1.9) installed (updated).
    Is there any other solution. Like waiting for the next update.

    Thread Starter tarmost

    (@tarmost)

    Thank you very much. Works now.
    Update didn’t solve the problem, but i run the alter table command. Somehow i did it. wasn’t pretty sure, what i was doing, but it did work.
    kohvipaks.oo-oo.ee

    Plugin Author landoweb

    (@landoweb)

    @tarmost

    This problem is solved? What is the link to your website?

    Thread Starter tarmost

    (@tarmost)

    kohvipaks.oo-oo.ee

    Plugin Author landoweb

    (@landoweb)

    I could not register me, but from what I noticed, everything is working, right?

    Thread Starter tarmost

    (@tarmost)

    Hi,
    Everything is working and once again thank you and thanks to ianhaycox who started this plugin.
    All the best.

    Plugin Author landoweb

    (@landoweb)

    Ok. Topic is resolved then.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Points error, prediction time changes with match result’ is closed to new replies.