Miscellaneous Hacks - SocialForums for vB3.8

SocialForums for vBulletin 3.8

Created by Marius Czyz aka Phalynx.

This mod will work *ONLY* with vBulletin 3.8 or higher. It will not run on vBulletin 3.7. Please use the version for vBulletin 3.7

Support will be only given for people who clicked Mark as INSTALLED.

Description
Not satisfied with vBulletin social groups messaging function? With SocialForums your social group leaders can create a standard forum for their group.
A group leader can only create a forum if the group has at least 5 members - this can be changed via settings. Optionally the group leader can be a moderator of such a social forum.

What about old discussions?
Via AdminCP, SocialForums, you can transfer all discussions and messages to a new forum. No post would be lost.

Permissions
There are advanced permissions (Forum and Archive). This includes read/write public and private (moderated/invite only) socialforums and creation of forum. As this needs two additional queries on every page you can disable this.

Demo
None, see screenshots

Installation
This product is fully phrased and uses template hooks. No file changes or manual template edits needed.
1. Upload bitfield_socialforums.xml to existing folder /includes/xml/
2. Upload functions_socialforums.php to existing folder /includes/
3. Fresh Installation: Just import the product. Upgrade: Import the product, allow overwrite. No forums get lost!
4. Check settings, especially for parent forum. Don't forget to set permissions via usergroups!

Troubleshooting
Q: I don't see a link to create a forum. Why?
A: Check permissions for the usergroup, espacially if the user is allowed to create forum.
A: Check if the usergroup meet min users requirement, see AdminCP/Settings/SocialForums.

Q: My users see the forums, but they shouldn't!
A: Check permissions for the usergroup, if the users usergroup is set to "can see".
A: Did you disabled the restriction mode? Enable it.

Todo
- By deleting a group the forum should also be deleted/archived. Currently this has to be done manually.

Known Issues
- On big boards with hundreds of social groups this mod can really impact the performance because of the mass of new created forums. If you still want to use this mod use the "Minimum Members" feature with a higher value. Using the permission check there are additional two queries on every page.
- With activated option to add owner as a moderator the transfering leads to removing all moderators of the linked forum

History
2.1.0, 11th August 2009
- Social Groups without a forum are listed in AdminCP and can be automatically converted with few clicks.
- Fixed errors converting bigger discussions
- Minor changes and fixes

2.0.1, 05th March 2009
- Convert ignores now deleted discussions
- Threads on Groups equipped with mark on new

2.0.0
- First official release for vBulletin 3.8
- Possibility to transfer Social Group Discussion into a real Forum
- New layout for threadlisting, similar to a real threadlist in a forum
- Possibility of a notice in Forums associated with a Social Group
- Discussion/Message counter is showing Thread/Reply counts. Phrase "Discussion" and "Message" cannot be changed to "Thread"/"Reply".
- Transfering a Group to another user updates now also the moderator
- Minor changes and fixes

[indie2industry]

Will you be making a 2.0 version for VB 3.7.x ??

I have that one installed.

[Redzzand]

thanks for this!!

Installed...

[blogthea]

Awesome work Phalynx
works great
thank you

[abdelghani68]

thanks. I have upgrade but there is a problem.

 
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT SQL_CALC_FOUND_ROWS socialgroup.*, socialgroup.dateline AS createdate,
    groupicon.thumbnail_width AS iconthumb_width,
    groupicon.thumbnail_height AS iconthumb_height, groupicon.dateline AS icondateline , socialgroup.lastpost, groupread.readtime
    , forum.threadcount, forum.replycount
   FROM vb_socialgroup AS socialgroup
   LEFT JOIN vb_socialgroupicon AS groupicon ON (groupicon.groupid = socialgroup.groupid)
   LEFT JOIN vb_groupread AS groupread
    ON (groupread.groupid = socialgroup.groupid
    AND groupread.userid = 1)
   LEFT JOIN vb_forum ON forum.forumid=socialgroup.forumid
   WHERE socialgroup.creatoruserid = 1
 
   ORDER BY dateline DESC
   LIMIT 0, 1;
MySQL Error   : Unknown column 'forum.threadcount' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, March 4th 2009 @ 03:13:14 PM
Error Date    : Wednesday, March 4th 2009 @ 03:13:15 PM
Script        : http://www.home.fr/forum/group.php
Referrer      : http://www.home.fr/forum/
IP Address    : *********
Username      : *******
Classname     : vB_Database
MySQL Version : 5.0.68-log

thanks

[Phalynx]

Originally Posted by indie2industry

Will you be making a 2.0 version for VB 3.7.x ??

I have that one installed.

It cannot be done due to missing/other hooklocations. Also, 3.7 has only messages, no discussions.

Originally Posted by abdelghani68

thanks. I have upgrade but there is a problem.
thanks

Fixed. Please download the ZIP again and import the product XML, overwrite.

[micza]

I've got the Database Error on
...forum/group.php?do=grouplist&cat=1

[Phalynx]

Same for you: Please download the ZIP again and import the product XML, overwrite.

Thanks for pointing me to this.

[abdelghani68]

Thanks, I have upgrade but there is a new problem :

Database error in vBulletin 3.8.1:

Invalid SQL:

                SELECT COUNT(*) AS count
                FROM vb_socialgroup AS socialgroup
                LEFT JOIN vb_socialgroupmember AS socialgroupmember ON
                    (socialgroupmember.userid = 1 AND socialgroupmember.groupid = socialgroup.groupid)LEFT JOIN vb_forum ON forum.forumid=socialgroup.forumid
                WHERE socialgroup.socialgroupcategoryid = 3;

MySQL Error   : Unknown column 'forum.forumid' in 'on clause'
Error Number  : 1054
Request Date  : Wednesday, March 4th 2009 @ 03:33:31 PM
Error Date    : Wednesday, March 4th 2009 @ 03:33:32 PM
Script        : http://www.****.fr/forum/group.php?do=grouplist&cat=3
Referrer      : http://www.****.fr/forum/group.php
IP Address    : *********
Username      : *****
Classname     : vB_Database
MySQL Version : 5.0.68-log

[buro9]

What's the upgrade process from running 1.4 on vb3.7 to 2.0 on vb3.8?

I've upgraded vbulletin itself from 3.7 to 3.8 and 1.4 remains installed, so how do I get from 1.4 to 2.0? I don't want to lose the socialforums I already have.

PS, a donation is winging it's way to you.