qnz9vvPM

1client.on("ready", () => {
2    console.log('Starting EcoBot..')
3    client.user.setActivity('Starting Bot..', { type: 'PLAYING' });
4    // Check if the table "points" exists.
5    print('start')
6    const table = sql.prepare("SELECT count(*) FROM sqlite_master WHERE type='table' AND name = 'money';", error);
7    print('table found')
8    if (!table['count(*)'], error) {
9      // If the table isn't there, create it and setup the database correctly.
10      sql.run("CREATE TABLE money (id TEXT PRIMARY KEY, user TEXT, money INTEGER);", error)
11      // Ensure that the "id" row is always unique and indexed.
12      sql.run("CREATE UNIQUE INDEX idx_money_id ON money (id);", error)
13      print('table wasnt found, made a new one')
14    }
15
16    const itemTable = items.prepare("SELECT count(*) FROM sqlite_master WHERE type='table' AND name = 'items';", error);
17    print('items found')
18    if (!itemTable['count(*)'], error) {
19        items.run("CREATE TABLE items (guildid TEXT, itemname TEXT, emote TEXT, price INTEGER, code TEXT);", error)
20        // items.run("CREATE UNIQUE INDEX idx_items_id ON items (guildid);");
21        print('items not found, made table')
22    }
23  
24    // And then we have two prepared statements to get and set the score data.
25    client.getScore = sql.prepare("SELECT * FROM money WHERE user = ?", error);
26    print('client.getScore set')
27    client.setScore = sql.run("INSERT OR REPLACE INTO money (id, user, money) VALUES (@id, @user, @money);", error);
28    print('client.setScore set')
29    client.makeItem = items.run("INSERT INTO items (guildid, itemname, emote, price, code) VALUES (@guildid, @itemname, @emote, @price, @code);", error);
30    print('client.makeItem set')
31    client.getItem = items.prepare("SELECT * FROM items WHERE guildid = ? AND itemname = ?", error)
32    print('client.getItem set')
33    client.getAllItems = items.prepare("SELECT * FROM items AS allItems", error)
34    print('client.getAllItems set')
35    console.log('Started! Logged in as '+client.user.tag)
36    client.user.setActivity('over '+client.guilds.size+' servers! | e!help', { type: 'WATCHING' });
37    console.log('Currently in '+client.guilds.size+' servers!')
38  });