functions.js

const sqlite3 = require('sqlite3').verbose();
const db = new sqlite3.Database('./servers.sqlite');
const fs = require("fs");
var afkJson = fs.readFileSync("./afk.json"),
	afk = JSON.parse(afkJson)
module.exports = (bot) => {
	bot.syncServers = function() {
		db.serialize(function() {
			db.run(`CREATE TABLE IF NOT EXISTS servers (
				id VARCHAR(25) PRIMARY KEY, 
				name VARCHAR(100), 
				prefix VARCHAR(10),
				welcomeMessagesEnabled BOOLEAN,
				leaveMessagesEnabled BOOLEAN,
				welcomeMessagesChannel VARCHAR(25),
				leaveMessagesChannel VARCHAR(25),
				leaveMessagesAutoDelete BOOLEAN,
				logsChannel VARCHAR(25), 
				dadJokesEnabled BOOLEAN,
				dadJokesJail VARCHAR(25),
				hallOfFameEnabled BOOLEAN,
				hallOfFameEmote VARCHAR(25),
				hallOfFameLimit VARCHAR(2),
				hallOfFameChannel VARCHAR(25),
				hallOfFameOverrideEnabled BOOLEAN,
				hallOfFameOverrideEmote VARCHAR(25),
				modMailChannel VARCHAR(25),
				welcomeMessage VARCHAR(300),
				leaveMessage VARHCHAR(300),
				securityEnabled BOOLEAN,
				securityChannel VARCHAR(25),
				securityPhrase VARCHAR(300),
				securityNickCheck BOOLEAN,
				securityNickFormat VARCHAR(32),
				securityJoinMessage VARCHAR(1000),
				securityRole VARCHAR(25),
				securityPinMessage VARCHAR(1000),
				giveme VARCHAR(2000)
				)`);
			bot.guilds.forEach(guild => {
				db.run(`INSERT OR IGNORE INTO servers VALUES (
					"${guild.id}",		 
					"${guild.name}", 
					"${bot.config.prefix}",
					0,
					0,
					"none",
					"none",
					0,
					"logs",
					1,
					"none",
					0,
					"none",
					"3",
					"none",
					0,
					"none",
					"none",
					"Hello {user}! Welcome to {guild}!",
					"{user} has left the server! :cry:",
					0,
					"new-members",
					"I have read the rules and regulations",
					0,
					"none",
					"Welcome {user}! Please read the rules and then enter the passphrase to enter the rest of the server! Thank you!",
					"members",
					"Welcome to {guild}! Please read the rules and then enter the passphrase to enter the rest of the server!",
					"none")`
				);
			});
		});
		bot.log("log", "Servers synced.", 'BOT  ')
	};
	bot.removeServer = function(guild) {
		db.run(`DELETE FROM servers WHERE id = ${guild.id}`);
		bot.log('log', guild.name + " successfully removed from the database!", 'BOT  ');
	};
	bot.addServer = function(guild) {
		db.run(`INSERT OR IGNORE INTO servers VALUES (
			"${guild.id}",		 
			"${guild.name}", 
			"${bot.config.prefix}",
			0,
			0,
			"none",
			"none",
			0, 
			"logs",
			1,
			"none",
			0,
			"none",
			"3",
			"none",
			0,
			"none",
			"none",
			"Hello {user}! Welcome to {guild}!",
			"{user} has left the server! :cry:",
			0,
			"new-members",
			"I have read the rules and regulations",
			0,
			"none",
			"Welcome {user}! Please read the rules and then enter the passphrase to enter the rest of the server! Thank you!",
			"members",
			"Welcome to {guild}! Please read the rules and then enter the passphrase to enter the rest of the server!",
			"none"
		)`);
		bot.log('log', guild.name + " successfully inserted into the database!");
	};
	bot.setSetting = function(setting, newSetting, message) {
		return new Promise(
			function(resolve, reject) {
				db.run(`UPDATE servers SET ${setting} = "${newSetting}" WHERE id = "${message.guild.id}"`), resolve(newSetting);
			});
	};
	bot.processMessage = function(message) {
		if (message.author.bot) return;
		x = message.content.toLowerCase();
	if (x.startsWith("im ") || x.startsWith("i'm ") || x.startsWith("i am ")) {
		bot.getSetting('dadJokesEnabled', message.guild).then(setting => {
			if (setting == '0') return;
			bot.getSetting('dadJokesJail', message.guild).then(chan => {
				jail = message.guild.channels.find(c => c.name == chan);
				if (!jail) {
					if (message.author.id == '226999841358610432') {
						const args = message.content.split(/\s+/g);
						const cmd = bot.commands.get('love');
						cmd.run(bot, message, args);
					} else {
						if (x.startsWith('i am ')) {
							joke1 = message.cleanContent.split(" ").slice(2);
						} else {
							joke1 = message.cleanContent.split(" ").slice(1);
						}
						if (joke1.length > 5) return;
						let joke = joke1.join(" ");
						message.channel.send(`Hi **${joke}**, I'm ${message.guild.me.displayName}! :heart:`);
						bot.log("log", `${message.guild.name}/#${message.channel.name}: ${message.author.username} (${message.author.id}) made a dad joke: ${joke}`, "DAD  ");
					};
				} else {
					if (message.channel == jail) {
						if (message.author.id == '226999841358610432') {
							const args = message.content.split(/\s+/g);
							const cmd = bot.commands.get('love');
							cmd.run(bot, message, args);
						} else {
							if (x.startsWith('i am ')) {
								joke1 = message.cleanContent.split(" ").slice(2);
							} else {
								joke1 = message.cleanContent.split(" ").slice(1);
							}
							if (joke1.length > 5) return;
							let joke = joke1.join(" ");
							message.channel.send(`Hi **${joke}**, I'm ${message.guild.me.displayName}! :heart:`);
							bot.log("log", `${message.guild.name}/#${message.channel.name}: ${message.author.username} (${message.author.id}) made a dad joke: ${joke}`, "DAD  ");
						};
					}
				}
			})
		})
	};
		if (message.isMentioned(bot.user)) {
			if (message.content.toLowerCase().includes("what's your prefix") || message.content.toLowerCase().includes("whats your prefix")) {
				this.getSetting('prefix', message.guild).then(prefix => {
					message.reply("my prefix for this server is `" + prefix + "`!")
				})
			}
			if (message.content.toLowerCase().includes("resetprefix") && message.member.hasPermission("ADMINISTRATOR")) {
				bot.setPrefix(config.prefix, message.guild);
				message.reply('I have reset this server\'s prefix to ``' + config.prefix + '``!')
			}
			if (message.content.toLowerCase().includes("what are your pronouns?") || message.content.toLowerCase().includes("what pronouns do you use?")) {
				this.getSetting('prefix', message.guild).then(prefix => {
					message.channel.send(`My creator calls me by she/her pronouns, but you can call me by whatever pronouns you like! However, I tend to only respond to valid commands starting with my prefix, \`${prefix}\`!`)
				})
			}
		}
		this.getSetting('prefix', message.guild).then(prefix => {
			if (message.content.startsWith(prefix)) {
				try {
					args = message.content.split(/\s+/g)
					message.content = message.content.substring(message.content.indexOf(" ") + 1, message.content.length) || null
					var command = args.shift().slice(prefix.length).toLowerCase()
					var cmd = bot.commands.get(command) || bot.commands.get(bot.aliases.get(command))
					if (!cmd) return;
					else if (!message.guild.me.hasPermission(cmd.conf.botPerms)) return message.channel.send(`Sorry, I don't have a permission I need to run that command!\n Required Permissions: ${cmd.conf.botPerms}`)
					else if (!message.member.hasPermission(cmd.conf.memberPerms)) return message.channel.send(`You do not have the permissions to run this command!\nRequired Permissions: ${cmd.conf.memberPerms}`)
					else if (cmd.conf.enabled) {
						bot.log('log', `${message.guild.name} #${message.channel.name} - ${message.author.username} (${message.author.id}) ran command ${cmd.help.name} - ${message.cleanContent}`, 'CMD  ')
						try {
							cmd.run(bot, message, args);
						} catch (err) {
							message.channel.send("Oh no! We encountered an error:\n```" + err.stack + "```")
						}
					}
				} catch (err) {
					message.channel.send("Oh no! We encountered an error:\n```" + err.stack + "```");
					bot.error(err.stack);
				}
			}
		})
	}
	bot.getSetting = function(input, g) {
		return new Promise(
			function(resolve, reject) {
				db.all(`SELECT * FROM servers WHERE id = "${g.id}"`, function(err, rows) {
					if (err || !rows[0])
						reject(err);
					else
						resolve(rows[0][input])
				});
			}
		)
	};
	bot.getUser = function(input, message) {
		const regex = /<@!?(\d+)>/;
		if ((m = regex.exec(input)) !== null) {
			//return bot.users.get(m);
			return m;
		} else if (bot.users.get(input)) {
			//return bot.users.get(input);
		} else if (bot.users.find(u => u.tag == input)) {
			//return bot.users.find(u => u.tag == input);
		}
	}
	bot.log = (type, message, title) => {
		if (!title) title = "LOG";
		console.log(`${type} | ${title} | ${message}`);
	};
	bot.awaitReply = async (message, question, limit = 60000) => {
		const filter = m => m.author.id;
		await message.channel.send(question);
		try {
			const collected = await message.channel.awaitMessages(filter, {
				max: 1,
				time: limit,
				errors: ['time']
			});
			return collected.first().content;
		} catch (e) {
			return false;
		}
	};
	bot.clean = async (bot, text) => {
		if (text && text.constructor.name == 'Promise') text = await text;
		if (typeof evaled !== 'string') text = require('util').inspect(text, {
			depth: 0
		});
		text = text.replace(/`/g, "`" + String.fromCharCode(8203)).replace(/@/g, "@" + String.fromCharCode(8203)).replace(bot.token, "mfa.VkO_2G4Qv3T--NO--lWetW_tjND--TOKEN--QFTm6YGtzq9PH--4U--tG0");
		return text;
	};
	bot.enabled = function(command, guild) {
		return true;
	};
	global.wait = require('util').promisify(setTimeout);
	global.range = (count, start = 0) => {
		const myArr = [];
		for (var i = 0; i < count; i++) {
			myArr[i] = i + start;
		}
		return myArr;
	};
	process.on('uncaughtException', (err) => {
		let errorMessage = err.stack.replace(new RegExp(`${__dirname}\/`, 'g'), './');
		console.error("Uncaught Exception: ", errorMessage);
	});
	process.on("unhandledRejection", err => {
		console.error("Uncaught Promise Error: ", err);
	});
};