Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

On new user registration only Super Users get notified but not Admins

9 years 3 months ago
Licenses:
JomSocial Expired

Im wondering why is that?

I already tried to set that particular Admin (MARKUS P.) as Super User and then it worked but thats not what i want.
I also tried to set "Get System Emails" for that user to "no" and then back to "yes" to update the database entry but still nothing.
i also added a new user as registered only and set "Get System Emails" but still the same result.

I dont want to set that particular Admin as Super User for some reasons - shhhhht ;)


Something im overseeing?

Thanks again loads.

Phil

9 years 3 months ago
Licenses:

Hi,

please try this solution, edit:
/components/com_community/models/register.php, at line 697

for administrator only, not super user. change the code from:

$query		= 'SELECT a.' . $db->quoteName('name').', a.'.$db->quoteName('email').', a.'.$db->quoteName('sendEmail')
				. ' FROM ' . $db->quoteName('#__users') . ' as a, '
				. $db->quoteName('#__user_usergroup_map') . ' as b'
				. ' WHERE a.' . $db->quoteName('id') . '= b.' . $db->quoteName('user_id')
				. ' AND b.' . $db->quoteName( 'group_id' ) . '=' . $db->Quote( 8 ) ;
to
$query		= 'SELECT a.' . $db->quoteName('name').', a.'.$db->quoteName('email').', a.'.$db->quoteName('sendEmail')
				. ' FROM ' . $db->quoteName('#__users') . ' as a, '
				. $db->quoteName('#__user_usergroup_map') . ' as b'
				. ' WHERE a.' . $db->quoteName('id') . '= b.' . $db->quoteName('user_id')
				. ' AND b.' . $db->quoteName( 'group_id' ) . '=' . $db->Quote( 7 ) ;

if you want both, super user and administrator. changing it to
$query		= 'SELECT a.' . $db->quoteName('name').', a.'.$db->quoteName('email').', a.'.$db->quoteName('sendEmail')
				. ' FROM ' . $db->quoteName('#__users') . ' as a, '
				. $db->quoteName('#__user_usergroup_map') . ' as b'
				. ' WHERE a.' . $db->quoteName('id') . '= b.' . $db->quoteName('user_id')
                                .  ' AND ( b.' . $db->quoteName( 'group_id' ) . '=' . $db->Quote( 8 )
				. ' OR b.' . $db->quoteName( 'group_id' ) . '=' . $db->Quote( 7 )) ;

Regards

9 years 3 months ago
Licenses:
JomSocial Expired

Cool i for now it works.

I had to change to query a little since it threw a syntax error when using this:

$query = 'SELECT a.' . $db->quoteName('name').', a.'.$db->quoteName('email').', a.'.$db->quoteName('sendEmail')
. ' FROM ' . $db->quoteName('#__users') . ' as a, '
. $db->quoteName('#__user_usergroup_map') . ' as b'
. ' WHERE a.' . $db->quoteName('id') . '= b.' . $db->quoteName('user_id')
. ' AND ( b.' . $db->quoteName( 'group_id' ) . '=' . $db->Quote( 8 )
. ' OR b.' . $db->quoteName( 'group_id' ) . '=' . $db->Quote( 7 )) ;


It was about these two brackets:
. ' AND ( b.' . $db->quoteName( 'group_id' ) . '=' . $db->Quote( 8 )
. ' OR b.' . $db->quoteName( 'group_id' ) . '=' . $db->Quote( 7 )) ;

i guess i understand the intention behind the brackets but after i deleted them it works :)

thanks a bunch and have a nice day!!

phil

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere

© JomSocial.com All Rights Reserved