[HELP] Fix my script (databases)

[Ziemo]

Hi, I've started writing scripts connected to the database, and I struggle why the current script that I am working on doesn't work.

Info:

- Name of the table: accounts

- Columns: username, skin, money

- No errors

Here is my script:

function showStats(player)
    local playerName = getPlayerName(player)
    local qh = dbQuery(db, "SELECT skin, money FROM accounts WHERE username=?", playerName)
    local result = dbPoll(qh, -1)
    if result then
        for _, row in ipairs(result) do
            outputChatBox("Skin: " ..row["skin"].. "Money: "..row["money"] .. "")
        end
    end
end
addCommandHandler("stats", showStats)

 

[DNL291]

Are you sure username is the player name and not the account name?

@Ziemo

[Ziemo]

@DNL291 I have set player's name in mta to the same as in database

[DNL291]

Do a test with this code:

function showStats(player)
    local playerName = getPlayerName(player)
    local qh = dbQuery(db, "SELECT skin, money FROM accounts WHERE username=?", playerName)
    local result = dbPoll(qh, -1)
    if result then
        for _, row in ipairs(result) do
            outputChatBox("Skin: " ..row["skin"].. "Money: "..row["money"] .. "")
        end
    end
	iprint( "qh " .. qh ..", result: ".. result )
end
addCommandHandler("stats", showStats)

Also, post the code where you create the table and save these values if possible.

[Ziemo]

It works, It outputted valid values, but I see an error: attempt to concatenate local 'result' (a table value) 

[DNL291]

Try:

function showStats(player)
    local playerName = getPlayerName(player)
    local qh = dbQuery(db, "SELECT skin, money FROM accounts WHERE username=?", playerName)
    local result = dbPoll(qh, -1)
    if result then
    	result = result[1]
        for _, row in ipairs(result) do
            outputChatBox("Skin: " ..row["skin"].. "Money: "..row["money"] .. "")
        end
    end
end
addCommandHandler("stats", showStats)

@Ziemo

[Ziemo]

This new function doesn't work, but when I delete: 

iprint( "qh " .. qh ..", result: ".. result )

from the older code, error doesn't show up

EDIT: never mind it showed, I just missed it

Edited August 7, 2019 by Ziemo

[IIYAMA]

Concat with iprint like this:

iprint( "qh ", qh, ", result: ", result )

@Ziemo

[Ziemo]

It works, shows the info in debug, and outputs skin and money from database! Thanks you both guys.