trunk/commands/noteget.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;
            }

            let user;

            try {
                user = await msg.guild.members.fetch(data.user_id);
                user = {
                    name: user.user.tag,
                    iconURL: user.displayAvatarURL()
                };
            }
            catch(e) {
                user = {
                    name: "User " + data.user_id
                };
            }

            await msg.reply({
                embeds: [
                    new MessageEmbed()
                    .setDescription(data.content)
                    .setAuthor(user)
                    .setFields([
                        {
                            name: "ID",
                            value: data.id + ''
                        }
                    ])
                    .setTimestamp(new Date(data.date))
                ]
            });
        });

    }
};
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			let user;
35
36			try {
37			user = await msg.guild.members.fetch(data.user_id);
38			user = {
39			name: user.user.tag,
40			iconURL: user.displayAvatarURL()
41			};
42			}
43			catch(e) {
44			user = {
45			name: "User " + data.user_id
46			};
47			}
48
49			await msg.reply({
50			embeds: [
51			new MessageEmbed()
52			.setDescription(data.content)
53			.setAuthor(user)
54			.setFields([
55			{
56			name: "ID",
57			value: data.id + ''
58			}
59			])
60			.setTimestamp(new Date(data.date))
61			]
62			});
63			});
64
65			}
66			};