# Integration

## Enter House

{% tabs %}
{% tab title="Client" %}

```lua
TriggerEvent('ak47_qb_housing:enterhouse', houseid)
```

{% endtab %}

{% tab title="Server" %}

```lua
TriggerClientEvent('ak47_qb_housing:enterhouse', source, houseid)
```

{% endtab %}
{% endtabs %}

## Set Vehicle Fuel

Path: ak47\_qb\_housing/modules/garage/client/customizable.lua

<figure><img src="https://2088945756-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkHcyR2RbVMcj5NHJ2HEa%2Fuploads%2FzPLRMKBlfBRXF4mt8CCB%2Fimage.png?alt=media&#x26;token=fb710e5c-90ec-482c-9f27-b6473688049c" alt=""><figcaption></figcaption></figure>

## Give Key

Path: ak47\_qb\_housing/modules/garage/client/customizable.lua\
Set your export or trigger here to give vehicle key

<figure><img src="https://2088945756-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkHcyR2RbVMcj5NHJ2HEa%2Fuploads%2FzQe4QeF9ZogJ8BwmjyIr%2Fimage.png?alt=media&#x26;token=9b8290db-205f-4a70-b650-8ffef75483e5" alt=""><figcaption></figcaption></figure>

## Garage Triggers

Path: ak47\_qb\_housing/modules/garage/client/customizable.lua

<figure><img src="https://2088945756-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkHcyR2RbVMcj5NHJ2HEa%2Fuploads%2FWkZTglhV0a9h4jrWPXYI%2Fimage.png?alt=media&#x26;token=dbda8ad2-4456-4d1a-8dd2-fc46552b0e3d" alt=""><figcaption></figcaption></figure>

### PS-MDT

Path: ps-mdt/server/dmb.lua

Replace: GetPlayerProperties

```lua
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

```lua
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

```lua
-- 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
```