 |
 |
 |
 |
Registered: 07/18/07
Posts: 17
|
|
|
 |
 |
 |
 |
|
 |
 |
 |
 |
|
Express Hosting
"We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#140284 - 11/08/04 04:40 PM
Re: so if this is the last ubbt, where with the suggestions?
|
journeyman
|
Registered: 06/05/06
Posts: 58
|
|
Quote:
Medar, out of personal curiosity, how does your member management system work? Do you let Threads be the master of the database, or does your system act as the master and synch against w3t_Users?
Hi Charles, just saw this (I am a once or twice a week'er over here).
Our forums are the central communication hub for our entire website, so I have built everything around the w3t_Users and w3t_Groups tables. Basically I admin a gaming group that plays various online games under various names, and many need various accesses. I am a HUGE fan of using U_Number and U_Group in queries to integrate Private Messages on all of our web pages, control accesses to certain web pages, and control access to the entire admin area.
I have a number of extra tables in a separate MySQL database, the main being an "SSB_Members" table that has a Mem_ForumId record - you can guess what that is - it is the U_Number record from w3t_Users. Every access is built around what Mem_ForumId = U_Number and what U_Groups they belong in.
This allows me to control the following:
1. Different members control different "rosters" of members in games. 2. Certain members have control over all rosters and expanded functions 3. A few members have access to grant accesses (add people to groups external from UBB.threads), which automatically gives them access to certain forums, and certain web adminsitration controls.
A quick example would be = http://www.bladekeep.com/admin/. That should look real familiar, heheh, and when logged in with proper access, it even feeds off the proper stylesheet by authenticating the U_StyleSheet.
Another example everyone that is a "member" can see http://www.bladekeep.com/teamspeak.php, as the members are part of group #8. If they are not logged in, or are not a part of that group, they get the not allowed message.
One last little cool thing I use is http://www.bladekeep.com/apply.php - this actually posts into a forum that the registered user cannot see, but it allows us to receive an application as a "new post" in a private forum, and we can discuss from there.
Why did I do all this silliness? I became tired of trying to get all the different game rosters (with members having multiple characters) correct, and it became too much for one or two people to handle. So by giving people access to Admin Roster and Application controls via UBB.threads Group controls, it allows me to dynamically spit out various rosters and provide various controls to our members.
All the below feeds or is connected to the w3t_Users table via various other tables.
http://www.bladekeep.com/highcouncil.php http://www.bladekeep.com/roster.php http://www.bladekeep.com/daoc/roster-rank.php http://www.bladekeep.com/swg/roster-swg.php http://www.bladekeep.com/wow/roster-wow.php http://www.bladekeep.com/eq2/roster-eq2.php
Sorry, went on a tangent, but love tinkering with this stuff.
|
|
Top
|
|
|
|
|
 |
 |
 |
 |
|
|