Help SQL plis

[WASSIm.]

hi guys plis i need help. i have problem it not working plis help

EDIT DEBUG: http://i.imgur.com/JFafHLR.png

local connection = nil 
  
addEventHandler ( "onResourceStart", resourceRoot, 
    function ( ) 
        connection = dbConnect( "sqlite", "database/database.db" ) 
        if ( connection )then 
            outputDebugString ( "Successfully connected to database.db" ) 
        else 
            outputDebugString ( "Failed to connect to database.db", 3 ) 
        end 
    end 
) 
  
function dbQueryZA( ... ) 
    local handler = connection 
    if ( not handler ) then 
        return false, "Couldn't connect to SQLite database." 
    end 
     
    local query = dbQuery( connection, ... ) 
    local result, numrows, errmsg = dbPoll ( query, -1 ) 
    if ( type ( result ) == "table" and #result == 0 or not result ) then 
        return false 
    else 
        return result 
    end      
end 
  
function dbExecZA( ... ) 
    local handler = connection 
    if ( not handler ) then 
        return false, "Couldn't connect to SQLite database." 
    end 
    return dbExec( connection, ... ) 
end 

this exmple i use

function getAccountZkill ( account ) 
    local result = exports["server"]:dbQueryZA( "SELECT * FROM zkills WHERE account = ?", tostring ( account ) ) 
    return tostring ( result[ 1 ][ "Zkill" ] ) 
end 

[K4stic]

Try This:

local connection = nil 
  
addEventHandler ( "onResourceStart", resourceRoot, 
    function ( ) 
        connection = dbConnect( "sqlite", "database/database.db" ) 
        if ( connection )then 
            outputDebugString ( "Successfully connected to database.db" ) 
        else 
            outputDebugString ( "Failed to connect to database.db", 3 ) 
        end 
    end 
) 
  
function dbQueryZA( ... ) 
    if (not connection ) then 
        return false, "Couldn't connect to SQLite database." 
    else 
        local hadler = dbQuery( connection, ... ) 
        return dbPoll( hadler, -1 ) 
    end 
end 
  
function dbExecZA( monkey, ... ) 
    if ( not connection ) then 
        return false, "Couldn't connect to SQLite database." 
    else  
        return dbExec( connection, monkey, ... ) 
    end 
end 

[WASSIm.]

now result dbQuery nil

[TAPL]

Try

local connection = nil 
  
addEventHandler("onResourceStart", resourceRoot, 
    function() 
        connection = dbConnect("sqlite", "database/database.db") 
        if (connection)then 
            outputDebugString("Successfully connected to database.db") 
        else 
            outputDebugString("Failed to connect to database.db", 3) 
        end 
    end 
) 
  
function dbQueryZA(Query, ...) 
    if (not connection) then 
        return false, "Couldn't connect to SQLite database." 
    end 
    local query = dbQuery(connection, Query, table.concat({...}, ", ")) 
    local result, numrows, errmsg = dbPoll(query, -1) 
    if (type(result) == "table" and #result == 0 or not result) then 
        return false 
    else 
        return result 
    end     
end 
  
function dbExecZA(Query, ...) 
    if (not connection) then 
        return false, "Couldn't connect to SQLite database." 
    end 
    return dbExec(connection, Query, table.concat({...}, ", ")) 
end 

[WASSIm.]

nothing

[TAPL]

Post the code you use.

[K4stic]

Try This:

local connection = nil 
  
addEventHandler ( "onResourceStart", resourceRoot, 
    function ( ) 
        connection = dbConnect( "sqlite", "database/database.db" ) 
        if ( connection )then 
            outputDebugString ( "Successfully connected to database.db" ) 
        else 
            outputDebugString ( "Failed to connect to database.db", 3 ) 
        end 
    end 
) 
  
function dbQueryZA( ... ) 
    if (not connection ) then 
        return false, "Couldn't connect to SQLite database." 
    else 
        local hadler = dbQuery( connection, ... ) 
        return dbPoll( hadler, -1 ) 
    end 
end 
  
function dbExecZA( monkey, ... ) 
    if ( not connection ) then 
        return false, "Couldn't connect to SQLite database." 
    else  
        return dbExec( connection, monkey, ... ) 
    end 
end 

To work that i make it's easy do the next (it's the same example that you give with little edit)

function getAccountZkill ( account ) 
    local result = exports["server"]:dbQueryZA( "SELECT * FROM zkills WHERE account = ?", tostring ( account ) ) 
    return tostring ( result ) 
end 

[WASSIm.]

Post the code you use.

that have getAccountZkill ?

[TAPL]

Yes.

[WASSIm.]

problem its in dbQueryZA

local connection = nil 
  
addEventHandler ( "onResourceStart", resourceRoot, 
    function ( ) 
        exports["scoreboard"]:addScoreboardColumn( "Zombie kills", root, 80, "Z kills", 6) 
        exports["server"]:dbExecZA("CREATE TABLE IF NOT EXISTS zkills (ID INTEGER PRIMARY KEY NOT NULL, account TEXT, Zkill INT)" ) 
    end 
) 
  
addEventHandler("onResourceStart", resourceRoot, 
function () 
    for index, player in ipairs(getElementsByType("player")) do 
        local account = getPlayerAccount(player) 
        if (not account or isGuestAccount(account)) then return false end 
        local accountName = getAccountName(account) 
        local zkill = getAccountZkill ( accountName ) 
        if (account) then 
            if not ( zkill ) then 
                addZkillToDatabase ( accountName ) 
                setElementData(player, "Zombie kills", 0) 
            else 
                setElementData(player, "Zombie kills", tonumber(zkill)) 
            end 
        end 
    end 
end 
) 
  
addEventHandler("onResourceStop", resourceRoot, 
function () 
    for index, player in ipairs(getElementsByType("player")) do 
        local zkill = tonumber(getElementData(player,"Zombie kills")) or 0 
        local account = getPlayerAccount(player) 
        if (not account or isGuestAccount(account)) then return false end 
        local accountName = getAccountName(account) 
        if (zkill) and (account) then 
            setAccountZkill(accountName, tonumber(zkill)) 
            removeElementData(player, "Zombie kills") 
        end 
    end 
end) 
  
addEventHandler("onPlayerLogout", getRootElement(), 
function (_,account) 
    local zkill = tonumber(getElementData(source,"Zombie kills")) or 0 
    local accountName = getAccountName(account) 
    setAccountZkill(accountName, zkill) 
    removeElementData(source, "Zombie kills") 
end 
) 
  
addEventHandler("onPlayerQuit", getRootElement(), 
function ( ) 
    local zkill = tonumber(getElementData(source,"Zombie kills")) or 0 
    local account = getPlayerAccount(source) 
    if (not account or isGuestAccount(account)) then return false end 
    local accountName = getAccountName(account) 
    if (zkill) and (account) then 
        setAccountZkill(accountName, zkill) 
    end 
end 
) 
  
addEventHandler("onPlayerLogin", getRootElement(), 
function (_,account) 
    local accountName = getAccountName(account) 
    local zkill = getAccountZkill ( accountName ) 
    if not ( zkill ) then 
        addZkillToDatabase ( accountName ) 
        setElementData(source, "Zombie kills", 0) 
    else 
        setElementData(source, "Zombie kills", zkill) 
    end 
end 
) 
  
function addZkillToDatabase ( account ) 
    return exports["server"]:dbExecZA("INSERT INTO zkills (ID, account, Zkill) VALUES (NULL, '".. tostring ( account ) .."', '0')" ) 
end 
  
function getAccountZkill ( account ) 
    local result = exports["server"]:dbQueryZA( "SELECT * FROM zkills WHERE account = ?", tostring ( account ) ) 
    return tostring ( result[ 1 ][ "Zkill" ] ) 
end 
  
  
function setAccountZkill ( account, theZkille ) 
    return exports["server"]:dbExecZA("UPDATE zkills SET Zkill = '".. tostring ( theZkille ) .."' WHERE account = '" .. tostring ( account ) .."'" ) 
end 

[TAPL]

local connection = nil 
  
addEventHandler("onResourceStart", resourceRoot, 
    function() 
        connection = dbConnect("sqlite", "database/database.db") 
        if (connection)then 
            outputDebugString("Successfully connected to database.db") 
        else 
            outputDebugString("Failed to connect to database.db", 3) 
        end 
    end 
) 
  
function dbQueryZA(Query) 
    if (not connection) then 
        return false, "Couldn't connect to SQLite database." 
    end 
    local query = dbQuery(connection, Query) 
    local result, numrows, errmsg = dbPoll(query, -1) 
    if (type(result) == "table" and #result == 0 or not result) then 
        return false 
    else 
        return result 
    end     
end 
  
function dbExecZA(Query) 
    if (not connection) then 
        return false, "Couldn't connect to SQLite database." 
    end 
    return dbExec(connection, Query) 
end 

addEventHandler("onResourceStart", resourceRoot, 
    function() 
        exports["scoreboard"]:addScoreboardColumn( "Zombie kills", root, 80, "Z kills", 6) 
        exports["server"]:dbExecZA("CREATE TABLE IF NOT EXISTS zkills (ID INTEGER PRIMARY KEY NOT NULL, account TEXT, Zkill INT)") 
    end 
) 
  
addEventHandler("onResourceStart", resourceRoot, 
function() 
    for index, player in ipairs(getElementsByType("player")) do 
        local account = getPlayerAccount(player) 
        if (not account or isGuestAccount(account)) then return false end 
        local accountName = getAccountName(account) 
        local zkill = getAccountZkill(accountName) 
        if (account) then 
            if not (zkill) then 
                addZkillToDatabase ( accountName ) 
                setElementData(player, "Zombie kills", 0) 
            else 
                setElementData(player, "Zombie kills", zkill) 
            end 
        end 
    end 
end) 
  
addEventHandler("onResourceStop", resourceRoot, 
function () 
    for index, player in ipairs(getElementsByType("player")) do 
        local zkill = getElementData(player,"Zombie kills") or 0 
        local account = getPlayerAccount(player) 
        if (not account or isGuestAccount(account)) then return false end 
        local accountName = getAccountName(account) 
        if (zkill) and (account) then 
            setAccountZkill(accountName, zkill) 
            removeElementData(player, "Zombie kills") 
        end 
    end 
end) 
  
addEventHandler("onPlayerLogout", getRootElement(), 
function (account) 
    local zkill = getElementData(source,"Zombie kills") or 0 
    local accountName = getAccountName(account) 
    setAccountZkill(accountName, zkill) 
    removeElementData(source, "Zombie kills") 
end) 
  
addEventHandler("onPlayerQuit", getRootElement(), 
function ( ) 
    local zkill = getElementData(source,"Zombie kills") or 0 
    local account = getPlayerAccount(source) 
    if (not account or isGuestAccount(account)) then return false end 
    local accountName = getAccountName(account) 
    if (zkill) and (account) then 
        setAccountZkill(accountName, zkill) 
    end 
end) 
  
addEventHandler("onPlayerLogin", getRootElement(), 
function (_,account) 
    local accountName = getAccountName(account) 
    local zkill = getAccountZkill(accountName) 
    if not ( zkill ) then 
        addZkillToDatabase ( accountName ) 
        setElementData(source, "Zombie kills", 0) 
    else 
        setElementData(source, "Zombie kills", zkill) 
    end 
end) 
  
function addZkillToDatabase(account) 
    return exports["server"]:dbExecZA("INSERT INTO zkills (ID, account, Zkill) VALUES (NULL, '"..account.."', '0')") 
end 
  
function getAccountZkill(account) 
    local result = exports["server"]:dbQueryZA( "SELECT * FROM zkills WHERE account = '"..account.."'") 
    if (type(result) == "table" and #result == 0 or not result) then 
        return false 
    else 
        return tostring(result[1]["Zkill"]) 
    end 
end 
  
function setAccountZkill(account, theZkille) 
    return exports["server"]:dbExecZA("UPDATE zkills SET Zkill = '"..theZkille.."' WHERE account = '"..account.."'") 
end 

[WASSIm.]

i can't make ( if (type(result) == "table" and #result == 0 or not result) then ) only in script have database ?

[TAPL]

function getAccountZkill(account) 
    local result = exports["server"]:dbQueryZA( "SELECT * FROM zkills WHERE account = '"..account.."'") 
    if (type(result) == "table" and #result == 0 or not result) then 
        return false 
    else 
        return tostring(result[1]["Zkill"]) 
    end 
end 

You can change it to:

function getAccountZkill(account) 
    local result = exports["server"]:dbQueryZA( "SELECT * FROM zkills WHERE account = '"..account.."'") 
    if (result) then 
        return tostring(result[1]["Zkill"]) 
    end 
end 

[WASSIm.]

thank you a lot

[TAPL]

You're welcome.