Forum Leaders Primary Group only

[jluerken]

Hi,

the forum leaders page shows people in multiple groups atm.

Example:
UserA is in Administrators and SpecialGroup
Administrator is primary group and SpecialGroup Secondary
Both groups have the flag to be shown on the forum leaders page.

This is how it works atm.

What I need now is that on the forum leaders page people are shown with their primary group only and do not show up double.

So in my example UserA should only be listed under Administrators and NOT under SpecialGroup.

How I can do this?

Regards
jluerken

[kh99]

In file showgroups.php around line 117 is this:

LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids))

if you remove the FIND_IN_SET part like this:

LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)

then I think it should do what you want. That information is cached, so you either need to clear the system cache or else wait until it refreshes (I think the default cache time is 3 hours).

[jluerken]

Thanks, that did the trick for me^^