// Insert the reaction role info into the database
        db.run(
            'INSERT INTO role_reactions (messageId, channelId, roleId) VALUES (?, ?, ?)',
            [sentMessage.id, interaction.channelId, roleId],
            (err) => {
                if (err) {
                    console.error('Error inserting data into the database:', err);
                    return;
                }
                console.log(`Role reaction button added for the ${role.name} role!`);
            }
        );

        // listener for button interactions
        addReactRoleListener(client);
    }

        // Insert the reaction role info into the database
        db.run(
            'INSERT INTO role_reactions (messageId, channelId, roleId) VALUES (?, ?, ?)',
            [sentMessage.id, interaction.channelId, roleId],
            (err) => {
                if (err) {
                    console.error('Error inserting data into the database:', err);
                    return;
                }
                console.log(`Role reaction button added for the ${role.name} role!`);
            }
        );

        // listener for button interactions
        addReactRoleListener(client);
    }

function addReactRoleListener(client) {
    client.on('interactionCreate', async (interaction) => {
        if (!interaction.isButton()) return;

        const roleId = interaction.customId === 'role_reaction';
        if (!roleId) return;

        const member = interaction.guild.members.cache.get(interaction.user.id);

        if (member) {
            if (member.roles.cache.has(roleId)) {
                await member.roles.remove(roleId);
                await interaction.reply({ content: 'Role removed!', ephemeral: true });
            } else {
                await member.roles.add(roleId);
                await interaction.reply({ content: 'Role added!', ephemeral: true });
            }
        }
    });
}

function addReactRoleListener(client) {
    client.on('interactionCreate', async (interaction) => {
        if (!interaction.isButton()) return;

        const roleId = interaction.customId === 'role_reaction';
        if (!roleId) return;

        const member = interaction.guild.members.cache.get(interaction.user.id);

        if (member) {
            if (member.roles.cache.has(roleId)) {
                await member.roles.remove(roleId);
                await interaction.reply({ content: 'Role removed!', ephemeral: true });
            } else {
                await member.roles.add(roleId);
                await interaction.reply({ content: 'Role added!', ephemeral: true });
            }
        }
    });
}