[geeklog-devel] [geeklog-cvs] Geeklog-1.x/system lib-security.php, 1.71, 1.72

[Dirk Haun]

Michael Jervis wrote:


>!     if($_DB_dbms == 'mssql') {

>!         $sql = "DELETE FROM {$_TABLES['tokens']} WHERE (DATEADD(ss,

>ttl, created) < NOW())"

>             . " AND (ttl > 0)";

>+     } else {

>+         $sql = "DELETE FROM {$_TABLES['tokens']} WHERE

>(DATE_ADD(created, INTERVAL ttl SECOND) < NOW())"

>+            . " AND (ttl > 0)";

>+     }


$sql can also be an array:

    $sql['mysql'] = ...
    $sql['mssql'] = ...
    DB_query($sql);

bye, Dirk


-- 
http://www.haun-online.de/
http://spam.tinyweb.net/