7 day items: time in items BBD table?

[kube]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

Hi, i'm searching how the server calcule the time for insert a new 7 day item to one user. I'm trying with date/mktime function but i can't obtain a correct timestamp value. How i can calculate this value?

Regards.

[Flashy]

other question, what is the target? why u want calc this value?

[kube]

I'm trying get a 7 day horse reward for vote my server, then i use the INSERT mysql function with the correct values (owner_id, item_id...) but i can't get the value for the variable "time" for a 7 day items.

If i create ingame this item, i obtain this value (for now):

1297786714574

How i can obtain this value in php for isert it in the database?

I'm tryed using date and mktime functions for obtain a timestamp, but is not work.

How the server obtain this value??

[Flashy]

in php.. use function: microtime() it return the unix timestamp within milisec. was what ur question?
this is exact the value u need for db insert...

example:

Code: Select all

   //Return the unix timestamp + microseconds  function micro_time()  {    $timearray = explode(" ", microtime());    return ($timearray[1] + $timearray[0]);  } 

[jurchiks]

it's unixtime in milliseconds.

[kube]

Ok, my unixtime was in seconds

Thx for ur time!!!!

PD: Solved.