kamani Posted November 20, 2010 Share Posted November 20, 2010 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.. Link to comment
laserlaser Posted November 20, 2010 Share Posted November 20, 2010 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) Link to comment
kamani Posted November 20, 2010 Author Share Posted November 20, 2010 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) Link to comment
laserlaser Posted November 20, 2010 Share Posted November 20, 2010 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) Link to comment
kamani Posted November 20, 2010 Author Share Posted November 20, 2010 ok, very thanks SOLVED! Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now