1
mjz55
Is there a max of user groups?
  • 2007/5/29 13:03

  • mjz55

  • Quite a regular

  • Posts: 298

  • Since: 2007/1/18


Is there a maximum amount of user groups that XOOPS will allow?

2
tom
Re: Is there a max of user groups?
  • 2007/5/29 17:07

  • tom

  • Friend of XOOPS

  • Posts: 1359

  • Since: 2002/9/21


I believe the only restraints you have is that set by your server/hosting spec.

I have one site with tons of groups, I have different level admins, and different level subscriptions.

So the short answer I believe is no, there are no maximum ammounts of user groups.
Kind Regards.
Tom

http://bassmanthemes.com
http://www.xoopslance.com

3
gediminasbyt
Re: Is there a max of user groups?

EDITED:
Simple look at MySQL shows:
explain dbname_groups;
+-------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------------+------+-----+---------+----------------+
| groupid | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(50) | NO | | | |
| description | text | NO | | | |
| group_type | varchar(10) | NO | MUL | | |
+-------------+----------------------+------+-----+---------+----------------+

Group ID is a smallint, the number range is -32768 32767. However it's unsigned therefore the shift is done from negative numbers towards positive side. Therefore without problems you can have at least 65535 groups.

I can't imagine having that many groups.

Login

Who's Online

232 user(s) are online (164 user(s) are browsing Support Forums)


Members: 0


Guests: 232


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits