In fact, they are two separate issues.
The issue of bonus points are not computing will be evaluated tonight. Probably this problem is affecting websites who underwent upgrade from previous versions of the plugin and the ALTER TABLE command must have failed for some reason, causing the auto update in the table prediction remains held. In this case, depending on the time zone in question, the predictions of Wwhen field may be being recorded with the subsequent kickoff match time table.
The response in question was in relation to bonus points, explaining that they are earned even if the user has the wrong prediction on the winner of the match.
@pokerbanter @landoweb
I’m on ver. 1.9.
Today i’ve also noticed wrong bonus points calculation (same situation as described by @pokerbanter).
So i’ve altered table wp_wcup_prediction and edited world-cup-predictor.php as provided by @landoweb.
Now works perfectly fine !!!
Just edited scoring for match no.2 and all points with two of the bonuses appeared correctly.
Thanks for all the hints, time to open my beer 🙂
thanks @dafone
don’t mind editing php files or editing values inside myphpadmin but im unsure what the ALTER TABLE is and how to do it so I beter just await the update to be safe I suppose.
@dafone
In fact, users who have experience to execute SQL commands on the database must have solved the issue with the instructions this morning.
But anyway, tonight I have to work on a version 1.9.1 just to fix this issue and solve the problem for users who do not have experience to make changes directly in the database.
I will test all situations upgrade before publishing that version 1.9.1, to ensure that regardless of the current version, the plugin work properly after this new upgrade.
Obviously not recommend websites where the plugin is working correctly perform the upgrade performed without backup his data before.
I can’t find @landoweb’s advise how to modify world-cup-predictor.php and to alter the wp_wcup_predictor table. Where is it?
Thanks
My points scoring and bonus calculations were working fine until last night. Now bonus points are not calculating! I am on WordPress version 3.5 and using plugin version 1.7 – any advice?
@euan01
I suggest you perform the upgrade to version 1.9.1. In version 1.7 there was the auto update in Wwhen table field wp_wcup_prediction when you post the results.
@jue_mue
Run the command:
ALTER TABLE 'wp_wcup_prediction' CHANGE 'wwhen' 'wwhen' TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
Replacing the single quotes with backticks.
Probably you also need to run the following command to set the time of their predictions:
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)
If you are new to tinker in the database, I suggest you perform the upgrade to version 1.9.1 of the plugin.
@pokerbanter
Version 1.9.1 was released. Recommend to perform the upgrade and test, do not forget to do a backup of your data before performing the upgrade.
@tarmost
Theoretically version 1.9.1 should solve their problems relating to bonus points. I suggest that you upgrade.
@landoweb
I just uploaded v 1.9.1 and replaced it for 1.9. Anything else I have to do now? Run the table upgrade anyway?
Thanks for updating…
@jamesjgbm
I suggest that you upgrade to version 1.9.1 and then go to Admin >> World Cup >> Predictions >> Score Matches, to recalculate the score, now including bonus points.
@jue_mue
If you did the updgrade, you not need to run the SQL commands mentioned above, because the upgrade has already made them for you. Now you just need to access the Score Matches option and press the Score Selected button to recalculate the plugin matches the points already made.
@landoweb
I updated, run the Score matches in the Admin area… now, user points are back to zero… 🙁
@tiiruff
It was unclear whether the score is being added correctly for you or not. If not, I recommend that you upgrade to version 1.9.1.