const Discord = require("discord.js");
const {EmbedBuilder} = require('discord.js')

module.exports = {
  name: 'addgoodbye',
  description: "Vous permez d'envoyer un message privé.",
  utilisation: "/addgoodbye",
  permission: Discord.PermissionFlagsBits.ManageGuild,
  dm: false,
  category: "administration",

  async run(bot, message) {
    if (!bot.db) {
      return message.reply({ content: "La base de données n'est pas disponible.", ephemeral: true });
    }

    const db = bot.db;
    const embedID = new EmbedBuilder()
      .setDescription(`MERCI D'ENVOYER L'ID DU SALON PAR MESSAGE CI DESSOUS ⬇️`);

    db.query(`SELECT * FROM server WHERE guild = '${message.guild.id}'`, async (err, req) => {
      if (req.length < 1) {
        message.reply({ content: "Je suis navré mais vous n'avez pas enregistré le serveur en bdd", ephemeral: true });
      } else {
        message.reply({ embeds: [embedID], ephemeral: true }).then(() => {
          const filter = m => m.author.id === message.user.id;
          const collector = message.channel.createMessageCollector({ filter, max: 1 });

          collector.on('collect', (m) => {

            let channel = m.content;
            setTimeout(() => {
              bot.channels.fetch(m.channelId).then(channel => {
                channel.messages.delete(m.id);
              });
            }, 2000);

            db.query(`SELECT * FROM server WHERE guild = '${message.guild.id}'`, async (err, req) => {

              db.query(`UPDATE server SET goodbyeChannel = '${channel}' WHERE guild = '${message.guild.id}'`);
            });
            });
        });
      }
    });
  }
};