Jump to content

mysql got boolean??


Diverti

Recommended Posts

Posted

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 
  

Posted
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.

San Andreas Utopia RPG (SAUR) Owner & Developer.

560x95_FFFFFF_FF9900_000000_000000.png

Education is the most powerful weapon which you can use to change the world.

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...