• Group leader is able to perform moderator actions in any group he or she created with the exception of giving warnings.
  
• Forum Moderators and Admins are able to perform moderator actions as well as close the group from discussion.
  
• Option to enable or disable MyCode and HTML in posts.
  
• Option to make members who aren't part of the group not be able to read threads, note that Moderators and Admins will still be able to see the threads.
  
• 3 Join types:
  • Anyone can join - any member can join the group instantly.
    
  • Requests must be approved - anyone can fill out the form to join, however the group leader is able to approve or deny the request.
    
  • Staff Only - Only users with Mod CP or Admin CP access are able to join the group.
• Option For SEO Support
  
• Category System with Category permissions
  
• Logos: Can either be an url or by file upload.
  

1. Upload groups.php, groupthread.php, and showgroup.php, and groupcp.php to your forum's root directory.
   
2. Upload socialgroups.php to your /inc/plugins directory.
   
3. Upload socialgroups.lang.php to your /inc/languages/english directory.
   
4. Install and Activate from the Admin CP.

1. Deactivate, not uninstall, the current version you are running
   
2. Upload the new files
   
3. Activate the plugin
   
4. Go to socialgroupsupgrade.php and select the version you are upgrading from. Note that there is no upgrade to 1.9 if you had an old version because database and templates did not change.
   

• Group Control Panel Features completed:
  • Only accessible by those with Mod CP or Admin CP access.
    
  • View All Groups
    
  • View All Threads
    
  • Lock specific group
    
  • Lock all groups
    
  • Unlock specific group
    
  • Unlock all groups
    
  • Edit specific group
    
  • Delete Thread
    
  • Delete specific group ( Limited to only those with Admin CP access )
    
  • Delete All groups /* Only a member in usergroup 4 (admininstrator) is able to use this feature.
• Bug Fixes:
  • Unable to join from being in too many groups
    
  • Moderators and Admins not being able to view threads on a private group
    
  • Fixes some errors where two commas somehow got combined in a row. This would trigger an SQL error 1064.
    
  • Some errors on the approval status of a thread.
    
  • Special file to alter table collation and character set.

• Made it so tables use the character character set by default
  
• Fixed a couple permission issues.
  
• Changed most things to use the mybb input array.
  
• Made more use of the built in redirect function
  

• Add Online Location correctly - Note that only staff get the name of a group thread due to being less server intensive. If you want anyone to be able to view this, ask and I will help.
  
• Category System - Categories are managed in the Admin CP
  
• Create an Admin Module - Manages Group Information & Categories
  
• Admin Log Entries
  
• Fix member_profile not updating
  
• Allow group images to be uploaded instead of remote url only
  
• SEO Support, not through Google SEO Plugin because I couldn't work with it.
  
• Cache for social groups and categories
  

• This release fixed many bugs.
  
• User experience improved slightly by using some redirects after actions.
  

# Custom Rules for social groups
# Social Groups SEO URL Rule for Groups:
RewriteRule ^socialgroup-([0-9]+)+(.*)\.html$ showgroup.php?gid=$1 [L,QSA,NC]

# Social Groups SEO URL Rule for Categories:
RewriteRule ^category-([0-9]+)+(.*)\.html$ groups.php?cid=$1 [L,QSA,NC]

# Social Groups SEO URL Rule for Group Threads:
RewriteRule ^conversation-([0-9]+)(.*)\.html$ groupthread.php?conid=$1 [L,QSA,NC]

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Query:
SELECT g.*, u.*, ug.gid, ug.namestyle FROM mybb_socialgroups g LEFT JOIN mybb_users u ON (g.uid=u.uid) LEFT JOIN mybb_usergroups ug ON (u.displaygroup=ug.gid) WHERE g.leader=u.username