cvs: pear /Perm_LiveUser/Admin/Perm DB_Common.php MDB_Common.php

arnaud Mon Oct 6 13:39:30 2003 EDT Modified files: /pear/Perm_LiveUser/Admin/Perm MDB_Common.php DB_Common.php Log: * add GROUP BY statement to query Index: pear/Perm_LiveUser/Admin/Perm/MDB_Common.php diff -u pear/Perm_LiveUser/Admin/Perm/MDB_Common.php:1.13 pear/Perm_LiveUser/Admin/Perm/MDB_Common.php:1.14 --- pear/Perm_LiveUser/Admin/Perm/MDB_Common.php:1.13 Mon Oct 6 13:31:12 2003 +++ pear/Perm_LiveUser/Admin/Perm/MDB_Common.php Mon Oct 6 13:39:30 2003 @@ -33,7 +33,7 @@ * MDB based containers used to maintain * the permission database. * - * @version $Id: MDB_Common.php,v 1.13 2003/10/06 17:31:12 arnaud Exp $ + * @version $Id: MDB_Common.php,v 1.14 2003/10/06 17:39:30 arnaud Exp $ * @package LiveUser */ class LiveUser_Admin_Perm_MDB_Common extends LiveUser_Admin_Perm_Common @@ -1451,6 +1451,8 @@ translations.section_type = ' . LIVEUSER_SECTION_RIGHT . ' AND translations.language_id = ' . $this->dbc->getIntegerValue($this->_langs[$this->getCurrentLanguage()]) . ' + GROUP BY + right_id ORDER BY rights.area_id ASC'; Index: pear/Perm_LiveUser/Admin/Perm/DB_Common.php diff -u pear/Perm_LiveUser/Admin/Perm/DB_Common.php:1.21 pear/Perm_LiveUser/Admin/Perm/DB_Common.php:1.22 --- pear/Perm_LiveUser/Admin/Perm/DB_Common.php:1.21 Mon Oct 6 13:31:12 2003 +++ pear/Perm_LiveUser/Admin/Perm/DB_Common.php Mon Oct 6 13:39:30 2003 @@ -33,7 +33,7 @@ * DB based containers used to maintain * the permission database. * - * @version $Id: DB_Common.php,v 1.21 2003/10/06 17:31:12 arnaud Exp $ + * @version $Id: DB_Common.php,v 1.22 2003/10/06 17:39:30 arnaud Exp $ * @package LiveUser */ class LiveUser_Admin_Perm_DB_Common extends LiveUser_Admin_Perm_Common @@ -1401,6 +1401,8 @@ translations.section_type = ' . LIVEUSER_SECTION_RIGHT . ' AND translations.language_id = ' . (int)($this->_langs[$this->getCurrentLanguage()]) . ' + GROUP BY + right_id ORDER BY rights.area_id ASC';