const Discord = require("discord.js");
const bot = new Discord.Client();
const st = require('settings.json')
var mysql = require('mysql');
var replaceall = require("replaceall");


var con = mysql.createConnection({
  host: st.dbhost,
  user: st.dbuser,
  password: st.dbuser,
  database: st.database,
  charset: "utf8mb4"
});


function mysqlEscape(stringToEscape){
    return stringToEscape
        .replace("\\", "\\\\")
        .replace("\'", "\\\'")
        .replace("\"", "\\\"")
        .replace("\n", "\\\n")
        .replace("\r", "\\\r")
        .replace("\x00", "\\\x00")
        .replace("\x1a", "\\\x1a")
}

function replaceSzarok(stringToReplace) {
    return replaceall("'", '"', stringToReplace);
}

function getFormattedDate() {
    var date = new Date();
    var str = date.getFullYear() + "-" + (date.getMonth() + 1) + "-" + date.getDate() + " " +  date.getHours() + ":" + date.getMinutes() + ":" + date.getSeconds();
    return str;
}

con.connect(function(err) {
  if (err) console.log(err);
});

bot.on("ready", () => {
  bot.user.setStatus(st.status);
  console.log("Discord Userbot logger, rewritten by Levente#6914\nOriginal code by: palmarci\nStarted on:", getFormattedDate());
});

bot.on("message", (message) => {

 if (message.author.id !== bot.user.id)
    {
        var Attachment = (message.attachments).array();
        var hasImage = false;
        var imageUrl = "None";

        Attachment.forEach(function(attachment) {
            imageUrl = attachment.url;
            hasImage = true;
        })

    sqlquerry= "INSERT INTO `messages` (`ID`, `timestamp`, `author_id`, `author_name`, `message`, `channel_name`, `guild`, `has_image`, `image_url`) VALUES (NULL, '" + getFormattedDate() + ".000000', '"message.author.id"' '"+mysqlEscape(replaceSzarok(message.author.username))+"#"+message.author.discriminator+"', '"+mysqlEscape(replaceSzarok(message.content))+"', '"+mysqlEscape(replaceSzarok(message.channel.name))+"', '"+mysqlEscape(replaceSzarok(message.guild.name))+"', '"+hasImage+"', '"+imageUrl+"')"

        /*if(hasImage) {
      sqlquerry= "INSERT INTO `messages` (`ID`, `timestamp`, `author_id`, `author_name`, `message`, `channel_name`, `guild`, `has_image`, `image_url`) VALUES (NULL, '" + getFormattedDate() + ".000000', '"message.author.id"' '"+mysqlEscape(replaceSzarok(message.author.username))+"#"+message.author.discriminator+"', '"+mysqlEscape(replaceSzarok(message.content))+"', '"+mysqlEscape(replaceSzarok(message.channel.name))+"', '"+mysqlEscape(replaceSzarok(message.guild.name))+"', '"+hasImage+"', '"+imageUrl+"')"
            //sqlquerry = "INSERT INTO `messages`(`ID`, `timestamp`, `author_id`, `author_name`, `message`, `channel_name`, `has_image`, `image_url`) VALUES (NULL, '" + getFormattedDate() + ".000000', " + message.author.id + ", '" + mysqlEscape(replaceSzarok(message.author.username)) + "', '"+ mysqlEscape(replaceSzarok(message.content)) + "', '" + "" + message.channel.name + "', " + hasImage + ", '" + imageUrl + "')";
        } else {
      sqlquerry= "INSERT INTO `messages` (`ID`, `timestamp`, `author_id`, `author_name`, `message`, `channel_name`, `guild`, `has_image`, `image_url`) VALUES (NULL, '" + getFormattedDate() + ".000000', '"message.author.id"' '"+mysqlEscape(replaceSzarok(message.author.username))+"#"+message.author.discriminator+"', '"+mysqlEscape(replaceSzarok(message.content))+"', '"+mysqlEscape(replaceSzarok(message.channel.name))+"', '"+mysqlEscape(replaceSzarok(message.guild.name))+"', '"+hasImage+"', '"+imageUrl+"')"
            //sqlquerry = "INSERT INTO `messages`(`ID`, `timestamp`, `author_id`, `author_name`, `message`, `channel_name`) VALUES (NULL, '" + getFormattedDate() + ".000000', " + message.author.id + ", '" + mysqlEscape(replaceSzarok(message.author.username)) + "', '"+ mysqlEscape(replaceSzarok(message.content)) + "', '" + "" + message.channel.name + "')";
        }*/

        con.query(sqlquerry), function (err, result, fields)
        {
            if (err) throw err;
        }
    }
});

bot.login(st.token);