Save Playtime

[Nameless]

Hello,

Can anybody tell me how to save the time played for a player?

I need to start the time count when somebody logs in and stop the time count when he logs out or quits. (in a sqlite database)

I hope you guys can help me!

//Nameless

[Anderl]

local aPlayerTime = { } 
  
addEventHandler( 'onPlayerLogin', root, 
    function( ) 
        if( not aPlayerTime[ source ] ) then 
            aPlayerTime[ source ] = { iTime = getTickCount( ), bLoggedOut = false } 
        end 
    end 
) 
  
function getPlayerPlayTime( pPlayer ) 
    if( aPlayerTime[ pPlayer ] ) then 
        -- convert player play time from ms to hour:minute:second 
        return --[[ time converted ]] aPlayerTime[ pPlayer ] 
    end 
    return false 
end 
  
addEventHandler( 'onPlayerLogout', root, 
    function( ) 
        local endTime = getTickCount( ) 
        aPlayerTime[ source ].iTime = aPlayerTime[ source ].iTime - endTime 
        aPlayerTime[ source ].bLoggedOut = true 
    end  
) 
  
addEventHandler( 'onPlayerQuit', root, 
    function( ) 
        if( aPlayerTime[ source ].bLoggedOut ) then 
            return 
        end 
         
        local endTime = getTickCount( ) 
        aPlayerTime[ source ].iTime = aPlayerTime[ source ].iTime - endTime 
    end 
) 

Now edit it to SQL.

[denny199]

or just this:

https://community.multitheftauto.com/ind ... ls&id=4784

Searching is a good way to find good stuff

But when your'e searching you'll never learn it

[_Dark_]

or just this:

https://community.multitheftauto.com/ind ... ls&id=4784

Searching is a good way to find good stuff

But when your'e searching you'll never learn it

1 second timer for updating player game time? Bad.

[denny199]

or just this:

https://community.multitheftauto.com/ind ... ls&id=4784

Searching is a good way to find good stuff

But when your'e searching you'll never learn it

1 second timer for updating player game time? Bad.

that isn't my script.

... I'm here for helping not for discussing, for the second time:

Searching is a good way to find good stuff

But when your'e searching you'll never learn it

gosh, why replying man?

you can help me too, without be replaying on my posts, with negative comments.

[_Dark_]

denny199, I didn't say anything to you personally.

[robhol]

Does everything have to become some kind of quarrel around here? Dark is right - doing it one second at a time is stupid. Let it drop.

[denny199]

pfffffff, only just helping someone and then getting a negative comment wow, nice. I'm out off this

[Nameless]

local aPlayerTime = { } 
  
addEventHandler( 'onPlayerLogin', root, 
    function( ) 
        if( not aPlayerTime[ source ] ) then 
            aPlayerTime[ source ] = { iTime = getTickCount( ), bLoggedOut = false } 
        end 
    end 
) 
  
function getPlayerPlayTime( pPlayer ) 
    if( aPlayerTime[ pPlayer ] ) then 
        -- convert player play time from ms to hour:minute:second 
        return --[[ time converted ]] aPlayerTime[ pPlayer ] 
    end 
    return false 
end 
  
addEventHandler( 'onPlayerLogout', root, 
    function( ) 
        local endTime = getTickCount( ) 
        aPlayerTime[ source ].iTime = aPlayerTime[ source ].iTime - endTime 
        aPlayerTime[ source ].bLoggedOut = true 
    end  
) 
  
addEventHandler( 'onPlayerQuit', root, 
    function( ) 
        if( aPlayerTime[ source ].bLoggedOut ) then 
            return 
        end 
         
        local endTime = getTickCount( ) 
        aPlayerTime[ source ].iTime = aPlayerTime[ source ].iTime - endTime 
    end 
) 

Now edit it to SQL.

Thank you very much Anderl!

[Anderl]

You're welcome.

['LinKin]

Hey,

so I'm using the guy's code

local aPlayerTime = { } 
  
addEventHandler( 'onPlayerLogin', root, 
    function( ) 
        if( not aPlayerTime[ source ] ) then 
            aPlayerTime[ source ] = { iTime = getTickCount( ), bLoggedOut = false } 
        end 
    end 
) 
  
function getPlayerPlayTime( pPlayer ) 
    if( aPlayerTime[ pPlayer ] ) then 
        -- convert player play time from ms to hour:minute:second 
        return --[[ time converted ]] aPlayerTime[ pPlayer ] 
    end 
    return false 
end 
  
addEventHandler( 'onPlayerLogout', root, 
    function( ) 
        local endTime = getTickCount( ) 
        aPlayerTime[ source ].iTime = aPlayerTime[ source ].iTime - endTime 
        aPlayerTime[ source ].bLoggedOut = true 
    end 
) 
  
addEventHandler( 'onPlayerQuit', root, 
    function( ) 
        if( aPlayerTime[ source ].bLoggedOut ) then 
            return 
        end 
        
        local endTime = getTickCount( ) 
        aPlayerTime[ source ].iTime = aPlayerTime[ source ].iTime - endTime 
    end 
) 

But I got one question.

In the table aPlayerTime, you insert a position (aPlayerTime[ source ] = { iTime = getTickCount( ), bLoggedOut = false })

So the question is, as soon as a player quits the server, is that row deleted from the table?

I don't understand very well they way it works.

[myonlake]

No, it does not. For that reason you should instead of using player element as array key, use a unique key like account ID or so. This way you can always get the saved player time without getting an error of undefined element after the player has quit.