trunk/commands/notedel.js

const History = require("../src/History");
const MessageEmbed = require("../src/MessageEmbed");

module.exports = {
    async handle(msg, cm) {
        if (typeof cm.args[0] === 'undefined') {
            await msg.reply({
                embeds: [
                    new MessageEmbed()
                    .setColor('#f14a60')
                    .setDescription(`This command requires at least one argument.`)
                ]
            });

            return;
        }

        await app.db.get("SELECT * FROM notes WHERE id = ? AND guild_id = ?", [cm.args[0], msg.guild.id], async (err, data) => {
            if (err) {
                console.log(err);
            }

            if (data === undefined) {
                await msg.reply({
                    embeds: [
                        new MessageEmbed()
                        .setColor('#f14a60')
                        .setDescription('No note found')
                    ]
                });

                return;
            }

            await app.db.get('DELETE FROM notes WHERE id = ? AND guild_id = ?', [cm.args[0], msg.guild.id], async (err) => {
                if (err) {
                    console.log(err);
                }

                
                await History.create(user.id, msg.guild, 'notedel', msg.author.id, async (data2) => {
                    await msg.reply({
                        embeds: [
                            new MessageEmbed()
                            .setDescription('Note has been deleted')
                        ]
                    });
                });
            });
        });

    }
};
1	const History = require("../src/History");
2	const MessageEmbed = require("../src/MessageEmbed");
3
4	module.exports = {
5	async handle(msg, cm) {
6	if (typeof cm.args[0] === 'undefined') {
7	await msg.reply({
8	embeds: [
9	new MessageEmbed()
10	.setColor('#f14a60')
11	.setDescription(`This command requires at least one argument.`)
12	]
13	});
14
15	return;
16	}
17
18	await app.db.get("SELECT * FROM notes WHERE id = ? AND guild_id = ?", [cm.args[0], msg.guild.id], async (err, data) => {
19	if (err) {
20	console.log(err);
21	}
22
23	if (data === undefined) {
24	await msg.reply({
25	embeds: [
26	new MessageEmbed()
27	.setColor('#f14a60')
28	.setDescription('No note found')
29	]
30	});
31
32	return;
33	}
34
35	await app.db.get('DELETE FROM notes WHERE id = ? AND guild_id = ?', [cm.args[0], msg.guild.id], async (err) => {
36	if (err) {
37	console.log(err);
38	}
39
40
41	await History.create(user.id, msg.guild, 'notedel', msg.author.id, async (data2) => {
42	await msg.reply({
43	embeds: [
44	new MessageEmbed()
45	.setDescription('Note has been deleted')
46	]
47	});
48	});
49	});
50	});
51
52	}
53	};