-- add inside Characters.ConvertProperties function
if GetResourceState('ak47_housing') == 'started' then
local identifier = Config.Prefix..''..charId..':'..identifier
local query = "SELECT * FROM `ak47_housing` WHERE `owner` = ?"
local response = MySQL.query.await(query, {identifier})
if response and response[1] then
for k,v in ipairs(response) do
local coords = json.decode(v.enter)
properties['house_'..v.id] = {
name = 'house_'..v.id,
type = "property",
label = 'House:'..v.id,
coords = vector3(coords.x, coords.y, coords.z),
}
end
end
end
