fdsf

```
const mysql = require('mysql');
const Discord = require('discord.js');
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 (result[0]) {
                        if (result[0].scoree > 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[0].scoree > 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();
            });
        });
    }
});
client.login("NDU0NbiyM");
```