7a3h5fFD

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';");
7    print('table found')
8    if (!table['count(*)']) {
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);")
11      // Ensure that the "id" row is always unique and indexed.
12      sql.run("CREATE UNIQUE INDEX idx_money_id ON money (id);")
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';");
17    print('items found')
18    if (!itemTable['count(*)']) {
19        items.run("CREATE TABLE items (guildid TEXT, itemname TEXT, emote TEXT, price INTEGER, code TEXT);")
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 = ?");
26    print('client.getScore set')
27    client.setScore = sql.run("INSERT OR REPLACE INTO money (id, user, money) VALUES (@id, @user, @money);");
28    print('client.setScore set')
29    client.makeItem = items.run("INSERT INTO items (guildid, itemname, emote, price, code) VALUES (@guildid, @itemname, @emote, @price, @code);");
30    print('client.makeItem set')
31    client.getItem = items.prepare("SELECT * FROM items WHERE guildid = ? AND itemname = ?")
32    print('client.getItem set')
33    client.getAllItems = items.prepare("SELECT * FROM items AS allItems")
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  });
39
40client.on('guildCreate', guild => {
41    client.user.setActivity('over '+client.guilds.size+' servers! | e!help', { type: 'WATCHING' });
42});