Track different types of statistics for ranking

[Demonofpower]

We need to track different stats to show them in the leaderboard/ranking

1. Veteran Adventurer Not 100% sure about that

2. Treasure Collector Value of extracted treasure from dungeon that can be sold to the collector

3. Killer Outlaw Number of PvP kills in highroller

4. Escape Artist Number of sucessful extractions

5. Lich Slayer Number of Lich kills

6. GhostKing Slayer Number of GhostKing kills

How should we save that stats? A possibility would be to add columns in the character table or we could add a new characterstatistics table to track everything. I would go with the second. @d3v1l401

[d3v1l401]

Yes, I'll make another Table referencing this data; then we can cache it and update it every 12/24 hours. We will keep count of the raw data, not the points themselves, these should be calculated and cached accordingly, perhaps by an external crontab program in Python.

[Demonofpower]

What we could save/track for each character.

• Playtime
• XP collected
• Number of games played
• Number of loot collected (each item picked up counts)
• Value of treasure collected
• Damage done PvP
• Damage done PvE
• Number of kills
• Number of kills highroller
• Number of sucesfull extractions
• Number of sucesfull extractions highroller
• Number of npcs killed
• Number of lich kills
• Number of ghostking kills

@d3v1l401 pls give feedback. Is this too much/less or is something important missing?

[Demonofpower]

I created the character_statistics table with https://github.com/d3v1l401/Bark-and-Barker/pull/7

We also need async ranking creation on a separate program which calculates the ranking out of character_statistics every x hours and puts the current top players into a table called ranking https://github.com/d3v1l401/Bark-and-Barker/tree/ranking_calculation