airScore

A bunch of scripts and php pages to handle IGC files and store them into a mysql database, determine track distance, do paragliding GAP RACE scoring, OLC-style scoring, etc. It also presents tracks on Leaflet JS Maps for further viewing.

The basic philosophy is to provide the scoring tools as a set of simple executable (perl scripts) that can be wrapped with any GUI. At this stage I've only provided a basic PHP/Google Maps interface.

The database schema maybe found in xcdb.sql.

Copyright

With the exception of the following code:

einsert.js (http://econym.googlepages.com - copyright Mike Williams) elabel.js (http://econym.googlepages.com - copyright Mike Williams)

bootstrap datatables.net open-iconic spacelab.css leafletjs leaflet-fullscreen leaflet-ruler leaflet-easybutton leaflet-sidebar

All rest of the code is provided under the GPL License version 2 described in the file "Copying".

If this is not present please download from www.gnu.org.

Geoff Wong, 2007-2023 geoff.wong@gmail.com

Installation

Helps to be experienced with Apache configurations and Mysql.

Edit the "Makefile":
- set the mysql password you want to use for airscore
- set your CGI bin directory
- set your HTDOCS location (for the php files)
'make database' if it's your first installation
Type 'make'
Ensure Apache is configured with mod-php, perl should be available too
Test that the login page work .../airscore/login.php (user: admin, pass: admin)

Other packages needed:

php5
mysql
perl
libxml-simple-perl

mysql config

Remove select/strict group by enforcement add the following to mysql.cnf:

sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Web Security

Enable exec() functionality for php.
Enable CGI (*pl *php) from the main installation directory for Apache

Script Notes

What do the perl scripts do: