bot.js

import './util/globals.js';
import { readdir } from 'node:fs';
import * as Discord from 'discord.js';
import db from './util/database.js';
import Lang from './util/i18n.js';
import Wiki from './util/wiki.js';
import { default as newMessage, defaultSettings, inlineCache, updateInlineLinks } from './util/newMessage.js';
import { breakOnTimeoutPause, allowDelete } from './util/functions.js';
import rcscriptButtons from './functions/rcscript_buttons.js';

const client = new Discord.Client( {
	makeCache: Discord.Options.cacheWithLimits( {
		MessageManager: 100,
		PresenceManager: 0
	} ),
	sweepers: {
		messages: {
			interval: 300,
			lifetime: 300
		}
	},
	allowedMentions: {
		parse: [],
		repliedUser: true
	},
	failIfNotExists: false,
	presence: ( process.env.READONLY ? {
		status: Discord.PresenceUpdateStatus.DoNotDisturb,
		activities: [{
			type: Discord.ActivityType.Custom,
			name: 'READONLY: ' + process.env.prefix + 'test' + ( process.env.SHARD_COUNT > 1 ? ' • Shard: ' + process.env.SHARDS : '' )
		}],
		shardId: process.env.SHARDS
	} : {
		status: Discord.PresenceUpdateStatus.Online,
		activities: [{
			type: Discord.ActivityType.Custom,
			name: process.env.prefix + 'help' + ( process.env.SHARD_COUNT > 1 ? ' • Shard: ' + process.env.SHARDS : '' )
		}],
		shardId: process.env.SHARDS
	} ),
	intents: [
		Discord.GatewayIntentBits.Guilds,
		Discord.GatewayIntentBits.GuildMessages,
		Discord.GatewayIntentBits.GuildMessageReactions,
		//Discord.GatewayIntentBits.GuildIntegrations,
		Discord.GatewayIntentBits.DirectMessages,
		Discord.GatewayIntentBits.DirectMessageReactions,
		Discord.GatewayIntentBits.MessageContent
	],
	partials: [
		Discord.Partials.Channel
	]
} );

var isStop = false;
client.on( Discord.Events.ClientReady, () => {
	console.log( '\n- ' + process.env.SHARDS + ': Successfully logged in as ' + client.user.username + '!\n' );
	client.application.commands.fetch({withLocalizations: true});
} );


String.prototype.isMention = function(guild) {
	var text = this.trim();
	return text === '@' + client.user.username || text === '@' + client.user.displayName || text.replace( /^<@!?(\d+)>$/, '$1' ) === client.user.id || ( guild && text === '@' + guild.members.me.displayName );
};

Discord.Message.prototype.isAdmin = function() {
	return this.inGuild() && this.member && ( this.member.permissions.has(Discord.PermissionFlagsBits.ManageGuild) || ( this.isOwner() && this.evalUsed ) );
};

Discord.Message.prototype.isOwner = function() {
	return process.env.owner.split('|').includes( this.author.id );
};

Discord.Message.prototype.uploadFiles = function() {
	return !this.inGuild() || this.channel.permissionsFor(client.user).has(Discord.PermissionFlagsBits.AttachFiles);
};

String.prototype.replaceSafe = function(pattern, replacement) {
	return this.replace( pattern, ( typeof replacement === 'string' ? replacement.replaceAll( '$', '$$$$' ) : replacement ) );
};

String.prototype.replaceAllSafe = function(pattern, replacement) {
	return this.replaceAll( pattern, ( typeof replacement === 'string' ? replacement.replaceAll( '$', '$$$$' ) : replacement ) );
};

Discord.Message.prototype.reactEmoji = function(name, ignorePause = false) {
	if ( breakOnTimeoutPause(this, ignorePause) ) return Promise.resolve();
	var emoji = ( WB_EMOJI.hasOwnProperty(name) ? WB_EMOJI[name] : name );
	return this.react(emoji).catch( error => {
		if ( error?.code === 10008 ) return; // Unknown Message
		log_error(error);
	} );
};

Discord.MessageReaction.prototype.removeEmoji = function() {
	return this.users.remove().catch( error => {
		if ( error?.code === 10008 ) return; // Unknown Message
		log_error(error);
	} );
};

Discord.Message.prototype.sendChannel = function(message, ignorePause = false) {
	if ( breakOnTimeoutPause(this, ignorePause) ) return Promise.resolve();
	if ( message?.embeds?.length && !message.embeds[0] ) message.embeds = [];
	return this.channel.send( message ).then( msg => {
		allowDelete(msg, this.author.id);
		return msg;
	}, error => {
		log_error(error);
		this.reactEmoji(WB_EMOJI.error);
	} );
};

Discord.Message.prototype.sendChannelError = function(message) {
	if ( breakOnTimeoutPause(this) ) return Promise.resolve();
	if ( message?.embeds?.length && !message.embeds[0] ) message.embeds = [];
	return this.channel.send( message ).then( msg => {
		msg.reactEmoji(WB_EMOJI.error);
		allowDelete(msg, this.author.id);
		return msg;
	}, error => {
		log_error(error);
		this.reactEmoji(WB_EMOJI.error);
	} );
};

Discord.Message.prototype.replyMsg = function(message, ignorePause = false, letDelete = true) {
	if ( breakOnTimeoutPause(this, ignorePause) ) return Promise.resolve();
	if ( message?.embeds?.length && !message.embeds[0] ) message.embeds = [];
	return this.reply( message ).then( msg => {
		if ( letDelete ) allowDelete(msg, this.author.id);
		return msg;
	}, error => {
		log_error(error);
		this.reactEmoji(WB_EMOJI.error);
	} );
};

String.prototype.hasPrefix = function(prefix, flags = '') {
	if ( flags === 'm' ) return this.split('\n').some( line => line.hasPrefix(prefix) );
	let text = this.split(' ')[0].replaceAll( '\u200b', '' ).toLowerCase();
	if ( prefix.endsWith( ' ' ) ) return text === prefix.trim();
	return text.startsWith( prefix );
};

const interaction_commands = {
	/** @type {{[x: string]: function(Discord.AutocompleteInteraction, Lang, Wiki)>}} */
	autocomplete: {},
	/** @type {{[x: string]: function(Discord.ChatInputCommandInteraction, Lang, Wiki)>}} */
	slash: {},
	/** @type {{[x: string]: function(Discord.ButtonInteraction, Lang, Wiki)>}} */
	button: {},
	/** @type {{[x: string]: function(Discord.ModalSubmitInteraction, Lang, Wiki)>}} */
	modal: {},
	/** @type {String[]} */
	allowDelete: []
};
readdir( './interactions', (error, files) => {
	if ( error ) return error;
	files.filter( file => file.endsWith('.js') ).forEach( file => {
		import('./interactions/' + file).then( ({default: command}) => {
			if ( command.hasOwnProperty('autocomplete') ) interaction_commands.autocomplete[command.name] = command.autocomplete;
			if ( command.hasOwnProperty('slash') ) interaction_commands.slash[command.name] = command.slash;
			if ( command.hasOwnProperty('button') ) interaction_commands.button[command.name] = command.button;
			if ( command.hasOwnProperty('modal') ) interaction_commands.modal[command.name] = command.modal;
			if ( command.allowDelete ) interaction_commands.allowDelete.push(command.name);
		} );
	} );
} );
/*
!test eval msg.client.rest.post( Discord.Routes.applicationCommands(msg.client.user.id), {
	body: require('../interactions/commands/inline.json')
} )
*/

/** @type {Map<String, Object>} */
const rowCache = new Map();

client.on( Discord.Events.InteractionCreate, interaction => {
	if ( interaction.channel?.partial ) return interaction.channel.fetch().then( () => {
		return interactionCreate(interaction);
	}, log_error );
	return interactionCreate(interaction);
} );

/**
 * Handle interactions.
 * @param {Discord.Interaction} interaction - The interaction.
 */
function interactionCreate(interaction) {
	if ( breakOnTimeoutPause(interaction) ) return;
	/** @type {function(Discord.Interaction, Lang, Wiki)} */
	var cmd = null;
	interaction.author = ( interaction.guildId || '' ) + ( interaction.inCachedGuild() ? '' : '@' + interaction.user.id );
	if ( interaction.isAutocomplete() ) {
		if ( !interaction_commands.autocomplete.hasOwnProperty(interaction.commandName) ) return;
		cmd = interaction_commands.autocomplete[interaction.commandName];
	}
	else if ( interaction.isChatInputCommand() ) {
		if ( interaction.commandName === 'inline' ) console.log( interaction.author + ': Slash: /' + interaction.commandName );
		else console.log( interaction.author + ': Slash: /' + interaction.commandName + ' ' + interaction.options.data.flatMap( option => {
			return [option, ...( option.options?.flatMap( option => [option, ...( option.options ?? [] )] ) ?? [] )];
		} ).map( option => {
			if ( option.options !== undefined ) return option.name;
			return option.name + ':' + option.value;
		} ).join(' ') );
		if ( !interaction_commands.slash.hasOwnProperty(interaction.commandName) ) return;
		cmd = interaction_commands.slash[interaction.commandName];
	}
	else if ( interaction.isButton() ) {
		if ( interaction.customId !== 'verify_again' ) console.log( interaction.author + ': Button: ' + interaction.customId );
		if ( !interaction_commands.button.hasOwnProperty(interaction.customId) ) {
			if ( interaction.inGuild() && interaction.customId.startsWith( 'rc_' ) ) rcscriptButtons(interaction);
			return;
		}
		cmd = interaction_commands.button[interaction.customId];
	}
	else if ( interaction.isModalSubmit() ) {
		console.log( interaction.author + ': Modal: ' + interaction.customId + ' ' + interaction.fields.components.reduce( (prev, next) => {
			return prev.concat(next.components);
		}, [] ).map( option => {
			return option.customId + ':' + option.value;
		} ).join(' ') );
		if ( !interaction_commands.modal.hasOwnProperty(interaction.customId) ) {
			if ( interaction.inGuild() && interaction.customId.startsWith( 'rc_' ) ) rcscriptButtons(interaction);
			return;
		}
		cmd = interaction_commands.modal[interaction.customId];
	}
	else return;
	if ( !cmd ) return;

	let sqlargs = [];
	if ( interaction.inCachedGuild() ) {
		sqlargs.push(interaction.guildId);
		if ( interaction.channel?.isThread() ) sqlargs.push(interaction.channel.parentId, '#' + interaction.channel.parent?.parentId);
		else sqlargs.push(interaction.channelId, '#' + interaction.channel?.parentId);
	}
	else {
		sqlargs.push('@' + interaction.user.id, interaction.guildId);
		if ( interaction.channel?.isThread() ) sqlargs.push(interaction.guildId + '#' + interaction.channel.parentId);
		else sqlargs.push(interaction.guildId + '#' + interaction.channelId);
	}
	( interaction.isAutocomplete() && rowCache.has(sqlargs.join(' ')) ? Promise.resolve(rowCache.get(sqlargs.join(' '))) : db.query( 'SELECT wiki, lang, desclength, fieldcount, fieldlength, sectionlength, sectiondesclength, whitelist FROM discord WHERE guild = $1 AND (channel = $2 OR channel = $3 OR channel IS NULL) ORDER BY channel DESC NULLS LAST LIMIT 1', sqlargs ).then( ({rows:[row]}) => {
		rowCache.set(sqlargs.join(' '), row);
		return row;
	} ) ).then( row => {
		if ( !row ) {
			interaction.defaultSettings = true;
			if ( !interaction.inCachedGuild() && interaction.isChatInputCommand() ) {
				let lang = new Lang(interaction.locale, 'settings');
				interaction.user.send( {
					content: lang.get('user missing', '`' + process.env.prefix + 'settings lang`', '`' + process.env.prefix + 'settings wiki`', interaction.user.toString()),
					components: ( process.env.dashboard ? [new Discord.ActionRowBuilder().addComponents(
						new Discord.ButtonBuilder().setLabel(lang.get('button')).setEmoji(WB_EMOJI.wikibot).setStyle(Discord.ButtonStyle.Link).setURL(new URL('/settings', process.env.dashboard).href)
					)] : [] ),
					allowedMentions: {users: [interaction.user.id]}
				} ).catch( error => {
					if ( error?.code === 50007 ) return; // CANNOT_MESSAGE_USER
					log_error(error);
				} );
			};
		}
		interaction.embedLimits = {
			descLength: row?.desclength ?? defaultSettings.embedLimits.descLength,
			fieldCount: row?.fieldcount ?? defaultSettings.embedLimits.fieldCount,
			fieldLength: row?.fieldlength ?? defaultSettings.embedLimits.fieldLength,
			sectionLength: row?.sectionlength ?? defaultSettings.embedLimits.sectionLength,
			sectionDescLength: row?.sectiondesclength ?? Math.min(row?.desclength ?? defaultSettings.embedLimits.sectionDescLength, defaultSettings.embedLimits.sectionDescLength)
		};
		interaction.wikiWhitelist = ( interaction.inCachedGuild() || interaction.isAutocomplete() ? row?.whitelist?.split?.('\n') ?? [] : [] );
		return cmd(interaction, new Lang(( row?.lang || interaction.guildLocale || interaction.locale )), new Wiki(row?.wiki));
	}, dberror => {
		console.log( '- Interaction: Error while getting the wiki: ' + dberror );
		if ( interaction.isAutocomplete() ) return;
		return interaction.reply( {
			content: new Lang(( interaction.locale || interaction.guildLocale ), 'general').get('database') + '\n' + process.env.invite,
			flags: Discord.MessageFlags.Ephemeral
		} ).catch(log_error);
	} );
}

client.on( Discord.Events.MessageCreate, msg => {
	if ( msg.channel.partial ) return msg.channel.fetch().then( () => {
		return messageCreate(msg);
	}, log_error );
	return messageCreate(msg);
} );

/**
 * Handle new messages.
 * @param {Discord.Message} msg - The message.
 */
function messageCreate(msg) {
	if ( isStop || !msg.channel.isTextBased() || msg.system || msg.webhookId || msg.author.bot || msg.author.id === msg.client.user.id ) return;
	if ( msg.member?.isCommunicationDisabled() || msg.guild?.members?.me?.isCommunicationDisabled() ) return;
	if ( !msg.content.hasPrefix(( patreonGuildsPrefix.get(msg.guildId) ?? process.env.prefix ), 'm') ) {
		if ( ( msg.content === process.env.prefix + 'help' || msg.content === process.env.prefix + 'test' ) && ( msg.isAdmin() || msg.isOwner() ) ) {
			if ( msg.channel.permissionsFor(msg.client.user)?.has(( msg.channel.isThread() ? Discord.PermissionFlagsBits.SendMessagesInThreads : Discord.PermissionFlagsBits.SendMessages )) ) {
				console.log( msg.guildId + ': ' + msg.content );
				let sqlargs = [msg.guildId];
				if ( msg.channel?.isThread() ) sqlargs.push(msg.channel.parentId, '#' + msg.channel.parent?.parentId);
				else sqlargs.push(msg.channelId, '#' + msg.channel.parentId);
				db.query( 'SELECT lang FROM discord WHERE guild = $1 AND (channel = $2 OR channel = $3 OR channel IS NULL) ORDER BY channel DESC NULLS LAST LIMIT 1', sqlargs ).then( ({rows:[row]}) => {
					msg.replyMsg( new Lang(( row?.lang || msg.guild.preferredLocale ), 'general').get('prefix', patreonGuildsPrefix.get(msg.guildId)), true );
				}, dberror => {
					console.log( '- Error while getting the lang: ' + dberror );
					msg.replyMsg( new Lang(msg.guild.preferredLocale, 'general').get('prefix', patreonGuildsPrefix.get(msg.guildId)), true );
				} );
			}
			return;
		}
		if ( !( msg.content.includes( '[[' ) && msg.content.includes( ']]' ) ) && !( msg.content.includes( '{{' ) && msg.content.includes( '}}' ) ) ) return;
	}
	if ( msg.inGuild() ) {
		let sqlargs = [msg.guildId];
		if ( msg.channel.isThread() ) sqlargs.push(msg.channel.parentId, '#' + msg.channel.parent?.parentId);
		else sqlargs.push(msg.channelId, '#' + msg.channel.parentId);
		var missing = new Discord.PermissionsBitField([
			( msg.channel.isThread() ? Discord.PermissionFlagsBits.SendMessagesInThreads : Discord.PermissionFlagsBits.SendMessages ),
			Discord.PermissionFlagsBits.AddReactions,
			Discord.PermissionFlagsBits.UseExternalEmojis,
			Discord.PermissionFlagsBits.ReadMessageHistory
		]).remove(msg.channel.permissionsFor(msg.client.user) ?? 0n);
		if ( missing > 0n ) {
			if ( ( msg.isAdmin() || msg.isOwner() ) && msg.content.hasPrefix(( patreonGuildsPrefix.get(msg.guildId) ?? process.env.prefix ), 'm') ) {
				console.log( msg.guildId + ': Missing permissions - ' + missing.toArray().join(', ') );
				if ( !missing.has(Discord.PermissionFlagsBits.SendMessages) && !missing.has(Discord.PermissionFlagsBits.SendMessagesInThreads) ) {
					db.query( 'SELECT lang FROM discord WHERE guild = $1 AND (channel = $2 OR channel = $3 OR channel IS NULL) ORDER BY channel DESC NULLS LAST LIMIT 1', sqlargs ).then( ({rows:[row]}) => {
						return row?.lang;
					}, dberror => {
						console.log( '- Error while getting the lang: ' + dberror );
					} ).then( lang => {
						msg.sendChannel( {
							content: new Lang(( lang || msg.guild.preferredLocale ), 'general').get('missingperm') + ' `' + missing.toArray().join('`, `') + '`',
							reply: ( missing.has(Discord.PermissionFlagsBits.ReadMessageHistory) ? undefined : {messageReference: msg.id} )
						}, true );
					} );
				}
			}
			return;
		}
		db.query( 'SELECT wiki, lang, role, inline, desclength, fieldcount, fieldlength, sectionlength, sectiondesclength, whitelist, (SELECT array_agg(ARRAY[prefixchar, prefixwiki] ORDER BY prefixchar) FROM subprefix WHERE guild = $1) AS subprefixes FROM discord WHERE guild = $1 AND (channel = $2 OR channel = $3 OR channel IS NULL) ORDER BY channel DESC NULLS LAST LIMIT 1', sqlargs ).then( ({rows:[row]}) => {
			if ( row ) {
				if ( msg.guild.roles.cache.has(row.role) && msg.guild.roles.cache.get(row.role).comparePositionTo(msg.member.roles.highest) > 0 && !msg.isAdmin() ) {
					msg.onlyVerifyCommand = true;
				}
				let subprefixes = ( row.subprefixes?.length ? new Map(row.subprefixes) : undefined );
				let embedLimits = {
					descLength: row.desclength ?? defaultSettings.embedLimits.descLength,
					fieldCount: row.fieldcount ?? defaultSettings.embedLimits.fieldCount,
					fieldLength: row.fieldlength ?? defaultSettings.embedLimits.fieldLength,
					sectionLength: row.sectionlength ?? defaultSettings.embedLimits.sectionLength,
					sectionDescLength: row.sectiondesclength ?? Math.min(row.desclength ?? defaultSettings.embedLimits.sectionDescLength, defaultSettings.embedLimits.sectionDescLength)
				};
				let wikiWhitelist = row.whitelist?.split?.('\n') ?? [];
				newMessage(msg, new Lang(row.lang), row.wiki, embedLimits, patreonGuildsPrefix.get(msg.guildId), row.inline, subprefixes, wikiWhitelist);
			}
			else {
				msg.defaultSettings = true;
				newMessage(msg, new Lang(msg.guild.preferredLocale));
			}
		}, dberror => {
			console.log( '- Error while getting the wiki: ' + dberror );
			msg.sendChannel( new Lang(msg.guild.preferredLocale, 'general').get('database') + '\n' + process.env.invite, true );
		} );
	}
	else db.query( 'SELECT wiki, lang, desclength, fieldcount, fieldlength, sectionlength, sectiondesclength FROM discord WHERE guild = $1 AND channel IS NULL ORDER BY channel DESC NULLS LAST LIMIT 1', ['@' + msg.author.id] ).then( ({rows:[row]}) => {
		if ( !row ) msg.defaultSettings = true;
		let embedLimits = {
			descLength: row?.desclength ?? defaultSettings.embedLimits.descLength,
			fieldCount: row?.fieldcount ?? defaultSettings.embedLimits.fieldCount,
			fieldLength: row?.fieldlength ?? defaultSettings.embedLimits.fieldLength,
			sectionLength: row?.sectionlength ?? defaultSettings.embedLimits.sectionLength,
			sectionDescLength: row?.sectiondesclength ?? Math.min(row?.desclength ?? defaultSettings.embedLimits.sectionDescLength, defaultSettings.embedLimits.sectionDescLength)
		};
		newMessage(msg, new Lang(row?.lang), row?.wiki, embedLimits);
	}, dberror => {
		console.log( '- Error while getting the wiki: ' + dberror );
		msg.sendChannel( new Lang(defaultSettings.lang, 'general').get('database') + '\n' + process.env.invite, true );
	} );
};

client.on( Discord.Events.MessageUpdate, (oldmsg, msg) => {
	if ( oldmsg.content === msg.content ) return;
	if ( !inlineCache.has(msg) ) return;
	if ( msg.channel.partial ) return msg.channel.fetch().then( () => {
		return messageUpdate(msg);
	}, log_error );
	return messageUpdate(msg);
} );

/**
 * Handle message updates.
 * @param {Discord.Message} msg - The message.
 */
function messageUpdate(msg) {
	if ( isStop || !msg.channel.isTextBased() || msg.system || msg.webhookId || msg.author.bot || msg.author.id === msg.client.user.id ) return;
	if ( msg.member?.isCommunicationDisabled() || msg.guild?.members?.me?.isCommunicationDisabled() ) return;
	if ( msg.inGuild() ) {
		let sqlargs = [msg.guildId];
		if ( msg.channel.isThread() ) sqlargs.push(msg.channel.parentId, '#' + msg.channel.parent?.parentId);
		else sqlargs.push(msg.channelId, '#' + msg.channel.parentId);
		var missing = new Discord.PermissionsBitField([
			( msg.channel.isThread() ? Discord.PermissionFlagsBits.SendMessagesInThreads : Discord.PermissionFlagsBits.SendMessages ),
			Discord.PermissionFlagsBits.ReadMessageHistory
		]).remove(msg.channel.permissionsFor(msg.client.user) ?? 0n);
		if ( missing > 0n ) {
			if ( msg.isAdmin() || msg.isOwner() ) {
				console.log( msg.guildId + ': Missing permissions - ' + missing.toArray().join(', ') );
			}
			return;
		}
		db.query( 'SELECT wiki, lang, role, inline, desclength, fieldcount, fieldlength, sectionlength, sectiondesclength, whitelist, (SELECT array_agg(ARRAY[prefixchar, prefixwiki] ORDER BY prefixchar) FROM subprefix WHERE guild = $1) AS subprefixes FROM discord WHERE guild = $1 AND (channel = $2 OR channel = $3 OR channel IS NULL) ORDER BY channel DESC NULLS LAST LIMIT 1', sqlargs ).then( ({rows:[row]}) => {
			if ( row ) {
				if ( msg.guild.roles.cache.has(row.role) && msg.guild.roles.cache.get(row.role).comparePositionTo(msg.member.roles.highest) > 0 && !msg.isAdmin() ) {
					msg.onlyVerifyCommand = true;
				}
				let subprefixes = ( row.subprefixes?.length ? new Map(row.subprefixes) : undefined );
				let embedLimits = {
					descLength: row.desclength ?? defaultSettings.embedLimits.descLength,
					fieldCount: row.fieldcount ?? defaultSettings.embedLimits.fieldCount,
					fieldLength: row.fieldlength ?? defaultSettings.embedLimits.fieldLength,
					sectionLength: row.sectionlength ?? defaultSettings.embedLimits.sectionLength,
					sectionDescLength: row.sectiondesclength ?? Math.min(row.desclength ?? defaultSettings.embedLimits.sectionDescLength, defaultSettings.embedLimits.sectionDescLength)
				};
				let wikiWhitelist = row.whitelist?.split?.('\n') ?? [];
				updateInlineLinks(msg, new Lang(row.lang), row.wiki, embedLimits, patreonGuildsPrefix.get(msg.guildId), row.inline, subprefixes, wikiWhitelist);
			}
			else {
				msg.defaultSettings = true;
				updateInlineLinks(msg, new Lang(msg.guild.preferredLocale));
			}
		}, dberror => {
			console.log( '- Error while getting the wiki: ' + dberror );
		} );
	}
	else db.query( 'SELECT wiki, lang, desclength, fieldcount, fieldlength, sectionlength, sectiondesclength FROM discord WHERE guild = $1 AND channel IS NULL ORDER BY channel DESC NULLS LAST LIMIT 1', ['@' + msg.author.id] ).then( ({rows:[row]}) => {
		if ( !row ) msg.defaultSettings = true;
		let embedLimits = {
			descLength: row?.desclength ?? defaultSettings.embedLimits.descLength,
			fieldCount: row?.fieldcount ?? defaultSettings.embedLimits.fieldCount,
			fieldLength: row?.fieldlength ?? defaultSettings.embedLimits.fieldLength,
			sectionLength: row?.sectionlength ?? defaultSettings.embedLimits.sectionLength,
			sectionDescLength: row?.sectiondesclength ?? Math.min(row?.desclength ?? defaultSettings.embedLimits.sectionDescLength, defaultSettings.embedLimits.sectionDescLength)
		};
		updateInlineLinks(msg, new Lang(row?.lang), row?.wiki, embedLimits);
	}, dberror => {
		console.log( '- Error while getting the wiki: ' + dberror );
	} );
};

client.on( Discord.Events.MessageReactionAdd, (reaction, user) => {
	var msg = reaction.message;
	if ( msg.applicationId !== client.user.id || !msg.interactionMetadata ) return;
	let command = msg.client.application.commands.cache.get(msg.interactionMetadata.id);
	if ( !interaction_commands.allowDelete.includes(command?.name) ) return;
	if ( reaction.emoji.name !== WB_EMOJI.delete || msg.interactionMetadata.user.id !== user.id ) return;
	msg.delete().catch(log_error);
} );


const joinGuilds = new Map();
const leftGuilds = new Map();

client.on( Discord.Events.GuildCreate, guild => {
	console.log( '- ' + guild.id + ': I\'ve been added to a server.' );
	joinGuilds.set(guild.id, setTimeout(removeSettings, 300_000, guild.id).unref());
	if ( leftGuilds.has(guild.id) ) {
		clearTimeout(leftGuilds.get(guild.id));
		leftGuilds.delete(guild.id);
	}
} );

client.on( Discord.Events.GuildDelete, guild => {
	if ( !guild.available ) {
		console.log( '- ' + guild.id + ': This server isn\'t responding.' );
		return;
	}
	console.log( '- ' + guild.id + ': I\'ve been removed from a server.' );
	leftGuilds.set(guild.id, setTimeout(removeSettings, 300_000, guild.id).unref());
	if ( joinGuilds.has(guild.id) ) {
		clearTimeout(joinGuilds.get(guild.id));
		joinGuilds.delete(guild.id);
	}
} );

function removeSettings(guild) {
	if ( leftGuilds.has(guild) ) {
		leftGuilds.delete(guild);
		if ( client.guilds.cache.has(guild) ) return;
		db.query( 'DELETE FROM discord WHERE main = $1', [guild] ).then( ({rowCount}) => {
			if ( patreonGuildsPrefix.has(guild) ) client.shard.broadcastEval( (discordClient, evalData) => {
				globalThis.patreonGuildsPrefix.delete(evalData);
			}, {context: guild} );
			if ( rowCount ) console.log( '- ' + guild + ': Settings successfully removed.' );
		}, dberror => {
			console.log( '- ' + guild + ': Error while removing the settings: ' + dberror );
		} );
	}
	if ( joinGuilds.has(guild) ) {
		joinGuilds.delete(guild);
		if ( !client.guilds.cache.has(guild) ) return;
		db.query( 'DELETE FROM discord WHERE guild LIKE $1 AND channel = $2', ['@%', guild] ).then( ({rowCount}) => {
			if ( rowCount ) console.log( '- ' + guild + ': User settings successfully removed.' );
		}, dberror => {
			console.log( '- ' + guild + ': Error while removing the user settings: ' + dberror );
		} );
	}
}


client.on( Discord.Events.Error, error => log_error(error, true) );
client.on( Discord.Events.Warn, warning => log_warning(warning, false) );

client.login(process.env.token).catch( error => {
	log_error(error, true, 'LOGIN-');
	return client.login(process.env.token).catch( error => {
		log_error(error, true, 'LOGIN-');
		return client.login(process.env.token).catch( error => {
			log_error(error, true, 'LOGIN-');
			process.exit(1);
		} );
	} );
} );

if ( isDebug ) client.on( Discord.Events.Debug, debug => {
	if ( isDebug ) console.log( '- ' + process.env.SHARDS + ': Debug: ' + debug );
} );


process.on( 'warning', warning => {
	if ( warning?.name === 'ExperimentalWarning' ) return;
	log_warning(warning, false);
} );

/**
 * End the process gracefully.
 * @param {NodeJS.Signals} signal - The signal received.
 */
function graceful(signal) {
	isStop = true;
	console.log( '- ' + process.env.SHARDS + ': ' + signal + ': Preparing to close...' );
	setTimeout( () => {
		console.log( '- ' + process.env.SHARDS + ': ' + signal + ': Destroying client...' );
		client.destroy();
		db.end().then( () => {
			console.log( '- ' + process.env.SHARDS + ': ' + signal + ': Closed the database connection.' );
			process.exit(0);
		}, dberror => {
			console.log( '- ' + process.env.SHARDS + ': ' + signal + ': Error while closing the database connection: ' + dberror );
		} );
	}, 1_000 ).unref();
}

process.once( 'SIGINT', graceful );
process.once( 'SIGTERM', graceful );