I updated Burak his example. But I have not refactored the variable names.
function AccDatacallback(AccData, player, account, AccName)
local result = dbPoll( AccData, 0 )
if AccData and #AccData > 0 then return end
local ID = getFreeID()
local SetData = dbExec(db,"INSERT INTO stats (ID,Account) VALUES (?, ?)", ID, AccName)
end
function getpaccount (_,account)
local AccName = getAccountName(account)
setPlayerName(source,tostring(AccName))
dbQuery(AccDatacallback, {source, account, AccName}, db, "SELECT * FROM stats WHERE Account=? LIMIT 1", AccName)
end
addEventHandler("onPlayerLogin",root, getpaccount)
The function was called instead of provided as function.
local AccData = dbQuery(AccDatacallback(), db,"SELECT * FROM stats WHERE Account=? LIMIT 1", AccName)
This is now moved inside of the call back function. Since the data is not immediately available.
if(AccData) then
if(#AccData > 0) then return end
end
local ID = getFreeID()
local SetData = dbExec(db,"INSERT INTO stats (ID,Account) VALUES (?, ?)",ID, AccName)