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.

[Endurer]

A fix has already been posted here: https://vborg.vbsupport.ru/showpost....95&postcount=2

[vgevolution]

Originally Posted by Endurer

A fix has already been posted here: https://vborg.vbsupport.ru/showpost....95&postcount=2

This is a different error. It's not the Leader Icon not showing up error. That's a path problem. The integration of vBadvanced wrapped around GRPS causes this error. I was just wondering if anyone else ran into it and had a fix. Essentially the function fetch_avatar_url() that generates the leader icon returns "Array" instead of the correct URL string when vBa is active. I've asked the same question in the vBa forums, looking for a solution. If I find one, I'll post it here as well.

EDIT: Oops, I quoted the wrong error (malformed avatar in postbit), but my error still isn't solved with post #2's suggestions. On a side note, I have another hack which has the same error, VB Image Host.

[CHIPIT195]

I have my forums on a subdomain (myforums.mysite.com)...
However, the forums are in a sub-directory (myforums.mysite.com/forums/)

The groups are installed at myforums.mysite.com/groups/

The links are showing the forums root... (ie: the create group link is myforums.mysite.com/forums/?do=creategroup, when it should be myforums.mysite.com/groups/?do=creategroup )

How do I fix this?

[Merriweather]

Sabre ~ Just checking in to see where you're at with the new version. Really hoping email notifications of group posts and checking user group permissions and removing them from groups if their permissions change is in the near future.

[Yours Truly]

Everything is going smooth except the navbar pointing to the wrong links but i can sort them.

Only thing that isn't working right is the group tools on the GRPS navbar dropdown isn't working. I click it then it just does nothing.

Any ideas?

[Kimiko]

FIXED! Thanks anyways!

[WDZaphod]

Hi!
Is there a wishlist existing already for Version3?

[hambil]

Help me understand how this has been installed 204 times. It doesn't create database tables. I've looked in the product.xml, and everywhere else, and nowhere does it create the tables that I can find.

This problem was pointed out 8 months ago by one of the first users in this post: https://vborg.vbsupport.ru/showpost....59&postcount=9

If you had a previous version of this installed, that created the tables, then perhaps that is why it is working. As far as I can tell it works as an upgrade only.

[vgevolution]

hambil: As far as I can tell, you didn't look very hard or read the instructions. By "I've looked in the product.xml, and everywhere else", you must surely mean, "I've looked in the product.xml, and didn't bother looking anywhere else". Try looking in the grps_installer.php file in the ROOT/groups/tools directory of the product's zip file. You know, the one you run to finish installing GRPS, as described in the install.txt file.

To make it clearer, here's an excerpt from install.txt (the bold text is a clue):

now go to your "groups/include/config_grps.php" and edit it accordingly. if you are having problems using your relative path, then please try your full path.

================

Now upload the files. and you're good to go (after running adding the product ofcourse).

--------

I need to advise you to back up your database before attempting anyway sort of database manipulation.

--------

You will now need to run groups/tools/grps_installer.php.

Excerpt from grps_installer.php:

PHP Code:

$db->query_write("
    ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `grpspermissions` INT(10)  UNSIGNED DEFAULT 0 NOT NULL
");

$db->query_write("
    ALTER TABLE `" . TABLE_PREFIX . "user` ADD `grps` MEDIUMTEXT NULL
");

$db->query_write("
    CREATE TABLE `grps` (
        `groupid` mediumint(9) NOT NULL auto_increment,
        `title` varchar(50)  NOT NULL default '',
        `description` varchar(250)  NOT NULL default '',
        `catid` smallint(2) NOT NULL default '0',
        `approved` enum('0','1')  default NULL,
        `create_date` int(10) unsigned NOT NULL default '0',
        `replycount` int(10) unsigned NOT NULL default '0',
        `lastpost` int(11) NOT NULL default '0',
        `membercount` int(10) unsigned NOT NULL default '0',
        `leaderid` int(10) default NULL,
        PRIMARY KEY  (`groupid`)
    )
");

$db->query_write("
    CREATE TABLE `grps_categories` (
        `catid` tinyint(3) unsigned NOT NULL auto_increment,
        `title` varchar(25)  NOT NULL default '',
        `description` varchar(250)  default NULL,
        PRIMARY KEY  (`catid`)
    )
");

$db->query_write("
    CREATE TABLE `grps_grouptext` (
        `groupid` mediumint(9) unsigned NOT NULL default '0',
        `pagetext` mediumtext  NOT NULL,
        `allowsmilie` enum('1','0')  default '1',
        `parseurl` enum('1','0')  default '1',
        `edit_reason` varchar(200)  default NULL,
        `edit_dateline` int(10) unsigned default NULL,
        `edit_userid` tinyint(4) default NULL,
        `edit_username` varchar(50)  default NULL,
        PRIMARY KEY  (`groupid`)
    )
");

$db->query_write("
    CREATE TABLE `grps_post` (
        `postid` int(10) unsigned NOT NULL auto_increment,
        `threadid` int(10) NOT NULL default '0',
        `groupid` mediumint(9) unsigned NOT NULL default '0',
        `parentid` int(10) unsigned default NULL,
        `username` varchar(50)  NOT NULL default '',
        `userid` int(10) unsigned NOT NULL default '0',
        `title` varchar(250)  NOT NULL default '',
        `dateline` int(10) unsigned NOT NULL default '0',
        `pagetext` mediumtext  NOT NULL,
        `ipaddress` varchar(16)  NOT NULL default '',
        `iconid` smallint(5) unsigned NOT NULL default '0',
        `visible` smallint(6) NOT NULL default '0',
        `attach` smallint(5) unsigned NOT NULL default '0',
        `allowsmilie` enum('1','0')  default NULL,
        `showsignature` enum('0','1')  NOT NULL default '0',
        `edit_username` varchar(50)  default NULL,
        `edit_userid` int(10) default NULL,
        `edit_reason` varchar(200)  default NULL,
        `edit_dateline` int(10) unsigned default NULL,
        `delete_username` varchar(50)  default NULL,
        `delete_userid` int(10) default NULL,
        `delete_reason` varchar(200)  default NULL,
        PRIMARY KEY  (`postid`),
        KEY `threadid` (`threadid`),
        FULLTEXT KEY `title` (`title`,`pagetext`)
    ) ENGINE=MyISAM
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (1, 'Automotive', 'For groups pertaining to cars, bikes or such')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (2, 'Computers', 'For groups referring to computers, whether hardware, software or modding')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (3, 'Education', 'For groups regarding learning, whether it be help studying or school activities')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (4, 'Entertainment', 'For groups surrounding anything entertaining, visual or audio')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (5, 'Games', 'For groups surrounding games you love, digital, card or board')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (6, 'Health & Fitness', 'For groups pertaining to well-being')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (7, 'Home & Families', 'For groups regarding the home life')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (8, 'Lifestyles', 'For groups surrounding lifestyles whether it be goths, hippies, etc')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (9, 'Places & Travel', 'For groups referring to towns, cities and holidays')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (10, 'Religion & Belief', 'For groups surrounding christianity, islam, buddism, etc')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (11, 'Sports & Recreation', 'For groups referring to sports, whether it be Football, Cricket or Baseball teams')
");

$db->query_write("
    INSERT INTO `grps_categories` VALUES (12, 'Others', 'For everything else')
");

$db->query_write("
    CREATE TABLE `grps_setting` (
        `groupid` mediumint(9) unsigned NOT NULL default '0',
        `image_name` varchar(50)  default NULL,
        `private_posts` enum('0','1')  default '0',
        `moderate_members` enum('0','1')  default '0',
        `hidden_group` enum('0','1')  default '0',
        `hide_image` enum('0','1')  default '0',
        `edit_details` enum('1','0')  default '1',
        `leaderonly_threads` enum('0','1')  NOT NULL default '0',
        PRIMARY KEY  (`groupid`)
    )
");

$db->query_write("
    CREATE TABLE `grps_user` (
        `recordid` mediumint(9) NOT NULL auto_increment,
        `groupid` mediumint(9) NOT NULL default '0',
        `userid` int(10) NOT NULL default '0',
        `in_mod_queue` enum('0','1')  NOT NULL default '0',
        `join_date` int(10) unsigned NOT NULL default '0',
        PRIMARY KEY  (`recordid`)
    )
");

$db->query_write("
    CREATE TABLE `grps_thread` (
        `threadid` int(10) unsigned NOT NULL auto_increment,
        `groupid` int(10) NOT NULL default '0',
        `userid` int(10) NOT NULL default '0',
        `username` varchar(250)  NOT NULL default '',
        `title` varchar(250)  NOT NULL default '',
        `dateline` varchar(15)  NOT NULL default '',
        `iconid` int(10) NOT NULL default '0',
        `lastposterid` varchar(250)  NOT NULL default '',
        `lastpostdateline` varchar(250)  NOT NULL default '',
        `replies` int(10) NOT NULL default '0',
        `firstpostid` int(10) default NULL,
        `closed` enum('0','1') NOT NULL default '0',
        `stuck` enum('0','1') NOT NULL default '0',
        PRIMARY KEY  (`threadid`),
        KEY `groupid` (`groupid`,`lastposterid`)
    )
"); 


Those lines of code are called database table entries. If you don't see this, download the zip file again and start over.

Also, had you bothered to look, that database error you snidely referred to was fixed almost immediately by sabret00the, 13 minutes later, four posts below the original error report, on the same page, as noted here. That means it was fixed 7 months, 29 days, 23 hours, and 47 minutes ago (by your math).

So, in a nutshell, to install the database tables you're missing, run the grps_installer.php script, as described in the install.txt file.

Did that help you understand?

[hambil]

vgevolution:

There's no reason to attack me personally. It's not even your hack, and the fact remains the install is rather confusing.

First, I looked for a separate installer, and didn't find it. It is buried three levels deep (root/groups/tools) and it's not named install.php. I'm not sure why it exists anyway, since all it does is create the database tables that should typically be done in the product.xml 'install' section. An external installer is usually reserved for multi-step installs that require user input.

Second, a big part of the reason I missed it is the instructions told me I was done:

"Now upload the files. and you're good to go (after running adding the product ofcourse)."

I took that to mean I needed to load the product.xml file, and that was it. To put another, critical line after that all but guarantees people will not see it. It's not like this is my first install. I write hacks.

So, back off, dude.