server.lua

-- Variables
local QBCore = exports['qb-core']:GetCoreObject()
local OutsideVehicles = {}
local activePlayerPositions = {}
local dataLoaded = false
local AllGarages = {}
OutsideVehiclesData = {}
-- Functions
local function GetClosestPlayerId(position) -- return the ID of the closest player
	local closestDistance = 1000000.0
	local closestPlayerID = nil
	local closestPos = nil
	for playerID, pos in pairs(activePlayerPositions) do
		local distance = #(position - pos)
		if (distance < closestDistance) then
			closestDistance = distance
			closestPlayerID = playerID
			closestPos = pos
		end
	end
	local distance = nil
	if (closestPlayerID ~= nil) then
		distance = #(position - closestPos)
	end
	return closestPlayerID, distance
end

local function ContainsPlate(plate, vehiclePlates)
	for k, v in pairs(vehiclePlates) do
		if plate == v then
			return true
		end
	end
	return false
end

local function GetRotationDifference(r1, r2) -- returns the difference in degrees from the axis with the highest difference
	local x = math.abs(r1.x - r2.x)
	local y = math.abs(r1.y - r2.y)
	local z = math.abs(r1.z - r2.z)

	if (x > y and x > z) then
		return x
	elseif (y > z) then
		return y
	else
		return z
	end
end

local function GetPlayerIdentifiersSorted(playerServerId) -- Return an array with all identifiers - e.g. ids['license'] = license:xxxxxxxxxxxxxxxx
	local ids = {}
	local identifiers = GetPlayerIdentifiers(playerServerId)
	for k, identifier in pairs (identifiers) do
		local i, j = string.find(identifier, ':')
		local idType = string.sub(identifier, 1, i-1)
		ids[idType] = identifier
	end
	return ids
end

local function IsPlayerWithLicenseActive(license) -- returns true if a player is active on the server with the specified license
	for playerId, playerPos in pairs(activePlayerPositions) do
		if (GetPlayerIdentifiersSorted(playerId)['license'] == license) then
			return true
		end
	end
	return false
end

local function Trim(value)
	if not value then return nil end
    return (string.gsub(value, '^%s*(.-)%s*$', '%1'))
end

local function GetPlate(vehicle)
    if vehicle == 0 then return end
    return Trim(GetVehicleNumberPlateText(vehicle))
end

local function TryGetLoadedVehicle(plate, loadedVehicles) -- returns a loaded vehicled with a given number plate
	for k, v in pairs(loadedVehicles) do
		if plate == GetPlate(v) and DoesEntityExist(v) then
			return v
		end
	end
	return nil
end

local function isVehicleExistInRealLife(plate) -- returns a loaded vehicled with a given number plate
	local loadedVehicles = GetAllVehicles()
	local check = false
	for k, v in pairs(loadedVehicles) do
		if plate == GetPlate(v) and DoesEntityExist(v) then
			check = true
		end
	end
	return check
end

local function TrySpawnVehicles() -- checks if vehicles have to be spawned and spawns them if necessary
	
	local playerVehiclePlates = {}
	for id, position in pairs(activePlayerPositions) do
		local ped = GetPlayerPed(id)
		local veh = GetVehiclePedIsIn(ped, false)
		if (DoesEntityExist(veh)) then
			table.insert(playerVehiclePlates, GetPlate(veh))
		end
	end
	for plate, vehicleData in pairs(OutsideVehicles) do
		if vehicleData then
			if not vehicleData.spawning then
				local closestPlayer, dist = GetClosestPlayerId(vehicleData.position)
				if closestPlayer ~= nil and dist < spawnDistance and not ContainsPlate(plate, playerVehiclePlates) then
					if vehicleData.handle ~= nil and DoesEntityExist(vehicleData.handle) then -- vehicle found on server side
						local networkOwner = -1
						while (networkOwner == -1) do
							Wait(0)
							networkOwner = NetworkGetEntityOwner(vehicleData.handle)
						end
						TriggerClientEvent('MojiaGarages:client:updateVehicle', networkOwner, NetworkGetNetworkIdFromEntity(vehicleData.handle))
					else -- vehicle not found on server side. Check, if it is loaded differently
						local loadedVehicles = GetAllVehicles()
						local loadedVehicle = TryGetLoadedVehicle(plate, loadedVehicles)
						if loadedVehicle ~= nil then -- vehicle found
							vehicleData.handle = loadedVehicle
							local networkOwner = -1
							while (networkOwner == -1) do
								Wait(0)
								networkOwner = NetworkGetEntityOwner(vehicleData.handle)
							end
							TriggerClientEvent('MojiaGarages:client:updateVehicle', networkOwner, NetworkGetNetworkIdFromEntity(vehicleData.handle))
						else -- vehicle not found. Try and spawn it
							local playerId, distance = GetClosestPlayerId(vehicleData.position)
							if playerId and distance < spawnDistance then
								if vehicleData.modifications then
									TriggerClientEvent('MojiaGarages:client:spawnOutsiteVehicle', playerId, vehicleData)
									TriggerClientEvent('MojiaGarages:client:updateVehicleKey', -1, plate) -- Update vehicle key for qb-vehiclekey
									vehicleData.spawning = true
								end
							end
						end
					end
				end
			else
				local loadedVehicles1 = GetAllVehicles()
				local loadedVehicle1 = TryGetLoadedVehicle(plate, loadedVehicles1)
				if loadedVehicle1 ~= nil then -- vehicle found
				else
					TriggerEvent('MojiaGarages:server:updateOusiteVehicles')
					vehicleData.spawning = false
				end
				if vehicleData.spawningPlayer then
					if not IsPlayerWithLicenseActive(vehicleData.spawningPlayer) then -- if vehicle is currently spawning check if responsible player is still connected
						TriggerEvent('MojiaGarages:server:setVehicleModsFailed', plate)
					end
				end
			end
		end
	end
end

local function GetActivePlayerCount()
	local playerCount = 0
	for k, v in pairs(QBCore.Functions.GetPlayers()) do
		playerCount = playerCount + 1
	end
	return playerCount
end

local function CleanUp() -- Default cleaning function. seize vehicles that are outside and just parked in one location without any change over a period of time
	local currentTime = os.time()
	local threshold = 60 * 60 * cleanUpThresholdTime
	local toDelete = {}
	for plate, vehicle in pairs(OutsideVehicles) do
		if vehicle.lastUpdate < os.difftime(currentTime, threshold) then
			MySQL.Async.execute('UPDATE player_vehicles SET state = 2 WHERE state = @state AND depotprice = @depotprice AND plate = @plate',
				{
					['@state'] = 0,
					['@depotprice'] = 0,
					['@plate'] = plate
				}
			)
			table.insert(toDelete, plate)
		end
	end
	for i = 1, #toDelete, 1 do
		local plate = toDelete[i]
		OutsideVehicles[plate] = nil
	end
end

-- Callbacks
QBCore.Functions.CreateCallback('MojiaGarages:server:checkHasVehicleOwner', function(source, cb, plate) -- Check Has Vehicle Owner:
	MySQL.Async.fetchAll('SELECT * FROM player_vehicles WHERE plate = ?',
		{
			plate
		}, function(result)
		if result[1] ~= nil then
			 cb(true, result[1].balance)
		else
			cb(false)
		end
	end)
end)

QBCore.Functions.CreateCallback('MojiaGarages:server:getVehicleData', function(source, cb, plate) -- Get Vehicle Data:
	MySQL.Async.fetchAll('SELECT * FROM player_vehicles WHERE plate = ?',
		{
			plate
		}, function(result)
		if result[1] then
			cb(result[1])
		else
			cb(false)
		end
	end)
end)

QBCore.Functions.CreateCallback('MojiaGarages:server:checkVehicleOwner', function(source, cb, plate) -- Check Vehicle Owner:
	local src = source
	local Player = QBCore.Functions.GetPlayer(src)
	MySQL.Async.fetchAll('SELECT * FROM player_vehicles WHERE plate = ? AND citizenid = ?',
		{
			plate,
			Player.PlayerData.citizenid
		}, function(result)
		if result[1] then
			 cb(true, result[1].balance)
		else
			cb(false)
		end
	end)
end)

QBCore.Functions.CreateCallback('MojiaGarages:server:GetUserVehicles', function(source, cb) -- Get a list of vehicles in the garage
	local src = source
	local Player = QBCore.Functions.GetPlayer(src)
	MySQL.Async.fetchAll('SELECT * FROM player_vehicles WHERE citizenid = ?',
		{
			Player.PlayerData.citizenid
		}, function(result)
		if result[1] ~= nil then
			cb(result)
		else
			cb(nil)
		end
	end)
end)

QBCore.Functions.CreateCallback('MojiaGarages:server:GetimpoundVehicles', function(source, cb) -- Get a list of impounded vehicles
	MySQL.Async.fetchAll('SELECT * FROM player_vehicles WHERE state = 2',{}, function(result)
		if result[1] ~= nil then
			cb(result)
		else
			cb(nil)
		end
	end)
end)

QBCore.Functions.CreateCallback('qb-garage:server:GetPlayerVehicles', function(source, cb) --Call from qb-phone
    local Player = QBCore.Functions.GetPlayer(source)
    local Vehicles = {}

    MySQL.Async.fetchAll('SELECT * FROM player_vehicles WHERE citizenid = ?',
		{
			Player.PlayerData.citizenid
		}, function(result)
        if result[1] then
            for k, v in pairs(result) do
                local VehicleData = QBCore.Shared.Vehicles[v.vehicle]
				local modifications = json.decode(v.mods)
                local VehicleGarage = 'None'
                if v.garage ~= nil then
					if Garages[v.garage] ~= nil then
						VehicleGarage = Garages[v.garage]['label']
					end
				end

                if v.state == 0 then
                    if v.depotprice == 0 then
						VehicleGarage = 'None'
						v.state = 'Out'
					else
						VehicleGarage = 'Depot'
						v.state = 'In Depot'
					end
                elseif v.state == 1 then
                    v.state = 'In'
                elseif v.state == 2 then
					VehicleGarage = 'Police Depot'
					v.state = 'Impounded'
                end
                
                local fullname 
                if VehicleData['brand'] ~= nil then
                    fullname = VehicleData['brand'] .. ' ' .. VehicleData['name']
                else
                    fullname = VehicleData['name']
                end    
                Vehicles[#Vehicles+1] = {
                    fullname = fullname,
                    brand = VehicleData['brand'],
                    model = VehicleData['name'],
                    plate = v.plate,
                    garage = VehicleGarage,
                    state = v.state,
                    fuel = modifications.fuelLevel,
                    engine = modifications.engineHealth,
                    body = modifications.bodyHealth
                }
            end
            cb(Vehicles)
        else
            cb(nil)
        end
    end)
end)

QBCore.Functions.CreateCallback("qb-garage:server:checkVehicleOwner", function(source, cb, plate)--Call from qb-vehiclesales
    local src = source
    local pData = QBCore.Functions.GetPlayer(src)
    MySQL.Async.fetchAll('SELECT * FROM player_vehicles WHERE plate = ? AND citizenid = ?',{plate, pData.PlayerData.citizenid}, function(result)
        if result[1] then
            cb(true, result[1].balance)
        else
            cb(false)
        end
    end)
end)

-- Events
RegisterNetEvent('MojiaGarages:server:renderScorched', function(vehicleNetId, scorched) -- render entity scorched (trigger with netid of the vehicle and false when repairing)
	local vehicleHandle = NetworkGetEntityFromNetworkId(vehicleNetId)
	if (DoesEntityExist(vehicleHandle)) then
		TriggerClientEvent('MojiaGarages:client:renderScorched', -1, vehicleNetId, scorched)
	end
end)

local VehicleData = {}

RegisterNetEvent('MojiaVehicles:server:UpdateVehicleData', function(data, plate)
    local currentTime = os.time()
	VehicleData[plate] = data
	if isVehicleExistInRealLife(plate) then
		VehicleData[plate].spawned = true
	else
		VehicleData[plate].spawned = false
	end
    TriggerClientEvent('MojiaVehicles:client:UpdateVehicleData', -1, VehicleData[plate], plate)
	MySQL.Async.fetchAll('SELECT plate FROM player_vehicles WHERE plate = @plate',
		{
			['@plate'] = plate,
		}, function(results)
		if results then
			MySQL.Async.execute('UPDATE player_vehicles SET posX = @posX, posY = @posY, posZ = @posZ, rotX = @rotX, rotY = @rotY, rotZ = @rotZ, mods = @mods, lastUpdate = @lastUpdate WHERE plate = @plate',
			{
				['@plate']          	= plate,
				['@posX']           	= data.position.x,
				['@posY']           	= data.position.y,
				['@posZ']           	= data.position.z,
				['@rotX']           	= data.rotation.x,
				['@rotY']           	= data.rotation.y,
				['@rotZ']           	= data.rotation.z,
				['@mods']  				= json.encode(data.mods),
				['@lastUpdate']     	= currentTime
			})
		end
	end)
end)

RegisterNetEvent('MojiaGarages:server:updateVehicle', function(networkId, plate, modifications)
	local vehicle = NetworkGetEntityFromNetworkId(networkId)
	if (DoesEntityExist(vehicle)) then
		local currentTime = os.time()
		local position = GetEntityCoords(vehicle)
		position = vector3(math.floor(position.x * 100.0) / 100.0, math.floor(position.y * 100.0) / 100.0, math.floor(position.z * 100.0) / 100.0)
		local rotation = GetEntityRotation(vehicle)
		rotation = vector3(math.floor(rotation.x * 100.0) / 100.0, math.floor(rotation.y * 100.0) / 100.0, math.floor(rotation.z * 100.0) / 100.0)
		if (OutsideVehicles[plate] ~= nil) then
			-- already on server list
			if (OutsideVehicles[plate].handle ~= vehicle) then
				if (DoesEntityExist(OutsideVehicles[plate].handle)) then
					DeleteEntity(OutsideVehicles[plate].handle)
				end
				OutsideVehicles[plate].handle = vehicle
				OutsideVehicles[plate].model = vehicle
			end
			OutsideVehicles[plate].position = position
			OutsideVehicles[plate].rotation = rotation
			OutsideVehicles[plate].modifications = modifications
			OutsideVehicles[plate].lastUpdate = currentTime
			MySQL.Async.execute('UPDATE player_vehicles SET posX = @posX, posY = @posY, posZ = @posZ, rotX = @rotX, rotY = @rotY, rotZ = @rotZ, mods = @modifications, lastUpdate = @lastUpdate WHERE plate = @plate',{
				['@plate']          = plate,
				['@posX']           = OutsideVehicles[plate].position.x,
				['@posY']           = OutsideVehicles[plate].position.y,
				['@posZ']           = OutsideVehicles[plate].position.z,
				['@rotX']           = OutsideVehicles[plate].rotation.x,
				['@rotY']           = OutsideVehicles[plate].rotation.y,
				['@rotZ']           = OutsideVehicles[plate].rotation.z,
				['@modifications']  = json.encode(OutsideVehicles[plate].modifications),
				['@lastUpdate']     = OutsideVehicles[plate].lastUpdate
			})
			RefreshVehicles()
		else
			-- insert in db
			OutsideVehicles[plate] = {
				handle          = vehicle,
				model = vehicle,
				position        = position,
				rotation        = rotation,
				modifications   = modifications,
				lastUpdate      = currentTime,
				spawning        = false,
				spawningPlayer  = nil
			}
			MySQL.Async.execute('UPDATE player_vehicles SET posX = @posX, posY = @posY, posZ = @posZ, rotX = @rotX, rotY = @rotY, rotZ = @rotZ, mods = @modifications, lastUpdate = @lastUpdate WHERE plate = @plate',{
				['@plate']          = plate,
				['@posX']           = OutsideVehicles[plate].position.x,
				['@posY']           = OutsideVehicles[plate].position.y,
				['@posZ']           = OutsideVehicles[plate].position.z,
				['@rotX']           = OutsideVehicles[plate].rotation.x,
				['@rotY']           = OutsideVehicles[plate].rotation.y,
				['@rotZ']           = OutsideVehicles[plate].rotation.z,
				['@modifications']  = json.encode(OutsideVehicles[plate].modifications),
				['@lastUpdate']     = OutsideVehicles[plate].lastUpdate
			})
			RefreshVehicles()
		end
	end
end)

RegisterNetEvent('MojiaGarages:server:setVehicleModsSuccess', function(plate)
	if (OutsideVehicles[plate]) then
		OutsideVehicles[plate].spawning = false
		OutsideVehicles[plate].spawningPlayer = nil
	end
end)

RegisterNetEvent('MojiaGarages:server:setVehicleModsFailed', function(plate)
	if (OutsideVehicles[plate] and OutsideVehicles[plate].handle and DoesEntityExist(OutsideVehicles[plate].handle)) then
		local networkOwner = -1
		while (networkOwner == -1) do
			Wait(0)
			networkOwner = NetworkGetEntityOwner(OutsideVehicles[plate].handle)
		end
		OutsideVehicles[plate].spawningPlayer = GetPlayerIdentifiersSorted(networkOwner)
		TriggerClientEvent('MojiaGarages:client:setVehicleMods', networkOwner, NetworkGetNetworkIdFromEntity(OutsideVehicles[plate].handle), plate, OutsideVehicles[plate].modifications)
	end
end)

RegisterNetEvent('MojiaGarages:server:syncPlayerPosition', function(position) -- sync player position
	activePlayerPositions[source] = position
end)

-- player disconnected
RegisterNetEvent('playerDropped', function(disconnectReason)
	activePlayerPositions[source] = nil
end)

RegisterNetEvent('MojiaGarages:server:removeOutsideVehicles', function(plate) -- Update car is outside
	OutsideVehicles[plate] = nil
end)

RegisterNetEvent('MojiaGarages:server:updateOusiteVehicles', function()
	MySQL.Async.fetchAll('SELECT vehicle, state, depotprice, plate, posX, posY, posZ, rotX, rotY, rotZ, mods, lastUpdate FROM player_vehicles', {}, function(results)
		if results then
			for k, v in pairs(results) do
				if v.state == 0 and v.depotprice == 0 then
					OutsideVehicles[v.plate] = {
						handle          = nil,
						model = v.vehicle,
						position        = vector3(v.posX, v.posY, v.posZ),
						rotation        = vector3(v.rotX, v.rotY, v.rotZ),
						modifications   = json.decode(v.mods),
						lastUpdate      = v.lastUpdate,
						spawning        = false,
						spawningPlayer  = nil
					}
				end
			end
		end
		CleanUp()
	end)
end)

RegisterNetEvent('MojiaGarages:server:UpdateGaragesZone', function() -- Update Garages
	local result = MySQL.Sync.fetchAll('SELECT * FROM houselocations', {})
	if result[1] then
		AllGarages = Garages
		for k, v in pairs(result) do
			local garage = json.decode(v.garage) or {}
			if v.garage ~= nil then
				AllGarages[v.name] = {
					label = v.label,
					spawnPoint = {
						vector4(garage.x, garage.y, garage.z, garage.h),
					},
					blippoint = vector3(garage.x, garage.y, garage.z),
					showBlip = true,
					blipsprite = 357,
					blipscale = 0.65,
					blipcolour = 3,
					job = nil, -- [nil: public garage] ['police: police garage'] ...
					fullfix = false, -- [true: full fix when take out vehicle]
					garastate = 1, -- [0: Depot] [1: Garage] [2: Impound]
					isHouseGarage = true,
					canStoreVehicle = true,
					zones = {
						vector2(garage.x1, garage.y1),
						vector2(garage.x2, garage.y2),
						vector2(garage.x3, garage.y3),
						vector2(garage.x4, garage.y4),
					},
					minz = garage.z - 1,
					maxz = garage.z + 3,
				}
			end
		end
		TriggerClientEvent('MojiaGarages:client:DestroyingZone', -1) -- Destroying all zone
		TriggerClientEvent('MojiaGarages:client:UpdateGaragesZone', -1, AllGarages) -- Reload garage information
	else
		TriggerClientEvent('MojiaGarages:client:DestroyingZone', -1) -- Destroying all zone
		TriggerClientEvent('MojiaGarages:client:UpdateGaragesZone', -1, Garages) -- Reload garage information
	end
end)

RegisterNetEvent('MojiaGarages:server:updateHouseKeys', function() --Update House Keys
	local HouseKeys = {}
	local src = source
	local Player = QBCore.Functions.GetPlayer(src)
	if Player then
		local identifier = Player.PlayerData.license
		local cid = Player.PlayerData.citizenid
		if AllGarages then
			for k, v in pairs(AllGarages) do
				if v.isHouseGarage then
					if Player.PlayerData.job.name == 'realestate' then
						HouseKeys[k] = true
					else
						HouseKeys[k] = exports['qb-houses']:hasKey(identifier, cid, k)
					end
				else
					HouseKeys[k] = false
				end
			end
			TriggerClientEvent('MojiaGarages:client:updateHouseKeys', source, HouseKeys)
		end
	end
end)

RegisterNetEvent('MojiaGarages:server:UpdateOutsideVehicles', function(Vehicles) -- Update car is outside
	local src = source
	local Player = QBCore.Functions.GetPlayer(src)
	local CitizenId = Player.PlayerData.citizenid
	Vehicles[CitizenId] = Vehicles
end)

RegisterNetEvent('MojiaGarages:server:updateVehicleState', function(state, plate, garage) -- Vehicle status update
	MySQL.Async.execute('UPDATE player_vehicles SET state = ?, garage = ?, depotprice = ? WHERE plate = ?',
	{
		state,
		garage,
		0,
		plate
	})
end)


RegisterNetEvent('MojiaGarages:server:PayDepotPrice', function(vehicle) -- Payment of vehicle fines
	local src = source
	local Player = QBCore.Functions.GetPlayer(src)
	local bankBalance = Player.PlayerData.money['bank']
	local cashBalance = Player.PlayerData.money['cash']
	MySQL.Async.fetchAll('SELECT * FROM player_vehicles WHERE plate = ?',
	{
		vehicle.plate
	}, function(result)
		if result[1] ~= nil then
			if bankBalance >= result[1].depotprice then
				Player.Functions.RemoveMoney('bank', result[1].depotprice, 'Paying fines for vehicle in the depot')
				TriggerClientEvent('MojiaGarages:client:doTakeOutVehicle', src, vehicle)
			elseif cashBalance >= result[1].depotprice then
				Player.Functions.RemoveMoney('cash', result[1].depotprice, 'Paying fines for vehicle in the depot')
				TriggerClientEvent('MojiaGarages:client:doTakeOutVehicle', src, vehicle)
			else
				TriggerClientEvent('QBCore:Notify', src, Lang:t('error.you_dont_have_enough_money'), 'error')
			end
		end
	end)
end)

RegisterNetEvent('MojiaGarages:server:DeleteVehicleKey', function(plate)
	local src = source
    local Player = QBCore.Functions.GetPlayer(src)
    if Player then
		local items = Player.Functions.GetItemsByName('vehiclekey')
		if items then
			for _, v in pairs(items) do
				if v.info.plate == plate then
					Player.Functions.RemoveItem(v.name, 1, v.slot)
					TriggerClientEvent('inventory:client:ItemBox', src, QBCore.Shared.Items[v.name], 'remove')
				end
			end
		end
    end
end)

AddEventHandler('onResourceStart', function(resource)
	if resource == GetCurrentResourceName() then
		Wait(100)
		if Realparking then
			print("Respawning cars")
		else
			local price = Realdepot
			MySQL.Async.execute('UPDATE player_vehicles SET state = ?, depotprice = ? WHERE state = 0 AND depotprice = 0', 
			{0, price})
		end
	end
end)

--Thread
CreateThread(function() -- Update data
	while true do
		if not dataLoaded then
			dataLoaded = true
			TriggerEvent('MojiaGarages:server:updateHouseKeys')
			TriggerEvent('MojiaGarages:server:UpdateGaragesZone')
			TriggerEvent('MojiaGarages:server:updateOusiteVehicles')
		end
		Wait(1000)
	end
end)

--[[
CreateThread(function() -- loop to spawn vehicles near players
	while (true) do		
		if (GetActivePlayerCount() > 0) then
			TrySpawnVehicles()
		end
		Wait(1000)
	end
end)
]]--

QBCore.Functions.CreateCallback('MojiaGarages:server:getOusiteVehicle', function(source, cb)
	MySQL.Async.fetchAll('SELECT * FROM player_vehicles WHERE state = ? AND depotprice = ?',
		{
			0,
			0
		}, function(result)
		if result then
			 cb(result)
		else
			cb(false)
		end
	end)
end)

QBCore.Functions.CreateCallback("MojiaGarages:server:getPlayerIdentifier", function(source, cb)
	local src = source
    local Player = QBCore.Functions.GetPlayer(src)
    if Player then
		local playerId = Player.PlayerData.citizenid
		if type(playerId) ~= 'nil' then
			cb(playerId)
		end
    end
end)

function RefreshVehicles()
	local vehicles = {}
	local result = MySQL.Sync.fetchAll('SELECT * FROM player_vehicles WHERE state = ? AND depotprice = ?', {0, 0})
	if result then
		for k, v in pairs(result) do
			local vehspawned = true
			local loadedVehicles = GetAllVehicles()
			local loadedVehicle = TryGetLoadedVehicle(v.plate, loadedVehicles)
			if loadedVehicle ~= nil then -- vehicle found
				vehspawned = true
			else
				vehspawned = false
			end
			vehicles[v.plate] = {
				model = v.vehicle,
				position = vector3(v.posX, v.posY, v.posZ),
				rotation = vector3(v.rotX, v.rotY, v.rotZ),
				mods = json.decode(v.mods),
				spawned = vehspawned
			}
		end
		TriggerClientEvent("MojiaGarages:client:refreshVehicles", -1, vehicles)		
	end
end

RegisterNetEvent('MojiaGarages:server:refreshVehicles', function()
	RefreshVehicles()
end)

RegisterNetEvent('MojiaGarages:server:updateVehicleKey', function()
	TriggerClientEvent('MojiaGarages:client:updateVehicleKey', -1) -- Update vehicle key for qb-vehiclekey
end)