Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const mysql = require('mysql');
- var settings = mysql.createConnection({
- host: 'localhost',
- user: 'root',
- password: '',
- database: 'guildsettings'
- })
- settings.connect(err => {
- if (err) throw err;
- console.log('Connected to the database 1!');
- })
- settings.query(`SELECT * FROM guild WHERE guildID = '${message.guild.id}'`, (err, rows) => {
- if(err) throw err;
- let sql;
- if(rows.length < 1) {
- sql = `INSERT INTO guild (guildID, modlogchannel, memberlogchannel, botUpdates, welcomeEnabled, autoRole, prefix, watchchannel) VALUES ('${message.guild.id}', 'mod-log', 'member-log', 'update-log', 'true', 'Member', 'tb!!', 'watch-channel')`
- } else if(command === `${prefix}set`) {
- let channel = args[0];
- sql = `UPDATE guild SET watchchannel = '${channel}' WHERE guildID = '${message.guild.id}'`;
- } else if(command === `${prefix}reset`) {
- sql = `UPDATE guild SET modlogchannel = 'mod-log', memberlogchannel = 'member-log', botUpdates = 'update-log', welcomeEnabled = 'true', autoRole = 'Member', prefix = 'tb!!', watchchannel = 'watch-channel' WHERE guildID = '${message.guild.id}'`;
- } else return
- settings.query(sql, console.log)
- })
- let balnk = settings.query(`SELECT prefix FROM guild WHERE guildID = '${message.guild.id}'`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement