Forum Home Enhancements - User's Social Groups on Forum Home (like forumlist, fully templated)

Available for vB4:
https://vborg.vbsupport.ru/showthread.php?t=221581

What does it do?

• Shows all social groups the actual user is a member of or is subscribed to, just below the forumlist (or anywhere else on forumhome). If there are new messages, the corresponding forum statusicon is highlighted - just like in forumlist.
• If there are no groups to show, you can choose to show a teaser message.

Things to set in AdminCP/Options:

• show member of / subscribed to /nothing
• sort by name or last message date
• limit max number of groups shown, then link to appropriate page (grouplist for members, usercp for subscribers)
• restrict use by usergroup
• show a teaser message if there are no groups to show
• show buttons to open new discussion etc.
• apply custom css to grouptitle
• trim group description to max length or disable
• parse bbcode in group descriptions
• use a different set of statusicons for groups than for forums
• use .png for statusicons instead of .gif (global in AdminCP, per style in groupsbit template)
• show groupicon instead of statusicon

Looks

• Out of the box: I tried to copy the standard look of the forumlist on forumhome.
• As requested, it is now fully templated (following the forumbit-scheme) for easy adjustment to custom styles.
  See the screenshot of a modified example in this post.

Install/upgrade

1. Upload folder "images" to your forum root (can be omitted if you do not want to use the buttons).
2. Import the product file.
3. Check settings in AdminCP->Options->Social Groups on Forumhome.

Template edit
Will be automatically inserted below your forums list if you are using TMS, which I highly recommend to do. If not:

Find:

<!-- /main -->

Above add:

$cel_social_groups

If you don't like it there, you can insert $cel_social_groups anywhere you like on forumhome.


Technical stuff
1 product file that adds
+ 3 templates (following the forumbit-scheme)
+ 3 plugins
+ adds 2 queries to forumhome (only if groups are shown, of course).
+ a bunch of phrases (prefix: cel_sgfh_).
+ 4 png-buttons, taken from the silk icon set.


Limitations

• Marking of new messages only works with database, not with cookie based marking of read threads (-> AdminCP setting)
  Explanation: This mod relys on the information in the database when a discussion was last read by the actual user. If you rely on cookies for this, you can use this mod anyway, but there will be no marking if there are unread messages by changed statusicons.
• 3.7 Discussion groups will show up as "no messages yet" as long as there was no message written under 3.8
  Explanation: When converting the old 3.7 message board into a discussion, Jelsoft was a little bit slack. While normally all the information about the last updated discussion is stored in the socialgroups table, this information is not entered for the auto-created discussion. For example: The discussion ID for the last updated discussion simply is 0 instead of the actual id of the auto created discussion. Therefore, this mod can not retrieve the information it needs since the discussion is not linked to the social group. This only changes when the first message under 3.8 is written.
• Not a bug note: In vB 3.8 there was an issue where the last discussion title was not correctly updated by vB in the socialgroup table. This would lead this mod to show a wrong last discussion title under some circumstances. This was resolved in 3.8.1.
  See Bugtracker: http://www.vbulletin.com/forum/proje...?issueid=27176

Version history

v 1.4
+ some bugfixes
+ option to turn teaser message off
+ option to show several buttons: to start a new discussion - see the group's members list - see the group' photos (only shown if there are any attached pictures) - unsubscribe (only if subscribed groups are shown) (Thanks to glorify)
1.4.1: Template/Style error in Google Chrome fixed

v 1.3
+ now fully templated. New templates: forumhome_cel_social_groups_groupsbit and forumhome_cel_social_groups_lastmsgby.
1.3.1: Link to user profile error fixed

v 1.2
+ added option to sort groups by date of last message
+ added missing phrase

v 1.1
+ improved database query
+ limitations somewhat lessened
+ added settings page to AdminCP
+ choose whether to show groups the user is a member of or subscribed to
+ limit number of groups shown, then link to appropriate page
+ restrict use by usergroup
+ some minor bugfixes


Planned features (no promises made!)

none atm

[s]option to use a set of different statusicons for the groups [/s]
[s]option to use the social group's icon instead of the statusicon[/s]
[s]and to go with that, for additional/substitunional unread marking, possibility to add css markup to the social group's title[/s]


Translations

• Polish (thanks to RadioErewan)
• German (thanks to redlabour)

Screenshots:

• AdminCP
• Forumhome (with groupicon and css formatted groupname, bbcode in description parsed)
• Forumhome (with forum statusicons and trimmed description -> bbcode not parsed)

### Don't forget to click install! ###
(No support if you don't)

[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.

[Phoenix81377]

Works great for me! Thank you!

[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.

[cellarius]

From mod description:

What does it do?
[...]
If a user is not a member of a social group, it will display a text referring to the groups.

[cellarius]

============== Important upgrade notes ==============
For upgrading from v1.0, please uninstall old version first!
If you changed templates manually, please note that the variable to insert has changed.

v 1.1
+ improved database query
+ limitations somewhat lessened
+ added settings page to AdminCP
+ choose whether to show groups the user is a member of or subscribed to
+ limit number of groups shown, then link to appropriate page
+ restrict use by usergroup
+ some minor bugfixes

[glorify]

Man--I was almost where I wanted this but the only problem I have is the $cel_sgfh_output. I wanna be able to mod the look a tad easier to reflect my style---any way of making the output a template? I hate having to modify the plugin.

I really love the mod, and I believe it's something vb should use as stock.

[glorify]

Found a bug---

When it displays (yes I have thread marking enabled correctly), It shows the last group thread, and the latest thread reply linked to the username.

Problem is, the last group thread and the latest group reply can be different. An example---

The last group thread was started 3 days ago (which is what the mod shows on forumhome). The latest reply was from a different thread tonight (which is linked to with the username on the forumhome.

Example of what it shows:

Thread Title 5 (started yesterday) shows it because it's the latest thread (still links to the latest reply though)
by Username (linked to Thread Title 1) linked to it because it's the latest reply

[Keyser Soze]

Great mod. You forgot to phrase the string "No messages yet". Please add a vbulletin-phrase for this string.

[cellarius]

Sorry, I corrected that. Product file updated.

[Diana Notacat]

This is working out WONDERFULLY for my boards so far! We needed this so much!

I would love to see an option where it will list your groups by "Newest messages". That way the most recently update groups are on the main page and people can click "Show More" to see the rest of their groups. (I'm not sure if this is already a feature, cause right now it's listing the groups in a random looking order.)