I try to fix a script but in didn’t succeed ! My scripts :
Client:
local distance = GetDistanceBetweenCoords(playerPos.x, playerPos.y, playerPos.z, Position.Recolet.x, Position.Recolet.y, Position.Recolet.z, true)
if not IsInVehicle() then
if distance < Position.Recolet.distance then
ShowInfo('~b~Appuyez sur ~g~E~b~ pour récolter', 0)
if IsControlJustPressed(1, 38) then
job = TriggerServerEvent("mine:job")
Wait(100)
if job == 4 then
TriggerEvent("player:getQuantity", 23)
roche = qte
TriggerEvent("player:getQuantity", 17)
cuivre = qte
TriggerEvent("player:getQuantity", 18)
fer = qte
TriggerEvent("player:getQuantity", 19)
diams = qte```
Server :
require "resources/essentialmode/lib/MySQL"
MySQL:open("127.0.0.1", "gta5_gamemode_essential", "root", "")
function nameJob(player)
local executed_query = MySQL:executeQuery("SELECT `job` FROM `users` WHERE `identifier` = '@identifier'", {['@identifier'] = player})
local result = MySQL:getResults(executed_query, {'job'}, "identifier")
return tostring(result[1].job)
end
RegisterServerEvent('mine:job')
AddEventHandler('mine:job', function()
TriggerEvent('es:getPlayerFromId', source, function(user)
local player = user.identifier
local job = nameJob(player)
return job
end)
end)
Thank you !