fs.readdir("./cmds/", (err, files) => {
    if(err) console.error(err);

    let jsfiles = files.filter(f => f.split(".").pop() === "js");
    if(jsfiles.length <= 0) {
        console.log("No commands to load.");
        return;
    }

    console.log(`Loading ${jsfiles.length} commands.`)

    jsfiles.forEach((f, i) => {
        let props = require(`./cmds/${f}`);
        console.log(`${i + 1}: ${f} loaded.`)
        bot.commands.set(props.help.name, props);
    });
});


bot.on('ready', async () => {
  console.log('I am ready!');

try {
        let link = await bot.generateInvite(["ADMINISTRATOR"]);
        console.log(link);
    } catch(e) {
        console.log(e.stack);
    }
});
//DATABASE
var con = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "1234",
    database: "sadb"
});

con.connect(err => {

    console.log("connected to database");
    con.query("SHOW TABLES", console.log);
});
//END DATABASE

function generateXP(){
    let min = 10;
    let max = 30;

    return Math.floor(Math.random() * (max - min + 1)) + min;
    }
// Read chat / message reader
bot.on('message', async message => {
    if(message.author.bot) return;
    if(message.channel.type === "dm") return;

    con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, (err, rows) =>{


        let sql;

        if(rows.length < 1){
            sql = `INSERT INTO xp (id, xp) VALUES ('${message.author.id}', ${generateXP()})`;
        } else {
            // PREVIOUS XP
            let xp = rows[0].xp;
            sql = `UPDATE xp SET xp = ${xp + generateXP()} WHERE id = '${message.author.id}'`;
        }

        con.query(sql);
    });

    if(/(?:https?:\/)?discord(?:app.com\/invite|.gg)/gi.test(message.content)){
        message.delete();
        return;
    }

    let messageAarray = message.content.split(/\s+/g);
    let command = messageArray[0];
    let args = messageArray(1);

    if(!command.startsWith(prefix)) return;
    let limit = bot.ratelimits.get(message.author.id);
    let now = Date.now();
    let timeLimit = 2000;

    if(limit != null){
        if(limit >= now - timelimit) {
            message.delete();
            return message.channel.send("RATELIMITED")

        } else {
            bot.ratelimits.set(message.author.id, now);

        }
    } else {
        bot.ratelimits.set(message.author.id, now);
    }
    let cmd = bot.comands.get(command.slice(prefix.length));
    if(cmd) cmd.run(bot, message, args, con);

});

bot.login(token);