Discord.js sending a message to every channel id stored in the database

Question

I'm trying to make a command that sends a message to every channel id stored using quick.db

db.set(`channelID_${message.guıld.ıd}`, message.channel.id)

so this is how i would store channel id is there a possible way to send a message to every channelID stored using this i have been trying and failed

EDIT: I tried to do it using

const channelIDs = db.all() 
  .filter(e => e.ID.startsWith("channeltest"));

channelIDs.forEach(async (id) => {
  try {
    
    const channel = await client.channels.fetch(id);
    channel.send('test');
  }
});

getting error channel_id: Value "[object Object]" is not snowflake.

maybe store it in an array that you can then run a `forEach` loop over. — Worthy Alpaca, Apr 06 '21 at 15:13
Feel free to post how you tried to send those messages. That `db.set` method looks a bit weird. I think you only set a key and no data. — Zsolt Meszaros, Apr 06 '21 at 15:20

score 0 · Answer 1 · answered Apr 06 '21 at 15:32

First of all I think you have a little typo in your code. You set a key but no data. Here is my correction:

db.set(`channelID_${message.guıld.ıd}`, message.channel.id)

I would recommend using a Array.forEach() loop through your database entries of channel IDs:

array1.forEach(async databaseElement => {
const fetchedChannel = await client.channels.fetch('ENTER CHANNEL ID');
fetchedChannel.send('Test message. It worked!')
});

score 0 · Answer 2 · answered Apr 06 '21 at 16:05

You should probably set an array of channel IDs as Worthy Alpaca mentioned.

db.set(`channelID_${message.guild.id}`, ['859324671543153', '859320171505419'])

You can add new IDs later using the push() method:

db.push(`channelID_${message.guild.id}`, message.channel.id)

Once you've got your db set up, you can get the array of IDs using the .get() method and iterate over it using the .forEach() method. For every channel ID, you can use .fetch() to get the channel. It returns a promise, so you'll need to resolve it first (that's why there is that await keyword). Once you got a channel, you can use the channel.send() method to send a message to that channel:

// get the array of IDs from the database
const channelIDs = db.get(`channelID_${message.guild.id}`);

// for every ID stored, send a message
channelIDs.forEach(async (id) => {
  try {
    // fetch the channel by its ID
    const channel = await client.channels.fetch(id);
    channel.send('Minus officiis dolore eveniet');
  } catch (error) {
    console.log(error);
  }
});

i get error TypeError: Cannot read property 'forEach' of null i'm editing my question with a way i tried to do and failed — Meme Loke, Apr 06 '21 at 16:42
I'm not sure why you use `db.all()` and also not sure what and how you store in your database. It doesn't look like you store channel IDs in it. — Zsolt Meszaros, Apr 06 '21 at 17:26

Discord.js sending a message to every channel id stored in the database

2 Answers2