[HELP] database problem

[BenceDev]

Hi everyone!

I have a problem, so my problem is i want to get a number from table (example: i save player skin id to database when he register it [it works for me], and after he logged in set player skin to his saved id), but i dont know how to do it.

This is from my server sided script when he log in:
 

addEvent("loginRequest", true)
function loginRequest(player, username, password)
    local check = exports.fs_sql:_QuerySingle("select * from users where username = ? ", username)
    if check then
        local checkPass = check.password
        if (checkPass == password) then
            logIn(player, getAccount(username), tostring(password))
            triggerClientEvent(player, "showHide", getRootElement())
            local skinID = exports.fs_sql:_QuerySingle("select * from users where pSkin = ?", SkinTable)
            local toNumberExsSkin = tonumber(skinID)
            setElementModel(source, skinID)
            outputChatBox ( "#34bf49Successful login!", source, 255, 255, 255, true )
            fadeCamera(source, true)
            setCameraTarget(source,source)
        else
            outputChatBox ( "#ff4c4cWrong password!", source, 255, 255, 255, true )
        end
    end
end
addEventHandler("loginRequest", getRootElement(), loginRequest)

and this is my debugscript 3 says:

WARNING: [Core]\fs_loginSystemGui\server.lua:39: Bad argument @ 'setElementModel' [Expected number at argument 2, got nil]

and this is my database:


and in red square i want this number for skin id

Thanks for all help!

 

[AaroN⍩]

Test

SELECT pSkin FROM users WHERE username = ?

It would stay that way, I think:

 

   local skinID = exports.fs_sql:_QuerySingle("SELECT pSkin FROM users WHERE username = ?", username)

Edited December 15, 2022 by AaroN⍩
-

[BenceDev]

34 minutes ago, AaroN⍩ said:

Test

SELECT pSkin FROM users WHERE username = ?

It would stay that way, I think:

 

   local skinID = exports.fs_sql:_QuerySingle("SELECT pSkin FROM users WHERE username = ?", username)

this is not working

debugscript says:
warning: bad argument @ 'setElementModel' [Expected number at argument 2, got table]

[AaroN⍩]

change to:

 setElementModel(player, skinID)

[BenceDev]

3 minutes ago, AaroN⍩ said:

change to:

 setElementModel(player, skinID)

same error

he got table

 

[AaroN⍩]

Send me a private message so I can help you.

[BenceDev]

Just now, AaroN⍩ said:

Send me a private message so I can help you.

okay

 

[alex17"]

            local skinID = exports.fs_sql:_QuerySingle("select * from users where pSkin = ? and username = ?", SkinTable, username)

or 

            local skinID = exports.fs_sql:_QuerySingle("select * from users where username = ? and pSkin = ?", username, SkinTable)

or more simple 

    local check = exports.fs_sql:_QuerySingle("select * from users where username = ? ", username)
    if check then
        local checkPass = check.password
        if (checkPass == password) then
    
           local pSkin = check.pSkin
    ...
    
    

simple

 

 

Edited December 16, 2022 by alex17"

[BenceDev]

12 hours ago, alex17" said:

            local skinID = exports.fs_sql:_QuerySingle("select * from users where pSkin = ? and username = ?", SkinTable, username)

or 

            local skinID = exports.fs_sql:_QuerySingle("select * from users where username = ? and pSkin = ?", username, SkinTable)

or more simple 

    local check = exports.fs_sql:_QuerySingle("select * from users where username = ? ", username)
    if check then
        local checkPass = check.password
        if (checkPass == password) then
    
           local pSkin = check.pSkin
    ...
    
    

simple

 

 

thanks and i test it now

[BenceDev]

UPDATE:

 

It works!
 

@AaroN⍩ and @alex17"

thanks for the help!