Installation
Add dependencies:
Add the script:
Apply Modifications: (if you want to add new job with /adddealerjob)
RegisterNetEvent('esx:refreshJobs', function(cb, triggerCheck)
if triggerCheck then
triggerCheck(true)
return
end
local Jobs = {}
MySQL.Async.fetchAll('SELECT * FROM jobs', {}, function(jobs)
for k, v in ipairs(jobs) do
Jobs[v.name] = v
Jobs[v.name].grades = {}
end
MySQL.Async.fetchAll('SELECT * FROM job_grades', {}, function(jobGrades)
for k, v in ipairs(jobGrades) do
if Jobs[v.job_name] then
Jobs[v.job_name].grades[tostring(v.grade)] = v
end
end
for k2, v2 in pairs(Jobs) do
if ESX.Table.SizeOf(v2.grades) == 0 then
Jobs[v2.name] = nil
end
end
ESX.Jobs = Jobs
if cb then
cb(true)
end
end)
end)
end)Notes:
Last updated