const Discord = require("discord.js");
const { stripIndents } = require("common-tags");

module.exports = {
    name: "redeem",
    aliases: [],
    category: "misc",
    description: "Redeem premium on your server.",
    usage: "[command | alias] <code>",
    run: async (bot, message, args, con) => {
        if(args.length == 0) return message.channel.send("Please enter a code after the command `pm!redeem [code]`");     
        const embed = new Discord.RichEmbed()
        let crow = await con.prepare('SELECT * FROM codes WHERE code = ?').get(args[0]);
        const { code } = await con.prepare('SELECT code FROM codes WHERE code = ?').get(args[0]);
        if(con.prepare('SELECT code FROM codes WHERE code != ?').get(args[0])) {
            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)   
        } else {
            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);
            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)
                await message.channel.send(embed)
                con.prepare('DELETE FROM codes WHERE code = ?').get(args[0]);   
            } else {
                embed.setTitle("Error.")
                embed.addField(`**GuildID**`, `${message.guild.name} already has premium enabled.`)
                message.channel.send(embed)
               
            }
        }
    }
}