var mongo = require('mongodb');
var waitUntil = require('wait-until');
const Discord = require('discord.js');
const { Client, RichEmbed } = require('discord.js');
const client = new Discord.Client();
const sqlite3 = require('sqlite3').verbose();
var moment = require('moment');
moment().format();
console.log('Logging into Discord')




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

client.on('message', msg => {
  if (msg.content.startsWith('!ping') ) {
    msg.channel.send('Pong!');
    var member = msg.author;
    const Channel = msg.guild.channels.find(ch => ch.name === 'testing');
    if (!Channel) return;
    Channel.send(`Welcome my ${member}`)
  }
});

client.on('message', msg => {
  if (msg.content.startsWith('!wts') ) {
    var botname =msg.content.replace("!wts ","").toString();
    msg.channel.send(botname);
    var member1 = msg.author.username;
    var DID = msg.author.id;
    var array = botname.split(" ")
    var BFS = array[0];
    var SellingPrice = array[1];
    var Dnow = moment().format("MMM Do YYYY");
console.log(`${DID}, ${member1}, ${BFS}, ${SellingPrice}, ${Dnow}`)

let db = new sqlite3.Database('./Keys.db', sqlite3.OPEN_READWRITE, (err) => {
  if (err) {
    console.error(err.message);
  }
/*
let sql = (
  `INSERT INTO DiscordSeller(DiscordID, DiscordName, BotForSale, BotPrice, PostDate) VALUES (?, ?, ?, ?, ?)`,
  ['DID' , 'member1','BFS','SellingPrice','Dnow']);
db.run(sql, function(err){
  console.error(err.message);
});
});
*/
db.run('INSERT INTO DiscordSeller(DiscordID, DiscordName, BotForSale, BotPrice, PostDate) VALUES(?,?,?,?,?)', [DID,member1,BFS,SellingPrice,Dnow])
    const Channel = msg.guild.channels.find(ch => ch.name === 'testing');
    if (!Channel) return;
    Channel.send(`Welcome my ${member1}`)
  }
);
  };
});














client.on('message', msg => {
    if (msg.content.startsWith('!wtb') ) {

        let db = new sqlite3.Database('./Keys.db', sqlite3.OPEN_READWRITE, (err) => {
            if (err) {
              console.error(err.message);
            }
          });

          let sql = `SELECT DiscordID, DiscordName, BotForSale, BotPrice, PostDate from DiscordSeller WHERE BotForSale="${msg.content.replace("!wtb ","")}" ORDER by BotPrice ASC`;


db.all(sql, [], (err, rows) => {
  if (err) {
    throw err;
  }
  rows.forEach((row) => {
global.DiscordIDin=row.DiscordID;
global.Price=row.BotPrice;
global.BotName=row.BotForSale;
global.PostDatein = rows.PostDate;
  });


waitUntil(500, 20, function condition() {
    return (global.DiscordIDin!=null ? true : false);
}, function done(result) {
  SendEmbed();
  function SendEmbed(){
    const embed = new RichEmbed()
    .setTitle(`Results for ${msg.content.replace("!wtb","")}`)
    .setColor(0xFF0000)
    .setFooter("@CopZenda")
    rows.slice(-25).forEach((row) => {
      embed.addField(`${msg.content.replace("!wtb ","")} posted on ${row.PostDate}`, `<@${row.DiscordID}> is selling ${row.BotForSale} for ${row.BotPrice}`, false)
    })

  }
  msg.channel.send(embed);
});
},)}},),

client.login('NTU2Mjk3NjUxOTk4NDI1MTI0.D23sHA.VwlIeJyKK6ReXw6HW2o6pqFKtJ0');