function GetPlayerProperties(cid, cb)
local data = MySQL.query.await('SELECT id, enter FROM ak47_qb_housing where owner = ?', {cid})
local result = {}
for i, v in pairs(data) do
table.insert(result, {
label = 'HID: '..v.id,
coords = json.encode({enter = json.decode(v.enter)})
})
end
return result
end
Path: ps-mdt/server/main.lua
Replace: GetPlayerPropertiesByCitizenId
function GetPlayerPropertiesByCitizenId(citizenid)
local properties = {}
local result = MySQL.Sync.fetchAll("SELECT * FROM ak47_qb_housing WHERE owner = @citizenid", {
['@citizenid'] = citizenid
})
if result and #result > 0 then
for i = 1, #result do
table.insert(properties, {
label = 'HID: '..result[i].id,
coords = json.encode({enter = json.decode(result[i].enter)})
})
end
end
return properties
end
ZSX_Multicharacter
-- add inside Characters.ConvertProperties function
if GetResourceState('ak47_qb_housing') == 'started' then
local citizenResponse = MySQL.query.await("SELECT `citizenid` FROM `players` WHERE `license` LIKE '%"..identifier.."' AND `cid` = ?", {charId})
local identifier = citizenResponse[1].citizenid
local query = "SELECT * FROM `ak47_qb_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
