From 18911a8c50581359ea238474810a64cd0d60e377 Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Wed, 20 Jan 2010 15:25:38 +0100 Subject: [PATCH] Remove superfluous AS which doesn't work with Oracle. --- framework/Share/Share/sql.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/framework/Share/Share/sql.php b/framework/Share/Share/sql.php index b5664509e..f2d5f7d86 100644 --- a/framework/Share/Share/sql.php +++ b/framework/Share/Share/sql.php @@ -705,7 +705,7 @@ class Horde_Share_sql extends Horde_Share { $where .= ' OR (' . Horde_SQL::buildClause($this->_db, 's.perm_default', '&', $perm) . ')'; // (name == perm_users and key == $userid and val & $perm) - $query .= ' LEFT JOIN ' . $this->_table . '_users AS u ON u.share_id = s.share_id'; + $query .= ' LEFT JOIN ' . $this->_table . '_users u ON u.share_id = s.share_id'; $where .= ' OR ( u.user_uid = ' . $this->_write_db->quote($userid) . ' AND (' . Horde_SQL::buildClause($this->_db, 'u.perm', '&', $perm) . '))'; @@ -720,7 +720,7 @@ class Horde_Share_sql extends Horde_Share { foreach ($ids as $id) { $group_ids[] = $this->_db->quote($id); } - $query .= ' LEFT JOIN ' . $this->_table . '_groups AS g ON g.share_id = s.share_id'; + $query .= ' LEFT JOIN ' . $this->_table . '_groups g ON g.share_id = s.share_id'; $where .= ' OR (g.group_uid IN (' . implode(',', $group_ids) . ')' . ' AND (' . Horde_SQL::buildClause($this->_db, 'g.perm', '&', $perm) . '))'; } elseif (is_a($groups, 'PEAR_Error')) { -- 2.11.0