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.

[Merriweather]

On the posting issue, some users are still getting this database error:

Invalid SQL:

SELECT COUNT(*) AS replies
FROM grps_thread
WHERE threadid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 Error Number : 1064
Date : Monday, March 5th 2007 @ 01:04:01 PM
Script : http://www.<edit>.com/groups/newreply.php
Referrer : http://www.<edit>.com/groups/newreply.php?do=newreply&t=36
IP Address : <edit>
Username : <edit>
Classname : vb_database

I will do the other tests for you this evening, I have to go for a while.

[Merriweather]

Originally Posted by sabret00the

can you upload these two to the groups folder please.

and then run:
www.yoursite.com/groups/test_groups.php?g=XX
http://www.yoursite.com/groups/test_....php?g=XX&t=YY

please substitute XX and YY for numbers in which icons display or in your case don't, in the normal groups.php and viewthread.php

test_groups.php just gave this:

=>

test_viewthread.php gave this:

=>=>=>=>=>=>=>=>=>=>=>=>=>=>

[Merriweather]

Another issue users are having is that it's putting HTML in the text entry box if a user previews their post. Seeing as we don't allow HTML in posts on the fourm, it's casuing a problem with formatting.

[Merriweather]

This whole random inability to post is really troublesome on my forums. It's the same DB error over and over:

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT COUNT(*) AS replies
FROM grps_thread
WHERE threadid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Error Number : 1064
Date : Monday, March 5th 2007 @ 09:47:35 PM
Script : http://www.<edit>.com/groups/newreply.php
Referrer : http://www.<edit>.com/groups/newreply.php?do=newreply&t=98
IP Address : <edit>
Username : <edit>
Classname : vb_database

We can't find any rhyme or reason for it, but some of my groups, you can only start threads and can't reply to them at all!!!

[sabret00the]

Originally Posted by Merriweather

Another issue users are having is that it's putting HTML in the text entry box if a user previews their post. Seeing as we don't allow HTML in posts on the fourm, it's casuing a problem with formatting.

can i get a screenshot of this one please?

as for the database error, i'm on it

[sabret00the]

Originally Posted by Merriweather

This whole random inability to post is really troublesome on my forums. It's the same DB error over and over:



We can't find any rhyme or reason for it, but some of my groups, you can only start threads and can't reply to them at all!!!

can you run this query please and give me the results [sql] SELECT COUNT(*) AS replies
FROM grps_thread
WHERE threadid = 98[/sql]

[sabret00the]

Originally Posted by Merriweather

Another issue users are having is that it's putting HTML in the text entry box if a user previews their post. Seeing as we don't allow HTML in posts on the fourm, it's casuing a problem with formatting.

can i get a screenshot of that because i'm unable to replicate that.

[sabret00the]

Originally Posted by Merriweather

test_groups.php just gave this:

=>

test_viewthread.php gave this:

=>=>=>=>=>=>=>=>=>=>=>=>=>=>

And there was DEFINITELY use of posticons on both pages correct?

[sabret00the]

Originally Posted by Merriweather

test_groups.php just gave this:

=>

test_viewthread.php gave this:

=>=>=>=>=>=>=>=>=>=>=>=>=>=>

can you please run this query with the same values for which you used XX and YY on the test_viewthread.php please

[sql] SELECT grps_post.postid, grps_post.groupid, grps_post.username AS postusername, grps_post.ipaddress AS ip, grps_post.title AS posttitle, grps_post.dateline, grps_post.pagetext, grps_post.iconid, i.title AS icontitle, i.iconpath, grps_post.visible, grps_post.allowsmilie, grps_post.showsignature, grps_post.edit_username, grps_post.edit_userid, grps_post.edit_reason, grps_post.edit_dateline, grps_post.delete_username, grps_post.delete_userid, grps_post.delete_reason, grps.leaderid, u.*, uf.*, utf.*, a.avatarid, a.avatarpath, NOT ISNULL(ca.userid) AS hascustomavatar, ca.dateline AS avatardateline, ca.width AS avwidth, ca.height AS avheight
FROM grps_post
LEFT JOIN grps ON (grps.groupid = grps_post.groupid)
LEFT JOIN user u ON (u.userid = grps_post.userid)
LEFT JOIN userfield uf ON (uf.userid = u.userid)
LEFT JOIN usertextfield utf ON (utf.userid = u.userid)
LEFT JOIN icon i ON (i.iconid = grps_post.iconid) > 0
LEFT JOIN avatar a ON (a.avatarid = u.avatarid)
LEFT JOIN customavatar ca ON (ca.userid = u.userid)
WHERE grps_post.groupid = XX and grps_post.threadid = YY
ORDER BY grps_post.dateline ASC
[/sql]

and please just look for the iconpath column and let me know if it's empty on all counts.

hold on, i think i've figured it out. are you using a default icon on your forums?

[Merriweather]

Originally Posted by sabret00the

can you run this query please and give me the results [sql] SELECT COUNT(*) AS replies
FROM grps_thread
WHERE threadid = 98[/sql]

Results: 1