How to create a job in ESX Legacy

The problem

You want to add a new job (for example, fisherman) to your ESX server and have it show up with its grades and salaries.

The cause

Jobs in ESX live in the `jobs` and `job_grades` tables. If you don't insert both correctly, the job doesn't exist or has no ranks.

The solution

Insert the job and its grades into the database:

-- Job
INSERT INTO jobs (name, label) VALUES ('pescador', 'Fisherman');

-- Grades (grade, salary, labels)
INSERT INTO job_grades (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
('pescador', 0, 'novato',   'Rookie',   200, '{}', '{}'),
('pescador', 1, 'experto',  'Expert',   400, '{}', '{}'),
('pescador', 2, 'capitan',  'Captain',  700, '{}', '{}');

Step by step

1. 1.Run the SQL on your database (phpMyAdmin, HeidiSQL or the CLI).
2. 2.Assign the job to a player with `/setjob ID pescador 0` (as admin) or from your jobs menu.
3. 3.For the job logic (zones, delivery payouts), validate the payments on the server.
4. 4.Want the full job script? Ask the Crxative-M AI tool for it.

Related guides