Advertisement
Guest User

Help

a guest
Oct 29th, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. const mysql = require('mysql');
  2.  
  3. var settings = mysql.createConnection({
  4.     host: 'localhost',
  5.     user: 'root',
  6.     password: '',
  7.     database: 'guildsettings'
  8. })
  9.  
  10. settings.connect(err => {
  11.     if (err) throw err;
  12.     console.log('Connected to the database 1!');
  13. })
  14.  
  15. settings.query(`SELECT * FROM guild WHERE guildID = '${message.guild.id}'`, (err, rows) => {
  16.         if(err) throw err;
  17.  
  18.         let sql;
  19.  
  20.         if(rows.length < 1) {
  21.             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')`
  22.         } else if(command === `${prefix}set`) {
  23.             let channel = args[0];
  24.  
  25.             sql = `UPDATE guild SET watchchannel = '${channel}' WHERE guildID = '${message.guild.id}'`;
  26.         } else if(command === `${prefix}reset`) {
  27.             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}'`;
  28.         } else return
  29.        
  30.  
  31.         settings.query(sql, console.log)
  32.     })
  33.  
  34.     let balnk = settings.query(`SELECT prefix FROM guild WHERE guildID = '${message.guild.id}'`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement