diff options
| author | svncommit <devs@roundcube.net> | 2005-10-25 15:04:17 +0000 |
|---|---|---|
| committer | svncommit <devs@roundcube.net> | 2005-10-25 15:04:17 +0000 |
| commit | d7cb77414c4cf074269b6812c3dd3571ee29afca (patch) | |
| tree | 8c29185f134c6c5135746bcda47459e4e1879850 /program/steps/addressbook/list.inc | |
| parent | e0ed972884aff33465ac551c8ef06febb57e4c54 (diff) | |
more pear/mdb2 integration
Diffstat (limited to 'program/steps/addressbook/list.inc')
| -rw-r--r-- | program/steps/addressbook/list.inc | 26 |
1 files changed, 12 insertions, 14 deletions
diff --git a/program/steps/addressbook/list.inc b/program/steps/addressbook/list.inc index 4ed092541..ecb634b6f 100644 --- a/program/steps/addressbook/list.inc +++ b/program/steps/addressbook/list.inc @@ -22,12 +22,11 @@ $REMOTE_REQUEST = TRUE; // count contacts for this user -$sql_result = $DB->query(sprintf("SELECT COUNT(contact_id) AS rows - FROM %s - WHERE del!='1' - AND user_id=%d", - get_table_name('contacts'), - $_SESSION['user_id'])); +$sql_result = $DB->query("SELECT COUNT(contact_id) AS rows + FROM ".get_table_name('contacts')." + WHERE del<>'1' + AND user_id=?", + $_SESSION['user_id']); $sql_arr = $DB->fetch_assoc($sql_result); $rowcount = $sql_arr['rows']; @@ -40,14 +39,13 @@ $commands .= sprintf("this.set_env('pagecount', %d);\n", $pages); $start_row = ($CONTACTS_LIST['page']-1) * $CONFIG['pagesize']; // get contacts from DB -$sql_result = $DB->query(sprintf("SELECT * FROM %s - WHERE del!='1' - AND user_id=%d - ORDER BY name", - get_table_name('contacts'), - $_SESSION['user_id']), - $start_row, - $CONFIG['pagesize']); +$sql_result = $DB->limitquery("SELECT * FROM ".get_table_name('contacts')." + WHERE del<>'1' + AND user_id=? + ORDER BY name", + $start_row, + $CONFIG['pagesize'], + $_SESSION['user_id']); $commands .= rcmail_js_contacts_list($sql_result); |