src/utils/setTimeout.ts

import path from "path";
import DiscordClient from "../client/Client";

const timeouts = new Map();

export const runTimeouts = async () => {
    const data = await DiscordClient.client.db.allAsync("SELECT * FROM timeouts");

    // await console.log(data);

    if (data && data.length > 0) {
        console.log('Running timeouts...');
        for await (const row of data) {
            // console.log(row)

            let timeout = await setTimeout(async () => {
                await console.log('TIMEOUT');
                await DiscordClient.client.db.runAsync("DELETE FROM timeouts WHERE id = ?", [row.id]);
                await timeouts.delete(row.id);
                (await import(row.filePath)).default(DiscordClient.client, ...JSON.parse(row.params));
            }, new Date(row.time).getTime() - Date.now());

            await timeouts.set(row.id, {
                row,
                timeout
            });
        }
    }
};

export const setTimeoutv2 = async (file: string, time: number, guild_id: string, cmd: string, ...params: any[]) => {
    await console.log('SETTING');
    await DiscordClient.client.db.allAsync("INSERT INTO timeouts(created_at, filePath, time, params, guild_id, cmd) VALUES(?, ?, ?, ?, ?, ?)", [new Date().toISOString(), path.resolve(__dirname, '../queues', file), new Date(Date.now() + time).toISOString(), JSON.stringify(params), guild_id, cmd]);
    const row = await DiscordClient.client.db.getAsync('SELECT * FROM timeouts ORDER BY id DESC LIMIT 0, 1');

    const timeout = await setTimeout(async () => {
        await console.log('TIMEOUT_SET');
        await DiscordClient.client.db.runAsync("DELETE FROM timeouts WHERE id = ?", [row.id]);
        await timeouts.delete(row.id);      
        (await import(path.resolve(__dirname, '../queues', file))).default(DiscordClient.client, ...params);
    }, time);
    
    const data = {
        row,
        timeout
    };

    await timeouts.set(row.id, data);
    return data;
};

export const clearTimeoutv2 = async ({ row, timeout }: any) => {
    await clearTimeout(timeout);
    await DiscordClient.client.db.runAsync("DELETE FROM timeouts WHERE id = ?", [row.id]);
    await timeouts.delete(row.id);
}; 

export const getTimeout = (id: string | number) => timeouts.get(id);

export const hasTimeout = (id: string | number) => timeouts.has(id);

export const getTimeouts = () => timeouts;
1	import path from "path";
2	import DiscordClient from "../client/Client";
3
4	const timeouts = new Map();
5
6	export const runTimeouts = async () => {
7	const data = await DiscordClient.client.db.allAsync("SELECT * FROM timeouts");
8
9	// await console.log(data);
10
11	if (data && data.length > 0) {
12	console.log('Running timeouts...');
13	for await (const row of data) {
14	// console.log(row)
15
16	let timeout = await setTimeout(async () => {
17	await console.log('TIMEOUT');
18	await DiscordClient.client.db.runAsync("DELETE FROM timeouts WHERE id = ?", [row.id]);
19	await timeouts.delete(row.id);
20	(await import(row.filePath)).default(DiscordClient.client, ...JSON.parse(row.params));
21	}, new Date(row.time).getTime() - Date.now());
22
23	await timeouts.set(row.id, {
24	row,
25	timeout
26	});
27	}
28	}
29	};
30
31	export const setTimeoutv2 = async (file: string, time: number, guild_id: string, cmd: string, ...params: any[]) => {
32	await console.log('SETTING');
33	await DiscordClient.client.db.allAsync("INSERT INTO timeouts(created_at, filePath, time, params, guild_id, cmd) VALUES(?, ?, ?, ?, ?, ?)", [new Date().toISOString(), path.resolve(__dirname, '../queues', file), new Date(Date.now() + time).toISOString(), JSON.stringify(params), guild_id, cmd]);
34	const row = await DiscordClient.client.db.getAsync('SELECT * FROM timeouts ORDER BY id DESC LIMIT 0, 1');
35
36	const timeout = await setTimeout(async () => {
37	await console.log('TIMEOUT_SET');
38	await DiscordClient.client.db.runAsync("DELETE FROM timeouts WHERE id = ?", [row.id]);
39	await timeouts.delete(row.id);
40	(await import(path.resolve(__dirname, '../queues', file))).default(DiscordClient.client, ...params);
41	}, time);
42
43	const data = {
44	row,
45	timeout
46	};
47
48	await timeouts.set(row.id, data);
49	return data;
50	};
51
52	export const clearTimeoutv2 = async ({ row, timeout }: any) => {
53	await clearTimeout(timeout);
54	await DiscordClient.client.db.runAsync("DELETE FROM timeouts WHERE id = ?", [row.id]);
55	await timeouts.delete(row.id);
56	};
57
58	export const getTimeout = (id: string \| number) => timeouts.get(id);
59
60	export const hasTimeout = (id: string \| number) => timeouts.has(id);
61
62	export const getTimeouts = () => timeouts;