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.