const mysql = require('mysql');
const Discord = require('discord.js');
const request = require('request')
const client = new Discord.Client();
let prefix = "!";
var role = null;
client.on('message', async message => {
    if (message.channel.type == 'text' && message.content.startsWith(`${prefix}rank`)) {
        console.log("test")
      /*  const con = mysql.createConnection({
            host: '//',
            user: 'root',
            password: '//',
            database: 'test'
        });*/
        message.guild.fetchMember(message.author).then(async guildMember => {
           // con.connect(async function (err) {
               // if (err) throw err;
             //   var sql = "SELECT scoree FROM score WHERE discordid = ?";
               // con.query(sql, [message.author.id], async function (err, result) {
                    //if (err) throw err;
                    //if (err) throw err;
                    request.get(`https://forum.terteus.eu/banlist/test.php?discordid=${message.author.id}`, async function(err,httpResponse,result){
                        console.log(result)
                    if (result) {

                        if (result > 0 <= 5) {
                            var role = message.guild.roles.find(r => r.name === `Minecraft Miner`);
                            if (!role) {
                                role = await message.guild.createRole({
                                    name: "Minecraft Miner",
                                    color: "#000000",
                                    permissions: []
                                });
                            }
                        }
                        if (result > 5) {
                            var role = message.guild.roles.find(r => r.name === `Nolife Miner`);
                            if (!role) {
                                role = await message.guild.createRole({
                                    name: "Nolife Miner",
                                    color: "#000000",
                                    permissions: []
                                });
                            }
                        }
                        guildMember.addRole(role);
                        message.reply(`Your rank ${role.name} was set`);
                    } else {
                        message.reply("You dont have any rank yet !");
                        return;
                    }
               // });
                //con.end();

            });

        });
    }
});