PATHFINDER - System Mapping Tool

pathfinder is an open source mapping tool for EVE ONLINE.

Setup and Bootstrapping

The following steps will guide you through the database bootstrapping/update process for PATHFINDER.

Environment

Information

Installation Pathfinder
Version v1.2.0
Package Fat-Free Framework 3.6.0-Release
Contact https://github.com/exodus4d
Repository https://github.com/exodus4d/pathfinder

Rquirements

Feature required found
Server type apache
Server version 2.5 2.4.10
PHP interface type apache2handler
PHP 5.6 7.0.16-1~dotdeb+8.1
PCRE 8.02 8.39
PDO installed installed
PDO_MYSQL installed installed
OpenSSL installed installed
XML installed installed
GD Library (for Image plugin) installed installed
cURL (for Web plugin) installed missing
max_input_vars 3000 5000
max_execution_time 10 30
Redis 3.0.0 missing
ZeroMQ extension 1.1.3 missing
ZeroMQ installation 4.1.3 unknown
mod_rewrite enabled enabled
mod_headers enabled enabled

Server

Time 2017/07/26 00:42:08 - (UTC)
OS Linux
Host name vps269165.ovh.net
Release name 3.16.0-4-amd64
Version info #1 SMP Debian 3.16.7-ckt25-1 (2016-03-06)
Machine type x86_64
Document root /var/www/pathfinder
Port 80
Protocol HTTP

Directories

TEMP tmp/
CACHE folder=tmp/cache/
LOGS logs/
UI public/
AUTOLOAD app/main/
FAVICON favicon/

Settings

Configuration

TYPE Config: environment.ini
BASE  
URL http://golden-pixel.com
DEBUG 0
CCP_CREST_URL https://crest-tq.eveonline.com
SSO_CCP_URL https://login.eveonline.com
SSO_CCP_CLIENT_ID e15b424af7174f7588407a... [32]
SSO_CCP_SECRET_KEY gFyXXlEYJ2QpbU7Z3sy4W5lWk6NJ7A... [40]
CCP_XML https://api.eveonline.com
SMTP_HOST localhost
SMTP_PORT 25
SMTP_SCHEME TLS
SMTP_USER  
SMTP_PASS ... [0]
SMTP_FROM registration@pathfinder-w.space
SMTP_ERROR admin@pathfinder-w.space

Registration

Status enabled
Max. count of private maps/user 3
Max. count of corporation maps/user 3
Max. count of alliance maps/user 3
Max. shared users (private maps) 10
Max. shared users (corporation maps) 3
Max. shared users (alliance maps) 2
Private maps 14
Corporation maps 99999
Alliance maps 99999
Private maps enabled
Corporation maps enabled
Alliance maps disabled

Database

Pathfinder

DB driver mysql
DB name pathfinder
DB user root
DB status connected
required installed
DB version 5.6 5.7.17
default_storage_engine InnoDB InnoDB
character_set_database utf8 utf8
character_set_client utf8 utf8
character_set_results utf8 utf8
character_set_connection utf8 utf8
collation_database utf8_general_ci utf8_general_ci
collation_connection utf8_general_ci utf8_general_ci
foreign_key_checks ON ON
Table exist    
activity_log  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. year smallint(6) 1 0
4. week tinyint(4) 1 0
5. active tinyint(1) 1 0
6. characterId int(11) 1 0
7. mapId int(11) 1 0
8. systemCreate smallint(6) 0 0
9. systemUpdate smallint(6) 0 0
10. systemDelete smallint(6) 0 0
11. connectionCreate smallint(6) 0 0
12. connectionUpdate smallint(6) 0 0
13. connectionDelete smallint(6) 0 0
14. signatureCreate smallint(6) 0 0
15. signatureUpdate smallint(6) 0 0
16. signatureDelete smallint(6) 0 0
foreign key
1. fk_activity_log___characterId___character___id
2. fk_activity_log___mapId___map___id
alliance  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. name varchar(128) 0 0
5. shared tinyint(1) 0 0
alliance_map  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. allianceId int(11) 1 0
5. mapId int(11) 1 0
foreign key
1. fk_alliance_map___allianceId___alliance___id
2. fk_alliance_map___mapId___map___id
character  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. lastLogin timestamp 1 0
4. active tinyint(1) 1 0
5. name varchar(128) 0 0
6. ownerHash varchar(128) 0 0
7. crestAccessToken varchar(255) 0 0
8. crestAccessTokenUpdated timestamp 1 0
9. crestRefreshToken varchar(255) 0 0
10. corporationId int(11) 1 0
11. allianceId int(11) 1 0
12. factionId int(11) 1 0
13. factionName varchar(128) 0 0
14. shared tinyint(1) 0 0
15. logLocation tinyint(1) 0 0
foreign key
1. fk_character___corporationId___corporation___id
2. fk_character___allianceId___alliance___id
character_authentication  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. characterId int(11) 1 0
5. selector varchar(128) 1 1
6. token varchar(128) 1 0
7. expires timestamp 1 0
foreign key
1. fk_character_authentication___characterId___character___id
character_log  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. characterId int(11) 1 1
5. systemId int(11) 1 0
6. systemName varchar(128) 0 0
7. constellationId int(11) 1 0
8. constellationName varchar(128) 0 0
9. regionId int(11) 1 0
10. regionName varchar(128) 0 0
11. shipTypeId int(11) 1 0
12. shipTypeName varchar(128) 0 0
13. shipId bigint(20) 1 0
14. shipName varchar(128) 0 0
15. stationId int(11) 1 0
16. stationName varchar(128) 0 0
foreign key
1. fk_character_log___characterId___character___id
character_map  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. characterId int(11) 1 0
5. mapId int(11) 1 0
foreign key
1. fk_character_map___characterId___character___id
2. fk_character_map___mapId___map___id
character_status  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. name varchar(128) 0 0
5. class varchar(128) 0 0
connection  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. mapId int(11) 1 0
5. source int(11) 1 0
6. target int(11) 1 0
7. scope varchar(128) 0 0
8. type text 0 0
9. eolUpdated timestamp 0 0
foreign key
1. fk_connection___mapId___map___id
2. fk_connection___source___system___id
3. fk_connection___target___system___id
connection_scope  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. name varchar(128) 0 0
5. label varchar(128) 0 0
6. connectorDefinition varchar(255) 0 0
constellation_wormhole  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. constellationId int(11) 1 0
4. wormholeId int(11) 1 0
foreign key
1. fk_constellation_wormhole___wormholeId___wormhole___id
corporation  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. name varchar(128) 0 0
5. shared tinyint(1) 0 0
6. isNPC tinyint(1) 0 0
corporation_map  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. corporationId int(11) 1 0
5. mapId int(11) 1 0
foreign key
1. fk_corporation_map___corporationId___corporation___id
2. fk_corporation_map___mapId___map___id
map  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. scopeId int(11) 1 0
5. typeId int(11) 1 0
6. name varchar(128) 0 0
7. icon varchar(128) 0 0
8. deleteExpiredConnections tinyint(1) 0 0
foreign key
1. fk_map___scopeId___map_scope___id
2. fk_map___typeId___map_type___id
map_scope  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. name varchar(128) 0 0
5. label varchar(128) 0 0
map_type  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. name varchar(128) 0 0
5. label varchar(128) 0 0
6. class varchar(128) 0 0
7. classTab varchar(128) 0 0
system  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. mapId int(11) 1 0
5. systemId int(11) 1 0
6. name varchar(128) 0 0
7. alias varchar(128) 0 0
8. regionId int(11) 1 0
9. region varchar(128) 0 0
10. constellationId int(11) 1 0
11. constellation varchar(128) 0 0
12. effect varchar(128) 0 0
13. typeId int(11) 1 0
14. security varchar(128) 0 0
15. trueSec float 0 0
16. statusId int(11) 1 0
17. locked tinyint(1) 0 0
18. rallyUpdated timestamp 0 0
19. rallyPoke tinyint(1) 0 0
20. description varchar(512) 0 0
21. posX int(11) 0 0
22. posY int(11) 0 0
23. createdCharacterId int(11) 1 0
24. updatedCharacterId int(11) 1 0
foreign key
1. fk_system___mapId___map___id
2. fk_system___typeId___system_type___id
3. fk_system___statusId___system_status___id
4. fk_system___createdCharacterId___character___id
5. fk_system___updatedCharacterId___character___id
system_jumps  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. systemId int(11) 1 1
5. value1 int(11) 0 0
6. value2 int(11) 0 0
7. value3 int(11) 0 0
8. value4 int(11) 0 0
9. value5 int(11) 0 0
10. value6 int(11) 0 0
11. value7 int(11) 0 0
12. value8 int(11) 0 0
13. value9 int(11) 0 0
14. value10 int(11) 0 0
15. value11 int(11) 0 0
16. value12 int(11) 0 0
17. value13 int(11) 0 0
18. value14 int(11) 0 0
19. value15 int(11) 0 0
20. value16 int(11) 0 0
21. value17 int(11) 0 0
22. value18 int(11) 0 0
23. value19 int(11) 0 0
24. value20 int(11) 0 0
25. value21 int(11) 0 0
26. value22 int(11) 0 0
27. value23 int(11) 0 0
28. value24 int(11) 0 0
system_kills_factions  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. systemId int(11) 1 1
5. value1 int(11) 0 0
6. value2 int(11) 0 0
7. value3 int(11) 0 0
8. value4 int(11) 0 0
9. value5 int(11) 0 0
10. value6 int(11) 0 0
11. value7 int(11) 0 0
12. value8 int(11) 0 0
13. value9 int(11) 0 0
14. value10 int(11) 0 0
15. value11 int(11) 0 0
16. value12 int(11) 0 0
17. value13 int(11) 0 0
18. value14 int(11) 0 0
19. value15 int(11) 0 0
20. value16 int(11) 0 0
21. value17 int(11) 0 0
22. value18 int(11) 0 0
23. value19 int(11) 0 0
24. value20 int(11) 0 0
25. value21 int(11) 0 0
26. value22 int(11) 0 0
27. value23 int(11) 0 0
28. value24 int(11) 0 0
system_kills_pods  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1) 1 0
4. systemId int(11) 1 1
5. value1 int(11) 0 0
6. value2 int(11) 0 0
7. value3 int(11) 0 0
8. value4 int(11) 0 0
9. value5 int(11) 0 0
10. value6 int(11) 0 0
11. value7 int(11) 0 0
12. value8 int(11) 0 0
13. value9 int(11) 0 0
14. value10 int(11) 0 0
15. value11 int(11) 0 0
16. value12 int(11) 0 0
17. value13 int(11) 0 0
18. value14 int(11) 0 0
19. value15 int(11) 0 0
20. value16 int(11) 0 0
21. value17 int(11) 0 0
22. value18 int(11) 0 0
23. value19 int(11) 0 0
24. value20 int(11) 0 0
25. value21 int(11) 0 0
26. value22 int(11) 0 0
27. value23 int(11) 0 0
28. value24 int(11) 0 0
system_kills_ships  
column exist type I U
1. created timestamp 1 0
2. updated timestamp 1 0
3. active tinyint(1)