const { SlashCommandBuilder, EmbedBuilder, PermissionFlagsBits, Colors } = require('discord.js');
const db = require('../database'); // Ellenőrizd, hogy a db-nek helyes elérési útja van

module.exports = {
  data: new SlashCommandBuilder()
    .setName('warnings')
    .setDescription('Check warnings of a user')
    .addUserOption(option => option.setName('target').setDescription('User to check warnings for').setRequired(true)),

  async execute(interaction) {
    const member = interaction.options.getMember('target');

    if (!interaction.member.permissions.has(PermissionFlagsBits.ModerateMembers)) {
      console.log('Permission denied for:', interaction.user.tag);
      return interaction.reply({ content: 'You do not have permission to view warnings.', ephemeral: true });
    }

    db.all(`SELECT * FROM warnings WHERE user_id = ? AND guild_id = ?`, [member.id, interaction.guild.id], (err, rows) => {
      if (err) {
        console.error('Error retrieving warnings:', err.message);
        return interaction.reply('An error occurred while retrieving warnings.');
      }

      if (rows.length === 0) {
        return interaction.reply(`${member.user.tag} has no warnings.`);
      }

      const warningsEmbed = new EmbedBuilder()
        .setTitle(`Warnings for ${member.user.tag}`)
        .setColor(Colors.Yellow)
        .setDescription(rows.map(row => `🔸 **ID:** ${row.id}\n🔸 **Reason:** ${row.reason}\n🔸 **Date:** ${new Date(row.timestamp).toLocaleDateString()}`).join('\n\n'))
        .setFooter({ text: `Requested by ${interaction.user.tag}` })
        .setTimestamp();

      interaction.reply({ embeds: [warningsEmbed] });
    });
  }
};