[Release] PD Impound [ESX]

roleplay
police
fivem-scripts
release
server

#44

Hi when i press pay to retrieve vehicle nothing happens and no errors


#45

would not have put to the vehicle when it is imprisoned in the impound, be deleted from the garage …

type this example I saw in another script.

  -- Insert vehicle into impound table
  MySQL.Async.execute("INSERT INTO `impounded_vehicles` (`vehicle`, `owner`, `impounded_at`) VALUES(@vehicle, @owner, @timestamp)", {['@vehicle'] = vehicle.vehicle, ['@owner'] = vehicle.owner, ['@timestamp'] = current_time})

  -- Delete vehicle from garage
  MySQL.Async.execute("DELETE FROM owned_vehicles WHERE plate=@plate LIMIT 1", {['@plate'] = vehicle.plate})

  -- Insert vehicle into owned_vehicles table
  MySQL.Async.execute("INSERT INTO `owned_vehicles` (`vehicle`, `state`, `owner`) VALUES(@vehicle, '0', @owner)", {['@vehicle'] = vehicle.vehicle, ['@owner'] = vehicle.owner})

  -- Delete vehicle from Impound Lot
  MySQL.Async.execute("DELETE FROM impounded_vehicles WHERE id=@id LIMIT 1", {['@id'] = vehicle.id})

#46

I’ll look into it once i’ve got the time. Thanks for your feedback.


#47

Is there anyone that can explain step by step how to install this with esx_migrate?

When I got to impound a vehicle it says unknown owner after i just bought it from the dealership.


#48

install the new vehicle shop, which is already updated with a new


#49

do you have a link to it?


#50

#51

If this top vehicheshop has bugged you in the hall of the car shop. This vehicle shop is not bugged in the middle of the car show…

esx_vehicleshop.rar (99.1 KB)


#53

You received this error when opening AND attempting to attach vehicle


Can someone help me please?


#54

Hi,

it’s pretty self-explanatory. It seems that the column “plate” is missing in your table. “owned_vehicles”


#55

When I open, I can not close the window.
What could be wrong?