on('playerDropped', async (reason) => {
    let result = await query(`
        insert into \`madmin_logs\` (\`type\`, \`author\`, \`message\`, \`date\`, \`player_uid\`, \`count\`, \`cancelled\`)
        values ('disconnect', '${GetPlayerName(global.source)}', 'disconnected. Reason: ${reason.replaceAll("'", "\\'")}', '${moment(Date.now()).format("DD.MM.YYYY HH:mm:ss")}', 'None', 0, 0)
    `)    
    if (result === false) return
})

RegisterNetEvent("mAdmin:AddKillLog")
on('mAdmin:AddKillLog', async (killer, reason) => {
    const src = global.source

    let victimIdentifier = ""
    let killerIdentifier = ""
    if (!killer) {
        killer = global.source
    }
    if (config.Framework.includes("qb")) {
        let qPlayer = FrameworkObject.Functions.GetPlayer(global.source)
        if (qPlayer) {
            victimIdentifier = qPlayer.PlayerData.citizenid
        }
        qPlayer = FrameworkObject.Functions.GetPlayer(killer)
        if (qPlayer) {
            killerIdentifier = qPlayer.PlayerData.citizenid
        }
    } else if (config.Framework.includes("esx")) {
        let xPlayer = FrameworkObject.GetPlayerFromId(src)
        if (xPlayer) {
            victimIdentifier = xPlayer.identifier
        }
        xPlayer = FrameworkObject.GetPlayerFromId(killer)
        if (xPlayer) {
            killerIdentifier = xPlayer.identifier
        }
    }

    let victimName = GetPlayerName(global.source)
    let killerName = GetPlayerName(killer)

    let result = await query(`
        insert into \`madmin_logs\` (
            \`type\`,
            \`author\`,
            \`message\`,
            \`date\`,
            \`player_uid\`
        ) values (
            'death',
            '${victimName}',
            'died. Reason: ${reason.replaceAll("'", "\\'")}. Killer: ${killerName.replaceAll("'", "\\'")}',
            '${moment(Date.now()).format("DD.MM.YYYY HH:mm:ss")}',
            '${victimIdentifier}'
        )
    `)
    if (result === false) return

    if (Number(src) !== Number(killer)) {
        result = await query(`
            insert into \`madmin_logs\` (
                \`type\`,
                \`author\`,
                \`message\`,
                \`date\`,
                \`player_uid\`
            ) values (
                'kill',
                '${killerName.replaceAll("'", "\\'")}',
                'killed ${victimName.replaceAll("'", "\\'")} Reason: ${reason.replaceAll("'", "\\'")}.',
                '${moment(Date.now()).format("DD.MM.YYYY HH:mm:ss")}',
                '${killerIdentifier}'
            )
        `)
        if (result === false) return
    }
})

RegisterNetEvent("mAdmin:RegisterDoubleConnect")
on("mAdmin:RegisterDoubleConnect", async (playerName, playerLicense) => {
    let result = await query(`
        insert into \`madmin_logs\` (
            \`type\`,
            \`author\`,
            \`message\`,
            \`date\`,
            \`player_uid\`
        ) values (
            'doubleconnect',
            '${playerName.replaceAll("'", "\\'")}',
            '${config.DropPlayerOnDoubleConnect ? 'tried to double connect.' : 'double connected.'} Identifier: license:${playerLicense.split(":")[1]}',
            '${moment(Date.now()).format("DD.MM.YYYY HH:mm:ss")}',
            'None'
        )
    `)
    if (result === false) return
})