Major Additions - GRPS: Groups Commune 2.0.x

Welcome ladies and gentleman, this is the release thread for GRPS, an interactive groups commune. I hope you enjoy this release and i sincerely hope it provides everything to your community in which you're looking for.

What is it?
It's a groups commune. The original idea is that forums with lots and lots of forums on the front-page suck, as a result i thought most of the conversation was rather obscure in regards to what the forums were trying to achieve, so it'd be nice to have that all going on elsewhere, not detracting away from the content and stopping your front-page from looking like a car crash.

Features?

• Groups Home
  
  • Groups Activity List
    
    • Newest Groups
      
    • Most Popular Groups
      
    • Largest Groups
      
  • Category List
    
  • Group Search by Title
    
  • Group Sort by Alphabetical Title, Categories, Member Count
    
    
  • Users can create groups
    
  • Admin switch to moderate groups or not
    
    • Admin CP access to moderation panel
      
• Groups Page
  
  • Posts since last visit notification
    
  • Group Info
    
    • Group Leader shown with avatar
      
    • Category
      
    • Type
      
      • Groups can be listed as public, private or hidden
        
    • Start Date
      
    • Member count
      
    • Post count
      
  • Group Desciption
    
    • Shows group title
      
    • Shows random image
      
    • Shows group information set by group leader
      
  • Groups Thread List (Forum)
    
    • Status Icon
      
    • Title
      
      • Threads use postbit as per the forums
        
    • Thread Author with avatar and time that the thread was started
      
    • Last reply with avatar, username and time that the last reply was posted
      
    • Post New Thread Button
      
      • Groups Members can create threads
        
  • Newest Members
    
    • Shows five newest members
      
    • Link to view all members
      
      • Shows all members of the group
        
  • Group Options
    
    • Users can join/leave groups
      
      • PM Notification for group leaders upon join requests (when moderation enabled).
        
      • PM Notification for of acceptance or refusal.
        
    • Users can send invites to other users via PM
      
• Groups Thread
  
  • Groups Info Box (see above for more info)
    
  • Group Description box (see above for more info)
    
  • Newest Members List (see above for more info)
    
  • List of groups posts using forums postbit
    
  • Pagination using native vBulletin pagination
    
  • Group Leader/Moderation Options
    
    • Open/Close Thread
      
    • Stick Thread
      
    • Delete Thread
      
  • Users have the ability to report posts
    
  • Moderators have the ability to view IP and host.
    
• Group Leader Options
  
  • Groups Management
    
    • WYSIWYG Editor
      
    • Reason for editing box
      
    • Group Options
      
      • Private Posts
        
      • Only group leader can make threads
        
      • Moderate Members
        
      • Show group text edit details
        
      • Hide group image on group pages
        
      • Hidden Group
        
        • This option is only available to admins
          
  • Group Members Moderation
    
    • Ability to accept or deny new members
      
• Postbit Integration
  
  • View Users Groups
    
• User Control Panel (Integration)
  
  • List of groups appears in usercp in order of the last post
    
• Administrator Options
  
  • vBulletin Options
    
    • Turn groups on or off
      
    • Groups Limit Per User
      
    • Posts Per Page (threads)
      
    • Check Forum Activity Posts
      
    • Check Forum Activity Time
      
    • Number of Random Images
      
    • Turn email notification of new groups on/off
      
  • Usergroup Options
    
    • Can view groups
      
    • Can create groups
      
    • Can join groups
      
    • Can post messages in groups
      
    • Can edit messages in groups
      
    • Can delete messages posted in groups
      
    • Numbers of groups usergroup can join limited
      
    • Can moderate groups
      
      • See above for more info
        
    • Can view IP Addresses
      
  • Category Editor
    
    • Edit
      
      • Edit cat id (please not this can ef up your show)
        
      • Edit cat title
        
      • Edit cat description
        
    • Add
      
      • New Cat Title And Description
        
  • Groups Editor
    
    • Search for group by id
      
      • Edit
        
        • Title
          
        • Desciption
          
        • Categoryid
          
        • Group leader id
          
        • Private Posts
          
        • Moderate Members
          
        • Hidden group
          

Special Thanks to harry1951, without his help testing and his recommendations, this would've never ended up the way it did.

Honestly, i can't think of anything else, if you appreciate the work gone into this mod, please donate (in GBP) (right click open in new window)

Hopefully you all appreciate that i just relaunched my site and rather than soak up the atmosphere there or go out drinking i came to release this tonight.

Screens below, rest to your right

Please note this mod does work with 3.5.x

PLEASE DO NOT JOIN MY SITE IN A BID TO PLAY WITH IT OR HAVE A LOOK AT IT FURTHER, MY SITE IS SOMETHING I VALUE FOR BEING SOMEWHERE I CAN CHILL AT, IT'S NOT A TEST SUITE OR DEMO!

Bug Fixes

• Groups v2.0.0 RC1b.zip: fix regarding incorrect table prefixes in index.php and editpost.php
• Groups v2.0.0 RC2.zip: fix regarding incorrect table prefixes in functions_grps.php and class_grps.php. also fix regarding installation instructions.
• Groups v2.0.0 RC3.zip: fix regarding inability to get to create groups page. updated simplified instructions, sadly still not cool html ones and also added ability to delete groups, delete categories and of course the menu options to get to these.
  • Groups v2.0.0 RC3b.zip: fix regarding joining and leaving group depreciated function error added uninstaller to the zip at http://www.yoursite.com/groups/tools...p?do=uninstall
  • Groups v2.0.0 RC3c.zip: fix regarding edit being stated as 70's on group stages, requires re-installtion of the plugin only.
• Groups v2.0.0 RC4.zip: various bug fixes and new general setting, please reupload all files and then reinstall the product.
• Groups v2.0.0 RC5.zip: bug fixes regarding fixing links to forums being broken and forcing redirects for create group outcomes.
• Groups v2.0.0 RC6.zip: various bug fixes including table prefixes in admincp, invitations system now features in-line erroneous username fall-back and clean up regarding broken images in viewthread.php
• Groups v2.0.0 RC7.zip: bug fixes including missing phrases and missing 'noavatar.gif for group leader on groups info.
• Groups v2.0.0 RC8.zip: various bug fixes including missing phrases, smilies not working. new function to turn of new group moderation. form now working on print_no_permission page (thanks Adrian) and something else i forgot.
• Groups v2.0.0 RC9.zip: fixes two spelling mistakes, moves viewthread.php string_replacements to admincp and simplifies the installer experience. (yeah i thought there'd be more to it too).
  • Groups v2.0.0 RC9b.zip: re-fixes two spelling mistakes, fixes a viewthread.php string_replacement via the admincp and turns the default random image count down to that of which is provided.
• Groups v2.0.0 RC10.zip: optimises some of the code, cuts down on queries in exchange for additional joins and now forces compatibility in groups/viewthread.php with vBulletin options. also adds new option in admincp in order to make usercp listing work better out of the box.
• Groups v2.0.0 RC11.zip: fixes a problem with avatars not displaying correctly in thread listing and also optimises the code in membership.php
• Groups v2.0.0.zip: adds and array_merge to the code and smilie popup fixed. now features hooks for plug-in 'easability'. uCS integration moved to external plugin too.
• Groups v2.0.1.zip: removes one hook, fixes problem with membership.php, fixes problem editgroup.php not remembering options and fixes avatar problem.
• Groups v2.0.2.zip: various bug fixes (like missing pagenavs, more elegant removal of reputation button and infraction button and php notices), one or two new features (like intuitive page titles) and now fully phrased.
• Groups v2.0.3.zip: bug fix regarding now being able to select categories. includes a new feature which is basically pagination for the thread listings.
• Groups v2.0.4.zip: bug fix regarding not being able to moderate group memberships.
• Groups v2.0.5.zip: bug fix regarding those introduced via 2.0.4, new features such as double post prevention disable, admins can override privacy settings, usergroup permission text more intuitive and end-user usability increased with modification to threadbit on groups.php. group leaders can now kick users from there groups.
• Groups v2.0.6.zip: bug fix including report, missing edit button and other misc small bugs, new features such as disable hidden groups, allow mods to see private groups, and resign from group handing off to another user.
• Groups v2.0.7.zip: bug fix including fixing post counts, thread goto's and fatal php errors.
• Groups v2.0.8.zip: bug fix regarding inability to delete posts, problem with editing posts and other misc errors.
• Groups v2.0.9.zip: various bug fixes including wywiwyg error, admin cp error and redirect/goto errors.
  • Groups v2.0.9b.zip: fixes problem with upgrade4.php
• Groups v2.0.10.zip: various bug fixes including acknowledging renamed modcp and admincp dir's also adds option regarding removing of posts at group exit/kick.
• Groups v2.0.11.zip: various bug fixes including security/privacy fixes.
• Groups v2.0.12.zip: permission bug fixed.
• Groups v2.0.13.zip: various bug fixes including ability to ignore members in groups and newreply bug.

[Paul M]

Any more off topic / insulting posts will be removed and the offender receive infraction points. This is not a schoolyard for people to pop insults at each other.

[sabret00the]

Originally Posted by DJDarknez

OK, here we go...

I'm trying the install, but hitting a bit of a block.

I uploaded the files, adjusted the config.php file, and tried to run the installer (again). Got the 1060 error, which resembles this:

Database error in vBulletin 3.6.8:

Invalid SQL:

	ALTER TABLE `usergroup` ADD `grpspermissions` INT(10)  UNSIGNED DEFAULT 0 NOT NULL;

MySQL Error  : Duplicate column name 'grpspermissions'
Error Number : 1060
Date         : Wednesday, August 15th 2007 @ 11:30:24 PM
Script       : http://www.earthprowlers.com/groups/tools/grps_installer.php
Referrer     : 
IP Address   : .
Username     : .
Classname    : vb_database

A quick search through this thread showed that since it was already installed, this part seemed to be done. Alrighty then. I installed the product via the AdminCP. Set the GRPS to active "parallel to forums" to yes since I have my forums in the root dir.

I went to .com/groups and viewing the source got me this:

Database error in vBulletin 3.6.8:

Invalid SQL:

		SELECT 
			userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
			language.phrasegroup_grps AS phrasegroup_grps,
			language.phrasegroup_global AS phrasegroup_global,
			language.options AS lang_options,
			language.languagecode AS lang_code,
			language.charset AS lang_charset,
			language.locale AS lang_locale,
			language.imagesoverride AS lang_imagesoverride,
			language.dateoverride AS lang_dateoverride,
			language.timeoverride AS lang_timeoverride,
			language.registereddateoverride AS lang_registereddateoverride,
			language.calformat1override AS lang_calformat1override,
			language.calformat2override AS lang_calformat2override,
			language.logdateoverride AS lang_logdateoverride,
			language.decimalsep AS lang_decimalsep,
			language.thousandsep AS lang_thousandsep
			
		FROM user AS user
		LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
		LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
		
		WHERE user.userid = 1;

MySQL Error  : Unknown column 'language.phrasegroup_grps' in 'field list'
Error Number : 1054
Date         : Wednesday, August 15th 2007 @ 11:31:11 PM
Script       : http://www.earthprowlers.com/groups/
Referrer     : 
IP Address   : 
Username     : 
Classname    : vb_database

A quick search through this thread those that "1054" means I have to run the installer...which gives me an SQL error...

halp?

run the uninstaller and then run the installer again, let me know if the problem persists from there i should be able to advise.

[Code Monkey]

Does this allow Group creators to upload a group image?

[0tolerance]

i was thinking the exact same thing but apparently it doesnt.
but im sure this is one of the feature he is coding into 3.0..

sabret00th do have an ETA on the completion of 3.0 beta?

[Code Monkey]

Is there a 3.0 in the works? I'm on page 7 of reading this thread so forgive me if I haven't gotten there yet.

Things I would like to see after playing with it a day.

1. More control over images. ex. Specific group home image and group leader image upload for groups unique image.
2. Group image next to group name in group list. #1 needed first of course.
3. The ability for the group leader to request, and admin to fulfill, the movement of a group thread to a main forum in vBulletin. This would give it group project capability. Or sometimes a topic is just too good to keep in the back room.
4. The ability to move a forum thread to a group.
5. Sub Categories which is self explanatory.
6. A mechanism to request categories and sub categories as well as the ability to tie that request to a payment option.

That's all I can think of so far. There seems to have been a lot of work put into this mod so far. Thanks for all the hard work on it.

[sabret00the]

Originally Posted by Code Monkey

Does this allow Group creators to upload a group image?

not at present

Originally Posted by 0tolerance

i was thinking the exact same thing but apparently it doesnt.
but im sure this is one of the feature he is coding into 3.0..

sabret00th do have an ETA on the completion of 3.0 beta?

i'm hoping to get out as private beta for the end of the third quarter (September)

Originally Posted by Code Monkey

Is there a 3.0 in the works? I'm on page 7 of reading this thread so forgive me if I haven't gotten there yet.

Things I would like to see after playing with it a day.

1. More control over images. ex. Specific group home image and group leader image upload for groups unique image.
2. Group image next to group name in group list. #1 needed first of course.
3. The ability for the group leader to request, and admin to fulfill, the movement of a group thread to a main forum in vBulletin. This would give it group project capability. Or sometimes a topic is just too good to keep in the back room.
4. The ability to move a forum thread to a group.
5. Sub Categories which is self explanatory.
6. A mechanism to request categories and sub categories as well as the ability to tie that request to a payment option.

That's all I can think of so far. There seems to have been a lot of work put into this mod so far. Thanks for all the hard work on it.

Yup 3.0 is in the works, firmly so infact.

Group image is already done, the implementation is that each group gets it's own gallery, for each gallery you can select a gallery front cover as well as the actual group image. In most places now, groups are listed with their thumbnails.

The ability to move forum threads to groups is something i've been looking at for a while and to a degree, i had a very personal wish to be able to mass do the task by forumid (i doubt that will go into the stock, i can't be arsed with the GUI from now and i'm a while away from starting) but in regards to doing it the other way around. i'm not so sure about, who knows though, i'll give it some thought.

Sub-Categories, every one wants these things and i have no idea why. I can't even see the use of the implementation in my head, that said however, everyone seems to want them and so while they'll be last on the list, i'll work towards achieving it.

The mechanism to request sub-cats, interesting idea. however i wonder, why wouldn't you run such a request method through ordinary means such as a thread or pm?

[Code Monkey]

Originally Posted by sabret00the

Sub-Categories, every one wants these things and i have no idea why. I can't even see the use of the implementation in my head, that said however, everyone seems to want them and so while they'll be last on the list, i'll work towards achieving it.

For example under the games category a bunch of people create wow topical groups. Well then it would be nice to have a wow subcat to organize it better for those looking for groups to discuss wow. It would also give people a link to give others to tell them where to find topics such as this.

Originally Posted by sabret00the

The mechanism to request sub-cats, interesting idea. however i wonder, why wouldn't you run such a request method through ordinary means such as a thread or pm?

Just convenience is all. You know how busy we get as admins. It would be nice to see an email stating that user "A" had paid for and requested a "widgets" category. Then I could just add it or refund if I don't want widget discussions on my site.

I sent you an email through an indirect method. Thanks again for all the hard work. And believe me, I know what a pain those PM's here can be for coders.

EDIT: Another thing that would be useful is instead of having the yes/no option for a usegroup to be limited on group joins, have the number of joins allowed entered and 0 for no limit.

[Freak0204]

Regarding images... All avatars and half the smilies work OK. But we have special graphics and vbplaza stuff in our postbits that aren't showing up in the groups. How can the code for those graphics be included so they show up? Also, what would you suggest regarding the other half of our smilies not showing up in posts, within the groups?

[Code Monkey]

Originally Posted by sabret00the

The ability to move forum threads to groups is something i've been looking at for a while and to a degree, i had a very personal wish to be able to mass do the task by forumid (i doubt that will go into the stock, i can't be arsed with the GUI from now and i'm a while away from starting) but in regards to doing it the other way around. i'm not so sure about, who knows though, i'll give it some thought.

Can't you just use the default thread and post system to store group threads and posts? That would help add them to the sites total threads and posts as well.

[Code Monkey]

Another thing to add would be the vBulletin AJAX username check to the textfields for inviting users to a group.