Miscellaneous Hacks - SocialForums 1.4

SocialForums for vBulletin 3.7
Created by Marius Czyz aka Phalynx.

This mod will work *ONLY* with vBulletin 3.7 or higher. It will not run on vBulletin 3.6.x due to non existent feature of "social groups".

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.

Permissions
Since 1.3 there are advanced permissions active (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.

History
1.4.6, 6th October 2008
- Permissions are now also active in Archive

1.4.2, 27th May 2008
- Added: If a group has a linked forum the grouplisting has the last post date and count of postings (with permission check).
- Added: Recent threads in linked forum on group home
- Added: Private groups: Link to forum only shown to members of group
- Changed: Enabled permissions for unregistered usergroup. Unregistered Users are not more explicit denied without a check of it's usergroup

1.3.1, 23th May 2008
- Fixed: Not existing array

1.3.0, 23th May 2008
- Added: Permissions are now active. This includes read/write public and private (moderated/invite only) socialforums and creation of forum. Please check permissions for every usergroup! As this needs two additional queries on every page you can disable this.
- Added: Checks for permission before the creation link will be displayed
- Changed: Default View Age set to "Show all Threads"

1.2.1 8th April 2008:
- Added: Group messaging can be disabled via options (previously: always disabled)

1.2.0 4th April 2008:
- Added: Groupleader can now be moderator of group forum
- Added: Minimum Members that are required for own forum
- Added: Group messaging will be automatically hide for group that has own forum
- Added: Forums are created with more allowances
- Added: By deleting a forum the linked socialgroup get's updated
- Added: Forum's description contains link back to social group
- Added: By changing group's name it synchronize it with the forum's name

1.0/1.1 1st April 2008:
- Initial releases

[djilou]

I have a problem with the 1.4.1 version

Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT
t.postusername, t.threadid, t.title, t.lastpost, t.lastpostid, t.replycount, t.views, p.pagetext, p.dateline, p.userid, u.username,
IF(displaygroupid=0, u.usergroupid, displaygroupid) AS displaygroupid
, user.avatarrevision, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, customavatar.width as avwidth, customavatar.height as avheight, customavatar.filedata_thumb
FROM thread AS t
INNER JOIN post AS p ON t.lastpostid=p.postid
INNER JOIN user AS u ON p.userid=u.userid
LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid)
WHERE t.forumid=86 AND t.visible=1
ORDER BY t.lastpost
LIMIT 10;

MySQL Error : Unknown column 'user.avatarrevision' in 'field list'
Error Number : 1054

[almera]

When trying to import 1.4.1 I get this error:

Importing Product, Please Wait...

[:]

vBulletin Message
Invalid File Specified

I have uploaded bitfield_vbblog.xml to ./includes/xml and checked that the path is correct.

[ecihanuysal]

After just i have updated it

i got a db error..

Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT
				t.postusername, t.threadid, t.title, t.lastpost, t.lastpostid, t.replycount, t.views, p.pagetext, p.dateline, p.userid, u.username,
				IF(displaygroupid=0, u.usergroupid, displaygroupid) AS displaygroupid
				, user.avatarrevision, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, customavatar.width as avwidth, customavatar.height as avheight, customavatar.filedata_thumb
				FROM db_thread AS t
				INNER JOIN db_post AS p ON t.lastpostid=p.postid
				INNER JOIN db_user AS u ON p.userid=u.userid
				LEFT JOIN db_avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN db_customavatar AS customavatar ON (customavatar.userid = u.userid) 
				WHERE t.forumid=187 AND t.visible=1
				ORDER BY t.lastpost
				LIMIT 10;

MySQL Error   : Unknown column 'user.avatarrevision' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, May 27th 2008 @ 04:02:23 PM
Error Date    : Tuesday, May 27th 2008 @ 04:02:23 PM
Script        : http://faz.la/group.php?groupid=7
Referrer      : http://faz.la/group.php?do=createforum&groupid=7

[Phalynx]

It must be the heat today in germany - fixed and reuploaded. Sorry!

[VargTimmen]

I think, I have found another Bug:
The overview from the Forum is ascending in Date. The oldest Posts are the first, which are shown, seen, as here:
http://forum.gcult.de/group.php?groupid=5

Kind regards,
Benny

[almera]

Originally Posted by Phalynx

It must be the heat today in germany - fixed and reuploaded. Sorry!

N/p. You do an awesome job man! I think you should go commercial and extend the community features.

I'll try the new version now, thanks!

[Phalynx]

Which file are your trying to upload?

[almera]

Originally Posted by Phalynx

Which file are your trying to upload?

Sorry, my bad!

[Phalynx]

Ok... the fix was for the avatarrevision

[djilou]

Originally Posted by VargTimmen

I think, I have found another Bug:
The overview from the Forum is ascending in Date. The oldest Posts are the first, which are shown, seen, as here:
http://forum.gcult.de/group.php?groupid=5

Kind regards,
Benny

yep same here,
and the "Last Post" column show never for old forum's group