const row = new ActionRowBuilder()
  .addComponents(
          new ButtonBuilder()
          .setCustomId('accept')
          .setLabel('Accept')
          .setEmoji(':white_check_mark:')
          .setStyle('3'),
  
          new ButtonBuilder()
          .setCustomId('reject')
          .setLabel('Reject')
          .setEmoji(':x:')
          .setStyle('1'),
  );
     interaction.editReply({ embeds: [exampleEmbed1], components: [row] }).then((msg) => {
     const collector = interaction.channel.createMessageComponentCollector({ time: 100000 });

     collector.on("collect", async (i) => {
     //if accpted
     if(i.customId === "accept"){
     const memberid = interaction.member.user.id; //get member id
     const messageID = msg.id; //message id
     //insert data in the db
     var sql1 = "INSERT INTO `screenshot` (`name`, `url`, `status`, `messageid`, `memebrid`) VALUES ('"+username+"','"+ imageurl.url+"', '1', '"+ messageID+"', '"+ memberid+"')";
     con.query(sql1, function (err, result){
     if(err) throw err;
     //edit reply 
     const exampleEmbed2 = new EmbedBuilder()
    .setDescription("``<<<Your ScreenShot has been Accepted \n\n Thank You! >>>``")
    .setThumbnail(`${imageurl.url}`)
    .setImage(`${imageurl.url}`)
    .setColor("#00b0f4")
  .setTimestamp();
     interaction.editReply({ embeds: [exampleEmbed2], fetchReply: true }) //edit reply    
     console.log("screenshot Inserted and approved.");
     })
 }
     
     //if rejected
     if(i.customId === "reject"){
     const memberid = interaction.member.user.id; //get member id
     const messageID = msg.id; //message id
     //insert data in the db
     var sql3 = "UPDATE `screenshot` SET `status` = '0' WHERE messageid = '"+messageID+"' && memebrid = '"+ memberid+"' && url = '"+ imageurl.url+"'";
     con.query(sql3, function (err, result){
     if(err) throw err;
     //edit reply 
     const exampleEmbed2 = new EmbedBuilder()
    .setDescription("``<<<Your ScreenShot has been Rejeted \n\n Thank You! >>>``")
    .setThumbnail(`${imageurl.url}`)
    .setImage(`${imageurl.url}`)
    .setColor("#00b0f4")
  .setTimestamp();
     interaction.editReply({ embeds: [exampleEmbed2], fetchReply: true }) //edit reply    
     console.log("screenshot has been Rejectd.");
     })
 
 
 }
     
     
})   
collector.on('end', collected => {
console.log(`Collected ${collected.size} interactions.`);
});