module.exports.run = async (bot, message, args) => {
	if(message.channel.type == "dm"){
		return message.reply("Please dont use this command in DMs!")
	}
	message.delete();
	function isEmpty(obj) {
		for(var key in obj) {
			if(obj.hasOwnProperty(key))
				return false;
		}
		return true;
	}
    var con = mysql.createConnection({
        host: "79.137.1.132",
        user: "u780_qYfiicxYfy",
        password: "bhNg1zNRDdBDOqew",
		database: 's780_whitelistSystem'
	});

    let author = message.guild.member(message.author)
    let selly = args[0]
    if(args.length < 1) return message.reply("please specify your selly.gg purchase code!");
    con.connect(function(err) {
		if (err) {
			message.reply("An unexpected error occured!\n[connect]\n\n"+err)
			throw err;
		}
    });
	con.query(`SELECT * FROM whitelistKeys WHERE selly='${selly}'`, function (err, result, fields) {
		if (err) {
			message.reply("An unexpected error occured!\n[query]\n\n"+err)
			throw err;
		}
		if(!isEmpty(result)){
			var sql = `INSERT INTO logs (discordID, suspicous, reason, whitelistKey) VALUES('${author.id}', 'true', 'usedSelly', 'N/A')`
			con.query(sql, function (err,result,fields) {
				if (err) {
					message.reply("An unexpected error occured!\n[query]\n\n"+err)
					throw err;
				}
				return message.reply("You have been logged for suspicious activity. This selly key is already used. If you think this is an error, DM Serophots#8223 with proof of purchase!")
			});
		}else{
			const checked = false;
			const generated = false;
			const verified = false;
			const finalize = false;

			message.reply("Checking selly key")

			var sql = `SELECT * FROM sellyKeys WHERE selly='${selly}'`
			con.query(sql, function (err, result,fields){
				if (err) {
					message.reply("An unexpected error occured!\n[query]\n\n"+err)
					throw err;
				}
				if(isEmpty(result)){
					return message.reply("You have been logged for suspicious activity. This selly key is not valid. If you think this is an error, DM Serophots#8223 with proof of purchase!")
				}else{
					console.log(result);
					checked = true
				}
			});
			await checked == true

			message.reply("Checked selly key")


			message.reply("Generating a whitelist key...")
			const key = uuid()
			message.reply("Generated whitelist key!")
			generated = true
			await generated == true



			message.reply("Verifying whitelist key...")
			sql = `SELECT * FROM whitelistKeys WHERE whitelistKey='${key}'`
			con.query(sql, function (err,result,fields) {
				if (err) {
					message.reply("An unexpected error occured!\n[query]\n\n"+err)
					throw err;
				}
				if(!isEmpty(result)) return message.reply("Unable to complete verification check! Try again!");
			});
			message.reply("Verified whitelist key!")
			verified = true
			await verified == true


			message.reply("Finalizing whitelist")
			sql = `INSERT INTO logs (discordID, suspicous, reason, whitelistKey) VALUES('${author.id}', 'false', 'N/A', '${key}')`
			con.query(sql, function (err,result,fields) {
				if (err) {
					message.reply("An unexpected error occured!\n[query]\n\n"+err)
					throw err;
				}
			});
			sql = `INSERT INTO whitelistKeys (selly, discordID, whitelistKey, whitelisted, blacklisted) VALUES('${selly}', '${author.id}', '${key}', 'true', 'false')`
			con.query(sql, function (err,result,fields) {
				if (err) {
					message.reply("An unexpected error occured!\n[query]\n\n"+err)
					throw err;
				}
			})
			message.reply("Finalized. Please check your DMs to find your whitelist key")
			finalize = true
			await finalize == true

			let embed = new Discord.RichEmbed()
			.setTitle("Your whitelist key")
			.setDescription(`Thank you for using LumberHaxx. If you have any problems,\ncontact staff and they will help you out!\n\nWhitelistkey: ${key}\n\nIf your key does not work, DM Serophots#8223 for support!`)
			.setColor('#'+(Math.random()*0xFFFFFF<<0).toString(16));
			author.send(embed);
		}
	});/*
	con.end(function(err) {
		if (err) {
			message.reply("An unexpected error occured!\n[query]\n\n"+err)
			throw err;
		}
	}); */
}