[HELP] SQLite

[ma2med]

Hi, I tried to get result of SQL operation from a custom db but it won't work, why that?

  
connection = dbConnect( "sqlite", "groups.db" ) 
  
function test(account, key) 
    for i, values in ipairs(getAccounts()) do 
        if getAccountName(values) == getAccountName(account) then 
                local query = dbQuery(connection, "SELECT value FROM groups WHERE userid = ".. i .." and key = '".. key .."'") 
            return dbPoll(query, -1) 
        end 
    end 
end-- 
  
addCommandHandler("lol", function(p) 
if not isGuestAccount(getPlayerAccount(p)) then 
for i, v in ipairs(test(getPlayerAccount(p), "Ranks")) do 
outputChatBox(v, root) 
end 
end 
end) 
  

[WhoAmI]

Do you have groubs.db in your resource folder and is it in meta?

[ma2med]

It's not in meta, should I add it? Which tag is it, script, file ?

[WhoAmI]

Yes. File.

[ma2med]

I think working now, thanks WhoAmI.

EDIT: Same result, I wasn't login I forgot. It's still print nothing.

[WhoAmI]

Any errors debugscript 3?

[ma2med]

Nope. When I put

  
addCommandHandler("lol", function(p) 
for i, v in ipairs(getDBAccountData(getPlayerAccount(p), "Ranks")) do 
outputChatBox(v, root) 
end 
end) 
  

 

It's show nothing but when I put

 

  
addCommandHandler("lol", function(p) 
outputChatBox(getDBAccountData(getPlayerAccount(p), "Ranks"), root) 
end) 
  
  

It's wrote that the result is table.

[WhoAmI]

Maybe it's empty.

[ma2med]

When I execute it with SQLite it's show 1 row.

[TAPL]

addCommandHandler("lol", 
function(p) 
    for i, row in ipairs(getDBAccountData(getPlayerAccount(p), "Ranks")) do 
        for column, value in pairs(row) do 
            outputChatBox(column..": "..value) 
        end 
    end 
end) 

Read the second example in the wiki and you will understand.

https://wiki.multitheftauto.com/wiki/DbPoll

Also you don't need to add the db file in the meta.

[ma2med]

Hi, it's still not working sorry but I don't understood the second example that the same thing or maybe I am wrong?

[TAPL]

Try.

connection = dbConnect( "sqlite", "groups.db" ) 
  
function test(account, key) 
    for i, values in ipairs(getAccounts()) do 
        if values == account then 
            local query = dbQuery(connection, "SELECT value FROM groups WHERE userid =? AND key =?", i, key) 
            return dbPoll(query, -1) 
        end 
    end 
end 
  
addCommandHandler("lol", 
function(p) 
    for i, row in ipairs(getDBAccountData(getPlayerAccount(p), "Ranks")) do 
        for column, value in pairs(row) do 
            outputChatBox(column..": "..value) 
        end 
    end 
end) 

[ma2med]

Try.

connection = dbConnect( "sqlite", "groups.db" ) 
  
function test(account, key) 
    for i, values in ipairs(getAccounts()) do 
        if values == account then 
            local query = dbQuery(connection, "SELECT value FROM groups WHERE userid =? AND key =?", i, key) 
            return dbPoll(query, -1) 
        end 
    end 
end 
  
addCommandHandler("lol", 
function(p) 
    for i, row in ipairs(getDBAccountData(getPlayerAccount(p), "Ranks")) do 
        for column, value in pairs(row) do 
            outputChatBox(column..": "..value) 
        end 
    end 
end) 

Sorry, I made mistake, the function is not getDBAccountData but test so I fixed it and it's still not working.

[TAPL]

Post the insert code.

[ma2med]

What do you mean by the insert code ? Here is my code:

  
    connection = dbConnect( "sqlite", "groups.db" ) 
      
    function test(account, key) 
        for i, values in ipairs(getAccounts()) do 
            if values == account then 
                local query = dbQuery(connection, "SELECT value FROM groups WHERE userid =? AND key =?", i, key) 
                return dbPoll(query, -1) 
            end 
        end 
    end 
      
    addCommandHandler("lol", 
    function(p) 
        for i, row in ipairs(test(getPlayerAccount(p), "Ranks")) do 
            for column, value in ipairs(row) do 
                outputChatBox(column..": "..value, root) 
            end 
        end 
    end) 
  

[TAPL]

The code where you've inserted the row.

[ma2med]

It's coming from a script so I don't know, what about that ?

CREATE TABLE `groups` ( 
    `id`    INTEGER, 
    `userid`    INTEGER, 
    `key`   TEXT, 
    `value` TEXT, 
    `type`  INTEGER, 
    PRIMARY KEY(id) 
); 

[ma2med]

Oh, I got it. Thanks WhoAmI and TAPL.