WordPress.org

Forums

World Cup Predictor
[resolved] Points error, prediction time changes with match result (10 posts)

  1. tarmost
    Member
    Posted 11 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://wordpress.org/plugins/world-cup-predictor/

  2. liorclub
    Member
    Posted 11 months ago #

    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 ...

  3. landoweb
    Member
    Plugin Author

    Posted 11 months ago #

    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 http://wordpress.org/support/topic/scores-are-not-updated?replies=38

  4. tarmost
    Member
    Posted 11 months ago #

    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.

  5. tarmost
    Member
    Posted 11 months ago #

    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

  6. landoweb
    Member
    Plugin Author

    Posted 11 months ago #

    @tarmost

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

  7. tarmost
    Member
    Posted 11 months ago #

    kohvipaks.oo-oo.ee

  8. landoweb
    Member
    Plugin Author

    Posted 11 months ago #

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

  9. tarmost
    Member
    Posted 11 months ago #

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

  10. landoweb
    Member
    Plugin Author

    Posted 11 months ago #

    Ok. Topic is resolved then.

Reply

You must log in to post.

About this Plugin

  • World Cup Predictor
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic