----- !!!!! TEST DATABASE IN USE !!!!! ----- ----- !!!!! TEST DATABASE IN USE !!!!! ----- ----- !!!!! TEST DATABASE IN USE !!!!! -----

Shropshire Chess Rapidplay League Controller - Database Maintenance



This page is for the sole use of the Shropshire Chess Rapidplay League Controller.

RAPIDPLAY LEAGUE SEASON SETUP:

competitions.php

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

 

MATCH ADJUSTMENTS:

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.

 

FIXTURE CREATION, AMENDMENT and HIDING

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. )

 

RESULTS TABLE ADJUSTMENTS:

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 DETAILS:

rapid_grading_players.php

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

rapid_grading_games.php

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

 

HOMEPAGE LIVE FEEDS:

rapidd1latest.php

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

rapidd1latestv2.php

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

rapidd2latest.php

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

rapidd2latestv2.php

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