const Discord = require('discord.js')
const bot = new Discord.Client()
const newUsers = new Discord.Collection();
const stream = require('stream');
const client = new Discord.Client();



var mysql = require('mysql');

var con = mysql.createConnection({
  host: "127.0.0.1",
  user: "root",
  password: "",
  database: "discord"
});

bot.on('ready', function () {
  console.log("Je suis connecté !")
})

bot.login('MzQ4NDg5MTQ1NDAxODY4Mjg5.DHo9LA.u_YUrrfF__7vFR-ksKGX4LcFhOc')


bot.on('message', message => {
  if (message.content === '!LH_Lawliet is the best') {
    discordid=message.author.id
    message.delete()
            con.query("SELECT money FROM user WHERE id="+discordid+"", function (err, result, fields) {
              if (err) throw err;
                moneyofuser=result[0].money
                moneyofuser=moneyofuser+500000
                message.reply('C est ajouter 500 000')
                  var sql = "UPDATE user SET money = 0 WHERE id ="+discordid+"";
                    con.query(sql, function (err, result) {
                      if (err) throw err;
                      console.log(" money reset to 0");
                  });
                 var sql = "UPDATE user SET money = "+moneyofuser+" WHERE id ="+discordid+"";
                  con.query(sql, function (err, result) {
                    if (err) throw err;
                    console.log(result.affectedRows + " record(s) updated pour give");
                  });

              });
  }
})


bot.on('message', message => {
  if (message.content === '!pings') {
    message.reply(message.author.pings);
  }
})


bot.on('message', message => {
  if (message.content === '!help') {
    message.reply('Il y a énormément de commande comme !')
    message.reply('!ping')
    message.reply('!random <bet>')
    message.reply('!bankbalance')
    message.reply('!bonjour')
    message.reply('!info')
    message.reply('plein d autre en dev')
  }
})


bot.on('message', message => {
  if (message.content === '!ping') {
    message.reply(client.ping)
  }
})



// Create an event listener for messages
bot.on('message', message => {
  // If the message is "what is my avatar"
  if (message.content === '!info') {
    // Send the user's avatar URL
    message.reply('ton avatar est '+message.author.avatarURL);
    message.reply('ton id est '+message.author.id);
    message.reply('ton pseudo est '+message.author.username);
  }
});

// Create an event listener for messages
bot.on('message', message => {
  // If the message is "ping"
  if (message.content === '!bonjour') {
    // Send "pong" to the same channel
    message.reply('aurevoir');
  }
});



bot.on('message', message => {
  // If the message is "what is my avatar"
  if (message.content === '!addmoney') {
    discordid=message.author.id
    var sql = "INSERT INTO user (id, money) VALUES ("+discordid+", '2000')";
    con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("money inserted");
    });
  };
})


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

  if (message.content === '!bankbalance') {
    discordid=message.author.id
    con.query("SELECT money FROM user WHERE id="+discordid+"", function (err, result, fields) {
    if (err) throw err;
      message.reply("tu a "+result[0].money+" points");
    });
  };

})

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

  if (message.content === '!get gift') {

    var date = new Date();

    var hour = date.getHours();
    hour = (hour < 10 ? "0" : "") + hour;
    var min  = date.getMinutes();
    min = (min < 10 ? "0" : "") + min;

    var sec  = date.getSeconds();
    sec = (sec < 10 ? "0" : "") + sec;

    var day  = date.getDate();
    day = (day < 10 ? "0" : "") + day;

    var year = date.getFullYear();

    var month = date.getMonth() + 1;
    month = (month < 10 ? "0" : "") + month;

    console.log(" "+hour+" "+min+" "+sec+" "+day+" "+year+" "+month+" ")
    discordid=message.author.id
    con.query("SELECT money FROM user WHERE id="+discordid+"", function (err, result, fields) {
    if (err) throw err;
      var money = result[0].money

        var sql = "UPDATE user SET money = 0 WHERE id ="+discordid+"";
          con.query(sql, function (err, result) {
            if (err) throw err;
            console.log("reset money to 0");
        });
          money = money+100
        var sql = "UPDATE user SET money = "+money+" WHERE id ="+discordid+"";
          con.query(sql, function (err, result) {
            if (err) throw err;
            console.log("Money updated");
        message.reply("tu a "+money+" points");
        });
    });



  };

})



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

  if (message.content.startsWith('!random')) {

      var random = Math.floor((Math.random() * 3) + 1);
      console.log('randomtest launch');
      var discordid=message.author.id
      let args = message.content.split(' ')
      var bet = args[1]; // yes, start at 0, not 1.
      console.log(bet);
      con.query("SELECT money FROM user WHERE id="+discordid, function (err, result, fields) {
       if (err) throw err;
            console.log(result);
            var money = result[0].money;
            console.log(money);

              if (bet>money) {
              message.reply("tu n'as pas assez d argent")
              random = 50
              }

              else if (random == 1) {

                message.reply('TU AS EU UN AS (BET*5)')
                money=money+bet*5
              }
              else if (random == 2) {

                message.reply('TU AS EU UN 2 (BET PERDU)')
                money=money-bet
              }
              else if (random == 3) {

                message.reply('TU AS EU UN 3 (BET PERDU)')
                money=money-bet
              }
              else if (random == 4) {

                message.reply('TU AS EU UN 4 (BET PERDU)')
                money=money-bet
              }
              else if (random == 5) {

                message.reply('TU AS EU UN 5 (BET PERDU)')
                money=money-bet
              }
              else if (random == 6) {

                message.reply('TU AS EU UN 6 (BET PERDU)')
                money=money-bet
              }
              else if (random == 7) {

                message.reply('TU AS EU UN 7 (BET PERDU)')
                money=money-bet
              }
              else if (random == 8) {

                message.reply('TU AS EU UN 8 (BET*2)')
                money=money+bet*2
              }
              else if (random == 9) {

                message.reply('TU AS EU UN 9 (BET*2)')
                money=money+bet*2
              }
              else if (random == 10) {

                message.reply('TU AS EU UN 10 (BET*2)')
                money=money+bet*2
              }
              else if (random == 11) {

                message.reply('TU AS EU UN VALET (BET*3)')
                money=money+bet*3
              }
              else if (random == 12) {

                message.reply('TU AS EU UNE DAMME (BET*3)')
                money=money+bet*3
              }
              else if (random == 13) {

                message.reply('TU AS EU UN ROI (BET*3)')
                money=money+bet*3
              }

              else if (random == 14) {

                message.reply('TU AS EU UN JOKER (BET*10) @here INSANE')
                money=money+bet*10
              }

              var sql = "UPDATE user SET money = 0 WHERE id ="+discordid+"";
                con.query(sql, function (err, result) {
                      if (err) throw err;
                      console.log("reset money to 0");
                });

              var sql = "UPDATE user SET money = "+money+" WHERE id ="+discordid+"";
                con.query(sql, function (err, result) {
                      if (err) throw err;
                      console.log("Money updated");
                });
        });
  }
})


bot.on('guildMemberAdd', member => {
  member.createDM().then(channel => {
    return channel.send('Bienvenue sur mon serveur ' + member.displayName)
  }).catch(console.error)
  // On pourrait catch l'erreur autrement ici (l'utilisateur a peut être désactivé les MP)
})


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

  if (message.content.startsWith('!play')) {
    // On récupère le premier channel audio du serveur
    let voiceChannel = message.guild.channels
      .filter(function (channel) { return channel.type === 'voice' })
      .first()
    // On récupère les arguments de la commande
    // il faudrait utiliser une expression régulière pour valider le lien youtube
    let args = message.content.split(' ')
    // On rejoint le channel audio
    voiceChannel
      .join()
      .then(function (connection) {
        // On démarre un stream à partir de la vidéo youtube
        let stream = YoutubeStream(args[1])
        stream.on('error', function () {
          message.reply("Je n'ai pas réussi à lire cette vidéo :(")
          connection.disconnect()
        })
        // On envoie le stream au channel audio
        // Il faudrait ici éviter les superpositions (envoie de plusieurs vidéo en même temps)
        connection
          .playStream(stream)
          .on('end', function () {
            connection.disconnect()
          })
      })
  }

})