From 4a4751f5e504ae457ca99ca19a1531190c527e71 Mon Sep 17 00:00:00 2001
From: thomascube <thomas@roundcube.net>
Date: Thu, 17 May 2007 15:59:56 -0400
Subject: [PATCH] Better SQL query for contact listing/search (closes #1484369)
---
program/include/rcube_contacts.inc | 14 +++++++-------
1 files changed, 7 insertions(+), 7 deletions(-)
diff --git a/program/include/rcube_contacts.inc b/program/include/rcube_contacts.inc
index cc801c6..3902e2a 100644
--- a/program/include/rcube_contacts.inc
+++ b/program/include/rcube_contacts.inc
@@ -24,7 +24,7 @@
var $db = null;
var $db_name = '';
var $user_id = 0;
- var $filter = '1';
+ var $filter = null;
var $result = null;
var $search_fields;
var $search_string;
@@ -115,7 +115,7 @@
function reset()
{
$this->result = null;
- $this->filter = '1';
+ $this->filter = null;
$this->search_fields = null;
$this->search_string = null;
}
@@ -142,9 +142,9 @@
$sql_result = $this->db->limitquery(
"SELECT * FROM ".$this->db_name."
WHERE del<>1
- AND user_id=?
- AND (".$this->filter.")
- ORDER BY name",
+ AND user_id=?" .
+ ($this->filter ? " AND (".$this->filter.")" : "") .
+ " ORDER BY name",
$start_row,
$length,
$this->user_id);
@@ -213,8 +213,8 @@
"SELECT COUNT(contact_id) AS rows
FROM ".$this->db_name."
WHERE del<>1
- AND user_id=?
- AND (".$this->filter.")",
+ AND user_id=?".
+ ($this->filter ? " AND (".$this->filter.")" : ""),
$this->user_id);
$sql_arr = $this->db->fetch_assoc($sql_result);
--
Gitblit v1.9.1