[geeklog-cvs] geeklog: Added pgsql compatible query in SEC_getTokenExpiryTime

[geeklog-cvs at lists.geeklog.net]

changeset 7688:be8df121a43e
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/be8df121a43e
user: stan
date: Sat Jan 30 14:50:32 2010 -0500
description:
Added pgsql compatible query in SEC_getTokenExpiryTime

diffstat:

 system/lib-security.php |  3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diffs (13 lines):

diff -r 0e5eab10e7e0 -r be8df121a43e system/lib-security.php
--- a/system/lib-security.php	Sat Jan 30 19:59:04 2010 +0100
+++ b/system/lib-security.php	Sat Jan 30 14:50:32 2010 -0500
@@ -1392,7 +1392,8 @@
 
         $sql['mysql'] = "SELECT UNIX_TIMESTAMP(DATE_ADD(created, INTERVAL ttl SECOND)) AS expirytime FROM {$_TABLES['tokens']} WHERE (token = '$token') AND (owner_id = '{$_USER['uid']}') AND (ttl > 0)";
         $sql['mssql'] = "SELECT UNIX_TIMESTAMP(DATEADD(ss, ttl, created)) AS expirytime FROM {$_TABLES['tokens']} WHERE (token = '$token') AND (owner_id = '{$_USER['uid']}') AND (ttl > 0)";
-
+        $sql['pgsql'] = "SELECT UNIX_TIMESTAMP(created) + ttl AS expirytime FROM {$_TABLES['tokens']} WHERE (token = '$token') AND (owner_id = '{$_USER['uid']}') AND (ttl > 0)";
+        
         $result = DB_query($sql);
         if (DB_numRows($result) == 1) {
             list($retval) = DB_fetchArray($result);