Website Database for players to find organizations.
The scraper was built from Siegen's sc-api.
To host the app yourself, add and run dependencies. Debian-based GNU+Linux distributions provide easy installation:
If using an ARM CPU, you will need to use the stretch repo for MySQL5.6.
add the repo
deb http://archive.raspbian.org/raspbian/ stretch main
(this might not work for all project boards)
The remaining instructions hold for all CPUs:
mysql 5.6 provides indexes on derived tables for fast subqueries
apt-get install mysql-server-5.6
optional (for easy database viewing)
apt-get install phpmyadmin
if you did not install phpmyadmin, which includes Apache2
apt-get install apache2
run the creation .SQL scripts
// username=publicselect password=public
sc-api uses curl
apt-get install php5-curl
shell script for updates has to resize images
apt-get install imagemagick
assuming you're hosting using Apache's default folder
cd /var/www/html git clone <repository url> .
test it locally
apt-get install php5-cli php -S localhost:8000
navigate to localhost:8000/index.html
To scrape org icons, run /dbPop/populate_icons.php. The front end assumes you save to /org_icons, so provide an Apache alias if necessary under 000-default.conf. Icons are stored locally and separately from the database.
To live host, set up port forwarding on your router, and navigate to <your_public_IP>/index.html