const { EmbedBuilder, Events } = require('discord.js');
const sqlite3 = require('sqlite3').verbose();
const db = new sqlite3.Database('myDatabase.db');

module.exports = {
    name: Events.GuildMemberUpdate,
    async execute(oldMember, newMember) {
        if (!oldMember.premiumSince && newMember.premiumSince) {
            let data = await new Promise((resolve, reject) => {
                db.get('SELECT value FROM gestion WHERE id = ?', [newMember.client.user.id], (err, row) => {
                    if (err) {
                        console.error(err.message);
                        reject(err);
                    }
                    resolve(row ? JSON.parse(row.value) : {});
                });
            });

            const boostlogChannelId = data[newMember.guild.id]?.boostlog;
            if (boostlogChannelId) {
                const boostlogChannel = newMember.guild.channels.cache.get(boostlogChannelId);
                if (boostlogChannel) {
                    const embed = new EmbedBuilder()
                        .setColor('#0099ff')
                        .setTitle('Nouveau booster')
                        .setDescription(`${newMember.user.tag} a commencé à booster le serveur!`)
                        .setTimestamp();

                    boostlogChannel.send({ embeds: [embed] });
                }
            }
        }
        console.log(newMember.premiumSince)
        if (oldMember.premiumSince && !newMember.premiumSince) {
            let data = await new Promise((resolve, reject) => {
                db.get('SELECT value FROM gestion WHERE id = ?', [newMember.client.user.id], (err, row) => {
                    if (err) {
                        console.error(err.message);
                        reject(err);
                    }
                    resolve(row ? JSON.parse(row.value) : {});
                });
            });

            const boostlogChannelId = data[newMember.guild.id]?.boostlog;
            if (boostlogChannelId) {
                const boostlogChannel = newMember.guild.channels.cache.get(boostlogChannelId);
                if (boostlogChannel) {
                    const embed = new EmbedBuilder()
                        .setColor('#0099ff')
                        .setTitle('Booster arrêté')
                        .setDescription(`${newMember.user.tag} a arrêté de booster le serveur.`)
                        .setTimestamp();

                    boostlogChannel.send({ embeds: [embed] });
                }
            }
        }
    },
};