Solved SQL - os.time() / how i use " os.time() " in mysql?[PHP]

[milbradt]

The lua language using :

os.time()

How do the same for mysql?


Example in lua:

getPlayerStorageValue(uid, storage, os.time() + time)

In sql would it?(page php)

$SQL->query("INSERT INTO `player_storage` (`player_id` ,`key` ,`value`) VALUES ('".$player->getId()."', '999', 'UNIX_TIMESTAMP('time')')");

 

[HalfAway]

Both UNIX_TIMESTAMP() and time() is the same.

UNIX timestamps are the number of seconds since midnight of January 1, 1970 in UTC.

Post the full script if you need more help.

 

[milbradt]

Both UNIX_TIMESTAMP() and time() is the same.

UNIX timestamps are the number of seconds since midnight of January 1, 1970 in UTC.

Post the full script if you need more help.

Thanks!
Solved.

PHP:

$TEST = time() + 24*60*60;
$SQL->query("INSERT INTO `player_storage` (`player_id` ,`key` ,`value`) VALUES ('".$player->getId()."', '999', '.$TEST.'')");