ESX

ESX jobs: add and edit jobs

A job in ESX is a role a player can hold, like police or mechanic. Each job has grades, which are the ranks inside that job, like Cadet then Officer then Chief. The big difference from QBCore: ESX does not store jobs in a jobs.lua file. ESX stores them in your SQL database, the place your server saves all its data. You add a job by inserting rows into two tables, then restarting. This lesson shows you those tables and the exact statements to run.

You'll do: Learn where ESX keeps jobs (the SQL database, not a Lua file), read the jobs and job_grades tables, write INSERT statements to add a new job with its grades, restart, then assign the job with /setjob and xPlayer.setJob in code.
Time: ~20 minutes.
You need: A running ESX Legacy server with es_extended, and a database client (HeidiSQL or DBeaver) connected to your fivem database.
Result: A new job that appears in game, with grades you can assign to any player.

BEFORE YOU START

The two tables

ESX keeps every job in two tables in your fivem database. A table is a grid of rows and columns, like a spreadsheet sheet.

The table holds one row per job. It is the short list of what jobs exist.

Column	Type	Description
`name`	string	The internal job id. Lowercase, no spaces, for example `police`. Code uses this.
`label`	string	The display name shown to players, for example `Police`.
`whitelisted`	number	`1` if only whitelisted players may take the job, `0` for open. Defaults to `0`, so you can leave it out of a basic insert.
`type`	string	A category tag (for example `civ`). Defaults to `'civ'`, so you can leave it out of a basic insert.

Column	Type	Description
`id`	number	Auto-numbered primary key. ESX fills it in for you, so leave it out of your inserts.
`job_name`	string	Which job this grade belongs to. Must match a `name` in the `jobs` table exactly.
`grade`	number	The rank level. Starts at `0` and goes up with no gaps: `0`, `1`, `2`.
`name`	string	The internal grade id, for example `recruit`. Lowercase, no spaces.
`label`	string	The display name of the rank, for example `Recruit`.
`salary`	number	The paycheck amount paid for this grade.
`skin_male`	text	Uniform outfit for male peds, stored as JSON. This column is NOT NULL, so always provide a value; use `{}` if you do not set one.
`skin_female`	text	Uniform outfit for female peds, stored as JSON. This column is NOT NULL, so always provide a value; use `{}` if you do not set one.

The two tables

Keep reading the full lesson