Problem with event

[Neproify]

Hi! I have code like this:

  
addEventHandler("onPlayerQuit", root, function() 
    local charInfo = getElementData(source, "charInfo") 
    if not charInfo then return end 
    local money = getPlayerMoney(source) 
    outputDebugString(money) 
    exports.rp_db:zapytanie("UPDATE rp_characters SET skin=? AND money=? WHERE UID=?", charInfo.skin, getPlayerMoney(source), charInfo.UID) 
end) 
  

And the money variable is 0... When I got $500 In Game... So, what's problem?

[Dimos7]

try change the soure to thePlayer may it work

[Neproify]

Now the money variable is... Correct. I setPlayerMoney serverside, not clientside, like before.

But now i have other problem. The query to database:

2014-09-24 20:11:24.861: [script] SUCCESS: Affected rows:0 [Query:UPDATE `rp_characters` SET `skin`=0 AND `money`=0 WHERE `UID`=1] 

Is "success", but I don't see changes in phpmyadmin...

[XFawkes]

Affected rows:0

IT means that it received the mysql query and it is correct [syntax] but there were another problems? No row with UID = 1 ? missing collumns money , skin?

[Neproify]

Nope. Query in phpmyadmin(I use: UPDATE `rp_characters` SET `skin`=0 AND `money`=0 WHERE `UID`=1) Is correct. It works. But in MTA this same query doesn't work... But why?

[lcd1232]

maybe try use instead of `` this '' or this ""

[Anubhav]

maybe try use instead of `` this '' or this ""

Are you mad? Its SQL.