[killergirl]

Not all the time, but sometimes get_systime() is returning me 0. I don't know why...

Is there any other function to get the current time in seconds format?

[Exolent[jNr]]

In what case is it happening?

[killergirl]

I'm sending a query to a mysql server when a player has disconnected

PHP Code:

static query[256]

formatex(query, charsmax(query), "INSERT INTO `asd` (id, timestamp) VALUES ('', '%d')", get_systime() ) 


In some cases, the get_systime() is returning 0 or 1. I don't know why...

[Exolent[jNr]]

How do you know it is returning 0 or 1?

[meTaLiCroSS]

Are you sure that "timestamp" field it's an INT ?

[killergirl]

@meta
Yes, is it INT (11).

Like I said, in some cases, not all the time. When I'm getting information from the database, in some cases when I convert them into php date, the date is 1970 (because the timestamp is 0).

@exolent
Because I wrote a function for debug, I'm sending & logging all the queries sent to mysql server.

[lucas_7_94]

Do you tried SYSDATE() ?

[meTaLiCroSS]

Originally Posted by lucas_7_94 Do you tried SYSDATE() ?

SYSDATE it's a Date function, it should work with a timestamp field

Also, did you tried creating another field, setting it as timestamp, default 0, and setting "NOW()" instead of passing get_systime() value?

[killergirl]

Originally Posted by meTaLiCroSS SYSDATE it's a Date function, it should work with a timestamp field Also, did you tried creating another field, setting it as timestamp, default 0, and setting "NOW()" instead of passing get_systime() value?

Did you mean I need to remove the get_systime() from the query string and format it with NOW() query?

PHP Code:

INSERT INTO `asd` (
   'id',
   'timestamp') VALUES (
   
   '',
   'NOW()' ) 


This is how you say?

[meTaLiCroSS]

Originally Posted by killergirl Did you mean I need to remove the get_systime() from the query string and format it with NOW() query? PHP Code: INSERT INTO `asd` (    'id',    'timestamp') VALUES (        '',    'NOW()' )  This is how you say?

Yeah, but "timestamp" field should be a "timestamp field" (lol), change his properties, set as default value = 0, and for retrieving the passed value as a unixtime int (timestamp fields are formated like year-month-day hour:minute:second) use "SELECT UNIX_TIMESTAMP(timestamp) FROM shit WHERE id = 1"