Problem with executeSQLInsert and onPlayerLogin

[BennyBunny]

I work atm on a save system and Scorebord system too for my server.

The problem is when i try to load executeSQLInsert over onPlayerLogin nothing save

But when i use the same script not over onPlayerLogin everything is fine

I wanna check is the player login for save kills... and when the player not login he can play normal with no save.

Before i had this login windows from the mta website but i dont like them so i try my way

I have try to load my script over /register but there was the same problem like in onPlayerLogin idk why

OK here is the problem script:

function playerloginsystem ( source )  
  
  
    local namelogin = getPlayerName ( source ) 
  
    checklogin = executeSQLSelect ( "playersave", "playerdb", "playerdb = '" .. namelogin .. "'" ) 
  
    if ( type( checklogin ) == "table" and #checklogin == 0 ) or not checklogin then -- see if any data was found at all 
  
            local userforregister = getPlayerName ( source ) 
  
        executeSQLInsert ( "playersave", "'" .. userforregister .. "', '2', '2', '2', '2', 'Register', '2'" )  --add the first data in the user table 
  
        setElementData ( source, "Status", "Register") 
  
    else 
  
            -- Data from db to scoreboard for register user 
   
            readKillsFromdb = executeSQLQuery ( "SELECT Killsdb FROM playersave WHERE playerdb=?", namelogin ) 
  
            readDeathsFromdb = executeSQLQuery ( "SELECT deathdb FROM playersave WHERE playerdb=?", namelogin ) 
  
            readPointsFromdb = executeSQLQuery ( "SELECT funpoints FROM playersave WHERE playerdb=?", namelogin ) 
  
            readMoneyFromdb = executeSQLQuery ( "SELECT money FROM playersave WHERE playerdb=?", namelogin ) 
  
            readStatusFromdb = executeSQLQuery ( "SELECT statusdb FROM playersave WHERE playerdb=?", namelogin ) 
  
  
        setElementData ( source, "Kills", readKillsFromdb[1].Killsdb ) 
  
            setElementData ( source, "Death", readDeathsFromdb[1].deathdb ) 
  
            setElementData ( source, "Fun Points", readPointsFromdb[1].funpoints ) 
  
            setElementData ( source, "Money", readMoneyFromdb[1].money ) 
  
            setElementData ( source, "Status", readStatusFromdb[1].statusdb ) 
  
  
            outputChatBox ("All your data are load! Have fun!", source) 
  
     end 
  
end 
  
addEventHandler ( "onPlayerLogin", getRootElement(), playerloginsystem ) 

I know it is not perfect but easy to understand for me, atm i learn so i try the easy way

[Castillo]

function playerloginsystem ( ) 
    local namelogin = getPlayerName ( source ) 
    local checklogin = executeSQLSelect ( "playersave", "playerdb", "playerdb = '" .. namelogin .. "'" ) 
    if ( type( checklogin ) == "table" and #checklogin == 0 ) or not checklogin then -- see if any data was found at all 
        local userforregister = getPlayerName ( source ) 
        executeSQLInsert ( "playersave", "'" .. userforregister .. "', '2', '2', '2', '2', 'Register', '2'" )  --add the first data in the user table 
        setElementData ( source, "Status", "Register") 
     else 
            -- Data from db to scoreboard for register user 
            readFromDB = executeSQLQuery ( "SELECT * FROM playersave WHERE playerdb=?", namelogin ) 
  
            setElementData ( source, "Kills", readFromDB[1].Killsdb ) 
  
            setElementData ( source, "Death", readFromDB[1].deathdb ) 
  
            setElementData ( source, "Fun Points", readFromDB[1].funpoints ) 
  
            setElementData ( source, "Money", readFromDB[1].money ) 
  
            setElementData ( source, "Status", readFromDB[1].statusdb ) 
  
            outputChatBox ("All your data are load! Have fun!", source) 
     end 
end 
addEventHandler ( "onPlayerLogin", getRootElement(), playerloginsystem ) 

Try that.