UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support I need to add more groups

How do I increase the number of groups. We have been making two groups per fourm, one moderator and one for members Now I get a message. That I cannot have more than 99 How can I get around this

Thanks

Hrm.. that could be tough. The biggest issue is the size abilities of the U_Groups field in the users table.

Groups are stored like this '-1-2-3-4-5-6-' etc.... so there would be a finite number of groups that a user could be assigned to. Likewise in the Board table, if you needed to excede the field size, you'd have to alter the field types in the database, so that they wouldn't get truncated.

As long as you are careful you should have no problems - although I am not using them at the moment - I have run with 700+ groups in the past. <img src="https://www.ubbcentral.com/boards/images/graemlins/laugh.gif" alt="" />

But as Josh says - there is a limit to the number of groups that somone can belong to. (I think the field limit is 255 - so 125 would be the maximum)

I can't remember the check you need to take out - but if you have a method for searching the code look for 99 and you will soon find it.

When I find the code, I will post it.

In docreategroup.php

Why for god's sake would you need 700+ groups?!

I use a tool called webmin. This tool allows me to access the database and I have been able to add more rows for groups. I moved it up 50 more rows and it allowed me to created more groups. I hope this does not create anymore problems but it seems to work.
Table w3t_Groups in database, then just add rows

Greg

[]
But as Josh says - there is a limit to the number of groups that somone can belong to. (I think the field limit is 255 - so 125 would be the maximum)
[/]
I think, if I've figurd this right - if it's a varchar 255 field, then you could hold about 85 groups per user.

Figure most of the groups are double digits, then the dash. Because each group is listed in the U_Groups or Bo_Read fields like -10-11-15-18-20- So each group added uses 3 characters.

You could increase the field size, but there's a lot of searching by groups in those fields, so not sure if that would affect efficiency or not.

As the last resort you can change the field type to TEXT. That will allow you a great deal of groups to be stored but it will come at a price. You will need to change the index to that field to a FULLTEXT one and then modify the .threads code in every area that this field is queried to comply with the FullText searches of MySQL. It is quite a task but if you must, I see no other alternative.

He shouldn't need to do this.

Unless a user belongs to over 85 groups (thanks Josh my maths was way out!) at any one time, then the issue will not apply.

When I was using 700+ groups a member only belonged to 4 or 5 groups at the most at any one time.

So the U_Groups was never over-used.


Anno - I had one group for each football club in the UK - and depending upon their club their side and top navigations varied for each member.