diff options
| author | sparc <sparc@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2005-10-20 16:58:34 +0000 |
|---|---|---|
| committer | sparc <sparc@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2005-10-20 16:58:34 +0000 |
| commit | 0fbe10808875d7fa1c17c28413b34fdde2e0bc53 (patch) | |
| tree | 140ccbfc0bfe93f31ce3a7c664dc19882e21fbb6 /roundcubemail/program/steps | |
| parent | f11c35ceb88fa158129587b626427063bb9b31a7 (diff) | |
added DB LIMIT abstraction
git-svn-id: https://svn.roundcube.net/trunk@47 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/program/steps')
| -rw-r--r-- | roundcubemail/program/steps/addressbook/delete.inc | 7 | ||||
| -rw-r--r-- | roundcubemail/program/steps/addressbook/func.inc | 7 | ||||
| -rw-r--r-- | roundcubemail/program/steps/addressbook/list.inc | 7 |
3 files changed, 9 insertions, 12 deletions
diff --git a/roundcubemail/program/steps/addressbook/delete.inc b/roundcubemail/program/steps/addressbook/delete.inc index 789d84149..e988f5569 100644 --- a/roundcubemail/program/steps/addressbook/delete.inc +++ b/roundcubemail/program/steps/addressbook/delete.inc @@ -65,12 +65,11 @@ if ($_GET['_cid']) $sql_result = $DB->query(sprintf("SELECT * FROM %s WHERE del!='1' AND user_id=%d - ORDER BY name - LIMIT %d, %d", + ORDER BY name", get_table_name('contacts'), - $_SESSION['user_id'], + $_SESSION['user_id']), $start_row, - $count)); + $count); $commands .= rcmail_js_contacts_list($sql_result); diff --git a/roundcubemail/program/steps/addressbook/func.inc b/roundcubemail/program/steps/addressbook/func.inc index 7858a4e88..53628162b 100644 --- a/roundcubemail/program/steps/addressbook/func.inc +++ b/roundcubemail/program/steps/addressbook/func.inc @@ -59,12 +59,11 @@ function rcmail_contacts_list($attrib) $sql_result = $DB->query(sprintf("SELECT * FROM %s WHERE del!='1' AND user_id=%d - ORDER BY name - LIMIT %d, %d", + ORDER BY name", get_table_name('contacts'), - $_SESSION['user_id'], + $_SESSION['user_id']), $start_row, - $CONFIG['pagesize'])); + $CONFIG['pagesize']); } else $sql_result = NULL; diff --git a/roundcubemail/program/steps/addressbook/list.inc b/roundcubemail/program/steps/addressbook/list.inc index 2c5148a91..4ed092541 100644 --- a/roundcubemail/program/steps/addressbook/list.inc +++ b/roundcubemail/program/steps/addressbook/list.inc @@ -43,12 +43,11 @@ $start_row = ($CONTACTS_LIST['page']-1) * $CONFIG['pagesize']; $sql_result = $DB->query(sprintf("SELECT * FROM %s WHERE del!='1' AND user_id=%d - ORDER BY name - LIMIT %d, %d", + ORDER BY name", get_table_name('contacts'), - $_SESSION['user_id'], + $_SESSION['user_id']), $start_row, - $CONFIG['pagesize'])); + $CONFIG['pagesize']); $commands .= rcmail_js_contacts_list($sql_result); |