Wacko Bot

var Discord = require('discord.js')
var bot = new Discord.Client();
var fs = require('fs');
var mysql = require('mysql');

var userData = JSON.parse(fs.readFileSync('Storage/userData.json', 'utf8'));
var commandsList = fs.readFileSync('Storage/commands.txt', 'utf8');

bot.on('message', message =>{

    var sender = message.author;
    var msg = message.content.toUpperCase();
    var prefix = '<'

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

        //let sql;

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

   // con.query(sql, console.log);
   // });


    if (sender.id === '365310048815153154') {
        return;
    }

    if (msg === prefix + 'HELP' || msg === prefix + 'COMMANDS') {
        message.channel.send(commandsList)

    }



    if (msg === prefix + 'STATS') {
        message.channel.send({embed:{
            title:'Stats',
            description:' In ' + bot.guilds.size + " Guilds!",
            color:0xFF00FF
        }})
    }



    if (msg === prefix + 'PING') {
        message.channel.send('Pong')
         bot.user.setGame('<help | ' + bot.guilds.size + ' Guilds!', 'https://twitch.tv/wackowookiee');
         message.react("eggplant")
    }

    if (message.channel.id === '365353184778256386') {
        if (isNaN(message.content)) {
            message.delete()
            message.author.send('Please only post numbers!')
        }
    }
   // if (msg.includes('WACKO')) {
      //  message.delete();
      //  message.author.send('Please dont not use the word **Wacko**')
    //}

if (msg === prefix + 'USERSTATS') {
    message.channel.send('You have sent **' + userData[sender.id].messagesSent + '** messages!')
}

    if (!userData[sender.id]) userData[sender.id] = {
        messagesSent: 0
    }

userData[sender.id].messagesSent++;
fs.writeFile('Storage/userData.json', JSON.stringify(userData), (err) =>{
    if (err) console.log(err);
    //con.query("SHOW TABLES", console.log);
});

});

//var con = mysql.createConnection({
//host: "localhost",
//user: "bot",
//password: "wacko",
//database: "sadb"
//});

//con.connect(err => {
//if(err) throw err;
//console.log("Connected to database")
//});

bot.on('ready', () => {
    console.log('Bot Launched!')
    bot.user.setGame('<help | ' + bot.guilds.size + ' Guilds!', 'https://twitch.tv/wackowookiee');
});



//bot.on('guildMemberAdd', member => {

    //console.log('User ' + member.user.username + " has joined the server!")

    //var role = member.guild.roles.find('name', 'Awks');

    //member.addRole(role)


   // member.guild.channels.get('365357215714115585').send('**' + member.user.username + '**, has joined the server!');
//});

//bot.on('guildMemberRemove', member => {

   // member.guild.channels.get('365357215714115585').send('**' + member.user.username + '**, has left the server! :(');

//});
//function generateXp(){
   // let min = 10
   // let max = 30
  //  return Math.floor(Math.random() * (30 - min + 10)) + min;
//}


































bot.login('MzY1MzEwMDQ4ODE1MTUzMTU0.DLdC3A.UT8z5BrTmsKeAFLgIN77mjAwoCs')