From 929a508d801d9434c8d98dccd0311e3a707303ba Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Mon, 01 Mar 2010 14:04:34 -0500 Subject: [PATCH] - Improve performance by avoiding unnecessary updates to the session table (#1486325) --- program/include/rcube_user.php | 5 ++--- 1 files changed, 2 insertions(+), 3 deletions(-) diff --git a/program/include/rcube_user.php b/program/include/rcube_user.php index 127efa7..ab44cdc 100644 --- a/program/include/rcube_user.php +++ b/program/include/rcube_user.php @@ -47,7 +47,7 @@ if ($id && !$sql_arr) { - $sql_result = $this->db->query("SELECT * FROM ".get_table_name('users')." WHERE user_id=?", $id); + $sql_result = $this->db->query("SELECT * FROM ".get_table_name('users')." WHERE user_id=?", $id); $sql_arr = $this->db->fetch_assoc($sql_result); } @@ -154,8 +154,7 @@ // get contacts from DB $sql_result = $this->db->query( "SELECT * FROM ".get_table_name('identities')." - WHERE del<>1 - AND user_id=? + WHERE del<>1 AND user_id=? $sql_add ORDER BY ".$this->db->quoteIdentifier('standard')." DESC, name ASC, identity_id ASC", $this->ID); -- Gitblit v1.9.1