SiteLink

SiteLink

Message to mysql database discord bot

The purpose of this bot is to dump the messages sent in a chat channel of discord to a MySQL database, with content, time, id, sender id, attachments links and image links all separated.

Features

• Dump messages to mySQL database
• Scalable, this bot is able to work across multiple servers at the same time, with the same code running and can be configured all from the config file
• Auto extraction of links and attachments that are passed as json elements to the database
• Include time stamp and id of the message
• Able to choose if to send the id, username or tag of the author of the message according to what's needed
• Able to choose if to send the id, username or tag of the users mentioned in the message according to what's needed
• Able to choose if to send the id or name of the channel mentioned in the message according to what's needed
• Able to choose if to send the id, name or name with color of the roles mentioned in the message according to what's needed
• Able to dump messages that has been send when the bot was ofline with dedicated !dump [arg] command (prefix can be changed in the config file), and an argument can be passed to limit the number of messages checked (limited and by default 99)
• Able to disable dump command on each channel individually
• Update data in the database if someone edits a message with dedicated value in the database
• Emojis are automaticaly converted from unicode to discord mark down(AKA 😂 --> :joy:)
• Able to choose if to ignore bots
• Supports parial

## How to set up

1. First make sure that you have the latest version of NodeJS and MySQL installed.
2. Run this command in a command prompt to install all the libraries required to run the code: npm install .
3. Create your bot on the developer portal on the discord website.
4. Copy the example config to config.json and configure as detailed below.

|Setting|Description| |--|--| |token|Discord API bot token (found on the developer portal)| |prefix|The prefix that will be used to trigger commands| |playing|Sets the playing status| |godMode|Array of user IDs who will be able to use the special commands| |servers|Array of configured servers| |servers.channel|ID of Discord channel to listen to| |servers.userMentionsMode| Conversion settings for user mentions in Discord messages. 0 will set as the user ID, e.g. @182925154211332097. 1 will set as just the username, e.g. @Owen. 2 will set as just the in-server nickname, e.g. @Not Owen. 3 will set as the username + discriminator, e.g. @Owen#1111 4 will set as the user ID plus end marker, e.g. @182925154211332097@. 5 will set as just the username plus end marker, e.g. @Owen@. Anything else will set as just the in-server nickname plus end marker e.g. @Not Owen@.| |servers.channelMentionsMode| Conversion settings for channel mentions in Discord messages. 0 will set as the channel ID, e.g. #224558110868635658. 1 will set as the name, e.g. #rules. 2 will set the id in between two hastag, e.g. #224558110868635658#. Anything else will the channel name between two hastag, e.g. #rules#.| |servers.roleMentionsMode| Conversion settings for role mentions in Discord messages. 0 will set as the role ID, e.g. &677081843086000128. 1 will set as just the name of the role, e.g. &foo. Anything else will set as the name + color in hex, e.g. &foo#ffffff| |servers.authorMode|Conversion settings for the author of the message. 0 will set as the user ID, e.g. @182925154211332097. 1 will set as just the username, e.g. @Owen. 2 will set as the username + discriminator, e.g. @Owen#1111. Anything will set just the in-server nickname, e.g. @Not Owen.| |servers.allowBots|Filters bots messages if setted to false (bolean)| |servers.prefix(optional)|This sets a custom prefix for the channel for the dump command and overwrites the prefix on for that particular channel| |servers.dbHost|MySQL database host| |servers.dbUser|MySQL database username| |servers.dbPassword|MySQL database password| |servers.db|MySQL database to store data in| |servers.dbTable|MySQL database table to store data in|

1. Connect your bot to your guild, by entering thE link https://discordapp.com/oauth2/authorize?client_id={YOUR BOT ID}scope=bot&permissions=8.

2. Setup the MySQL database table with the following query, replacing "TABLE_NAME" as appropriate.

   CREATE TABLE `TABLE_NAME` (
   `message` longtext NOT NULL,
   `id` text NOT NULL,
   `time` varchar(25) NOT NULL,
   `timeEdit` varchar(25) NOT NULL,
   `user` text NOT NULL,
   `links` text NOT NULL,
   `images` text NOT NULL
   ) COLLATE 'utf8mb4_unicode_ci';
   

3. Start the bot by running node index.js or nodemon

4. Congratulation, your bot is up and running!

To do stuff

• Automatically delete from database if message is removed on Discord
• Add example code of usage

## If any problem comes up or something please open an issue on github

Have a great life!