change the databasedesign

[Mas*Mind]

I've noticed that the databasedesign is very inefficient...For example the usertable: Every time you make a new usergroup the user is added again with all his info...this creates alot of overhead. You can better make a foreignkeytable like this:

-------------------
USER
---+------+--------
ID | Name | etc...
---+------+--------

-------------------
USER_GROUP
-------+-----------
UserID | GroupID
-------+-----------

-------------------
GROUP
---+------+--------
ID | Name | etc...
---+------+--------

This way you only have one record per user maximum and the relationships between groups and users are stored in the USER_GROUP table...

I also couldn't login anymore into the control-panel because I made myself a moderator while I was also an administrator...somehow the script 'thought' I was logging in as a moderator...

[James]

I believe John is planning to totally optimise the database structure in a future major version later on this year - it's certainly quite high on his todo list :)

James

[Mas*Mind]

I said nothing :D

[SonnetCelestial]

*gapes* :eek:

Okay... I'm glad i heard that because I was about to engage in a super hack... This would definitely change a lot of what I would do!!

[WildWayz]

Mas*Mind - there is a file in the zip in the extras folder called something line admin.php.
That recovers the admin in such an event (I think)

--James