Open cohenaj194 opened 1 year ago
@oldben87 wants this in the mysql db, we can have the mysql population container do it.
We will get that teamcraft list and then filter it down by removing all non marketable items not found under https://universalis.app/api/v2/marketable
this is now in the item_id_to_names
database and item_id_to_names
table
the columns are:
(itemID INT PRIMARY KEY, en VARCHAR(255), de VARCHAR(255), ja VARCHAR(255), fr VARCHAR(255)
some example rows are
(38664, 'Orange Sweet Peas', 'Orangene Duftwicken', 'スイートピー:オレンジ', 'Bouquet de pois de senteur orange')
(38665, 'Purple Sweet Peas', 'Violette Duftwicken', 'スイートピー:パープル', 'Bouquet de pois de senteur violets')
(38666, 'White Sweet Peas', 'Weiße Duftwicken', 'スイートピー:ホワイト', 'Bouquet de pois de senteur blancs')
(38667, 'Black Sweet Peas', 'Schwarze Duftwicken', 'スイートピー:ブラック', 'Bouquet de pois de senteur noirs')
(38668, 'Rainbow Sweet Peas', 'Bunte Duftwicken', 'スイートピー:ブレンド', 'Bouquet de pois de senteur multicolores')
(38672, 'Leveilleur Estate Flooring', 'Leveilleur-Fußboden', 'ルヴェユール・フローリング', 'Parquet des Leveilleur')
(38673, 'Leveilleur Estate Chandelier', 'Leveilleur-Kronleuchter', 'ルヴェユール・シャンデリア', 'Lustre des Leveilleur')
(38674, 'Leveilleur Estate Interior Wall', 'Leveilleur-Innenwand', 'ルヴェユール・インナーウォール', 'Revêtement mural des Leveilleur')
(38675, 'Pearl of Winds', 'Windperle', '大妖異の風宝珠', 'Orbe de maîtresse du vent')
(38684, 'Weatherproof Cloth', 'Schmutzabweisender Stoff', '防塵撥水布', 'Toile en tissu tous temps')
(38685, 'Weathered Pipe', 'Altes Leichtmetallrohr', '古びた軽量パイプ', 'Tuyau léger usé')
(38686, 'Exciting Leather', 'Euphoraleder', 'エキサイトレザー', 'Ludocuir')
Item names in 4 languages: english, german, japanese and french can be found here, we should consider using it somehow and adding a language toggle.
https://raw.githubusercontent.com/ffxiv-teamcraft/ffxiv-teamcraft/master/apps/client/src/assets/data/items.json