Shropshire Chess League Controller - Database Maintenance

competitions.php

Used to create a new Competition, eg Division 4! or amend details for an existing one.

setleaguefixtures.php

Creates League Competition details, Teams and Fixtures. Must be run BEFORE re-setting the current season to a new date using "setnewseason.php". Details for each Division can only be created once. It is STRONGLY ADVISED that you take a backup of the database BEFORE using this!

setnewseason.php

Changes the default season to the next new season. Must only be run once at the start of a new season! Must only be run AFTER League fixtures have been created for all Divisions, using "setleaguefixtures.php".
When run, all results, tables, etc will default to the new season, and so initially will appear empty. Fixture lists will contain the details that were produced for the new season using "setleaguefixtures.php".

amendresult.php

Allows match details to be corrected or to be reset as though they had not yet been played. Works on any Competition, but only in the current Season. It is STRONGLY advised to always take a backup of the database BEFORE using this - just in case!

consistencycheck.php

Checks that using amendresult.php hasn't resulted in any known problems. If problems are detected, they will be highlighted by "N" appearing in the last column (OK?), and a change of colour of the relevant cell. If there are any problems, the database should be restored to the condition prior to running amendresult.php, and then reported.

fixtures.php

Allows fixtures in the current Season to be modified. Fixtures can:
     be created, e.g. playoffs, for any of the Competitions,
     have their fixture dates changed, if they have not yet been played,
     be "hidden" so that their results and scores no longer appear on any results pages,
     (Fixtures can be "un-hidden" again if needed. Any games played are retained and still appear in the grading pages. )

tables.php

Allows the details in the Results Table for any of the Competitions to be modified and teams to be "hidden". Only affects the current season. Any games played are retained and still appear in the grading pages.

grading_players.php

Produces a list of Shropshire League players in the format needed for submission to ECF for grading. Can be run for any season.

grading_games.php

Produces a list of Shropshire League games and results in the format needed for submission to ECF for grading. Can be run for any season.

grading_players_minor.php

Produces a list of players in the Minor Knockout Trophy in the format needed for submission to ECF for grading. Can be run for any season.

grading_games_minor.php

Produces a list of games and results from the Minor Knockout Trophy in the format needed for submission to ECF for grading. Can be run for any season.

grading_players_cox.php

Produces a list of players in the Cox Trophy in the format needed for submission to ECF for grading. Can be run for any season.

grading_games_cox.php

Produces a list of games and results from the Cox Trophy in the format needed for submission to ECF for grading. Can be run for any season.

rapid_grading_players.php

Produces a list of players in the Rapidplay League in the format needed for submission to ECF for grading. Can be run for any season.

rapid_grading_games.php

Produces a list of games and results from the Rapidplay League in the format needed for submission to ECF for grading. Can be run for any season.

ecfnonmembers.php

Produces lists of players in each Division who have played in matches but are not yet members. For these lists to be accurate, the latest ECF Membership List must be obtained and loaded onto the ShropshireChess Dabatase before running this page.

d1latest.php

Code designed to be embedded in the Shropshirechess homepage to show the latest two Division 1 League results.

d1latestv2.php

Code designed to be embedded in the Shropshirechess homepage to show the latest Division 1 League results and individual game details.

d2latest.php

Code designed to be embedded in the Shropshirechess homepage to show the latest two Division 2 League results.

d2latestv2.php

Code designed to be embedded in the Shropshirechess homepage to show the latest Division 2 League results and individual game details.

d3latest.php

Code designed to be embedded in the Shropshirechess homepage to show the latest two Division 3 League results.

d3latestv2.php

Code designed to be embedded in the Shropshirechess homepage to show the latest Division 3 League results and individual game details.

coxlatest.php

Code designed to be embedded in the Shropshirechess homepage to show the latest two Cox Trophy results.

coxlatestv2.php

Code designed to be embedded in the Shropshirechess homepage to show the latest Cox Trophy results and individual game details.

mkolatest.php

Code designed to be embedded in the Shropshirechess homepage to show the latest two Minor Knockout Trophy results.

mkolatestv2.php

Code designed to be embedded in the Shropshirechess homepage to show the latest Minor Knockout Trophy results and individual game details.