const discord = require("discord.js");
const fs = require("fs");
const bot = new discord.Client();
const colors = require('colors');
const mysql = require('mysql');
const moment = require('moment');
const botconfig = require("./botconfig.json")
const talkedRecently = new Set();

bot.commands = new discord.Collection();
bot.func = require('./storage/functions.js')

var con = mysql.createConnection({
  host: botconfig.host,
  port: botconfig.port,
  user: botconfig.user,
  password: botconfig.password,
  database: botconfig.database
});

con.connect(err => {
  moment.locale('nl');
  var d = moment().format('L');
  var t = moment().format('LT');
  var logDate = `[${d} ${t}]`

  if(err) throw err;
  console.log("")
  console.log(`${logDate} `.white + `Verbonden met `.bold.green + `${botconfig.database}`.green)
  console.log("")
});


bot.on('ready', () => require('./events/ready.js')(bot));


/*
  Command Handler
*/
fs.readdir("./commands/" , (err, files) => {
    if(err) console.log(err);
    var jsfiles = files.filter(f => f.split(".").pop() === "js");
    if(jsfiles.length <=0) {
        console.log("Geen files gevonden in /commands/.");
        return;
    }
    jsfiles.forEach((f,i) => {
        var fileGet = require(`./commands/${f}`);
        console.log(`${f} Is geladen`);
        bot.commands.set(fileGet.help.name, fileGet);
    })
});
bot.on("message", (message) => {
  var guildId = message.guild.id
  if (message.channel.type === "dm")return;
  if (message.author.bot) return;
  if (talkedRecently.has(message.author.id)) {
        message.channel.send("**Cooldown** Wait `1` second!" + message.author);
    } else {
      con.query(`SELECT gPrefix FROM guilddata WHERE gId ="${message.guild.id}"`, (err, rows) => {
      if (err) throw err;
        if (rows.length > 0) {
          // Als de prefix gevonden is.
          let prefix = rows[0].gPrefix;
          if (!message.content.startsWith(prefix)) return;
          var messageArray = message.content.split(" ");
          var command = messageArray[0];
          var args= messageArray.slice(1);
          var commands = bot.commands.get(command.slice(prefix.length));
          if(commands) commands.run(bot, message, args, con);

          let logGuild = bot.guilds.find(g => g.id == `${botConfig.logGuild}`);
          let commandLog = logGuild.channels.find(c => c.id == `${botConfig.commandLog}`);

          var embedCommandLog = new discord.RichEmbed()
            .setTitle(`**Command Gebruikt**`)
            .addField("Command", message.content)
            .addField("Author", message.author + " *" +  message.author.id + "*")
            .addField("Guild", message.guild + " *" + message.guild.id + "*")
            .setColor("#4abb3c")
            .setFooter("Electronic")
            .setTimestamp();
          commandLog.send(embedCommandLog)

        } else {
          //Als de prefix NIET gevonden is, registreer de guild in de database
          bot.func.dbGuildCreate(bot, message)
        }
      })
        talkedRecently.add(message.author.id);
        setTimeout(() => {
          talkedRecently.delete(message.author.id);
        }, 1000);
    }

});


bot.login(botconfig.token);