lb-phone

lb-phone integration tutorial.

ESX

1. Navigate to lb-phone/server/custom/frameworks/esx/vehicles.lua

2. Replace function GetPlayerVehicles with this:

   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 = GlobalState.garages[tostring(vehicle.vehicleGarage)]
               vehicle.garage = garage and garage.Label or "Garage"
   
               if vehicle.isTowedOut then
                   local impound = GlobalState.impounds[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:

   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

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:

   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 = GlobalState.garages[tostring(vehicle.vehicleGarage)]
               vehicle.garage = garage and garage.Label or "Garage"
   
               if vehicle.isTowedOut then
                   local impound = GlobalState.impounds[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 = "unknown"
   
           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:

   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