#17290Frontend user groups not sorted in frontend admin panel (with solution)
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)