job system

/** client.lua (missionSystem)**/

blipsUpToDate = false

RegisterNetEvent('missionSystem:getJobName')
AddEventHandler('missionSystem:getJobName', function(name)

    if(blipHarvest == false) then
        RemoveBlip(blipHarvest)
    end

    if(blipTreatment == false) then
        RemoveBlip(blipTreatment)
    end

    if(blipSell == false) then
        RemoveBlip(blipSell)
    end

    if(qte == "Mineur") then
        blipHarvest = AddBlipForCoord(<X>, <Y>, <Z>)
        SetBlipSprite(blip, <#Sprite>)
        SetBlipAsShortRange(blip, true)

        blipTreatment = AddBlipForCoord(<X>, <Y>, <Z>)
        SetBlipSprite(blip, <#Sprite>)
        SetBlipAsShortRange(blip, true)

        blipSell = AddBlipForCoord(<X>, <Y>, <Z>)
        SetBlipSprite(blip, <#Sprite>)
        SetBlipAsShortRange(blip, true)
    end
end)

RegisterNetEvent('missionSystem:processGetWeed')
AddEventHandler('missionSystem:processGetWeed', function(qte)
    if(qte == nil) then
        qte = 0
    end

    if qte < 30 then
        TriggerEvent('player:receiveItem',1, 1)
        ClearPrints()
        SetTextEntry_2("STRING")
        AddTextComponentString("~g~Vous venez de récolter du cannabis.")
        DrawSubtitleTimed(4500, 1)
    else
        ClearPrints()
        SetTextEntry_2("STRING")
        AddTextComponentString("~r~Vous ne pouvez pas récolter plus de cannabis!")
        DrawSubtitleTimed(2000, 1)
    end
end)

RegisterNetEvent('missionSystem:processGetShit')
AddEventHandler('missionSystem:processGetShit', function(qteWeed, qteShit)
    if(qteWeed == nil) then
        qteWeed = 0
    end

    if(qteShit == nil) then
        qteShit = 0
    end

    if qteShit < 30 and qteWeed > 0 then
        TriggerEvent('player:receiveItem',2, 1)
        TriggerEvent('player:looseItem',1, 1)
        ClearPrints()
        SetTextEntry_2("STRING")
        AddTextComponentString("~g~Vous venez de faire du shit.")
        DrawSubtitleTimed(4500, 1)
    else
        ClearPrints()
        SetTextEntry_2("STRING")
        AddTextComponentString("~r~Vous ne pouvez plus transformer de cannabis !")
        DrawSubtitleTimed(2000, 1)
    end
end)

RegisterNetEvent('missionSystem:processSellShit')
AddEventHandler('missionSystem:processSellShit', function(qte)
    if(qte == nil) then
        qte = 0
    end

    if qte > 0 then
        TriggerEvent('player:looseItem',2, 1)
        TriggerServerEvent('mission:completed', 50)
        ClearPrints()
        SetTextEntry_2("STRING")
        AddTextComponentString("~g~Vous venez de vendre du shit pour 50€.")
        DrawSubtitleTimed(2000, 1)
    else
        ClearPrints()
        SetTextEntry_2("STRING")
        AddTextComponentString("~r~Vous n'avez pas de shit à vendre!")
        DrawSubtitleTimed(2000, 1)
    end
end)

Citizen.CreateThread(function()
listOn = false
    while true do
        Wait(0)

        if(blipsUpToDate == false) then

            TriggerServerEvent('jobssystem:getJobName')
            blipsUpToDate = true
        end

        -- RECOLTE DE CANABIS - START
        if GetDistanceBetweenCoords(GetEntityCoords(GetPlayerPed(-1)), 2208.777,5578.235,53.735, true) <= 10 then
            TriggerServerEvent('missionSystem:getWeed')
            Citizen.Wait(5000)
        end
        -- RECOLTE DE CANABIS - END


        -- RECOLTE DE SHIT - START
        if GetDistanceBetweenCoords(GetEntityCoords(GetPlayerPed(-1)), -1103.57861328125,4889.03271484375,216.067886352539, true) <= 5 then
            TriggerServerEvent('missionSystem:getShit')
            Citizen.Wait(5000)
        end

        if GetDistanceBetweenCoords(GetEntityCoords(GetPlayerPed(-1)), -1171.8962402344,-1572.1916503906,4.6636219024658, true) <= 5 then
            TriggerServerEvent('missionSystem:sellShit')
            Citizen.Wait(2500)
        end

        -- RECOLTE DE SHIT - END

    end
end)


/** server.lua (Jobs System) **/

require "resources/essentialmode/lib/MySQL"
MySQL:open("localhost", "gta5_gamemode_essential", "root", "")


function nameJob(id)
  local executed_query = MySQL:executeQuery("SELECT * FROM jobs WHERE job_id = '@namejob'", {['@namejob'] = id})
  local result = MySQL:getResults(executed_query, {'job_name'}, "job_id")
  return result[1].job_name
end

function updatejob(player, id)
  local job = id
  MySQL:executeQuery("UPDATE users SET `job`='@value' WHERE identifier = '@identifier'", {['@value'] = job, ['@identifier'] = player})
end

function getPlayerJob(identifier)
  local executed_query = MySQL:executeQuery("SELECT * FROM jobs WHERE identifier = '@identifier'", {['@identifier'] = identifier})
  local result = MySQL:getResults(executed_query, {'job_name'}, "job_id")
  return result[1].job_name
end

RegisterServerEvent('jobssystem:jobs')
AddEventHandler('jobssystem:jobs', function(id)
  TriggerEvent('es:getPlayerFromId', source, function(user)
        local player = user.identifier
        local nameJob = nameJob(id)
        updatejob(player, id)
        TriggerClientEvent("es_freeroam:notify", source, "CHAR_MP_STRIPCLUB_PR", 1, "Mairie", false, "Votre métier est maintenant : ".. nameJob)
  end)
end)

RegisterServerEvent('jobssystem:getJobName')
AddEventHandler('jobssystem:getJobName', function(id)
  TriggerEvent('es:getPlayerFromId', source, function(user)
        local player = user.identifier
        local name = getPlayerJob(player)
        TriggerClientEvent("missionSystem:getJobName", source, name)
  end)
end)