local expp = exports.mysql:_Exec("insert into pojazdy(model,ownerid) values (?,?)",model,ownerid)

local query, rows, id = exports

function _Query(...) 
    if not {...} then return end 
        local query = dbQuery(db_handler, ...) 
        local result, num_affected_rows, last_insert_id = dbPoll(query, -1) 
    return result, num_affected_rows, last_insert_id
end

setElementData(vehicle, "vehicle:id", id)

-- to co przed exportem
local result, num, id = exports.mysql:_Query("tutaj insert")
if result then
--tutaj tworzenie pojazdu
if vehicle then
-- tutaj warp
setElementData(vehicle, "vehicle:id", id)
-- dalsza cze?? 

function StworzPojazd(plr,model,posx,posy,posz,rotx,roty,rotz)

local ownerid = getElementData(plr,"sid")

local result, num, id = exports.mysql:_Exec("insert into pojazdy(model,ownerid) values (?,?)",model,ownerid)
if result then
local vehicle = createVehicle(model, posx, posy, posz, rotx, roty, rotz)
if vehicle then
warpPedIntoVehicle(plr, vehicle)
setElementData(vehicle, "vehicle:id", id)
setElementData(vehicle, "vehicle:milage", 0)
setElementData(vehicle, "vehicle:fuel", 100)
local name = getPlayerName(plr)
setElementData(vehicle, "ostkierowca", name)
end
end
end

local connection = nil
addEventHandler("onResourceStart",resourceRoot,function(resource)
        connection = dbConnect("mysql","dbname=******;host=*******;port=3306;","*****","*******")
        if connection then
            outputDebugString("Polaczono z baza danych!")
            return true
        else
            outputDebugString("Blad podczas laczenia sie z baza danych!")
            return false
        end
    end
)

function _Query(...) 
    if not {...} then return end 
        local query = dbQuery(connection, ...) 
        local result, num_affected_rows, last_insert_id = dbPoll(query, -1) 
    return result, num_affected_rows, last_insert_id
end

function _QuerySingle(str,...)
    if connection then
        local result = _Query(str,...)
        if type(result) == 'table' then
            return result[1]
        end
    else
        return false
    end
end

function _Exec(str,...)
    if connection then
        local query = dbExec(connection,str,...)
        return query
    else
        return false
    end
end

setElementData(vehicle, "vehicle:id", idv)

function ZapiszPojazd(vehicle)

local panelstates={}
local id=getElementData(vehicle, "vehicle:id")
local model=getElementModel(vehicle)
local health=getElementHealth(vehicle)
local x,y,z=getElementPosition(vehicle)
local rx,ry,rz=getElementRotation(vehicle)
local id=getElementData(vehicle,"vehicle:id")
local fuel=getElementData(vehicle,"vehicle:fuel")
local mileage=getElementData(vehicle,"vehicle:mileage")
local c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12=getVehicleColor(vehicle, true)
local ownerid=getElementData(vehicle,"vehicle:ownerid")
local h1,h2,h3=getVehicleHeadLightColor(vehicle)
local paintjob=getVehiclePaintjob(vehicle)
local ostkierowca=getElementData(vehicle, "vehicle:ostkierowca") or " "
local frozen= isElementFrozen(vehicle) and 1 or 0
local mk1 = getElementData(vehicle, "vehicle:mk1")
local mk2 = getElementData(vehicle, "vehicle:mk2")
local mk3 = getElementData(vehicle, "vehicle:mk3")
local rh1 = getElementData(vehicle, "vehicle:rh1")

for i=0,6 do table.insert(panelstates, getVehiclePanelState(vehicle,i)) end
panelstates=table.concat(panelstates,",")
upgrades=getVehicleUpgrades(vehicle)
if not upgrades then upgrades={} end
upgrades=table.concat(upgrades, ",")
exports.mysql:_Exec("UPDATE pojazdy SET ownerid=?, frozen=?, health=?, fuel=?, milage=?, ostkierowca=?, posx=?, posy=?, posz=?, rotx=?, roty=?, rotz=?, color='%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d', panelstates=?, headlights='%d,%d,%d', tuning=?, mk1=?, mk2=?, mk3=?, rh1=?, paintjob=? where id=?",ownerid, frozen, health, fuel, milage, ostkierowca, x,y,z,rx,ry,rz,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,panelstates,h1,h2,h3, tuning, mk1, mk2, mk3, rh1, paintjob, id)

end