[Help] Mysql Save

[kamani]

Hey, i used mysql module, Created login, Load data from mysql perfect, but don't save information...

This is "data save to mysql" function..

function SaveData() 
x,y,z = getElementPosition(source) 
money = getPlayerMoney(source) 
skin = getPedSkin(source) 
local SaveQuery = "UPDATE users SET PosX='" .. x .. "', PosY='" .. y .."', PosZ='" .. z .."'  WHERE username='" .. getPlayerName(source) .."'" 
local SaveQuery2 = "UPDATE users SET Money='" .. money .. "', Skin='" .. skin .."' WHERE username='" .. getPlayerName(source) .."'" 
end 
addEventHandler("onPlayerQuit",getRootElement(),SaveData) 

i think this function have save Money,Skin,x y z coord to mysql by username, but don't save..

[laserlaser]

Hey, i used mysql module, Created login, Load data from mysql perfect, but don't save information...

This is "data save to mysql" function..

function SaveData() 
x,y,z = getElementPosition(source) 
money = getPlayerMoney(source) 
skin = getPedSkin(source) 
local SaveQuery = "UPDATE users SET PosX='" .. x .. "', PosY='" .. y .."', PosZ='" .. z .."'  WHERE username='" .. getPlayerName(source) .."'" 
local SaveQuery2 = "UPDATE users SET Money='" .. money .. "', Skin='" .. skin .."' WHERE username='" .. getPlayerName(source) .."'" 
end 
addEventHandler("onPlayerQuit",getRootElement(),SaveData) 

i think this function have save Money,Skin,x y z coord to mysql by username, but don't save..

lol where mysql_query

mysql_query(SaveQuery)

[kamani]

Okey, now its

function SaveData() 
x,y,z = getElementPosition(source) 
money = getPlayerMoney(source) 
skin = getPedSkin(source) 
local SaveQuery = "UPDATE users SET PosX='" .. x .. "', PosY='" .. y .."', PosZ='" .. z .."'  WHERE username='" .. getPlayerName(source) .."'" 
local SaveQuery2 = "UPDATE users SET Money='" .. money .. "', Skin='" .. skin .."' WHERE username='" .. getPlayerName(source) .."'" 
mysql_query(SaveQuery) 
mysql_query(SaveQuery2) 
end 
addEventHandler("onPlayerQuit",getRootElement(),SaveData) 

and when player disconnect in server console i see

bad argument #1 to 'mysql_query' (LuaBook.mysqlHandler expected, got string)

[laserlaser]

Okey, now its

function SaveData() 
x,y,z = getElementPosition(source) 
money = getPlayerMoney(source) 
skin = getPedSkin(source) 
local SaveQuery = "UPDATE users SET PosX='" .. x .. "', PosY='" .. y .."', PosZ='" .. z .."'  WHERE username='" .. getPlayerName(source) .."'" 
local SaveQuery2 = "UPDATE users SET Money='" .. money .. "', Skin='" .. skin .."' WHERE username='" .. getPlayerName(source) .."'" 
mysql_query(SaveQuery) 
mysql_query(SaveQuery2) 
end 
addEventHandler("onPlayerQuit",getRootElement(),SaveData) 

and when player disconnect in server console i see

bad argument #1 to 'mysql_query' (LuaBook.mysqlHandler expected, got string)

sorry,

handler=mysql_connect(string hostname, string username, string password, string database)

mysql_query(handler, SaveQuery)

[kamani]

ok, very thanks SOLVED!