utility Online Gaming Time

[goddameit 52]

Preview: 
http://goo.gl/GUwpM5

 
Info: Tell you how long you're online.
 
Download:
script - http://pastebin.com/gYVYqgpF
sql - http://pastebin.com/HTL3wEhz

Edited January 19, 2015 by goddameit

[evilpuncker 504]

thanks =D

[Thunderbolt 3]

Simple script Online exchange Point ?

[goddameit 52]

Simple script Online exchange Point ?

 

prontera,150,180,4      script  OnlineGamingTime        100,{        .@tick = 0;        query_sql "UPDATE `onlinetime` SET `total_sec` = `total_sec` + TIMESTAMPDIFF(SECOND, `start_time`,  NOW()), `start_time` = NOW() WHERE `account_id` = "+getcharid(3);        query_sql "SELECT `total_sec` FROM `onlinetime` WHERE `account_id` = "+getcharid(3), .@tick;        mes "Your online time is:";        mes "[ "+callfunc("Time2Str", gettimetick(2)+.@tick)+" ]";        @tick = .@tick;        if(prompt("[100t ---> 1p]", "[close]") == 1 && @tick >= 100) {                @tick -= 100;                #CASHPINTS += 1;        }        query_sql "UPDATE `onlinetime` SET `total_sec` = "+@tick+" WHERE `account_id` = "+getcharid(3);        .@tick = 0;        @tick = 0;        close;

Edited February 18, 2015 by goddameit

[Thunderbolt 3]

Thank you sir ^ ^

[Kong 9]

@@goddameit

 

Is it possible to capture a player's entire online time? Like it would help determine if a player has been playing for 20 hours (that could be used in a referral system where GMs need to check if the player has been active for a definite time before reward will be given to the referrer)

[InFiNiTe 0]

Is it possible for this to count the actual online time and not the entire online time?

[Begin 11]

Hello Sir,

I am getting this error when I query:

MySQL said: 

#1067 - Invalid default value for 'start_time'

[minx123 2]

hi.

i got this error 

[Debug]: script debug : 0 110012807 : [OnlineTime]: Auto-Backup player date.

can i know what the problem?