client.on("ready", () => {
    console.log('Starting EcoBot..')
    client.user.setActivity('Starting Bot..', { type: 'PLAYING' });
    // Check if the table "points" exists.
    print('start')
    const table = sql.prepare("SELECT count(*) FROM sqlite_master WHERE type='table' AND name = 'money';", error);
    print('table found')
    if (!table['count(*)'], error) {
      // If the table isn't there, create it and setup the database correctly.
      sql.run("CREATE TABLE money (id TEXT PRIMARY KEY, user TEXT, money INTEGER);", error)
      // Ensure that the "id" row is always unique and indexed.
      sql.run("CREATE UNIQUE INDEX idx_money_id ON money (id);", error)
      print('table wasnt found, made a new one')
    }

    const itemTable = items.prepare("SELECT count(*) FROM sqlite_master WHERE type='table' AND name = 'items';", error);
    print('items found')
    if (!itemTable['count(*)'], error) {
        items.run("CREATE TABLE items (guildid TEXT, itemname TEXT, emote TEXT, price INTEGER, code TEXT);", error)
        // items.run("CREATE UNIQUE INDEX idx_items_id ON items (guildid);");
        print('items not found, made table')
    }

    // And then we have two prepared statements to get and set the score data.
    client.getScore = sql.prepare("SELECT * FROM money WHERE user = ?", error);
    print('client.getScore set')
    client.setScore = sql.run("INSERT OR REPLACE INTO money (id, user, money) VALUES (@id, @user, @money);", error);
    print('client.setScore set')
    client.makeItem = items.run("INSERT INTO items (guildid, itemname, emote, price, code) VALUES (@guildid, @itemname, @emote, @price, @code);", error);
    print('client.makeItem set')
    client.getItem = items.prepare("SELECT * FROM items WHERE guildid = ? AND itemname = ?", error)
    print('client.getItem set')
    client.getAllItems = items.prepare("SELECT * FROM items AS allItems", error)
    print('client.getAllItems set')
    console.log('Started! Logged in as '+client.user.tag)
    client.user.setActivity('over '+client.guilds.size+' servers! | e!help', { type: 'WATCHING' });
    console.log('Currently in '+client.guilds.size+' servers!')
  });