Leaguerunner - PHP software to run an ultimate league

Leaguerunner is a LAMP application for managing an Ultimate league. It runs the Ottawa-Carleton Ultimate Association's summer, fall, and winter indoor leagues, handling over 500 teams and 10000 registered players in more than 60 different divisions and three seasons of play.

Prerequisites

1. Webserver with PHP 5.x, with PDO (PHP Data Objects) extension. PDO ships with PHP 5.1, and is available as a PECL extension for 5.0
2. MySQL 5.x database, and the relevant PHP support for MySQL
3. PHP PEAR libraries
4. (optional) PHP jpgraph library
5. (optional) the ability to run Perl scripts from the commandline for maintenance tasks.
6. (optional) mod_rewrite is required if you want clean URLs (if you want http://your-server/leaguerunner/home instead of http://your-server/leaguerunner/index.php?q=/home)

Installation

Once the prerequisites are installed and configured normally you can install the software.

To install Leaguerunner:

1. copy all of the src/ directory to some location under your server's web root. If your site's root is at /var/www/html, /var/www/html/leaguerunner is a good place to put it. You can also run it from a user's public_html directory if you wish.
2. initialise the database. First, you need to create it. This can be done by running:

  mysql -uroot -p

and logging in as the MySQL root user. Once logged in, run the following SQL commands:

  CREATE DATABASE leaguerunner;
  GRANT ALL ON leaguerunner.* TO leaguerunner_user@localhost IDENTIFIED BY 'password';

Be sure to choose an appropriate username instead of "leaguerunner_user" and a better password in place of "password". Once this is done, you will need to import the database schema using:

  mysql leaguerunner -u leaguerunner_user -p < db/mysql_fresh_install.sql

Each time, you will be prompted for the password of "leaguerunner_user", so enter the one you just used when creating it.

1. Change into the directory in which you installed Leaguerunner, and edit the leaguerunner.conf file. You will need to edit $DB_URL to use the username and password you used when creating the database; $BASE_URL to set the base URL used to access Leaguerunner.

Once this is complete, you should be able to point your web browser at the base URL and log in using the user 'admin' with a password of 'admin'.

If you can log in, but get an error finding /home:

1. check that mod_rewrite is enabled and that the .htaccess file can override the config files. The keywords to search for in httpd.conf (apache) are "mod_rewrite" and "AllowOverride".
2. if you do not have mod_rewrite, ensure that you have not enabled clean URLs for your configuration (the default is to have them turned off in new installations). Since this configuration setting is made using the web UI, you will need to directly modify the database to turn it off and gain access to the web interface. To do this, execute the SQL:

  UPDATE variable SET value = '0' WHERE name = 'clean_url';