dhedegaard/poetracker repository overview

⁠Poetracker

A simple app for tracking the ranks of friends and such in Path of Exile⁠.

The basic idea is:

• A web interface, where clients connect and get data over SignalR core⁠, written using Typescript⁠ and React⁠.
• An ASP.NET core app, running a SignalR core hub.
• A small fetcher application that stores any new data and submits it to the hub.

The application uses SignalR core, and therefore requires ASP.NET core⁠ 5.0+.

⁠How to run it

• Download the source code, either through git or as a zip/tarball.
• Make sure you have a postgres running, with a poetracker database and user.
• Migrate the tables and such from the Core directory: $ dotnet ef database update
• Install frontend dependencies and build the bundles (required NodeJS), from the Web directory: $ yarn && yarn start
• Run the ASP.NET application from the backend/Web directory: $ dotnet run

Or the easy way: $ docker-compose up --build

⁠How to help

Feel free to send pull requests, feature requests and create issues when you hit bugs :)

⁠Weird character data on wrong accounts

This happens when the Path of Exile API return some bad data.

The easiest way to fix your data is to delete all the datapoints for charname/account/league that only has a single row. An example of how this can be achieved via psql is:

delete from "Datapoints"
where "Id" in (
  select min("Id") as "Id"
  from "Datapoints"
  group by "Charname", "AccountId", "LeagueId"
  having count(*) < 2
)