--local connection = exports.db:getConnection()
account = ""
player = nil
function writedata(query)
if not player then return end
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("onPlayerQuit", root, function(quitType, reason, responsibleElement)
local connection = exports.db:getConnection()--I have another script that exports the connection
player = source --reset the player element variable
if player then
account = getPlayerAccount(source)--reset the account variable
dbQuery(writedata, connection, "SELECT * FROM players ", source)
end
end)
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)
test this