[Cameltoe]

Quote:

Originally Posted by cyberlord this function count milliseconds so i need to convert them to minutes and hours i need something like formula to do that

It's been a while since i posted here, and i'm quite outdated on the subject. But the way i would do it is to store just minutes. After 60 minutes, reset the variable to zero and send a mysql request to your mysql server telling the timeonline variable to add 60 minutes. I would do this by creating a function for instance:

pawn Код:

stock UpdatePlayerOnlineTime(playerid, DatabaseID, tTime)
{
    new String[80];
    format(string, sizeof(string), "UPDATE `users` SET On‌lineTime = (OnlineTime + %i) WHERE UserID = %i;", tTime, DatabaseID);
    mysql_query(string);
    PlayerVar[playerid][OnlineTime] = 0;
    return 1;
}

Then it can be called whenever you want, f. example on disconnect. I'm sorry if there are any fault in this code, as i have not been active for a very long time now, but if you encounter any problems, i will check back later and try to see if i can solve it.

EDIT: To call it simply (Inside timer):

pawn Код:

if(PlayerVar[playerid][OnlineTime] == 60 || PlayerVar[playerid][OnlineTime] > 60)
{
    UpdatePlayerOnlineTime(playerid, GetPlayerDBID(playerid), PlayerVar[playerid][OnlineTime]);
}