Download it ? maybe lmao
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
+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?
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 ?