Amtgard ORK 3

This is the third major release of the Amtgard Online Record Keeper.

Development

Envirionment

Git, PHP 5.6, MySQL 5.5 and Apache.

Basic Setup

To set up you will need a copy of the codebase, a recent copy of the database, and an LAMP or WAMP installation.

Clone the code to a a reasonable place in your web root.

Rehydrate the database from https://drive.google.com/drive/folders/1ai6zOM1EogUWE-Zf_fg_gGrZclM4nSQC

Set Up the Config File

Copy config.dev.php to config.php. Make sure to change the admin email to your own in config.php.

View the Site

You can now view the site at http://servername/ork/orkui/.

Using Docker (Will be outdated with PHP8 changes see below)

A docker-compose file is setup for quickly getting the environment running locally. If there are other environments using port 80 change the exposed port in the docker-compose file to keep from conflicting. Same goes for 3306 for the database. Run the following Docker command from the cloned directory.

docker-compose up -d

Once this completes and MySql is waiting on a socket there are some setup tasks required. In another window issue the following commands:

mysql -P 3306 --protocol=tcp -h localhost -u root -proot ork < ork.sql

This will setup the database.

Download and extract a recent Ork backup from https://ork.amtgard.com/assets/backups/

mysql -P 3306 --protocol=tcp -h localhost -u root -proot ork < ~/Downloads/2020.01.20.06.06.01.sq

This will take a while but will hydrate the database with the backup that was downloaded and extracted above.

mysql -P 3306 --protocol=tcp -h localhost -u root -proot 

Once the SQL prompt appears enter:

SET GLOBAL sql_mode = '';
exit

This was needed to allow the database to accept certain values sent by the PHP APIs.

Navigate to http://localhost/ork/orkui and see the contents of the backup that was restored. Login with your ORK account and password provided you have recently setup your password before the backup database was created on the production server.

Using Docker 8.1 (Under Development)

docker-compose -f docker-compose.php8.yml up

You can access from local at: http://localhost:19080/orkui/

This may redirect to port 80, you may need to add the 19080 port.

On first run, you will need to import a database backup to configure the database.

mysql -P 24306 --protocol=tcp -h localhost -u root -proot ork < ~/Downloads/[somedate].sql