[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/