[geeklog-cvs] geeklog: Fixed Links search
geeklog-cvs at lists.geeklog.net
geeklog-cvs at lists.geeklog.net
Mon Dec 22 06:01:30 EST 2008
details: http://project.geeklog.net/cgi-bin/hgweb.cgi/rev/e402d4122df2
changeset: 6582:e402d4122df2
user: Dirk Haun <dirk at haun-online.de>
date: Sun Dec 21 18:39:25 2008 +0100
description:
Fixed Links search
diffstat:
1 file changed, 11 insertions(+), 11 deletions(-)
plugins/links/functions.inc | 22 +++++++++++-----------
diffs (64 lines):
diff -r 67afff11b45f -r e402d4122df2 plugins/links/functions.inc
--- a/plugins/links/functions.inc Sun Dec 21 12:28:09 2008 +0100
+++ b/plugins/links/functions.inc Sun Dec 21 18:39:25 2008 +0100
@@ -363,13 +363,13 @@
// link search
$select = 'SELECT lid,title,url,owner_id,hits,UNIX_TIMESTAMP(date) AS day';
- $sql = " FROM {$_TABLES['links']} WHERE date <> 1 ";
+ $sql = " FROM {$_TABLES['links']} WHERE date <> 1";
if (!empty ($query)) {
if ($keyType == 'phrase') {
$mysearchterm = addslashes ($query);
- $sql .= " AND (description LIKE '%$mysearchterm%')"
- . " OR (title LIKE '%$mysearchterm%')";
+ $sql .= " AND ((description LIKE '%$mysearchterm%')"
+ . " OR (title LIKE '%$mysearchterm%'))";
} else if ($keyType == 'all') {
$mywords = explode (' ', $query);
$sql .= ' AND (';
@@ -377,8 +377,8 @@
foreach ($mywords AS $mysearchterm) {
$mysearchterm = addslashes (trim ($mysearchterm));
if (!empty ($mysearchterm)) {
- $tmp .= "(description LIKE '%$mysearchterm%')"
- . " OR (title LIKE '%$mysearchterm%') AND ";
+ $tmp .= "((description LIKE '%$mysearchterm%')"
+ . " OR (title LIKE '%$mysearchterm%')) AND ";
}
}
$tmp = substr ($tmp, 0, strlen ($tmp) - 5);
@@ -390,16 +390,16 @@
foreach ($mywords AS $mysearchterm) {
$mysearchterm = addslashes (trim ($mysearchterm));
if (!empty ($mysearchterm)) {
- $tmp .= "(description LIKE '%$mysearchterm%')"
- . " OR (title LIKE '%$mysearchterm%') OR ";
+ $tmp .= "((description LIKE '%$mysearchterm%')"
+ . " OR (title LIKE '%$mysearchterm%')) OR ";
}
}
$tmp = substr ($tmp, 0, strlen ($tmp) - 4);
$sql .= $tmp . ')';
} else { // quick search
$mysearchterm = addslashes ($query);
- $sql .= " AND (description LIKE '%$mysearchterm%')"
- . " OR (title LIKE '%$mysearchterm%')";
+ $sql .= " AND ((description LIKE '%$mysearchterm%')"
+ . " OR (title LIKE '%$mysearchterm%'))";
}
}
@@ -415,9 +415,9 @@
}
if (!empty ($author)) {
- $sql .= "AND (owner_id = '$author')";
+ $sql .= " AND (owner_id = '$author')";
}
- $sql .= COM_getPermSQL ('AND');
+ $sql .= COM_getPermSQL('AND');
$sql .= ' GROUP BY date, lid, cid, url, description, title, hits, owner_id, group_id, perm_owner, perm_group, perm_members, perm_anon ORDER BY date DESC';
$l = ($perpage * $page) - $perpage;
$sql .= ' LIMIT ' . $l . ',' . $perpage;
More information about the geeklog-cvs
mailing list