Help SQL

[WASSIm.]

HI GUYS. i have problem wit this code its not working and return nil

function getBan(banlSerial) 
    local result = exports["ZA"]:dbQueryZA( "SELECT * FROM bans WHERE banlSerial = ?", tostring(banlSerial)) 
    if (result) then return tostring(result[1]) end 
end 
  
addCommandHandler("ban", 
function (thePlayer) 
    outputChatBox(tostring(getBan(getPlayerSerial(thePlayer)).banlSerial)) 
end) 

[Jaysds1]

Did you try seeing if the result is a table before trying to return the value?

[Baseplate]

Can you copy the table creation syntax?

[WASSIm.]

i fixed that problem but i have other like it . function not working if no row

ERROR: 108: attempt to index a nil value

function isPlayerBanned(thePlayer) 
    if (thePlayer) then 
        local IP = getPlayerIP(thePlayer) 
        local serial = getPlayerSerial(thePlayer) 
        if (getBan(serial)["banlSerial"]) or (getBanFromIP(IP)["banlIP"]) then 
            return true else return false 
        end 
    else 
        return false 
    end 
end 

[Castillo]

Either getBan or getBanFromIP must be returning a boolean instead of a table.

[WASSIm.]

Either getBan or getBanFromIP must be returning a boolean instead of a table.

its working if have row. btw how fix ?

[Castillo]

function isPlayerBanned ( thePlayer ) 
    if ( thePlayer ) then 
        local IP = getPlayerIP ( thePlayer ) 
        local serial = getPlayerSerial ( thePlayer ) 
        if ( getBan ( serial ) and getBan ( serial ) [ "banlSerial" ] ) or ( getBanFromIP ( IP ) and getBanFromIP ( IP ) [ "banlIP" ] ) then 
            return true 
        else 
            return false 
        end 
    else 
        return false 
    end 
end