setPlayerName problem

[dugasz1]

Hi! (Sorry for my bad english )

I got some problem whit the setPlayerName.

function onLogin ( player, user, pass ) 
    handler = mysql_connect( host, username, password, db ) 
    local login = mysql_query(handler,"SELECT * FROM account_data WHERE AccountName = '"..mysql_escape_string( handler, user ).."' AND Password = '"..mysql_escape_string( handler, md5(pass) ).."';") 
    if login then 
        local rows = mysql_num_rows(login) 
        if rows == 1 then 
            local adat = mysql_fetch_assoc(login) 
            triggerClientEvent( player, "closeWindow", getRootElement() ) 
            outputChatBox("* Login succes! Welcome "..adat['AccountName'].."!", player, 255, 0, 0) 
            spawnPlayer( player, adat['x'], adat['y'], adat['z'], 0, JoinSkin )  
            fadeCamera( player, true ) 
            setCameraTarget( player, player ) 
            giveWeapon( player, joinWeapon, joinAmmo ) 
            setPlayerMoney( player, adat['penz'] ) 
            setPedArmor ( player, adat['armor'] ) 
            setElementHealth ( player, adat['hp'] ) 
            setPlayerName ( source , adat['IGName']) 
        else 
            outputChatBox("* Login failed!", player, 255, 0, 0) 
        end 
        mysql_free_result(login) 
    end 
end 

Everything working fine , i get the money,hp,armor... but my name still the original. No error message nothing. I trying to search for answers but i can't fix it. I'm very beginner somebody explain to me simple what's wrong

Thanks

Edited May 8, 2013 by Guest

[Castillo]

setPlayerName ( source , adat['IGName']) 

You are using 'source' there, but on your other functions you use 'player'.

[dugasz1]

oops Thats just a fail. I trying it whit player too but the same problem

Here the client side maybe it's help to find out what's the problem:

(user_edit_l = the player login name pw_edit_l = the password)

function login_player ( source ) 
        triggerServerEvent ( "onLogin", getRootElement(), getLocalPlayer(), guiGetText(user_edit_l), guiGetText(pw_edit_l) ) 
end 
addEventHandler("onClientGUIClick", login_btn_l, login_player,false) 

And the i forgot the adEvent

addEvent( "onLogin", true ) 
addEventHandler( "onLogin", getRootElement(), onLogin ) 

[iPrestege]

triggerServerEvent ( "onLogin", getRootElement(), getLocalPlayer(), guiGetText(user_edit_l), guiGetText(pw_edit_l) ) 

Should Be :

triggerServerEvent ( "onLogin", getLocalPlayer(), guiGetText(user_edit_l), guiGetText(pw_edit_l) ) 

[dugasz1]

Now i got an error message:

WARNING: sawmode\sawmode.lua:48 Bad argument @ 'md5' 
ERORR: sawmode\sawmode.lua:48 Bad argument #2 to 'mysql_escape_string' <string expected got boolean> 

[dugasz1]

huu Sorry, i fixed the problem. I saw a server where we can use space to my character name but it don't support space in the setPlayerName

[Renkon]

huu Sorry, i fixed the problem. I saw a server where we can use space to my character name but it don't support space in the setPlayerName

That're nametags.

[dugasz1]

I know it isnt change the name in settings(it's good for me now) but i doesen't know how i can call it.

[Castillo]

You can change their nametag text with:

setPlayerNametagText 

It won't change the display name on chat though.

[dugasz1]

Now i know how make the server to use space in the names. Thanks for help

[Castillo]

You're welcome.