Easy Profile - Joomla Extension

Hi,
sorry for late reply, it's a weekend for us.

try with this code

{source}<?php

    $db=JFactory::getDbo();

	$id = JFactory::getUser(JRequest::getVar('id',null));

    			$query=$db->getQuery(true);

    			$query->select('title')->from('#__usergroups')->where('id IN (SELECT group_id FROM #__user_usergroup_map WHERE user_id = '.(int)$id.')');

    			$db->setQuery($query);

    			$result=$db->loadColumn(); 



    			echo implode(', ',$result); 

    

?>{/source}

Hi,
sorry but we will not add this feature because we do not want to expose usergroups in frontend.

Although is this solution up there still working. It doesn't for me.

try with this code:

<?php 

				$db=JFactory::getDbo();

				$query=$db->getQuery(true);

				$query->select('title')->from('#__usergroups')->where('id IN ('.implode(',',$this->user->getAuthorisedGroups()).')');

				$db->setQuery($query);

				$result=$db->loadColumn(); 

				echo '<div><b>Member of:</b> '.implode(', ',$result).'</div>';  

?>

As a feature I would like to have it as a custom field rather than a fixed info beneath the name.

The faster way is to use a plugin like Sourcerer (https://www.regularlabs.com/extensions/sourcerer) and put the code below in HTML delimiter field type (see Screenshot)

{source}

<?php

$db=JFactory::getDbo();



$user = JFactory::getUser(JRequest::getVar('id',null));

$query=$db->getQuery(true);

$query->select('title')->from('#__usergroups')->where('id IN ('.implode(',',$user->getAuthorisedGroups()).')');

$db->setQuery($query);

$result=$db->loadColumn(); 

echo implode(', ',$result); 

?>

{/source}

NOTES:
- HTML delimiter field type allow you to put a static test in a field position (http://docs.easy-profile.com/index.php/article/html-delimiter-field-type)
- Sourcerer plugin allow you to use PHP code in the all parts that load Joomla content plugins (like HTML delimiter field type)

Although is this solution up there still working. It doesn't for me.
As a feature I would like to have it as a custom field rather than a fixed info beneath the name.
Or is it yet possible to do this with some custom sql query?

Hey.
I really want to back this idea up and maybe we will find this feature in one of the upcoming releases. It would be most useful to be able to view / display the usergroup(s) a user is in in their profile.

Going to try this custom workaround. Thanks!

Hi,
sorry this is not possible natively.

To do this you need to override profile template and add custom code, follow these steps:
- Copy file from /components/com_jsn/views/profile/tmpl/default.php to /templates/your-template-folder/html/com_jsn/profile/default.php
- in the new file add this code after line 101

<?php 

				$db=JFactory::getDbo();

				$query=$db->getQuery(true);

				$query->select('title')->from('#__usergroups')->where('id IN ('.implode(',',$user->getAuthorisedGroups()).')');

				$db->setQuery($query);

				$result=$db->loadColumn(); 

				echo '<div>Member of: '.implode(', ',$result).'</div>';  

?>

Sorry, my english is not so good. From Joomla. I have several user groups in Joomla and would like to see them in the profile.

Sorry, but I can not understand, can you explain me better?

Memberships from which component?