[LUA Scripting] How to find "targetPlayer" into "TriggerClientEvent"

marco.paggioro · 2019-08-10T10:49:31.225Z

The problem is not the result of the query, i think. Cause if i put a static string the triggerclientevent not work

slother6 · 2019-08-10T10:49:58.787Z

and it still doesn’t work on restart of game at all?

wizzy06 · 2019-08-10T10:51:34.849Z

Try with that :

local function OnPlayerConnecting(name, setKickReason, deferrals)
  local Source = source  
  MySQL.ready(function()
    local steamID = nil
    local identifiers = GetPlayerIdentifiers(Source)

    print("Source: " .. source)

    for _, v in pairs(identifiers) do
      if string.find(v, "steam") then
        steamID = v
        break
      end
    end

    local result = MySQL.Sync.fetchAll("SELECT * FROM `users` WHERE `identifier`=@steam", {['steam'] = steamID})
    if result then
      TriggerClientEvent("mysqlTest:test", Source, result)
    end
  end)
end``

marco.paggioro · 2019-08-10T10:52:31.143Z

With sync mysql same error
Already restarted the game client and the game server

local function OnPlayerConnecting(name, setKickReason, deferrals)
	local steamID = nil
	local identifiers = GetPlayerIdentifiers(source)
	
	print("Source: " .. source)
	
	--Steam identifier
	for _, v in pairs(identifiers) do
        if string.find(v, "steam") then
            steamID = v
            break
		end
    end
	
	local players = MySQL.Sync.fetchAll('SELECT id, name FROM users')
	print(players[1].id)
	TriggerClientEvent("mysqlTest:test", source, "test", "test")
end

AddEventHandler("playerConnecting", OnPlayerConnecting)

wizzy06 · 2019-08-10T10:53:09.507Z

cfx> Connecting: MinePuzza
InvokeNative: execution failed: Argument at index 0 was null.
Error resuming coroutine: Execution of native 00000000ff7f66ab in script host failed.
stack traceback:
        [C]: in upvalue '_in'
        citizen:/scripting/lua/natives_server.lua:169: in function 'GetNumPlayerIdentifiers'
        citizen:/scripting/lua/scheduler.lua:244: in function 'GetPlayerIdentifiers'
        @mysqlTest/server.lua:4: in upvalue 'callback'
        @mysql-async/lib/MySQL.lua:197: in function <@mysql-async/lib/MySQL.lua:189>

This message principally appear when

source

have a nil value

marco.paggioro · 2019-08-10T10:56:33.950Z

No errors in console but same error

image1099×130 74.4 KB

wizzy06 · 2019-08-10T10:57:03.213Z

No in client console, check in server console

marco.paggioro · 2019-08-10T10:57:37.740Z

Nothing special in console

wizzy06 · 2019-08-10T10:58:39.293Z

Wait, i will do tests in my server, i will give you the code after, give me 10 minutes

marco.paggioro · 2019-08-10T10:59:04.504Z

Thanks man, if you help me to resolve i’ll pay u:rofl:

wizzy06 · 2019-08-10T11:18:53.512Z

AddEventHandler('playerConnecting', function(name, setKickReason)
  local identifier
  local Source = source
  for k,v in ipairs(GetPlayerIdentifiers(source))do
    if string.sub(v, 1, string.len("steam:")) == "steam:" then
      identifier = v
      break
    end
  end

  MySQL.ready(function()
    local result = MySQL.Sync.fetchAll("SELECT * FROM `users` WHERE `identifier`=@steam", {['steam'] = identifier})
    if result then
     TriggerClientEvent("mysqlTest:test", Source, result)
   end
 end)
end)

Worked !

wizzy06 · 2019-08-10T11:23:56.202Z

You can add to be sure that user is connected to Steam and has connected before FiveM launching app

if not identifier then
    setKickReason("Steam ID not detected, please restart FiveM")
    CancelEvent()
  end

marco.paggioro · 2019-08-10T11:34:52.065Z

i can’t understand… still not work on my server…
can you please upload into internet the files and send to me link so i can directly download your code?

wizzy06 · 2019-08-10T14:01:05.334Z

What is error code ?

marco.paggioro · 2019-08-10T14:46:55.399Z

same error. Job variable is not defined.

wizzy06 · 2019-08-10T14:58:33.870Z

Don’t forget to print value in MySQL query and print the identifier variable first

wizzy06 · 2019-08-10T15:00:38.040Z

After, check if a parameter is passed here, and your event goes here.
Proceed by step !

RegisterNetEvent("mysqlTest:test")
AddEventHandler("mysqlTest:test", function(par1, par2)
	print ("OK")
        print (par1, par2)
    job = par1
end)

marco.paggioro · 2019-08-10T15:14:37.826Z

i tryed to add in server.lua
print("Source: " .. source)
My friend and I joined the server and in the console we read “Source: 65536” and “Source: 65537”.
All ok.
I tryed to add in client.lua into the RegisterCommand function
print("Source: " .. source)
but when i do /test and i open console with F8 i can see “Source: 0” for me and the same “Source: 0” for my friend.
So i think this is the error. But it has no sense that two people have the same source. No?

wizzy06 · 2019-08-10T15:24:57.284Z

marco.paggioro:

source

No, no, Client / Server are not the same. In client, if you see the message in your client console, it is because you have received the message. (Server say to specific client (you) to do an action ) So, in client, to get your client player id , it is GetPlayerPed(-1). But, you don’t need this information. Have you checked in client that you receive your parameters ?

marco.paggioro · 2019-08-10T15:46:44.453Z

I added

print ("OK")
print (par1, par2)

And nothing changed. I didn’t see either of the two prints.
So i tryed to create a new event in client.lua. I added

local hello
RegisterNetEvent("hello1234")
AddEventHandler("hello1234", function(eventParam1, eventParam2)
	hello = "Woooooooooow"
end)

RegisterCommand("hello", function(source, args, rawCommand)
	TriggerEvent('chat:addMessage', {
		args = { "Madonna : " .. hello}
	})
end, false)

And I added in server.lua
TriggerClientEvent("ciaoneBurlone", "-1", "ciao", 21)
Where “-1” means all the client. So if i do /hello i can see “Madonna: Woooooow”

So I think that the problem is the “source” parameter in server script