Issue Feature Closed

#17290Frontend user groups not sorted in frontend admin panel (with solution)

Jonas Felix 05/10/07, 00:09 updated 10/02/18, 12:39

Description

The select box of ‘simulate frontend user group’ is not sorted, the groups are displaied in the order they where added (uid).

That makes it realy hard to select a group out of a big list of groups.

Solution:

Replace the current exec_SELECTquery( in the file t3lib/class.t3lib_tsfebeuserauth.php on line 295 with:

$res = $GLOBALS[‘TYPO3_DB’]->exec_SELECTquery(
‘fe_groups.uid, fe_groups.title’,
‘fe_groups,pages’,
‘pages.uid=fe_groups.pid AND pages.deleted=0 ‘.t3lib_BEfunc::deleteClause(‘fe_groups’).’ AND ‘.$this->getPagePermsClause(1),
‘’,
‘fe_groups.title ASC’
);
(issue imported from #M5593)

Reviews 2