[geeklog-cvs] geeklog: ..

[geeklog-cvs at lists.geeklog.net]

changeset 7633:d363b888855e
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/d363b888855e
user: stan <yankees26an at gmail.com>
date: Wed Jul 15 13:49:22 2009 -0400
description:
..

diffstat:

 plugins/links/functions.inc |  6 ++++--
 1 files changed, 4 insertions(+), 2 deletions(-)

diffs (21 lines):

diff -r 8581fcb9b0b9 -r d363b888855e plugins/links/functions.inc
--- a/plugins/links/functions.inc	Wed Jul 15 12:03:31 2009 -0400
+++ b/plugins/links/functions.inc	Wed Jul 15 13:49:22 2009 -0400
@@ -365,13 +365,15 @@
 */
 function plugin_dopluginsearch_links($query, $datestart, $dateend, $topic, $type, $author, $keyType, $page, $perpage)
 {
-    global $_TABLES, $LANG_LINKS;
+    global $_TABLES, $LANG_LINKS,$_DB_dbms;
 
     // Make sure the query is SQL safe
     $query = trim(addslashes($query));
 
     $sql = "SELECT lid AS id, title, description, UNIX_TIMESTAMP(date) AS date, owner_id AS uid, hits, CONCAT('/links/portal.php?what=link&item=', lid) AS url ";
-    $sql .= "FROM {$_TABLES['links']} WHERE date <> 1 ";
+    $sql .= "FROM {$_TABLES['links']} WHERE date";
+    if($_DB_dbms=='pgsql'){$sql .='<> NULL ';}
+    else{$sql .=" <> 1 "; }
     $sql .= COM_getPermSQL('AND') . ' ';
 
     if (!empty($datestart) && !empty($dateend))