New version 2.5.0

If you upgraded to the new version, but would like to downgrade to version 2.4.4 and you don’t have a database backup, follow these steps:

1. Download previous version from https://downloads.www.ads-software.com/plugin/football-pool.2.4.4.zip
2. Open the file /data/install.txt from the zip in a text editor and replace the string “{$prefix}” with the string “pool_”+table prefix (on default install this would be “pool_wp_”.
3. Run the script on the database. It only recreates the tables that were removed in the update. Existing tables will be left alone.
4. Overwrite the files on your server with the files in the zip.
5. Run the following SQL script on the database (assuming you have the default table prefix “wp_”):

UPDATE wp_options
SET option_value = REPLACE( option_value, '"db_version";s:5:"2.5.0"', '"db_version";s:5:"2.4.4"' )
WHERE option_name = 'footballpool_plugin_options'

6. Open the wp-admin and do a full calculation.

The full and Smart calculation was very useful. Please add it back to the new update!

The old calculation had two big problems: it could timeout easy on large databases and it showed incorrect data in a ranking during the calculation.

To fix this I had to completely redo the way the calculation was done. And smart calculation is not possible in this new method. At least not in the way it used to work. I had to choose the lesser of two evils ??

Smart calculation is useful for situations where a lot of custom rankings are defined and most of these rankings don’t have updates in their linked matches/questions. The new situation will calculate those as well and therefor the calculation will take longer than it used to in version 2.4.4. But if this does not apply or the calculation time is not that long, then you’re better of with the new version.

If you want the smart calculation back, then you can downgrade to 2.4.4. And just ignore the 2.5.x versions.

In a future version I may reconsider the smart calculation.

Hi Antoine,
unfortunately I landed on this very page AFTER I updated. And of course Murphy’s law kicked in. The update messed up the current installation. i.e. all pics seem to be deleted. (stadiums, flags, teams) I know, my fault.
But I’d like to recoomend mentionig your above warnings as well as the update content in the wp plugin notice.

I’d like to offer the coming Euro Cup 16 -Toto as a little gimmick to the vistiors of the page. Any idea how I could fix my problem efficiently?

Thanks for your entire effort anyway. Seems to be a great plugin in spite of my dilemmea.

I added an upgrade notice in the readme file and WP used to show these, but you’re right, WP doesn’t show these anymore. But this page shows a workaround that I will implement in future version. Just to inform people that they should always backup their data.

I’d like to offer the coming Euro Cup 16 -Toto as a little gimmick to the vistiors of the page. Any idea how I could fix my problem efficiently?

Not sure what your problem is, but please open a new topic if it is not already answered here.