Installation

Pregame

Make sure your server envirinment fulfils all Requirements. Here is a shortcut for Debian/Ubuntu/Nginx (Configuration help is not included).

sudo apt-get install -y php5 php5-gd ruby ruby-dev mysql-server nginx && sudo gem install compass

If you are using Apache, just type that instead. (So you don't install Nginx when you don't need it)

sudo apt-get install -y php5 php5-gd ruby ruby-dev mysql-server && sudo gem install compass

Configuring Nginx/Apache

There are hundreds of guides on how to configure apache/nginx to serve PHP sites. Use Google if you need help with this.

---

Main Install

Navigate to your desired install location and git clone the repo:

git clone https://github.com/exodus4d/pathfinder.git

---

Bootstrapping the Main DB - Clean Data Export [CDE]

If using PHPMyAdmin you probably have to increase upload_max_filesize to get it imported. Importing by SSH is much more prefered!

The SQL dump is now part of this repository: download

wget https://raw.githubusercontent.com/exodus4d/pathfinder/master/pathfinder.sql
mysql -u root -p pathfinder_clean < pathfinder.sql // This will create a *pathfinder_clean* database and import the .sql file. Replace _root_ with your mysql user.

Make sure, that all column indexes and foreign key constraints have been imported correct! Otherwise you will get DB errors and the cache engine can not track all tables (Models), which may result in bad performance!

Bootstrapping the (CCP) Static Data Export [SDE]

You also need to import the Eve SDE into the database specified in the DB_CCP_* settings. You can do this like the following:

wget https://www.fuzzwork.co.uk/dump/mysql-latest.tar.bz2
tar xf mysql-latest.tar.bz2
cd vanguard-[..] // go to the extracted folder
mysql -u root -p -e "create database vanguard"; // Create the SDE database.
mysql -u root -p __DATABASE_NAME__ < db_file.sql // Upload the sql file. It might be named like "mysql56-vanguard-[...].sql", Also replace "root" with your mysql user.

You might need to rename theses tables in phpmyadmin (to change them to lowercase), because when you import them, they'll import as invTypes, mapConstellations etc~ (Notice the capital letters). (check list of table names for correct names [see below]). If you want to "bulk-change" all table names before importing, this (#50) might help you.

---

You don´t have to import all tables into your DB! PATHFINDER requires only the following:

- invtypes
- mapconstellations
- mapdenormalize
- maplocationwormholeclasses
- mapregions
- mapsolarsystems