· 7 years ago · Oct 02, 2018, 10:18 PM
1const Discord = require('discord.js');
2const sql = require('sqlite');
3const settings = require('./botsettings.json');
4const fs = require('fs');
5
6const bot = new Discord.Client();
7const talkedRecently = new Set();
8
9sql.open('./database.sqlite');
10
11// Creating a new collection for all the bot commands
12bot.commands = new Discord.Collection();
13
14// Loading evey command inside cmds folder ( ./cmds )
15fs.readdir("./cmds/", (err, files) => { //Reading commands from path: cmds/
16 if(err) console.error(err);
17
18 let jsFiles = files.filter(f => f.split('.').pop() === "js");
19 if (jsFiles.length <= 0) {
20 console.log("No commands found");
21 return;
22 }
23
24 jsFiles.forEach((f) => {
25 delete require.cache[require.resolve(`./cmds/${f}`)];
26 let props = require(`./cmds/${f}`);
27 console.log(`${f}`);
28 bot.commands.set(props.help.name, props);
29 })
30})
31
32// Bot event listeners
33bot.on('ready', async () => {
34 bot.user.setActivity("domestic abuse", { type: 'WATCHING' });
35
36 // Create server data sql-table if it doesn't exist
37 await sql.all("SELECT count(*) FROM sqlite_master WHERE type = 'table' AND name = 'serverdata'").then(e => {
38 sql.run("CREATE TABLE IF NOT EXISTS serverdata (token TEXT, prefix TEXT, currency TEXT, gambling INTEGER)").then(() => {
39 if (!e[0][Object.keys(e[0])[0]]) {
40 sql.run("INSERT INTO serverdata (token, prefix, currency, gambling) VALUES (?, ?, ?, ?)", [settings.token, '!', '<:cash:494974846455906305>', 423937982211293194]);
41 }
42 }).catch(e => {
43 console.log(e);
44 });
45 });
46});
47
48let prefix = sql.all(`SELECT prefix FROM serverdata`);
49
50........