const Discord = require('discord.js');
const client = new Discord.Client();
const sqlite3 = require('sqlite3').verbose();

let db = new sqlite3.Database('./toots.db');

client.on('ready', () => {
  console.log(`Logged in as ${client.user.tag}!`);
});

client.on('message', msg => {
  if (msg.author.id != 405143889691934720 && msg.channel.id == 167729387381325825) {
    db.run("INSERT INTO toots(id, userid, uri, content) VALUES(?, ?, ?, ?)", [msg.id, msg.author.id, msg.url, msg.content], function(err) {
  if (err) {
    return console.error(err.message);
  }
  console.log(`Rows inserted ${this.changes}`);
});
  }
});

client.login('NDA1MTQzODg5NjkxOTM0NzIw.Xa3cXQ.4WAm6EoysK_hFS4zAm9_tU-SX9Y');