commands/moderation/NotegetCommand.ts

import { BanOptions, CommandInteraction, Guild, GuildMember, Interaction, Message, User } from 'discord.js';
import BaseCommand from '../../utils/structures/BaseCommand';
import DiscordClient from '../../client/Client';
import CommandOptions from '../../types/CommandOptions';
import InteractionOptions from '../../types/InteractionOptions';
import MessageEmbed from '../../client/MessageEmbed';
import getUser from '../../utils/getUser';
import History from '../../automod/History';
import getMember from '../../utils/getMember';
import ms from 'ms';

export default class NotegetCommand extends BaseCommand {
    supportsInteractions: boolean = true;

    constructor() {
        super('noteget', 'moderation', []);
    }

    async run(client: DiscordClient, msg: Message | CommandInteraction, options: CommandOptions | InteractionOptions) {
        if (!options.isInteraction && typeof options.args[0] === 'undefined') {
            await msg.reply({
                embeds: [
                    new MessageEmbed()
                    .setColor('#f14a60')
                    .setDescription(`This command requires at least one argument.`)
                ]
            });

            return;
        }

        let id: string;

        if (options.isInteraction) {
            id = await options.options.getNumber('id')?.toString()!;
        }
        else {
            id = options.args[0];
        }

        await client.db.get("SELECT * FROM notes WHERE id = ? AND guild_id = ?", [[id], msg.guild!.id], async (err: any, data: any) => {
            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	import { BanOptions, CommandInteraction, Guild, GuildMember, Interaction, Message, User } from 'discord.js';
2	import BaseCommand from '../../utils/structures/BaseCommand';
3	import DiscordClient from '../../client/Client';
4	import CommandOptions from '../../types/CommandOptions';
5	import InteractionOptions from '../../types/InteractionOptions';
6	import MessageEmbed from '../../client/MessageEmbed';
7	import getUser from '../../utils/getUser';
8	import History from '../../automod/History';
9	import getMember from '../../utils/getMember';
10	import ms from 'ms';
11
12	export default class NotegetCommand extends BaseCommand {
13	supportsInteractions: boolean = true;
14
15	constructor() {
16	super('noteget', 'moderation', []);
17	}
18
19	async run(client: DiscordClient, msg: Message \| CommandInteraction, options: CommandOptions \| InteractionOptions) {
20	if (!options.isInteraction && typeof options.args[0] === 'undefined') {
21	await msg.reply({
22	embeds: [
23	new MessageEmbed()
24	.setColor('#f14a60')
25	.setDescription(`This command requires at least one argument.`)
26	]
27	});
28
29	return;
30	}
31
32	let id: string;
33
34	if (options.isInteraction) {
35	id = await options.options.getNumber('id')?.toString()!;
36	}
37	else {
38	id = options.args[0];
39	}
40
41	await client.db.get("SELECT * FROM notes WHERE id = ? AND guild_id = ?", [[id], msg.guild!.id], async (err: any, data: any) => {
42	if (err) {
43	console.log(err);
44	}
45
46	if (data === undefined) {
47	await msg.reply({
48	embeds: [
49	new MessageEmbed()
50	.setColor('#f14a60')
51	.setDescription('No note found')
52	]
53	});
54
55	return;
56	}
57
58	let user;
59
60	try {
61	user = await msg.guild!.members.fetch(data.user_id);
62	user = {
63	name: user.user.tag,
64	iconURL: user.displayAvatarURL()
65	};
66	}
67	catch(e) {
68	user = {
69	name: "User " + data.user_id
70	};
71	}
72
73	await msg.reply({
74	embeds: [
75	new MessageEmbed()
76	.setDescription(data.content)
77	.setAuthor(user)
78	.setFields([
79	{
80	name: "ID",
81	value: data.id + ''
82	}
83	])
84	.setTimestamp(new Date(data.date))
85	]
86	});
87	});
88
89	}
90	}