[geeklog-cvs] geeklog: fixed token bug

[geeklog-cvs at lists.geeklog.net]

changeset 7640:434d6add3437
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/434d6add3437
user: stan <yankees26an at gmail.com>
date: Mon Jul 20 19:17:07 2009 -0400
description:
fixed token bug

diffstat:

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

diffs (12 lines):

diff -r 63576c4ff14f -r 434d6add3437 system/lib-security.php
--- a/system/lib-security.php	Mon Jul 20 17:46:05 2009 -0400
+++ b/system/lib-security.php	Mon Jul 20 19:17:07 2009 -0400
@@ -1143,7 +1143,7 @@
         if($_DB_dbms != 'mssql') {
             $sql['mysql'] = "SELECT ((DATE_ADD(created, INTERVAL ttl SECOND) < NOW()) AND ttl > 0) as expired, owner_id, urlfor FROM "
                . "{$_TABLES['tokens']} WHERE token='$token'";
-            $sql['pgsql'] = "SELECT ((ROUND(EXTRACT(EPOCH FROM ABSTIME(created))) + (SELECT ttl from {$_TABLES['tokens']} LIMIT 1)) < ROUND(EXTRACT(EPOCH FROM ABSTIME(NOW()))) AND ttl > 0) as expired, owner_id, urlfor FROM "
+            $sql['pgsql'] = "SELECT ((UNIX_TIMESTAMP(created) + ttl) < UNIX_TIMESTAMP() AND ttl > 0)::int4 as expired, owner_id, urlfor FROM "
                . "{$_TABLES['tokens']} WHERE token='$token'";
         } else {
             $sql['mssql'] = "SELECT owner_id, urlfor, expired =