SQlite table error

[Solstice.]

I thought the issue was with dbConnect initially although after going through some checkpoints there appears to be an issue table-side.

function display_char () 
    db = dbConnect ("sqlite", "account_info.db") 
    outputChatBox ("Some generic output implying the function is triggered") 
    if db == false then 
        outputChatBox ( "Some generic output implying dbConnect doesn't work") 
    else 
        outputChatBox ("Some generic output implying dbConnect does work") 
        skin_id = executeSQLQuery ("SELECT skin FROM characters WHERE acc_owner=? AND slot=?", acc_name, 1) 
        outputChatBox ( "",skin_id,"") -- if there's no output there's probably an issue with the query 
    end 
end 

[Renkon]

For using executeSQLQuery, the working database is the one stored as registry.db.

If you want to use your own DB, you gotta use dbExec

[Solstice.]

For using executeSQLQuery, the working database is the one stored as registry.db.

If you want to use your own DB, you gotta use dbExec

Although dbExec only returns true or false. What I need is to have the query return the skin ID listed in the table for the respective character.

An example:

How do I go about pulling the number '121' from the table so I can use it to set a spawned player's skin? Basically bind 121 to a variable. I'm working on a system whereas you can have more characters bound to one account. Later I'll be adding additional collums such as money in hand etc. but to get the drill I'm starting off simple.

[Renkon]

For that you can use dbQuery and then use dbPoll on that dbQuery.

local ex = dbQuery(...) 
local poll = dbPoll(ex, -1) 

Poll will be the table holding all the tables from the query

so if you wanna get that using:

SELECT skin FROM yourtable WHERE acc_owner = 'solstice' 

It will be stored in poll[1].skin if I'm not wrong.

[Solstice.]

For that you can use dbQuery and then use dbPoll on that dbQuery.

local ex = dbQuery(...) 
local poll = dbPoll(ex, -1) 

Poll will be the table holding all the tables from the query

so if you wanna get that using:

SELECT skin FROM yourtable WHERE acc_owner = 'solstice' 

It will be stored in poll[1].skin if I'm not wrong.

Perfect! Thank you very much. That helped me out.