I’m having the same issue. I also can’t find the scoring tables in phpmyadmin for manual change.
Scoring isn’t correct. Somebody predicted 4:1 for Brasil and got 11 points.
Others with the exact prediction get only 7!!!
see it here:
http://wordpress.org/support/topic/scoring-error-1
regards
Jens
Did you upgrade the plug-in?
EDIT:
You can change the scoring situation in the file: world-cup-predictor/admin/wcp-scoring.class.php. “For some reason when you change the scoring in the admin area it doesn’t change the file.”
The SQL file pushes data to the table “wcup_predictions” and under the last column labeled “points” you can alter you current score as it doesn’t change automatically once you fix the scoring file.
That’s all I can do, the plugin authors need to fix the issue.
you can change directly by ADMIN
@linux.sergio “For some reason when you change the scoring in the admin area it doesn’t change the file.”
“For some reason when you change the scoring in the admin area it doesn’t change the file.”
What is the reason? How can I change it manually?
Thread Starter
Euan01
(@euan01)
Still not working. I am scared to upgrade the plugin. I have nearly 4000 predictions and don’t want to lose them.
Tonight it will be corrected.
Well…
I got a huge issue. Every single member got zero points now. I entered the result of the fra – hon match and every single member got zero points instantly.
I tried to calculate the points. But it didn’t work. I deleted and entered the game results again, but it failed aswel. How can I fix it? :/
v. 1.9.1
If you have access to the database, run the command:
ALTER TABLE wp_wcup_prediction CHANGE wwhen wwhen TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
And:
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)
@euan01, @nickcav, @jefigo, @mcbot, @linux.sergio, @tiiruff and @stadtaffe7
Please like to get a feedback if everything is working correctly for you now. You could inform the link to your respective websites?
The plugin update didn’t work for me but I used your commands and just changed the wp_ to what my database prefix is, now everything works fine.
