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.

Active group change to Random group

12 years 2 months ago
Licenses:
JomSocial Expired

how i can change the Active group to Random group ?

12 years 2 months ago
Licenses:

Hi Maged,

please edit /modules/mod_activegroups/helper.php
and change the query from

$query = 'SELECT *, (a.' . $db->quoteName('discusscount') . ' + a.' . $db->quoteName('wallcount') . ' ) AS count FROM ' . $db->quoteName('#__community_groups') . ' as a'
. ' INNER JOIN ' . $db->quoteName('#__community_groups_members') . ' AS b ON a.' . $db->quoteName('id') . '= b.' . $db->quoteName('groupid')
. ' WHERE a.' . $db->quoteName('published') . ' = ' . $db->Quote('1')
. ' GROUP BY a.' . $db->quoteName('id')
. ' ORDER BY ' . $db->quoteName('count') . ' DESC '
. ' LIMIT 0, ' . $count;
To
$query = 'SELECT *, (a.' . $db->quoteName('discusscount') . ' + a.' . $db->quoteName('wallcount') . ' ) AS count FROM ' . $db->quoteName('#__community_groups') . ' as a'
. ' INNER JOIN ' . $db->quoteName('#__community_groups_members') . ' AS b ON a.' . $db->quoteName('id') . '= b.' . $db->quoteName('groupid')
. ' WHERE a.' . $db->quoteName('published') . ' = ' . $db->Quote('1')
. ' GROUP BY a.' . $db->quoteName('id')
. ' ORDER BY RAND() ' 
. ' LIMIT 0, ' . $count;

Regards,
Albert

12 years 2 months ago
Licenses:
JomSocial Expired

hi Albert,
thank you very very much

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