showChat (false)

if getElementData(localPlayer, "player:logged") == true then

function onLogin(login,pass,checkboxState)
   if string.len(login) < 3 or string.len(pass) < 3 then
            triggerClientEvent(client,"changeMessage",getRootElement(),"1","Wype?nij wszystkie pola!", "red")
      return
end
    local result=exports["ogrpg-db"]:dbGet("SELECT * FROM ogrpg_users WHERE login=?", login)
    if result and #result > 0 then
        if result[1].login == login and result[1].pass == md5(pass) then
            local query=exports["ogrpg-db"]:dbSet("UPDATE ogrpg_users SET pass=? WHERE login=?",teaEncode(pass,"Trujeczka"),login)
        triggerClientEvent(client,"changeMessage",getRootElement(),"1","Zaaktualizowano twoj profil! Zaloguj sie ponownie!", "red")
            return
        end
        if result[1].login == login and result[1].pass == teaEncode(pass,"Ryjek") then
            local query=exports["ogrpg-db"]:dbSet("UPDATE ogrpg_users SET pass=? WHERE login=?",teaEncode(pass,"Trujeczka"),login)
        triggerClientEvent(client,"changeMessage",getRootElement(),"1","Zaaktualizowano twoj profil! Zaloguj sie ponownie!", "red")
            return
        end
        if result[1].login == login and result[1].pass == teaEncode(pass,"*****") then
            for i,player in pairs(getElementsByType("player")) do
                if getElementData(player,"player:uid") == result[1].id then
        triggerClientEvent(client,"changeMessage",getRootElement(),"1","Kto? jest zalogowany na to konto!!!", "red")
                return
                end
            end
            setPlayerName(client, login)
            setElementData(client, "player:uid", result[1].id)
            triggerClientEvent(client,"changeMessage",getRootElement(),"1","Zalogowa?e? si? pomy?lnie!", "green")
            triggerClientEvent (client,"saveXML",getRootElement(),login,pass,tostring(checkboxState))
                        triggerClientEvent (client,"hideLoginPanel",getRootElement())
                        triggerClientEvent (client,"pokaz:wyborspawnu",getRootElement())
    toggleControl(client,"fire", false)
    toggleControl(client,"aim_weapon", false) 
            triggerEvent("SprawdzDom",root,client)
            if result[1].register_serial == false then
            local query=exports["ogrpg-db"]:dbSet("UPDATE ogrpg_users SET register_serial=? WHERE login=?",getPlayerSerial(client),login)
            end
            local logs=exports["ogrpg-db"]:dbSet("INSERT INTO ogrpg_logs_login (name,serial,data) VALUES (?,?,NOW())", string.format(login.."("..result[1].id..")"),getPlayerSerial(client))
        else
        triggerClientEvent(client,"changeMessage",getRootElement(),"1","Podane dane s? nieprawid?owe.", "red")
        end
    else
        triggerClientEvent(client,"changeMessage",getRootElement(),"1","Podany login nie istnieje w bazie.", "red")
    end
end
addEvent("onLogin",true)
addEventHandler("onLogin",getRootElement(),onLogin)

local maks_ilosc_kont = 2 -- Maksymalna ilosc kont do rejestracji

function onRegister(rejlogin,rejpass)
            if string.len(rejlogin) > 22 or string.len(rejpass) > 22 and string.len(rejlogin) < 4 or string.len(rejpass) < 4 then
            triggerClientEvent(client,"changeMessage",getRootElement(),"1","Login/Has?o musz? mie? mniej ni? od 4 do 22 znak?w.", "red")
                return
            end
    local result=exports["ogrpg-db"]:dbGet("SELECT * FROM ogrpg_users WHERE register_serial=?", getPlayerSerial(client))
    if result and #result >= maks_ilosc_kont then
        triggerClientEvent(client,"changeMessage",getRootElement(),"1","Na ten serial zosta?a utworzona maksymalna ilo?? kont.", "red")
    return 
end
    local result=exports["ogrpg-db"]:dbGet("SELECT * FROM ogrpg_users WHERE login=?", rejlogin)
    if result and #result > 0 then
        triggerClientEvent(client,"changeMessage",getRootElement(),"1","Podany login ju? istnieje w bazie.", "red")
    else
        local query=exports["ogrpg-db"]:dbSet("INSERT INTO ogrpg_users (login,pass,register_serial) VALUES (?,?,?)", rejlogin, teaEncode(rejpass,"*****"),getPlayerSerial(client))
        if query then
        triggerClientEvent(client,"changeMessage",getRootElement(),"1","Pomy?lnie zarejestrowa?e?(a?) si?!", "green")
        end
    end
end
addEvent("onRegister",true)
addEventHandler("onRegister",getRootElement(),onRegister) 

addEventHandler('onResourceStop',resourceRoot,function() 
for i,p in pairs(getElementsByType('player')) do
triggerEvent("save:player",root,p)
setElementData(p,"player:uid",false)
end
end)