const Discord = require("discord.js");
const config = require("../../config.json")
const mysql = require('mysql');

module.exports = {
    name: "premium",
    aliases: [],
    category: "admin",
    description: "Add premium",
    usage: "[command | alias] <guildid>",
    run: async (bot, message, args, con) => {
        
        let embed = new Discord.RichEmbed()
		if (!config.eval_access.includes(message.author.id))
		{
				return message.channel.send('You\'re not allowed to use this command.');			    
		} else {
            if(!args) return message.channel.send("Please enter a guildid") 
            let row = await con.prepare('SELECT * FROM config WHERE guildid = ?').get(args[0]);
            const { premium } = await con.prepare('SELECT premium FROM config WHERE guildid = ?').get(args[0]);
            if (premium != 1) {
                con.prepare('UPDATE config SET premium = ? WHERE guildid = ?').run(1, args[0]);
                embed.setTitle("Premium added.")
                embed.addField(`**GuildID**`, args[0])
                message.channel.send(embed)
                    
            } else {
                con.prepare('UPDATE config SET premium = ? WHERE guildid = ?').run(0, args[0]);
                let embed = new Discord.RichEmbed()
                .setTitle("Premium removed.")
                .addField(`**GuildID**`, args[0])
                message.channel.send(embed)
            }
        } 
    }
}