search

TurqW / LongSphinx

Discord bot made to help with role management and RPG playing. Name inspired by the Terra Ignota series by Ada Palmer.
5 stars 3 forks source link

Mission note tracking #60

Open TurqW opened 5 years ago

diziara commented 5 years ago

Bonus points if we can find a way to sync it with something in the Nova?

diziara commented 5 years ago

Stupid question... how much of a pain in the ass might it be to get it to read from the database? Would you need to poke at a nova db to find out? I can give you the credentials for the r&d install, if you want to poke at it. (Should I move that site into its own user so you can have sftp access to poke at it if we want to look at Nova integrations?)

diziara commented 5 years ago

Okay, read only db user has been created, ping me for that info when you're ready to start work. Will also need to whitelist the ip the request is coming from.

I figure it'll need two pieces of data to see if the mission notes are worth reading/displaying: Is the mission active, and the notes themselves. Possible enhancement is to enable it to pull upcoming mission notes too.

Probably the lowest traffic intense option to pull the data would be to cache it to the bot, and only refresh it in two cases: when a flag is included to force it to refresh, and if it's been over x amount of time since last check. A week is probably a good value to use since mission notes aren't usually updated a lot.

Proposed commands: !mission Just pull the mission notes for currently active mission/s.

!mission upcoming Pull missions notes for any missions flagged as upcoming in the system.

!mission sync Pull active missions, pulling from the db even if it's been checked in the last week.

If we want to get really fancy, could look at pulling all the mission info: summary, link to logs in the mission, and the notes. If we go in that direction, then the command might change to !mission pulls summary and links to included logs, !mission notes pulls up the mission notes, and the above flags could still be used.

If I actually used mission banners, it would be super cool if those could be pulled and displayed at the top of an embed. But that's less a must have to launch the feature, and more a cool idea.

diziara commented 5 years ago

I would appreciate the mission notes being displayed in a fixed width font, which I think means it needs to use the code block. (Which Discord makes entirely too low contrast for my tastes. >.>)