Total time online of a player saved in db

[Nana]

Is there any chanse to k now the total time online like a timer that starts when someone login, and stop when someone be afk, or vending or logout or something like these?

I think i can made the stoped part, but i really dont know how inicialize the timer

Do anyone have any clue about this?

Thanks a lot n_n

[Schrwaizer]

You can start by save the login time tick in a variable, just like this:

OnPcLoginEvent:
set tick, gettimetick(2);

When the player logs out, you can subtract the setted tick with an actual tick, then sum it with the value on DB, just like this:

OnPcLogoutEvent:
set time, gettimetick(2) - tick;

This will give you the time (in seconds) that the player were online. I'll let the queries part up to you!

[Nana]

Great!! thanks a lot n_n

I'll give a shot with this n_n!!!

[Emistry]

should be like this...

OnPCLoginEvent:
@login_time = gettimetick(2);
end;
OnPCLogoutEvent:
#online_time += ( gettimetick(2) - @login_time );
end;

[Schrwaizer]

should be like this...

OnPCLoginEvent:
@login_time = gettimetick(2);
end;
OnPCLogoutEvent:
#online_time += ( gettimetick(2) - @login_time );
end;

@login_time will be deleted after "end;"

And, yes, it would be a better idea to store it on an account variable.

[Emistry]

yes...because we dont need to save it permanently....

we only need a permanent variable to store total online time..not the "different" between login time and logout time..

your method that shown in above...

the "time" variable will be reset and assigned with new value everytime they login and logout....

[Schrwaizer]

I did it that way because she said to store it on Database. I was expecting her to make a query that updates the old value plus the new "time" value, so there woudn't be problems on reseting the variable everytime the players logon again.

As I said, "I'll let the queries part up to you!"...

Edited December 30, 2012 by Schrwaizer

[Nana]

thanks n_n

[Ajjwidjdneidjenw]

Emistry's script does exactly the same to what your script does, but in a cleaner fashion. "@login_time" is your "tick", and since "Tick" 's value will change again upon login, it is pointless to have it as a permanent variable stored in the database. The Variable Emistry used, isn't deleted upon 'end' but upon server restart.

[vip53041]

Hello, i know its an old post,

 

what is there any command to type on chat to get total time played in the whole life of the character?

 

 

Thank you.