Difference between membergroup and memberGroup?

[bully]

so, in the table yabbse_members, there is a column "memberGroup", and in the table yabbse_membergroups there is a column "membergroup" which saves the different groups and the different names I can even change in the forums settings.

- What is the difference of those two columns, and where is the connection?
- And why is this splitting up necessary?
- Why not just use membergroup as foreign key in yabbse_members, just storing the GROUP_ID there?
- Where are the standard names for the membergroups stored?

Thx for the help

[Spaceman-Spiff]

- What is the difference of those two columns, and where is the connection?
- And why is this splitting up necessary?
- Where are the standard names for the membergroups stored?

the difference is, in members table, an admin will always show as: 'Administrator', and gmod as 'Global Moderator'
these are used for validating permissions in the code
the ones stored in membergroups table is for the name display, like if u change the admin rank title into 'Super Admin' to display in the post display, profile, etc

- Why not just use membergroup as foreign key in yabbse_members, just storing the GROUP_ID there?

i agree with this solution, its better, but a lot of changes will have to be made in the code
u'll probably get this in YSE 2

[bully]

Ok, I already thought of sth. like that, but are these two tables interconnected in any way?

They have to be somehow, because the new added Membergroups have to be transferred into the members profile.
Or is the membergroups just used to setup the drop down menu for membergroup in membersettings, which then is delivered as a variable into the membersprofile?
So there actually is no connection of those two tables in sql?

[[Unknown]]

Yes that's all it's used for.

yabbse_members now uses ID_GROUP in my secret project, by the way.

-[Unknown]