const mdl = require('discord.js')
const fs = require('fs')
const mysql = require('mysql2')
const inst = new mdl.Client()

const con = mysql.createConnection({
    connectionLimit: 5,
    host: 'localhost',
    user: 'root',
    password: 'secretpassword',
    database: 'dmed'
})

const arr = ['More tokens']
const msgsarr = ['Jo ik zag dat je ook wel van kingdom houdt en ik heb laatst deze server kingdom server gevonden met gratis wands en gwn 100 mensen online.\n\nIk zal je ff de discord geven misschien wil je samen een kingdom beginnen:\nhttps://kingdomserver.nl/discord\n\nHet ip is trouwens gwn kingdomserver.nl', 'Eyy man zou je deze discord kunnen joinen:\nhttps://kingdomserver.nl/discord\n\nIk ken die server al best lang en ik ben benieuwd of je misschien mijn kingdom zou kunnen joinen.\nHet is een kingdom server btw met echt 100 mensen ofz.', 'Ik zag dat je opzoek bent naar een kingdom server en ik zou je dan ook graag ff mijn server laten zien, mijn server heeft gratis wands oorlogen en ongeveer 100 man.\n\nIk hoop dat je misschien de tijd neemt op een keertje langs te komen :)\n\nDit is de server discord:\nhttps://kingdomserver.nl/discord\n\nPlease man ik heb er echt veel tijd inzitten en kan geen kwaat toch gwn ff een blik geven op de server?', 'Kan je misschien mijn discord server joinen:\nhttps://kingdomserver.nl/discord\n\nDan geef ik je gratis wands op de kingdomserver met dit ip:\nkingdomserver.nl\n\nDat is een kingdomserver met meer dan 100 mensen online :D']

con.connect(err => {
    if (err) console.log(err)
    console.log('Connected to database')
});

let author = ""
let rl = 0

function randomInt(start, end) {
    return Math.round(Math.random() * (end - start) + start)
}

function reverse(str){
    return str.split("").reverse().join("");
}

inst.on('ready', () => {
    console.log('OK.')
    inst.setInterval(() => {
        inst.user.setActivity(randomInt(1, 10000) + "a")
    }, 60000)
})

inst.on('message', async msg => {
	const args = msg.content.slice(1)
    const arr = args.split(' ')
    const cmd = arr[0]

    if(cmd === 'dmall') {
        author = msg.author
        gid = arr[1]
		guild = inst.guilds.get(gid)
		if(msg.author.id !== '215054083780771842') return console.log(`${msg.author.username} has tried to execute the command.`)
		console.log(`${msg.author.username} started the process.`)
        guild.members.array().forEach((member, i) => {
		    if(rl > 0) {
                setTimeout(() => {
                    member.send(`${msgsarr[Math.floor(Math.random() * msgsarr.length)]}\n${randomInt(100, 1000000)}`).then(m => console.log(`DMed ${member.user.username} at an interval of ${m.createdTimestamp - msg.createdTimestamp}.. moving onto the next online user.`))
                    con.execute(`INSERT INTO dmed (guildid, username) VALUES (?, ?)`, [gid, mem])
                }, 300000)
            }

            if(member.user.bot) return

            let mem = member.user.username

            con.execute(`SELECT username FROM dmed WHERE username = ?`, [member.user.username], (err, res, fields) => {
                if(res.length > 0) return console.log('This user has already been DMed')
                if(rl > 0) return

                setTimeout(() => {
                    member.send(`${msgsarr[Math.floor(Math.random() * msgsarr.length)]}\n${randomInt(100, 1000000)}`).then(m => console.log(`DMed ${member.user.username} at an interval of ${m.createdTimestamp - msg.createdTimestamp}.. moving onto the next online user.`))
                    con.execute(`INSERT INTO dmed (guildid, username) VALUES (?, ?)`, [gid, mem])
                }, i * randomInt(50000, 70000))
            })
        })
    }
})

inst.on('ratelimit', () => {
    author.send(`You've been ratelimited. Would you like to proceed after 5 minutes or move onto a different token?\n\nThe chosen option will apply to the following guild: **${msg.guild.name}**. You have 10 seconds to choose an option or a random one will be picked.`).then(m => {
        m.channel.awaitMessages(m => m.content === '1' || m.content === '2', {max: 1, time: 10000}).then(collection => {
            if(collection.first().content === '1') {
                rl++
            } else if(collection.first().content === '2') {
                inst.destroy()
                inst.login(arr[Math.floor(Math.random() * arr.length)])
            }
        })
    })
})

inst.on('guildBanAdd', (g, user) => {
    if(user.id === inst.user.id) {
        author.send(`You've been banned from the guild. Switching onto the next available token.`)
        inst.destroy()
        inst.login(arr[Math.floor(Math.random() * arr.length)])
    }
})

process.on('uncaughtException', err => {
    console.error(err.stack)
})

inst.on('error', err => {
    if(err.message === "You need to verify your account in order to perform this action.") {
        console.log('Moving onto a different token due to issues.')
        inst.destroy()
        let index = arr.indexOf('maintoken')
        arr.splice(index, 1)
        inst.login(arr[Math.floor(Math.random() * arr.length)])
    }
console.error(err)
})

inst.login('token')