I want to use this bot in other daily submission challenges I do (I'm currently doing a blender one on the side). So the data should also store the guild name and only add up submission counts on that specific guild rather than just using author.
Modifying the database: adding a new column "guild" in the "submission" table. With "general" as the default value so the data in the current database can be kept.
Either have separate channels for different challenges, or add a new user input parameter in the !submit command
Same as point 2, the weekly submission summary function will also need to be modified.
I want to use this bot in other daily submission challenges I do (I'm currently doing a blender one on the side). So the data should also store the guild name and only add up submission counts on that specific guild rather than just using author.