Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 3 of 3
  1. #1
    WDF Staff Wired's Avatar
    Join Date
    Apr 2003
    Posts
    7,656
    Member #
    1234
    Liked
    137 times
    Ok, I'm working on a project where there will be 3 or 4 basic levels of users: reader level, selective area moderators / editors, project wide moderators, and of course, Greyskull level.

    What's the best way to set up this arrangement and to integrate it with a database of entries? The selective area moderators will need their permissions based on a single value that is part of each possible database entry.
    The Rules
    Was another WDF member's post helpful? Click the like button below the post.

    Admin at houseofhelp.com

  2.  

  3. #2
    Senior Member Brak's Avatar
    Join Date
    Apr 2003
    Location
    San Francisco, CA
    Posts
    3,413
    Member #
    1217
    Liked
    2 times
    For the table containing users, add a level colomn, preferably interger. Then make a separate table full of permissions for each level of user. This way you can have unlimited(for all intesive purposes) levels of users, each with separate, unique privelegves.
    Kyle Neath: Rockstar extraordinare
    The blog | The poetry site | The Spore site

  4. #3
    Senior Member seanmiller's Avatar
    Join Date
    Sep 2003
    Location
    Glastonbury, UK
    Posts
    868
    Member #
    3263
    Liked
    1 times
    If I read you correctly, I think you want to be able to grant individuals access to edit individual areas?

    In which case, you need to set up an area/content/user relationship...

    ie.
    -an "area" table containing unique references for each of the areas of the site
    -each content page (or section) should be assigned to an area
    - a "users" table containg your users
    - a "user_areas" table which is an intersection entity between users and areas. hence, an individual user can edit multiple areas, and an area can have multiple editors.

    Sean


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 03:55 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com