Changeset 6667 for branches/2.1/include/functions_session.inc.php

Timestamp:

07/06/10 14:17:37 (3 years ago)

Author:

nikrou

Message:

Bug 1766 fixed : [PostgreSQL] unkown database function UNIX_TIMESTAMP()
Add a new function pwg_db_date_to_ts() to calculate a timestamp from a date
Merge from trunk

Files:

• branches/2.1/include/functions_session.inc.php (modified) (1 diff)

branches/2.1/include/functions_session.inc.php

@@ -176 +176 @@
 DELETE
   FROM '.SESSIONS_TABLE.'
-  WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(expiration) > '
+  WHERE '.pwg_db_date_to_ts('NOW()').' - '.pwg_db_date_to_ts('expiration').' > '
   .$conf['session_length'].'
 ;';