Jump to content

mysql got boolean??


Diverti

Recommended Posts

Hello! I use mysql resource. I want to use setPlayerName to set the name of the player to his/her admin name.

Somehow, it isn't work :(

  
function nevcsere(jatekos) 
            local adminnev = exports.mysql:query_free("SELECT adminnev FROM felhasznalok WHERE " .. mysql:escape_string(getElementData(thePlayer,"account:id"))) 
            setPlayerName(jatekos, adminnev) 
            end 
            addCommandHandler("adminnev", nevcsere) 
  

Any idea? :?

  
ERROR: mysql\connection.lua:210 bad argument #2 to'mysql_escape_string' (string expected, got boolean) 
ERROR: call: failed to call 'mysql:escape_string' [string"?"] 
ERROR: admins\s_nevcsere.lua:2: attempt to concatenate a boolean value 
  

Link to comment
function nevcsere ( jatekos ) 
    local adminnev = exports.mysql:query_free ( "SELECT adminnev FROM felhasznalok WHERE ".. mysql:escape_string ( getElementData ( jatekos, "account:id" ) ) ) 
    setPlayerName ( jatekos, adminnev ) 
end 
addCommandHandler ( "adminnev", nevcsere ) 

You were using the argument "thePlayer" but it was not defined, you had to change it to "jatekos" at getElementData.

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...