# lb-phone

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

1. Navigate to `lb-phone/server/custom/frameworks/esx/vehicles.lua`
2. Replace function `GetPlayerVehicles` with this:<br>

   ```lua
   function GetPlayerVehicles(source)
       local toSend = {}
       local vehicles = MySQL.query.await("SELECT * FROM owned_vehicles WHERE owner = ? ", { GetIdentifier(source) })

       for i = 1, #vehicles do
           local vehicle = vehicles[i] or {}

           if vehicle.stored == nil then
               vehicle.stored = vehicle.state
           end

           local impounded = false

           if type(vehicle.stored) ~= "boolean" then
               impounded = vehicle.stored == 2
               vehicle.stored = vehicle.stored == 1
           end

           if GetResourceState("cd_garage") == "started" then
               debugprint("Using cd_garage")

               impounded = vehicle.in_garage == 2
               vehicle.stored = vehicle.in_garage or vehicle.in_garage == 1
               vehicle.garage = vehicle.garage_id
               vehicle.type = vehicle.garage_type
           elseif GetResourceState("loaf_garage") == "started" then
               vehicle.stored = 1
           elseif GetResourceState("jg-advancedgarages") == "started" then
               debugprint("Using jg-advancedgarages")

               vehicle.stored = vehicle.in_garage
               vehicle.garage = vehicle.garage_id

               impounded = vehicle.impound == 1

               if impounded and vehicle.impound_data then
                   vehicle.stored = false
                   vehicle.pound = "Impound"

                   local impoundInfo = json.decode(vehicle.impound_data)

                   vehicle.impoundReason = impoundInfo and {
                       reason = impoundInfo.reason and #impoundInfo.reason > 0 and impoundInfo.reason or nil,
                       retrievable = ConvertJSTimestamp and ConvertJSTimestamp(impoundInfo.retrieval_date) or nil,
                       price = impoundInfo.retrieval_cost,
                       impounder = impoundInfo.charname
                   }
               end
           elseif GetResourceState("op-garages") == "started" then
               debugprint("Using op-garages")
               vehicle.stored = not vehicle.stored

               local garage = exports['op-garages']:getGarageByIndex(tostring(vehicle.vehicleGarage))
               vehicle.garage = garage and garage.Label or "Garage"

               if vehicle.isTowedOut then
                   local impound = exports['op-garages']:getImpoundByIndex(tostring(vehicle.vehicleImpound))
                   vehicle.stored = false
                   vehicle.pound = impound and impound.Label or "Impound"

                   vehicle.impoundReason = {
                       reason = vehicle.impoundReason,
                       retrievable = vehicle.retrievable,
                       price = vehicle.towedPrice,
                       impounder = vehicle.towedOutBy
                   }
               end
           end

           if GetResourceState("qs-advancedgarages") == "started" then
               vehicle.stored = vehicle.garage ~= "OUT"
           end

           local location = vehicle.stored and (vehicle.garage or "Garage") or "out"

           if impounded and vehicle.pound then
               location = vehicle.pound
           end

           ---@type VehicleData
           local newCar = {
               plate = vehicle.plate,
               type = vehicle.type,
               location = location,
               impounded = impounded,
               statistics = {},
               impoundReason = vehicle.impoundReason
           }

           if vehicle.damages then
               local damages = json.decode(vehicle.damages)

               if damages?.engineHealth then
                   newCar.statistics.engine = math.floor(damages.engineHealth / 10 + 0.5)
               end

               if damages?.bodyHealth then
                   newCar.statistics.body = math.floor(damages.bodyHealth / 10 + 0.5)
               end
           end

           local vehicleMods = json.decode(vehicle.vehicle)

           if vehicleMods.fuel then
               newCar.statistics.fuel = math.floor(vehicleMods.fuel + 0.5)
           end

           newCar.model = vehicleMods.model

           toSend[#toSend+1] = newCar
       end

       return toSend
   end
   ```
3. Replace function `GetVehicle` with this:<br>

   ```lua
   function GetVehicle(source, plate)
       local storedCheck = "`%s` = ?"
       local storedColumn = "stored"

       ---@type any
       local storedValue = 1

       ---@type any
       local outValue = 0

       if GetResourceState("cd_garage") == "started" or GetResourceState("jg-advancedgarages") == "started" then
           storedColumn = "in_garage"
       elseif GetResourceState("qs-advancedgarages") == "started" then
           storedCheck = "`%s` != ?"
           storedColumn = "garage"
           storedValue = "OUT"
           outValue = "OUT"
       elseif GetResourceState("op-garages") == "started" then
           storedValue = 0
           outValue = 1
       end

       storedCheck = storedCheck:format(storedColumn)

       local vehicle = MySQL.single.await(
           "SELECT * FROM owned_vehicles WHERE owner = ? AND plate = ? AND " .. storedCheck,
           { GetIdentifier(source), plate, storedValue }
       )

       if not vehicle then
           return
       end

       MySQL.update(
           "UPDATE owned_vehicles SET `" .. storedColumn .. "` = ? WHERE plate = ?",
           { outValue, plate }
       )

       vehicle.model = json.decode(vehicle.vehicle).model

       return vehicle
   end
   ```

{% endtab %}

{% tab title="QB/QBOX" %}

1. Navigate to `lb-phone/server/custom/frameworks/qbcore/vehicles.lua` OR `lb-phone/server/custom/frameworks/qbox/vehicles.lua`
2. Replace function `GetPlayerVehicles` with this:<br>

   ```lua
   function GetPlayerVehicles(source)
       local toSend = {}
       local vehicles = MySQL.query.await(
           "SELECT * FROM player_vehicles WHERE citizenid = ?",
           { GetIdentifier(source) }
       )

       for i = 1, #vehicles do
           local vehicle = vehicles[i] or {}

           if GetResourceState("cd_garage") == "started" then
               vehicle.state = vehicle.in_garage
               vehicle.garage = vehicle.garage_id
               vehicle.type = vehicle.garage_type
           elseif GetResourceState("loaf_garage") == "started" then
               vehicle.state = 1
           elseif GetResourceState("jg-advancedgarages") == "started" then
               vehicle.state = vehicle.in_garage
               vehicle.garage = vehicle.garage_id

               if vehicle.impound == 1 and vehicle.impound_data then
                   vehicle.state = 2
                   vehicle.garage = "Impound"

                   local impoundInfo = json.decode(vehicle.impound_data)

                   vehicle.impoundReason = impoundInfo and {
                       reason = impoundInfo.reason and #impoundInfo.reason > 0 and impoundInfo.reason or nil,
                       retrievable = ConvertJSTimestamp and ConvertJSTimestamp(impoundInfo.retrieval_date) or nil,
                       price = impoundInfo.retrieval_cost,
                       impounder = impoundInfo.charname
                   }
               end
           elseif GetResourceState("qs-advancedgarages") == "started" then
               if vehicle.type == "vehicle" then
                   vehicle.type = "car"
               end
           elseif GetResourceState("op-garages") == "started" then
               debugprint("Using op-garages")
               vehicle.state = not vehicle.state

               local garage = exports['op-garages']:getGarageByIndex(tostring(vehicle.vehicleGarage))
               vehicle.garage = garage and garage.Label or "Garage"

               if vehicle.isTowedOut then
                   local impound = exports['op-garages']:getImpoundByIndex(tostring(vehicle.vehicleImpound))
                   vehicle.state = false
                   vehicle.pound = impound and impound.Label or "Impound"

                   vehicle.impoundReason = {
                       reason = vehicle.impoundReason,
                       retrievable = vehicle.retrievable,
                       price = vehicle.towedPrice,
                       impounder = vehicle.towedOutBy
                   }
               end
           end

           local location = vehicle.garage or "Garage"

           if vehicle.state == 0 then
               location = "out"
           elseif vehicle.state == 1 or vehicle.state == true then
               location = vehicle.garage or "Garage"
           elseif vehicle.state == 2 then
               location = vehicle.garage or "Impound"
           end

           ---@type VehicleData
           local newCar = {
               plate = vehicle.plate,
               type = QB.Shared.Vehicles[vehicle.hash]?.category or vehicle.type or "car",
               location = location,
               impounded = vehicle.state == 2,
               statistics = {
                   engine = math.floor(vehicle.engine / 10 + 0.5),
                   body = math.floor(vehicle.body / 10 + 0.5),
                   fuel = vehicle.fuel
               },
               impoundReason = vehicle.impoundReason
           }

           newCar.model = tonumber(vehicle.hash) --[[@as number]]

           toSend[#toSend+1] = newCar
       end

       return toSend
   end
   ```
3. Replace function `GetVehicle` with this:<br>

   ```lua
   function GetVehicle(source, plate)
       local storedColumn = "state"
       local storedValue = 1
       local outValue = 0

       if GetResourceState("cd_garage") == "started" or GetResourceState("jg-advancedgarages") == "started" then
           storedColumn = "in_garage"
       elseif GetResourceState("op-garages") == "started" then
           storedValue = 0
           outValue = 1
       end

       local vehicle = MySQL.single.await(([[
           SELECT plate, mods, `hash`, fuel
           FROM player_vehicles
           WHERE citizenid = ? AND plate = ? AND `%s` = ?
       ]]):format(storedColumn), { GetIdentifier(source), plate, storedValue })

       if not vehicle then
           return
       end

       MySQL.update(
           "UPDATE player_vehicles SET `" .. storedColumn .. "` = ? WHERE plate = ?",
           { outValue, plate }
       )

       vehicle.model = tonumber(vehicle.hash)

       return vehicle
   end
   ```

{% endtab %}
{% endtabs %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.otherplanet.dev/scripts/op-garages-v2/script-integrations/lb-phone.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.