const Discord = require('discord.js')
const mysql = require('mysql');
const bot = new Discord.Client()
const ip = require('ip');
const moment = require('moment');
const request = require('request');
const rp = require('request-promise');
const cheerio = require('cheerio');
var EventEmitter = require("events").EventEmitter;

var con = mysql.createConnection({
    host: "localhost",
    user: "****",
    password: "****",
    database: "foxy"
});

con.connect(function(err) {
	if (err) throw err;
    console.log("Connected!");
});

var arrayUser = [];


bot.on('ready', function () {
    console.log("Je suis connecté !")
    bot.user.setPresence({status: 'online', game: { name : 'Se rouler en boule'}});

})

bot.login('*********************');

bot.on("guildMemberAdd" , (member) => {
    console.log(member);
    if(member)
    {
	console.log('Member exists')
	var id = member.user.id
	member.addRole('516992804178886686');
	arrayUser['id-'+id] = []
	console.log(arrayUser['id-'+member.id]);
	member.guild.channels.get('516991336017166337').send("Welcome <@"+id+">");

    }
    else
	console.log("Member don't exisst")



    var records = [
	[0, member.displayName, member.id, 0, '0000-00-00 00:00:00', '00:00:00', 0, 9]
    ];

    var sql = "INSERT INTO user (id, user_name, user_disc, salary, user_voicetime, user_totaltime, user_xp, id_user_role) VALUES ?";
    con.query(sql, [records], function (err, result) {
	if (err) throw err;
	console.log("1 record inserted");
    });
});


//bot.on("unhandledRejection", error => {
//    console.error("Unhandled promise rejection: ", error);
//});