[Release] Jobs System v2.1 and Paycheck v2.1

Download it ? maybe lmao

1 Like

I see the function but i don’t know how to use it in client script

local executed_query = MySQL:executeQuery("SELECT salary FROM users INNER JOIN jobs ON users.job = jobs.job_id WHERE identifier = '@username'",{['@username'] = user_id})

Me don’t work , i use french version i click to policier , mineur and taxi don’t work do nothing. Why?

They work but only as a paycheck you need freeroam for notification. I ll release an update of this system in like a week stay tuned

im having a issue where i cant select a job from the list, why could this be?

Update your database, or redownload the script

I am having a issue when trying to add the SQL to my database I get this error.

[Err] 1146 - Table ‘gta5_gamemode_essential.jobs’ doesn’t exist
[Err] –
– Base de donnĂ©es : gta5_gamemode_essential

INSERT INTO jobs (job_id, job_name, salary)
VALUES (1, ‘Unemployed’,500),(2, ‘Cop’, 1200),(3, ‘Fireman’, 1200),(4, ‘Minor’, 700),(5, ‘Taxi driver’, 1000);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/
!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/
!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
[Msg] Finished - Unsuccessfully

Make sure you have a table named jobs in gta5_gamemode_essential database

The error is literally telling you what the issue is
 The “jobs” table doesn’t exist


You should’ve ran the “jobs.sql” file before the other one.

Hey thanks for all your work, it’s great!
Wondering if you are going to implement this into a gui?
Thought that’s what your github said.

Thanks

It have already a GUI

Should my jobs in user tab be set to Null = Yes and Default =1?

Hi, thx for this beautiful release.
Is it possible to display the job in the hud below the display of money ? If someone has a script for it :slight_smile:

+1 i am looking for this. I know that someone did it with essentialmode But the code is link to job in user table or WE need it to be link to job_name in job table you Can see the code here :

In order to display the job name we need to add events for when the job changes

Hello really good script, but why when we disconnect and reconnect we always having a random job on the
corner below the money?

1 Like

up please if someone knows ?

That’s a problem with the HUD script, not this script. Check your DB and paycheck amount, they are correct. The HUD simply displays the wrong job.

Does this work with essistenal mod 3.0 with couchdb?

How make a permission to have a job with this system ?