Whitelist ESX jobs

FiveM Resource Development & Modding Modding Tutorials
, ,
21

Thats why they have to make a new character

22

that doesnt help you still have the same job.

23

I do have custom script for that :wink:

24

Is there any plan to release that script? It would be really nice to be able to whitlist certain players so they pick roles and come and go as they please.

25

NICE! good job man i love it

26

im getting this error

[ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM jobs WHERE whitelisted = false {=}”: Unknown column ‘whitelisted’ in ‘where clause’

how do i fix this???

27

Add column whitelisted in your sql table…

28

how would i go about doing that?

29

mysql%20error
mysql%20error1240×95 4.28 KB

this is the error code i get when i go to select a job does anyone know how i can fix this

30

read the description …

ALTER TABLE jobs add whitelisted BOOLEAN NOT NULL DEFAULT FALSE;
31

i dont have the file esx_joblisting_sv.lua in my resources/esx_joblisting/server
where can i find it? or find one?
can you paste the file so i can make one please?

32

are you sure you looked at joblisting look at here path and file

image
image747×128 7.43 KB

33

i dont have that file at all… can you paste the code here i will make a file with it…

i only have main.lua

34

on the new version the file name is main.lua

line 6

35

ok i have the line 6.

‘SELECT * FROM jobs WHERE whitelisted = false’,… what is wrong with it? why the console say:

ERROR] [MySQL] An error happens on MySQL for query “SELECT * FROM jobs WHERE whitelisted = false {=}”: Unknown column ‘whitelisted’ in ‘where clause’

when i try to select a job it says that…

36

okay i got it working by modifying the line 6 to:

SELECT * FROM essentialmode.jobs;

37 
ALTER TABLE jobs add whitelisted BOOLEAN NOT NULL DEFAULT FALSE;
38

Hey guys, can someone tell me how to add a player to a whitelisted job? I am using the setjob command but it says I have insufficient permissions to add a player to the police. I’m set as an admin both in the user table and in the ace permissions of server.cfg. How can I get permissions to add players to the jobs?

39

put yourself superadmin and you’ll be able to setjob someone. and to whitelist a job, go into your db and put a 1 in the whitelisted column in jobs

40

So the only way for someone to do a whitelisted job is to run the /setjob command? Is there to add someone to a whitelist essentially and they can get the job as they choose? What if no superadmins are online, how would one go on duty as an officer?

Thanks!