v1.4.0

• New map filter options #641
• New "compact" map layout #607
• New planets data added #648
• New "is static" column added to "wormhole types" table
• Improved "shattered wormhole" data (statics, icon,...) #647
• Improved "killboard module" (added links for corp/ally/char killboards) #650
• Improved "Abyss" system support (fixed names,..) #631
• Improved "intel module" (added zKillbaord link for corporation icons) #646
• Improved UI performance, decreased update time for "system description" #459
• Improved search performance for system names (added infinite scroll) #644
• Upgraded Cron php F3 extension v1.0.0 → v1.2.0
• Upgraded FontAwesome icon library v5.0.2 → v5.0.13
• Upgraded jQuery JS lib v3.1.1 → v3.3.1
• Upgraded PNotify js lib v3.0.0 → v3.2.0
• Fixed bug where "structures" not get updated/inserted properly #640
• Fixed broken persistent system alias #360
• Fixed missing "wandering" WHs for C13 shattered systems
• Fixed some broken Dotlan deeplinks #638
• Fixed high memory consumption for PHP cronjob scripts #636
• Fixed broken cronjobs on ISS (Windows) servers #635
• Fixed PHP "init session" race condition #595
• Removed EVE SDE requirement for Pathfinder. Static universe DB (e.g. system info) is requested from ESI API and stored in eve_universe_ DB #628

---

Upgrade guide: v1.3.5 → v1.4.0

1. Backup your DB (in case something went wrong!)
2. Backup your *.ini config files
3. Replace existing code
4. Adjust environment.ini and pathfinder.ini
5. Upgrade pathfinder_esi to v1.2.5
Composer will do the job for you. Run this command in your projects root dir:

$ composer install

6. Upgrade your DB

• Go to /setup page and update eve_universe DB, click "Setup tables"
• Go to /setup page and add new column(s)/keys, click " Fix columns/keys"

7. Import initial eve_universe.sql dump into eve_universe DB

• read the updated Database wiki page for more information.

8. Cleanup DB

• Some tables and columns are no longer needed and should be deleted manually from pathfinder DB
  • Drop table constellation_wormhole
  • Drop table system_wormhole
  • Drop table wormhole
  • Drop column system.name
  • Drop column system.regionId
  • Drop column system.region
  • Drop column system.constellationId
  • Drop column system.constellation
  • Drop column system.effect
  • Drop column system.security
  • Drop column system.trueSec

9. Clear cache data

• Clear cached template files (tmp/)
• Clear cached data (filecache: tmp/cache or Redis)

10. Build "systems" index

• Go to /setup page, click "Build" system index (Do not reload until build is done ~5min) → watch progress bar
• In case of Ajax errors, reload page and try again 😄

If you have update problems, feel free to ask in our dev-chat: #Slack

v1.3.5

• New "Into The Abyss" systems added #631
• New "Intel module" for tracking "player owned structures" (e.g. Citadels) #246
• Added "lazy update" (ctrl + v) shortcut for "intel module" (paste data from eve client) #246
• Added "signature strength" data to wormhole types #623
• Added information tooltip for static WH connections to map #625 #624
• Added "character whitelist" configuration to pathfinder.ini #611
• Improved links to external mapping pages. Added Anoik wormhole information #605
• Improved links on "changelog" dialog, new Github deeplinks #612
• Updated wormhole mass data, added some missing/wrong values
• Upgraded "Cortex" php ORM lib 1.5.0 → 1.6.0-dev
• Upgraded "Select2" js lib 4.0.3 → 4.0.6-rc.1
• Upgraded "jquery.hoverIntent" js lib v1.8.0 → v1.9.0
• Upgraded "VelocityJS" js lib v1.4.1 → v1.5.1
• Fixed some login Issues
• Fixed broken "pilot count" tooltip. Removed visible HTML tags #617 #476 #296
• Fixed broken map/* reroute URL - wildcard replacement #621
• Fixed broken cache layer for Universe DB models
• Fixed broken js eventHandlers for new added System (drag&drop issue) #622
• Fixed js bug where signature sync (client side update) failed
• Fixed ESI error 400 "'connections' items are not all unique" response for getRouteData()
• Fixed ESI error 400 "too many items for 'connections'" response for getRouteData()
• Fixed some UI animation issues #607
• Many more minor fixes and performance optimizations ...

---

Upgrade guide: v1.3.4 → v1.3.5

1. Backup your DB (in case something went wrong!)
2. Backup your *.ini config files
3. Replace existing code
4. Adjust environment.ini and pathfinder.ini
5. Upgrade pathfinder_esi to v1.2.4
Composer will do the job for you. Run this command in your projects root dir:

$ composer install

6. Upgrade your DB

• Drop eve_universe DB, we need to rebuild it from scratch! (I had to make some structure changes). This DB just holds cached data from ESI you will not lose any other data.
• Go to /setup page and create a fresh eve_universe DB click "create database"
• Go to /setup page and add new column(s)/keys, click on "Setup tables" then "fix keys"
• There is a new SDE available in this repo /export/sql/eve_abyss_min.sql.zip. You need to manually import the dump into a new DB named "eve_abyss" (check environment.ini)

7. Clear cache data

• Clear cached template files (tmp/)
• Clear cached data (filecache: tmp/cache or Redis)

If you have update problems, feel free to ask in our dev-chat: #Slack

v1.3.4

• New "inactive/offline-inGame" pilot information available in map view #567
• New map deeplinks (unique map URLs for easy share) #593
• New connection info added to "route search" module (e.g. show WHs info between system jumps)
• New clock added, showing current EVE server time #602
• Added "system type" info (e.g. WH, 0.0,..) to signature "leads to" select #597
• Added OS notifications to JS/CSS Gulp build process, see #510
• Added example config for Super-Admins to pathfinder.ini
• Added notification to /admin/maps page if there are no maps found
• Improved "route search" module. New ESI endpoint is now default #590
• Improved client site map initialization process (switched to a JS Promise based implementation)
• Improved CSS build. pathfinder.css moved into version tag folder now
• Upgraded SQL Schema lib 2.2.1 → 2.2.2
• Upgraded Bootstrap Confirmation lib 1.0.5 → 1.0.7
• Fixed non persistent map size for non "Chrome" browsers e.g. Firefox #585
• Fixed a bug where admin permissions were not set correctly #589 #591
• Fixed not working "jump info" menu button #588
• Fixed number format in "statistics dialog" #596
• Fixed a bug with "cookie accept" hint on /login page
• Removed background image on /map view #598
• Many more minor fixes and performance optimizations ...

---

Upgrade guide: v1.3.3 → v1.3.4

1. Backup your DB (in case something went wrong!)
2. Backup your *.ini config files
3. Replace existing code
4. Adjust environment.ini and pathfinder.ini
5. Upgrade pathfinder_esi to v1.2.3
Composer will do the job for you. Run this command in your projects root dir:

$ composer install

6. Clear cache data

• Clear cached template files (tmp/)
• Clear cached data (filecache: tmp/cache or Redis)

If you have update problems, feel free to ask in our dev-chat: #Slack

v1.3.3

• New "map resize" feature for maps #553
• New "role management" for corporation managers #164
• New map icon options options to the map add/edit dialog
• New config value SHOW_COMPLETE_LOGIN_PAGE hides some sections on login page
• Improved "route search" algorithm (some routes were not found)
• Improved Discored WebHook integration (added new subDomain validation) #578
• Improved /setup page "DB diff" function (added column "nullable" detection for columns)
• Upgraded FatFreeFramework (core PHP framework) 3.6.1 → 3.6.2
• Upgraded FontAwesome (icon library) 4.7.0 → 5.0.2
• Fixed SPL object data cache for "characterlog" table updates (better performance)
• Fixed some cURL errors for not existing discord map configuration
• Fixed a bug where php-fpm receive >stderr from php when NO log handler is set

---

Upgrade guide: v1.3.2 → v1.3.3

1. Backup your DB (in case something went wrong!)
2. Backup your *.ini config files
3. Replace existing code
4. Adjust environment.ini and pathfinder.ini

IMPORTANT: CCP_ESI_SCOPES have changed and CCP_ESI_SCOPES_ADMIN are currently empty.

5. Upgrade your DB

IMPORTANT: You have to run the following query manually on your database in order to prepare the DB for the next step!

UPDATE `character` SET `roleId`= 1

• Go to /setup page create the new tables, click on "Setup tables"
• Go to /setup page and fix column(s), click on "Fix columns/keys"

6. Clear cache data

• Clear cached template files (tmp/)
• Clear cached data (filecache: tmp/cache or Redis)

If you have update problems, feel free to ask in our dev-chat: #Slack

v1.3.2

• New Discord integration (Webhooks) #547
• New feature added for sorting map tabs (drag&drop) #571
• New "map recovery" option added to admin section (corporation maps) #547
• Improved system positions on map. Prevents overlapping #570
• Improved "mass logging" module (bug fixes and some new features) #560
• Improved core JS function for "map sync" (replaced 'callback' functions with Promises)
• Added a version check to "changelog" dialog (helpful for self hosted installations)
• Fixed DB version check on "/setup" page for MariaDB installations

---

Upgrade guide: v1.3.1 → v1.3.2

1. Backup your DB (in case something went wrong!)
2. Backup your *.ini config files
3. Replace existing code
4. Adjust environment.ini and pathfinder.ini
5. Upgrade your DB

• New column map.discordUsername
• New column map.discordWebHookURLRally
• New column map.discordWebHookURLHistory

• Go to /setup page and add new column(s), click on "Setup tables"

6. Upgrade pathfinder_esi to v1.2.2
Composer will do the job for you. Run this command in your projects root dir:

$ composer install

7. Clear cache data

• Clear cached template files (tmp/)
• Clear cached data (filecache: tmp/cache or Redis)

If you have update problems, feel free to ask in our dev-chat: #Slack

v1.3.1

• New "jump log" tracking for wormhole connections #313
• New persistent custom layout, drag&drop for reorder panels #234
• New "jump info" dialog lists all (80) wormhole types with mass limits
• improved "lazy update" for signatures.New toggle button added for auto-delete expired signatures (not part of current clipboard), Shortcut: ctrl + v #445
• fixed drag/select offset on scrolled maps #534
• fixed missing system alias in edit dialog #508
• fixed cURL version requirement in composer.json #546

---

Upgrade guide: v1.3.0 → v1.3.1

1. Backup your DB (in case something went wrong!)
2. Backup your *.ini config files
3. Replace existing code
4. Adjust environment.ini and pathfinder.ini
5. Upgrade your DB

• Go to /setup page create the new connection_log table, click on "Setup tables"
• Go to /setup page and fix column(s), click on "Fix columns/keys"

6. Clear cache data

• Clear cached template files (tmp/)
• Clear cached data (filecache: tmp/cache or Redis)

If you have update problems, feel free to ask in our dev-chat: #Slack

v1.3.0

• New docking information for "structures" (e.g. citadels) - New ESI scope required read_structures.v1
• New "map log" handling for map/system/signature/connection changes, closed #271
• New Slack push service for map changes #271
• New Slack push for "rally point" notification
• New "rally point" poke options (e.g. custom message), closed #295
• New log options for WebSocket Installations (write log files async)
• New system variable check on /setup page
• added ship "mass" logging (backend only), #313
• added "ESI error rate" limit detection - Dev blog
• added Monolog as new logging library (Composer dependency)
• added Swiftmailer as new eMail library (Composer dependency)
• added Support for Redis session hander (performance boost) - How to
• improved character select panels (added "online" status icon)
• improved "activity logging" (new DB columns added to check for change)
• improved E-mail notification (new HTML template support)
• improved "deleted map" now become "inactive" for some days before final delete
• improved character logout handling
• improved /setup page p (added new button for DB create if not exists)
• fixed broken ship tracking (ship name re-added)
• fixed broken ship tracking for multiple characters on different browser tabs
• fixed broken cursor coordinates, closed #518
• fixed null pointer "charactermodel.php->isActive():925" closed #529
• fixed broken "scroll offset", closed #533 closed #534
• updated SDE data. New eve_liveblood_min.sql in /export/sql/eve_lifeblood_min.sql.zip
• Updated "validation" library JS v0.10.1 → v0.11.9
• Updated ORM Mapper Cortex v1.5.0-dev → v1.5.0
• and many more....

---

Upgrade guide: v1.2.4 → v1.3.0

Important: There is a new (3rd) DB required for caching static ressources from CCPs ESI API.

1. Backup your DB (incase something wrent wrong!)
2. Backup your *.ini config files
3. Replace existing code
4. Install/update Composer dependencies (v1.2.1 pathfinder_esi )
Composer will do the job for you. Run this command in your projects root dir:

$ composer update

Hint: You can delte existing /vendor folder, delte composer.json.lock and run $ composer clearcache before install/update if you have problems with previous installed composer packages.

5. Adjust environment.ini and pathfinder.ini
Some config keys has changed and new were added. Do not blind replace config files!

6. Upgrade your DB

• Go to /setup page create the new eve_universe database
• Go to /setup page and add new column(s), click on "Setup tables"
• Go to /setup page and fix column(s), click on "Fix columns/keys"

6.a Update SDE DB [OPTIONAL]
There is a fresh SDE dump available export/sql/eve_lifeblood_min.sql.zip. It is recommended to use it in order to stay up2date.

7. Clear cache data

• Clear cached template files (tmp/)
• Clear cached data (filecache: tmp/cache or Redis)

8. Redis as Session handler [OPTIONAL]
If you already use Redis as Cache backend for Pathfinder you may want to configure PHP to use it for Session handling how to.
Then change SESSION_CACHE in config.ini to default

WebSocket installations

1. Update project
If you have Pathfinder running with a WebSocket server. Make sure to update your WebSocket-Server to v1.0.1 pathfinder_websocket

2. Install/update Composer dependencies
3. Restart WebSocket server

If you have update problems, feel free to ask in our dev-chat: #Slack

v.1.2.4

• NEW support for German/French signature parsing #490
• improved build process for *.js/*.css static files (Gulp4) #510
• added support for custom *.ini config directory
• fixed map sync bug #505
• fixed character location update bug #507
• fixed login restriction bug for ally/corp white lists #499

---

Upgrade guide: v1.2.3 → v1.2.4

1. Upgrade your DB
New column character.esiScopes

• Go to /setup page and add new column(s), click on "Setup tables"

2. Clean up DB [optional]
Columns that no longer exist, should be dropped manually!
Drop column character_authentication from table scopeHash

3. Clear cache data

• Clear cached template files (tmp/)
• Clear cached data (filecache: tmp/cache or Redis)

v1.2.3

• NEW "Admin interface" for corp member administration [BETA] #494
• NEW ESI based, in-game "online status" tracking for characters #495
• NEW map option for "persistent system aliases" #496
• NEW map options for connection/wh handling (cronjob) #219
• improved "ship name" information (UI changes) #487
• improved "inactive/afk" character status #489
• improved login page (UI changes) #323
• improved /setup requirements check for PHP 64-bit support
• fixed hidden system tooltips with "active characters" #461
• fixed character access with manual corp/ally whitelist #414
• fixed missing "leads to" options for sig.<->wh connections "leads to" #488

---

Upgrade guide: v1.2.2 → v1.2.3

1. Install/update dependencies (v1.1.0 pathfinder_esi ).
Composer will do the job for you. Run this command in your projects root dir:

$ composer update

2. Update your environment.ini file with new ESI scopes AND ESI admin scopes

• compare with new scopes environment.ini#L37

3. Upgrade your DB
New column character.roleId
New column character.kicked
New column character.banned
New column map.deleteEolConnections
New column map.persistentAliases

• Go to /setup page and add new column(s), click on "Setup tables"

Changed column system_neighbour.trueSec to decimal(18,6)

• Go to /setup page and fix column(s), click on "Fix columns/keys"

5. Clear cache data

• Clear cached template files (tmp/)
• Clear cached data (filecache: tmp/cache or Redis)

v1.2.2

• NEW "Nearby" map overlay #481
• NEW ESI API replaces deprecated APIs (CREST and XML) #473
• improved "route finder", added new "frigate hole" filter option #460
• improved signature ⇒ wormhole connection label (use system alias) #458
• improved "accept cookie" hint on /login page #359
• fixed "lazy copy&paste" shortcut action for signatures
• fixed "Access Denied" bug on login #471
• fixed "HTTP 500" error on "delete account" action #468
• fixed a "/setup" error on installations with no WebSockets #464
• fixed a login bug for subDirectory installations #431

---

Upgrade guide: v1.2.1 → v1.2.2

1. Install new dependencies (pathfinder_esi).
Composer will do the job for you. Run this command in your projects root dir:

$ composer install

2. Update your environment.ini file with new ESI scopes

• read updated wiki Configuration

3. Upgrade your DB
New column securityStatus on table character
New column scopeHash on table character_authentication

• Go to /setup page and add new column(s), click on "Setup tables"

4. Clean up DB [optional]
Columns that no longer exist, should be dropped manually!
Drop column factionId from table character
Drop column factionName from table character

Drop column constellationId from table character_log
Drop column constellationName from table character_log
Drop column regionId from table character_log
Drop column regionName from table character_log

5. Clear cache data

• Clear cached data (filecache: tmp/cache or Redis)