Problem With Quit Event

[3B00DG4MER]

Hi Guys,

i'm Making a gamemode which it's RPG .......

i've problem onClientPlayerQuit

i tried to make if player Quit then Save the Last position With Mysql here is Client:

function playerQuit() 
  
local PosX,PosY,PosZ = getElementPosition(source) 
triggerServerEvent("onClientLogout", localPlayer,PosX,PosY,PosZ) 
end 
addEventHandler("onClientPlayerQuit", getRootElement(),playerQuit) 

and Here is Server:

  
function quitPlayer( PosX,PosY,PosZ ) 
local id = getElementData(source,"id") 
local query = dbExec(connection, "UPDATE `??` SET `??` = '??' AND `??` = '??' AND `??` = '??' WHERE `??` = '??' LIMIT 1","accounts","PosX",PosX,"PosY",PosY,"PosZ",PosZ,"id",id) 
  
end 
addEvent("onClientLogout",true) 
addEventHandler ( "onClientLogout", getRootElement(), quitPlayer ) 
  

[Bonsai]

And whats the problem?

[3B00DG4MER]

And whats the problem?

it's don't update !!!!!!!!!!!!

and there is nothing in debugscript, that's the problem !!!!!

[Et-win]

local id = getElementData(source,"id") 

The player left, so you can't do this.

[3B00DG4MER]

local id = getElementData(source,"id") 

The player left, so you can't do this.

i used this on another fuction

setElementData(source,"id",row['id']) 

so what i can do ???

[Et-win]

Do that code (getElementData) in the 'playerQuit' function and send it withing the trigger.

[3B00DG4MER]

Do that code (getElementData) in the 'playerQuit' function and send it withing the trigger.

i tried dat

client:

  
function playerQuit() 
local id = getElementData(source,"id") 
local PosX,PosY,PosZ = getElementPosition(source) 
triggerServerEvent("onUserLogout", source,PosX,PosY,PosZ,id) 
end 
addEventHandler("onClientPlayerQuit", getRootElement(),playerQuit) 

server:

function quitPlayer( PosX,PosY,PosZ,id ) 
  
local query = dbExec(connection, "UPDATE `??` SET `??` = '??' AND `??` = '??' AND `??` = '??' WHERE `??` = '??' LIMIT 1","accounts","PosX",PosX,"PosY",PosY,"PosZ",PosZ,"id",id) 
  
end 
addEvent("onUserLogout",true) 
addEventHandler ( "onUserLogout", getRootElement(), quitPlayer ) 

[Et-win]

Then or: It can't or: It's server-side, but I don't know what since I have no idea how db-codes work yet.

[3B00DG4MER]

Ty For ur HElp i fixed it

i was problem with DB codes

i used 'AND' instead ','