Alzalia
Alzalia
PostsComments
DIAdiscord.js - Imagine an app
Created by Alzalia on 8/11/2023 in #djs-questions
Edit a database when mute/warn is over
Oh ok, my bad 😅 Have a nice day, and sorry for the mistake ^^
11 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 8/11/2023 in #djs-questions
Edit a database when mute/warn is over
Okay I'm so sorry to bother you again, but I- I don't understand why that part doesn't work. Basically I try to access my database, well, to analyse it. Except it just... doesn't seem to know it's existence. What I don't understand is that it is used in my first warn/mute command and there is no problem at all, but here it just doesn't want to. My code : 
const Sequelize = require('sequelize');
const { EmbedBuilder } = require('discord.js');

( async () => {
    const now = Date.now();
    const openSanctions = await Sanctions.findAll({ where : {state: "open"}});
    const passedSanctions = openSanctions.map(t => ((t.createdAt + t.duration)<=now) ? t : null);
    
    passedSanctions.forEach(element => {
        salon = client.channels.cache.get('1119652569023791126')
        salon.send(`Case ${element.case_id} \nElement passé à : ${new Date(element.createdAt + element.duration)}`);
    });
})()
const Sequelize = require('sequelize');
const { EmbedBuilder } = require('discord.js');

( async () => {
    const now = Date.now();
    const openSanctions = await Sanctions.findAll({ where : {state: "open"}});
    const passedSanctions = openSanctions.map(t => ((t.createdAt + t.duration)<=now) ? t : null);
    
    passedSanctions.forEach(element => {
        salon = client.channels.cache.get('1119652569023791126')
        salon.send(`Case ${element.case_id} \nElement passé à : ${new Date(element.createdAt + element.duration)}`);
    });
})()
The error I get : 
 const openSanctions = await Sanctions.findAll({ where : {state: "open"}});
                          ^

ReferenceError: Sanctions is not defined
    at /home/ubuntu/discordBot/BeeBot_SourceCode/commands/moderation/autoUnMod.js:6:27
    at Object.<anonymous> (/home/ubuntu/discordBot/BeeBot_SourceCode/commands/moderation/autoUnMod.js:13:3)
    at Module._compile (node:internal/modules/cjs/loader:1218:14)
    at Module._extensions..js (node:internal/modules/cjs/loader:1272:10)
    at Module.load (node:internal/modules/cjs/loader:1081:32)
    at Module._load (node:internal/modules/cjs/loader:922:12)
    at Module.require (node:internal/modules/cjs/loader:1105:19)
    at require (node:internal/modules/cjs/helpers:103:18)
    at Object.<anonymous> (/home/ubuntu/discordBot/BeeBot_SourceCode/deploy-commands-expe.js:21:19)
    at Module._compile (node:internal/modules/cjs/loader:1218:14)

Node.js v18.13.0
 const openSanctions = await Sanctions.findAll({ where : {state: "open"}});
                          ^

ReferenceError: Sanctions is not defined
    at /home/ubuntu/discordBot/BeeBot_SourceCode/commands/moderation/autoUnMod.js:6:27
    at Object.<anonymous> (/home/ubuntu/discordBot/BeeBot_SourceCode/commands/moderation/autoUnMod.js:13:3)
    at Module._compile (node:internal/modules/cjs/loader:1218:14)
    at Module._extensions..js (node:internal/modules/cjs/loader:1272:10)
    at Module.load (node:internal/modules/cjs/loader:1081:32)
    at Module._load (node:internal/modules/cjs/loader:922:12)
    at Module.require (node:internal/modules/cjs/loader:1105:19)
    at require (node:internal/modules/cjs/helpers:103:18)
    at Object.<anonymous> (/home/ubuntu/discordBot/BeeBot_SourceCode/deploy-commands-expe.js:21:19)
    at Module._compile (node:internal/modules/cjs/loader:1218:14)

Node.js v18.13.0
I declared Sanctions globally with global.Sanctions = ... but what I really don't understand is why would it work with my warn/mute command file but not this one ?
11 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 8/11/2023 in #djs-questions
Edit a database when mute/warn is over
okay perfect then, I will make that, thank you very much !
11 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 8/11/2023 in #djs-questions
Edit a database when mute/warn is over
oooh, true true. Is it async ? (I don't have the right word I think but like, if I have two that will end before the end can I make two setTimeout or do I need to make them in order from nearest to furthest ?)
11 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 8/11/2023 in #djs-questions
Edit a database when mute/warn is over
yes but the bigger interval the least precise the durations. If I do it every 5 minutes for example, first on at t0. I mute someone for 5min at t1. When the test happens at t5, there is still 1 minute to go. So it passes. But then, 1 min later... nothing, you need to wait t10 for the next message. Which, I mean, can be okay, but it would be best to have it precisely set... But if you tell me there is no easy other way then nevermind I'll do it that way (thus a cronjob would be the easiest right ?)
11 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 8/11/2023 in #djs-questions
Edit a database when mute/warn is over
(Unless I didn't understand what you meant, I'm quite new with javascript, and thus discord.js and node.js)
11 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 8/11/2023 in #djs-questions
Edit a database when mute/warn is over
But that would need to analyse the database at least every minute wouldn't it ? Which would be quite resourceful ?
11 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 8/11/2023 in #djs-questions
Edit a database when mute/warn is over
Discord.js is 14.12.1 Node.js is 18.13.0
11 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 8/11/2023 in #djs-questions
Edit a database when mute/warn is over
So far, I've tried this (emitter file): 
const { SlashCommandBuilder, PermissionFlagsBits} = require('discord.js');
const Sequelize = require('sequelize');
const EventEmitter = require('events')
const eventEmitter = new EventEmitter()

module.exports = {
    data: new SlashCommandBuilder()
        // ... the commands options
    async execute(interaction) {
         //... Some code that works and isn't relevant
        // Retrieve infos | prepare sanction apply to db
        const case_id = await randomIdGenerator(); (//randomIdGenerator works and is set just before)
        const type = interaction.options.getString('sanction');
        const user_id = interaction.options.getUser('utilisateur').id;
        const duration = (interaction.options.getInteger('durée') != null) ? interaction.options.getInteger('durée') : 60;
        const moderator_id = interaction.user.id;
        const reason = (interaction.options.getString('raison') != null) ? interaction.options.getString('raison') : "Aucune raison spécifiée";
        const state = "open";

        switch(type){
            case "warn":
                //... Warn code
            case "mute":
                //... Warn code
            case "kick":
                //... Kick code
            case "ban":
                //... Ban code
        }


        // Apply the infos to db. It works, Sanctions is set with global.Sanctions in index.js
        try {
            const tag = await Sanctions.create({
                case_id: case_id,
                type: type,
                user_id: user_id,
                duration: duration,
                moderator_id: moderator_id,
                reason: reason,
                state: state,
            });
            eventEmitter.emit('sanctionLevée', { case_id, user_id, duration });
            return interaction.reply(`Tag ${tag.case_id} added by ${tag.moderator_id} at ${tag.createdAt} to ${tag.type} ${tag.user_id} because ${tag.reason} for a time of ${tag.duration}. State : ${tag.state}`);
        }
        catch (error) {
            if (error.name === 'SequelizeUniqueConstraintError') {
                return interaction.reply('That tag already exists.');
            }

            return interaction.reply('Something went wrong with adding a tag. : \n'+error);
        }
    },
};
const { SlashCommandBuilder, PermissionFlagsBits} = require('discord.js');
const Sequelize = require('sequelize');
const EventEmitter = require('events')
const eventEmitter = new EventEmitter()

module.exports = {
    data: new SlashCommandBuilder()
        // ... the commands options
    async execute(interaction) {
         //... Some code that works and isn't relevant
        // Retrieve infos | prepare sanction apply to db
        const case_id = await randomIdGenerator(); (//randomIdGenerator works and is set just before)
        const type = interaction.options.getString('sanction');
        const user_id = interaction.options.getUser('utilisateur').id;
        const duration = (interaction.options.getInteger('durée') != null) ? interaction.options.getInteger('durée') : 60;
        const moderator_id = interaction.user.id;
        const reason = (interaction.options.getString('raison') != null) ? interaction.options.getString('raison') : "Aucune raison spécifiée";
        const state = "open";

        switch(type){
            case "warn":
                //... Warn code
            case "mute":
                //... Warn code
            case "kick":
                //... Kick code
            case "ban":
                //... Ban code
        }


        // Apply the infos to db. It works, Sanctions is set with global.Sanctions in index.js
        try {
            const tag = await Sanctions.create({
                case_id: case_id,
                type: type,
                user_id: user_id,
                duration: duration,
                moderator_id: moderator_id,
                reason: reason,
                state: state,
            });
            eventEmitter.emit('sanctionLevée', { case_id, user_id, duration });
            return interaction.reply(`Tag ${tag.case_id} added by ${tag.moderator_id} at ${tag.createdAt} to ${tag.type} ${tag.user_id} because ${tag.reason} for a time of ${tag.duration}. State : ${tag.state}`);
        }
        catch (error) {
            if (error.name === 'SequelizeUniqueConstraintError') {
                return interaction.reply('That tag already exists.');
            }

            return interaction.reply('Something went wrong with adding a tag. : \n'+error);
        }
    },
};
And the receiver file : 
const cron = require('node-cron');
const EventEmitter = require('events');
const eventEmitter = new EventEmitter();
const Sequelize = require('sequelize');
require('discord.js');

// Écouter l'Ă©vĂ©nement pour la levĂ©e de la sanction
eventEmitter.on('sanctionLevée', ({ case_id, user_id, duration }) => {
try{
  const maintenant = Date.now();
  const tempsDeLevée = maintenant + duration; // Calculer le moment de la levée
  console.log(`Bien reçu l\'emit : ${new Date(tempsDeLevée)} pour lever`);
  // Planifier la levée de la sanction avec la tùche cron
  cron.schedule(new Date(tempsDeLevée), () => {
    client.channels.cache.get('1119652569023791126').send(`Bien enlevé le warn`);
    Sanctions.update({ state: "closed" }, { where: { case_id: case_id } })
  });
} catch(e) {
    console.log(`**Error** :\n\n ${e}`);
    client.channels.cache.get('1119652569023791126').send(`**Error** :\n\n ${e}`);
}
});
const cron = require('node-cron');
const EventEmitter = require('events');
const eventEmitter = new EventEmitter();
const Sequelize = require('sequelize');
require('discord.js');

// Écouter l'Ă©vĂ©nement pour la levĂ©e de la sanction
eventEmitter.on('sanctionLevée', ({ case_id, user_id, duration }) => {
try{
  const maintenant = Date.now();
  const tempsDeLevée = maintenant + duration; // Calculer le moment de la levée
  console.log(`Bien reçu l\'emit : ${new Date(tempsDeLevée)} pour lever`);
  // Planifier la levée de la sanction avec la tùche cron
  cron.schedule(new Date(tempsDeLevée), () => {
    client.channels.cache.get('1119652569023791126').send(`Bien enlevé le warn`);
    Sanctions.update({ state: "closed" }, { where: { case_id: case_id } })
  });
} catch(e) {
    console.log(`**Error** :\n\n ${e}`);
    client.channels.cache.get('1119652569023791126').send(`**Error** :\n\n ${e}`);
}
});
So I just... don't know what's wrong, or what can I do. There is no error message. The database isn't changed neither, so I guess it just never receives the event ? Thank you for your help, if there is any easier way (if this is even a way)...
11 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 7/25/2023 in #djs-questions
Error after following the cooldown guide
well apparently not, thank you, how did I miss that ;-;
6 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 7/25/2023 in #djs-questions
Error after following the cooldown guide
Do you mean in each individual command file ?
6 replies
DIAdiscord.js - Imagine an app
Created by Alzalia on 7/24/2023 in #djs-questions
Keep the bot online
Okay, thank you very much ^^
4 replies