Editorials: On-line Tournament Management and Public Display of Results
Last Easter an Internet-based tournament management system was trialled at the Surbiton Tournaments.
The consequences of using a web-hosted system are:
As with all computerised systems the data can be readily mauled to produce customised reports, e.g. number of hoops scored, pre-calculated Advanced ‘handicap card’ filling in data for a nominated player, player ranking, etc.
The progress of the tournament is stored in an Access database on a web server and updated and interrogated via web pages. The program operates either in Viewer Mode, or Manager (admin) Mode.
http://www.oxfordcroquet.com/swizz/ is the current working model.
In Viewer Mode no changes can be made. In Manager Mode – accessed by a password (‘norbert’) new tournaments can be set up, games assigned and results gathered. You are encouraged to play – the real data for Easter has been saved.
The Viewer Mode display can be substantially different from the Manager Mode display.
The program operated without any major issues apart from very occasional long pauses whilst the underpowered laptop decided to do infrequent maintenance tasks such as download antivirus updates, etc. There was no problem with using a remote database. A number of enhancements were pencilled in for development.
The manager’s laptop can run a local web server on its hard disk and allow viewers to receive pages from it. That way a network failure does not frustrate the tournament management. A dynamic DNS name can be used on the laptop and information directly sent to viewers or relayed via another web server.
This software is capable solely of handling a Swizz format currently; software would need to be written for other formats.
All rights reserved © 2010-2017