UBB.Developers Forums UBB.threads 7 Development How Do I? Increase the number of groups

Does anyone know what I would need to do to have more than 99 groups?

*ponders more than 99 groups.... head explodes*

I beleive currently this is a no go.

I remember somewhere on here Rick posting that this is not possible. There are too many problems with the way things are coded to go beyond this.

Hmmm, looks like I'm going to have to figure out a new way to implement groups.

Chuck is right. More groups will cause Problems if a single user is in too many groups.
Maybe you can help me to convince Rick to store the user&group informations in a seperate table. That would solve the issue and it would be a lot easier to use the threads in other applications.

Ah God Astaran lets not go there. You know how Rick talks about the LEFT JOINS NOW and worrying about code bloat like or competitor VB. I don't think doing another one will make him happy.

Hmm... I have over 600 groups with no issues I will dig out the alterations that I made. As long as memebers do not belong to all groups, you should be fine - I certainly have not had any issues to date. The majority of my members will belong to no more than 5 groups at any one time.

Cool, that sounds like what I need. I appreciate you documenting what it takes to do it.

Okay - the potential problems are when you assign permissions to a particular board for reading, writing & reply permissions - if you have too many groups with permissions set, then you will go over the 255 character limit - each group has an extra '-' after the digit, to add to the length.

The way I use groups, is to enable additional features & links - so as far as permissions are concerened, I just user the basic 4 groups (admin, mod, user & guests), with perhaps one or two others, well within the limits set.

Okay - usual disclaimers apply - I cannot be held responsible if your forums die, or Elvis comes knocking on your front door etc...


In admin/docreategroup.php find this

-----------------------------------------
Make sure we don't already have 99 groups
$query = "
SELECT COUNT(*)
FROM {$config['tbprefix']}Groups
";
$sth = $dbh -> do_query($query);
list($num) = $dbh -> fetch_array($sth);
$dbh -> finish_sth($sth);

if ($num == "99") {
$html -> not_right("{$ubbt_lang['MAX_GROUP']}",$Cat);
}

and change it to...


// -----------------------------------------
// Make sure we don't already have 99 groups
// $query = "
// SELECT COUNT(*)
// FROM {$config['tbprefix']}Groups
// ";
// $sth = $dbh -> do_query($query);
// list($num) = $dbh -> fetch_array($sth);
// $dbh -> finish_sth($sth);
//
// if ($num == "99") {
// $html -> not_right("{$ubbt_lang['MAX_GROUP']}",$Cat);
// }

That is it - if you want to see how it works on my site go to http://www.nonleague.com register, select a team from the Ryman Premier League - go to Change Display settings under My Home and select another team in the Ryman Premier League, and see how the navigation above, and the side bar alters. (Only the Ryman Premier League is fully using the system at the moment.)

As I say, it may or may not work for you depending upon how you need to use groups.

I should also mention that my groups are not sequential - my numbering system goes up to over 5300, due to my database diving