[HELP] db Insert

[Snow-Man]

  
 function addPlayerPunishments(thePlayer)  
local account = getPlayerAccount(thePlayer)  
if (account) and not (isGuestAccount(account)) then  
local accountName = getAccountName(account)  
local serial = getPlayerSerial(thePlayer)  
Local time = getRealTime().timestamp return exports.USCsql:Execdb("INSERT INTO punishlogs (account,serial,time) VALUES(?,?,?)", accountName, serial, time) end return false end 

When i use this export, i didn't found any data in db

Help?

[xXMADEXx]

You're defining time with Local. It should be local. If it still doesn't work please post your whole code, and the Execdb function along with any debug errors that are appearing.

function addPlayerPunishments ( source ) 
    local account = getPlayerAccount ( source ) 
    if ( account and not isGuestAccount ( account ) ) then 
        local accName = getAccountName ( account ) 
        local serial = getPlayerSerial ( source ) 
        local time = getRealTime ( ).timestamp 
        local exe = exports.USCsql:Execdb ( "INSERT INTO punishlog ( account, serial, time ) VALUES ( ?, ?, ? )", 
             tostring ( accName ), tostring ( serial ), tostring ( time ) ) 
  
        return exe 
    end 
    return false 
end 

[Snow-Man]

WARNING: USCstaff\server.lua:6: Bad argument @ 'getPlayerAccount' [Expected element at argument 1, got nil]

[Snow-Man]

done, i fixed it

/lock please