server.lua

Citizen.CreateThread(function()
	local HouseGarages = {}
	local result = exports.ghmattimysql:executeSync('SELECT * FROM houselocations')
	if result[1] ~= nil then
		for k, v in pairs(result) do
			local owned = false
			if tonumber(v.owned) == 1 then
				owned = true
			end
			local garage = v.garage ~= nil and json.decode(v.garage) or {}
			Config.Houses[v.name] = {
				coords = json.decode(v.coords),
				owned = v.owned,
				price = v.price,
				locked = true,
				adress = v.label, 
				tier = v.tier,
				garage = garage,
				decorations = {},
			}
			HouseGarages[v.name] = {
				label = v.label,
				takeVehicle = garage,
			}
		end
	end
	TriggerClientEvent("qb-garages:client:houseGarageConfig", -1, HouseGarages)
	TriggerClientEvent("qb-houses:client:setHouseConfig", -1, Config.Houses)
end)

QBCore.Functions.CreateCallback('qb-spawn:server:getOwnedHouses', function(source, cb, cid)
	if cid ~= nil then
		local houses = exports.ghmattimysql:executeSync('SELECT * FROM player_houses WHERE citizenid=@citizenid', {['@citizenid'] = cid})
		if houses[1] ~= nil then
			cb(houses)
		else
			cb(nil)
		end
	else
		cb(nil)
	end
end)