local connect = exports['ad_db']
local noti = exports['ad_notification']

function loginPlayer(player, login, password)
    login = string.gsub(login, ' ', '');
    password = string.gsub(password, ' ', '');

    local result = connect:query([[select * from accounts where login = ?]], login);
    if result and #result > 0 then
        passwordVerify(password, result[1].password, function(verify)
            if verify then
                for i,v in pairs(getElementsByType('player')) do
                    if (getElementData(v, "checkuserdata:pid") == result[1].pid) then
                        outputConsole('Ktoś jest zalogowany na to konto', player)
                        return
                    end
                end
                setPlayerName(player, login)
                fadeCamera(player, true)
                triggerClientEvent(player, 'LOGIN', resourceRoot, true);
            else
                outputConsole('Złe hasło', player)
            end
        end)
    else
        outputConsole('Takie konto nie istnieje', player)
    end
end

function registerPlayer(player, login, password, mail)
    login = string.gsub(login, ' ', '');
    password = string.gsub(password, ' ', '');

    local result = connect:query('select * from accounts where login=? limit 1', login)
    if result and #result > 0 then
        outputConsole('Konto o takiej nazwie już istnieje.', player)
        return
    end

    result = connect:query('select * from accounts where serial=?', getPlayerSerial(player))
    if result and #result >= 2 then
        outputConsole('Możesz posiadać maksymalnie 2 konta.', player)
        return
    end

    local discordcode = math.random(100000,999999)
    passwordHash(password, 'bcrypt', {}, function(pass)
        local query, _, pid = connect:query("INSERT INTO accounts (login,password,serial, register_ip, lasted_ip, kod_discord) VALUES (?,?,?,?, ?, ?)", login, pass, getPlayerSerial(player), getPlayerIP(player), getPlayerIP(player), discordcode, 1)
        setElementData(player, "checkuserdata:userDataLogging", true)
        if query then
            result = connect:query('select * from accounts where pid=? limit 1', pid)
            if result and #result > 0 then
                -- Account successfully created
            else
                outputConsole('Utworzono konto pomyślnie.', player)
            end
        else
            outputConsole('Wystąpił błąd podczas rejestracji. Zgłoś ten błąd administratorowi na forum.', player)
        end
    end)
end

addEvent('logging.registerPlayer', true)
addEventHandler('logging.registerPlayer', resourceRoot, function(...) registerPlayer(client, ...) end)

addEvent('logging.loginPlayer', true)
addEventHandler('logging.loginPlayer', resourceRoot, function(...) loginPlayer(client, ...) end)

triggerServerEvent('rpg:respawnPlayer', localPlayer)