Track 2 · Pro Path

Vehicles & garages

A garage is a valet with a clipboard. The clipboard is your database. The plate is the ticket. Owning a vehicle in FiveM is not the spawned car on the street, it is a row in a table: a unique plate, a model, and a state column that records whether the car is out right now or sitting in the garage. This lesson builds the full take and store flow, then takes it apart so you understand why the plate is the key and why the state column, not the spawning, is the actual garage.

You'll learn: Plate as primary key, the garage state column, the take/store lifecycle, CreateVehicleServerSetter, parameterized upserts
Time: ~24 minutes
Prereqs: P1 (oxmysql + a MariaDB database), P7 (OneSync enabled)
Outcome: A working garage where /takecar spawns and persists a car by plate, and /storecar flips its state back and despawns it

BEFORE YOU START

Build it

Make the resource folder

The server has one folder for this lesson.

Inside your server's resources folder, create this folder:

code

resources/qu_vehicles_garages

Vehicles & garages

Build it

Make the resource folder

Create the files

Write fxmanifest.lua

Create the table

Write the lesson code

Start and test it

Keep reading the full lesson