local conn = dbConnect("sqlite","players.db")
if conn then
    outputConsole("AD-Info: Polaczono z baza danych Players.db")
else
    outputConsole("AD-Info: ERROR! Blad polaczenia z baza danych Players.db")
end

addEventHandler("onResourceStart",resourceRoot,
function()
    if conn then
        dbExec(conn,"CREATE TABLE IF NOT EXISTS players(login TEXT, health INT, armor INT, money INT, wantedlvl INT, reputation INT, exp INT, lvl INT, x FLOAT, y FLOAT, z FLOAT, r FLOAT, interior INT, dimension INT)")
    end
end)

addEventHandler("onPlayerLogin",resourceRoot,
function()
local login = getPlayerAccount(source)
if getAccountData(login,"alreadyPlayed") then
local q = dbQuery(conn,"SELECT rowid,* FROM players WHERE login=?",login)
local result = dbPoll(q,-1)
    if result then
        for _,row in ipairs(result) do
            spawnPlayer(source,row["x"],row["y"],row["z"],row["r"],0,row["interior"],row["dimension"])
            fadeCamera (source, true)
            setCameraTarget (source, source)
            setElementHealth(source,row["health"])
            setPedArmor(source,row["armor"])
            setElementData(source,"ID",row["rowid"])
            setPlayerMoney(source,row["money"],true)
            setPlayerWantedLevel(source,row["wantedlvl"])
            setElementData(source,"AD-reputation",row["reputation"])
            setElementData(source,"AD-exp",row["exp"])
            setElementData(source,"AD-lvl",row["lvl"])
        end
    end
else
    spawnPlayer(source,1448.8975830078, -2287.2204589844, 13.546875,90,0)
    fadeCamera (source, true)
    setCameraTarget (source, source)
end
end)

addEventHandler("onPlayerQuit",resourceRoot,
function()
if getPlayerAcount(source) then
    local acc = getPlayerAccount(source)
    local hajs = getPlayerMoney(source)
    local zycie = getElementHealth(source)
    local pancerz = getPedArmor(source)
    local px,py,pz = getElementPosition(source)
    local _,_,pr = getElementRotation(source)
    local expe = getElementData(source,"AD-exp") or 0
    local lvle = getElementData(source,"AD-lvl") or 0
    local rep = getElementData(source,"AD-reputation") or 0
    local wanted = getPlayerWantedLevel(source)
    local inter = getElementInterior(source)
    local dimens = getElementDimension(source)
    setAccountData(acc,"alreadyPlayed",true)
    local q = dbQuery(conn, "SELECT * FROM players WHERE login=?",acc)
    local result = dbPoll(q,-1)
    dbFree(q)
    if #result == 0 then
        dbQuery(conn,"INSERT INTO players (login,health,armor,money,wantedlvl,reputation,exp,lvl,x,y,z,r,interior,dimension) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,)",acc,zycie,pancerz,hajs,wanted,rep,exe,lvle,px,py,pz,pr,inter,dimens)
    elseif #result == 1 then
        dbExec(conn,"UPDATE players SET health=?,armor=?,money=?,wantedlvl=?,reputation=?,exp=?,lvl=?,x=?,y=?,z=?,r=?,interior=?,dimension=? WHERE login=?",zycie,pancerz,hajs,wanted,rep,exe,lvle,px,py,pz,pr,inter,dimens,acc)
    end
end
end)

spawnPlayer(source,1448.8975830078, -2287.2204589844, 13.546875,90,0)
    fadeCamera (source, true)