Help for add job restriction

FiveM Resource Development Discussion
1

Hello my code dont work

require “resources/essentialmode/lib/MySQL”
MySQL:open(“‘-’”, “‘-’”, “root”, “‘-’”)

– HELPER FUNCTIONS

function nameJob(player)
  local executed_query = MySQL:executeQuery("SELECT identifier, job_id, job_name FROM users LEFT JOIN jobs ON jobs.job_id = users.job WHERE users.identifier = '@identifier'", {['@identifier'] = player})
  local result = MySQL:getResults(executed_query, {'job_name'}, "identifier")
  return tostring(result[1].job_name)
end

RegisterServerEvent('BusJOB:success')
AddEventHandler(BusJOB:success', function(price)
print("Player ID " ..source)
TriggerEvent('es:getPlayerFromId', source, function(user)
local nameJob = nameJob(id)
if nameJob == 20 then -- bus job
total = price;
user:addMoney((total))
end)
end)

errorbusjob.jpg996×401 201 KB

Could help me to run .-.

2

We’d need a bit more information than just “it won’t work”.

Do you get an errors in console? If so, could you print them?

Also, does nameJob exist, if so then what does it do?

1 Like
3

Hello i have more error

4

Yes the work exists but when I start the server it generates several errors

5

I sent the error and I posted all my code

6

Could anyone help? ,-,