DiscordBot w/ DB Integration

Hello,

I was bored and so I made this bot, I will explain how it works and how you can use it to the fullest.

If you don't know how to setup/make a discord bot, follow this:



What is this discord bot capable of doing?

• Absolute control via database
• Very similar to the infamous BOT System
• Various events etc
• Complete log of the discord chat
• Assign role for new members (by role name)

What can you do via the database?

1. Send Message
2. Delete Messages
3. React to Messages
4. Direct Message Users
5. Trigger certain events on (Mention, Message, DM) etc

What is this bot useful for?

• Creating custom event without allowing someone else to have access to the db
• Unique Log / Appeared or Killed
• Global Log
• Job Kill Log or Wanted Log
• etc

Usage example:


Important information:

• You can use _AddMessageLog / _AddMentionLog to do any kind of event depending on the event (think of it as log db procedures)
• You can get ChannelId from _ChannelData or _MessageLog or right clicking on the channel in Discord and pressing Copy ID
• You can mention a user using the following code (You can obtain UserId from _MessageLog)
  
  Code:

  '<@' + @UserId + '>

• Procedures parameters:
  
  _AddMessageLog
  @Channel
  @ChannelId
  @User
  @UserId
  @Message
  @MessageId
  
  _AddMentionLog
  @Channel
  @ChannelId
  @User
  @UserId
  @Message
  
  _AddDMLog
  @User
  @UserId
  @Message
  @MessageId
  
  _DeleteMessage
  @ChannelId
  @MessageId
  
  _ReactMessage
  @ChannelId
  @MessageId
  @EmojiId
  
  _SendMessage
  @ChannelId
  @Content
  
  _SendDM
  @UserId
  @Message
  
  
• You can get the EmojiId by right clicking on the emoji and pressing Copy ID
• You can send an emoji by using the follow the normal emoji name ex:
  
  Code:

  :thinking:
  
  EXEC _SendMessage ChannelId, 'What? :thinking:'

• Edit config.json and put your database info and discord bot token
  
  
   Clean DiscordBot DB Query

  Code:

  TRUNCATE TABLE _ChannelData
  TRUNCATE TABLE _MessageLog
  TRUNCATE TABLE _MentionLog
  TRUNCATE TABLE _RequestHandler
  TRUNCATE TABLE _DMLog
  
  DBCC CHECKIDENT (_RequestHandler, RESEED, 0)

Hopefully someone will be able to use it.

good, Thanks bro for shared

db restore error :(

have script?

Quote:

Originally Posted by ILowe db restore error :( PHP Code: System.Data.SqlClient.SqlError: The database was backed up on a server running version 13.00.5026. That version is incompatible with this server, which is running version 12.00.2000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)  have script?

use a newer sql version

so useful , thanks

Good Job Bro

Quote:

Originally Posted by ILowe db restore error :( PHP Code: System.Data.SqlClient.SqlError: The database was backed up on a server running version 13.00.5026. That version is incompatible with this server, which is running version 12.00.2000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)  have script?

I have added the db script in the attachments.

thanks ,

thanks

awesome bot thanks for sharing

Great job, Ace! Can't wait to see this used in Ruby 4! #waiting.

Can you tell me about the installation?
Can you tell with video. I don't understand how it works :(

Quote:

Originally Posted by ILowe Can you tell me about the installation? Can you tell with video. I don't understand how it works :(

Check the first post, I have added a small guide on how to do it.

Anyone test it and Work fine

error

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]