statbot
statbot copied to clipboard
strinking
A data ingestion bot that reads records from Discord guilds into a SQL database.
The problem happens when a user has added some reaction, or has their ID in the audit log, but have left the server. In that case, we get a bunch...
Hello! Having issues with the setup, it looks like the channel crawler is trying to reference a value from the un-initialized channels table? The only channel that populates is 'users',...
when i try to start bot __main__.py: error: unrecognized arguments: [-d] config.yaml
`sql.py` has gotten quite large. Statbot should adopt a system similar to [futaba's](https://github.com/strinking/futaba) that allows keeping SQL functionality isolated, but spread among several submodules.
Would be interesting to correlate banned user IDs with other possibly pertinent information, like membership in other servers or post speed etc.
Repro: point statbot at a guild containing channels that don't have Read Message History explicitly granted to a bot user. The crawler will ignore those channels. Consider https://github.com/strinking/statbot/blob/81137108fa9bb4011936c79f3ee5288967804505/statbot/crawler.py#L159 Replacing this...
The `messages` table tracks the current state of all messages. However any information in edits is lost. We should add a `message_history` table with the following schema: | Column Name...
Add a section to the configuration file that allows for certain features to be disabled. As of now, this should include: * activity changes * status changes * typing *...
Add a configurable option to track users' past avatars and the time it was changed. See also #58