Error

[Msypon]

Line 21: attempt to index field '?'

addEventHandler ( 'onResourceStart', resourceRoot, 
    function ( ) 
        executeSQLCreateTable ( 'SQLData', 'money INT, serial STRING' ) 
    end 
) 
  
addCommandHandler ( 'savesql', 
    function ( player ) 
        local serial = getPlayerSerial ( player ) 
        local money = getPlayerMoney ( player ) 
        executeSQLQuery ( 'UPDATE SQLData SET money = ? WHERE serial = ?', money, serial ) 
    end 
) 
  
addCommandHandler ( 'loadsql', 
    function ( player ) 
        local serial = getPlayerSerial ( player ) 
        local result = executeSQLQuery ( 'SELECT money FROM SQLData WHERE serial = ?', serial ) 
        if ( type ( result ) == "table" and #result == 0 ) or not result then 
            return  
            setPlayerMoney ( player, result[1].money ) 
        end 
    end 
) 

[DNL291]

addCommandHandler ( 'loadsql', 
    function ( player ) 
        local serial = getPlayerSerial ( player ) 
        local result = executeSQLQuery ( 'SELECT money FROM SQLData WHERE serial = ?', serial ) 
        if ( type ( result ) == "table" and #result == 0 ) or not result then 
            return 
        end 
        setPlayerMoney ( player, result[1].money ) 
    end 
) 

[Msypon]

not worked

[DNL291]

Where is the 'result' ?

Edited February 16, 2013 by Guest

[Msypon]

im learning sqllite men, which result table are you talking?

[Castillo]

You are on the database? because the "savesql" command will only update it, it won't insert the row.