[glorify]

Originally Posted by cellarius

@glorify: Ah, ok, I see where you make the difference, of course: member of vs. subscribed.

Try replacing the database query at the top of the plugin with this:

    $result = $db->query_read("
        SELECT
            socialgroup.groupid, socialgroup.name, socialgroup.description, socialgroup.dateline, socialgroup.lastpost, socialgroup.lastposter, socialgroup.lastposterid, socialgroup.lastgmid, socialgroup.visible, socialgroup.lastdiscussion, socialgroup.discussions, socialgroup.members,
            discussionread.readtime
        FROM " . TABLE_PREFIX . "socialgroup as socialgroup
        LEFT JOIN " . TABLE_PREFIX . "discussionread as discussionread
        ON socialgroup.lastdiscussionid = discussionread.discussionid
        INNER JOIN " . TABLE_PREFIX . "socialgroupmember as socialgroupmember
        ON socialgroup.groupid = socialgroupmember.groupid
        INNER JOIN " . TABLE_PREFIX . "subscribegroup as subscribegroup
        ON socialgroup.groupid = subscribegroup.groupid
        WHERE socialgroupmember.userid = " . $vbulletin->userinfo['userid'] . " AND subscribegroup.userid = " . $vbulletin->userinfo['userid'] . "
        GROUP BY name
        ORDER BY name ASC, lastpost DESC
        ");

Untested, let me know if it works.

Will let you know. Thanks

One question---if there are no subscribed or memberships, does the box not show at all?

Originally Posted by RvG2

cellarius, i think you can make it an option in admincp to select whether we want to show group messages as member or subscribed only.

I like it.