const commando = require('discord.js-commando');
const mysql = require("mysql");
const { RichEmbed } = require('discord.js');

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

con.connect(err => {
    if(err) throw err;
    con.query("SHOW TABLES");
});


class ShowXPCommand extends commando.Command {
    constructor(client) {
        super(client, {
            name: 'showxp',
            group: 'xp',
            memberName: 'showxp',
            description: 'Shows the XP of mentioned user or you.'
        });
    }

    async run(message, args) {
        let target = message.mentions.users.first() || message.guild.members.get(args[1]) || message.author;

        con.query(`SELECT * FROM xp WHERE id = '${target.id}'`, (err, rows) => {
            if(err) throw err;

            if(!rows[0]) return message.channel.send("This user has no XP on record. :c ~")

            let xp = rows[0].xp;
            message.channel.send(xp);

            let embed = new RichEmbed()
            .setDescription("User's XP")
            .setcolor("#15f153")
            .addField("User's Name", message.target.username);
            return message.embed(embed);
        })
    }
}

module.exports = ShowXPCommand