issues
search
Virtual-Royaume
/
Royaume-Discord-Bot
It is the bot of our Discord community, it offers various utility features. It is written in TypeScript and uses DiscordJS to interact with the Discord API.
9
stars
1
forks
source link
Data management for activity
#12
Closed
Bluzzi
closed
3 years ago
Bluzzi
commented
3 years ago
Data :
Member
table relied to the
MemberActivity
table with voice time (minute), message count (per channel, total and number of message during the month)
[x] tables class
[x] data update
ServerActivity
table with one line per day. It will contain following global members informations : voice time, message count, member count
[x] table class
[x] data update
[x] date primary column auto define (without time)
Commands :
[x] member-stats \<mention> : see member statistics (message count per channel, number of message during the month, total message, voice time)
[x] top-msg [total, month or channel mention] \<page> : see message count scoreboard (20 members per page)
[x] top-voice \<page> : see voice time scoreboard (20 members per page)
[x] inactive : list of members (limit : 30) with 0 message send this month
[x] stats : send three embed with chart (chart.js) of the last 30 day global statistics (voice time, message count, member count)
Bluzzi
commented
3 years ago
[x] No need to check if the person is in the AFK channel because it is automatically muted once inside.
Bluzzi
commented
3 years ago
[x] Check if all data is correctly updated
Bluzzi
commented
3 years ago
[x] update alwaysOnTheServer column (in
Member
datebase entity)
Bluzzi
commented
3 years ago
[x] Bots should not be registered in the database
Data :
Member
table relied to theMemberActivity
table with voice time (minute), message count (per channel, total and number of message during the month)ServerActivity
table with one line per day. It will contain following global members informations : voice time, message count, member countCommands :