trunk/commands/notedel.js

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 msg.reply({
                    embeds: [
                        new MessageEmbed()
                        .setDescription('Note has been deleted')
                    ]
                });
            });
        });

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