=== wp-championship ===
Contributors: tuxlog
Donate link: http://www.tuxlog.de/
Tags: championship, guessing, game, soccer, sport
Requires at least: 6.2
Tested up to: 7.0
Stable tag: 11.2
License: GPLv2 or later
License URI: https://www.gnu.org/licenses/gpl-2.0.html

wp-championship is a plugin for wordpress letting you play a guessing game of a tournament e.g. soccer

== Description ==
wp-championship is a plugin for wordpress letting you play a guessing game of a tournament e.g. soccer

Features:

 + define number of groups, and points given to the winner, looser of each match
 + define teams and a team specific icons
 + define matches finalround and pre-final round
 + for each user you can set a substitute
 + sends mails about current game status (optional)
 + define game admins to edit match results
 + shows various stats for admin and users
 + allows to arrange tippgroups as a kind of team guessing
 + access via XMLRPC is possible
 + various joker features (e.g. each player may select some matches and gets double points on it) BETA
 + a lot of data for various tournaments and leagues (German Bundesliga, WM 2018, EM 2021)
 + interface ti OpenLeagueDB to fetch team and match data automatically

Credits:
Thanks go to all who support this plugin, with  hints and suggestions for improvment and especially to Andy Chapman for doing a lot of tests



== Installation ==

	1.  Upload to your plugins folder, usually
	    `wp-content/plugins/`, keeping the directory structure intact
	    (i.e. `wp-championship.php` should end up in
	    `wp-content/plugins/wp-championship/`).

	1.  Activate the plugin on the plugin screen.

	1.  Visit the configuration page (wp-championship) to
            configure your guessing game

	1.  Optional: load teams and matches into your database using the import feature.

	1.  Recommende for updates: Please remember to deactivate and activate the plugin once for database updates

== Frequently Asked Questions ==
= Where can I get further information about the plugin? =

There are several resources to visit:

* [A quick english reference for wp-championship][wpcsref]
* [The german wp-championship page][wpcspost]
* [The german manual wp-championship][german]

[german]:   http://www.tuxlog.de/wp-championship-handbuch/ "German manual for wp-championship"
[wpcsref]:  http://www.tuxlog.de/wordpress/2013/wp-championship-quickreference-english/ "quick reference for wp-championship"
[wpcspost]: http://www.tuxlog.de/wp-championship/


== Screenshots ==
1. wp-championship stats
2. wp-championship tipp dialog

== Changelog ==
= 2026-05-27 v11.2 =
* fixed team delete in admin dialog
* fixed WM 2026 data for final round

= 2026-05-22 v11.1 =
* added playersonly parameter to cs-userstats shortcode to add show only the player ranking of one tippgroup
* added data for the WM 2026

= 2024-07-11 v11.0 =
* fixed joker calculation

= 2024-06-30 v10.9 =
* added number of tippgroup members to stats8
* added option to sort tippgroup stats (cs-stats8) by average
* added option to show fullnames in rnaking (cs-suerstats)
* fixed, show all entries for stats4 in tournament mode
* fxied a special case during final round update

= 2024-06-15 v10.8 =
* fixed frequently nonce problem on some of the statistic

= 2024-06-08 v10.7 =
* fixed some typo in german translations
* fixed label for matchid column for final round

= 2024-06-07 v10.6 =
* fixed new widget for not approved guessing game users

= 2024-06-07 v10.5 =
* added new widget to show infos about logged in user
* fixed typo in labels dialog
* fixed reset settings in xmlrpc labels
* fixed show/hide matchid column of tiptable
* fixed division by zero warning in log when tip is missing

= 2024-05-27 v10.4 =
* fixed add new user bug

= 2024-05-20 v10.3 =
* fixed missing tippspiel user bug

= 2024-04-04 v10.2 =
* fixed typo in XML RPC class
* added data for teams andmatches for the EM2024

= 2023-09-02 v10.1 =
* WP 6.2 ist now required
* made source more compliant to the WP coding standards and using newer functions from WordPress
* fixed some typos in translation
* fixed some minor problems with tippgroup statistics
* changed default parametersfor easier configuration

= 2023-08-14 v10.0 =
* OpenLigaDB seems to have issues with there SOAP api, so I switched to json api.

= 2023-06-18 v9.9 =
* added data for women worldchampionship 2023
* fixed incompatibility with DB drop-in
* added new option for cs_stats4 to show all tips and not only tips of finished matches
* added number of missed tips for each player in admin stats

= 2022-11-19 v9.8 =
* fixed column sorter on tippdialog for hidden columns
* extended statistics to show championtipp in ranking
* fixed statistic table heading

= 2022-10-21 v9.7 =
* fixed user auto create feature for new database structures
* fixed some santizing checks

= 2022-10-11 v9.6 =
* changed game data for the WM 2022 due to changes of the FIFA

= 2022-07-11 v9.5 =
* added data for WM 2022 in Qatar
* moved old data to "old"- directory

= 2022-06-10 v9.4 =
* fixed typo in setup data

= 2022-06-06 v9.3 =
* enhanced URL length for OL DB import
* added some missing security checks

= 2022-06-02 v9.2 =
* fix invalid insert of users with some settings
* added some missing nonce checks

= 2021-10-17 v9.1 =
* added hint if preeliminaries of OpenLigaDB import are not met
* added joker feature, you can set joker matches which gives the double points, either per user or for global for all users

= 2021-07-03 v9.0 =
* fixed finals calculation for non unique target teams
* fixed typo in EM2021 match data
* added cs_stats9 champion-tip stats
* added data for the german Bundesliga 2021/22

= 2021-06-12 v8.9 =
* fixed typos in EM2921 data
* fixed german translation
* fixed table toggle in cs_userstats

= 2021-05-31 v8.8 =
* fixed problem with adding new users on some setups

= 2021-05-12 v8.7 =
* fixed user settings dialog
* fixed translation

= 2021-05-08 v8.6 =
* added new feature to hide finished games in tip dialog

= 2021-05-06 v8.5 =
* fixed typo in EM2021 data

= 2021-05-05 v8.4 =
* added data for EM 2021

= 2020-09-09 v8.3 =
* fixed icon representation
* fixed german translations

= 2020-09-06 v8.2 =
* fixed deprecated create_function call
* added data for German bundesliga 2020/2021
* added support to import data from OpenligaDB

= 2020-05-20 v8.1 =
* fixed WPLANG warnings
* fixed deprecated calls

= 2019-08-03 v8.0 =
* added data for German Bundesliga 2019/2020

= 2018-08-27 v7.9 =
* replaced deprecated create_function calls
* changed translation to be compatible with WordPress standards

= 2018-07-18 v7.8 =
* reduced reminder mails to one mail per check not one mail per match
* fixed tippgroup parameter passing for stats in some special cases
* added option to send mails as text not HTML
* fixed typo in user tipp
* fixed a matchtime typo in Matches 59 and 60
* added data for German bundesliag 2018/2019

= 2018-06-11 v7.7 =
* add submit buttons after eacht section to support quicker tipps
* fixed tablesorter for different month in one round

= 2018-06-11 v7.6 =
* fixed a typo in the match data, matcfh 40 is on 24th not on 23th
* fixed a typo in a select to substitute another player


= 2018-05-31 v7.5 =
* fixed some typos and changed times in match data for WM2018

= 2018-05-26 v7.4 =
- added new headline for cs-stats8 and show message if tippgroups are not activated
- switched from user_nicename to display_name to show the name the user selected in the profile dialog of WordPress
- surpress some warnings of undefined variables
- fixed incompatibility with Outlook mails
- english translation updated. Thanks to Kristin.


= 2018-01-14 v7.3 =
- added new data for the WM2018 in russia

= 2017-08-03 v7.2 =
* added new data for Bundesliga 2017/2018 - Thanks to Max

= 2017-01-22 v7.1 =
* added tippgroup table to remove tables function
* fixed auto add admin as player
* fixed show only a number of matches, failed if less then wanted number of matchdays left
* fixed import data without truncating db-tables

= 2016-08-05 v7.0 =
* added penalty/bounus points feature for users
* switched database ddl to dbDelta syntax
* replaced deprecated function get_currentuserinfo
* added feature to only display a given number of match days
* added tippgroup admin dialog to manage tippgroups better
* added switch to activate/deactivate tippgroups
* added cs-stats8 - stats for tippgroups
* added new widget to show stats for tippgroups
* added option to select tippgroup from tipp dialog
* extended cs-stats1 with column for number of tipps
* added data for 1. Bundesliga 2016/2017 Thanks to Mario
* added data for 2. Bundesliga 2016/2017 Thanks to Matthias

= 2016-05-18 v6.9 =
* fixed show tips was not saved in admin dialog
* adopted default css to twentysixteen Theme

= 2016-05-13 v6.8 =
* fixed team data and replaced wrong icon

= 2016-05-10 v6.7 =
* fixed permissions for Switzerland icon
* fixed validation rule for separate threshold value
* made plugin independent from privileges to create temporary tables
* fixed typo in EM 2016 team name

= 2016-03-13 v6.6 =
* added Icons and SQL and CSV for EM 2016 in France -  Thanks to all who helped :-))

= 2016-03-01 v6.5 =
* fixed admin dialog XMLRPC options
* adopted mysql version check to mysqli api

= 2016-01-03 v6.4 =
* updated data for Bundesliga 2015/2016, dates and times were updated

= 2015-11-26 v6.3 =
* updated data for Bundesliga 2015/2016, dates and times were updated

= 2015-11-07 v6.2 =
* fixed php warning when file was called directly

= 2015-11-06 v6.1 =
* fixed ajax problem for stats4-stats7

= 2015-11-04 v6.0 =
* switched to ajax in backend
* removed core dependencies
* sanitize post calls

= 2015-10-29 v5.9 =
* fixed some potential sql injection leaks

= 2015-09-06 v5.8 =
* updated data for Bundesliga 2015/2016, dates and times were updated

= 2015-08-15 v5.7 =
* updated data for Bundesliga 2015/2016, dates and times were updated

= 2015-06-27 v5.6 =
* added data for Bundesliga 2015/2016
* fixed import (imported zero dates sometimes)


= 2015-04-06 v5.5 =
* updated data for Bundesliga 2014/2015, final update

= 2014-12-25 v5.4 =
* updated data for Bundesliga 2014/2015, dates and times were updated

= 2014-10-23 v5.3 =
* fixed data for Bundesliga 2014/2015 dates were not loaded correctly

= 2014-09-30 v5.2 =
* updated data for Bundesliga 2014/15

= 2014-09-12 v5.1 =
* updated data for Bundesliga 2014/15

= 2014-09-01 v5.0 =
* fixed wrong warning message when saving tipps (for champion tip)

= 2014-08-21 v4.9 =
* fixed quotes in Bundesliga csv file

= 2014-08-15 v4.8 =
* added parameter for one side tipp, choice between with tendency only, withour tendency only and always
* added parameter to set final winner in case you are guessing on results after 90 Minutes which can be tied in the final
* added german Bundesliga 2014/2015 as SQL and CSV. Thanks to Manuel

= 2014-06-17 v4.7 =
* added responsive css for tipp table (uses CSS3)
* replaced use of gmt_offset for mailservice
* if tipp could not be saved because match has already started the wrong tip was displayed one time
* fixed calc points for one side goal tip

= 2014-06-06 v4.6 =
* fixed typos in csv files

= 2014-05-24 v4.5 =
* added csv import and export for teams and matches
* updated jquery.tooltip.js to v1.1 and made it work with bootstrap themes
* fixed typo when deleting preround matches
* updated manual
* removed dead code
* fixed problem while editing final matches

= 2014-05-05 v4.4 =
* fixed some table names in sqls to vars from globals.php
* fixed bug for direct compare for german bundesliga
* fixed typo for WM2014 Match 59
* added support link
* added contextual help

= 2014-04-15 v4.3 =
* fixed SQL for WM2014
* added SQL for WM2014 with CEST timezones
* fixed delete team in team edit dialog

= 2014-02-15 v4.2 =
* added teams andmatches for the soccer-world-championship 2014 (Thanks to Dieter Pfenning for all your work)
* made many functions pluggable (you can overwrite them from within e.g. functions.php)
* you can now store icons in YourThemefolder/wp-championship/icons
* you can now store xwp-championship.css in YourThemefolder/wp-championship/ too
* you can now override cs-stats.php ,cs-groupstats.php and cs-matchstats.php if you place a file with the same name in YourThemefolder/wp-championship/
* removed jquery.dimensions enqueue since it is part of jquery now
* removed old icons

= 2013-10-23 v4.1 =
* fixed adding a match to the final round
* fixed cs-stats5 results were shifted when player did not enter a tip for every match
* removed timezone calc for client side due to geoip service was shut down
* added english quickreference guide

= 2013-08-04 v4.0 =
* fixed setup because default admin entry was not correct
* added icons and sql for Bundesliga 2013/2014

= 2012-11-24 v3.9 =
* add the possibility to give each team a penalty in points

= 2012-10-09 v3.8 =
* load javascript in backend only on wp-championship pages
* add cs-stats7 Guesser of the month stats
* changed enqueue script to proper use with plugins_url

= 2012-07-06 v3.7 =
* added new option for goalsum tip you only hit if your tipp is euqal goalsum not equal or greater
* added sql and icons for Bundesliga 2012/2013
* added columnd points to stats4
* added stats6 to show all matches from one team
* extended tipp-aids in tippdialog with stats6 when hovering over the teamname

= 2012-06-25 v3.6 =
* fixed the widget display name
* extended goal sum tipp to accept a sum of 0
* fixed goalsum tipp could only be entered for all games at once
* points for goalsum tipp where assigned when tipp was >= result, changed this to =
* tipps from other players are now shown directly after the match has started in stats4
* extended selection filter to select from match and player
* fixed a bug in team stats, count of wins and loss

= 2012-06-10 v3.5 =
* fixed substitue list contained all usernames not only the players in tip dialog
* fixed wrong trend was shown at first result
* fixed a numbering issue with the widget
* fixed display average in the widget
* trend was lost when admin entered tips but no results
* mailreminder was not send due to a typo in date variable

= 2012-06-03 v3.4 =
* fixed problem with table sorting option
* fixed some typos in readme.txt

= 2012-06-01 v3.3 =
* fixed xmlrpc statistic 7 (all tables were displayed independent of the parameter)
* fixed first tipp when user was not in cs_users


= 2012-05-20 v3.2 =
* added hover table feature to tipp dialog (shows an ajax like group table when hovering over the group id)
* fixed uninitialized value fpr cs_sort_tipp

= 2012-05-18 v3.1 =
* fixed deprecated use of user_level (leads to many many php notices)
* fixed problem with entering a wrong tipp as first tipp (all tips were set to -1)
* fixed html error in confirmation mail
* removed deprecated parameter from add_option in setup.php (leads to many php notices during activation)
* clean up some php notices on the admin dialogs

= 2012-05-12 v3.0 =
* fixed button style in admin dialog
* added XMLRPC interface to wp-championship for use with smartphone apps
* fixed width of menu entry in wp admin menu
* fixed widget layout on twentyeleven
* adopt default css to twentyeleven
* added demo mode (activate in wp-championship.php)
* fixed an incompatibility with wordpress MU and register_activation/deactivation
* adopted to HTML5 for 3.3 compatibility
* added SQL for EM2012 (folder sql)
* fixed heading for location in tipp table
* fixed confirmation mail (teams and time were not displayed, for finals set team to n/a)
* fixed wrong message (Mail could not be sent...) when deactivating the mailreceipt
* added auto add feature to automatically add new users to guessing game (see admin dialog to activate)
* fixed mailservice receipt was only send for admins
* cleanup php warning (a bit)
* cleanup html validity
* fixed stats4 when all players were selected only part of the tipps was shown


= 2011-08-26 v2.9=
* added the possibility to select all users in cs-stats4
* fixed problem adding final match with bundesliga mode
* fixed problem with jquery 1.4.4 and trigger in wordpress 3.1
* added cs-stats5 an compact overview over one day
* fixed that field spieltag was deleted when editing match
* added shortname for teams for use in reports and stats
* added widget for display the current ranking
* fixed error in winner calculation in Bundesliga-mode
* added confirmation mail feature
* fix ranking when matches were deleted and old tipps were still present
* added group feature for players (every user can be member of a tippgroup, stats can be calculated only for one group or for all)
* fixed an incompatibility with FF6 and Wordpress adminbar

= 2010-11-08 v2.8 =
* fixed debug info dump
* fixed stats to work with non standard wp installations
* fixed pie chart calculating correct percentage
* added charset /collation to setup
* fixed wrong collation in ajax data transfer

= 2010-10-31 v2.7 =
* added label configuration admin dialog
* conserve wp-championship.css during autoupdate
* added basic statistics (insert [cs-stats1], [cs-stats2], [cs-stats3] or [cs-stats4] into a page or post) see documentation for further information

= 2010-08-20 v2.6 =
* fixed collision with older wp-championship version and buddypress

= 2010-08-06 v2.5 =
* removed invalid table class from default css file
* added collapse/expand per day for Bundesligamodus
* added admin switch to lock round1-tipps generally
* added spieltag attribute to matches for mapping in liga-mode
* added trend barometer for ranking table and mailservice
* only output finalround on stats page when final matches exists

= 2010-07-09 v2.4 =
* fixed missing calculation of next match in finalround (match for third place) again :-(

= 2010-07-07 v2.3 =
* fixed invalid xhtml in tipp-dialog
* fixed missing calculation of next match in finalround (match for third place)

= 2010-06-20 v2.2 =
* fixed invalid xhtml tableheader in ranking mail
* fixed sql for result calculation in group tables

= 2010-06-11 v2.1 =
* fixed some translation tags
* fixed warning message for browser timezone when ip is localhost
* fixed WM2010 location of match #56 from Johannisburg to Kapstadt
* fix saving other tipps during a game was not possible

= 2010-06-01 v2.0 =
* fixed output of nonce field, was probably a collision with other plugins
* fixed sort order on tipp dialog for finalround
* fixed points calculation for oneside tipp in conjunction with tendency tipp(> instead of >=)
* fixed goalsum tipp for tipps with no points yet
* fixed link to substitue was not correct with all permalink settings in wordpress

= 2010-05-19 v1.9 =
* fixed missing cr in mail header (which causes some mailservers to deny mailtransfer)
* fixed check for championtipp against current time, used server time instead of blog-time. this lead to problems if server and blog time are in different timezones

= 2010-05-09 v1.8 =
* fixed warning message when allow_url_fopen was Off

= 2010-05-08 v1.7 =
* added option for oneside tipp only hits if tendency is correct
* added auto goalsum tipp (tipp will be calcualted from result tipp (sum of goals)

= 2010-04-27 v1.6 =
* fixed layout in readme.txt
* added screenshots
* fixed, championtipp was not updated when no other field was changed (tippdialog)
* added error message when championtipp should be changed after first match start
* added feature to gain points for a only on one side correct tip
* added feature to gain points for a sum of goals/points during for each match
* fixed save user data when using substitutes
* added feature to gain points if one side of the tipp is exactly correct
* fixed button class on tipp page
* added switch to enable/disable floating link

= 2010-04-15 v1.5 =
* adopt to wordpress 2.9.2
* added sql for WM2010 (teams, matches)
* added mail reminder for upcoming matches
* added italian translation (thanks to Davide :-) )
* added sortable tables to tipp page
* added foldable tables to results page
* added tooltip to matchtime column showing the starttime based on browsers timezone
* added animated flags (thanks to Andy)
* extended input checking on tipp page
* mark not accepted values in red (tipp page)
* added auto-floating "Top of page" link
* make sure only one admin entry is added by default
* added menu icon - the worldcup :-)

= 2009-03-29 v1.4 =
* adding a first draft of english translation

= 2008-08-02 v1.3 =
* corrected a bit of incorrect xhtml
* fixed wrong timestamp for championtime
* check tipptime for championtime in case of injection
* mark admin as tippspiel admin during install
* add switch to disable substitute feature
* added nonce check
* added championship modus for the german bundesliga
* extended classification boards with some stats

= 2008-06-18 v1.2 =
* added the possibility to define mixed finalround matches (from groups and match)
* fixed a problem to store user settings when no champion tipp was given
* fixed an error when using a substitute
* added separate trigger for recalculating points and finals in admin dialog

= 2008-06-16 v1.1 =
* fixed some spelling mistakes
* fixed xhtml for tipp page
* fixed problem with saving user options
* fixed html in admin dialog
* fixed sql error when updating finals
* corrected type error in team dialog

= 2008-06-11 v1.0 =
* send mails only when admin is entering results (not when admin entered tipps)
* added mailservice trigger in admin dialog
* corrected order in group classification
* consider wordpress timezone for time checking
* store only new or changed tipps
* corrected pulldown menu for champion tipp in user dialog
* fixed points calculation for tendency and tied games (when no tipp was entered points for tied games were added)

= 2008-06-01 v0.9 =
* fixed mistake in em2008.sql
* fixed problem creating matches

= 2008-05-31 v0.8=
* read correct wordpress table prefix
* added possibility to remove wp-championship db tables
* the finals will now be calculated each time a results is changed
* you can overrule pre-elimination classification manual by setting the standing in the match dialog
* when creating a new user in user dialog check if user allready exists

= 2008-05-27 v0.7=
* extended data validation for input fields (tipps and results)
* prepare for translation, added .pot file
* corrected spelling errors

= 2008-05-22 v0.6=
* initial alpha release
