flyxiv / ffxiv_simbot

0 stars 0 forks source link

Add Item Database #2

Closed flyxiv closed 1 month ago

flyxiv commented 2 months ago

I only added a few tank items because adding all of them is so tedious. Find a way to add at least the relevant equipment for each jobs.

flyxiv commented 2 months ago

Etro gives us public API for FFXIV info. Let's see if we can use this https://etro.gg/api/docs/

flyxiv commented 2 months ago

gives us all the infos of over 25,000 items. However we need to decode some json names

Screenshot 2024-03-19 at 11 27 58 PM
flyxiv commented 2 months ago
Screenshot 2024-03-19 at 11 30 21 PM Screenshot 2024-03-19 at 11 30 28 PM
id stat
1 strength
2 dexterity
3 vitality
4 intelligence
5 mind
6 piety
19 tenacity
22 direct hit
27 crit
44 det
45 sks
46 sps
flyxiv commented 1 month ago

etro uses python APIs, so why not use Python to reformat data into structurable data

flyxiv commented 1 month ago
Screenshot 2024-03-23 at 8 52 16 PM

Finished implementing python data translation script, now the data columns look more structured.

flyxiv commented 1 month ago

Finished Adding Rust Parsers for each data. We ignore Materia and Medicine data, since Etro gives them way too specifically, when all we need is "non-zero stats, value, and duration."

Make sure it runs well tommorow and add Unit Tests and finalize loading DB

flyxiv commented 1 month ago

Finished Writing TC and loading all level 90 combat items from Etro API.