vb.org Archive - Miscellaneous Hacks - SocialForums for vB3.8

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Miscellaneous Hacks - SocialForums for vB3.8 (https://vborg.vbsupport.ru/showthread.php?t=207315)

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

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

I have that one installed.

thanks for this!!

Installed...

Awesome work Phalynx
works great
thank you

thanks. I have upgrade but there is a problem.

Code:

 

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

Quote:

Originally Posted by indie2industry (Post 1760026)

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.

Quote:

Originally Posted by abdelghani68 (Post 1760036)

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

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

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

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

Thanks for pointing me to this.

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

Code:

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

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.

Quote:

Originally Posted by abdelghani68 (Post 1760056)

Thanks, I have upgrade but there is a new problem

Sorry for this. It was the same error, other location.
Reported here: https://vborg.vbsupport.ru/showpost....51&postcount=7

ZIP fixed...

Quote:

Originally Posted by Phalynx (Post 1760053)

Thanks for pointing me to this.

We have to say "Thank you!" for this great work.

Donation sent... that "Support developer" link should really be on your profile page.

Anyhow... thanks again.

Quote:

Originally Posted by buro9 (Post 1760058)

Just install 2.0 over the old one, no linked forum get's lost. Don't forget to upload the php files from the ZIP.

As for the donation: Thanks in advance.

Quote:

Originally Posted by buro9 (Post 1760062)

Actually, no donation... you haven't published a paypal address anywhere. Do so and you'll have some money :)

That is not really true. You can use the button from above to send me money. Also, in AdminCP there is a "Info"-Link with a PayPal Button.

If you want to use the eMail directly: contact@marius.de

Thanks :)

it works now. thanks !

Question. You said:

Quote:

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.

But this performance impact would only be when the board is being created, right? What is the actual impact on a "Big Board" on a regular basis? If it's just a one-time impact (the creation of the boards), then that's fine. If it's an ongoing impact (added queries), we need to know that separately. Thank you.

admin_socialforums.php?do=doconvert

This doesn't honour table prefixes

Quote:

Originally Posted by buro9 (Post 1760076)

admin_socialforums.php?do=doconvert

This doesn't honour table prefixes

Now it does. Please download ZIP and replace admin_socialforums.php

Quote:

Originally Posted by buro9 (Post 1760076)

admin_socialforums.php?do=doconvert

This doesn't honour table prefixes

In just one place... where the groupmessage table is in the JOIN.

Hi

Nice work :)
What do you think about an attachment integration?

The created forums are real forums with real threads and real posts - and thus with attachments.

Quote:

Originally Posted by Phalynx (Post 1760093)

The created forums are real forums with real threads and real posts - and thus with attachments.

Phalynx, please let me know what you think about this: https://vborg.vbsupport.ru/showpost....4&postcount=17

Quote:

Originally Posted by Kaelon (Post 1760074)

There is no really impact creating a forum.
Indeed, the thoughts about big boards is going in the direction that more forums means less caching (datastore) efficiency. But I have boards running with hundreds of forums AND SocialForums: http://www.aquariumforum.de/forumdisplay.php?f=422

Queries are only generated if you enable the following features:
- In a forum: Notice in a forum about a connected Social Group
- Global: Check for permissions (for private Social Groups)

I have it installed, great. Confused about how to use this mod. How do i create a socil group through a forum? Do I create a forum first or vice versa? I assume any social groups prior to thei mod cannot be converted? None of them are linked to any forum.

To get support, you will need to click "Mark as Installed".

You can assign a forum to a group at any time. Existing discussions can be transferred to the new forum.

Quote:

Originally Posted by Phalynx (Post 1760114)

To get support, you will need to click "Mark as Installed".

You can assign a forum to a group at any time. Existing discussions can be transferred to the new forum.

Marked, thanks. Let me check that out

still looking to see when you can assign a forum to a group. I don't see that as an option.

Did you read that already?

Quote:

Originally Posted by Readme

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.

this is better than the group discussion builtin in vB... :D

Nominated to MOTD!!!

I must have screwed something up as I cannot find a link to create a social forum. Where is that?

never mind, I'm an idiot. Works like a champ!

Unbelievably useful mod. Installed and rated. It gets around some features about Social Groups that was stopping my users from using them. Specifically the group discussions not showing up on new posts.

Major kudos.

Quote:

Originally Posted by Phalynx (Post 1760093)

The created forums are real forums with real threads and real posts - and thus with attachments.

Thanks :) - Installing now (localhost and public)

Do we must first remove the old SocialForums 1.4 ? or is 2.0 an upgrade for 1.4 ... :)

Hi,
i try to create a social forum - i get this error:

"Ein erforderliches Feld subforumcolumns fehlt oder enthält eine ungültige Angabe."

What can i do ?

Do you have any hacks installed that needs a column called "subforumcolumns" ? It does not come with SocialForums.

For example, "Forums arranged in columns on forumhome"?

Yes - i hav this hack installed... but not in use yet....

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01468 seconds Memory Usage 1,830KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (14)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: