Implement a non-Core FFXIV database plugin on which other FFXIV plugins can depend on
Describe the solution you'd like
Allow an internal use of FFXIV data through a database plugin so that other FFXIV plugins can rely on it to handle FFXIV data easily and in a consistent manner, with localization supported across all 4 languages of the game.
This module should also handle basic built-in commands (from #3, thanks @ArcaneDisgea) :
- [ ] Item Queries
- [ ] Action Queries
- [ ] Recipe Queries
Additional context
/item "Antidote"
/action "Shukuchi"
/recipe "Shishi-odoshi"
Prolly want to include a language field to these queries unless we want to store preferred language of a user in db and let them use a /lang command also exploitable prolly isn't a great word for that.
Edited it out, turns out the nuances of the word differs a bit in fr/en (and how it's being used, I guess)
Do we want to store preferred languages ?
That's how other bots do it to my knowledge. Since those bots tend to have reputation systems for a guild and store the lodestone character data attached to that discord user, they also just store language as an additional user-defineable field that gets referenced for any commands that would need to care about language.
If we added this we would want to add a default language field that can be set for the guild and then a user-defineable one that overrides the guild setting for a particular user.
If this was done @karashiiro could ditch the language field on /market and just reference whatevers set in the db.