local connection = exports.mysql:conexion()
local adminTitles = {
    nivel1 = "Admin a prueba",
    nivel2 = "Administrador",
    nivel3 = "Administrador General",
    nivel4 = "Owner",
}

local modTitles = {
    nivel1 = "Soporte a prueba",
    nivel2 = "Soporte",
    nivel3 = "Moderador",
    nivel4 = "Moderador General",
}

local donatorTitles = {
    nivel1 = "Donador Nivel I",
    nivel2  = "Donador Nivel II",
    nivel3 = "Donador Nivel III",
}

function getAdminLevel(player)
    local check = dbQuery(connection, "SELECT * FROM `accounts` WHERE ID=?", getElementData(player or client, "idAccount"))
    local result = dbPoll(check, -1)
    local levelAdmin = tonumber(result[1].admin)
    return levelAdmin
end
addEvent("getAdminLevel", true)
addEventHandler("getAdminLevel", root, getAdminLevel)

function getAdminTitle(player)
    local adminTitle = "Ninguno"
    if getAdminLevel(player) == 1 then
    adminTitle = adminTitles.nivel1
    elseif getAdminLevel(player) == 2 then
    adminTitle = adminTitles.nivel2
    elseif getAdminLevel(player) == 3 then
    adminTitle = adminTitles.nivel3
    elseif getAdminLevel(player) == 4 then
    adminTitle = adminTitles.nivel4
    end
    return adminTitle
end
addEvent("getAdminTitle", true)
addEventHandler("getAdminTitle", root, getAdminTitle)

function isPlayerAdmin(player, level)
    local pLevel = getAdminLevel(player)
    if pLevel == level then
        return true
    else
        return false
    end
end
addEvent("isPlayerAdmin", true)
addEventHandler("isPlayerAdmin", root, isPlayerAdmin)

function getModLevel(player)
    local check = dbQuery(connection, "SELECT * FROM `accounts` WHERE ID=?", getElementData(player or client, "idAccount"))
    local result = dbPoll(check, -1)
    local levelMod = tonumber(result[1].support)
    return levelMod
end
addEvent("getModLevel", true)
addEventHandler("getModLevel", root, getModLevel)

function getModTitle(player)
    local modTitle = "Ninguno"
    if getAdminLevel(player) == 1 then
    modTitle = modTitles.nivel1
    elseif getAdminLevel(player) == 2 then
    modTitle = modTitles.nivel2
    elseif getAdminLevel(player) == 3 then
    modTitle = modTitles.nivel3
    elseif getAdminLevel(player) == 4 then
    modTitle = modTitles.nivel4
    end
    return modTitle
end
addEvent("getModTitle", true)
addEventHandler("getModTitle", root, getModTitle)

function isPlayerMod(player, level)
    local pLevel = getModLevel(player)
    if pLevel == level then
        return true
    else
        return false
    end
end
addEvent("isPlayerMod", true)
addEventHandler("isPlayerMod", root, isPlayerMod)