local db = exports['rpg_db']

addEvent('login', true)
addEventHandler('login', root, function(login, pass)
	local qq = string.format("SELECT * FROM authorize WHERE login=%s", login)
    local res = db:query(qq)
    if not res or #res<1 then
        outputChatBox('takie konto nie istnieje')
        return
    end
    if res[1].login == 0 then
        outputChatBox('takie konto nie istnieje')
        return
    end
    if res[1].pass ~= pass then
        outputChatBox('zle haslo')
        return
    end
    setElementData(client, "player:dbid", res[1].dbid)
end)

addEvent('new', true)
addEventHandler('new', root, function(login, pass)
	local qq = string.format('SELECT * FROM authorize WHERE login=%s', login)
    local res = db:query(qq)
    if res and #res>0 then
        outputChatBox('takie konto juz jest')
        return
    end
	qq = string.format('INSERT INTO authorize (login,pass) VALUES (%s, %s)', login, pass)
    db:execute(qq)
    outputChatBox('zrobiles konto')
end)