venat icon indicating copy to clipboard operation
venat copied to clipboard

Implement a non-Core FFXIV database plugin on which other FFXIV plugins can depend on

Open MKhayle opened this issue 3 years ago • 3 comments

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"

MKhayle avatar May 19 '22 16:05 MKhayle

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.

ArcaneDisgea avatar May 19 '22 16:05 ArcaneDisgea

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 ?

MKhayle avatar May 19 '22 16:05 MKhayle

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.

ArcaneDisgea avatar May 19 '22 17:05 ArcaneDisgea