const fs = require("fs")
const guildsettings = JSON.parse(fs.readFileSync("./settings.json"))
const MySQL = require('mysql2/promise');
    const db = MySQL.createConnection({
        host: "localhost",
        user: "lars",
        password: "1j<~l3g-d1&\"%?K",
        database: "shuvi",
        multipleStatements: true
    }).then(db => {
client.guilds.forEach( g => {
    db.query(`INSERT INTO guildhelper (guildid, logchannel, modlogchannel, autorole, welcomemessage, leavemessage, welcomechannel, leavechannel, starexclude,
         logexclude, specificrules, starthres, starblacklist, starboardchannel, modlogcase, mutes, muterole, donator) VALUES
    (${g.id}, ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].logchannel > 1 ? guildsettings[g.id].logchannel : null : null},
        ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].modlog > 1 ? guildsettings[g.id].modlog : null : null},
        ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].autorole > 1 ? guildsettings[g.id].autorole : null : null},
        ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].welcome > 1 ? guildsettings[g.id].welcome : null : null},
        ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].leave > 1 ? guildsettings[g.id].leave : null : null},
        ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].umsgchannel > 1 ? guildsettings[g.id].umsgchannel : null : null},
        ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].umsgchannel > 1 ? guildsettings[g.id].umsgchannel : null : null},
        ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].starboardexclude ? guildsettings[g.id].starboardexclude.join(",") : null : null},
        ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].logexclude ? guildsettings[g.id].logexclude.join(",") : null : null},
        null,
        0,
        null,
        ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].starboard > 1 ? guildsettings[g.id].starboard : null : null},
        0,
        null,
        ${guildsettings[g.id] ? guildsettings[g.id] && guildsettings[g.id].muterole > 1 ? guildsettings[g.id].muterole : null : null},
        ${g.owner.id === "132584525296435200" ? 1 : 0}) ON DUPLICATE KEY UPDATE guildid=guildid`)
});
db.end()
});