[Release] [ESX] ESX_JobWhitelisting - Whitelist jobs (and ranks!) to certain players!

FiveM Resource Development & Modding Releases
, ,
22

I too am having the exact same issue.

23

Perhaps the SQL was not imported properly?

24

I have installed everything well

25

ive never understood why someone would add use essentialmode to a sql it always denies permisssion to it so why bother adding it at all ?

26

I did not quite understand the functionality of this script, can anyone give me an example of what time I would use it?

27

If you have whitelisted jobs, such as police or EMS, and you don’t want said jobs to be in the job center for everyone, previously you would have to use the /setjob command to set their job every time the player wants to go on duty. With this script, you can make those jobs show up in the job center for only the people that are whitelisted for them. It’s actually really handy

1 Like
28

Thanks, this is very interesting

29

If your db is named essentialmode then it wouldn’t. :stuck_out_tongue:

3 Likes
30

I could be wrong but shouldn’t the ranks be NOT NULL?

USE `essentialmode`;

CREATE TABLE IF NOT EXISTS `characters` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`identifier` VARCHAR(255) NOT NULL,
	`firstname` VARCHAR(255) NOT NULL,
	`lastname` VARCHAR(255) NOT NULL,
	`dateofbirth` VARCHAR(255) NOT NULL,
	`sex` VARCHAR(1) NOT NULL DEFAULT 'M',
	`height` VARCHAR(128) NOT NULL,
	PRIMARY KEY (`id`)
);

ALTER TABLE `characters` ADD COLUMN IF NOT EXISTS (
`ems_rank`  int(11) NOT NULL DEFAULT '-1',
`leo_rank`  int(11) NOT NULL DEFAULT '-1',
`tow_rank`  int(11) NOT NULL DEFAULT '-1'
);
32

Im getting this error, can someone help me pls?

33

did u fix the error?

34

I am trying to add the cardealer_rank column to the Characters Table and it will not appear in the Job Listings, is there something else I need to edit/add?

35

Yup that will be in the server Lua. If you need any help feel free to DM me on discord HaxersAlwaysWin 7078

36

When I go to the job center and press E it opens the menu twice. What should I do?

37

If you haven’t deleted esx_joblisting, you’ll need to remove that as this script is a complete replacement for it

38

better late than never i just remove this line USE essentialmode ;
with Sublime or notepad++ then inject it, as i do with all of my SQL files for Zap
as they already have the data base set they dont allow use essential mode hop this helps

39

Not sure why people use ZAP anyway, it’s not even worth your time in my opinion. But glad you got it fixed

40

when i use this:
USE essentialmode;

CREATE TABLE IF NOT EXISTS characters (
id int(11) NOT NULL AUTO_INCREMENT,
identifier VARCHAR(255) NOT NULL,
firstname VARCHAR(255) NOT NULL,
lastname VARCHAR(255) NOT NULL,
dateofbirth VARCHAR(255) NOT NULL,
sex VARCHAR(1) NOT NULL DEFAULT ‘M’,
height VARCHAR(128) NOT NULL,
PRIMARY KEY (id)
);

ALTER TABLE characters ADD COLUMN IF NOT EXISTS (
ems_rank int(11) NULL DEFAULT ‘-1’,
leo_rank int(11) NULL DEFAULT ‘-1’,
tow_rank int(11) NULL DEFAULT ‘-1’
);

i get this error:
SQL-query:

``

ALTER TABLE `characters` ADD COLUMN IF NOT EXISTS (
`ems_rank`  int(11) NULL DEFAULT '-1',
`leo_rank`  int(11) NULL DEFAULT '-1',
`tow_rank`  int(11) NULL DEFAULT '-1'
)

MySQL meldt: Documentatie

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS (ems_rank int(11) NULL DEFAULT '-1',leo_rank int(11) NUL' at line 1

41

ALTER TABLE characters ADD COLUMN (
ems_rank int(11) NULL DEFAULT ‘-1’,
leo_rank int(11) NULL DEFAULT ‘-1’,
tow_rank int(11) NULL DEFAULT ‘-1’
);

That fixed it for me.

1 Like
43

I am getting a error cause of the resource file is there a way to fix that