const Discord = require("discord.js")

module.exports = {
    name: "redeem",
    aliases: [],
    category: "misc",
    description: "Redeem premium on your server.",
    usage: "[command | alias]",
    run: async (bot, message, args, con) => {
        if(!args) return pmessage.channel.send("Please enter a code after the command `pm!redeem [code]`");     
        const embed = new Discord.RichEmbed()
        let row = await con.prepare('SELECT * FROM config WHERE guildid = ?').get(message.guild.id);
        const { premium } = await con.prepare('SELECT premium FROM config WHERE guildid = ?').get(message.guild.id);
        let crow = await con.prepare('SELECT * FROM codes');
        const { code } = await con.prepare('SELECT code FROM codes');
        if(code == args[0]) {
            if (premium == 0) {
                con.prepare('UPDATE config SET premium = ? WHERE guildid = ?').run(1, message.guild.id);
                embed.setTitle("Premium added.")
                embed.addField(`**GuildID**`, message.guild.name)
                message.channel.send(embed)
            } else {
                embed.setTitle("Error.")
                embed.addField(`**GuildID**`, `${message.guild.name} already has premium enabled.`)
                message.channel.send(embed)
                con.prepare('DELETE FROM codes WHERE code = ?').run(args[0]);
            }
        } else {
            const rembed = new Discord.RichEmbed()
            embed.setTitle("Error.")
            embed.addField(`**Couldn't verify code**`, `${args[0]} has already been used or is an invalid code.`)
            message.channel.send(embed)              
        }
    }
}