function loadPlayerData(plr)
    local result=exports["ogrpg-db"]:dbGet("SELECT * FROM ogrpg_users WHERE id=?", getElementData(plr,"player:uid"))
    if result and #result > 0 then
        local v=result[1]
        setPlayerMoney(plr,v.money)
        setElementModel(plr,v.skin)
        setElementData(plr,"status","Aktywny")
        setElementData(plr,"user:nickname",v.login1)
        setElementData(plr,"player:logged",true)
        --setElementData(plr,"player:shoe",toJSON(v.prize))
        setElementData(plr,"player:license:pjA",v.pjA)
        setElementData(plr,"player:license:pjB",v.pjB)
        setElementData(plr,"player:license:pjC",v.pjC)
        setElementData(plr,"player:license:pjL",v.pjL)
        setElementData(plr,"player:reputation",v.reputation)
        setElementData(plr,"player:workinjob",v.worker)
        setElementData(plr,"player:registerdate",v.registered)
        setElementData(plr,"player:hours",v.hours)
        setElementData(plr,"p:title",v.rp_tytul)
        setElementData(plr,"nanky:x",v.nankyx)
        setElementData(plr,"nanky:y",v.nankyy)
        setElementData(plr,"nanky:z",v.nankyz)
        --if v.prize ~= "" then setElementData(plr, "player:shoe", fromJSON(v.prize)) else setElementData(plr, "player:shoe", {}) end
        local queryA=string.format("SELECT * FROM ogrpg_users WHERE id=%d AND premiumdate>NOW() LIMIT 1", getElementData(plr,"player:uid"))
        local resultA=exports["ogrpg-db"]:pobierzWyniki(queryA)
        if (resultA) then
            setElementData(plr,"player:premium",true)
            setElementData(plr,"player:premiumdate",v.premiumdate)
            setPlayerName(plr,"#FFBF00"..getPlayerName(plr))
        else
            setElementData(plr,"player:premium",false)
        end
        setElementData(plr,"player:skin",v.skin)
        local org=exports["ogrpg-db"]:dbGet("SELECT * FROM ogrpg_organizations WHERE uid=? LIMIT 1", getElementData(plr,"player:uid")) -- pobieramy tylko JEDEN rekord
        if org and #org > 0 then
            setElementData(plr,"player:organization",org[1].code)
            exports['ogrpg-db']:dbSet("UPDATE ogrpg_organizations SET actived=curdate() WHERE uid=?", getElementData(plr,"player:uid"))
        end
        return true
    end
    return false
end
 
--[[function savePlayerData(plr)
    local uid=getElementData(plr,"player:uid")
    local data = getElementData(plr,"_zalogowany")
    if not uid then return end
    if not data then return end
    local money=getPlayerMoney(plr)
    local licensea=getElementData(plr,"player:license:pjA")
    local licenseb=getElementData(plr,"player:license:pjB")
    local licensec=getElementData(plr,"player:license:pjC")
    local licensel=getElementData(plr,"player:license:pjL")
    local reputation=getElementData(plr,"player:reputation")
    local minuty=getElementData(plr,"player:hours")
    local minutyduty=getElementData(plr,"player:workinjob")
    --local prize=getElementData(plr,"player:shoe")
    local rypy=getElementData(plr,"p:title")
    local x, y, z = getElementPosition(plr)
    local query=exports["ogrpg-db"]:dbSet("UPDATE ogrpg_users SET money=?, reputation=?, pjA=?, pjB=?, pjC=?, pjL=?, hours=?, worker=?, rp_tytul=?, nankyx=?, nankyy=?, nankyz=? WHERE id=?",money,reputation, licensea, licenseb, licensec, licensel, minuty, minutyduty, rypy, x, y, z, uid)
]]--end
 
function hook_givePlayerMoney( sourceResource, functionName, isAllowedByACL, luaFilename, luaLineNumber, ... )
    local args = { ... }
    local plr = args[1]
    local money = args[2]
    local monety = exports['ogrpg-db']:dbGet("select * from ogrpg_users where id=?",getElementData(plr,"player:uid"))
    local ile = monety[1]['money'] + money
    exports['ogrpg-db']:dbSet('update ogrpg_users set money=? where id=?',ile,getElementData(plr,"player:uid"))
end
addDebugHook( "postFunction", hook_givePlayerMoney, {"givePlayerMoney"})
 
function hook_takePlayerMoney( sourceResource, functionName, isAllowedByACL, luaFilename, luaLineNumber, ... )
    local args = { ... }
    local plr = args[1]
    local money = args[2]
    local monety = exports['ogrpg-db']:dbGet("select * from ogrpg_users where id=?",getElementData(plr,"player:uid"))
    local ile = monety[1]['money'] - money
    exports['ogrpg-db']:dbSet('update ogrpg_users set money=? where id=?',ile,getElementData(plr,"player:uid"))
end
addDebugHook( "postFunction", hook_takePlayerMoney, {"takePlayerMoney"})
 
function hook_setPlayerMoney( sourceResource, functionName, isAllowedByACL, luaFilename, luaLineNumber, ... )
    local args = { ... }
    local plr = args[1]
    local money = args[2]
    exports['ogrpg-db']:dbSet('update ogrpg_users set money=? where id=?',money,getElementData(plr,"player:uid"))
end
addDebugHook( "postFunction", hook_setPlayerMoney, {"setPlayerMoney"})
 
function hook_setElementData( sourceResource, functionName, isAllowedByACL, luaFilename, luaLineNumber, ... )
   local args = {...}
   if args[2] == "player:reputation" then
        local ile = args[3]
        local plr = args[1]
        exports['ogrpg-db']:dbSet('update ogrpg_users set reputation=? where id=?',ile,getElementData(plr,"player:uid"))
   end
    if args[2] == "player:workinjob" then
        local ile = args[3]
        local plr = args[1]
        exports['ogrpg-db']:dbSet('update ogrpg_users set worker=? where id=?',ile,getElementData(plr,"player:uid"))
   end
    if args[2] == "player:hours" then
        local ile = args[3]
        local plr = args[1]
        exports['ogrpg-db']:dbSet('update ogrpg_users set hours=hours+? where id=?',ile,getElementData(plr,"player:uid"))
   end
    if args[2] == "player:license:pjA" then
        local ile = args[3]
        local plr = args[1]
        exports['ogrpg-db']:dbSet('update ogrpg_users set hours=? where id=?',ile,getElementData(plr,"player:uid"))
   end
    if args[2] == "player:license:pjB" then
        local ile = args[3]
        local plr = args[1]
        exports['ogrpg-db']:dbSet('update ogrpg_users set hours=? where id=?',ile,getElementData(plr,"player:uid"))
   end
    if args[2] == "player:license:pjC" then
        local ile = args[3]
        local plr = args[1]
        exports['ogrpg-db']:dbSet('update ogrpg_users set hours=? where id=?',ile,getElementData(plr,"player:uid"))
   end
    if args[2] == "player:license:pjL" then
        local ile = args[3]
        local plr = args[1]
        exports['ogrpg-db']:dbSet('update ogrpg_users set hours=? where id=?',ile,getElementData(plr,"player:uid"))
   end
end
addDebugHook( "postFunction", hook_setElementData, {"setElementData"})
 
addEventHandler("onPlayerQuit",root,function(x)
    local tresc = getPlayerName(source):gsub("#%x%x%x%x%x%x","").." opuscil gre. pieniadze: "..getPlayerMoney(source).." RP "..getElementData(source,"player:reputation").." przepracowane "..getElementData(source,"player:workinjob")
    exports['ogrpg-db']:dbSet("insert into ogrpg_logi (uid,tresc,serial,typ,data) values (?,?,?,?,?)",getElementData(source,"player:uid"),tresc,getPlayerSerial(source,"player:uid"),x,"NOW()")
end)