Hondabase Discord Bot

This repository hosts the codebase for our own Discord Bot.

It is pretty basic in functionality right now, but it will surely grow with time.

Note

I'd like you to please feel free to submit any pull requests but make sure to discuss changes on Discord first.

Files Portal database

Member departure reports can include Files Portal participation when the bot has a read-only MySQL account configured:

# Optional overrides; defaults use MYSQL_USER/MYSQL_PASSWORD and hondabase_files.
FILES_MYSQL_HOST=localhost
FILES_MYSQL_USER=...
FILES_MYSQL_PASSWORD=...
FILES_MYSQL_DATABASE=hondabase_files

The account only needs SELECT permission on the Files Portal database:

GRANT SELECT ON hondabase_files.* TO 'bot-user'@'localhost';

Shared Discord database

Image fingerprints are shared with other Discord bots through the discord.image_fingerprints table. The default credentials are MYSQL_USER and MYSQL_PASSWORD; they can be overridden with:

SHARED_DISCORD_MYSQL_HOST=localhost
SHARED_DISCORD_MYSQL_USER=...
SHARED_DISCORD_MYSQL_PASSWORD=...
SHARED_DISCORD_MYSQL_DATABASE=discord