vehicles

--server
addCommandHandler("vehicle",function(player,command,model)
    model = tonumber(model)
    if type(model) == "number" then
        if model > 399 and model < 612 then
            local db = exports.vehiclesdb:getVdb()
            dbExec(db,"INSERT INTO filex (model,statue,spawn) VALUES (?,?,?)",model,100,"Parked")
        end
    end
end)

function showC(p)
    local db = exports.vehiclesdb:getVdb()
    function send(query)
        local table = dbPoll(query,0)
        triggerClientEvent("show:window",p,table)
    end
    dbQuery(send,db,"SELECT * FROM filex")

end
addCommandHandler("vehicles",showC)

addEvent("warp:vehicle",true)
addEventHandler("warp:vehicle",getRootElement(),function(p,model)
    x,y,z = getElementPosition(p)
    v = createVehicle(model,x,y,z + 2)
    warpPedIntoVehicle(p,v)
end)

--- Client
function window(table)
    local screenW, screenH = guiGetScreenSize()
    showCursor(true)
    local window = guiCreateWindow((screenW - 320) / 2, (screenH - 249) / 2, 320, 249, "owned vehiles", false)
    window:setMovable(false)
    window:setSizable(false)
    local parkB = guiCreateButton(12, 211, 79, 27, "park", false,window)
    local fixB = guiCreateButton(97, 211, 79, 27, "fix", false,window)
    local spawnB = guiCreateButton(186, 211, 79, 27, "spawn", false,window)
    local list = guiCreateGridList(12, 23, 256, 178, false,window)
    local closeB = guiCreateButton(271, 23, 39, 216, "CLOSE", false,window)
    guiGridListAddColumn(list, "name", 0.3)
    guiGridListAddColumn(list, "price", 0.3)
    guiGridListAddColumn(list, "statue", 0.3)
    for k,v in ipairs(table) do
         guiGridListAddRow(list,getVehicleNameFromModel(v.Model),v.Statue,v.Spawn)
    end
    addEventHandler("onClientGUIClick", closeB,function()destroyElement(window) showCursor(false) end)
    addEventHandler("onClientGUIClick", spawnB,function()
        r,c = guiGridListGetSelectedItem ( list)
        name =  guiGridListGetItemText ( list, r, c)
        model = getVehicleModelFromName(name)

        triggerServerEvent("warp:vehicle",getLocalPlayer(),getLocalPlayer(),model)
        destroyElement(window)
        showCursor(false)

    end)


end

addEvent("show:window",true)
addEventHandler("show:window",getRootElement(),window)