NYCPHP Meetup

[Christopher French]

well here is one way of getting the Joomla ACL list in  joomla 2.5.

$db = JFactory::getDbo();
$query = 'SELECT CONCAT( REPEAT(\'..\', COUNT(parent.id) - 1), node.title)
as text, node.id as value' . ' FROM #__usergroups AS node, #__usergroups AS
parent' . ' WHERE node.lft BETWEEN parent.lft AND parent.rgt' . ' GROUP BY
node.id' . ' ORDER BY node.lft';
$db -> setQuery($query);
$gtree = $db -> loadObjectList();

with that you can do whatever you want


On Mon, Dec 17, 2012 at 1:07 PM, Geoffrey Schaller <gjschaller at psi-13.com>wrote:

> On Mon, Dec 17, 2012 at 3:05 PM, Christopher French <
> contact at chrisfrench.me> wrote:
>
>> I don't know w much about community builder, but do you just want a query
>> to list the Joomla user groups or are these community builder groups
>
>
> Joomla Groups.  The CB part is done already within CB, but there's
> specific groups I want to keep OUT of CB, and handled only by Joomla
> itself.  These are the ones I need to display on the user's profile.
>
> -Geoffrey
>
> _______________________________________________
> New York PHP SIG: Joomla! Mailing List
> http://lists.nyphp.org/mailman/listinfo/joomla
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/joomla/attachments/20121217/0aaaa9f0/attachment.html>