How i can save player money and location when the player leave the server i tried a code before but it didnt work.
it says on line 9 getPlayerMoney(expected player element)
PLEASE HEEEELP
this error takes me 5 days
--local connection = exports.db:getConnection()
local account = ""
local player = ""
function writedata(query)
local connection = exports.db:getConnection()--I have another script that exports the connection
local result = dbPoll(query, 0)
if (#result > 0 ) then
local up = dbQuery(connection, "UPDATE players SET money = ? WHERE account = ? ", getPlayerMoney(player), account)--Update player money if found result
dbFree(up)
elseif (#result == 0 ) then
local insert = dbQuery(connection, "INSERT INTO players (account, money) VALUES(?, ?) ", account, getPlayerMoney(player))--insert player money if found result
end
end
--addEventHandler("onPlayerLogout", root, function(acc)
--local connection = exports.db:getConnection()--I have another script that exports the connection
--player = source--reset the player element variables
--account = acc
--d--bQuery(writedata, connection, "SELECT * FROM players ", source, accout)
--end)
function quit()
local connection = exports.db:getConnection()--I have another script that exports the connection
player = source--reset the player element variables
account = getPlayerAccount(source)
dbQuery(writedata, connection, "SELECT * FROM players ", source, accout)
setElementData(source, "d", 45)
end
addEventHandler("onPlayerQuit", root, quit)
function returnn(select)
local connection = exports.db:getConnection()--I have another script that exports the connection
local result = dbPoll(select, 0)
for i, v in pairs(result) do
if v.money then--check if there is a value
setPlayerMoney(player, v.money)--set the player money
end
end
end
addEventHandler("onPlayerLogin", root, function(_, acc)
local connection = exports.db:getConnection()--I have another script that exports the connection
account = acc--reset the account variable
player = source--reset the player element variable
local select = dbQuery(returnn, connection, "SELECT * FROM players")
end)