King Ragnar Discord Bot

To-Do

• greet a newly joined member in a channel (random message)
• while adding a reaction to a message send a message to a channel ( gave reaction to )
• parameterized command (eg - !role <role_name>), create a role named the parameter recieved and assign it to the user.
• using a parameterized command(eg - !register ) insert the name to database, if same name tries to register again send error message to channel.
• with a role restricted command retrieve all names in the database ( eg - !names)

Commands

• !register yourname - to add yourname to the db
• !names - to list all names in db(requires nikhil role)
• !role rolename - to get the specified role

MySQL To Create Table

CREATE TABLE users (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255)
)

Screenshots

Bot welcoming new users

!role rolename - to get the specified role

!register yourname - to add yourname to the db
!names - to list all names in db(requires arjunms role)

Sending message when someone reacts