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

[CrimePays]

no we need to ask the maker of this script to convert it to 3.0

[ChocoBoyFr_Games]

+1 I have the same problem, impossible to harvest items as long as blips does not appear on the map.

[PandaBasketteur]

I am not yet at 3.0, and for now I do not intend to go there.

[Day_Field]

@PandaBasketteur Hello ! Is there a way to hide/show a job in the selection only if the player is whitelisted (i use cops five m and want to hide “policier” for all non policer. ty

[PandaBasketteur]

It’s simple, you make an event that you call as you like, a server event (before adding the buttons), you verify if it has the right to take with a request … Simple (SELECT)

If the table is not null you return true (or equal to a number, short condition) otherwise false.

You return this value to the client event by not forgetting the source, and then you add conditions by adding buttons only if the send value is true or false.

Putting words in French is not optimizing… xD

[ZenKo]

Possible to add the work in the hud at the top right ?

[Emrys]

I want to close the menu of job, after selecting one of them, it’s possible please ?

[PandaBasketteur]

In function changeJob add : Menu.hidden = not Menu.hidden

[Galardowyn]

Hello, I’m looking for a way to give some prime to some people of my server . And those prime will change based on their behavior so that needs to be per person and variable . I tried to change your sql query in paycheck from INNER JOIN to FULL JOIN and adding a salary column in users but it doesnt . Any idea to help me ?

In case you are french

J’essaye d’octroyer des primes à certains joueurs avec votre script paycheck . Pour se faire j’ai créé une colone salary dans la table users en plus de celle dans jobs et j’ai remplace votre query INNER JOIN en FULL JOIN , espérant que cela allait combiné les 2 montants . Ca ne fonctionne malheureusement pas . Il me faudrait donc un peu d’aide . Cette prime devrait etre modifiable et assigné à un seul joueur et devrait se rajouter au salaire lié à son job .

Thanks / Merci

[Scapin]

don"t work for me Someone work for him ?

[PandaBasketteur]

function changeJob(id)
  TriggerServerEvent("jobssystem:jobs", id)
  Menu.hidden = not Menu.hidden
  Menu.renderGUI()
end

Full code

[PandaBasketteur]

Full join is not the solution, you must add a “prime” table is make a code like this :

local executed_query = MySQL:executeQuery("SELECT salary,prime FROM users INNER JOIN jobs ON users.job = jobs.job_id WHERE identifier = '@username'",{['@username'] = user_id})
    local result = MySQL:getResults(executed_query, {'salary','prime'})
    local salary_job = result[1].salary
    local prime = result[1].prime
  	user:addMoney((salary + prime + salary_job))

You can do even better:

local executed_query = MySQL:executeQuery("SELECT salary,prime FROM users INNER JOIN jobs ON users.job = jobs.job_id WHERE identifier = '@username'",{['@username'] = user_id})
    local result = MySQL:getResults(executed_query, {'salary','prime'})
    local salary_job = result[1].salary
    if result[1].prime then
	    local prime = result[1].prime
	  	user:addMoney((salary + prime + salary_job))
	 	TriggerClientEvent("es_freeroam:notify", source, "CHAR_BANK_MAZE", 1, "Maze Bank", false, "Prime reçu : " .. prime .. "~g~€~s~~n~Salaire reçu :  + "..salary.."~g~€~s~~n~Salaire metier reçu : + "..salary_job.." ~g~€")
	else
	  	user:addMoney((salary + salary_job))
	 	TriggerClientEvent("es_freeroam:notify", source, "CHAR_BANK_MAZE", 1, "Maze Bank", false, "Salaire reçu :  + "..salary.."~g~€~s~~n~Salaire metier reçu : + "..salary_job.." ~g~€")
	end

Here.

(If the query does not work, replace SELECT salary, prime by SELECT salary, users.prime but … normally no query problem since you do not have prime tables in the table jobs so no conflict)

[bFe]

I got one problem. I select the jobs using the menu but nothing happens.
I get no confirmation or anything. In the DB it says in the users table that my job id is 4, which should be correct.

And yes, I do have the jobs table also.

Any tips?

Edit: When I do /job list I only have the default ones, not miner or cab driver.

[Galardowyn]

Thanks a lot mate . I added a table prime to users and I’m gonna try now .

[Emrys]

Works fine, thank you bro

function menuJobs()
  MenuTitle = "Jobs"
  ClearMenu()
  for _, item in pairs(jobs) do
    local nameJob = item.name
    local idJob = item.id
    Menu.addButton(nameJob,"changeJob",idJob)
  end
end

function changeJob(id)
  TriggerServerEvent("jobssystem:jobs", id)
  Menu.hidden = not Menu.hidden
end

[Manny]

Anyone got a working Paycheck v1.0? i’ve set mine up with couchDB so i think i need that version but there’s nothing on @PandaBasketteur git.

[PandaBasketteur]

I know, i’m not going to do update for DB layer simply because i would not pass for the moment to this method, i prefer MySQL which holds for the moment the road with 24 slots.

[Rhodiniium]

Getting this issue, Not sure whats causing it, But when i join my server this error occurs.

[Emrys]

It’s possible to get different player model when choosing a job? This would be very interesting and I think many people want this

Good work to the author, and to all those who do their best to help us

[Rhodiniium]

Anyone have a fix for this? Not sure whats wrong.

Thank you