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)

[cad2go]

cool - cheers for all the help

[redlabour]

Originally Posted by cellarius

Uh - I don't get that error... on neither of my boards. Since there's no line 458 in the plugin, I do not know exactly which of the two foreach statements in the plugin might be responsible. Since this only happens after upgrade, probably the newly added Can't see what might be causing it at the moment.

Please try the following: in the plugin add

$array_discussionread = array();

before

while ($array = $db->fetch_array($result_discussionread))

Are you using PHP 4 or PHP 5?

If the above does not fix it, please try to replace

foreach ($array_discussionread[$cel_groups['groupid']] as $discussions)

with

foreach ((array) $array_discussionread[$cel_groups['groupid']] as $discussions)

Originally Posted by redlabour

PHP5 - the second Hint works now!

Originally Posted by cellarius

Good to know. Will include this into the package and then send an upgrade notification

It is still not included in the new Update!!!

[webgroup]

Nice, the icons are showing correctly now.
But Im gettin this error and I had to disable the hack:

Warning: Invalid argument supplied for foreach() in [path]/index.php(67) : eval()'d code on line 212

[redlabour]

Ehhmmm....look one Posting behind yours and relax and reinstall!

[webgroup]

Oh ok, I edited the code as stated above and now its working!
im using php5

[Breakpoint]

Thanks I will need to insstall this!

[yotsume]

Does this mod work with vb3.7x. I get a database error after installing this mod and doing the template edit:

Database error in vBulletin 3.7.4:

Invalid SQL:

                SELECT
                        socialgroup.groupid,
                        socialgroup.name,
                        socialgroup.description,
                        socialgroup.picturecount,
                        socialgroup.lastpost,
                        socialgroup.lastposter,
                        socialgroup.lastposterid,
                        socialgroup.lastgmid,
                        socialgroup.visible,
                        socialgroup.lastdiscussion,
                        socialgroup.discussions,
                        socialgroup.members,
                        socialgroupicon.dateline
                FROM vb_socialgroup as socialgroup
                INNER JOIN vb_socialgroupmember as socialgroupmember
                        ON socialgroup.groupid = socialgroupmember.groupid
                   LEFT JOIN vb_socialgroupicon as socialgroupicon
                        ON socialgroupicon.groupid = socialgroup.groupid
                WHERE socialgroupmember.userid = 1
                GROUP BY name
                ORDER BY lastpost DESC;

MySQL Error   : Table 'xxxxxxxxx.vb_socialgroupicon' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, July 14th 2009 @ 06:45:29 PM
Error Date    : Tuesday, July 14th 2009 @ 06:45:29 PM
Script        : http://www.xxxxxxxx.com/forum.php
Referrer      : http://www.xxxxxxxx.com/admincp/index.php?do=head
IP Address    : xx.xxx.xx.xxx
Username      : xxxxxx
Classname     : vB_Database
MySQL Version : 5.0.67-log

Did I miss something???

[BigDog56]

Updated and thank you!

[sensimilla]

The new version messed my forumhome display.
Back to 1.5.0

[cellarius]

Originally Posted by yotsume

Does this mod work with vb3.7x. I get a database error after installing this mod and doing the template edit:
Did I miss something???

Yes. User group dsicussions were only introduced in 3.8, so there's no way this mod can work on 3.7.